New spreadsheet functions

[Regina Henschel <rb...@t-online.de>]

Hi all,

it might be overlooked, so I want to draw your attention to the commit 
of CWS calcishmakkica in r1381446 to r1381452 on 5.Sept. 2012. (You 
remember the long lasting attempt to get it?) It contains in the main 
the work of Marina Plakalovic from the OpenOffice.org Summer 2010 
Internship. She has implemented the function XOR, COUNTIFS, AVERAGEIFS, 
and SUMIFS. Daniel Rentz added Excel filters. Thanks to Eike, who 
rebased the CWS and has brought this all forward, and to Andrew, who 
finally committed it.

There are still things to do. There are no help texts and the reference 
in the Wiki [1] is missing too.

Kind regards
Regina

[1] Start for example in 
http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_alphabetically

Re: New spreadsheet functions

[Rob Weir <ro...@apache.org>]

On Sun, Oct 7, 2012 at 9:06 AM, Regina Henschel <rb...@t-online.de> wrote:
> Hi all,
>
> it might be overlooked, so I want to draw your attention to the commit of
> CWS calcishmakkica in r1381446 to r1381452 on 5.Sept. 2012. (You remember
> the long lasting attempt to get it?) It contains in the main the work of
> Marina Plakalovic from the OpenOffice.org Summer 2010 Internship. She has
> implemented the function XOR, COUNTIFS, AVERAGEIFS, and SUMIFS. Daniel Rentz
> added Excel filters. Thanks to Eike, who rebased the CWS and has brought
> this all forward, and to Andrew, who finally committed it.
>
> There are still things to do. There are no help texts and the reference in
> the Wiki [1] is missing too.
>

We can probably get some good definitions from the ODF 1.2 definition
of these functions, and translating them into more user-friendly
language, e.g.:

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#XOR


-Rob

> Kind regards
> Regina
>
> [1] Start for example in
> http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_alphabetically

Re: New spreadsheet functions

[Alexandro Colorado <jz...@oooes.org>]

BTW new insertions should also be applied to functions list by categories.
Is there a way to have this data linked in mediawiki?
http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category

On 10/7/12, Alexandro Colorado <jz...@oooes.org> wrote:
> If I remember correctly, the COUNTIFS, AVERAGEIFS, and SUMIFS are the
> same description as COUNTIF, AVERAGEIF and SUMIF but in a concurrent
> manner as opposed to a single operation.
>
> On 10/7/12, TJ Frazier <tj...@cfl.rr.com> wrote:
>> On 10/7/2012 09:06, Regina Henschel wrote:
>>> Hi all,
>>>
>>> it might be overlooked, so I want to draw your attention to the commit
>>> of CWS calcishmakkica in r1381446 to r1381452 on 5.Sept. 2012. (You
>>> remember the long lasting attempt to get it?) It contains in the main
>>> the work of Marina Plakalovic from the OpenOffice.org Summer 2010
>>> Internship. She has implemented the function XOR, COUNTIFS, AVERAGEIFS,
>>> and SUMIFS. Daniel Rentz added Excel filters. Thanks to Eike, who
>>> rebased the CWS and has brought this all forward, and to Andrew, who
>>> finally committed it.
>>>
>>> There are still things to do. There are no help texts and the reference
>>> in the Wiki [1] is missing too.
>>>
>>> Kind regards
>>> Regina
>>>
>>> [1] Start for example in
>>> http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_alphabetically
>>>
>>>
>>>
>> Hi, Regina,
>>
>> I added some redlink references for the new functions, to make it easier
>> for somebody to write their descriptions. (I couldn't even write a
>> description for the XOR function, without knowing what the code does.
>> I'd presume that it evaluates each operand for TRUE or FALSE, then
>> returns TRUE if the number of TRUE operands is odd.)
>>
>> If someone who knows what to write will create the pages, I'll come
>> along behind and tidy up any wiki stuff (like categories).
>>
>> HTH,
>> /tj/
>>
>>
>
>
> --
> Alexandro Colorado
> PPMC Apache OpenOffice
> http://es.openoffice.org
>


-- 
Alexandro Colorado
PPMC Apache OpenOffice
http://es.openoffice.org

Re: New spreadsheet functions

[Alexandro Colorado <jz...@oooes.org>]

If I remember correctly, the COUNTIFS, AVERAGEIFS, and SUMIFS are the
same description as COUNTIF, AVERAGEIF and SUMIF but in a concurrent
manner as opposed to a single operation.

On 10/7/12, TJ Frazier <tj...@cfl.rr.com> wrote:
> On 10/7/2012 09:06, Regina Henschel wrote:
>> Hi all,
>>
>> it might be overlooked, so I want to draw your attention to the commit
>> of CWS calcishmakkica in r1381446 to r1381452 on 5.Sept. 2012. (You
>> remember the long lasting attempt to get it?) It contains in the main
>> the work of Marina Plakalovic from the OpenOffice.org Summer 2010
>> Internship. She has implemented the function XOR, COUNTIFS, AVERAGEIFS,
>> and SUMIFS. Daniel Rentz added Excel filters. Thanks to Eike, who
>> rebased the CWS and has brought this all forward, and to Andrew, who
>> finally committed it.
>>
>> There are still things to do. There are no help texts and the reference
>> in the Wiki [1] is missing too.
>>
>> Kind regards
>> Regina
>>
>> [1] Start for example in
>> http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_alphabetically
>>
>>
>>
> Hi, Regina,
>
> I added some redlink references for the new functions, to make it easier
> for somebody to write their descriptions. (I couldn't even write a
> description for the XOR function, without knowing what the code does.
> I'd presume that it evaluates each operand for TRUE or FALSE, then
> returns TRUE if the number of TRUE operands is odd.)
>
> If someone who knows what to write will create the pages, I'll come
> along behind and tidy up any wiki stuff (like categories).
>
> HTH,
> /tj/
>
>


-- 
Alexandro Colorado
PPMC Apache OpenOffice
http://es.openoffice.org

Re: New spreadsheet functions

[TJ Frazier <tj...@cfl.rr.com>]

On 10/7/2012 09:06, Regina Henschel wrote:
> Hi all,
>
> it might be overlooked, so I want to draw your attention to the commit
> of CWS calcishmakkica in r1381446 to r1381452 on 5.Sept. 2012. (You
> remember the long lasting attempt to get it?) It contains in the main
> the work of Marina Plakalovic from the OpenOffice.org Summer 2010
> Internship. She has implemented the function XOR, COUNTIFS, AVERAGEIFS,
> and SUMIFS. Daniel Rentz added Excel filters. Thanks to Eike, who
> rebased the CWS and has brought this all forward, and to Andrew, who
> finally committed it.
>
> There are still things to do. There are no help texts and the reference
> in the Wiki [1] is missing too.
>
> Kind regards
> Regina
>
> [1] Start for example in
> http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_alphabetically
>
>
>
Hi, Regina,

I added some redlink references for the new functions, to make it easier 
for somebody to write their descriptions. (I couldn't even write a 
description for the XOR function, without knowing what the code does. 
I'd presume that it evaluates each operand for TRUE or FALSE, then 
returns TRUE if the number of TRUE operands is odd.)

If someone who knows what to write will create the pages, I'll come 
along behind and tidy up any wiki stuff (like categories).

HTH,
/tj/