Check correctness of output cell values #3
Description
Set up a nice test sheet with text, multiline text, integer, float, currency, sci notation?, anything available, and see if the default output is acceptable. Add fixes if needed. Add tests to make sure it stays acceptable.
Hopefully this doesn't need to be a configurable thing. 😩
Tests:
- Currency values do not lose precision (common issue reading through OLE)
- Percent is ok - decimal
- Scientific also has the literal
- Multiline embeds newlines beautifully
- Dates are excel epoch integers
- Date + time is staying literally what I entered?