Created attachment 116947 [details] Repro.ods When the "Excel A1" formula and the worksheets name is "single-byte number + Japanese", we can not correctly reference the cell. As a result of a reference to the cell, "# NAME?" error occurs. This problem occurs only in the "single-byte number + Japanese". It does not occur in the case of "single-byte + Japanese" and "Japanese + single-byte number", "Japanese only". Step 1:Start the LibreOffice 2:Change the sheet name "Sheet1" to "4月" 3:Add "Sheet2" 4:Select the cell A1 of "Sheet2" and enter the "=" 5:Click on the B1 cell of "4月" sheet 6:Press the Enter key 7:A1 cell of "Sheet2" is displayed as "#NAME?" Workaround Change "single-byte number + Japanese" to "double-byte number + Japanese" In the case of "single-byte number + Japanese" in Excel A1 environment, please to be able to correctly sheet reference. Best Regards.
Created attachment 116948 [details] Repro.ods
Confirmed. I'll lower severity a bit, as workaround exists. Win 7 Pro 64-bit, Version: 4.4.4.3 Build ID: 2c39ebcf046445232b798108aa8a7e7d89552ea8 Locale: fi_FI Version: 5.1.0.0.alpha1+ (x64) Build ID: 3a6ec53eeeec71312f5ea890689f9c2ee79c2aac TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-07-01_02:24:40 Locale: fi-FI (fi_FI)
"4月" means "April" in English. In Japan, it is often to use the month to the sheet name. And, basically,we are using a single-byte numbers. This issue is an unavoidable issue in the Japanese environment. Please support by increasing the priority. Best Regards.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=2fd3560e0815b547ada7d7f6557857fe3c8678ba Resolves: tdf#92448 check for numeric '.' only if sheet separator is '.' It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Actually not restricted to Digit + Japanese but in Excel reference syntax notation any sheet name starting with an ASCII digit. Note that it can be temporarily worked around during input by enclosing the sheet name in single quotes, e.g. ='4月'!B1 Pending review https://gerrit.libreoffice.org/17244 for 5-0 https://gerrit.libreoffice.org/17245 for 4-4
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=21be4e095056800fc8869868448e005728d1bb65&h=libreoffice-5-0 Resolves: tdf#92448 check for numeric '.' only if sheet separator is '.' It will be available in 5.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3d2c83982dac10bcc7f73d87134a20aec945fbc5&h=libreoffice-4-4 Resolves: tdf#92448 check for numeric '.' only if sheet separator is '.' It will be available in 4.4.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.