Issue 101467 - Unable to import Excel Offset() formula returning a reference
Summary: Unable to import Excel Offset() formula returning a reference
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.1 RC2
Hardware: Unknown All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 122718 (view as issue list)
Depends on:
Reported: 2009-05-01 05:51 UTC by eberry
Modified: 2013-07-12 12:45 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

.xlsx file showing the Offset() formula issue (8.47 KB, application/
2009-05-01 05:51 UTC, eberry
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description eberry 2009-05-01 05:51:07 UTC
If I put this (simplified) formula in a .xlsx document:

In Excel 2007 this works fine, but Calc 3.1 RC2 reports this:
Err:509 Error: Operator Missing
And improperly changes the formula to:
=AVERAGE(B2:B2(B2; 0; 0))

The problem might be due to Excel's Offset returning a reference while calc
returns a value.  See:

See the attached sample .xlsx file for an example where this formula isn't
imported/translated correctly.
Comment 1 eberry 2009-05-01 05:51:42 UTC
Created attachment 61941 [details]
.xlsx file showing the Offset() formula issue
Comment 2 Edwin Sharp 2013-06-21 13:41:51 UTC
As given in description.
Rev. 1491860 Win 7
Comment 3 Edwin Sharp 2013-07-12 12:45:27 UTC
*** Issue 122718 has been marked as a duplicate of this issue. ***