Bug 92143 - Equations in Writer tables show sum for any undefined function
Summary: Equations in Writer tables show sum for any undefined function
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Writer-Tables-Formulas
  Show dependency treegraph
Reported: 2015-06-17 22:12 UTC by mahfiaz
Modified: 2019-03-31 05:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

Example document (9.45 KB, application/vnd.oasis.opendocument.text)
2015-06-17 22:12 UTC, mahfiaz

Note You need to log in before you can comment on or make changes to this bug.
Description mahfiaz 2015-06-17 22:12:38 UTC
Created attachment 116610 [details]
Example document

When using average or stdev functions in Writer native tables, the results are totally off. Sum is shown in both cases instead.
Comment 1 m.a.riosv 2015-06-18 01:05:56 UTC
Because average it's not a function in Writer the function it's 'mean', while editing the formula you can see the available functions with the formula functions (fx icon).

I doesn't have AOo in English but seeing the name used in Spanish, is inherited from OOo the use of 'mean' instead 'average'

Seems the bug it's not to show an error with non defined functions, and it is inherited from OOo. You can use any name you like result it's always the sum if it is not a defined function.

Please change the title to define the real issue.
Comment 2 mahfiaz 2015-06-18 05:55:37 UTC
Thanks for the comment. I change the title.

Probably an enhancement request should be filed to rename mean to average, I don't think these should be named differently in Writer and Calc. (also mean is a nice umbrella term)
Comment 3 m.a.riosv 2015-06-18 19:50:23 UTC
Thanks @mahfiaz, I think it's much appropriate now.

I don't know if we are missing some reason to use 'mean', who knows. :)

If change the name can imply backwards compatibility issues, perhaps better add 'average' without deleting 'mean'.
Comment 4 QA Administrators 2016-09-20 10:11:38 UTC Comment hidden (obsolete)
Comment 5 m.a.riosv 2016-09-21 23:05:39 UTC
Still there.
Version: (x64)
Build ID: 3c2231d4aa4c68281f28ad35a100c092cff84f5d
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; 
Locale: es-ES (es_ES); Calc: group
Comment 6 Xisco Faulí 2017-09-29 08:50:12 UTC Comment hidden (obsolete)
Comment 7 Roman Kuznetsov 2019-01-16 13:50:21 UTC
Now in LO 6.3 when I try use function name "Average" in formula in Writer table I got message in cell "Expression is faulty"
Comment 8 mahfiaz 2019-03-31 05:30:29 UTC
Looks like it has been fixed. Closing the bug.