Issue 117389

Summary: OFFSET of external reference doesn't work with expressions as arguments for rows, columns, height, width.
Product: Calc Reporter: ooo
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: issues, jeffooo, kg_ooohelp, oukcha.fr
Version: recent-trunk   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on: 103331    
Issue Blocks:    
Attachments:
Description Flags
testcase, formulas in column H should yield 255 each none

Description ooo 2011-03-15 14:35:30 UTC
Follow-up of issue 103331:
OFFSET('external.ods'#$Sheet1.$A$1;-B3;C3) yields Err:504 because of -B3 expression.
Comment 1 ooo 2011-03-15 14:39:17 UTC
Created attachment 76108 [details]
testcase, formulas in column H should yield 255 each
Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:17:22 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 3 Oukcha 2014-05-30 07:47:31 UTC
*** Issue 124996 has been marked as a duplicate of this issue. ***
Comment 4 mroe 2014-06-19 15:59:44 UTC
*** Issue 125082 has been marked as a duplicate of this issue. ***
Comment 5 Marcus 2017-05-20 10:44:04 UTC
Reset the assignee to the default "issues@openoffice.apache.org".