octave-bug-tracker
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Octave-bug-tracker] [bug #52875] [octave-forge] (io-2.4.9) Empty value


From: Philip Nienhuis
Subject: [Octave-bug-tracker] [bug #52875] [octave-forge] (io-2.4.9) Empty value tag (<v/>) due to a formula in Excel causes multiple cells to be skipped
Date: Sun, 25 Mar 2018 10:00:44 -0400 (EDT)
User-agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:51.0) Gecko/20100101 Firefox/51.0 SeaMonkey/2.48

Follow-up Comment #10, bug #52875 (project octave):

@Markus;
With io-2.4.10 I get this out of file #42995:

>> [num, txt, raw] = xlsread ('Excel2016_emptyFormulaResult.xlsx', 1, '',
'oct')
num =
     1     2   NaN     4     5

txt =
{
  [1,1] = A
  [2,1] =
  [1,2] = B
  [2,2] =
  [1,3] = C
  [2,3] =
  [1,4] = D
  [2,4] =
  [1,5] = E
  [2,5] =
}

raw =
{
  [1,1] = A
  [2,1] =  1
  [1,2] = B
  [2,2] =  2
  [1,3] = C
  [2,3] =
  [1,4] = D
  [2,4] =  4
  [1,5] = E
  [2,5] =  5
}


Output cellstr array txt has too many elements, but the numeric array is fine.
So we have progress ... :-)

    _______________________________________________________

Reply to this item at:

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

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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]