Free Support Forum - aspose.com

Worksheet view

Dear,

Aspose.Cells offer the oportunity to save the worksheet view between two mode using the property (IsPageBreakPreview) :
- Normal View
- Page Break Preview

But in Excel, three modes are availables. The two above are managed with Aspose and another one which is "PageSetup" only in Excel.

Is there any property or function that allow us to specify the worksheet view to "PageSetup" (PageSetup.jpg in attachment) ?

Many thanks in advance for your answer.

Hi,

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

Thank you for considering Aspose.

Well, I am afraid; your requested feature is not supported at the moment. We have added the feature in our internal issue tracking system with issue id CELLSNET-14833. We will look into the feasibility of this feature and get back to you soon.

Thank You & Best Regards,

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

Please try the following code to set the Worksheet view to PageLayoutView.

Workbook book = new Workbook();

book.Worksheets[0].ViewType = ViewType.PageLayoutView;

book.Save("C:\\PageLayout_out.xlsx");

Thank You & Best Regards,

Hi,

Thanks for the answer. Could you please say me from which version of the library this option is available ?

Best regards

Hi,

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

This feature was supported in Aspose.Cells V4.8.0.14. You may download the attached version and try as per your need.

Thank You & Best Regards,