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
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.
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