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."
Reproducible with: Win7x64 Ultimate Autofill - Date - Months' wrong if day of month exceeds max. days of month
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.