https://bugs.freedesktop.org/show_bug.cgi?id=66409
Priority: medium
Bug ID: 66409
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: failure to correctly implement CELL
Severity: normal
Classification: Unclassified
OS: All
Reporter: aguel...@pyrshep.ca
Hardware: Other
Status: UNCONFIRMED
Version: 3.4.5 release
Component: Spreadsheet
Product: LibreOffice
In LO enter the following in A1:
=CELL("col",C5:C7)
and in A2:
=CELL("col",C5)
A2 shows, as expected, 3. A1 on the other hand showws #VALUE! It appears that
LO uses implicit intersection and fails since C5:C7 does not interset with row
1. This contravenes the ODF definition, see ODF 1.2 part 2 6.13.3:
"R : if R is a reference to a cell, it is the cell whose information will be
returned; if R is a reference to a range, the top-left cell in the range is the
selected one; if R is omitted, the current cell is used."
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
