Colin Zhao wrote:
What I find is that poi sometime has difficulty parsing seemingly good formula texts. When that happens, you will get what you got. Just retyping the formula over and saving the file will make the problem go away. That's not a solution, just showing the problem.
Speaking more specifically, when you use Copy/Paste to duplicate a formula in Excel and then save the file, it stores one copy of the formula in a separate place in the spreadsheet file, and stores links to that "shared" formula in the actual cells.
POI can't currently handle this shared formula table, hence these will always break.
Retyping the formula over results in a completely new formula, which is why it will work after doing this.
The only solution would be adding shared formula support. I'm not even sure where to start on that one...
Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Ph: +61 2 9280 0699 Web: http://www.nuix.com.au/ Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this message or attachment is strictly prohibited. --------------------------------------------------------------------- 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/
