Opening Excel file created by Aspose.Cells by OpenOffice application

Aspose.Cells Product Family
1

Hi!

I’m developer in Cellebrite. I’m using your program for Excel file creation (Aspose.Cells). Our clients had a problem to open our report by OpenOffice application. Instead of the whole sheet the first column opens only. In Office Excel all of the content displays properly. Please, tell us - if is it possible to create an Excel report (.xlsx) by Aspose that can be viewed in OpenOffice?

Thanks.

2

Hi,


Can you please share your sample report with us, so that we can investigate it and assist you further?

Also, please let us know the Aspose.Cells version that you are using.

Thanks
3

Attached report was created by using trial latest version (for check purpose). But we are using older version in our releases (5.2) with the same problem.

4

Hi,


I was able to reproduce the issue that you have reported. I have logged it in our database and created a ticket with ID: CELLSNET-40660 against this issue. Our developers will look into it and we will update you as we get update on it.

Thank you for using Aspose.Cells and providing feedback.
5

Hi,


Please try the following code in your program and see if it solves your problem.

OoxmlSaveOptions saveOptions = new OoxmlSaveOptions(SaveFormat.Xlsx);
saveOptions.ExportCellName = true;
workbook.Save(fileName, saveOptions);

Let us know your feedback then.

Thanks
6

It works now! Thank you very much!

7

Hi,


You are welcome. Please feel free to contact us for any additional help if you require.

Thank you for using Aspose.Cells