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 [EMAIL PROTECTED]  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: [EMAIL PROTECTED]
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/

Reply via email to