If a name is local to a worksheet and that worksheet had an apostrophe, the fulltext property is not escaping the apostrophe.
Dim wb As Workbook
Dim n As Name
Set wb = ActiveWorkbook Set n = wb.Names(1)
ExcelFullText.png (11.9 KB)
var workbook = new Workbook(“aspose.xlsx”);
var name = workbook.Worksheets.Names;
var fullText = name.FullText;
AsposeFullText.png (10.5 KB)
PFA sample workbook.
aspose.zip (6.1 KB)