unicode worksheet names not being quoted in cross-sheet references #2045

New Issue

2020-07-03T21:09:19Z

wlawt commented

2020-07-03 21:09:19 +00:00

(Migrated from github.com)

How to reproduce this issue:

With a workbook that has 2 worksheets (i.e. Sheet1 and a-b)
Set A1 cell in a-b to 1
Go to Sheet1 and in A1 hit = and go to a-b and click on the A1 tab and enter
Save the workbook as NAME.xlsb and NAME.xlsx

Using npx:
npx xlsx --formulae test.xlsx "Sheet1" && npx xlsx --formulae test.xlsb "Sheet1"

Output:

Sheet1
A1='a-b'!A1
Sheet1
A1=a-b!A1

Other unicodes that reproduce the same result:
^ % # ٪ ☃️

Other unicodes that fail (return an error when doing npx):
!! $ !

Error messages:

For !!
npx xlsx --formulae test.xlsx "anpx xlsx --formulae test.xlsx "a^b" && npx xlsx --formulae test.xlsb "a^b"b" && npx xlsx --formulae test.xlsb "anpx xlsx --formulae test.xlsx "a^b" && npx xlsx --formulae test.xlsb "a^b"b" Sheet anpx xlsx --formulae test.xlsx a^b && npx xlsx --formulae test.xlsb a^bb cannot be found
For $
Sheet a cannot be found
For !
bash: !b: event not found

Test file:
See this test file

**How to reproduce this issue:** 1. With a workbook that has 2 worksheets (i.e. Sheet1 and a-b) 2. Set A1 cell in `a-b` to `1` 3. Go to `Sheet1` and in A1 hit `=` and go to `a-b` and click on the A1 tab and enter 4. Save the workbook as `NAME.xlsb` and `NAME.xlsx` Using `npx`: `npx xlsx --formulae test.xlsx "Sheet1" && npx xlsx --formulae test.xlsb "Sheet1"` **Output:** ``` Sheet1 A1='a-b'!A1 Sheet1 A1=a-b!A1 ``` **Other unicodes that reproduce the same result:** `^` `%` `#` `٪` `☃️` ` ` **Other unicodes that fail (return an error when doing `npx`):** `!!` `$` `!` Error messages: - For `!!` `npx xlsx --formulae test.xlsx "anpx xlsx --formulae test.xlsx "a^b" && npx xlsx --formulae test.xlsb "a^b"b" && npx xlsx --formulae test.xlsb "anpx xlsx --formulae test.xlsx "a^b" && npx xlsx --formulae test.xlsb "a^b"b" Sheet anpx xlsx --formulae test.xlsx a^b && npx xlsx --formulae test.xlsb a^bb cannot be found` - For `$` `Sheet a cannot be found` - For `!` `bash: !b: event not found` **Test file:** See [this test file](https://github.com/SheetJS/test_files/blob/master/cross-sheet_formula_names.xlsb)

Sign in to join this conversation.