[Octave-bug-tracker] [bug #45303] xlsread in io package can't handle Excel worksheet reordering

[Philip Nienhuis]

Update of bug #45303 (project octave):

                  Status:                    None => Need Info              

    _______________________________________________________

Follow-up Comment #1:

A number of questions:

1. How do you reorder sheets? Do you do that in Excel?

2. What io package version?

3. What interface does the io package report when you open an Excel file for
the first time in a new Octave session? COM? OCT? UNO? POI?

4. Do other interfaces than the one you used correctly pick up the proper
worksheet?

Worksheet reordering is indeed a tricky issue. The main concern of the io
developers was to be able to read and write (into) worksheets, not so much
reordering them.

FYI, that is works in Matlab is obvious - Matlab invokes Excel itself behind
the scenes. The io package can do that too using the COM interface. For other
interfaces we have to mimic Excel's behavior in Octave as far as we can, but
that isn't always possible.

Similar bugs has been fixed in (IIRC) io-2.2.5; some care was taken to comply
with the OOXML spec but maybe (possibly) this part needs revisiting.


    _______________________________________________________

Reply to this item at:

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

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