https://bugs.documentfoundation.org/show_bug.cgi?id=101250
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #3 from m.a.riosv <[email protected]> ---
As in comment #1, is needed to verify that used functions admit joined ranges.
INDEX() admit joined ranges, explicitly described in their help:
https://help.libreoffice.org/Calc/Spreadsheet_Functions#INDEX
but COLUMNS() seems not, it is not mentioned in their help:
https://help.libreoffice.org/Calc/Spreadsheet_Functions#COLUMNS
and gives an error, even entering addresses of the joined ranges in the
function instead a named range.
So except you are sure that COLUMNS() it's designed to accept joined range,
there is not a bug.
If you are not agree, reopen it.
But please first ask on the forum, also to know what the formula does,
please look for help in the forum, https://ask.libreoffice.org/en/questions/
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
