Issue 56051

Summary:	Indirect() function inside SUM()
Product:	Calc	Reporter:	cerulli <r.cerulli>
Component:	programming	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues, rb.henschel
Version:	OOO 2.0 Beta2	Keywords:	oooqa
Target Milestone:	---
Hardware:	All
OS:	Windows XP
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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