Issue 38413 - INDIRECT() does not work in cell range specification
Summary: INDIRECT() does not work in cell range specification
Status: CLOSED DUPLICATE of issue 4904
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-12-04 04:27 UTC by urlgrrrl
Modified: 2004-12-08 14:39 UTC (History)
1 user (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 urlgrrrl 2004-12-04 04:27:26 UTC 
The following formula imported from Excel returns Err:508:
    =CORREL($G60:INDIRECT(CONCATENATE("g"&F6));H60:INDIRECT(CONCATENATE("h"&F6)))

After experimenting, the problem appears to be with specifying the cell ranges
using INDIRECT.  Rewriting the formula as follows does work:
    =CORREL($G60:G244;H60:H244)

This problem was reproducted in OOo 2.0 (1.9.62) of 12 Nov.
Comment 1 frank 2004-12-08 14:39:18 UTC 
Hi,

this is a double to Issue 4904

Frank

*** This issue has been marked as a duplicate of 4904 ***
Comment 2 frank 2004-12-08 14:39:51 UTC 
closed double