Re: Example of spreadsheet formula testing

2013-09-10 Thread Herbert Duerr
On 09.09.2013 22:03, Andrea Pescetti wrote: On 03/09/2013 Herbert Duerr wrote: That's a good idea. Here is a first very rough draft: https://blogs.apache.org/roller-ui/authoring/preview/OOo/?previewEntry=writing_spreadsheet_test_cases_now That link is behind an editor password. Here's the publ

Re: Example of spreadsheet formula testing

2013-09-09 Thread Shemil Hashan
I need help on steps to make the build on fedora 19. Please give me steps in simple language with terminal code. It is urgent. I'm a student of University of Moratuwa,doing a project to give predictive text for Open Office. Reply me ASAP,im stuck on the build. On Mon, Sep 9, 2013 at 4:03 PM, Andr

Re: Example of spreadsheet formula testing

2013-09-09 Thread Andrea Pescetti
On 03/09/2013 Herbert Duerr wrote: That's a good idea. Here is a first very rough draft: https://blogs.apache.org/roller-ui/authoring/preview/OOo/?previewEntry=writing_spreadsheet_test_cases_now That link is behind an editor password. Here's the public preview link: https://blogs.apache.org/pr

Re: Example of spreadsheet formula testing

2013-09-03 Thread Herbert Duerr
On 02.09.2013 21:25, Andrea Pescetti wrote: On 27/08/2013 Herbert Duerr wrote: A good idea. I just wrote a task [1] and a script [2] that takes a slightly modified version of Regina's sample document and checks whether all of its tests pass. This script is now part of the Functional Verification

Re: Example of spreadsheet formula testing

2013-09-02 Thread Andrea Pescetti
On 27/08/2013 Herbert Duerr wrote: A good idea. I just wrote a task [1] and a script [2] that takes a slightly modified version of Regina's sample document and checks whether all of its tests pass. This script is now part of the Functional Verification Test (a.k.a. FVT). [1] https://issues.apache

Re: Example of spreadsheet formula testing

2013-08-28 Thread Herbert Duerr
On 28.08.2013 16:04, Rob Weir wrote: On Wed, Aug 28, 2013 at 10:00 AM, Herbert Duerr wrote: [...] Yes, just keep the test-ids of the rows with intermediate results empty. They will be ignored. Marking lines to ignore with content in a specific column -- this is so FORTRAN. I love it. I thi

Re: Example of spreadsheet formula testing

2013-08-28 Thread Rob Weir
On Wed, Aug 28, 2013 at 10:00 AM, Herbert Duerr wrote: > On 28.08.2013 14:30, Rob Weir wrote: >> >> On Wed, Aug 28, 2013 at 4:51 AM, Herbert Duerr wrote: >>> >>> On 27.08.2013 15:29, Rob Weir wrote: On Tue, Aug 27, 2013 at 8:44 AM, Herbert Duerr wrote: > > > [...]

Re: Example of spreadsheet formula testing

2013-08-28 Thread Herbert Duerr
On 28.08.2013 14:30, Rob Weir wrote: On Wed, Aug 28, 2013 at 4:51 AM, Herbert Duerr wrote: On 27.08.2013 15:29, Rob Weir wrote: On Tue, Aug 27, 2013 at 8:44 AM, Herbert Duerr wrote: [...] A good idea. I just wrote a task [1] and a script [2] that takes a slightly modified version of Regin

Re: Example of spreadsheet formula testing

2013-08-28 Thread Rob Weir
On Wed, Aug 28, 2013 at 4:51 AM, Herbert Duerr wrote: > On 27.08.2013 15:29, Rob Weir wrote: >> >> On Tue, Aug 27, 2013 at 8:44 AM, Herbert Duerr wrote: >>> >>> [...] >>> >>> A good idea. I just wrote a task [1] and a script [2] that takes a >>> slightly >>> modified version of Regina's sample do

Re: Example of spreadsheet formula testing

2013-08-28 Thread Herbert Duerr
On 27.08.2013 15:29, Rob Weir wrote: On Tue, Aug 27, 2013 at 8:44 AM, Herbert Duerr wrote: [...] A good idea. I just wrote a task [1] and a script [2] that takes a slightly modified version of Regina's sample document and checks whether all of its tests pass. This script is now part of the Func

Re: Example of spreadsheet formula testing

2013-08-27 Thread Rob Weir
On Tue, Aug 27, 2013 at 8:44 AM, Herbert Duerr wrote: > On 25.08.2013 16:12, Andrea Pescetti wrote: >> >> On 19/08/2013 Herbert Duerr wrote: >>> >>> An example of a test case where a formula ("addition") is checked is in >>> [1]. This file is clean and easy enough that it could be used as a >>> te

Re: Example of spreadsheet formula testing

2013-08-27 Thread Herbert Duerr
On 25.08.2013 16:12, Andrea Pescetti wrote: On 19/08/2013 Herbert Duerr wrote: An example of a test case where a formula ("addition") is checked is in [1]. This file is clean and easy enough that it could be used as a template for more formula checks. [1] http://svn.apache.org/repos/asf/openoffi

Re: Example of spreadsheet formula testing

2013-08-25 Thread Regina Henschel
Hi Andrea, Andrea Pescetti schrieb: On 19/08/2013 Herbert Duerr wrote: An example of a test case where a formula ("addition") is checked is in [1]. This file is clean and easy enough that it could be used as a template for more formula checks. [1] http://svn.apache.org/repos/asf/openoffice/trun

Re: Example of spreadsheet formula testing

2013-08-25 Thread Andrea Pescetti
On 19/08/2013 Herbert Duerr wrote: An example of a test case where a formula ("addition") is checked is in [1]. This file is clean and easy enough that it could be used as a template for more formula checks. [1] http://svn.apache.org/repos/asf/openoffice/trunk/test/testuno/source/fvt/uno/sc/formu

Re: Example of spreadsheet formula testing

2013-08-21 Thread Inge Wallin
On Friday, August 16, 2013 13:32:30 Rob Weir wrote: > Moving this topic to its own thread. > > It should be possible to code a very thorough set of test cases in a > spreadsheet, without using macros or anything fancy. Just careful > reading of the ODF 1.2 specification and simple spreadsheet log

Re: Example of spreadsheet formula testing

2013-08-19 Thread sebb
On 19 August 2013 11:41, Regina Henschel wrote: > Hi Jan, > > janI schrieb: > >> On 19 August 2013 12:24, Regina Henschel wrote: >> > [..] > >>> But for both kind of testing there exists a problem with "expected >>> values". For example, calculation of PMT needs expm1 and log1p, or >>> calculatio

Re: Example of spreadsheet formula testing

2013-08-19 Thread Regina Henschel
Hi Jan, janI schrieb: On 19 August 2013 12:24, Regina Henschel wrote: [..] But for both kind of testing there exists a problem with "expected values". For example, calculation of PMT needs expm1 and log1p, or calculation of LINEST needs lot of matrix calculation. It is not impossible to calc

Re: Example of spreadsheet formula testing

2013-08-19 Thread janI
On 19 August 2013 12:24, Regina Henschel wrote: > Hi Herbert, > > Herbert Duerr schrieb: > > On 16.08.2013 21:37, Regina Henschel wrote: >> >>> Rob Weir schrieb: >>> Moving this topic to its own thread. It should be possible to code a very thorough set of test cases in a spre

Re: Example of spreadsheet formula testing

2013-08-19 Thread Regina Henschel
Hi Herbert, Herbert Duerr schrieb: On 16.08.2013 21:37, Regina Henschel wrote: Rob Weir schrieb: Moving this topic to its own thread. It should be possible to code a very thorough set of test cases in a spreadsheet, without using macros or anything fancy. Just careful reading of the ODF 1.2

Re: Example of spreadsheet formula testing

2013-08-19 Thread Herbert Duerr
On 19.08.2013 11:18, janI wrote: On 19 August 2013 10:43, Herbert Duerr wrote: [...] There is no need to develop a new framework. Please check Zhe Liu's wonderful work on test automation that I referenced above [2] that is already available in our "test/" directory. It is very powerful, clean a

Re: Example of spreadsheet formula testing

2013-08-19 Thread janI
On 19 August 2013 10:43, Herbert Duerr wrote: > On 16.08.2013 21:37, Regina Henschel wrote: > >> Rob Weir schrieb: >> >>> Moving this topic to its own thread. >>> >>> It should be possible to code a very thorough set of test cases in a >>> spreadsheet, without using macros or anything fancy. Jus

Re: Example of spreadsheet formula testing

2013-08-19 Thread Herbert Duerr
On 16.08.2013 21:37, Regina Henschel wrote: Rob Weir schrieb: Moving this topic to its own thread. It should be possible to code a very thorough set of test cases in a spreadsheet, without using macros or anything fancy. Just careful reading of the ODF 1.2 specification and simple spreadsheet

Re: Example of spreadsheet formula testing

2013-08-16 Thread Rob Weir
On Fri, Aug 16, 2013 at 4:47 PM, janI wrote: > On 16 August 2013 22:14, Rob Weir wrote: > >> On Fri, Aug 16, 2013 at 3:51 PM, janI wrote: >> > On 16 August 2013 21:37, Regina Henschel >> wrote: >> > >> >> Hi Rob, >> >> >> >> Rob Weir schrieb: >> >> >> >>> Moving this topic to its own thread. >>

Re: Example of spreadsheet formula testing

2013-08-16 Thread janI
On 16 August 2013 22:14, Rob Weir wrote: > On Fri, Aug 16, 2013 at 3:51 PM, janI wrote: > > On 16 August 2013 21:37, Regina Henschel > wrote: > > > >> Hi Rob, > >> > >> Rob Weir schrieb: > >> > >>> Moving this topic to its own thread. > >>> > >>> It should be possible to code a very thorough se

Re: Example of spreadsheet formula testing

2013-08-16 Thread Rob Weir
On Fri, Aug 16, 2013 at 3:51 PM, janI wrote: > On 16 August 2013 21:37, Regina Henschel wrote: > >> Hi Rob, >> >> Rob Weir schrieb: >> >>> Moving this topic to its own thread. >>> >>> It should be possible to code a very thorough set of test cases in a >>> spreadsheet, without using macros or any

Re: Example of spreadsheet formula testing

2013-08-16 Thread Rob Weir
On Fri, Aug 16, 2013 at 3:37 PM, Regina Henschel wrote: > Hi Rob, > > Rob Weir schrieb: > >> Moving this topic to its own thread. >> >> It should be possible to code a very thorough set of test cases in a >> spreadsheet, without using macros or anything fancy. Just careful >> reading of the ODF 1

Re: Example of spreadsheet formula testing

2013-08-16 Thread janI
On 16 August 2013 21:37, Regina Henschel wrote: > Hi Rob, > > Rob Weir schrieb: > >> Moving this topic to its own thread. >> >> It should be possible to code a very thorough set of test cases in a >> spreadsheet, without using macros or anything fancy. Just careful >> reading of the ODF 1.2 spec

Re: Example of spreadsheet formula testing

2013-08-16 Thread Regina Henschel
Hi Rob, Rob Weir schrieb: Moving this topic to its own thread. It should be possible to code a very thorough set of test cases in a spreadsheet, without using macros or anything fancy. Just careful reading of the ODF 1.2 specification and simple spreadsheet logic. Following the spec is not

Example of spreadsheet formula testing

2013-08-16 Thread Rob Weir
Moving this topic to its own thread. It should be possible to code a very thorough set of test cases in a spreadsheet, without using macros or anything fancy. Just careful reading of the ODF 1.2 specification and simple spreadsheet logic. I'd like to share an example of this that I created for o