Free Support Forum - aspose.com

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:

<!–[if gte mso 10]>

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Обычная таблица"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-fareast-language:EN-US;}

<![endif]–>

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


<o:p></o:p>


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