Page 1 of 1
Page Layout / Size
Posted: Tue Feb 11, 2014 5:11 pm
by 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
Re: Page Layout / Size
Posted: Wed Feb 12, 2014 9:23 am
by CareAll
As far as I can see, XLS.Sheets.Xc12Sheet.PageSetup.PaperSize always returns psA4.
Re: Page Layout / Size
Posted: Thu Feb 13, 2014 9:04 am
by larsa
Hello
Use: XLS[0].PrintSettings.PaperSize := psLegal;
Re: Page Layout / Size
Posted: Thu Feb 13, 2014 12:50 pm
by 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).
Re: Page Layout / Size
Posted: Fri Feb 14, 2014 9:36 am
by larsa
Hello
OK, I understand now. This will be fixed in the next update.
Re: Page Layout / Size
Posted: Fri Feb 14, 2014 12:15 pm
by CareAll
Thanks in advance.