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=38358>. 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=38358 Summary: Unable to parse formula Product: POI Version: 2.5 Platform: All OS/Version: All Status: NEW Severity: critical Priority: P2 Component: HSSF AssignedTo: poi-dev@jakarta.apache.org ReportedBy: [EMAIL PROTECTED] I have to do a report with some value issued from an AS400. Anyway, when I put all my values and finally my formula, all other formula works perfectly but YIELD(TODAY()+3;V5;W5;... and so on, dosn't work... The formula is parsed without any errors, and as a result, we ca see in the Cell : TODAY()+3;otherparams;)XYIELD where X is a strange caracter (sometimes a chinese sign, or a rectangle ...) I have to explain to my client that he must click on the Cell and click Enter and after that, copy the formula right down ... I've putted my formula with a '=' and in string type ... I've search a lot but there is apparently any other possibility to put a formula and to bypass the parsing done by HSSF ... So if its possible when you know that your way is not completely finished, provide another possibilty or a workaround ... If there is one, I'm really interested !!!! -- 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/