Free Support Forum - aspose.com

Issue viewing print preview in

Aspose.Cells Product Family
#1

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
#2

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for sharing the files.

We will investigate your issue and get back to you soon. Your issue has been registered in our internal issue tracking system with issue id: CELLSNET-16018.

Thank You & Best Regards,

#3

Hi,

Please try the fix 4.9.0.3 (attached).

The issue regarding print preview is caused by the settings of the original file which are not initialized.

If you still have any problem, please feel free to contact us any time.

Thank you.