poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 55007] New: Add function to indirectly reference formulas
Date Wed, 22 May 2013 16:37:07 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=55007

            Bug ID: 55007
           Summary: Add function to indirectly reference  formulas
           Product: POI
           Version: unspecified
          Hardware: PC
            Status: NEW
          Severity: enhancement
          Priority: P2
         Component: HSSF
          Assignee: dev@poi.apache.org
          Reporter: golfjunobravo@gmail.com
    Classification: Unclassified

Have a function in OO Calc that allows a cell with a formula to be indirectly
evaluated.  This will allow a single formula to be referenced in multiple other
cells with any changes in the reference formula being reflected in the other
cells.

Sheet1.A1 has formula =SUM(D4:D9;E4:E6)
Sheet2.C9 has a pointer to Sheet1.A1
Sheet3.C9 has a pointer to Sheet1.A1
Sheet4.H3 has a pointer to Sheet1.A1

Desired evaluation result for cell Sheet2.C9 is =SUM(Sheet2.D4:D9;Sheet2.E4:E6)
Desired evaluation result for cell Sheet3.C9 is =SUM(Sheet3.D4:D9;Sheet2.E4:E6)
Desired evaluation result for cell Sheet4.H3 is =SUM(Sheet4.D4:D9;Sheet2.E4:E6)

Optional function feature would be to allow a row and column offset that would
offset non-absolute value formula references.

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

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message