Issue 53262

Summary:

function INDIRECT produces ERR 508 when using a range

Product:

Calc

Reporter:

opp <openoffice.org>

Component:

code

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues, rainerbielefeld_ooo_qa

Version:

OOo 2.0 Beta

Keywords:

oooqa

Target Milestone:

---

Hardware:

All

OS:

Windows XP

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Issue Depends on:

53263

Issue Blocks:

Attachments:

Description	Flags
Function INDIRECT produces ERR 508 when used as argument in ranges	none

Description opp 2005-08-12 19:34:26 UTC

When you import a spreadsheet from Excel with the function "INDIRECT" or use the
Excel-Convention for the function "INDIRECT" ERR 508 might occure as follows:

If you use INDIRECT as single arguments it works proper.
If you use INDIRECT within a range-arguments ERR 508 is produced.

Example:

Content of Cell B1 is "2"
Content of Cell C1 is "5"
Content of Cell A1 is â€œ=SUM(INDIRECT(ADDRESS(1;2));INDIRECT(ADDRESS(1;3)))â€
Content of Cell A2 is â€œ=SUM(INDIRECT(ADDRESS(1;2)):INDIRECT(ADDRESS(1;3)))â€

The same happens with the function "INDIRECT" (see extra issue)

Comment 1 opp 2005-08-12 19:39:57 UTC

Created attachment 28710 [details]
Function INDIRECT produces ERR 508 when used as argument in ranges

Comment 2 Rainer Bielefeld 2005-08-13 17:00:52 UTC

I checked with 2.0 (1.9.m122) German version WIN XP: [680m122(Build8941)] and
also with 1.1.4 (German) WIN XP: [645m52 (Build 8824)], both same result.

Seems to be the same problem as in issue 53263 (pls also read comments there!):
SUMME (samd as SUM) does not work for ranage if formula contains INDIRECT, but
it works for discrete values separated by semicolon.

Comment 3 frank 2005-09-13 10:19:10 UTC

it's a double to Issue 4904

please check also the comments on the other duplicates.

*** This issue has been marked as a duplicate of 4904 ***

Comment 4 frank 2005-09-13 10:19:48 UTC

closed double