Bug 167841 - AVERAGE, AVERAGEA, COUNT, COUNTA ... argument names are wrong in help
Summary: AVERAGE, AVERAGEA, COUNT, COUNTA ... argument names are wrong in help
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Olivier Hallot
URL:
Whiteboard: target:26.2.0
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures Help-Changes-Features
  Show dependency tree / graph
 
Reported: 2025-08-07 06:25 UTC by Mike Kaganski
Modified: 2025-08-15 13:22 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2025-08-07 06:25:35 UTC 
AVERAGE, AVERAGEA, COUNT, COUNTA (and so on) help pages need a fix of the argument names.

E.g.:
https://help.libreoffice.org/25.8/en-US/text/scalc/01/04060184.html?DbPAR=CALC#bm_id3145824

They show arguments as "Number 1 [; Number 2 [; … [; Number 255]]]". But the arguments are not "number", but anything, including ranges, or text.

It would be better to refer to them simply as "Arg 1 [; Arg 2 [; … [; Arg 255]]]", or something like that.
Comment 1 Werner Tietz 2025-08-07 10:06:39 UTC 
for the non-techies maybe:

optional arbitary number of arguments split by $(argument-delimiter) any of them as single-cell-address, range-address or literal number?

but yes +1
Comment 2 Commit Notification 2025-08-07 15:29:29 UTC 
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/89a16829fb0e4cf550bad87c9c27ccc4c89870ef

tdf#167841 Arguments of statistical functions