OpenXML: Filter truncates multi-line formulas

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)