Hey, thanks for your response.
On Thu, May 21, 2015 at 11:19 PM, Morten Welinder <[email protected]> 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 > <[email protected]> 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 > > [email protected] > > https://mail.gnome.org/mailman/listinfo/gnumeric-list > > >
_______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list
