Open with OpenOffice .xlsx document.

Open with OpenOffice .xlsx document.

rompeplatosrompeplatos Posts: 20Questions: 4Answers: 0
edited November 2015 in Buttons

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

This question has an accepted answers - jump to answer

Answers

  • allanallan Posts: 57,737Questions: 1Answers: 9,204 Site admin

    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

  • rompeplatosrompeplatos Posts: 20Questions: 4Answers: 0

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

  • allanallan Posts: 57,737Questions: 1Answers: 9,204 Site admin

    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

  • rompeplatosrompeplatos Posts: 20Questions: 4Answers: 0

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

  • allanallan Posts: 57,737Questions: 1Answers: 9,204 Site admin
  • jLinuxjLinux Posts: 981Questions: 73Answers: 75
    edited November 2015

    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

  • jLinuxjLinux Posts: 981Questions: 73Answers: 75

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

  • jLinuxjLinux Posts: 981Questions: 73Answers: 75

    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$
    
  • btreebtree Posts: 99Questions: 14Answers: 11

    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

  • allanallan Posts: 57,737Questions: 1Answers: 9,204 Site admin

    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

  • KiruwagakaKiruwagaka Posts: 1Questions: 0Answers: 0

    Any more information about this issue?

  • allanallan Posts: 57,737Questions: 1Answers: 9,204 Site admin

    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)Tom (DataTables) Posts: 139Questions: 0Answers: 26
    Answer ✓

    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

  • btreebtree Posts: 99Questions: 14Answers: 11

    Works great, thanks Tom!

This discussion has been closed.