Can't read .ods file

[TanguyBarthelemy]

Hi,
I have an issue in reading .ods files.
I try to import it as a spreadsheet file:

So the file is placed in the providers panel and the sheet are recognised:

But that's all, the file is empty and the series are not read (when I click on the small + on the left, the sheet does not unroll with the series):

Maybe it's a bug or the .ods format is not accepted?
Is it possible to add a warning or an error in this case to inform the user that his file won't be read?

[charphi]

Does it work in JD+ v3?
Try to load it in the spreadsheet profiler (Menu>Tools>Spreadsheet Profiler) and check if something is loaded.

[TanguyBarthelemy]

The spreadsheet profiler is able to read my data but not my dates:

[TanguyBarthelemy]

I tried to edit and save my file with Excel (and not LibreOffice) and the file became readable in JDemetra+ 2.2.4

Here I join you the two version of the same file (one saved with Excel and the other with LibreOffice)

world_excel.ods
world_libre_office.ods

[TanguyBarthelemy]

in V3 the problem remains the same as in V2 except thar we can explore the content of each sheet but the series are not available because the date is not read:

[TanguyBarthelemy]

Hi Philippe,

I tested other .ods files created this time by R (from the readODS package).
I join you the two files (named world_R.ods and world_excel_R.ods): world_excel_R.ods and world_R.ods.

For these two, the file contains one sheet named Sheet1 but seems empty in the provider panel:

When I put these 2 files in the Spreadsheet Profiler Windows, I can read my dates:

for world_R.ods:

for world_excel_R.ods:

So as you can see it doesn't depends on the date format because these 2 files have differents date format.

The problem is the same in v3 except that in the providers tab, the series (colnames) appear but when I try to open them, "No data available".

[charphi]

The R example is a different problem.
The profiler shows that the date cells are in blue, meaning that it is a string type, not a date.
In order to parse these cells, you need to configure the "Data format" option (i.e. yyyy-MM-dd).

[charphi]

For the world_libre_office.ods file, the problem comes from the underlying library that is unable to handle LocalDate while being able to handle LocalDateTime.

I've created a new issue at nbbrd/spreadsheet4j#470

[TanguyBarthelemy]

Thank you for your answer about the file .ods created with R.

The date column was (as you mentionned) in the text format and effectively needed a configuration of Date format option when importing (in Providers panel) the file.

[charphi]

The spreadsheet4j issue has been solved and will be integrated in the next bugfix release of JDemetra+ v2.
jdemetra/jdemetra-core#1134