Issues parsing formulas involving dates

Open lancecarlson opened this issue 15 years ago • 0 comments

I have a column of dates that don't get parsed correctly because they're in formula form and they're all =A#+30 (the pound sign is just a number). This should add 30 days to each date but instead comes up with messed up stuff. When I trace out the output of the object i get:

Some Date:Thu Sep 27 00:00:00 GMT-0500 1900:(com.as3xls.xls.formula::Formula)#0 formula = "=S141+30" myCol = 19 myRow = 140 result = "30Mon Aug 18 00:00:00 GMT-0400 2008"

Looking through the code to see how I can fix but I'm new to this library so it's taking me a bit to isolate where I can fix this. Ideas?

Feb 08 '10 22:02 lancecarlson