Issue 125076 - Unexpected localization of boolean values
Summary: Unexpected localization of boolean values
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.1.0
Hardware: All Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-06-09 13:57 UTC by Mark Hung
Modified: 2017-05-20 11:55 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Unexpected Chinese (ZH_TW) localization of boolean values (25.13 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-06-09 13:58 UTC, Mark Hung
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Mark Hung 2014-06-09 13:57:28 UTC
This issue were found in 4.1.0 with ZH_TW locale.

While checking why 4th parameter (i.e. sort order ) of vlookup() does not accept true or false ( issue originally found in 4.0.1 (ZH_TW)) , I found that I have to use 真 or 假 to make it work. ( For people who don't read Chinese, they are true and false translated to Chinese respectively. )

Generally people don't expect literal in programming language translated. And it makes a critical issue for script compatibility.

I've made a illustration file in attachment.
Comment 1 Mark Hung 2014-06-09 13:58:28 UTC
Created attachment 83535 [details]
Unexpected Chinese (ZH_TW) localization of boolean values
Comment 2 Mark Hung 2014-06-09 14:04:16 UTC
On the other hand, Chinese (ZH_TW) help file about vlookup() explicitly state that "請輸入布林值 FALSE 或零" (i.e. , use either False or 0) and makes the description inconsistent.
Comment 3 Mark Hung 2014-06-09 22:21:10 UTC
Change the component.