Issue 53262 - function INDIRECT produces ERR 508 when using a range
Summary: function INDIRECT produces ERR 508 when using a range
Status: CLOSED DUPLICATE of issue 4904
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on: 53263
Blocks:
  Show dependency tree
 
Reported: 2005-08-12 19:34 UTC by opp
Modified: 2005-09-13 10:19 UTC (History)
2 users (show)

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


Attachments
Function INDIRECT produces ERR 508 when used as argument in ranges (6.67 KB, application/vnd.sun.xml.calc)
2005-08-12 19:39 UTC, opp
no flags Details

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