https://bugs.freedesktop.org/show_bug.cgi?id=82011
Priority: medium
Bug ID: 82011
Assignee: [email protected]
Summary: CountIf and CountIfs not updating following data
deletion
Severity: critical
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.3.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 103816
--> https://bugs.freedesktop.org/attachment.cgi?id=103816&action=edit
Countif/Countifs Deleted Data Example
Windows 7 Home Premium SP1
Deleting a row in a named range which is used by CountIf/CountIfs does not
update the function's result (the results are updated when new data is added).
Forcing a recalculation using F9 does not update the result, however, saving
and re-opening the file does update the result.
The attached example contains, in sheet 1, a list of vegetables and seasons.
Sheet 2 contains a list and a count of the vegetables. Sheet 3 a list of the
vegetables and seasons with a count.
In sheet1 there are three entries for cabbage and two for cabbage in the
spring. Sheet2 (CountIf) calculates there are three entries for cabbage.
Sheet 3 (CountIfs) calculates there are two entries for cabbage in the spring.
Delete in sheet 1 an entry for cabbage in the spring and sheets 2 and 3 do not
update the corresponding results.
--
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
