Re: [libreoffice-users] Re: lost opportunity

[libreoffice-ml . mbourne]

Urmas - davian...@gmail.com wrote:

05.11.2015 23:19, Tom Davies:


For some weird reason IE decided to
rename the downloads from ".msi" to another format.


That 'weird reason' was the error in the default webserver configuration
which no one of LO people cared to fix.


When that problem occurs, it's due to specific mirrors being 
misconfigured, not LibreOffice's own servers. If the faulty mirror can 
be identified and reported, they do work with the mirror operator to fix 
it, e.g.:




I've just downloaded LibreOffice 5.0.3 from the University of Texas 
mirror (the only one I can see explicitly mentioned in this thread) 
using IE:


It saves with a .msi extension and checksums match, so there doesn't 
appear to be a problem with that mirror.


Mark.


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: lost opportunity

[Urmas]

05.11.2015 23:19, Tom Davies:

> For some weird reason IE decided to
> rename the downloads from ".msi" to another format.

That 'weird reason' was the error in the default webserver configuration
which no one of LO people cared to fix.




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Need a count formula for calc

[Robert Peirce]

I have two columns of data, A and B.  Sometimes A.n>B.n, A.nA.n=B.n.  I want to count these occurrences.  The closest I could find 
in help was countif(), but that doesn't really do what I need.  Any ideas?



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Need a count formula for calc

[Johnny Rosenberg]

I think I found it.

In A1:B1 enter your values. It doesn't matter if not all rows are
filled.
Enter the following in the following cells:
C1: A>B
C2: A=B
C3: AB1:B1)*(ISNUMBER(A1:A1))*(ISNUMBER(B1:B1)))
D2: =SUM((A1:A1=B1:B1)*(ISNUMBER(A1:A1))*(ISNUMBER(B1:B1)))
D3: =SUM((A1:A1:

> And again…
> -- Forwarded message --
> From: Johnny Rosenberg 
> Date: 2015-11-07 18:39 GMT+01:00
> Subject: Re: [libreoffice-users] Need a count formula for calc
> To: Robert Peirce 
>
>
> The following works for 1 rows or less.
> {=SUM(IF(A1:A1>B1:B1;1;0))}
> {=SUM(IF(A1:A1=B1:B1;1;0))-SUM(IF(A1:A1="";1;0))}
> {=SUM(IF(A1:A1 The exception is if there are rows where the A value is empty and the B
> value is not.
>
> For some reason, this didn't work:
>
> {=SUM(IF(A1:A1=B1:B1;1;0))-SUM(IF(OR(A1:A1="";B1:B1="");1;0))}
>
> I'll see if I can improve this a bit more. Not good enough yet, I think…
>
>
> Johnny Rosenberg
>
> 2015-11-07 18:19 GMT+01:00 Johnny Rosenberg :
>
>> 2015-11-07 17:44 GMT+01:00 Robert Peirce :
>>
>>> I have two columns of data, A and B.  Sometimes A.n>B.n, A.n>> A.n=B.n.  I want to count these occurrences.  The closest I could find in
>>> help was countif(), but that doesn't really do what I need.  Any ideas?
>>>
>>
>> Yes, a few ideas. I think the best one is using array formulas.
>> If n is known, this will do the trick (assuming n=1000 in this case):
>> {=SUM(IF(A1:A1000>B1:B1000;1;0))}
>> {=SUM(IF(A1:A1000=B1:B1000;1;0))}
>> {=SUM(IF(A1:A1000>
>> To enter an array formula, enter the formula as usual but instead of
>> hitting Enter when done, hit Ctrl+Shift+Enter.
>> The {} thing is added automatically, you should not enter them manually.
>>
>> The downside with my example here is when there are empty cells in
>> A1:B1000. That means that if n is not known, you can't just select a high
>> number, such as A1:A100, because all empty rows will be considered A=B…
>>
>> I've only been playing with this for a couple of minutes yet so I am not
>> sure how to solve that, but I'm pretty sure it's possible.
>>
>> I'll write back if I find a solution to that before anyone else does, but
>> I'm not sure how much time I will spend on this…
>>
>>
>> Johnny Rosenberg
>>
>>
>>>
>>> --
>>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>>> Problems?
>>> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>>> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
>>> List archive: http://listarchives.libreoffice.org/global/users/
>>> All messages sent to this list will be publicly archived and cannot be
>>> deleted
>>>
>>
>>
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Fwd: Need a count formula for calc

[m.a.riosv]

I think for not take care of the number of blank cells, it's easier and
versatile with SUMPRODUCT()

=SUMPRODUCT($A$2:$A$12>$B$2:$B$12;$A$2:$A$12>0;$B$2:$B$12>0)

Attached a sample file.

Miguel Ángel.



--
View this message in context: 
http://nabble.documentfoundation.org/Need-a-count-formula-for-calc-tp4165581p4165604.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted