Issue 71455 - How to handle OOo -> xls -> OOo for incompatible functions (eg INDIRECT/INDIRECT_XL)
Summary: How to handle OOo -> xls -> OOo for incompatible functions (eg INDIRECT/INDIR...
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.0.4
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on: 20857 30172
  Show dependency tree
Reported: 2006-11-12 00:51 UTC by demeterft
Modified: 2013-07-30 02:43 UTC (History)
7 users (show)

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

demonstration of the bug in INDIRECT_XL (8.52 KB, application/vnd.oasis.opendocument.formula)
2006-11-12 00:52 UTC, demeterft
no flags Details
minor patch (512 bytes, patch)
2006-12-01 18:31 UTC, jodygoldberg
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description demeterft 2006-11-12 00:51:10 UTC
The result of the INDIRECT_XL will be Error:502 if the name of the referenced
sheet contains accentuated letter:


Name of the 1st sheet: Munkalap
Name of the 2nd sheet: Ékezetes
Cell H1 on 1st sheet: 100
Cell H1 on 2nd sheet: 50
Cell H4 on 1st sheet: Munkalap!H1
Cell H6 on 1st sheet: Ékezetes!H1
Cell C4 on 1st sheet: =INDIRECT_XL(H4)
Cell C6 on 1st sheet: =INDIRECT_XL(H6)

The C4 will show 100 and the C6 will show Error:502
Comment 1 demeterft 2006-11-12 00:52:53 UTC
Created attachment 40521 [details]
demonstration of the bug in INDIRECT_XL
Comment 2 demeterft 2006-11-12 00:59:20 UTC
Oops, I forgot to mention I use the Hungarian version of the product. 

Comment 3 ooo 2006-11-13 01:09:07 UTC
Hi Jody,

As upstream OOo doesn't have INDIRECT_XL this seems to be yours.

Comment 4 jodygoldberg 2006-11-15 17:15:54 UTC
The problem will be with the new XL style parsing that went in with the r1c1 code.
Comment 5 jodygoldberg 2006-12-01 18:31:08 UTC
Created attachment 41055 [details]
minor patch
Comment 6 jodygoldberg 2006-12-01 18:32:34 UTC
Yes I realize that this adds exactly the performance degradation that I just
submitted a patch for :-)
Fixing that will require more of an interface change in the XL style header parsing.
Comment 7 aexl 2006-12-15 17:13:30 UTC
There seem to be some related issues with indirect_xl:
(i think it might be better to bundle them here)
- using indirect("$Table1.a1"), exporting table to .xls, and opening with OOo ,
gives indirect_xl("$Table1.a1") resulting in an error 502. expected result:
(NOTE: these are in fact 2 issues, "$" (which excel does not know) and "."(OOo)
/ "!" (excel)
Comment 8 jodygoldberg 2007-03-02 16:40:30 UTC
aexl : I would look at the problems differently.  The issue is not that
INDIRECT_XL can not handle OOo style parsing.  We may not want to export it to
XL as INDIRECT at all.

ps In the future let's open a distinct bug

Comment 9 stx123 2007-07-11 20:55:28 UTC
Is somebody picking this up for Jody?
Comment 10 mmeeks 2007-07-12 10:54:55 UTC
Jon - we should push this onto your work queue too - though you'll need an MSDN
license & Office copy somewhere to get into this. 
Comment 11 kpalagin 2008-03-15 17:01:01 UTC
Is somebody taking care of this patch?
Comment 12 ooo 2008-03-17 13:58:46 UTC
@kpalagin: upstream OOo doesn't have INDIRECT_XL, so there's nothing to take
care of.

Note that ODFF defines INDIRECT and ADDRESS to be Excel compatible, this entire
ADDRESS_XL and INDIRECT_XL differentiation will be moot in future.
Comment 13 Rob Weir 2013-03-11 15:02:40 UTC
I'm adding this comment to all open issues with Issue Type == PATCH.  We have 220 such issues, many of them quite old.  I apologize for that.  

We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0.

If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know.

On the other hand, if the patch is no longer relevant, please let us know that as well.

If you have any general questions or want to discuss this further, please send a note to our dev mailing list:


Comment 14 Rob Weir 2013-07-30 02:43:18 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.