only in version 7-4-2-1 pre-release
Language = German
select any field
type =3,2+6 enter
you see error #name
if you type
you see 9,2
the (german) decimal-point on the keyboard is not interpreted as decimal-point
only in 7-4-2-1
all previous versions work without bug
Can you attach a sample file?
Do you by chance have English function names activated? That would explain, because it now sets the formula expression context to English.
thank you for this comment.
indeed, english functions names are activated (since about ten years).
I tested it under 7-4-2-1 with no english function (ergo german-) names, and then it works properly.
but in 7-4-1-2 german commas on the decimal-block on the keyboard worked well, even if english function names have been activated.
Created attachment 182712 [details]
calc-sheets made with version 7-4-2-1 (with bug)
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to gerdl from comment #3)
> but in 7-4-1-2 german commas on the decimal-block on the keyboard worked
> well, even if english function names have been activated.
Yes, that changed with the implementation for bug 135993 that was fixed for 7.4.2, and some related, which now places such formula into English context.
I'd rather regard it as bug that previously using English function names still used the localized context.
It is more logical that when using English function names the formula syntax uses an English context with the corresponding decimal separator as well because that finally enables one to copy-paste sample formulas found on the web like on the ask.libreoffice.org site.
Previously I accidentally comentend to a not correct BUG (152034)
This is the right one, sorry.
My comment from the mentioned bug:
Same issue happens with all "," (comma) separator using languages, like Hungarian, German...
It should be fixed, as it happens frequently to type numbers first in a cell, then need to adjust it later with a simple "multiply" or "add" like: "4,5" to "=2*4,5" or "=B1*4,5". Or using complicated functions gathered from our older documents and we need to readjust the numbers every time when we need to modify it and the text in a cell could be 100+ char long, with constants in some random places with decimal separator!
Localized function names not only used for Copy-Paste but for easier handling and finding. English function names mostly better than some pretty brain-dead loalized function names what I would not find ever AND I do not want to learn all of them in any other laguage what I may facing with!
If you (QA) think that it is normal to use DOT instead of COMMA in eglish functions, think about the tousends of scientific users who SHOULD use localized numbers BUT they dealing with lot of abbreviations and names in almost only ENGLISH.
I guess the best would be to set a checkbox beside the "Use English Function Names" with option like "Use dot in functions for decumal separator" which maybe defaulted to ON but can be set by user.
And not the opposite! As under the Language Setting I have "decimal key = ," set, and even than, it is not handling the comma within fuctions just shows the comma in the results.
Tested system: Linux x64, 5.4.0-132-generic, Xubuntu 20.4.5
LibreOffcie: 7.4.2~rc3-0ubuntu0.20.04.1~lo1 (22.214.171.124)
*** This bug has been marked as a duplicate of bug 151886 ***