We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

PageSetup.Zoom property always shows 100

Hi,


The PageSetup.Zoom property of the chart and worksheet objects shows 100 no matter what the value of zoom is in the actual workbook.

Workbook workbook = new Workbook(“test.xls”);
Console.WriteLine(workbook.Worksheets[0].PageSetup.Zoom);
Console.Read();

Output: 100 (even when the zoom is set to 120%)

Could you please explain if i am missing something or is this a bug?

Thanks

Hi Yashali,


Thank you for contacting Aspose support.

We have evaluated your presented scenario while using the latest version of Aspose.Cells for .NET 8.3.1.1, and we are able to observe the problem of Zoom value. In your provided spreadsheet, the Zoom is set to 120% whereas if read through Aspose.Cells for .NET API, the value returns to be 100. We have logged the problem in our bug tracking system under the ticket CELLSNET-43258 for further investigation. Please spare us little time to properly analyze the scenario on our end. In the meanwhile, we will keep you posted with updates in this regard.

We are sorry for your inconvenience.

Hi Yashali,


Thank you for your patience.

Please use the Worksheet.Zoom property to get the zoom factor set for a given worksheet. Please check the following piece of code on your side.

C#

Workbook workbook = new Workbook(“D:/temp/test.xls”);
Console.WriteLine(workbook.Worksheets[0].Zoom);

Hi,

Thanks, that helped!

Hi Yashali,


It is good to know that you are up & running again. Please feel free to contact us back in case you need our further assistance with Aspose APIs.