Fwd: Test suite for Gnumeric

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:

https://blogs.gnome.org/mortenw/2014/03/11/writing-tests-is-humbling/

Chris Sherlock

---------- Forwarded message ----------
From: Morten Welinder <mortenw@gnome.org>
Date: Thu, Mar 13, 2014 at 12:16 AM
Subject: Re: Test suite for Gnumeric
To: Chris Sherlock <chris.sherlock79@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
BIFF_CONTINUE records.

> 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
strings,
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.

https://git.gnome.org/browse/gnumeric/tree/test/t6500-strings.pl

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.


MortEn.