[Octave-bug-tracker] [bug #45916] io 2.2.9: xlswrite 'OCT' doesn't add strings to sheets created with LibreOffice

[Philip Nienhuis]

Update of bug #45916 (project octave):

                  Status:               Confirmed => Ready For Test         
        Operating System:               GNU/Linux => Any                    

    _______________________________________________________

Follow-up Comment #4:

The issue was that LO occasionally puts newlines between xml nodes at some
places, Excel doesn't do that (save for the upper xml identification line as
usual for xml files).
Not quite illegal, but it requires more robust code as the io pkg's OCT
interface doesn't invoke a real xml parser to handle OOXML.
In addition, LO doesn't complain about unlinked-to xml files in the zip
archive (that .xlsx really is) but apparently repairs the spreadsheet file
silently and drops those dangling files. Excel at least tells you that it
found inconsistencies.

I've replaced a few strrep calls by regexprep calls to be able to catch
whitespaces between xml nodes; works fine now for me.

Please try attached __OCT_oct2xlsx__.m (replace the one in io-2.2.9/private/)
and report back if this fixes the bug(s) for you.


(file #34860)
    _______________________________________________________

Additional Item Attachment:

File name: __OCT_oct2xlsx__.m             Size:24 KB


    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?45916>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/