Build failed in Jenkins: POI-DSL-OpenJDK #260

2017-09-19 Thread Apache Jenkins Server 
See 


Changes:

[fanningpj] Bug 61528 - Pivot Table enhancements, new example [Thanks to R 
Kietel]. This closes #71

[fanningpj] Bug 61528 - Pivot Table enhancements, new example [Thanks to R 
Kietel]. This closes #71

[fanningpj] tidy up some test code

[centic] Add test to verify that bug 61532 is fixed as far as I see via the 
changes for bug 61148.

[centic] Adjust to make forbidden-api-check succeed again

[centic] Bug 61148: Fix calculating formula value, unfortunately we currently 
need to set the value twice
Also rework related tests to run more of the tests for HSSF, XSSF and SXSSF

[centic] IntelliJ warnings, deprecation

[centic] Fix some IntelliJ warnings

[tallison] 60805 (partial) -- remove/suppress println in tests

[centic] While working on bug 61148 I found that getCellType() and 
setCellErrorValue() in SXSSFCell are doing different things than the ones in 
XSSFCell, tried to fix this by mimicking functionality of XSSF in SXSSF as well.
Reformating some small things as well.

--
[...truncated 619.75 KB...]
 [java] at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:412)
 [java] at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:393)
 [java] at 
org.apache.poi.hssf.HSSFTestDataSamples.openSampleWorkbook(HSSFTestDataSamples.java:50)
 [java] at 
org.apache.poi.xssf.usermodel.TestMissingWorkbookOnXSSF.setUp(TestMissingWorkbookOnXSSF.java:35)
 [java] at junit.framework.TestCase.runBare(TestCase.java:139)
 [java] at junit.framework.TestResult$1.protect(TestResult.java:122)
 [java] at junit.framework.TestResult.runProtected(TestResult.java:142)
 [java] at junit.framework.TestResult.run(TestResult.java:125)
 [java] at junit.framework.TestCase.run(TestCase.java:129)
 [java] at junit.framework.TestSuite.runTest(TestSuite.java:252)
 [java] at junit.framework.TestSuite.run(TestSuite.java:247)
 [java] at 
org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86)
 [java] at org.junit.runners.Suite.runChild(Suite.java:128)
 [java] at org.junit.runners.Suite.runChild(Suite.java:27)
 [java] at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
 [java] at 
org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
 [java] at 
org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
 [java] at 
org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
 [java] at 
org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
 [java] at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
 [java] at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
 [java] at org.junit.runner.JUnitCore.run(JUnitCore.java:115)
 [java] at org.junit.runner.JUnitCore.run(JUnitCore.java:105)
 [java] at org.junit.runner.JUnitCore.run(JUnitCore.java:94)
 [java] at org.apache.poi.util.OOXMLLite.build(OOXMLLite.java:149)
 [java] at org.apache.poi.util.OOXMLLite.main(OOXMLLite.java:94)
 [java] 146) 
testMissingWorkbookMissing(org.apache.poi.xssf.usermodel.TestMissingWorkbookOnXSSF)
 [java] java.lang.NoSuchMethodError: 
java.nio.ByteBuffer.position(I)Ljava/nio/ByteBuffer;
 [java] at 
org.apache.poi.poifs.filesystem.NPOIFSFileSystem.(NPOIFSFileSystem.java:306)
 [java] at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:412)
 [java] at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:393)
 [java] at 
org.apache.poi.hssf.HSSFTestDataSamples.openSampleWorkbook(HSSFTestDataSamples.java:50)
 [java] at 
org.apache.poi.xssf.usermodel.TestMissingWorkbookOnXSSF.setUp(TestMissingWorkbookOnXSSF.java:35)
 [java] at junit.framework.TestCase.runBare(TestCase.java:139)
 [java] at junit.framework.TestResult$1.protect(TestResult.java:122)
 [java] at junit.framework.TestResult.runProtected(TestResult.java:142)
 [java] at junit.framework.TestResult.run(TestResult.java:125)
 [java] at junit.framework.TestCase.run(TestCase.java:129)
 [java] at junit.framework.TestSuite.runTest(TestSuite.java:252)
 [java] at junit.framework.TestSuite.run(TestSuite.java:247)
 [java] at 
org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86)
 [java] at org.junit.runners.Suite.runChild(Suite.java:128)
 [java] at org.junit.runners.Suite.runChild(Suite.java:27)
 [java] at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
 [java] at 
org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
 [java] at 
org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
 [java] at 
org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)

[GitHub] poi pull request #71: Bug 61528 - Pivot Table enhancements, new example

2017-09-19 Thread asfgit 
Github user asfgit closed the pull request at:

https://github.com/apache/poi/pull/71


---

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61033] [PATCH] Add Workbook.setCellFormulaValidation to control whether formulas are validated during Cell.setCellFormula or not

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61033

Dominik Stadler  changed:

   What|Removed |Added

   Keywords||PatchAvailable

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61116] Formula evaluation fails when using matrix addition within index function call with RuntimeException

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61116

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #1 from Dominik Stadler  ---
Can you check if the changes done in bug 61469 solve this?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61252] Error evaluating formulas with more of 30 arguments on excel file 2007 or major.

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61252

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #7 from Dominik Stadler  ---
This is resolved as far as I see.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61469] [PATCH] Support Array Formulas and Matrix Functions

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61469

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #4 from Dominik Stadler  ---
This seems to be applied via r1808297, is there anything still missing?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61472] Unable to evaluate dependent cell formula

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

--- Comment #6 from Dominik Stadler  ---
The problem happens because the first cell is a string-value via TEXT(...), but
the second cell reads it as time for the HOUR() function, which Excel seems to
somehow manage, but Apache POI does not. 

You might be able to change the first cell to be only "NOW()" and use
formatting to get the desired format display, while still keeping the
date-value as formula-result.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61494] Updating meta properties in xlsm/xlsx corrupted equation

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61494

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #3 from Dominik Stadler  ---
Can you provide unit-tests/sample-code/sample-files which allows to reproduce
the problem? Without this it is not possible to see where the actual problem
is.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61148] Formula evaluation on an SXSSFCell is not working

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148

--- Comment #4 from Dominik Stadler  ---
*** Bug 61532 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61532] XSSFFormulaEvaluator.evaluateFormulaCell() replaces the formula and changes the cell type

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61532

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #4 from Dominik Stadler  ---
I have now tested it as far as I can and added a unit-test via r1808932 which
shows that the two methods behave as documented and expected after fixing bug
61148. 

Please verify it with a build which contains these changes and reopen the bug
if it is still not fixed for you with some special combination of
formula/call-order.

*** This bug has been marked as a duplicate of bug 61148 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 60302] Formulas not working correctly on LibreOffice with SXSSF

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=60302

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #5 from Dominik Stadler  ---
The problem is that the cached values for the formula is not populated by
default in POI to save the CPU cycles if not needed. You can force single cells
or all formulas to be evaluated with the FormulaEvaluator which is available
via "wb.getCreationHelper().createFormulaEvaluator()", so in your case the
following makes the result of the formula also show up in LibreOffice
correctly:

wb.getCreationHelper().createFormulaEvaluator().evaluateAll();

Therefore I am closing this WORKSFORME now as this is currently by design and
only Excel seems to somehow detect that the formulas need recalculation whereas
LibreOffice seems to rely on them being populated always.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 60302] Formulas not working correctly on LibreOffice with SXSSF

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=60302
Bug 60302 depends on bug 61148, which changed state.

Bug 61148 Summary: Formula evaluation on an SXSSFCell is not working
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61148] Formula evaluation on an SXSSFCell is not working

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148

Dominik Stadler  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|NEW |RESOLVED

--- Comment #3 from Dominik Stadler  ---
Fixed some related problem with SXSSF via r1808874 and the core issue reported
here via r1808929, unfortunately a slight hack needed to be employed, see the
fix for details. 

So this should be fixed now.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61532] XSSFFormulaEvaluator.evaluateFormulaCell() replaces the formula and changes the cell type

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61532

--- Comment #3 from Dave Neuer  ---
I don't believe this is a duplicate of the linked issue; the description of
that issue is different, though they may share an underlying cause.

I'll work on a small test case demonstrating the issue in the coming days.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61516] problem adjusting cell reference in formula to zeroth row

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61516

--- Comment #5 from Dominik Stadler  ---
doh, sorry, must have been asleep already to mix up "A" vs. row.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 60805] Remove calls to System.out.print and System.out.println

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=60805

--- Comment #4 from Tim Allison  ---
r1808903 focused on println in tests.

* redirected stdout for x.main(args) calls.

* deleted a few printlns that were prob useful during development.

* commented out a few printlns that I felt someone might want to turn back on
during development

* converted some to POILogger.log()

* left the printlns in MemoryUsage...not sure what to do with those?!

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61474] Adjusting of formulas in context of column shifting

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61474

--- Comment #9 from Javen O'Neal  ---
Let's rewind to what signature shifting columns should have.

Sheet.shiftRows(int startRow, int endRow, int n[, boolean copyRowHeight])

I wrote copyRows with a CellCopyPolicy object to avoid having a long signature.
Do we want something similar for a new shiftRows and shiftColumns method?

Usually when I use shiftRows, I have to shift from some insertion point to the
last row in the workbook so I don't shift rows onto existing rows. Can
shiftRows/shiftColumns be used with n>0 and endRow!=last row number?

Can we make shiftRows/shiftColumns behave as close to Excel as possible to make
it as intuitive to use as possible? I favor calling it insert rows instead of
shift rows since it's clearer that it isn't copying or cutting (though we
should provide that ability).

If all you have time for now is a clone of shiftRows behavior, we'll commit
that and incrementally improve it later if there's interest. It just means
breaking the API at a later date.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 60805] Remove calls to System.out.print and System.out.println

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=60805

--- Comment #3 from Tim Allison  ---
Doh.  Thank you, Javen...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61536] Let's get rid of println in tests

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61536

--- Comment #2 from Javen O'Neal  ---
Agreed!

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61536] Let's get rid of println in tests

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61536

Javen O'Neal  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 OS||All
 Resolution|--- |DUPLICATE

--- Comment #1 from Javen O'Neal  ---


*** This bug has been marked as a duplicate of bug 60805 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 60805] Remove calls to System.out.print and System.out.println

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=60805

Javen O'Neal  changed:

   What|Removed |Added

 CC||talli...@mitre.org

--- Comment #2 from Javen O'Neal  ---
*** Bug 61536 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61536] New: Let's get rid of println in tests

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61536

Bug ID: 61536
   Summary: Let's get rid of println in tests
   Product: POI
   Version: unspecified
  Hardware: PC
Status: NEW
  Severity: trivial
  Priority: P2
 Component: POI Overall
  Assignee: dev@poi.apache.org
  Reporter: talli...@mitre.org
  Target Milestone: ---

Let's get clean up/suppress printlns in our unit tests.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 52972] Enable RichText in SXSSF

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=52972

--- Comment #5 from Dominik Stadler  ---
This is pretty much the same as bug 57294 where a possible implementation was
suggested, but is now outdated...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61532] XSSFFormulaEvaluator.evaluateFormulaCell() replaces the formula and changes the cell type

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61532

Dominik Stadler  changed:

   What|Removed |Added

 Status|REOPENED|NEEDINFO

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61532] XSSFFormulaEvaluator.evaluateFormulaCell() replaces the formula and changes the cell type

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61532

Dominik Stadler  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|DUPLICATE   |---

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61148] Formula evaluation on an SXSSFCell is not working

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148

Dominik Stadler  changed:

   What|Removed |Added

 CC||david.neuer.vendor@crowncas
   ||tle.com

--- Comment #2 from Dominik Stadler  ---
*** Bug 61532 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61532] XSSFFormulaEvaluator.evaluateFormulaCell() replaces the formula and changes the cell type

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61532

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #2 from Dominik Stadler  ---


*** This bug has been marked as a duplicate of bug 61148 ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Build failed in Jenkins: POI-DSL-OpenJDK #259

2017-09-19 Thread Apache Jenkins Server 
See 


Changes:

[onealj] bug 61454: add column width to example Spreadsheet ToHtml; thanks to 
Christian Froehler

[onealj] bug 61454: add column width to example Spreadsheet ToHtml; thanks to 
Christian Froehler

--
[...truncated 612.57 KB...]
 [java] at 
org.apache.poi.poifs.filesystem.NPOIFSFileSystem.(NPOIFSFileSystem.java:306)
 [java] at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:412)
 [java] at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:393)
 [java] at 
org.apache.poi.hssf.HSSFTestDataSamples.writeOutAndReadBack(HSSFTestDataSamples.java:65)
 [java] at 
org.apache.poi.hssf.HSSFITestDataProvider.writeOutAndReadBack(HSSFITestDataProvider.java:55)
 [java] at 
org.apache.poi.xssf.usermodel.TestXSSFCell.testEncodingBelowAscii(TestXSSFCell.java:487)
 [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 [java] at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 [java] at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 [java] at java.lang.reflect.Method.invoke(Method.java:498)
 [java] at 
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
 [java] at 
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
 [java] at 
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
 [java] at 
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
 [java] at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
 [java] at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
 [java] at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
 [java] at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
 [java] at 
org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
 [java] at 
org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
 [java] at 
org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
 [java] at 
org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
 [java] at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
 [java] at org.junit.runners.Suite.runChild(Suite.java:128)
 [java] at org.junit.runners.Suite.runChild(Suite.java:27)
 [java] at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
 [java] at 
org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
 [java] at 
org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
 [java] at 
org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
 [java] at 
org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
 [java] at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
 [java] at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
 [java] at org.junit.runner.JUnitCore.run(JUnitCore.java:115)
 [java] at org.junit.runner.JUnitCore.run(JUnitCore.java:105)
 [java] at org.junit.runner.JUnitCore.run(JUnitCore.java:94)
 [java] at org.apache.poi.util.OOXMLLite.build(OOXMLLite.java:149)
 [java] at org.apache.poi.util.OOXMLLite.main(OOXMLLite.java:94)
 [java] 147) 
testMultiSheetAreasHSSFandXSSF(org.apache.poi.xssf.usermodel.TestXSSFFormulaEvaluation)
 [java] java.lang.NoSuchMethodError: 
java.nio.ByteBuffer.position(I)Ljava/nio/ByteBuffer;
 [java] at 
org.apache.poi.poifs.filesystem.NPOIFSFileSystem.(NPOIFSFileSystem.java:306)
 [java] at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:412)
 [java] at 
org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.java:393)
 [java] at 
org.apache.poi.hssf.HSSFTestDataSamples.openSampleWorkbook(HSSFTestDataSamples.java:50)
 [java] at 
org.apache.poi.xssf.usermodel.TestXSSFFormulaEvaluation.testMultiSheetAreasHSSFandXSSF(TestXSSFFormulaEvaluation.java:338)
 [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 [java] at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 [java] at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 [java] at java.lang.reflect.Method.invoke(Method.java:498)
 [java] at 
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
 [java] at 
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
 [java] at 
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
 [java] at

[Bug 61148] Formula evaluation on an SXSSFCell is not working

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61148

Dominik Stadler  changed:

   What|Removed |Added

 Blocks||60302

--- Comment #1 from Dominik Stadler  ---
FYI, I have a fix pending for this that is waiting for another fix to land. 

When this is done, we should check if it also solves bug 60302 by fixing the
cached formula content.


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=60302
[Bug 60302] Formulas not working correctly on LibreOffice with SXSSF
-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 60302] Formulas not working correctly on LibreOffice with SXSSF

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=60302

Dominik Stadler  changed:

   What|Removed |Added

 Depends on||61148


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=61148
[Bug 61148] Formula evaluation on an SXSSFCell is not working
-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61300] Very slow processing on corrupted file

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61300

Tim Allison  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|NEEDINFO|RESOLVED

--- Comment #2 from Tim Allison  ---
Dominik,
  I'm sorry for never responding.  Y, looks like I could reproduce this in pure
POI.

fixed r1801989

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61474] Adjusting of formulas in context of column shifting

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61474

--- Comment #8 from Dragan Jovanović  ---
Thanks for comment. You're right that there is duplication in the code. I would
be willing to work on this to eliminate the duplication but that would probably
not result in net neutral SLoC because there is additional functionality.
Column shifting certainly is useful functionality which  provides value and
which we and others need. We will definitely be using it for our application
context. 

I have taken a look at the issues that you have listed to see which issues are
really relevant. 46742 is certainly relevant as it sketches additional
functionality that would be useful. But this is really independent from column
shifting. Column shifting does not make these items much easier or harder to
fix. Many of the other bugs do not seem to really be very relevant (i.e. 53320,
54509). Unfortunately my employer is not very likely to support work on these
issues. 

So overall I see this as your call. I can do work on eliminating the
duplications.  

Maybe I would be willing to fix some of the open issues on my own time. But if
you want to consider column shifting only after all the earlier bugs have been
resolved, that would make little sense to me.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61516] problem adjusting cell reference in formula to zeroth row

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61516

--- Comment #3 from Dragan Jovanović  ---
Created attachment 35335
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35335=edit
test file, for manual work in Excel

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61516] problem adjusting cell reference in formula to zeroth row

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61516

--- Comment #2 from Dragan Jovanović  ---
Created attachment 35334
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35334=edit
minimized version of test case

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Jenkins build is back to normal : POI-DSL-SonarQube-Gradle #114

2017-09-19 Thread Apache Jenkins Server 
See 



-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 61472] Unable to evaluate dependent cell formula

2017-09-19 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=61472

Amol Gawali  changed:

   What|Removed |Added

Version|3.13-FINAL  |3.17-FINAL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org