Issue 127217

Summary: Subtotal and Offset function for each line
Product: Calc Reporter: jeffooo <jeffooo>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: oooforum
Version: 4.1.3   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Subtotal with offset for each cell
none
Subtotal and Offset in MS Excel (locale Fr) none

Description jeffooo 2016-11-18 11:04:46 UTC
Created attachment 85858 [details]
Subtotal with offset for each cell

Hello,

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 :
=SUBTOTAL(3,OFFSET($A$1,LINE(A2),0))

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 https://bugs.documentfoundation.org/show_bug.cgi?id=58874
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