You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ce...@apache.org on 2014/12/22 08:57:04 UTC
svn commit: r1647254 - in /poi/trunk:
src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestUnfixedBugs.java
test-data/spreadsheet/57236.xlsx
Author: centic
Date: Mon Dec 22 07:57:03 2014
New Revision: 1647254
URL: http://svn.apache.org/r1647254
Log:
Bug 57236: Add reproducer, although I am not sure if we should and how to fix this...
Added:
poi/trunk/test-data/spreadsheet/57236.xlsx (with props)
Modified:
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestUnfixedBugs.java
Modified: poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestUnfixedBugs.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestUnfixedBugs.java?rev=1647254&r1=1647253&r2=1647254&view=diff
==============================================================================
--- poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestUnfixedBugs.java (original)
+++ poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestUnfixedBugs.java Mon Dec 22 07:57:03 2014
@@ -25,6 +25,7 @@ import junit.framework.TestCase;
import org.apache.poi.hssf.HSSFTestDataSamples;
import org.apache.poi.ss.usermodel.Cell;
+import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
@@ -103,5 +104,34 @@ public final class TestUnfixedBugs exten
}
}
}
+ }
+
+
+ public void test57236() {
+ // Having very small numbers leads to different formatting, Excel uses the scientific notation, but POI leads to "0"
+
+ /*
+ DecimalFormat format = new DecimalFormat("#.##########", new DecimalFormatSymbols(Locale.getDefault()));
+ double d = 3.0E-104;
+ assertEquals("3.0E-104", format.format(d));
+ */
+
+ DataFormatter formatter = new DataFormatter(true);
+
+ XSSFWorkbook wb = XSSFTestDataSamples.openSampleWorkbook("57236.xlsx");
+ for(int sheetNum = 0;sheetNum < wb.getNumberOfSheets();sheetNum++) {
+ Sheet sheet = wb.getSheetAt(sheetNum);
+ for(int rowNum = sheet.getFirstRowNum();rowNum < sheet.getLastRowNum();rowNum++) {
+ Row row = sheet.getRow(rowNum);
+ for(int cellNum = row.getFirstCellNum();cellNum < row.getLastCellNum();cellNum++) {
+ Cell cell = row.getCell(cellNum);
+ String fmtCellValue = formatter.formatCellValue(cell);
+
+ System.out.println("Cell: " + fmtCellValue);
+ assertNotNull(fmtCellValue);
+ assertFalse(fmtCellValue.equals("0"));
+ }
+ }
+ }
}
}
Added: poi/trunk/test-data/spreadsheet/57236.xlsx
URL: http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/57236.xlsx?rev=1647254&view=auto
==============================================================================
Binary file - no diff available.
Propchange: poi/trunk/test-data/spreadsheet/57236.xlsx
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org