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 09011180CB for ; Thu, 3 Sep 2015 20:46:15 +0000 (UTC) Received: (qmail 76389 invoked by uid 500); 3 Sep 2015 20:46:14 -0000 Delivered-To: apmail-poi-commits-archive@poi.apache.org Received: (qmail 76353 invoked by uid 500); 3 Sep 2015 20:46:14 -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 76344 invoked by uid 99); 3 Sep 2015 20:46:14 -0000 Received: from eris.apache.org (HELO hades.apache.org) (140.211.11.105) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Sep 2015 20:46:14 +0000 Received: from hades.apache.org (localhost [127.0.0.1]) by hades.apache.org (ASF Mail Server at hades.apache.org) with ESMTP id 95991AC010E for ; Thu, 3 Sep 2015 20:46:14 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1701133 - in /poi/trunk: src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java test-data/spreadsheet/53105.xlsx Date: Thu, 03 Sep 2015 20:46:14 -0000 To: commits@poi.apache.org From: centic@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20150903204614.95991AC010E@hades.apache.org> Author: centic Date: Thu Sep 3 20:46:14 2015 New Revision: 1701133 URL: http://svn.apache.org/r1701133 Log: Add unit test which verifies that bug 53105 is actually fixed now Added: poi/trunk/test-data/spreadsheet/53105.xlsx 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=1701133&r1=1701132&r2=1701133&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 Thu Sep 3 20:46:14 2015 @@ -2616,4 +2616,21 @@ public final class TestXSSFBugs extends wb.close(); } + + @Test + public void test53105() throws IOException { + Workbook wb = XSSFTestDataSamples.openSampleWorkbook("53105.xlsx"); + assertNotNull(wb); + + + // Act + // evaluate SUM('Skye Lookup Input'!A4:XFD4), cells in range each contain "1" + FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator(); + double numericValue = evaluator.evaluate(wb.getSheetAt(0).getRow(1).getCell(0)).getNumberValue(); + + // Assert + assertEquals(16384.0, numericValue, 0.0); + + wb.close(); + } } Added: poi/trunk/test-data/spreadsheet/53105.xlsx URL: http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/53105.xlsx?rev=1701133&view=auto ============================================================================== Binary files poi/trunk/test-data/spreadsheet/53105.xlsx (added) and poi/trunk/test-data/spreadsheet/53105.xlsx Thu Sep 3 20:46:14 2015 differ --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org For additional commands, e-mail: commits-help@poi.apache.org