https://bugs.freedesktop.org/show_bug.cgi?id=71325
--- Comment #6 from John Smith <[email protected]> --- (In reply to comment #5) > (In reply to comment #3) > > Perhaps this can be put forward as a bug to > > have the Array check-box automatically selected as it is for functions such > > as MMULT, GROWTH and TREND > > I have to disagree. INDEX is not always an array formula. > > When INDEX is used as an array function, the first argument is required and > the rest are optional. > > When INDEX is used as simple function, both row and column arguments are > required, and there are no "default" values for these 2 arguments (not > "zero" nor "one"). > > IMHO, this is a documentation problem only, thus the doc's team should be > cc'd and the description of the bug should be changed accordingly. 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. 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'. 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. -- 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
