Issue 117389 - OFFSET of external reference doesn't work with expressions as arguments for rows, columns, height, width.
Summary: OFFSET of external reference doesn't work with expressions as arguments for r...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 124996 125082 (view as issue list)
Depends on: 103331
Blocks:
  Show dependency tree
 
Reported: 2011-03-15 14:35 UTC by ooo
Modified: 2017-05-20 10:44 UTC (History)
4 users (show)

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


Attachments
testcase, formulas in column H should yield 255 each (8.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-03-15 14:39 UTC, ooo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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".