https://bugs.freedesktop.org/show_bug.cgi?id=77728
Priority: medium
Bug ID: 77728
Assignee: [email protected]
Summary: Countif and Countifs Not Counting Second Set of Added
Data
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.4.1 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 97689
--> https://bugs.freedesktop.org/attachment.cgi?id=97689&action=edit
Countif and Countifs Example
Windows 7 64 Home Premium SP1; LibreOffice 4.2.4.1 (RC1) and 4.2.3
The countif and countifs functions are not counting second and subsequent rows
of data entered by copying, autocomplete, or via the selection list.
Attached example has two sheets: data and summaries. On the data sheet, the
Fruit column is named Fruit_Data and the season column is named Season_Data.
The data contains a dummy row, above which new rows are to be inserted. The
summaries sheet counts the number of fruits (countif) and fruits plus seasons
(countifs). The data sheet contains four entries for apples and three for
pears; plus two apples with the season autumn, two apples with winter, and
three pears with autumn.
Insert one row above the dummy row and enter, say, "Pears" and "Autumn"; the
countif and countifs update.
Close and re-open the file. Insert two rows and enter, say, "Pears" and
"Autumn" in both rows. The countif and countifs functions do not count the
second row. even if the second additional row data is changed from "Pears" and
"Autumn" to, say, "Apples" and "Winter" via copying, autocomplete or the
selection list, the functions do not update. Changing the first additional row
data results in the functions updating (although they still ignore the second
additional data row).
--
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
