[Issue 118072] Incorrect interpretation of Excel 2003 XML spreadsheet

[bu...@apache.org]

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

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Latest|4.0.1                       |4.2.0-dev
    Confirmation in|                            |
                 CC|                            |damjan@apache.org
           Keywords|                            |ms_interoperability

--- Comment #7 from damjan@apache.org ---
Run:
xsltproc  main/filter/source/xslt/import/spreadsheetml/spreadsheetml2ooo.xsl
~/Downloads/outRunningBalance2.xml | xmllint --format -

and look at this row:

---snip---
        <table:table-row table:style-name="ro1-10">
          <table:table-cell table:style-name="s60"
table:formula="oooc:=SUM([.A8:A6])" office:value-type="float"
office:value="600">
            <text:p>600</text:p>
          </table:table-cell>
          <table:table-cell table:style-name="s60"
table:formula="oooc:=SUM([.B8:B6])" office:value-type="float"
office:value="650">
            <text:p>650</text:p>
          </table:table-cell>
          <table:table-cell table:style-name="s60" table:formula="[.C8]"
office:value-type="float" office:value="950">
            <text:p>950</text:p>
          </table:table-cell>
        </table:table-row>
---snip---

The table:formula values above are:

table:formula="oooc:=SUM([.A8:A6])"
table:formula="oooc:=SUM([.B8:B6])"
table:formula="[.C8]"

There is a missing "oooc:=" prefix for the "[.C8]".

We should also be using "of:=" instead for ODF 1.2, but that's a separate
issue.

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