[Octave-bug-tracker] [bug #59273] [octave forge] (io) can't reliably load XLSX files in release 2.6.2

[Philip Nienhuis]

Follow-up Comment #17, bug #59273 (project octave):

Please try with attached __OCT_spsh_open__.m and __ods_get_sheet_dims__.m, bth
in private/ subdir.
As usual, on top of the other latest file versions in this bug report :-)

I'm a bit surprised you got this error. This code apparently hasn't changed
since > 7 years; I can only surmise it is due to the test.ods spreadsheet in
the test directory. That spreadsheet *is* kosher, that is, it gives no errors
when reading with LibreOffice and any of the other spreadsheet interfaces, so
the bug must be real.
Which makes me wonder if the debian tests have changed the last year, IOW, why
hasn't this been catched before.
But then again, maybe maybe something changed in Octave-6+ that provoked the
bug. File encoding handling?

That said, the entire OCT interface comprises fairly fragile code. Regexps,
string searches for XML nodes and tags, it isn't all very robust but
apparently just enough.



(file #50042, file #50043)
    _______________________________________________________

Additional Item Attachment:

File name: __OCT_spsh_open__.m            Size:7 KB
    <https://file.savannah.gnu.org/file/__OCT_spsh_open__.m?file_id=50042>

File name: __ods_get_sheet_dims__.m       Size:5 KB
   
<https://file.savannah.gnu.org/file/__ods_get_sheet_dims__.m?file_id=50043>



    _______________________________________________________

Reply to this item at:

  <https://savannah.gnu.org/bugs/?59273>

_______________________________________________
  Message sent via Savannah
  https://savannah.gnu.org/