Issue 127217 - Subtotal and Offset function for each line
Summary: Subtotal and Offset function for each line
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 4.1.3
Hardware: All All
: P5 (lowest) Normal with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2016-11-18 11:04 UTC by jeffooo
Modified: 2020-02-24 14:23 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Subtotal with offset for each cell (51.39 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-11-18 11:04 UTC, jeffooo
no flags Details
Subtotal and Offset in MS Excel (locale Fr) (23.42 KB, image/png)
2016-11-18 11:08 UTC, jeffooo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jeffooo 2016-11-18 11:04:46 UTC
Created attachment 85858 [details]
Subtotal with offset for each cell


Steps to reproduce :
 - open a sample file in attachment
 - choose 1 in B1 for choice filter
 - In A16, SUBTOTAL give result for A3, but A3 is hidden

Function in A16 :

This formula work in Excel

Best regards
Comment 1 jeffooo 2016-11-18 11:08:11 UTC
Created attachment 85859 [details]
Subtotal and Offset in MS Excel (locale Fr)
Comment 2 oooforum (fr) 2016-11-18 17:11:14 UTC
Sounds like a dup of Issue 93837
Comment 3 jeffooo 2016-11-18 18:31:12 UTC
My attachment is not a import of MS file, is a native OpenDocument.

Perhaps is the same issue, because the really problem is :

- SUBTOTAL give a result of hidden cell, with OFFSET range.
Comment 4 jeffooo 2017-08-16 09:17:52 UTC
There’s the same issue in LibO, it’ll resolved in LibO 6, see
Comment 5 oooforum (fr) 2017-08-16 09:40:49 UTC
LibO patch can't be integrated due to licence incompatibility.
So to solve this issue, you can:
1) ask to the LibO developer to set its patch as AL v2 licence
2) wait an AOO developer to produce a fix
Comment 6 jeffooo 2017-08-17 07:31:48 UTC
1) I think the license is a utopia ...
2) AOO being my favorite tool, I will wait for the developers to produce a fix

Can this issue be Confirmed ?
Comment 7 jeffooo 2020-02-24 14:23:28 UTC
Confirmed with AOO 4.1.7