[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Re: KSpread: A-functions
From:       Tomas Mecir <mecirt () gmail ! com>
Date:       2005-08-05 9:15:44
Message-ID: 492258b105080502151b139a74 () mail ! gmail ! com
[Download RAW message or body]

On 8/5/05, Tomas Mecir <mecirt@gmail.com> wrote:
> Oh well ... Time to get back to reality ... So, as far as I see it,
> the following modifications are necessary ...
> - statistical functions using AVERAGE should use AVERAGEA instead,
> same for STDEVA
> - SUMA must go back
> - A-functions need to be modified so that they ignore empty cells
> - non-A-functions need to be modified so that they ignore empty cells,
> bool values and strings.

All done. KSpread now returns exactly the same values as excel for the
.xls file you provided.

/ Tomas
_______________________________________________
koffice-devel mailing list
koffice-devel@kde.org
https://mail.kde.org/mailman/listinfo/koffice-devel

[prev in list] [next in list] [prev in thread] [next in thread]