I want to present you the new way you can write build-time unit tests for
How are the tests organized?*
The tests are located in sc/qa/unit and consists of filters-test.cxx and the
files in sc/qa/unit/data. In the data directory there is one directory per
supported file extensions (ods, xls, xlsx) and one directory contentCSV that
only contains csv files. Please don't touch the other directories, they are
for special tests) At the moment we have a for-named-ranges test, a database
ranges test , a formatting test and a standard content test file.
Additionally there is one file per directory for bugfix tests so that import
bugs that are fixed once will not reoccur. If possible a new test case
should be added to each of the three directories so that we test as much as
possible for every filter.
What can we test?*
We can test the content of a calc document directly after loading it. It is
quite easy to test the content of cells, that means the formula in a cell,
the result as a value and the formatted result as a string. It is even
possible to test the result of cells that are part of conditional
formatting. It gets more complicated for other stuff since I don't have any
csv handler for that or it might need some code to test it.
We can't test any dynamic changes in calc documents with this test ( there
is ucalc for these cases). So for unit tests that try to emulate user input
and/or changes that go beyond what is done during loading, can't be tested
with this easy unit test.
How to write a new test?*
It's quite easy to write a new unit test.
The first step is to create a document that should be tested or
add/extend an existing sheet in a document.
The second step is to create for every sheet a csv file that contains
the expected result, formula or string that the test document should
*How can I get the existing files?*
Either you have the source code already than it is in sc/qa/unit or you can
get the files from:
I will create a wiki page for these information soon but feel free to ask me
anything or make suggestions. I try to announce changes around this on the
It would be amazing if some of the calc users would write or extend the
existing tests. Even if you could provide just one or two test cases you
would help very much ensure that our next release will contain less bugs and
that calc becomes even more stable.
Here are somethings, for instance, that could be tested or
the test extended:
- normal content
- data pilot/pivot table
- the functions document should be extended to all build-in functions (
testing special cases, normal behaviour, etc. )
- advanced functions like sorted content, autofilter, subtotals,
- some of the import bugs fixed during the 3-4 release cycle
I'm sure I missed a lot of important things and that is your big chance! Did
you ever wanted to commit something to Libreoffice source code but you don't
know how to code ? You don't have the time to get familiar with the code ?
This is the perfect opportunity to get your first commit ;) You have a nasty
bug that you don't want to see again ? Write a test file, add a csv file
with the expected content and send it to the
I'm looking forward to all your great contributions that will help us to
release a nice next version.
P.S. Links to all ods documents that we have at the moment:
Unsubscribe instructions: E-mail to firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/projects/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-projects] New way for non coders to help with calc unit tests · Markus Mohrhard
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy