Problem with using group:merge smart marker

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

Hi,

Thanks for providing us the template files with sample code.

After an initial test, we found the issue. We found some string data (having dots) are converted to invalid values (it seems it tries to convert those values to date time values). We will figure it out soon. Your issue has been logged into our issue tracking system with an issue id: CELLSNET-11753.

Thank you.

Hi,

Thank you for considering Aspose.

Please try the attached latest version. We have fixed your mentioned issue.

Thank You & Best Regards,

Hi!


Thanks, it worked


Regards, Evgeny