Hi!
There is a problem with using “group:merge” smart marker ( Aspose.Cell 4.8.0) :
Code:
DataTable dt = new DataTable("Rows");
dt.Columns.Add(new DataColumn("field1", typeof(string)));
dt.Columns.Add(new DataColumn("field2", typeof(float)));
DataRow dr = dt.NewRow();
dr["field1"] = "test";
dr["field2"] = 69.03;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["field1"] = "test";
dr["field2"] = 460.02;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["field1"] = "test";
dr["field2"] = 460.02;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["field1"] = "test1";
dr["field2"] = 4600.05;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["field1"] = "test1";
dr["field2"] = 474.58;
dt.Rows.Add(dr);
WorkbookDesigner designer = new WorkbookDesigner();
//Non merged - OK
designer.Workbook.Open(@"..\..\NonMerge.xls");
designer.SetDataSource(dt);
designer.Process(true);
designer.Save(@"..\..\NonMergeOut.xls", FileFormatType.Default);
//Merged - ERROR !!!
//Content of Cell (B7=”field2”) is disappeared
designer.Workbook.Open(@"..\..\MergeFormat.xls");
designer.SetDataSource(dt);
designer.Process(true);
designer.Save(@"..\..\MergeFormatOut.xls", FileFormatType.Default);
Templates in attachment
Thanks, Evgeny