Bug 108978 - countif conditions does not work correct when data are loaded from a .xls file
Summary: countif conditions does not work correct when data are loaded from a .xls file
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.0.1 rc
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-07-05 20:53 UTC by Alfredo
Modified: 2017-08-10 18:43 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Alfredo 2017-07-05 20:53:37 UTC 
Loading data from a .xls file COUNTIF works only if the condition is defined in the selected range.
A condition defined in a different cell or within the formula does not work.

example
A  B
1  1
1
2
3
4

COUNTIF(A1:A5;1) => 0 -> wrong
COUNTIF(A1:A5;B1) => 0 -> wrong
COUNTIF(A1:A5;&B1) => ### -> wrong

COUNTIF(A1:A5;A1) => 2 -> correct

When I add a separate ranges manually COUNTIF works correct
This seems to be a character encoding problem 

Also loading the data from a csv file ISO-8859-15 encoded COUNTIF works correct
Comment 1 m_a_riosv 2017-07-06 00:00:59 UTC 
Please can you attach a sample file to test?
Comment 2 Alfredo 2017-08-10 18:07:08 UTC 
seems to be fixed in Version: 5.4.0.3
I cannot reproduce this behaviour