We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Page setup settings only specifically in Spreadsheet (IWorksheet)

How to achieve a set of settings shown in the attachment?

The paper size was able to set successfully. But many settings were not available/ not known.
Also, looks like there is a difference in values set before margins in code and actual time printing.  ( Auto rounding: 0.76 to 0.8 and 1.94 to 1.9 )

Is it possible to set other settings provided in screenshot using IWorksheet?

3 Replies

VK Vinoth Kumar Sundara Moorthy Syncfusion Team August 23, 2019 12:19 PM UTC

Hi Vaibhav, 
Thank you for contacting Syncfusion support. 
We have checked your reported requirement and we would like to let you know that we have provided the print option (Margins, Orientation, PageSize) in Import/Export support. We can able to Export / Import the spreadsheet with the provided options available in our PaperSettings. For more details refer the below UG links, 
Could you please check the above details and get back to us, if you need any further assistance on this? 
Vinoth Kumar S 

VM Vaibhav More August 27, 2019 09:25 AM UTC

Thanks for the reply.

I am not making use Grid Spreadsheet.

Here, in the backend code excel sheet is generated manually using syncfusion functions and saved and downloaded.

There, I do not see more properties in Page setup. 
Property: IWorksheet.PageSetup

Please let me know if you need more information. 

AV Abirami Varadharajan Syncfusion Team August 28, 2019 01:54 PM UTC

Hi Vaibhav, 

Please refer to below API reference for setting this scaling option.  
Please refer to below documentation to know more about Page Setup setting.  


Live Chat Icon For mobile
Up arrow icon