Apache OpenOffice (AOO) Bugzilla – Issue 102383
address() result doesn't work as 2nd arg in cell()
Last modified: 2013-12-18 14:19:11 UTC
(note, locale is it_IT) according to the guide, this formula should work: =CELLA("contents";INDIRIZZO(1;2*(RIF.RIGA()-1);1;1;"Foglio1")) ie in EN =CELL("contents";ADDRESS(1;2*(RIF.ROW()-1);1;1;"Sheet1")) as it does work in INDIRETTO() (EN: INDIRECT() ): =INDIRETTO(INDIRIZZO(1;2*(RIF.RIGA()-1);1;1;"Foglio1")) as both function expect a cell ref as text; eg if the above ADDRESS() returns Sheet1.$B$3 then INDIRECT(ADDRESS(...)) will work like manually writing in the cell ref, ie INDIRECT(Sheet1.$B$3), whereas CELL(..., ADDRESS(...)) yields an error "#REF!" and CELL(..., Sheet1.$B$1) does work. Looking at the docs and function tips I don't see any error in function usage, thus it looks like a bug in CELL(). I was using 2.4 in Linux, thought it's a bug fixed in 3.x then checked latest 3.1 in XP but with same results. thx
Please attach a document with all that formulas. Then I can open it an English version; the function names will be translated then.
You know, that the second parameter of CELL must be a reference, but ADDRESS returns a text?
> You know, that the second parameter of CELL must be a reference, but ADDRESS > returns a text? indeed - ack. Well, terms used in function wizard and help are the same ("Riferimento" = "Reference"), rather confusiong IMHO. Re-checking, eventually maybe I got it right: (in a cell) =INDIRECT(ADDRESS(...)) is equivalent to =CELL("contents"; INDIRECT(ADDRESS(...))) the point is, that help/wizard say that INDIRECT() returns the *contents* of the cell, whereas it actually returns the *reference* to the cell. So the bug seems to be poor/bad wording in docs - to my understanding, of course. I suggest to make it clearer in the f.wizard, with labels like Reference: and Reference (as "text"): in due cases. thx (test .odf seems unneeded at this point, though I'm attaching it anyway)
Created attachment 62660 [details] some test case for indirect() and cell() and address()
This Issue requires more information ('needmoreinfo'), but has not been updated within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download Please report back the outcome of your testing, so this Issue may be closed or progressed as necessary - otherwise the issue may be Resolved as Invalid in the future.
bug way too old, guess/hope OOO help/f.wizard has been improved to correct ambiguity. Can't install latest, running just a small netbook with SO8.0 preinstalled. Better close the ticket as you please. thx
INDIRECT function Function Wizard: "Returns the contents of a cell that is referenced in text form." OpenOffice Help: "Returns the reference specified by a text string." AOO410m1(Build:9750) - Rev. 1551264 2013-12-17_04:10:52 - Rev. 1551455 Debian