Conversion API ignores spreadsheetLayout and omits header/footer in XLSX -> PDF

Docs API
, ,
1

Because there is no Print API, I’m using the Conversion API to export XLSX to PDF. The export mostly works, but I’m seeing two issues:

  • The spreadsheetLayout parameters in the request appear to be ignored. Orientation, scaling, margins, and page size are taken from the workbook’s Page Setup instead.
  • I can’t force the export to print the worksheet header and footer, even though they are defined in the spreadsheet.

Could you confirm whether spreadsheetLayout is supported for XLSX → PDF and how to enable printing of headers/footers?

Payload used:

{
  "filetype": "xlsx",
  "key": "<key>",
  "outputtype": "pdf",
  "region": "cs-CZ",
  "spreadsheetLayout": {
    "ignorePrintArea": false,
    "orientation": "portrait",
    "scale": 100,
    "pageSize": { "width": "210mm", "height": "297mm" },
    "margins": { "top": "15.2mm", "bottom": "15.2mm", "left": "10.2mm", "right": "10.2mm" }
  },
  "title": "test.pdf",
  "url": "<my url>"
}
2

Hello @mozko

What version of Document Server is being used in your tests? Also, is it possible to share a sample file that produces described behavior?