Return-Path: X-Original-To: apmail-poi-dev-archive@www.apache.org Delivered-To: apmail-poi-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 010ED11545 for ; Thu, 18 Sep 2014 11:47:21 +0000 (UTC) Received: (qmail 94318 invoked by uid 500); 18 Sep 2014 11:47:20 -0000 Delivered-To: apmail-poi-dev-archive@poi.apache.org Received: (qmail 94278 invoked by uid 500); 18 Sep 2014 11:47:20 -0000 Mailing-List: contact dev-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Developers List" Delivered-To: mailing list dev@poi.apache.org Received: (qmail 94266 invoked by uid 99); 18 Sep 2014 11:47:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Sep 2014 11:47:20 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [212.13.204.73] (HELO urchin.earth.li) (212.13.204.73) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Sep 2014 11:47:15 +0000 Received: from nick (helo=localhost) by urchin.earth.li with local-esmtp (Exim 4.80) (envelope-from ) id 1XUaAn-0007Qb-72 for dev@poi.apache.org; Thu, 18 Sep 2014 12:46:53 +0100 Date: Thu, 18 Sep 2014 12:46:53 +0100 (BST) From: Nick Burch X-X-Sender: nick@urchin.earth.li To: POI Developers List Subject: Re: Tests for D* In-Reply-To: <5630_1411036754_541AB652_5630_3031_1_532174E54FAD45119C6A3BDBF1E68590@haltec.local> Message-ID: References: <5630_1411036754_541AB652_5630_3031_1_532174E54FAD45119C6A3BDBF1E68590@haltec.local> User-Agent: Alpine 2.02 (DEB 1266 2009-07-14) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Checked: Checked by ClamAV on apache.org On Thu, 18 Sep 2014, Zimmermann, Patrick wrote: > I don't have tests yet and am unsure what the best way to write those > is. After a quick look at how the other functions do their tests it > seems that they usually mock up the inputs for testing. For simpler functions, this is the best way to do it, as it allows for fine-grained testing. For some complex functions, the tests will load up an Excel file with the input data pre-set up, and probably the formula already there and calculated by Excel. They then evaluate the formula, and ensure they get the same answer as Excel did Nick --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org For additional commands, e-mail: dev-help@poi.apache.org