[Bug 122718] New: Offset Function is not correctly converted in some cases

[bu...@apache.org]

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: issues@openoffice.apache.org
          Reporter: fwebb02@msn.com
                CC: issues@openoffice.apache.org

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.

[Bug 122718] Offset Function is not correctly converted in some cases

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=122718

Edwin Sharp <el...@mail-page.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |elish@mail-page.com
         Resolution|---                         |DUPLICATE

--- Comment #1 from Edwin Sharp <el...@mail-page.com> ---
bug 101467 is even more severe with error 509.

*** This bug has been marked as a duplicate of bug 101467 ***

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