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

2016-01-15 Thread 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


signature.asc
Description: PGP signature
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

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

2016-01-15 Thread m.a.riosv 
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 change it for interoperability.
>
>   Eike

Some thoughts:

1) How to avoid break for people having a number as text in a cell, to have
the value without being taken into account in formulas/functions.

1) It makes more complicated to have a criteria for countif only numbers, if
there are a mix of numbers and numbers as text.

2) To have a consistent interpretation,  I think it implies change the
evaluation of text as numbers, from only direct references to consider every
reference in array ranges as a direct reference.

3) What to do with functions like SUM(), evaluate always, when introduced as
array, never.

I think it is a deep change on the restricted behavior, that merits a deep
and reposed discussion.

In ODF 1.2,
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017988_715980110,
"
6.3.5Conversion to Number

If the expected type is Number, then if value is of type:

●Number, return it. 

●Logical, return 0 if FALSE, 1 if TRUE. 

●Text: The specific conversion is implementation-defined; an evaluator
may return 0, an Error value, or the results of its attempt to convert the
Text value to a Number (and fall back to 0 or Error if it fails to do so).
Evaluators may apply VALUE() or some other function to do this conversion,
should they choose to do so. Conversion depends on the actual locale the
application runs in, especially if group or decimal separators are involved.
"

Should be numbers what are numbers for VALUE()?, so we can test/know when
the conversion will be done. Should it be in any kind of reference or range
reference?

NumberAsTextInFormulas.ods
 
 



--
View this message in context: 
http://nabble.documentfoundation.org/QA-Need-someone-having-Excel-tp4171047p4171893.html
Sent from the QA mailing list archive at Nabble.com.
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] [ANN] LibreOffice 5.1.0 RC2 available

2016-01-15 Thread Tommy 

Christian Lohmaier wrote:

Dear Community,

The Document Foundation is pleased to announce the second release
candidate of LibreOffice 5.1.0.
...


bugzilla 5.1.0.2 rc item created


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/