Formatting lost when converting from .xls to .xlsx

[bungeemann]

I am trying to convert a .xls file to .xlsx but all of the formatting is lost during the conversion. Here is the code:

Code: Select all

Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
workbook.LoadFromStream(cdfStream);
workbook.SaveToFile(filePathName, ExcelVersion.Version2013);


It doesn't matter which ExcelVersion I choose. This is how the conversion looks:

screenshot.png (24.99 KiB) Viewed 936 times

The data is coming from a 3rd party database so that is why the code sample has the data loaded as a stream. It doesn't matter if I export to a file first, the same thing happens. Attached is the raw file from the database.

The 3rd party application hides the workbook so you have to click the View menu in Excel and click Unhide to view the data. The conversion automatically unhides the data which is perfectly fine.

Any help would be appreciated.

[Jane.Bai]

Hi,

Thank you for your inquiry.
I have reproduced the issue and logged it in our bug tracking system. Once it is fixed, I will let you know.
Sorry for the inconvenience caused!

Sincerely,
Jane
E-iceblue support team

[bungeemann]

Thank you. I'll be interested if this can be fixed.

[Betsy.jiang]

Hi,

Sorry that the issue is not resolved at present. And I got information from our Dev team that the issue is very complex and it would not be fixed in a short time. Anyway, we will inform you as soon as there is any good news.

Sincerely,
Betsy
E-iceblue support team