As per our requirement we need to read the FitToPages and FitToPagesTall values from the template file and set them to the output sheet, while doing so we are always getting the values as 1 even if the template is showing "Automatic", I am finding this as a weird behaviour .
I have created a new workbook through Aspose from an application, it comes up with a sheet say " sheet1", if I retrieve the values of FitToPagesTall and FitToPagesWide for this worksheet "sheet1" using sheet1.PageSetup.FitToPagesWide and sheet1.PageSetup.FitToPagesTall they are displayed as 1 for both of them, now I am saving the workbook on to the disk using Save method and then when I open the workbook using Excel the values displayed for both FitToPagesTall and FitToPagesWide on the "PageSetup" tab of the excel are "Automatic", shouldn't it be 1?
Similar is the behaviour when I create a workbook using Microsoftexcel and save it to disk, now if we open the workbook through aspose, the properties FitToPagesTall and FitToPagesWide are having 1, while the worksheet on the disk is having "Automatic".
Once if we change the values of any one property say FitToPagesWide to 1, save the file to disk and then check the other values through the aspose application then it is getting displayed 0 for FitToPagesTall.
Is this the expected behaviour or am I missing any thing?
Thanks & Regards,