[Libreoffice-qa] [QA] Need someone having Excel

[Eike Rathke]

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.
> =COUNTIF(range;1)
> =COUNTIF(range;"1")
> =COUNTIF(range;"=1")
> provides the same result in Excel with range having text data while Calc
> count only numerical values for the 1st one.
> 
> This apply to COUNTIF(S) and SUMIF(S).
> 
> What is the opinion of dev's about this (Eike or another)? Should we comply
> to Excel in this case or not ?

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 change it for interoperability.

  Eike

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/
Care about Free Software, support the FSFE https://fsfe.org/support/?erack
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/libreoffice-qa/attachments/20160115/2d242e94/attachment.sig>