Smart makers FieldName has dot

Aspose.Cells Product Family
1

Hi,

I was use Aspose.Cells 20.1.0,
this is sample code,
when then FieldName has dot like &=[TEST].[TAG_TAG1.00], it’s not working.

        var workBook = new Workbook(FileFormatType.Excel97To2003);
        var sheet = workBook.Worksheets[0];

        var dt = new DataTable("TEST");
        dt.Columns.Add("TAG_TAG1.00", typeof(string));
        dt.Columns.Add("TAG_TAG2.00", typeof(string));

        for (int i = 0; i < 10; i++)
        {
            var dr = dt.NewRow();
            foreach (DataColumn item in dt.Columns)
            {
                dr[item.ColumnName] = "1000";
            }

            dt.Rows.Add(dr);
        }

        for (int i = 0; i < dt.Columns.Count; i++)
        {
            DataColumn item = dt.Columns[i];
            sheet.Cells[0, i].PutValue($"&=[{dt.TableName}].[{item.ColumnName}](copystyle)");
        }

        WorkbookDesigner designer = new WorkbookDesigner
        {
            Workbook = workBook
        };

        designer.SetDataSource(dt);
        designer.Process();

        workBook.Save(Utility.GetOutputFilePath(TestingPath, "TestSpecialTag1.xls"));`
2

@Jun_Lin,
We have logged the issue as “CELLSNET-47477” in our database for investigations. Once, we will have some news for you, we will update you in this topic.

1 Like
3

@Jun_Lin,
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-47477”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

1 Like
4

@Jun_Lin,
The issues you have found earlier (filed as CELLSNET-47477) have been fixed in Aspose.Cells for .NET v20.7. This message was posted using Bugs notification tool by ahsaniqbalsidiqui

5

@ahsaniqbalsidiqui,

Thanks a lot, It’s fixed.

6

@Jun_Lin,
You are welcome.