[Bug 52169] Date arithmetic on textual cells
https://bz.apache.org/bugzilla/show_bug.cgi?id=52169 PJ Fanning changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #3 from PJ Fanning --- TIMEVALUE is in v5.1.0 -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52169] Date arithmetic on textual cells
https://bz.apache.org/bugzilla/show_bug.cgi?id=52169 --- Comment #2 from PJ Fanning --- DATEVALUE function is in recent versions of POI (eg POI 5.0.0). TIMEVALUE is not implemented yet. -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52169] Date arithmetic on textual cells
https://bz.apache.org/bugzilla/show_bug.cgi?id=52169 Ralph Jacobs changed: What|Removed |Added Version|3.8-dev |3.17-FINAL CC||r_jac...@gmx.de -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52169] Date arithmetic on textual cells
https://bz.apache.org/bugzilla/show_bug.cgi?id=52169
--- Comment #1 from Ralph Jacobs ---
Same applies to date or time constants as arguments of the VALUE function
(VALUE("11:45"). They will give a #VALUE! error on evaluation.
see org.apache.poi.ss.formula.functions.Value.convertTextToNumber(String)
Missing implementations of specialized functions DATEVALUE and TIMEVALUE, which
would offer a workaround for the VALUE function in case of date/time constants.
--
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 52169] Date arithmetic on textual cells
https://bz.apache.org/bugzilla/show_bug.cgi?id=52169 Dominik Stadler changed: What|Removed |Added Severity|normal |enhancement -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
