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