Re: Inquiry Regarding SUMPRODUCT Support in Apache POI

On Tue, 21 Nov 2023, Reddy, Sri Rama wrote: I've recently encountered an issue with SUMPRODUCT advanced use cases in Apache POI What specifically didn't work? Detailed steps to reproduce the problem, and/or a failing junit unit test showing the issue, would be most helpful as outlined in

Re: POI PMC roll call

On Fri, 3 Mar 2023, PJ Fanning wrote: Apologies if anyone thinks I'm going in the wrong direction here. The TLDR is: I am asking if PMC members could respond with whether they are still interested in working on POI or if they are no longer in a position to help. Still here, still watching,

[jira] [Commented] (XMLBEANS-629) org.apache.xmlbeans.XmlObject.selectPath(String arg0) API returns wrong values after org.apache.xmlbeans.XmlCursor.moveXml(XmlCursor arg0) API call

[ https://issues.apache.org/jira/browse/XMLBEANS-629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17616342#comment-17616342 ] Nick Burch commented on XMLBEANS-629: - As was already stated, XmlBeans is in maintenance mode. Your

[jira] [Commented] (XMLBEANS-616) is there a dead lock in loading the SOAP Service Concurrently

[ https://issues.apache.org/jira/browse/XMLBEANS-616?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17562666#comment-17562666 ] Nick Burch commented on XMLBEANS-616: - What version of Apache XMLBeans are you using

Re: poi site - missing trademark declaration

On Thu, 9 Jun 2022, PJ Fanning wrote: The src/documentation/index.xml that we have for Forrest build seems to try to add it as a footer but it doesn't get picked up. I don't much about Forrest. Anyone know how this can be fixed? I've a few ideas, but currently I can't seem to build POI from a

Re: want to provide patch

On Thu, 28 Apr 2022, stanton fisque wrote: i'd like to provide a patch for some missing functionality, specifically the support handler for AverageIf (the generalized version is present but not the singular version). what is the best way to provide that? is there a repo where a pull request

Re: Duplicate classes in classpath from poi-ooxml-lite and ooxml-schemas

On Fri, 21 Jan 2022, Валерий Зайченко wrote: I used fr.opensagres.xdocreport:org.apache.poi.xwpf.converter.pdf:1.0.5 for convert *.docx files to *.pdf. That's a totally different project, which merely depends on Apache POI Can you please put in order dependencies for

Re: XWPF - worth adding helpers for creating styles?

On Wed, 22 Dec 2021, Nick Burch wrote: I was wondering about adding a couple of friendly helper methods on XWPFStyles, which would either set you up with some sensible default styles (inspired by the ones Word pops in a new file), or let you quickly add a bunch of header or paragraph styles

XWPF - worth adding helpers for creating styles?

Hi All I found myself wanting to create a DOCX file from scratch today, and in order to have it look nice that meant setting up a bunch of styles. It's a bit fiddly, and would've been pretty tough if I hadn't already been happy with reading the XML from word and re-doing that in CT xmlbeans

Re: flaky tests on CI/CD

On Thu, 25 Nov 2021, PJ Fanning wrote: There are other issues on the CI/CD tests. For example, https://ci-builds.apache.org/job/POI/job/POI-DSL-1.11/ just keeps failing with svn issues. It's like the machine(s) that support Java 11 have an issue. Is there somewhere we can report this? Based

Re: svn commit: r1889815 - in /poi/trunk: build.gradle gradle/wrapper/gradle-wrapper.jar gradle/wrapper/gradle-wrapper.properties gradlew gradlew.bat

On Wed, 12 May 2021, fannin...@apache.org wrote: Modified: poi/trunk/build.gradle poi/trunk/gradle/wrapper/gradle-wrapper.jar poi/trunk/gradle/wrapper/gradle-wrapper.properties poi/trunk/gradlew poi/trunk/gradlew.bat Need to be careful with the Gradle wrapper, see

Re: Commons IO dependency

On Tue, 4 May 2021, Andreas Beeker wrote: Any objections? (... I always wonder, why we haven't had commons-io as an dependency ...) Historically, we tried to avoid having too many dependencies. Partly that was to help downstream users with jar-hell, partly because many of our new users are

Re: TRIM function issue

On Tue, 16 Mar 2021, Emil Elmarsson wrote: I'm not sure where to contact you or if you have an issue tracker somewhere, so tell me if I should ask this question somewhere else. Apache POI uses Bugzilla for issue tracking: https://bz.apache.org/bugzilla/describecomponents.cgi?product=POI I

Re: Apache POI for Modular JavaFX Projects

On Tue, 23 Feb 2021, Julio Lopez wrote: My team and I have been using POI for quite some time now on our Java applications. We already developed a wide variety of applications that are being used in our company, thanks to your excellent Java-Excel tools. However, we came across this on a

Re: poi-ooxml-lite 5.0.0

On Tue, 2 Feb 2021, Feiger, Dieter wrote: I am locking for the source code of the poi-ooxml-lite of the Version 5.0.0. I am planning to use this library in one of my projects, but before I can do this the legal department has to check the terms and conditions of usage. This includes also the

Re: License file

On Tue, 12 Jan 2021, Andreas Beeker wrote: do we really need that long LICENSE file? Junit / Jacoco and few others aren't necessary to run POI and only used to build it. Do utility libraries need to be included in the official LICENSE file? If we ship them we need to detail them May we

Re: Website update

On Wed, 11 Nov 2020, Marius Volkhart wrote: I wanted to submit a change for the website (poi.apache.org) but I can't seem to find the files for the documentation. I found them at the last 2.x branch tag. The website source should be at I don't think

Re: XLSX wrapped in an OLE2 CompObj/Package - should WorkbookFactory handle it?

On Sun, 11 Oct 2020, Andreas Beeker wrote: Should we have WorkbookFactory spot this case, grab the OOXML out of the POIFS and try to load that? Actually I've updated the factories to handle that case - it might not work ... We should have an example in our test corpus - Dominik/Tim, can you

XLSX wrapped in an OLE2 CompObj/Package - should WorkbookFactory handle it?

Hi All Over on Stackoverflow there's a user who was getting what they thought was an embedded XSLX file out of a PPT, but finding it was an OLE2 wrapper with CompObj and Package entries. The real XLSX was in the Package part. Passing the outer

Re: Apache POI Example page is broken

On Wed, 29 Jul 2020, Ivan Mladenov wrote: it seems like Apache POI Examples web page is broken a lot (probably all) of links render 404HSSF and XSSF Examples Hmm, looks like there's a problem, eg http://poi.apache.org/components/spreadsheet/examples.html#business-plan links to

Re: XSSF doesn't work - but HSSF works fine

On Fri, 10 Jul 2020, Jan Fenten wrote: for school I need to analyse some xlsm files. I thought about using your API. But sadly the XSSF Workbook doesn't work properly. The HSSF does it's job fine, but I have to handle newer Office Versions and large tables. The error I get is the

Re: New Bugzilla version tag

On Sat, 15 Feb 2020, Andreas Beeker wrote: please do the Bugzilla magic (i.e. adding the version, disabling the old if necessary) for the released POI 4.1.2 version. 4.1.2-FINAL added, 4.1.0-FINAL disabled for new bugs, 4.1.1-FINAL and 4.1.x-dev unchanged + open Thanks Nick

Re: Feedback download.html

On Tue, 11 Feb 2020, Joris Aerts wrote: The changelog (https://poi.apache.org/changes.html) states there must be a version 4.1.2 of POI, released on 02-20-2020, but I can’t find it nowhere. Note that that date is in the future! It's a planned future release Is this version actually

Re: Snapshot repository

On Fri, 10 Jan 2020, Ghazi TRIKI wrote: I know that the latest snapshot can be downloaded from the official Jenkins. However I did not find it in any of the online repositories because I would like to use it on a project. Did I miss a repository where it could be in? Or is there a policy not

Re: Need help getting Specs for One Note versions older than 2012

On Mon, 23 Dec 2019, Nicholas DiPiazza wrote: Unfortunately, the formats are *drastically* different. Any attempt to reverse engineer would be a massive project... mostly impossible. Pesky. I have heard of that with products that get bought-in then redone, unusual for Microsoft fully in-house

Re: Need help getting Specs for One Note versions older than 2012

On Mon, 23 Dec 2019, Nicholas DiPiazza wrote: I'm needing some help gathering the older Spec documentation for Microsoft OneNote prior to year 2012. See https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-onestore/ae670cd2-4b38-4b24-82d1-87cfb2cc3725 and you'll notice that the

Re: Add 4.1.1 to Bugzilla

On Mon, 21 Oct 2019, Andreas Beeker wrote: On 20.10.19 22:47, Nick Burch wrote: Done! Open versions are now 4.0.1, 4.1.0, 4.1.1 and 4.1.x-dev. Shall I close off 4.0.1, or leave it open for now? Thank you Nick - please close 4.0.1. Disabled for new bugs (already open ones tagged

Re: Add 4.1.1 to Bugzilla

On Sun, 20 Oct 2019, Andreas Beeker wrote: please add 4.1.1 to our bugzilla. Done! Open versions are now 4.0.1, 4.1.0, 4.1.1 and 4.1.x-dev. Shall I close off 4.0.1, or leave it open for now? Cheers Nick - To unsubscribe,

Re: Add support for LocalDate/LocalDateTime

On Fri, 27 Sep 2019, Axel Howind wrote: since version 4.0.1, POI requires at least Java 8. I suggest adding support for the new Java Date/Time API introduced with that version of the JDK, i.e. `Cell.getLocalDateValue()` `Cell.getLocalDateTimeValue()` and two matching overloads of

Re: POIFS int size - limits size to 2G

On Mon, 15 Apr 2019, pj.fanning wrote: I'm not very familiar with the OLE specification that POIFS implements. Right now, we have the size parameter implemented as an int which means that we are limited to a file size of approx 2G. That's correct. That's a published restriction on OLE2 (CFB)

Re: Feedback download.html

On Thu, 8 Nov 2018, Gerardi Francesco (CAP-SST/ESM1) wrote: We are using poi 3.9 already for excel file generation and plan to migrate to 4.0 using enhanced excel graph features. There's a lot of bug fixes since 3.9! See everything above http://poi.apache.org/changes.html#3.9 A few

Re: Proposal - host javadocs of recent versions too

On Fri, 19 Oct 2018, Nick Burch wrote: The immediate change would be: * Everything at https://poi.apache.org/apidocs/ gets pushed to https://poi.apache.org/apidocs/dev/ * A new page at https://poi.apache.org/apidocs/ which says which versions you can see javadocs for online, and instructions

Proposal - host javadocs of recent versions too

Hi All As many of you will know, we have javadocs on the website, but these correspond to the latest (typically unreleased) code. Javadocs for a specific release are shipped in the binary package, and as a javadoc jar via Maven central (eg for IDE use). Based on stackoverflow posts though,

Re: POI 4.0.0 issues with new commons-compress library "InputStream of class [..] is not implementing InputStreamStatistics"

On Sat, 29 Sep 2018, Jörn Franke wrote: as part of the HadoopOffice library ( https://github.com/zuinnote/hadoopoffice/wiki) we provide the functionality to read office documents, such as MS Excel, on Big Data platforms, such as Hadoop/Hive/Spark/Flink. We should probably list that on the

Worth doing a 4.0.1 release soon?

Hi All It looks like we've had a few issues with 4.0.0, which while they're not a problem for most people, are a significant issue for a few of our user's platforms. Good news - they've all been fixed, and fixed super speedily, yey! :) Bad news - they're only fixed in svn... What do people

Re: Speaking on POI at China Open Source Conference in October

On Sat, 15 Sep 2018, Dave Fisher wrote: I’ll be at Apachecon Montreal, anyone else? I'll be there! Happy to look at draft slides then, and offer advice :) Nick - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For

Re: Provide alpha releases via Apache repo

On Fri, 7 Sep 2018, Alain FAGOT BÉAREZ wrote: This was also the way I started to contribute, first testing my changes against my pet project by local publishing Maven artifacts to my .m2 for a first try. However, there had been a steep step until I managed to gather all necessary info and…

Re: Provide alpha releases via Apache repo

On Fri, 7 Sep 2018, Dave Fisher wrote: Release Policy is such that publishing a snapshot to a public, open repository is not allowed. See http://www.apache.org/legal/release-policy.html#release-definition Just what I was

Re: POI 4.0.0 in bugzilla

On Thu, 6 Sep 2018, Andreas Beeker wrote: please check the bugzilla version tags and decide how to proceed with 4.0.0 and the upcoming - in a few months - 4.0.1 version. I've gone for * 4.0.0-FINAL * 4.0.x-dev I've also disabled 3.17-dev and a couple of the older 3.1x-FINAL versions from

Re: Help on POI JVM Languages Kotlin

On Wed, 6 Jun 2018, Luiz Oliveira wrote: I just finish some code in Kotlin using Apache POI and I see that you need a want some of this. The repository here https://github.com/ luizleiteoliveira/kotlin-poi-example How can I add my code on POI website? Do you mean adding a Kotlin section to

3.18? Or push for 4?

Hi All We released 3.17 back in September, which is over 6 months ago. The changelog says we've done quite a bit since then What do we think about another release? Do a 3.18, then breaking changes for 4.0 afterwards to release that in the summer? Or just

Re: Single Java 9 module jar?

On Thu, 19 Apr 2018, Michal Schielmann wrote: Is there any way to run poi with ooxml at the moment on Java 9? Apache POI works just fine with Java 9 on the classpath Java 9 / 10 module path is not supported at the moment Nick

Re: git repo is not in synch with svn

On Wed, 21 Mar 2018, pj.fanning wrote: Anyone know who to contact about https://github.com/apache/poi being out of sync with svn? What happens is that SVN syncs with http://git.apache.org/ , then Github syncs with that Drop an email to us...@infra.apache.org with details of the last SVN

Re: Single Java 9 module jar?

On Fri, 2 Mar 2018, pj.fanning wrote: Could we consider keeping all the jars but ensure that no package spans jars? We'd need to re-package all the jars by component / area. You couldn't have a HSSF only one for example, it'd need to be HSSF+XSSF+SS if there was to be no package spanning.

Single Java 9 module jar?

Hi All From my understanding of Java 9 modules, you basically can't have one package split across multiple jars. This is an issue for us, as we do split things betwen core, scratchpad and ooxml, to permit people to minimise their jar sizes by excluding components they don't want. Longer

RE: publishing poi xmlbeans jars

On Wed, 28 Feb 2018, pj.fanning wrote: http://mail-archives.apache.org/mod_mbox/attic-general/201802.mbox/%3C1519744891.257410.1285160920.6801732D%40webmail.messagingengine.com%3E Looks like we're not going to make much progress on resurrecting Apache XMLBeans. The big problem is with Maven

Re: XMLBeans in 4.0.0 release

On Wed, 10 Jan 2018, pj.fanning wrote: I don't fancy trying to merge the xmlbeans and poi ant builds. I've been trying for an hour or more and still getting issues. There's no need to do this! We'd keep the two codebases separate, and probably release at different times. (XMLBeans hardly

Re: XMLBeans in 4.0.0 release

On Mon, 8 Jan 2018, pj.fanning wrote: I understand the desire to replace XMLBeans altogether but I don't think we have enough developer time available to do this in the 4.0.0 time frame. Given the amount of work that'd take, and a desire for other features and bugs to be worked on in the

Re: svn commit: r1816500 [1/23] - in /poi/site: publish/apidocs/ publish/apidocs/org/apache/poi/class-use/ publish/apidocs/org/apache/poi/common/usermodel/fonts/ publish/apidocs/org/apache/poi/common/

On Mon, 27 Nov 2017, abea...@apache.org wrote: URL: http://svn.apache.org/viewvc?rev=1816500=rev Log: update status and javadocs for closed github-68 What jdk did you use to generate the javadocs? Generally we try to use (oldest POI supported + openjdk), so currently openjdk 8. Everyone using

Re: [DISCUSS] Getting a fixed version of XMLBeans

On Thu, 9 Nov 2017, Dave Fisher wrote: e) take XMLBeans out of the attic. Fix the bugs and make maintenance releases as 2.7, 2.8, etc. This would be an official version. Probably needs a board resolution. I think it might be enough for the Attic PMC to vote with 3 +1s to transfer the

Re: Suspected Spam:Re: Non-maintainer upload of bugfixes for the XMLBeans library in the Attic

On Thu, 9 Nov 2017, Dustin Spicuzza wrote: I'm curious, does anyone know the rationale for closing down the XMLBeans product in the first place? It doesn't seem to be stated on the XMLBeans website. See https://attic.apache.org/ for details of how the attic works and how things get put there.

Re: Excel formula saving oddity

On Fri, 9 Jun 2017, Greg Woolsey wrote: However, for unknown reasons not documented in Excel help as far as I can see, the named range reference has to be specified as: 'workbook file name.xlsx'!named_range however, when saving, the XML doesn't store the file name, but rather: [0]!named_range

XSSF tables - anyone know much about them?

Hi All Yesterday I came across a post on stackoverflow with a user having trouble with XSSF tables. In the process of fixing the bug they'd found, I also had a go at tidying up their code to reduce the need to touch the raw CT classes from end-user java code. As part of that, I've added a

Re: POI @ ApacheCon

On Mon, 15 May 2017, David North wrote: Who else is in Miami for ApacheCon? Do we have critical mass for an in-person chat over breakfast/beer/... ? I'm here! Nick - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For

Re: svn commit: r1795002 [3/3] - in /poi/trunk: ./ src/java/org/apache/poi/ss/usermodel/ src/ooxml/java/org/apache/poi/xssf/model/ src/ooxml/java/org/apache/poi/xssf/usermodel/ src/ooxml/testcases/org

On Fri, 12 May 2017, Greg Woolsey wrote: Argh, fat fingered it before I could type my comment. No worries! We all do it eventually... Don't forget you can edit the message later: http://stackoverflow.com/questions/2184317/change-svn-commit-message-retroactively My implementation is really

Re: svn commit: r1794084 - in /poi/trunk: src/java/org/apache/poi/hssf/usermodel/ src/java/org/apache/poi/ss/formula/ src/java/org/apache/poi/ss/usermodel/ src/ooxml/java/org/apache/poi/xssf/usermodel

On Fri, 5 May 2017, gwool...@apache.org wrote: Currently only implemented for XSSF, as there is no API available for HSSF conditional formatting rule number formats (if it is even in the files). Best way I can think of to check if it's stored - build a xlsx file with this in, save, open,

Re: New Bugzilla version entry

On Wed, 19 Apr 2017, Andreas Beeker wrote: please add a new version entry to our bugzilla. I've added two new versions: * 3.16-FINAL * 3.17-dev I've also edited two older versions to prevent new bugs being raised against them (old bugs are unchanged): * 3.15-dev * 3.12-FINAL Nick

NPOIFS, files and the read-only flag

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

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

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]

Re: Saving modified Workbook in place

On Wed, 1 Feb 2017, Murphy, Mark wrote: I thought that there was a way to save a workbook in place when using a File type input. But I can't find the secret sauce. The method will be write() with no arguments: https://poi.apache.org/apidocs/org/apache/poi/POIDocument.html#write() Off the top

Re: Evaluating expressions outside a cell value context

On Sat, 28 Jan 2017, Greg Woolsey wrote: As noted in one of the method JavaDocs, we also need to expose and make use of the ConditionalFormattingRule "priority" attribute. That's key to matching the right rule when more than one rule applies to a cell. Only the first match in priority order is

Re: Evaluating expressions outside a cell value context

On Fri, 27 Jan 2017, Greg Woolsey wrote: This can be done today by accessing the evaluate* package-scoped methods in o.a.p.ss.formula.WorkbookEvaluator from a class defined in that package. This requires some understanding of formula parsing and the resulting Ptg array, and uses a method

Re: Time for another release?

On Wed, 25 Jan 2017, Greg Woolsey wrote: I have something I'm going to file an issue about tomorrow, but it could wait. Although having it in would help fix some bugs I'm working around with Vaadin Spreadsheet. It would be my first official commit, so I don't want to do it near a code freeze,

Time for another release?

Hi All We seem to be about 2 months after our last beta release now, and about 4 months since our last final release. Is it worth doing another beta soon, to let people test possible breaking changes from some of the enum and deprecated stuff? Or hold off a bit longer, and just go for 3.16

Re: Using Apache Commons IO

On Tue, 17 Jan 2017, Javen O'Neal wrote: In the spirit of "the best code is no code", how would you feel about replacing our endian classes and IOUtils with Apache Commons IO? The downside is that it adds a dependency. https://poi.apache.org/overview.html#components How many classes do we

Re: svn commit: r1771220 - in /poi/site: publish/download.html src/documentation/content/xdocs/download.xml

On Thu, 24 Nov 2016, one...@apache.org wrote: URL: http://svn.apache.org/viewvc?rev=1771220=rev Log: remove snarky disclaimer The POI nightly builds are run on the https://builds.apache.org/view/POI/;>Jenkins continuous integration server. - Note that these are not officially verified

Re: Interesting question on SO

On Mon, 21 Nov 2016, Murphy, Mark wrote: http://stackoverflow.com/questions/40723370/was-opensagres-allowed-to-use-apache-poi-like-packages Does ASF defend its package names, or do we just ignore these kinds of things and folks use them at their own peril? I had a quick look at

Re: [Bug 59907] HSSFClientAnchor.setAnchorType API was broken (problem with jasperreports-5.1.0 and poi-3.14)

On Tue, 8 Nov 2016, bugzi...@apache.org wrote: (HX)SSFClientAnchor.setAnchorType(int) was restored in r1760617, which was after the release of POI 3.15 final. This will be available again in POI 3.16 beta 1 and 3.16 final. Is it worth doing a 3.16 beta 1 release quite soon, so that people

Re: Document validation hook in POIXMLDocument

On Sun, 30 Oct 2016, Mark Murphy wrote: Is there a validation hook in POIXMLDocument that will allow a document to validate itself before it writes itself to disk? Maybe prepareForCommit() ? (Need to call superclass too!) Here is the use case. An XWPFDocument header or footer must contain at

Re: svn commit: r1766520 - /poi/site/src/documentation/content/xdocs/status.xml

On Tue, 25 Oct 2016, Javen O'Neal wrote: Nick said in r1766520: Raw Release Notes for a few more releases, needs someone else to re-format them into the summary form Would it be better to paste the summary text into status.xml and write document2changes.xsl to create the list items by

Re: Apache POI 3.15 released

On Fri, 21 Oct 2016, Javen O'Neal wrote: In the meantime, what's the best way to retrieve old release notes? Were they committed to a private or public SVN server? We've been using svnpubsub for dist for a while (2011 IIRC), so you ought to be able to get them from there by asking SVN for the

Re: Functionality injection technique for XWPF

On Mon, 17 Oct 2016, Mark Murphy wrote: I found I should be able to do it using reflection to avoid long strings of instanceof conditions which is really the same as duplicating the code, but all inside one class. Any issue with using Reflection? If you post some of the code you're working

Re: Apache POI 3.15 released

On 29/09/16 15:29, Javen O'Neal wrote: Do we archive the release notes somewhere so that someone can read a high-level summary of the changes for each release? Digging through the dev@ email list archive to find the release notes draft or searching a web archiver of one of the mirrors at a date

Re: Minimal Java version requirement

On Sun, 25 Sep 2016, Yaniv Kunda wrote: What are the plans in regards to bumping the minimal Java runtime version for POI? None. Until there's a compelling feature to upgrade for, or enough users have upgraded, bumping the version will only make life hard for users. (Most people stuck on old

Re: [VOTE] Apache POI 3.15 RC3

On Wed, 21 Sep 2016, David North wrote: Nick - please can you sort the Bugzilla versions? Added 3.15-FINAL and 3.16-dev 3.14-dev and 3.11-FINAL disabled for new bugs Nick - To unsubscribe, e-mail:

Re: [VOTE] Apache POI 3.15 (RC1)

On Mon, 22 Aug 2016, Javen O'Neal wrote: switch (cell.getCellType()) { case Cell.CELL_TYPE_NUMERIC: I have fixed the backwards compatibility problem in r1757235. See [1] for more info. Thanks! Some of this stuff can be a real pain :( (Personally

Re: [VOTE] Apache POI 3.15 (RC1)

On Mon, 22 Aug 2016, Javen O'Neal wrote: Cell.CELL_TYPE_NUMERIC -> CellType.NUMERIC We can't make a backwards incompatible change of this magnitude just like that. It would break almost every single user of POI's code, as well as breaking almost every example of using POI that's out there!

Re: Image Blocks Text POI XSLF

On Tue, 9 Aug 2016, Javen O'Neal wrote: Slightly off topic... On Aug 9, 2016 3:10 PM, "Andreas Beeker" wrote: Then you unzip both files and find out the differences in the xml files. If you know which xml element to change, than you can modify it via the xmlbeans

Re: POI xlsx indeterminism

On Mon, 1 Aug 2016, armin.winte...@ldbv.bayern.de wrote: we've been experiencing an indeterminism problem with POI's xlsx format, when generating hash values with the following method in testng test cases: XLSX uses Zip files, which contain within them file dates. If you're comparing the

Re: 3.15 beta 3 soon?

On Sun, 31 Jul 2016, Nick Burch wrote: On Sun, 31 Jul 2016, Mark Murphy wrote: So does this mean the trunk is locked for beta 3? I have a couple changes to add, but I will not do so if we are going to roll a new beta soon. Could you hold off for a couple of hours? Just about to start

Re: 3.15 beta 3 soon?

On Sun, 31 Jul 2016, Mark Murphy wrote: So does this mean the trunk is locked for beta 3? I have a couple changes to add, but I will not do so if we are going to roll a new beta soon. Could you hold off for a couple of hours? Just about to start... Nick

Re: svn commit: r1754521 - in /poi/trunk: ./ maven/ src/java/org/apache/poi/hssf/usermodel/ src/java/org/apache/poi/ss/usermodel/ src/ooxml/java/org/apache/poi/xssf/streaming/ src/ooxml/java/org/apach

On Fri, 29 Jul 2016, dno...@apache.org wrote: Add a dependency on commons collections 4, also ASL licensed so no problem. Can you update http://poi.apache.org/overview.html#components to reflect the new dependency? poi/trunk/maven/poi-ooxml.pom Since HSSF uses it too, should it be the

Re: 3.15 beta 3 soon?

On Fri, 22 Jul 2016, Nick Burch wrote: On Fri, 22 Jul 2016, Andreas Beeker wrote: Who will roll the release? As usual, I'll be the fallback (as long as my key is valid ...) Anyone else want to give the docs a try? :) Actually, thinking about it, it'd be good to try to get POI 3.15 final out

Volunteers wanted - Test HSSF + HSLF in-place write + help document

Hi All About 10 years after someone first asked for it, we've finally gotten in-place-write and write-to-file available for HSSF! (And HSLF too) This means that if you open a HSSFWorkbook or HSLFSlideShowImpl from a File, in read-write mode (not read-only, which is the default), you can

Re: 3.15 beta 3 soon?

On Fri, 22 Jul 2016, Andreas Beeker wrote: When are your current tasks completed (e.g. in-place-writing...)? In-place write + write-to-File is now done for HSSF + HSLF + HPSF. That's probably enough for now. Once we've got some feedback, we can add it to HWPF, then decide how to do the same

Re: svn commit: r1752809 - in /poi/site/src/documentation/content/xdocs: book.xml download.xml

On Fri, 15 Jul 2016, Javen O'Neal wrote: I had the same idea. Would an https license URL need to be blessed by legal? Pass Someone from Creadur ought to know :) Nick - To unsubscribe, e-mail:

Re: poi-ruby.html no longer being built by Forrest

On Thu, 14 Jul 2016, Javen O'Neal wrote: After some recent changes to the site [1], "ant docs" no longer creates/updates publish/poi-ruby.html. I've just done a "svn up" and "ant docs", and poi-ruby.html was re-created for me Does Forrest have some rules about file naming (does

Re: svn commit: r1752809 - in /poi/site/src/documentation/content/xdocs: book.xml download.xml

On Fri, 15 Jul 2016, one...@apache.org wrote: Author: onealj Date: Fri Jul 15 09:55:48 2016 New Revision: 1752809 URL: http://svn.apache.org/viewvc?rev=1752809=rev Log: use http URL in Apache License for rat check It might be worth getting the Apache Creadur project (who maintain rat) if

Re: Regenerate and publish javadocs

On Tue, 12 Jul 2016, Dominik Stadler wrote: Ideally we would also update the Subversion repository as part of the config, but I did not want to put my credentials in there, not sure if there are some "automation" credentials or accessKeys available for such cases. You'd need to ask infra -

Re: DrawingML

On Fri, 8 Jul 2016, Murphy, Mark wrote: Much of the Chart code and other things are common parts between Spreadsheets, Documents, and Presentations. At least for the XML side of things. I propose that the DrawingML portions of these three projects be consolidated into a separate package or

Re: BitField#setValue is not a setter

On 04/07/16 03:17, Javen O'Neal wrote: Andi and I noticed a RV_RETURN_VALUE_IGNORED_NO_SIDE_EFFECT warning from FindBugs in HWPF. BitField#setValue is not a setter. It returns the value of the holder if a value was set through the BitMask. The BitField class should probably probably use a name

Re: [VOTE] Apache POI 3.15-beta2 release (RC1)

On Thu, 30 Jun 2016, Andreas Beeker wrote: I think we ought to fix that before the release, no? Actually I'd prefer to push the release and unfreeze the trunk. How about having a beta3 in a month and you skip beta2 for tika? As long as it's in the release notes clearly, and as long as we aim

Re: How do those of you who use Git produce patches

On Fri, 24 Jun 2016, Murphy, Mark wrote: I have a small change to xwpf that I am working on in a local Git repository, but I need to know how to create a patch. The documentation on the How to contribute page isn't particularly helpful. The easiest is probably to fork the POI github repo,

Re: [PATCH] Use of Hashtable in POI codebase

On Thu, 23 Jun 2016, Axel Howind wrote: Nick Burch gagravarr.org> writes: Patches to the list tend to get lost. Any chance you could either open a bugzilla entry and attach it there, or open it as a new pull request on github? I have created https://bz.apache.org/bugzilla/show_bug.cgi

Re: [PATCH] Use of Hashtable in POI codebase

On Wed, 22 Jun 2016, Axel Howind wrote: When looking at the current source, I noticed Hashtable still being used in a number of places. Is there any reason for not replacing all these hashtable instances with HashMap (besides TestContentType.java failing, see below)? I suspect just history!

Re: source code for org.apache.poi:poi-ooxml-schemas - 3.8

On Wed, 22 Jun 2016, Rongli Shi wrote: I have successfully build the project 'poi-3.8' and get the source jar 'ooxml-lib/ooxml-schemas-src-1.1.jar¹. Could this file be regarded as the original source code for 'poi-ooxml-schemas-3.8.jar¹? Sort of... See

Re: source code for org.apache.poi:poi-ooxml-schemas - 3.8

On Wed, 22 Jun 2016, Rongli Shi wrote: I could not find the source code of "poi-ooxml-schemas - 3.8" neither in the maven repository nor in the svn/git repo. See http://poi.apache.org/faq.html#faq-N10186 for details of how it is generated, and how to get the source Nick

Re: Finding deprecated methods

On Tue, 14 Jun 2016, Javen O'Neal wrote: Is there a smarter way to find deprecated classes besides checking out the code from 2 final releases ago and removing any deprecated code that still exists in trunk@HEAD? I'd probably attempt it with: * grep trunk for @deprecated with no date, with a

Re: Git

On Tue, 14 Jun 2016, Mark Murphy wrote: Trying to find documentation site on Git, but it does not appear to exist. Is this true? IIRC only trunk, branches and tags get mirrored into github. THe docs are in a different bit of the tree, in part so that the ASF webservers can watch svn for

3.15 beta 2 soon?

Hi All We're now about 2 months since we released 3.15-beta1, and it looks like we've got quite a few fixes and bits of new behaviour in, which is great! Based on bugzilla emails, we've also got a few user-contributed patches which are almost ready/fully-applied too. So, two questions: -

  1   2   3   4   5   6   7   >