Chart's size is changed after convert from .xlsx to .xlsb

Aspose.Cells Product Family
1

Hi,
I have the sample (.xlsb) sample.zip (10.4 KB), after do the convert to .xlsx and then convert back to .xlsb, chart’s size is changed. The code:

//convert from .xlsb to .xlsx
var options = new Aspose.Cells.LoadOptions(LoadFormat.Xlsb);
using(var doc = new Workbook(<inputxlsbfile>, options))
doc.Save(outputXlsxFile, SaveFormat.Xlsx);
//convert from .xlsx back to .xlsb
var options2 = new Aspose.Cells.LoadOptions(LoadFormat.Xlsx);
using(var doc = new Workbook(outputXlsxFile, options2))
doc.Save(<outputxlsbfile>, SaveFormat.Xlsb);

I checked and see that when convert .xlsx to .xlsb, content of file: xl/chartsheets/sheet1.xml is changed causing chart’s size is changed.
I use the aspose.cell 20.6.
Please check and give me feedback.

Thank you very much.

2

@dunghnguyen,

Thanks for the sample file.

Please notice we were able to reproduce the issue as you mentioned by using your sample code and template file. We found chart’s size is changed (decreased) after converting back from XLSX to XLSB file format. We have logged a ticket with an id “CELLSNET-47459” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

@dunghnguyen,
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47459”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

I got it. Thank @ahsaniqbalsidiqui, @Amjad_Sahi for your prompt support.

5

@dunghnguyen,
You are welcome.

6

@dunghnguyen,

Please try our latest version/fix: Aspose.Cells for .NET v20.6.5 (attached):
Aspose.Cells20.6.5 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.6.5 For .Net4.0.Zip (5.4 MB)
Aspose.Cells20.6.5 For .NetStandard20.Zip (5.3 MB)

Your issue should be fixed in it.

Let us know your feedback.

7

Hi @Amjad_Sahi,
I’ve tested and it worked well.

Again, thank you very much for your support.

8

@dunghnguyen,

Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

9

@dunghnguyen,
The issues you have found earlier (filed as CELLSNET-47459) have been fixed in Aspose.Cells for .NET v20.7. This message was posted using Bugs notification tool by ahsaniqbalsidiqui