Bug 97944 - Formula COUNTIF in portuguese version
Summary: Formula COUNTIF in portuguese version
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.8.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-17 19:46 UTC by Vinícius Policarpo
Modified: 2016-02-17 20:57 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 Vinícius Policarpo 2016-02-17 19:46:40 UTC 
When using LibreOffice Calc 4.2.8 I've found a bug concerning the formula "countif" ("cont.se" in portuguese). The outcome is logical rather than a number, as I see the system is reading it as an "IF" formula.
Comment 1 Julien Nabet 2016-02-17 20:08:55 UTC 
4.2.8 version is outdated. Please give a try to a more recent LO version (last stable one is 5.0.4 or brand new 5.1.0)
Comment 2 Eike Rathke 2016-02-17 20:47:21 UTC 
More likely the cell is formatted to boolean instead of number, check the applied number format.
Comment 3 Vinícius Policarpo 2016-02-17 20:52:33 UTC 
(In reply to Eike Rathke from comment #2)
> More likely the cell is formatted to boolean instead of number, check the
> applied number format.

Eike Rathke, you're right, my problem was the cell format! thanks!

(In reply to Julien Nabet from comment #1)
> 4.2.8 version is outdated. Please give a try to a more recent LO version
> (last stable one is 5.0.4 or brand new 5.1.0)

I've just updated the suite. thanks!
Comment 4 Julien Nabet 2016-02-17 20:57:39 UTC 
Thank you for your feedback, let's put this one as NOTABUG.