Using the 19.4 last version of Aspose.Cells, I have created a small .net program that open a Workbook and save it as pdf.
var strFileName = “test.pdf”;
var AWB = new Aspose.Cells.Workbook(strFileName.Remove(strFileName.Length - 4) + “.xlsx”);
In the workbook I have 2 sheets. I have setup the pages in Excel :
- first page number: 0
- custom footer: &[Page]
- different first page: checked
When i save as pdf I have the folowing result, different from what i get in the Excel print preview for the entire workbook:
- “Page 0” is visible but I was expecting not visible
- “Page 1” is not visible, I was expecting visible (then pages 2,3,4 are visible again)
- the page count does not restart to 0 for each worksheet and I was expecting it to restart
Please find attached the test workbook.
test.zip (9.9 KB)
Do you have any idea of how to fix that or a workaround ?
I was thinking of exporting each sheet separately as pdf then merge them, but it is quite heavy… and the 1st page is still visible while the 2nd one is not.
Than you in advance.