Formulas with references to sheet names with underscore
Original Reporter info from Mantis: MAndreato @mandreato
-
Reporter name:
Original Reporter info from Mantis: MAndreato @mandreato
- Reporter name:
Description:
Formulas with references to sheet names with underscore are well managed on a TsWorksheetGrid but not if TsWorkbookSource is used.
Steps to reproduce:
Create an Excel (XLSX) document and fill in the following cells of the Sheet1:
- A1: "a"
- B1: "b"
Rename Sheet1 as "a_b" (without quotes).
Add a new sheet and fill its A1 with the formula: =TEXTJOIN(",";TRUE;a_b!A1:A2)
On Form1, drop a TsWorksheetGrid, set ReadFormulas to True and WorkbookSource.Filename to filename/path of the Excel document --> it is OK.
Add a TsWorkbookSource and connect sWorksheetGrid1.WorkbookSource to it, then set sWorkbookSource1.Filename to the document --> Formula error in cell ... Unknown character at pos 1: "_"
Mantis conversion info:
- Mantis ID: 38762
- OS: Windows
- OS Build: 10
- Platform: x86-64