https://bugs.documentfoundation.org/show_bug.cgi?id=127624
--- Comment #12 from Winfried Donkers ---
(In reply to Julien Nabet from comment #11)
> > (see uploaded document, rows 3..6)
> Except using "isNumeric"/"isText" function, how to distinguish them and
> above all how to change them?
> I
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
--- Comment #11 from Julien Nabet ---
(In reply to Winfried Donkers from comment #10)
> Created attachment 154277 [details]
> simplified use cases
>
> (In reply to Julien Nabet from comment #5)
>
> I can explain what happens:
> -if
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
Winfried Donkers changed:
What|Removed |Added
CC||winfrieddonkers@libreoffice
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
m.a.riosv changed:
What|Removed |Added
CC||miguelangelrv@libreoffice.o
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
--- Comment #8 from Oliver Brinzing ---
Created attachment 154268
--> https://bugs.documentfoundation.org/attachment.cgi?id=154268=edit
countif_excel_vs_lo
excel results to "4" in all cases, but warns about values formatted as text
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
Oliver Brinzing changed:
What|Removed |Added
CC||oliver.brinz...@gmx.de
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
Alain Touret changed:
What|Removed |Added
Ever confirmed|1 |0
Status|NEEDINFO
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
Julien Nabet changed:
What|Removed |Added
CC||o...@dci-electronics.nl
---
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
--- Comment #4 from Julien Nabet ---
2 cells are Text, 2 cells are numbers
To check this, you can type in H3:
=ESTTEXTE(E3)
Then copy the formula for the others.
Now why count.if takes into account Text + number if Text in criteria and
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
--- Comment #3 from Alain Touret ---
I tried the same on the 6.2.6.2 version of LibreOffice on Linux (build
1:6.2.6-0ubuntu0.19.04.1): the same behavior was observed.
I tried something more:
1) I added a first column to compare two
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
--- Comment #2 from Alain Touret ---
Created attachment 154262
--> https://bugs.documentfoundation.org/attachment.cgi?id=154262=edit
a calc file that exhibits the buggy behavior
--
You are receiving this mail because:
You are the
https://bugs.documentfoundation.org/show_bug.cgi?id=127624
Julien Nabet changed:
What|Removed |Added
CC||serval2...@yahoo.fr
12 matches
Mail list logo