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.
>
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
Hi all,
For Bug 96923 (https://bugs.documentfoundation.org/show_bug.cgi?id=96923),
we need someone with Excel.
The purpose is to check if Excel treat numbers written as text (with '
before) like numeric 1 in SUMIFS.
If it is the case, can somenone provide a short file with mixed value:
1 written
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
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
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
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