https://issues.apache.org/ooo/show_bug.cgi?id=122718
Bug ID: 122718
Issue Type: DEFECT
Summary: Offset Function is not correctly converted in some
cases
Product: Calc
Version: AOO 3.4.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
The Excel formula below is only partially correct in OpenOffice Calc. This
Excel statement works fine in Excel (and actually works fine in OpenOffice once
it is retyped). When the Excel file is opened in OpenOffice, the first Offset
is converted to V56 (at least in this case with the V$56: just prior to the
Offset function). The second Offset is fine in OpenOffice. I would guess that
the difference is due to the first Offset function being inside of the Sum
function. Since the Offset statement is converted to a cell reference that is
beside it, there is no standard way to search and replace this. There is an
error in the cell, but each cell must be reviewed and modified individually to
replace the original Offset function - then it works fine in OpenOffice Calc.
SUM(V$56:OFFSET(V460,-B473,0))+OFFSET(U460,-B473+1,0)
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
