[Octave-bug-tracker] [bug #59277] xls2oct and/or openxls behave unexpected

[Philip Nienhuis]

Follow-up Comment #20, bug #59277 (project octave):

OK, a first step from me.

Attached is an  __OCT_xlsx2oct__.m  with all your fixes and a somewhat amended
suggestion cf. comment #19.

Would you please look
0 if it still works
0 if you still have the expected speed gain
?

I have a spreadsheet with ~162 strings, some deliberately with mixed
formatting, where execution for reading it 100 times went down from 18.some to
16.some seconds, not much, but significant (it has many more numerical data),
I tested along the lines of

xls = xlsopen ("<filename>", 0, "oct")
opts = struct ("formulas_as_text", 0)
>> tic; for ii=1:100; raw = __OCT_xlsx2oct__ (xls, 3, "", opts); end; toc
Elapsed time is 16.8628 seconds.
>> xls = xlsclose (xls)
xls = [](0x0)
>>


with patched  __OCT_xlsx2oct__.m  in the current directory
(check with "which  __OCT_xlsx2oct__.m ")

In the mean time I'll check with my collection of bug report spreadsheets if I
can spot any regressions.

(file #50077)
    _______________________________________________________

Additional Item Attachment:

File name: __OCT_xlsx2oct__.m             Size:9 KB
    <https://file.savannah.gnu.org/file/__OCT_xlsx2oct__.m?file_id=50077>



    _______________________________________________________

Reply to this item at:

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

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