[Libreoffice-bugs] [Bug 114241] Subtotal syntax should allow function name

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=114241

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WONTFIX

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171204/b3b3ed4f/attachment-0001.html>