Bug 76440

Summary: COUNTIF broken when applied on database ranges imported from registered source
Product: LibreOffice Reporter: spYre <jm.zambon>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED FIXED    
Severity: major CC: miguelangelrv
Priority: medium    
Version: 4.2.2.1 release   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description spYre 2014-03-21 10:46:52 UTC 
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
Comment 1 m_a_riosv 2014-03-21 23:14:03 UTC 
Hi spYre, thanks for reporting.

It is fixed for:
Version: 4.2.3.1 Build ID: 3d4fc3d9dbf8f4c0aeb61498a81f91c5b7922f13
Comment 2 spYre 2014-03-21 23:34:54 UTC 
Wow ;-)
Thanks for such a speedy good news.
Comment 3 m_a_riosv 2014-03-21 23:36:12 UTC 
You can download it in:
http://downloadarchive.documentfoundation.org/libreoffice/old/?C=M;O=D