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

[Philip Nienhuis]

Update of bug #59277 (project octave):

                  Status:               Need Info => Confirmed              

    _______________________________________________________

Follow-up Comment #13:

Thanks for testing xlsopen.m; so one issue got fixed.
In hindsight it was a bit of a dumb error by me, but I also remembered how and
why I came there.

I dug up the bug report about formulas in sharedStrings.xml,
https://savannah.gnu.org/bugs/?51512
There's a fair amount of profiling involved there, maybe it can help you. The
issue of shared formulas was touched there (and postponed, with good reason).
IIRC that bug report was also about, or a prelude to, other report(s) about
complex strings. Maybe later on I'll stumble upon it/those.

As to your code:
The aim of cell2mat() is to get rid of extra cell "wrapping". Applying cellfun
to cell2mat output looks like it is re-wrapped again.
No need to enclose the regexp call in parens, it is already enclosed in
commas.

Maybe experimenting with vertcat or horzcat can help with unwrapping regexp's
output as well, but I am not so familiar with those functions.

I'll set bug status provisionally back to "confirmed" until I have more time
to look into it and/or help you recoding string reading in OCT interface.

    _______________________________________________________

Reply to this item at:

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

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