https://bugs.freedesktop.org/show_bug.cgi?id=71325
--- Comment #7 from Ady <[email protected]> --- (In reply to comment #6) > I believe this should be an array formula. > The first argument, 'reference' is always required. > Only as 'array' is a result returned when this parameter is used on its own. > When 'row' is then added both 'simple' and 'array' return results. > Same when 'column' is added with 'row' so that both are present. > Only as 'array' is a result returned with 'row' 0 or omitted and 'column' > present. > Your own comments are reinforcing the need to improve the current help documents for the INDEX function in Calc. > If you read the ODF spec. for this function here; > http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2. > html#INDEX > I think you will appreciate why it ought to be an 'array'. Well, I still read the same as before. It says "ReferenceList|Array DataSource", meaning that the *DataSource* can be either a *reference* (simple formula) or an *array* (array formula). So, again, INDEX can be used in a simple formula or in an array formula. > > I am still of the opinion this should be passed to the devs as a bug to > allow them to determine just what the function should do. IMHO, the function itself is already defined and it seems to be working as defined, so I see this as a documentation problem in Calc. Perhaps the Status of this bug report should be changed and some QA group should be cc'd. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
