Re: proposal for collaboration between Gnumeric and LibreOffice

[Markus Mohrhard <markus mohrhard googlemail com>]

Hey,

thanks for your response.

On Thu, May 21, 2015 at 11:19 PM, Morten Welinder <mortenw gnome org> wrote:

For purposes of testing evaluation we already have a pile
of spreadsheets aiming at that.  One can always do more,
but it's a start.  They are not, for better or worse, not split
out from the test sheets used for other purposes.  They
can be found at

    https://git.gnome.org/browse/gnumeric/tree/samples

The relevant ones for calculation are, for example,
    excel/*funs*.xls
    excel/yalta2008.xls
    crlibm.gnumeric
    burkhardt.gnumeric
    amath.gnumeric

(Some of these are gnumeric files, but a quick "ssconvert
crlibm.gnumeric crlibm.ods" will fix that for you.)

That should not be a problem as LibreOffice (at least in developer builds) contains a basic gnumeric import.
 

However, whenever I want to see how localc is doing with
any of our spreadsheets I run into this bug:

    https://bugs.documentfoundation.org/show_bug.cgi?id=71459

So that is a known problem and based on a design decision in the LibreOffice formula engine. For many operations we assume that if we are off by just the last two bits that this is related to rounding errors and therefore switch to the hopefully "correct" number. This works in some cases and won't work in others.

I think a formal collaboration is unnecessary.  IMHO, you should
move to a point where you can use our test sheets while at the
same time we should move to a point where we can use yours.
A good start would be to let us know where you keep yours.

So most of the function tests are in sc/qa/unit/data/ods

Mainly the following files but some tests are sadly in other files:

database-functions.ods
financial_functions.ods
date-time-functions.ods
information-functions.ods
logical-functions.ods
mathematical_functions.ods
matrix.ods
matrix-operations.ods
spreadsheet-functions.ods
statistical-functions.ods
text-functions.ods
user-defined-function.ods

There is no system in them yet. Often it just contains one or two test cases written by the QA team.

 

Preferably the use of each other's sheets should be without
changes so we don't get a merge problem.  That might not be
something we can achieve in all cases, though.

Morten

On Wed, May 20, 2015 at 10:41 PM, Markus Mohrhard
<markus mohrhard googlemail com> wrote:
> Hey,
>
> I'm one of the LibreOffice Calc maintainers and one of the people
> maintaining the calc automated tests.
>
> As you might know there is no official OpenFormula test suite which in my
> opinion is one of the big issues with OpenFormula. To make matters worse
> many corner cases are not specified and therefore implementation defined
> resulting in problems around interoperability.
>
> Another point is that adding new features requires to add them into an own
> namespace which is important for Excel interoperability. As more or less
> every implementation is implementing its own names for these non-specified
> functions it further causes interoperability issues.
>
>
> I was wondering if there is interested in tackling these issues as part of a
> cooperation between the two projects by creating a test suite for
> OpenFormula functions and related functions. The idea would be that this
> suite could be consumed by both projects in their automated tests to make
> sure that the implementation is consistent and that names for new functions
> are the same for both projects.
>
> Currently my idea would be to use flat odf for a document containing a
> spreadsheet with the functions and csv for the expected results but I'm open
> to other ideas that create easy to consume tests.
>
> I'd love to hear what you think of this proposal for collaboration.
>
> Regards,
> Markus
>

> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>