Issue 56051 - Indirect() function inside SUM()
Summary: Indirect() function inside SUM()
Status: CLOSED DUPLICATE of issue 4904
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO 2.0 Beta2
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2005-10-15 09:09 UTC by cerulli
Modified: 2005-10-15 13:48 UTC (History)
2 users (show)

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

Attachments
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 cerulli 2005-10-15 09:09:03 UTC 
Using INDIRECT()location as one of the boundary of a range in SUM, gives a
(misleading) Err:508.
Example =SUM(INDIRECT(I18):E17) where I18 = E14, that should give the sum in the
range (E14:E17), gives an Err:508.
Comment 1 Regina Henschel 2005-10-15 13:47:41 UTC 
OOo cannot use calculation in part of a range adress. The fitting feature
request is issue 4904.

*** This issue has been marked as a duplicate of 4904 ***
Comment 2 Regina Henschel 2005-10-15 13:48:56 UTC 
closing duplicate