Issue 101467 - Unable to import Excel Offset() formula returning a reference
Summary: Unable to import Excel Offset() formula returning a reference
Status: CONFIRMED
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:
URL: http://user.services.openoffice.org/e...
Keywords:
: 122718 (view as issue list)
Depends on:
Blocks:
 
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: ---

Attachments
.xlsx file showing the Offset() formula issue (8.47 KB, application/vnd.ms-excel)
2009-05-01 05:51 UTC, eberry 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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:
=AVERAGE(B2:OFFSET(B2, 0, 0))

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:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=18227

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. ***