Page Layout / Size

[CareAll]

Hello,

In my source xlsx file on the 'Page Layout' tab the 'Size' property is set to A3, but after saving the output file it is changed to A4.
Please investigate this issue.
Thank you

Tamas

[CareAll]

As far as I can see, XLS.Sheets.Xc12Sheet.PageSetup.PaperSize always returns psA4.

[larsa]

Hello

Use: XLS[0].PrintSettings.PaperSize := psLegal;

[CareAll]

Hello Lars,

The problem is the XLS.Sheets[0].Xc12Sheet.PageSetup.PaperSize doesn't contain the right value after reading the file.
It should be the value from the \xl\worksheets\sheet1.xml:

Code: Select all

<pageSetup paperSize="8" orientation="portrait" r:id="rId452"/>

As you can see, paperSize is 8 (psA3) in this example, but when I open the file, the XLS.Sheets[0].Xc12Sheet.PageSetup.PaperSize has the value of 9 (psA4).

[larsa]

Hello

OK, I understand now. This will be fixed in the next update.

[CareAll]

Thanks in advance.