[Issue 127217] New: Subtotal and Offset function for each line

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=127217

          Issue ID: 127217
        Issue Type: DEFECT
           Summary: Subtotal and Offset function for each line
           Product: Calc
           Version: 4.1.3
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: jeff...@orange.fr
  Target Milestone: ---

Created attachment 85858
  --> https://bz.apache.org/ooo/attachment.cgi?id=85858&action=edit
sample file

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

-- 
You are receiving this mail because:
You are the assignee for the issue.