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 <[email protected]> Date: Thu, Mar 13, 2014 at 12:16 AM Subject: Re: Test suite for Gnumeric To: Chris Sherlock <[email protected]> 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.
_______________________________________________ LibreOffice mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice
