[Bug 55007] New: Add function to indirectly reference formulas

[bu...@apache.org]

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

[Bug 55007] Add function to indirectly reference formulas

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=55007

--- Comment #1 from Mark B <ma...@tiscali.co.uk> ---
Slightly confused about what you are asking for here. Are you saying that you
want a new function within Excel itself that exhibits this feature? If so, then
you really need to post this request to Microsoft as POI is only used to
create/edit files that are compatible with the application, it cannot be used
to modify the application itself.

Alternativly, you need to create a user defined function - these can be
included into the application - but I am not at all sure you could call it SUM
as I suspect that is a reserved word or name within the application. To do so,
you will be writing the VBA code again within Excel and this is another
question best asked on an Excel users forum.

Finally, you might be asking if it is possible to make POI's formula evaluator
work in the manner you describe. If so, this might be possible as you can
create functions outside of Excel and have POI use these during it's evaluation
of the workbook. Again though, I suspect you will fall foul of naming issues if
you still want to call it the SUM function.

-- 
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