https://bugs.freedesktop.org/show_bug.cgi?id=65671
Priority: medium
Bug ID: 65671
Assignee: [email protected]
Summary: Formulas expect arguments in Locale Language when
Formulas are set to English names
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
If a user selects the "Use English function names" (under Tools> Options>
LibreOffice Calc> Formula) then it is because he/she is used to typing formulas
in English.
In this situation it doesn't make sense that valid arguments are expected in
the language defined in Locale Settings.
How to reproduce:
Set your Locale to another language (e.g. Portuguese) (under Tools> Options>
Language Settings> Languages> Locale setting)
In the attached file paste formula =VLOOKUP(C2;A2:B3;2;FALSE)in cell D2 and/or
=HLOOKUP(C5;A5:B6;2;FALSE) in D5.
Expected result:
Should be equal to 3 if you set "Use English function names" regardless of the
Locale Language
Actual result:
It's equal to 3 if your Locale is English and equal to #NAME if it is another
language (because in e.g. Portuguese it expects FALSO as argument)
See this topic (including answers and comments)
http://ask.libreoffice.org/en/question/18851/vlookup-does-not-work-when-user-interface-not/
--
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
