Issue 101645 - INDIRECT function produces Err:502 for external links since OO 3.1
Summary: INDIRECT function produces Err:502 for external links since OO 3.1
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO310m11
Hardware: All All
: P3 Trivial with 10 votes (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
Keywords: oooqa, regression
: 102399 104969 (view as issue list)
Depends on:
Blocks: 101565
  Show dependency tree
Reported: 2009-05-07 14:34 UTC by skstorch
Modified: 2013-08-07 15:15 UTC (History)
6 users (show)

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

file containing the error (7.31 KB, text/plain)
2009-05-07 14:35 UTC, skstorch
no flags Details
file containing the data linked to (6.53 KB, text/plain)
2009-05-07 14:36 UTC, skstorch
no flags Details
contains source and target file to see the error, unpack and open ziel.ods (21.08 KB, application/x-compressed)
2009-05-17 18:40 UTC, Regina Henschel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description skstorch 2009-05-07 14:34:58 UTC
Since I updated to 3.1, the Calc function "INDIRECT" does not work with links to
different files any more. This used to work up to 3.0.

1. I create (in cell A1) a direct link to a cell in an external .ods file by
typing "=" and then left-clicking a cell in the other file.
2. I create a cell holding the link-url as a string by adding double quotation
marks around the link url in the formula from 1.
3. I type "INDIRECT(A1)" and get an Err:502
Comment 1 skstorch 2009-05-07 14:35:42 UTC
Created attachment 62074 [details]
file containing the error
Comment 2 skstorch 2009-05-07 14:36:20 UTC
Created attachment 62075 [details]
file containing the data linked to
Comment 3 Regina Henschel 2009-05-07 17:48:58 UTC
I confirm the error for OODEVm47 too. I have tried several variants: with and
without blank in the address and with and without second parameter. It fails always.
Comment 4 jbf.faure 2009-05-10 08:08:04 UTC
Is it in its specifications that the INDIRECT function must accept external links ? 
It is not clear for me from

Kind regards
Comment 5 skstorch 2009-05-10 13:42:38 UTC
Might not be in the specs, but having stuff working in 3.0 and not in 3.1 is 
surely not something the developers consider an improvement ;-)
Comment 6 oc 2009-05-11 07:55:17 UTC
Hi Eike, please have a look
Comment 7 jean_francois_philip 2009-05-13 21:45:08 UTC

The INDIRECT fonction is more important, please, resolve it on 3.1.1 if it is
Vista is impacted too (all Windows OS ? ).

Comment 8 jbf.faure 2009-05-17 17:49:49 UTC
Hi skstorch,

It seems there is a sysntax error in your bugdoc : INDIRECT function needs a
reference specified as text : =INDIRECT("A1") instead of =INDIRECT(A1)

In your bugdoc, changing A3=INDIRECT(A2) in A3=INDIRECT("A2") fixes the error.
Is it correct for you ?

Comment 9 Regina Henschel 2009-05-17 18:38:58 UTC
It is not a systax error. INDIRECT("A2") will give you the content of the cell
A2. INDIRECT(A2) gives you the content of the cell, which reference is in A2.

I'll attach a zip-file. It contains two files. Open the file ziel.ods in
OOo3.0.1 and in OOo.3.1 to see the difference.
Comment 10 Regina Henschel 2009-05-17 18:40:47 UTC
Created attachment 62330 [details]
contains source and target file to see the error, unpack and open ziel.ods
Comment 11 jbf.faure 2009-05-17 21:02:07 UTC
Thanks Regina, I now understand and I think this bug should be fixed for OOo 3.1.1.

Kind regards
Comment 12 andorko 2009-05-29 22:54:35 UTC
The DDE function appears to work fine as a workaround.

YMMV, haven't tried with MS Excel documents.
Comment 13 Regina Henschel 2009-05-31 19:21:57 UTC
*** Issue 102399 has been marked as a duplicate of this issue. ***
Comment 14 Olaf Felka 2009-06-10 10:14:47 UTC
adjusting target
Comment 15 ooo 2009-06-18 18:26:20 UTC
Issue added to CWS dr68ooo311.
Comment 16 ooo 2009-06-24 17:08:57 UTC
In cws dr68ooo311:

revision 273296

revision 273358
Comment 17 ooo 2009-06-29 13:38:18 UTC
Also in cws calc51 for OOo3.2:

revision 273474
Comment 18 ooo 2009-07-03 16:10:15 UTC
Reassigning to QA for verification.

Note that the file name of the referred document is displayed wrongly, which is
issue 103317
Comment 19 oc 2009-07-13 14:27:29 UTC
verified in internal builds cws_dr68ooo311 and cws_calc51
Comment 20 amy2008 2009-08-07 03:51:18 UTC
Verified in DEV300m54 on WinXP
Comment 21 ooo 2009-09-23 16:28:58 UTC
*** Issue 104969 has been marked as a duplicate of this issue. ***