DO NOT REPLY [Bug 32562] - Enable inserting new columns

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

DO NOT REPLY [Bug 32562] - Enable inserting new columns

Bugzilla from bugzilla@apache.org
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG?
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=32562>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND?
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=32562





------- Additional Comments From [hidden email]  2005-05-31 16:10 -------
I've been thinking about this myself and although I agree
with the idea that POI is basically a file format translator,
this is also one of the desirable features, especially when
creating new workbooks. (For instance when you want a
summary table at the top that has dynamic num of rows -
hence it is unpredictable how many rows it will occupy -
and consists of formulas based on cells below, which in turn
have formulas...)

IMHO, POI should allow ways for external classes to hook
into the FormulaParser and add such features. Currently,
since FormulaParser can be only contructed with a Workbook
instance, it isnot possible for HSSF client classes to
parse formulas.

With a clean way to hook into the FormulaParser api, I
imagine it should not be too much of an effort to emulate
excel's shift row/columns functionality (AFAIK, All
CellReferences are shifted by an X,Y offset by excel
when insert col/row is performed). Ofcourse, I'm not
suggesting that such a functionality be a part of
POI main, but seems like it would be a good addition
to 'contrib' or 'examples'.

--
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/