We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Smart makers FieldName has dot


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";


        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


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

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

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

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


Thanks a lot, It’s fixed.

You are welcome.