Bug 105369 - Function names for formulas in tables in Writer are in English instead of localized (Dutch)
Summary: Function names for formulas in tables in Writer are in English instead of loc...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Writer-Tables-Formulas
  Show dependency treegraph
 
Reported: 2017-01-16 15:06 UTC by Roy D
Modified: 2020-11-14 09:35 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
writer_table_localized_formula (9.56 KB, application/vnd.oasis.opendocument.text)
2017-08-02 13:58 UTC, Oliver Brinzing
Details
lo5352_german_help_sum_formula (547.52 KB, application/pdf)
2017-08-09 14:45 UTC, Oliver Brinzing
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roy D 2017-01-16 15:06:03 UTC
When opening old Writer documents, with tables in it including some calculations, Writer gives on the formula (Dutch): =som(<E2:E16>) the error **Foutieve expressie**(=Expression Error). The expression should now apparently be in English: =sum(<E2:E16>), which is accepted. I have not read about an intended change of localized function names to English in Writer.
Comment 1 Xisco Faulí 2017-01-16 16:11:32 UTC
@Cor, can you take a look at this one and comment?
Comment 2 Cor Nouws 2017-01-16 21:48:02 UTC
Hi Roy,

(In reply to Roy D from comment #0)
> When opening old Writer documents, with tables in it including some
> calculations, Writer gives on the formula (Dutch): =som(<E2:E16>) the error
> **Foutieve expressie**(=Expression Error). The expression should now
> apparently be in English: =sum(<E2:E16>), which is accepted. I have not read
> about an intended change of localized function names to English in Writer.

Those have never been localized, until now.
Have seen some discussion on the subject, don't find an issue right now..
It was because sometimes (or in the past) Som<...> was interpreted as Sum, being a fall back / default function.

Set as enhancement.
Comment 3 Oliver Brinzing 2017-08-02 13:58:39 UTC
Created attachment 135073 [details]
writer_table_localized_formula
Comment 4 Oliver Brinzing 2017-08-02 14:00:57 UTC
attached writer document (created with lo 4.4.7.2) has a working 
"localized" sum formula: =summe <A1:A3>
with lo 5.1.6 it gives an error.
Comment 5 Cor Nouws 2017-08-09 14:00:20 UTC
(In reply to Oliver Brinzing from comment #4)
> attached writer document (created with lo 4.4.7.2) has a working 
> "localized" sum formula: =summe <A1:A3>
> with lo 5.1.6 it gives an error.

this sometimes works/worked by accident, rather than by design
Comment 6 Oliver Brinzing 2017-08-09 14:45:34 UTC
Created attachment 135345 [details]
lo5352_german_help_sum_formula

> worked by accident, rather than by design

that's true, but i found 2 entries in the german 
help where "=Summe" is used instead of "=sum".
Comment 7 Mike Kaganski 2020-11-14 09:35:30 UTC
This is not a bug. Since resolving bug 61228, this now works as intended, not accepting any random string to be ignored (thus sometimes making an impression it "works"). Comment 5 is absolutely correct. And there was never a localization of formulas/function names in Writer.

(In reply to Oliver Brinzing from comment #6)
> that's true, but i found 2 entries in the german 
> help where "=Summe" is used instead of "=sum".

That would be a documentation bug. References to those would be needed to solve.