- changed status to resolved
OpenXML: Filter truncates multi-line formulas
Issue #734
resolved
Reduced testcase attached. This file contains a formula like this:
IF(B1=1, "A",
IF(B1=2, "B",
IF(B1=3, "C"
)))
(If you change the value of cell B1 to either 1, 2, or 3, the value of A1 will change to A, B, or C.)
If we roundtrip this file through tikal, the formula in the output file is cut off at the first line break:
IF(B1=1, "A",
Excel will repair the file, but it's still data loss.
Side note: when I tried to create this testcase in LibreCalc, it flattened the formula into a single line and I had to re-introduce line breaks by hand. However, Excel seems to allow this (or at least, I've seen these files in the wild, and they must be coming from somewhere.)
Comments (3)
-
reporter -
reporter - changed milestone to M36
-
reporter -
assigned issue to
-
assigned issue to
- Log in to comment
Fix issue
#734- Don't corrupt multiline formulas during extraction→ <<cset b5eaceb04e8d>>