Bug 107040 - Calc, SUBTOTAL function: add help for function indexes 101-111
Summary: Calc, SUBTOTAL function: add help for function indexes 101-111
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:6.0.0
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency tree / graph
 
Reported: 2017-04-08 23:15 UTC by Aron Budea
Modified: 2017-08-21 20:21 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 Aron Budea 2017-04-08 23:15:57 UTC 
Currently this is the help for SUBTOTAL function:
https://help.libreoffice.org/index.php?title=Calc/Mathematical_Functions&Language=en-US&System=UNIX&Version=5.4#bm_id3165644

It only shows 1-11 as available function indexes. Codes have been extended with indexes 101-111 to comply with the Excel function of the same name:
https://support.office.com/en-us/article/SUBTOTAL-function-7b027003-f060-4ade-9040-e478765b9939

The only difference between the two ranges is that the 101-111 functions disregard hidden rows.

The new function indexes were added with this commit:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=40575c20ff9cd693b8a6d3627274ce6d745e0581

Setting to NEW based on the referenced sources.
Comment 2 Commit Notification 2017-08-21 18:39:58 UTC 
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/help/commit/?id=12f5fcacd219532e748c24b96c3be143e1fec99f

tdf#107040 Calc: help for SUBTOTAL indexes 101-111