Bug 66409

Summary: failure to correctly implement CELL
Product: LibreOffice Reporter: Andreas J Guelzow <aguelzow>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: mariosv
Version: 3.4.5 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:

Description Andreas J Guelzow 2013-06-30 18:27:57 UTC
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."
Comment 1 m.a.riosv 2013-06-30 21:53:48 UTC
Reproducible with:
Win7x64 Ultimate
Autofill - Date - Months' wrong if day of month exceeds max. days of month
Comment 2 A (Andy) 2014-09-27 10:15:47 UTC
Comment 1 was probably not the right response to this bug report.

This issue is reproducible with LO 4.3.2.2 (Win 8.1).  But a correction is necessary: "," needs to be replaced by ";" in the formulas.

The ODF definitions mentions this reference to a range.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.