Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Sharadhi
205
Worksheet page setup
posted

Hi,

I am using Infragistics Excel, I want to set up a worksheet page i.e Pageset up has to be done as we have Pagesetup option in Interop do we have any property in infragistics to set up page .

I want to set up below things,

Zoom
FitToPagesWide
FitToPagesTall

Please let me know this.

  • 44743
    posted

    The settings you need are on the Worksheet.PrintOptions and Worksheet.DisplayOptions:

    • Zoom - I'm not sure what you mean here. This could either be Worksheet.DisplayOptions.MagnificationInNormalView or Worksheet.PrintOptions.ScalingFactor.
      • Using the ScalingFactor requires that Worksheet.PrintOptions.ScalingType is set to UseScalingFactor.
    • FitToPagesWide - Worksheet.PrintOptions.MaxPagesHorizontally
      • This requires that Worksheet.PrintOptions.ScalingType is set to FitToPages.
    • FitToPagesTall - Worksheet.PrintOptions.MaxPagesVertically
      • This requires that Worksheet.PrintOptions.ScalingType is set to FitToPages.