Can sheet name contain the characters '.', '-' ?
(I mean using this sheet names in formulas.)
When I load Excel workbooks with sheet names like '1.Table-A' that used in formulas then fpspreadsheet can load and refresh the values when the referenced cell changed.
But when I try to create formulas with this sheetnames i.e. "=1.Table-A!A2" or "='1.Table'-A!A2" then I get exception:
"Unpected Chrakter Like .". Even with Spready app.
Is this bug or are such table names not allowed in formulas?
I added example worksheet, in list-sheet the columns C,E,F are links to other sheets.
Edit:
You can also not use sheets that contains '_'-charakter in their names in formulas. You can't use it as first charakter.
Edit2:
There must be a bug. You can not use names when first char is nummer in formulas like "1Sheet".
In other Spreedsheet-applications you can put the name in '' like
"='1Sheet'!A1"