Free Support Forum -

PageZoom doesn't work

Firstly, I'm using the excel dll unregistered. I have tried setting my worksheet page zoom to 75% with the code

Excel excel = new Excel();
excel.Worksheets[0].PageSetup.Zoom = 75;
excel.Save("C:\\test.xls", FileFormatType.Default);

I put a watch on excel.Worksheets[0].PageSetup.Zoom, before the save it is 75, after the save it goes back to 100, and when I open the document (text.xls), there is 100% zoom on worksheet[0] (the first worksheet). I've have tried most other things (such as calcs etc) and they all work, its just this.

I am planning on registering the product, If this is only avaliable in registered product then thats fine, but I'd like to know.



PageSet.Zoom set the scaling factor in page setup. Please choose File->PageSetup, in “Scaling” option, you can see “Adjust to 75% normal size”.

If you want to adjust the scaling factor in MS Excel, please use Worksheet.Zoom property to set it.