Skip to content
This repository has been archived by the owner on Jul 31, 2019. It is now read-only.

Issues parsing formulas involving dates #4

Open
lancecarlson opened this issue Feb 8, 2010 · 0 comments
Open

Issues parsing formulas involving dates #4

lancecarlson opened this issue Feb 8, 2010 · 0 comments

Comments

@lancecarlson
Copy link

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?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant