Hi!
There is a problem with using “group:merge” smart marker ( Aspose.Cell 4.8.0) if text in the cell contains dot character:
Code:
DataTable dt = new DataTable("Rows");
dt.Columns.Add(new DataColumn("field1", typeof(string)));
dt.Columns.Add(new DataColumn("field2", typeof(float)));
dt.Columns.Add(new DataColumn("field3", typeof(string)));
DataRow dr = dt.NewRow();
dr["field1"] = "test";
dr["field2"] = 69.03;
dr["field3"] = "553.45.00";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["field1"] = "test";
dr["field2"] = 460.02;
dr["field3"] = "560.11.00";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["field1"] = "test";
dr["field2"] = 460.02;
dr["field3"] = "553.45";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["field1"] = "test1";
dr["field2"] = 4600.05;
dr["field3"] = "560.11.01";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["field1"] = "test1";
dr["field2"] = 474.58;
dr["field3"] = "560.11.02";
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 strings without dots - OK
designer.Workbook.Open(@"MergeApplied.xls");
designer.SetDataSource(dt);
designer.Process(true);
designer.Save(@"MergeAppliedOut.xls", FileFormatType.Default);
//Merging strings with dots - ERROR !!!
designer.Workbook.Open(@"Merge.xls");
designer.SetDataSource(dt);
designer.Process(true);//Generate exception
designer.Save(@"MergeOut.xls", FileFormatType.Default);
Templates in attachment
Thanks, Evgeny