Issue 125076 - Unexpected localization of boolean values
Summary: Unexpected localization of boolean values
Status: UNCONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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.