Bug 114241 - Subtotal syntax should allow function name
Summary: Subtotal syntax should allow function name
Status: CLOSED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Function-Subtotal
  Show dependency treegraph
 
Reported: 2017-12-04 14:45 UTC by Thomas Lendo
Modified: 2017-12-04 23:57 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Lendo 2017-12-04 14:45:37 UTC
Subtotal syntax should allow function name in addition to the existing number system.

The syntax of Subtotal is: SUBTOTAL(Function; Range)
For Function, there is a list of numbers which references to the allowed functions. See help: https://help.libreoffice.org/Calc/Mathematical_Functions#SUBTOTAL

To simplify the manual use of the syntax in Calc's input line (without look to the help page if you use this function rarely), allow to use the function name too.

In addition to the example on the help
 =SUBTOTAL(9;B2:B5)
is should be allowed to use
 =SUBTOTAL(SUM;B2:B5)
or maybe another notation (which is more logical for a rare subtotal user like me)
 =SUBTOTAL(SUM(B2:B5))

There may be technical obstacles against it but maybe it's possible without too much effort.
Comment 1 Thomas Lendo 2017-12-04 14:50:23 UTC Comment hidden (no-value)
Comment 2 m_a_riosv 2017-12-04 16:35:35 UTC
Maybe an easy way would be listing those in the help text on the function wizard.

If a manner can be I think would be as in the CELL() function with the required function name as text inside quotes.

In any case a request for enhancement.
Comment 3 Eike Rathke 2017-12-04 23:57:03 UTC
All three approaches are not viable. Using a stray function name within an expression would be a completely exceptional case to all formula parsing, SUM is a function name that expects opening parenthesis, argument(s) and closing parenthesis. For the same reason in SUBTOTAL(SUM(B2:B5)) the result of summing the range B2:B5 is the argument to the SUBTOTAL function. Literal text as arguments does not play with translated UI functions.

Furthermore, but not least, SUBTOTAL is *defined* by two standards to have the first argument as a function number and all spreadsheet applications interpret it as such.

Won't implement.