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 ?
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.
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.