bugGNU Octave - Bugs: bug #58235, [octave-forge](io) xlsopen does...


bug #58235: [octave-forge](io) xlsopen does not work with UNO interface

Submitted by:  None
Submitted on:  Fri 24 Apr 2020 09:01:00 AM UTC  
Category:  Octave Forge Package Severity:  3 - Normal
Priority:  5 - Normal Item Group:  Unexpected Error
Status:  Works For Me Assigned to:  None
Originator Name:  Ennio Condoleo Originator Email:  -email is unavailable-
Open/Closed:  Closed Release:  other
Operating System:  Microsoft Windows

Add a New Comment (Rich Markup)

You are not logged in

Please log in, so followups can be emailed to you.


Sat 23 May 2020 08:13:57 PM UTC, comment #2: 

No response for over 4 weeks.
Closing report with "Works for me" (with io-2.6.1)

Philip Nienhuis <philipnienhuis>
Project Member
Fri 24 Apr 2020 09:40:04 AM UTC, comment #1: 

io-2.4.13 is "old", please try io-2.6.1.

Exactly what commands did you use to open the file? That's what I need to try to reproduce this issue, not just output from the Octave terminal.

Furthermore, Octave + io package should be able to read .xlsx files w/o external support files. UNO (LibreOffice) can be advantageous, sure, but for simple reading you can also try with the OCT interface.

FYI, gauged by the number of bug / help mailing list reports the UNO interface isn't used that often and it is a fragile interface at that. So in a way I'm quite glad to see someone using it :-)

Philip Nienhuis <philipnienhuis>
Project Member
Fri 24 Apr 2020 09:01:00 AM UTC, original submission:  


I met an error into opening xlsx file by using xlsopen function.
I was using io package with version 2.4.13 (that theoretically should correct this issue):

(P.S. The file to be opened in in the attachments).

Detected XLS interfaces: UNO*; (* = default interface)

PLEASE NOTE: UNO (=OpenOffice.org-behind-the-scenes) is EXPERIMENTAL
After you've opened a spreadsheet file using the UNO interface,
xlsclose on that file will kill ALL OpenOffice.org invocations,
also those that were started outside and/or before Octave!
Trying to quit Octave w/o invoking xlsclose will only hang Octave.

warning: UNO interface will write ODS format for unsupported file extensions

Oops, Octave hit an error.
error: 'octave_config_info' undefined near line 103 column 18
error: called from
    _UNO_spsh_open_ at line 103 column 16
    xlsopen at line 311 column 35



(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:

Attached Files
file #48922:  NRR_20200422_141105_CP__003809_003813.xlsx added by None (351KiB - application/vnd.openxmlformats-officedocument.spreadsheetml.sheet - Attached file to be opened with xlsopen function)


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -email is unavailable- added by None (Submitted the item)

    Do you think this task is very important?
    If so, you can add your encouragement to it.
    This task has 0 encouragements so far.

    Only project members can vote.




    Follow 7 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2020-05-23 philipnienhuis StatusNeed Info => Works For Me
        Open/ClosedOpen => Closed
        Release5.2.0 => other
    2020-04-24 philipnienhuis Item GroupMissed Error or Warning => Unexpected Error
        StatusNone => Need Info
        Summaryxlsopen does not work => [octave-forge](io) xlsopen does not work with UNO interface
    2020-04-24 None Attached File- => Added NRR_20200422_141105_CP__003809_003813.xlsx, #48922

    Back to the top

    Powered by Savane 3.5