You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jul 31, 2019. It is now read-only.
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?
The text was updated successfully, but these errors were encountered:
Sign up for freeto subscribe to this conversation on GitHub.
Already have an account?
Sign in.
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?
The text was updated successfully, but these errors were encountered: