You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2023/01/12 01:38:41 UTC

[Issue 116319] sheet reference error on Excel 2003 xml import

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

damjan@apache.org changed:

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

--- Comment #5 from damjan@apache.org ---
If we run:

xsltproc  main/filter/source/xslt/import/spreadsheetml/spreadsheetml2ooo.xsl
116319\ Test.xml

and we look at the formula cell on Sheet2:

<table:table-cell
  table:style-name="ta1"
  table:formula="oooc:=SUM([Sheet1.A1:[Sheet1.B1])"
  office:value-type="float"
  office:value="3">
    <text:p>3</text:p>
</table:table-cell>

the table:formula of:
oooc:=SUM([Sheet1.A1:[Sheet1.B1])

has 2 "[" but only 1 "]", and nests Sheet1.B1 in a possibly unnecessary or
wrong pair of "[" and "]".

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