Hi,
I am using aspose cells V 4.9
I need to set few cells properties for excel file.
After setting up cells properties, if i see print preview in Microsoft Office Professional Plus 2007, i am not able to see complete data.
Herewith i have attached sample native excel file and aspose normalized excel file (you should save this file and see print preview using Microsoft Office Professional Plus 2007).
Code snippet:
Dim oExcelBook As Workbook = New Workbook
oExcelBook.Open(strOutPath)
For inti = 0 To oExcelBook.Worksheets.Count - 1
Dim oExcelSheet As Worksheet = oExcelBook.Worksheets(inti)
oExcelSheet.PageSetup.Orientation = PageOrientationType.Landscape
oExcelSheet.PageSetup.Zoom = 100
Next
oExcelBook.Save(strOutPath)
Native file: 2017400000074.xls
Normalized file: 2017400000074.nor.xls
Note: The normalized file is working fine (can see print preview properly) in Microsoft Office Ultimate 2007.
The issue is only with setting up cells properties and viewing print preview in Microsoft Office Professional Plus 2007.
Regards,
Karthik