[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/
- [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,
Philip Nienhuis <=