Bug Format XLSX with Smart Makers and Open Office

Hi,

I use aspose cells v7.0.1.0 and i test with open office 3.3 & libre office 3.5:
I use this code:
System.Data.DataTable dt = new System.Data.DataTable(“Table1”);
dt.Columns.Add(“iddoss”);
dt.Columns.Add(“lbdoss”);
System.Data.DataRow dr = dt.NewRow();
dr[“iddoss”] = “TITI”;
dr[“lbdoss”] = “TOTO”;
dt.Rows.Add(dr);

//Instantiating a WorkbookDesigner object
AsposeUtil.SetLicense();
Aspose.Cells.WorkbookDesigner designer = new Aspose.Cells.WorkbookDesigner();

//Open a designer spreadsheet containing smart markers
designer.Workbook = new Aspose.Cells.Workbook(templatePath);

//Set the data source for the designer spreadsheet
designer.SetDataSource(dt);

//Process the smart markers
designer.Process();

string filePath = Path.Combine(Path.GetTempPath(), “outputTest.xlsx”);
designer.Workbook.Save(@filePath);

when I open the result with open office, the merged cells do not appear, whereas with Excel 2010 display is correct!

How to explain this behavior? (not reproduce with xls or ods format, only xlsx)
To reproduce the problem I attached the offending file

thanks

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please also provide us your template file to look into this problem.

Please aslo try the latest version:
Aspose.Cells for .NET (Latest Version)
and let us know if it works fine.

Here my template

This bug is known ? Fixed by new version ?

Hi,

I have managed to find the issue in the output file as you have mentioned using your template file and sample code with v7.1.1.1. The issue can be only seen in the OpenOffice, e.g 3.2 or greater as I tested. The output file looks fine opening it into MS Excel 2007/2010 as you pointed out.

I have logged a ticket with an id: CELLSNET-40400. We will investigate and look into it soon.

Thank you.

thank you for your response!

Hi,

Please change your codes as the following:

C#


OoxmlSaveOptions saveOptions = new OoxmlSaveOptions();

saveOptions.ExportCellName = true;


designer.Workbook.Save(@“D:\FileTemp\dest.xlsx”, saveOptions);


@shakeel.faiz

Thanks but… with MS Office 2010 the document is not good !
: &=[Table1].[iddoss] (File attached)

I must be compatible for OpenOffice and MS Excel…

For now I use the XLS format, which poses no problem with Excel / OpenOffice

Hi,

I opened your file with Ms-Excel 2010, it is opening fine. Please see the screenshot below.

Are you getting problems in this file when you open it in OpenOffice?

Please provide me a screenshot highlighting the differences or the problems you are facing.


@shakeel.faiz

Indeed, I am sincerely sorry, I opened the wrong file!
It works!

Hi,

It’s good to know your issue is resolved now.

If you find any other problem or get any question, please feel free to ask, we will help you asap.