Return-Path: X-Original-To: apmail-poi-commits-archive@minotaur.apache.org Delivered-To: apmail-poi-commits-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 61A4F11ACB for ; Wed, 23 Jul 2014 07:56:10 +0000 (UTC) Received: (qmail 14457 invoked by uid 500); 23 Jul 2014 07:56:10 -0000 Delivered-To: apmail-poi-commits-archive@poi.apache.org Received: (qmail 14421 invoked by uid 500); 23 Jul 2014 07:56:10 -0000 Mailing-List: contact commits-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@poi.apache.org Delivered-To: mailing list commits@poi.apache.org Received: (qmail 14412 invoked by uid 99); 23 Jul 2014 07:56:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Jul 2014 07:56:10 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Jul 2014 07:56:08 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id D30D023889E7; Wed, 23 Jul 2014 07:55:48 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1612786 - /poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java Date: Wed, 23 Jul 2014 07:55:48 -0000 To: commits@poi.apache.org From: centic@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20140723075548.D30D023889E7@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: centic Date: Wed Jul 23 07:55:48 2014 New Revision: 1612786 URL: http://svn.apache.org/r1612786 Log: Fix test to make it work on different date as well Modified: poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java Modified: poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java URL: http://svn.apache.org/viewvc/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java?rev=1612786&r1=1612785&r2=1612786&view=diff ============================================================================== --- poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java (original) +++ poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java Wed Jul 23 07:55:48 2014 @@ -26,6 +26,7 @@ import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; +import java.util.Calendar; import java.util.List; import org.apache.poi.EncryptedDocumentException; @@ -40,6 +41,7 @@ import org.apache.poi.poifs.filesystem.N import org.apache.poi.poifs.filesystem.POIFSFileSystem; import org.apache.poi.ss.formula.WorkbookEvaluator; import org.apache.poi.ss.formula.eval.ErrorEval; +import org.apache.poi.ss.formula.eval.NumberEval; import org.apache.poi.ss.formula.eval.ValueEval; import org.apache.poi.ss.formula.functions.Function; import org.apache.poi.ss.usermodel.*; @@ -1753,12 +1755,11 @@ public final class TestXSSFBugs extends public void testBug56688_4() { XSSFWorkbook excel = XSSFTestDataSamples.openSampleWorkbook("56688_4.xlsx"); -// Calendar calendar = Calendar.getInstance(); -// calendar.add(Calendar.MONTH, 2); -// double excelDate = DateUtil.getExcelDate(calendar.getTime()); -// NumberEval eval = new NumberEval(Math.floor(excelDate)); -// checkValue(excel, eval.getStringValue() + ".0"); - checkValue(excel, "41904.0"); + Calendar calendar = Calendar.getInstance(); + calendar.add(Calendar.MONTH, 2); + double excelDate = DateUtil.getExcelDate(calendar.getTime()); + NumberEval eval = new NumberEval(Math.floor(excelDate)); + checkValue(excel, eval.getStringValue() + ".0"); } private void checkValue(XSSFWorkbook excel, String expect) { --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org For additional commands, e-mail: commits-help@poi.apache.org