https://bugs.freedesktop.org/show_bug.cgi?id=76440
Priority: medium
Bug ID: 76440
Assignee: [email protected]
Summary: COUNTIF broken when applied on database ranges
imported from registered source
Severity: major
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.2.1 release
Component: Spreadsheet
Product: LibreOffice
To reproduce:
1. Import a set of data from Bibliography source using datasource panel (F4).
2. A database range is created, called something like "Import1"
3. Insert a simple COUNTIF formula pointing to that database range (f.ex.
COUNTIF($A$1:$A$10;A1) if first cell of range is A1)
Result:
COUNTIF return 0 in all cases
Notes:
1. If the cell pointed by the condition argument af the COUNTIF formula is
edited, then correct value is then displayed correctly.
If you refresh de database range, then the value displayed after edition is
reset to 0.
2. All works correctly if the condition argument is a regular expression.
Context:
- LibO : 4.2.0.4 and 4.2.2.1 releases
- OS : Windows XP and Windows 7
--
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
