On Mon, 30 Jun 2008, [EMAIL PROTECTED] wrote:
Question for you before this thread goes away. I have come across a formula in a spreadsheet that I am currently unsuccessfuly trying to parse under the POI usereventmodel in 3.01FINAL. The company that distributes the data wanted to prevent US zipcodes from showing up as numbers in Excel and therefore coded them as ="70164" to represent the zipcode of 70164.
See usermodel.TestBugs#testZipCodeFormulas(), which verifies that poi is working properly. Note that for string formulas, you need to get the next record after the FormulaRecord to get the string itself.
XLS2CSVmra has code to do that, you might want to take a look there Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
