Free Support Forum - aspose.com

Having problem with PageSetup.FixToPages

Hi,

I’m using version 1.8.3.0 and having the problem of setting the page scaling.

my code as below:
sheet.PageSetup.FitToPagesTall = 1;
sheet.PageSetup.FitToPagesWide = 1;

The exported file will always take the default option (adjust to 100% normal size) and does not take effect of the scaling setting above.

Sorry, it’s a bug.

I have fixed it. You can get the next hotfix within a week. Now thanks for your patience.

Appears the problem listed above is fixed, however it is not clear on how to set the height to no value. This is a very common practice to set the page width to 1 and let the height be blank, which means it will automatically be calculated by Excel at print time. Manually I would go in and simply delete the Tall property. Does this capability exist? In theory I could specify a large number tall that should have no impact for smaller reports but have not tested that.

Thanks for your suggestion.

I will investigate to support this in object modal within one week. Now you can set it in your designer file and using Aspose.Excel to import it.

Now you can try this line of code:

sheet.PageSetup.FitToPagesTall = 0;

I want adjust 77% normal size to my excel sheet from the visual basic.
How can I do that? send me sample coding immediately

Best Regards
Jayantha

Hi,

You can try this:

Dim Excel as Aspose.Excel = new Excel()
Excel.Worksheets(0).PageSetup.Zoom = 77