Ref3DPtg implementation

[Andreas Prohaska <ap...@allocation.net>]

Hi. While trying to parse more complex Excel formulas, as returned by
HSSFCell.getFormulaString(), we ran across a problem that seems to
be caused by the Ref3DPtg.toFormulaString() implementation.

What we are basically trying to do is to parse a formula that contains
a reference to a cell on another sheet. The name of the Sheet contains
spaces like =IF('Sheet 1'!A1=0,1,2). However the Ref3DPtg implementation
does not add the single quotes and produces a rather unparseable 
excel formula =IF(Sheet 1!A1=0,1,2).

There is already an issue
http://issues.apache.org/bugzilla/show_bug.cgi?id=36646
that seems to adress this topic. But since it was posted almost a year ago, 
I'm curious whether there is still an effort to fix this.

Any reply is appreciated :-)

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