Hi,
El 15/01/16 a las 12:31, Eike Rathke escribió:
> Hi,
>
> On Thursday, 2016-01-07 13:20:25 -0700, Gérard Fargeot wrote:
>
> My take on that is that COUNTIF(range;1) queries a numeric value.
> But if Excel does it different and therefor users expect the same
> behavior we probably have to c
Hi,
On Thursday, 2016-01-07 13:20:25 -0700, Gérard Fargeot wrote:
> The reporter first, yhen Joel close yhe bug report.
> I'm not sure this is a good idea. The screenshot provided by Miroslav show
> that Excel handles functions in the same way whether the argument either
> text or number.
> =COUN
Related links.
http://erack.org/blog/archives/40-LibreOffice-4.3-new-Calc-feature-user-selectable-text-conversion-models.html
https://wiki.documentfoundation.org/ReleaseNotes/4.3#User_selectable_text_conversion_models
https://bugs.documentfoundation.org/show_bug.cgi?id=37132
https://bugs.docume
On 01/07/2016 12:20 PM, Gérard Fargeot wrote:
> The reporter first, yhen Joel close yhe bug report.
> I'm not sure this is a good idea. The screenshot provided by Miroslav show
> that Excel handles functions in the same way whether the argument either
Just to clarify, I closed it after someone el
The reporter first, yhen Joel close yhe bug report.
I'm not sure this is a good idea. The screenshot provided by Miroslav show
that Excel handles functions in the same way whether the argument either
text or number.
=COUNTIF(range;1)
=COUNTIF(range;"1")
=COUNTIF(range;"=1")
provides the same result
Hi Gerard,
about comment in A4, If I'm not wrong, modify cell format never changes the
cell content. Formatting the cell as text after enter a number or a formula,
it doesn't convert them to text.
about the criteria as number only summing for numbers in the criteria range,
I think in calc interpr
