Apache OpenOffice (AOO) Bugzilla – Issue 71455
How to handle OOo -> xls -> OOo for incompatible functions (eg INDIRECT/INDIRECT_XL)
Last modified: 2013-07-30 02:43:18 UTC
The result of the INDIRECT_XL will be Error:502 if the name of the referenced sheet contains accentuated letter: Example: 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
Created attachment 40521 [details] demonstration of the bug in INDIRECT_XL
Oops, I forgot to mention I use the Hungarian version of the product.
Hi Jody, As upstream OOo doesn't have INDIRECT_XL this seems to be yours. Eike
The problem will be with the new XL style parsing that went in with the r1c1 code.
Created attachment 41055 [details] minor patch
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.
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: indirect_xl("Table1!a1") (NOTE: these are in fact 2 issues, "$" (which excel does not know) and "."(OOo) / "!" (excel)
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
Is somebody picking this up for Jody?
Jon - we should push this onto your work queue too - though you'll need an MSDN license & Office copy somewhere to get into this.
Is somebody taking care of this patch?
@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.
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: dev@openoffice.apache.org Thanks! -Rob
Reset assignee on issues not touched by assignee in more than 1000 days.