Zoom level changes after opening and rewriting Excel file

Aspose.Cells Product Family
1

If you use Aspose.Cells to simply open the attached workbook (one worksheet) and immediately save the file, the resulting workbook is zoomed to the maximum level.



I have some idea of why this is happening. The file was created by exporting an Access file to Excel, and if you look in the XML behind the file, the value for zoomScaleNormal for the worksheet is 467, and the value for zoomScaleSheetLayoutView is 429. I do not believe this is normal, and I suspect the client needs to fix some step in the process they use to export from Access to Excel, but they haven’t been able to figure that out yet.



Further, it looks like that when you rewrite the file, you add the property zoomScale to the worksheet and set it to 467, which causes it to actually display zoomed, rather than just having a couple of the default zooms overridden. Like I said, I’m trying to get the client to fix their process, but is it possible to have Aspose.Cells handle this situation better, maybe by not adding the property?



Thanks,

Michael Whalen

2

Hi,


Thanks for providing us template file with details.

After an initial test, I noticed the issue in the output file. But I guess the problem is with your template Excel file where zoom element(s) in the source .xml file is not correct. I think as a workaround to cope with your issue, you may try the following sample code to set the zoom level for worksheet(s) to 100.
e.g
Sample code:

var workbook = new Workbook(@“E:\test2\Sample.xlsx”);
foreach (Worksheet worksheet in workbook.Worksheets)
{
worksheet.Zoom = 100;
}
workbook.Save(@“E:\test2\out1.xlsx”);

Hope, this works for your needs.

Thank you.
3

That won’t work so well for our product, as it’ll reset the zoom level on any documents that are supposed to be zoomed.





We’re just trying to preserve the original properties as closely as possible while making whatever other changes to the document we need to, and in this case a property is being added that wasn’t there before, so I was hoping that could be fixed. Again, I think the initial process that creates the workbook needs some fixing, and is the main problem, but the zoomScale property is getting added during the save process when it wasn’t in the original document, and it seems like that could be fixed.

4

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue and fixed it. We will soon provide the fix after performing QA and including other enhancements and fixes. Once, the fix is available for you, we will let you know by posting in this thread.

5

The issues you have found earlier (filed as CELLSNET-44478) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.