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

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:

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,

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

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]

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 h...@apache.org 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

Re: Example of spreadsheet formula testing

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

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 h...@apache.org wrote: On 27.08.2013 15:29, Rob Weir wrote: On Tue, Aug 27, 2013 at 8:44 AM, Herbert Duerr h...@apache.org wrote: [...] A good idea. I just wrote a task [1] and a script [2] that takes a

Re: Example of spreadsheet formula testing

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

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 h...@apache.org 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

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]

Re: Example of spreadsheet formula testing

2013-08-27 Thread Rob Weir
On Tue, Aug 27, 2013 at 8:44 AM, Herbert Duerr h...@apache.org 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

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 logic.

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-19 Thread janI
On 19 August 2013 10:43, Herbert Duerr h...@apache.org 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. Just

Re: Example of spreadsheet formula testing

2013-08-19 Thread Regina Henschel
Hi Jan, janI schrieb: On 19 August 2013 12:24, Regina Henschel rb.hensc...@t-online.de 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

Re: Example of spreadsheet formula testing

2013-08-19 Thread sebb
On 19 August 2013 11:41, Regina Henschel rb.hensc...@t-online.de wrote: Hi Jan, janI schrieb: On 19 August 2013 12:24, Regina Henschel rb.hensc...@t-online.de wrote: [..] But for both kind of testing there exists a problem with expected values. For example, calculation of PMT needs expm1

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

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

Re: Example of spreadsheet formula testing

2013-08-16 Thread janI
On 16 August 2013 21:37, Regina Henschel rb.hensc...@t-online.de 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

Re: Example of spreadsheet formula testing

2013-08-16 Thread Rob Weir
On Fri, Aug 16, 2013 at 3:37 PM, Regina Henschel rb.hensc...@t-online.de 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

Re: Example of spreadsheet formula testing

2013-08-16 Thread Rob Weir
On Fri, Aug 16, 2013 at 3:51 PM, janI j...@apache.org wrote: On 16 August 2013 21:37, Regina Henschel rb.hensc...@t-online.de 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

Re: Example of spreadsheet formula testing

2013-08-16 Thread janI
On 16 August 2013 22:14, Rob Weir robw...@apache.org wrote: On Fri, Aug 16, 2013 at 3:51 PM, janI j...@apache.org wrote: On 16 August 2013 21:37, Regina Henschel rb.hensc...@t-online.de wrote: Hi Rob, Rob Weir schrieb: Moving this topic to its own thread. It should be possible

Re: Example of spreadsheet formula testing

2013-08-16 Thread Rob Weir
On Fri, Aug 16, 2013 at 4:47 PM, janI j...@apache.org wrote: On 16 August 2013 22:14, Rob Weir robw...@apache.org wrote: On Fri, Aug 16, 2013 at 3:51 PM, janI j...@apache.org wrote: On 16 August 2013 21:37, Regina Henschel rb.hensc...@t-online.de wrote: Hi Rob, Rob Weir schrieb: