Fix ods datetime and time export and import

jazzband / tablib

Python Module for Tabular Datasets in XLS, CSV, JSON, YAML, &c.

https://tablib.readthedocs.io/

MIT License

4.61k stars 593 forks source link

Closed pascalfree closed 3 months ago

pascalfree commented 3 months ago

The ods format was not matching the spec (Table 14) on datetime and time:

datetime must be handled like date: The value goes into the date-value attribute instead of the value attribute.
time value must be formatted as a duration according to XML spec.

[x] Add backwards compatibility, to import the broken time format as it is exported in the current version?
[x] Add test for time import
[x] Add test for datetime export

claudep commented 3 months ago

Thanks! I guess I'll wait for the test before approving? You could also add an entry in HISTORY.md

claudep commented 3 months ago

Could you still rebase and squash, please?