https://bugs.documentfoundation.org/show_bug.cgi?id=170876
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |127300 Version|4.0.0.3 release |Inherited From OOo --- Comment #4 from ady <[email protected]> --- * LibreOffice 3.3.0.4: Worksheet name / label shown by Calc: sheet1 1 (please note it is all lower-case, and it adds an extra space and an extra number 1) _ Error: Err:504 (Error in parameter list, "IllegalParameter" ) In the formula, the imported sheet name is replaced by "#REF!" ; the cell addresses are shown correctly: $#REF!.$B$3:$B$4 Please note the presence of the initial "$", and the dot separator before the cell addresses. * LibreOffice 4.0.0.3 Same as LO 3.3.0.4, except that in the formula, the imported address is shown as: sheet1!$b$3:$b$4 Note that there is no replacement for "#REF!" this time, but there is also no conversion from "sheet1!" (with the "!" symbol, Excel's notation for worksheet name address) to Calc's notation "$sheet1." (with the initial "$" for absolute worksheet address and the dot as separator instead of the "!" symbol). The cell addresses are not in uppercase, so Calc is not correctly importing the original (full) address in Excel's notation format. Calc does not recognize the original as a valid address, and thus there is no conversion to Calc's notation. For some reason, the name / label of the worksheet is incorrectly imported by Calc, changing it by adding an extra " 1" (a space character and a one, the same as with LO 3.3). * LO Dev 26.8 (2026-02-16): In a recent LO Dev, the same as for LO 4.0 happens except that the worksheet name / label is not just with an extra " 1" (as it was in LO 3.3, which was also not correctly imported), but with an extra " -1" (space character, then hyphen-minus character, then a one): "sheet1 -1". The importing problem seems to be (at least partially) inherited (in name / label of the worksheet), but the current behavior (for incorrect importing of the worksheet name / label, and for the resulting incorrect behavior in the formula) is already slightly different than in LO 3.3. The problem is how Calc is importing the name / label of the worksheet (which, in addition, seems to be different than how it is parsed for the formula). Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=127300 [Bug 127300] [META] Issues with import/export/display of Excel built-in defined names -- You are receiving this mail because: You are the assignee for the bug.
