Apache OpenOffice (AOO) Bugzilla – Issue 101645
INDIRECT function produces Err:502 for external links since OO 3.1
Last modified: 2013-08-07 15:15:15 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. Example: 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
Created attachment 62074 [details] file containing the error
Created attachment 62075 [details] file containing the data linked to
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.
Is it in its specifications that the INDIRECT function must accept external links ? It is not clear for me from http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula Kind regards JBF
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 ;-)
Hi Eike, please have a look
Hi, The INDIRECT fonction is more important, please, resolve it on 3.1.1 if it is possible. Vista is impacted too (all Windows OS ? ). Regards
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 ? Regards JBF
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.
Created attachment 62330 [details] contains source and target file to see the error, unpack and open ziel.ods
Thanks Regina, I now understand and I think this bug should be fixed for OOo 3.1.1. Kind regards JBF
The DDE function appears to work fine as a workaround. =DDE("soffice","/home/me/tmp/test1.ods","Sheet1.A1") YMMV, haven't tried with MS Excel documents.
*** Issue 102399 has been marked as a duplicate of this issue. ***
adjusting target
Issue added to CWS dr68ooo311.
In cws dr68ooo311: revision 273296 sc/inc/address.hxx sc/source/core/tool/address.cxx sc/source/core/tool/interpr1.cxx sc/source/core/tool/interpr4.cxx revision 273358 sc/inc/externalrefmgr.hxx sc/source/core/data/documen4.cxx sc/source/core/tool/interpr1.cxx sc/source/ui/docshell/externalrefmgr.cxx
Also in cws calc51 for OOo3.2: revision 273474 sc/inc/address.hxx sc/inc/compiler.hxx sc/inc/externalrefmgr.hxx sc/source/core/data/documen4.cxx sc/source/core/data/table3.cxx sc/source/core/inc/interpre.hxx sc/source/core/tool/address.cxx sc/source/core/tool/compiler.cxx sc/source/core/tool/interpr1.cxx sc/source/core/tool/interpr4.cxx sc/source/ui/docshell/externalrefmgr.cxx
Reassigning to QA for verification. Note that the file name of the referred document is displayed wrongly, which is issue 103317
verified in internal builds cws_dr68ooo311 and cws_calc51
Verified in DEV300m54 on WinXP Closing
*** Issue 104969 has been marked as a duplicate of this issue. ***