<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - calc unit test writing" href="https://bugs.documentfoundation.org/show_bug.cgi?id=39749#c12">Comment # 12</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - calc unit test writing" href="https://bugs.documentfoundation.org/show_bug.cgi?id=39749">bug 39749</a> from <a class="email" href="mailto:dennisfrancis.in@gmail.com" title="Dennis Francis <dennisfrancis.in@gmail.com>"> Dennis Francis</a> <pre>(In reply to Ekansh Jha from <a href="show_bug.cgi?id=39749#c11">comment #11</a>) > I am new to LO. Just want to ask if this issue is still open, and how to get > started to solve this bug. Hey Ekansh, The aim of this ticket is to create tests for all of the Calc spreadsheet functions. As of now, the tests for each Calc spreadsheet function is put in a fods file which is created with Calc itself(no C++ coding involved). For examples of how to create these files, see the fods documents in sc/qa/unit/data/functions/<category>/ which asserts the results of spreadsheet function for different test inputs. For example, sc/qa/unit/data/functions/statistical/var.fods tests the spreadsheet function VAR(). Each of these fods document consists of at least two sheets. 1. Sheet2 contains a column of function evaluation at test points, a column of corresponding expected values, another column(with boolean values) that checks if computed and expected values are close enough. 2. Sheet1 contains a summary of results in Sheet2, with a single boolean value in cell "B3" that shows whether _any_ of the tests in Sheet2 failed or not. The unit testing framework for checking the fods files will check the value of Sheet1.B3 and complain if not TRUE. If you have any questions, you can either ask here or in the irc channel #libreoffice-dev. Thanks !</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>