Build failed in Jenkins: POI-DSL-Maven #95

2017-02-10 Thread Apache Jenkins Server
See Changes: [kiwiwings] SonarQube fixes and removed redundant logger level checks, for simple String messages -- [...truncated 1055 lines...] Running

[Bug 60724] New: SUBTOTAL() function doesn't skip auto-filtered rows

2017-02-10 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60724 Bug ID: 60724 Summary: SUBTOTAL() function doesn't skip auto-filtered rows Product: POI Version: 3.16-dev Hardware: All OS: All Status: NEW Severity:

[Bug 60416] Reduce Hyperlink memory consumption in SXSSF

2017-02-10 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60416 --- Comment #5 from Dominik Stadler --- Simple code-sample from the duplicated bug: -example code: SXSSFWorkbook wb = new SXSSFWorkbook(100); SXSSFSheet sheet = wb.createSheet(); CreationHelper createHelper =

[Bug 60723] Hyperlink Memory Leak

2017-02-10 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60723 Dominik Stadler changed: What|Removed |Added Resolution|--- |DUPLICATE

[Bug 60416] Reduce Hyperlink memory consumption in SXSSF

2017-02-10 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60416 Dominik Stadler changed: What|Removed |Added CC|

RE: NPOIFS, files and the read-only flag

2017-02-10 Thread Murphy, Mark
I guess I don't understand this that well, so please bear with me. With a File loaded read-write how are changes stored such that writing to a different OutputStream is not feasible? I don't think they are written back to the original File until a write operation is performed. Or is that

NPOIFS, files and the read-only flag

2017-02-10 Thread Nick Burch
Hi All Currently, in NPOIFS (NPOIFSFileSystem + POIFSFileSystem, but not OPOIFSFileSystem), you can either load from a File or from a Stream. With a Stream, everything gets buffered into memory When loading from a File, you can load read-write or read-only. In read-write mode, we use NIO to

Build failed in Jenkins: POI-DSL-Maven #94

2017-02-10 Thread Apache Jenkins Server
See Changes: [nick] Add a possible future TODO [nick] Use long for the dummy stream, to permit >2gb streams [nick] If a property refers to an invalid index, log + ignore rather than failing with a IndexOutOfBoundsException

Re: Build failed in Jenkins: POI-DSL-Maven #93

2017-02-10 Thread Dominik Stadler
This config runs a Maven-build from directory "sonar", so you need to adjust the pom.xml at https://svn.apache.org/viewvc/poi/trunk/sonar/pom.xml?revision=1780508=markup for this one. These are used to run the Sonar checks, however we could now try to do this in the Gradle-build and get rid of

[Bug 60601] Hyperlinks in original worksheet are not removed if there are no more hyperlinks on write.

2017-02-10 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60601 --- Comment #7 from Javen O'Neal --- I don't like the idea of suppressing exceptions, as they may catch an exception that we didn't intend to check. Does if (worksheet.isSetHyperlinks()) { worksheet.unsetHylerlinks();

[Bug 60670] Fails to create document nodes in MSI files larger than 2 GB

2017-02-10 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60670 --- Comment #7 from Nick Burch --- I've just tried with your program and your 3gb msi file, but I think the file might be corrupt? When I run the program, it fails with: Exception in thread "main"

Re: Build failed in Jenkins: POI-DSL-Maven #93

2017-02-10 Thread Javen O'Neal
I thought it was already doing that with https://svn.apache.org/viewvc/poi/trunk/build.gradle?revision=1782118=markup#l80 80 tasks.withType(JavaCompile) { 81

Re: Build failed in Jenkins: POI-DSL-Maven #93

2017-02-10 Thread Nick Burch
I think the key errors for this are things like: [WARNING] /home/jenkins/jenkins-slave/workspace/POI-DSL-Maven/sonar/main/src/test/java/org/apache/poi/ss/usermodel/TestDateUtil.java:[113,27] unmappable character for encoding US-ASCII [WARNING]

Build failed in Jenkins: POI-DSL-Maven #93

2017-02-10 Thread Apache Jenkins Server
See Changes: [nick] Update the big file test to use POIFSFileSystem.create(File), and tweak javadocs -- [...truncated 1055 lines...] Running org.apache.poi.hssf.record.chart.TestSeriesLabelsRecord

[Bug 60713] SXSSFWorkbook.write(OutputStream) close OutputStream

2017-02-10 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=60713 --- Comment #2 from Nick Burch --- I believe that all the write methods should be closing the streams, because once POI has finished writing to the File / Stream, there's nothing more that can be done to them. All the

Re: 3.16 Beta1 vs 3.15 FINAL

2017-02-10 Thread kiwiwings
jeevan86 wrote > By the way, any probable date decided on 3.16 FINAL release ? We will usually have 2 betas before a final and try to release often, which is currently every 2-3 month. I would expect the final to be announced by end of April. -- View this message in context:

Re: 3.16 Beta1 vs 3.15 FINAL

2017-02-10 Thread Jeevan Chamarthi
Thanks Andi and Javen. That helps a lot. I will go ahead and use 3.16 beta 1. By the way, any probable date decided on 3.16 FINAL release ? Regards, Jeevan On 2017-02-09 22:29 (+0530), "Javen O'Neal" wrote: > And might as well use 3.16-beta2 since it was just released. > >

Re: Evaluating expressions outside a cell value context

2017-02-10 Thread Andreas Beeker
Hi Greg, > but I won't make my first commit some behemoth that hasn't received any > feedback Sorry to read that, but I have to admit that I usually immediatly remove emails containing expressions like shift rows, cell style, formula evaluation ... You can try to stimulate a discussion / review,

SUBTOTAL "ignores hidden values" functions

2017-02-10 Thread Greg Woolsey
These are not yet implemented, I presume because they need to evaluate auto-filter conditions on cells, and hide rows as needed? This came up in a conversation with Vaadin over the conditional formatting work I'm doing. Anyone have any knowledge of that area, and the existing partial support for

Re: Evaluating expressions outside a cell value context

2017-02-10 Thread Greg Woolsey
Well, I couldn't stand the incomplete support, so now this supports evaluating rules for all the different types, including range aggregates like "greater than 2 standard deviations" and "top 10". Still doesn't provide help assigning partitioning buckets for icon sets and colors, but everything