Andrew C. Oliver wrote:
I can obviously just catch Exception around my call to getCellFormula(), but does anybody else have a better idea of what causes this error?
>
A bug or unimplemented PTG structure in the formula parser.
Okay. Actually, I isolated all the spreadsheets which were causing the problem and then modified our code so that it prints a particular error message into the cells which have this issue.
Every single cell with a problem is a formula which links to another file on disk, only the file isn't actually on disk. So even if the formula would be parseable, it wouldn't be particularly useful because the file it links to is gone. Luckily, the values are still present anyway.
Daniel -- Daniel Noll Nuix Australia Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Phone: (02) 9280 0699 Fax: (02) 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/