[Issue 118072] Incorrect interpretation of Excel 2003 XML spreadsheet

[bugzilla]

https://bz.apache.org/ooo/show_bug.cgi?id=118072

--- Comment #8 from dam...@apache.org ---
The bug is in the original MS Excel 2003 XML:

---snip---
      <Row ss:AutoFitHeight="0" ss:Height="13.5">
        <Cell ss:StyleID="s60" ss:Index="1" ss:Formula="=SUM(R[-2]C:R[-4]C)">
          <Data ss:Type="Number">600</Data>
        </Cell>
        <Cell ss:StyleID="s60" ss:Index="2" ss:Formula="=SUM(R[-2]C:R[-4]C)">
          <Data ss:Type="Number">650</Data>
        </Cell>
        <Cell ss:StyleID="s60" ss:Index="3" ss:Formula="R[-2]C">
          <Data ss:Type="Number">950</Data>
        </Cell>
      </Row>
---snip---

Note how ss:Formula="..." always begins with an "=", EXCEPT for the "R[-2]C"!!!

If you edit the file and prefix an "=", changing it to ss:Formula="=R[-2]C",
then the formula opens successfully.

Now the question is, does Excel open these broken formulas with missing "="
prefixes? If so, we need to do so as well, for compatibility.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.