Re: EventUserModel - Getting the Formula String from FormulaRecord and Setting Formula

[Nick Burch <ni...@torchbox.com>]

On Mon, 30 Jun 2008, sirapitt@hotmail.com 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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org