https://bugs.freedesktop.org/show_bug.cgi?id=86219
Bug ID: 86219
Summary: EDITING: MOD (and others) function fails when both
arguments are arrays
Product: LibreOffice
Version: Inherited From OOo
Hardware: Other
OS: All
Status: NEW
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 109368
--> https://bugs.freedesktop.org/attachment.cgi?id=109368&action=edit
sheet with examples of array formula
=MOD(A2:A4;B1:C1) used in array formula returns an array with MOD(A2;B1) in the
1st cell and #VALUE! for all the other cells.
Using onky one array and a scalar for args works correctly. (MOD(A2:A4;B1) for
example.
Other functions expected 2 scalars as argument have the same behavior.
Like CEILING, FLOOR...
I've just used Excel for some weeks 4 years ago (so I'm not 100% sure) and I
think Excel can handle this formula.
--
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
