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 2015/06/23 10:07:04 UTC

[Issue 126381] OO corrupts formulas when reading Excel spreadsheet

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

--- Comment #1 from J.Ty. <jt...@mimuw.edu.pl> ---
Created attachment 84806
  --> https://bz.apache.org/ooo/attachment.cgi?id=84806&action=edit
an example spreadsheet corrupted by OO

OO corrupts spreadsheets created under Excel, which contain references to whole
rows in the form '1:1'.

E.g., Excel's meaningful =INDEX(1:1,INDEX(2:2,3))
becomes OO's =INDEX($A1:$AMJ1INDEX($A2:$AMJ2)), which makes no sense and
produces an error.

The most pervert form is that Excel's =INDEX(2:2,2)
is turned into OO's =INDEX($A2:$AMJ2), which is syntactically correct, but
produces generally a different value.

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