LibreOffice compatibility tests

From CSV on the Web Working Group Wiki
Jump to: navigation, search

Version: LibreOffice, version 4.1.3.2, running under Mavericks (a.k.a. OS X version 10.9.1)

test-utf8.csv

  • Cyrillic text recognised
  • Latin text with accents recognised
  • data recognized as "Date & Time" and "Number"
  • The escaped line break is interpreted

As far as I can see, it renders as it should be. Note, however, that it is converted through a wizard where details can be modified/set.

Conversion-LibreOffice-test-utf8-bom.csv.png

test-utf8-bom.csv

Exactly Identical to the test-utf8 case

test-utf16.csv

Exactly Identical to the test-utf8 case

test-utf16-bom.csv

Exactly Identical to the test-utf8 case

test.xlsx

Rendering appears correct; note retention of formatting on date column labelled as 'custom format' (not date).

Conversion-LibreOffice-test.xlsx.png

test.xls

Exactly identical to the 'xlsx' case