[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: |
Mon, 15 Jan 2018 17:30:49 -0500 (EST) |
User-agent: |
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:51.0) Gecko/20100101 Firefox/51.0 SeaMonkey/2.48 |
Follow-up Comment #7, bug #52875 (project octave):
Thanks Radek, yes I see what you mean.
Your fix indeed works for your file and the default test script
(io_xls_testscript.m, also in io), good! but I want to test some more
spreadsheets I have lying around here to be sure (and to be sure there are no
screw-ups elsewhere).
This is actually a case Markus Muetzel showed earlier, i.e., having shared
formulas rather than shared strings, see bug #51512, comment #16 and comment
#22 and up. It didn't get implemented at the time as this situation was
supposedly rare, but now you've hit it :-) (I'll cc Markus, I'd bet he wants
to know.)
With your fix we can at least read the shared formula values, but reading back
the formulas is quite a bit more involved.
It may take a little while, hopefully next weekend I have more time.
Some days ago I had io-2.4.10 released so this fix will be in a next version,
probably some months away, so no hurry yet.
_______________________________________________________
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] (io-2.4.9) __OCT_xlsx2oct__.m Empty value tag (<v/>) due to a formula in Excel causes multiple cells to be skipped, anonymous, 2018/01/12
- [Octave-bug-tracker] [bug #52875] (io-2.4.9) __OCT_xlsx2oct__.m Empty value tag (<v/>) due to a formula in Excel causes multiple cells to be skipped, anonymous, 2018/01/12
- [Octave-bug-tracker] [bug #52875] (io-2.4.9) __OCT_xlsx2oct__.m Empty value tag (<v/>) due to a formula in Excel causes multiple cells to be skipped, anonymous, 2018/01/12
- [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, 2018/01/13
- [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, anonymous, 2018/01/14
- [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, 2018/01/15
- [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, anonymous, 2018/01/15
- [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 <=
- [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, 2018/01/18
- [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, Markus Mützel, 2018/01/20