[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