Re: proposal for collaboration between Gnumeric and LibreOffice

[Morten Welinder <mortenw gnome org>]

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.)

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

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.

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