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