Fwd: Test suite for Gnumeric

Chris Sherlock chris.sherlock79 at gmail.com
Wed Mar 12 21:26:07 PDT 2014

Hi all,

I'm forwarding an email from Morten Welinder, who works on Gnumeric. He has
generated a test spreadsheet, and has kindly given me permission to forward
it on to the LO dev mailing list. When I get a moment, I'll log some bugs
with the results of his testing as it pertains to LO Calc!

The original blog post was here:


Chris Sherlock

---------- Forwarded message ----------
From: Morten Welinder <mortenw at gnome.org>
Date: Thu, Mar 13, 2014 at 12:16 AM
Subject: Re: Test suite for Gnumeric
To: Chris Sherlock <chris.sherlock79 at gmail.com>

The sheet in question was created this way:

./ssconvert -T Gnumeric_Excel:excel_biff7
../samples/string-tests.gnumeric ~/string-tests.xls

I'm attaching the sheet.  The strings get truncated at ~2k characters when
read by LO.  I will risk a guess: LO doesn't handle multiple

> Also, what sort of tests are you doing?

Basically I have been creating sheet with all the features I can think of.
In the strings case that means short strings, long, string, crazy long
ascii, non-ascii, etc.  My tests then uses the converter ("ssconvert") to
convert to (say) xls/biff7 and back.  And it had better come back without
any changes that aren't fully explained.


The key here is ssconvert which makes it possible to automate the whole
thing fully.  If you have a similar tool, it should be fairly easy to
create the
same type of tests, although you presumably would start from .ods files.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20140313/a63c28da/attachment.html>

More information about the LibreOffice mailing list