Open with OpenOffice .xlsx document.

rompeplatos

I have a problem with .xlsx document. When I open this document, it´s in empty!. It´s posible open .xlsx document with OpenOffice??
Example:
- https://datatables.net/extensions/buttons/examples/flash/simple.html
- https://datatables.net/extensions/buttons/examples/html5/simple.html

Version OpenOffice: 4.1.2

Windows 7

allan

I've tested it with LibreOffice 5.0 and 4.4 and the files appear to open without issue in that software. Does OpenOffice give you any errors?

Allan

rompeplatos

No errors, the document open is empty. With Microsoft Excel open correctly but with OpenOffice not.

allan

I've just downloaded OpenOffice 4.1.2 and also see this error. I don't understand why that would be the case as it is a valid XLSX file that can be read by Excel and LibreOffice without issue.

I'll open a bug report on OpenOffice's bug tracker and see if we can get any debug information from OO.org. I'll post back here when I've filed it.

Allan

rompeplatos

Excelent Allan!!, I waiting a response. If you when to Granada, Spain I will invite a beer!! ;).

allan

Posted here: https://bz.apache.org/ooo/show_bug.cgi?id=126644 .

jLinux

I actually get errors with the ones I have.

http://d.pr/i/17A6r

Clicking Yes: http://d.pr/i/19JSr

But with the DT Flash example one, yes, its blank.. very odd

jLinux

However, opening it with excel, then saving it and closing it, it then opens with OO

jLinux

Might be worth noting, that the exact same file, just opened and re-saved, has a big file size difference (Well big in the fact the file is already small)

MacBooks-MacBook-Air:Desktop jhyland$ ls -alrth DataTables\ example\ -\ From_*
-rw-------@ 1 jhyland  staff   3.6K Nov 11 12:22 DataTables example - From_DT.xlsx
-rw-r--r--@ 1 jhyland  staff    11K Nov 11 12:24 DataTables example - From_Excel.xlsx
MacBooks-MacBook-Air:Desktop jhyland$

btree

Jeeezz should have looked first in the forum, got the same problem. Never though to test it in another program. Thanks for posting a bug report @allan

allan

It looks like it is an already known OOo bug - https://bz.apache.org/ooo/show_bug.cgi?id=126344 .

Unfortunately the bug doesn't state why this is happening, so I'm not sure what should be changed in the generated file. Possibly naming each cell (A1 for example) might fix it.

The file size difference is due to Excel saving loads of additional information such as styling etc, which is not required for the simple file that Buttons creates.

Allan

Kiruwagaka

Any more information about this issue?

allan

The Excel file format Buttons is creating is currently in the process of being modified to add styling information and I have hopes that will address this OOo bug. However, as noted above, it is an OOo bug. The file currently generated is a valid XLSX file.

Allan

Tom (DataTables)

This should now be fixed, changes are now in the nightly version ( https://datatables.net/download/nightly )

Link to commit- https://github.com/DataTables/Buttons/commit/71fd6d01a7a9d24e0b8343603392eff3070f2cd1

btree

Works great, thanks Tom!