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

Free Support Forum - aspose.com

Local range name property FullText is not escaped if parent worksheet has an apostrophe

If a name is local to a worksheet and that worksheet had an apostrophe, the fulltext property is not escaping the apostrophe.

Excel example:
Dim wb As Workbook
Dim n As Name

Set wb = ActiveWorkbook
Set n = wb.Names(1)

Result:
ExcelFullText.png (11.9 KB)

Aspose:
var workbook = new Workbook(“aspose.xlsx”);
var name = workbook.Worksheets.Names[0];
var fullText = name.FullText;
Result:
AsposeFullText.png (10.5 KB)

PFA sample workbook.
aspose.zip (6.1 KB)

Thanks,
Dean

@Moonglum,

Please notice, I am able to reproduce the issue as you mentioned by using your template file. I found that local range name property FullText is not escaped if parent worksheet has an apostrophe. I have logged a ticket with an id “CELLSNET-50055” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

@Moonglum,

This is to inform you that your issue has bee resolved. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

@Moonglum
Please try our latest version/fix:
Aspose.Cells21.12.4 For .Net2_AuthenticodeSigned(1).Zip (5.6 MB)
Aspose.Cells21.12.4 For .Net4.0.Zip (5.6 MB)
Aspose.Cells21.12.4 For .NetStandard20.Zip (5.6 MB)

The issues you have found earlier (filed as CELLSNET-50055) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao