I was testing Aspose.Cells latest 188.8.131.52 with a future product but encountered an issue when charts are on their own sheet - see the attached basic work book I created to show what looks like to be a bug.
Use this code:
Workbook obstacleWorkbook = new Workbook(“testBook.xlsm”);
Basically the act of saving the workbook again (or loading it in in the first place) seems to resize the chart area, making it way too wide.
I also tried manually correcting the chart area size but when you save out it decides to make it bigger than the page again.
So to see issue:
1. Look at testbook - chart fits nicely on page
2. Run the workbook through Aspose.Cells
3. Open new saved workbook, chart has been resized for no reason?
Thanks for your posting and using Aspose.Cells.
Please download and try the latest version: Aspose.Cells
for .NET v184.108.40.206. It works fine. We have attached the output file for your reference.
The output file your attached is still wrong,
see attached screenshots of before and after.
Thanks for providing us the screen shots.
After an initial test, I can notice the issue as you have mentioned.The chart is moved or resized after re-saving the file. I have logged a ticket with an id “CELLSNET-41691” for your issue. We will look into your issue to figure it out soon.
Could you please download and try this fix: Aspose.Cells for .NET v220.127.116.11 and let us know your feedback.
Your issue should be fixed in it.