https://issues.apache.org/bugzilla/show_bug.cgi?id=49344
Summary: NumberFormatTests.xlsx fail on my machine
Product: POI
Version: 3.7-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
With the current trunk (rev948199) I get two build failures. Both of them are
related to the patch applied in rev942809 as described in issue 49066. I work
on a Polish Locale. I had other problems with this, but this time it's weird.
build.xml seems to set the locale to en_US via junit.properties (which is a
good idea) but I still can't build POI.
The NumberFormatTests.xlsx seems to fail on row 333. The value of the cell A333
in the "Tests" sheet is unreadable in an English version of Excel 2010beta.
This is the only cell in the A column that produces a #VALUE!. All other values
in the A column are visible correctly in Excel and pass in java code.
The NumberFormatApproxTests.xlsx is much worse. When I open it in Excel, almost
all values in the A column of the "Tests" sheet show a #VALUE! error. Only
cells which show an actual value are: A40, A41, A96, A97, A136, A137, A176,
A177, A216, A217. I get a failure in row 7: expected 120000.0 but was 100000.0.
How should I approach debugging this?
[java] 1)
testNumberFormat(org.apache.poi.ss.format.TestCellFormatPart)junit.framework.ComparisonFailure:
format "org.apache.poi.ss.format.cellformatp...@511e0a" expected:<....14...>
but was:<...,,14,159.3,...>
[java] at
org.apache.poi.ss.format.CellFormatTestBase$CellValue.equivalent(CellFormatTestBase.java:74)
[java] at
org.apache.poi.ss.format.CellFormatTestBase.tryColor(CellFormatTestBase.java:228)
[java] at
org.apache.poi.ss.format.CellFormatTestBase.tryFormat(CellFormatTestBase.java:201)
[java] at
org.apache.poi.ss.format.CellFormatTestBase.runFormatTests(CellFormatTestBase.java:109)
[java] at
org.apache.poi.ss.format.TestCellFormatPart.testNumberFormat(TestCellFormatPart.java:50)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at org.apache.poi.util.OOXMLLite.build(OOXMLLite.java:103)
[java] at org.apache.poi.util.OOXMLLite.main(OOXMLLite.java:78)
[java] 2)
testNumberApproxFormat(org.apache.poi.ss.format.TestCellFormatPart)junit.framework.AssertionFailedError:
format "org.apache.poi.ss.format.cellformatp...@8be9ef",|1.2|e|5| ~=
|1,2.1|e|5| expected:<120000.0> but was:<100000.0>
[java] at
org.apache.poi.ss.format.TestCellFormatPart$3.equivalent(TestCellFormatPart.java:70)
[java] at
org.apache.poi.ss.format.CellFormatTestBase.tryColor(CellFormatTestBase.java:228)
[java] at
org.apache.poi.ss.format.CellFormatTestBase.tryFormat(CellFormatTestBase.java:201)
[java] at
org.apache.poi.ss.format.CellFormatTestBase.runFormatTests(CellFormatTestBase.java:109)
[java] at
org.apache.poi.ss.format.TestCellFormatPart.testNumberApproxFormat(TestCellFormatPart.java:58)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at org.apache.poi.util.OOXMLLite.build(OOXMLLite.java:103)
[java] at org.apache.poi.util.OOXMLLite.main(OOXMLLite.java:78)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
