Issue 127217 - Subtotal and Offset function for each line
Summary: Subtotal and Offset function for each line
Status: UNCONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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

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