https://bugs.documentfoundation.org/show_bug.cgi?id=92448
Bug ID: 92448
Summary: CALC: Excel A1 formula can not reference the cell by
worksheets names "single-byte number + Japanese"
Product: LibreOffice
Version: 4.4.4.3 rc
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 116947
--> https://bugs.documentfoundation.org/attachment.cgi?id=116947&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
