Re: License file

2021-01-12 Thread Nick Burch
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 cr

Re: poi-ooxml-lite 5.0.0

2021-02-02 Thread Nick Burch
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 so

Re: Apache POI for Modular JavaFX Projects

2021-02-23 Thread Nick Burch
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 particul

Re: TRIM function issue

2021-03-16 Thread Nick Burch
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 was

Re: Commons IO dependency

2021-05-05 Thread Nick Burch
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 al

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

2021-05-13 Thread Nick Burch
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 https://issues.

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

2021-05-13 Thread Nick Burch
On Thu, 13 May 2021, PJ Fanning wrote: The gradle-wrapper.jar was already part of our builds. It is in our POI 5.0.0 source distribution. If we remove gradle wrapper dir from source distribution, we should remove the gradlew scripts too. Hopefully Dave can pop along in a bit to help answer a

Re: flaky tests on CI/CD

2021-11-25 Thread Nick Burch
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 o

XWPF - worth adding helpers for creating styles?

2021-12-22 Thread Nick Burch
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 cl

Re: XWPF - worth adding helpers for creating styles?

2021-12-23 Thread Nick Burch
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 by

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

2022-01-22 Thread Nick Burch
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 fr.opensagres.xdocreport:

Re: want to provide patch

2022-04-28 Thread Nick Burch
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 ca

Re: poi site - missing trademark declaration

2022-06-09 Thread Nick Burch
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: POI PMC roll call

2023-03-03 Thread Nick Burch
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, bu

Re: Inquiry Regarding SUMPRODUCT Support in Apache POI

2023-11-21 Thread Nick Burch
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 t

Worth doing a 4.0.1 release soon?

2018-09-19 Thread Nick Burch
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: POI 4.0.0 issues with new commons-compress library "InputStream of class [..] is not implementing InputStreamStatistics"

2018-09-29 Thread Nick Burch
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 web

Proposal - host javadocs of recent versions too

2018-10-19 Thread Nick Burch
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, th

Re: Proposal - host javadocs of recent versions too

2018-10-30 Thread Nick Burch
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

Re: Feedback download.html

2018-11-08 Thread Nick Burch
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 things

Re: POIFS int size - limits size to 2G

2019-04-15 Thread Nick Burch
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) fi

Re: Add support for LocalDate/LocalDateTime

2019-09-27 Thread Nick Burch
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 `Cell.setCellV

Re: Add 4.1.1 to Bugzilla

2019-10-20 Thread Nick Burch
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, e-

Re: Add 4.1.1 to Bugzilla

2019-10-22 Thread Nick Burch
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 with this

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

2019-12-23 Thread Nick Burch
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 spe

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

2019-12-23 Thread Nick Burch
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: Snapshot repository

2020-01-10 Thread Nick Burch
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 de

Re: Feedback download.html

2020-02-11 Thread Nick Burch
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 released,

Re: New Bugzilla version tag

2020-02-18 Thread Nick Burch
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: XSSF doesn't work - but HSSF works fine

2020-07-09 Thread Nick Burch
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 NoClassDefFoun

Re: Apache POI Example page is broken

2020-07-30 Thread Nick Burch
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 http://svn.apache

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

2020-10-09 Thread Nick Burch
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 OLE2

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

2020-10-13 Thread Nick Burch
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 pr

Re: Website update

2020-11-11 Thread Nick Burch
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: RawDataBlock IOException

2008-05-15 Thread Nick Burch
On Thu, 15 May 2008, Bowesman Antony wrote: I just tried 3.1-beta1 on one Word doc I have that is 28671 bytes, i.e. 55 blocks, + 511 bytes. Now that throws the following Exception The quick fix is to comment out the EOF=true in the short block section. I'm hoping to do a proper fix an day now

Re: RawDataBlock IOException

2008-05-20 Thread Nick Burch
On Thu, 15 May 2008, Bowesman Antony wrote: > I just tried 3.1-beta1 on one Word doc I have that is 28671 bytes, i.e. > 55 blocks, + 511 bytes. Now that throws the following Exception This should now be fixed properly in svn trunk Nick ---

Re: RawDataBlock IOException

2008-05-21 Thread Nick Burch
On Wed, 21 May 2008, Antony Bowesman wrote: Thanks Nick, I'll try it out with the forthcoming beta2. Alas it won't be in beta 2 - it was committed too late. You'll need a nightly build[1], or the release after Nick [1] http://encore.torchbox.com/poi-svn-build/ -

Re: [VOTE] Release POI 3.1-BETA2

2008-05-23 Thread Nick Burch
On Mon, 19 May 2008, Yegor Kozlov wrote: The release artifacts can be downloaded from the following URL: http://people.apache.org/~yegor/POI-3.1-BETA2/ +1 Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comma

Re: Word Maintainer

2008-05-23 Thread Nick Burch
On Mon, 19 May 2008, Squee wrote: I'm curious if there is anyone reviewing bugs & patches for the Word support at the moment. There's no-one dedicated to overseeing HWPF, so patches and bugs just get looked at whenever anyone else has the time to review them. I believe your patch has now gone

Re: Reg. Apache POI 3.1 beta release date..

2008-06-16 Thread Nick Burch
On Mon, 16 Jun 2008, Suresh786 wrote: Please let me know when can I expect a POI build with HSSFHyperlink ? 3.1 beta 2: http://www.apache.org/dyn/closer.cgi/poi/dev/ nightly builds: http://encore.torchbox.com/poi-svn-build/ Either of those should work for you Nick ---

Re: Help search and replace

2008-06-18 Thread Nick Burch
On Wed, 18 Jun 2008, Fabio Alves de Araujo Ebner - Dna wrote: hira.. can u help me?? i got the poi directorie from http://svn.apache.org/repos/asf but i think i got something wrong. You might find the nightly builds easier to use: http://encore.torchbox.com/poi-svn-build/ come +/- 3

Re: Help search and replace

2008-06-18 Thread Nick Burch
On Wed, 18 Jun 2008, Fabio Alves de Araujo Ebner - Dna wrote: nick tanks.. i got the files poi*2008061.jar but i don't find the method replaceText In the scratchpad jar, org.apache.poi.hwpf.usermodel.Range has replaceText, and its children inherit it Nick --

Re: Help search and replace

2008-06-18 Thread Nick Burch
On Wed, 18 Jun 2008, Fabio Alves de Araujo Ebner - Dna wrote: nice i've found.. but do you know here i got some documentation from that method?? Have you tried the online version of the javadocs? http://poi.apache.org/apidocs/org/apache/poi/hwpf/usermodel/Range.html#replaceText(java.lang.String

Re: [vote] Release POI-3.1-FINAL

2008-06-28 Thread Nick Burch
On Sat, 21 Jun 2008, Yegor Kozlov wrote: Please vote and give your feedback: +1 Incidently, I think it may be worth doing a 3.1.1 FINAL release in a 6-8 week timeframe. My experiences recently have been that it's much easier to port fixes trunk -> ooxml branch, compared to ooxml branch -> t

Re: [vote] Release POI-3.1-FINAL

2008-06-30 Thread Nick Burch
On Mon, 30 Jun 2008, Yegor Kozlov wrote: I think the release procedure for maintenance releases can be quicker, otherwise we should start voting on 3.1.1. right now :) Personally, I think we can do it in one step and skip betas. That works for me. I don't think we're going to see many / any ne

[vote] Release 3.5.1 beta 1 (from ooxml branch)

2008-07-07 Thread Nick Burch
Hi All Now that we have the OK from the board and the legal committee, I think it's time for our first beta release from the ooxml branch. The release artifacts can be downloaded from: http://people.apache.org/~nick/POI-3.5.1-beta1/ including the main parts in: http://people.ap

Re: [vote] Release 3.5.1 beta 1 (from ooxml branch)

2008-07-07 Thread Nick Burch
On Mon, 7 Jul 2008, Nick Burch wrote: Finally, voting will be open until this Friday, 11th July. Please vote: I'm +1 Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [vote] Release 3.5.1 beta 1 (from ooxml branch)

2008-07-10 Thread Nick Burch
On Thu, 10 Jul 2008, Yegor Kozlov wrote: (1) I expect the main POI jar (poi-3.5-*.jar) to be compatible with 3.1 and earlier releases. 3.1 has just been released and I expected 3.05-beta1 to be roughly equivalent. Unfortunately it is no so. org.apache.poi.hssf.util.Region was moved to org.apac

Re: [vote] Release 3.5.1 beta 1 (from ooxml branch)

2008-07-10 Thread Nick Burch
On Thu, 10 Jul 2008, Yegor Kozlov wrote: It makes sense to prolong the vote for another week. Yup, I'll restart the count and vote period once I do the new artifacts Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additi

[vote] Release 3.5.1 beta 1 20080718 (from ooxml branch)

2008-07-11 Thread Nick Burch
Hi All Yegor spotted we'd missed one file out of the previous beta artifacts, so we're trying again. As with last time, these have been produced from the ooxml branch, with fixes from trunk as of last night merged in. The new release artifacts can be downloaded from: http://people.apa

Re: HSSFHyperlink

2008-07-11 Thread Nick Burch
On Fri, 11 Jul 2008, swan wrote: Thanks! For your reply! But I need to read the cell hyperlink not to write in back in excel. Just use poi 3.1, that has proper excel hyperlink support in it Nick - To unsubscribe, e-mail: [EMA

Re: [vote] Release 3.5.1 beta 1 20080718 (from ooxml branch)

2008-07-12 Thread Nick Burch
On Fri, 11 Jul 2008, Josh Micich wrote: "Type mismatch: cannot convert from Region to Region" org.apache.poi.hssf.util.Region -> org.apache.poi.ss.util.Region These were related to hssf.util.Region going walkies. I've fixed this in svn "The import org.apache.poi.hssf.usermodel.HSSFFormulaEv

Re: changed API when introducing ss to hssf, add old as @deprecated?

2008-07-18 Thread Nick Burch
On Fri, 18 Jul 2008, Rainer Schwarze wrote: I'm trying to work with JasperReports 3.0.0 which is built against POI-3.0.1-FINAL. When I use a newer POI library, it complains, because interfaces changed such as HSSFCell.setCellStyle(HSSFCellStyle) being now HSSFCell.setCellStyle(CellStyle). I'm

[ANNOUNCE] Apache POI 3.5.1 Beta 1 Released

2008-07-18 Thread Nick Burch
le via Maven, as the dependencies are not packaged. For the Apache POI Team Nick Burch - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [ANNOUNCE] Apache POI 3.5.1 Beta 1 Released

2008-07-18 Thread Nick Burch
On Fri, 18 Jul 2008, Nick Burch wrote: The POI team is pleased to announce the availability of Apache POI 3.5.1 beta 1, our first release including OOXML (Office Open XML) support. Just to let everyone here know that I'm aiming to do beta releases around once a month, until we're

Re: changed API when introducing ss to hssf, add old as @deprecated?

2008-07-20 Thread Nick Burch
On Fri, 18 Jul 2008, Rainer Schwarze wrote: java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFCell.setCellStyle(Lorg/apache/poi/hssf/usermodel/HSSFCellStyle;)V at net.sf.jasperreports.engine.export.JRXlsExporter.setCell(JRXlsExporter.java:208) ... (+ some more lines) Ah, that's

Re: HWPF dependency on HSSF

2008-07-21 Thread Nick Burch
On Sat, 19 Jul 2008, Jason Harrop wrote: I would like to create a jar containing only the stuff necessary to work with HWPF. I can remove hssf, except that 5 classes in org.apache.poi.ddf depend on org.apache.poi.hssf.record.RecordFormatException For now, you'd probably want to just include t

Re: changed API when introducing ss to hssf, add old as @deprecated?

2008-07-21 Thread Nick Burch
On Sun, 20 Jul 2008, Rainer Schwarze wrote: However, I don't see why we can't add in the overloaded method for common cases that people use. So, I've done it for this case, and I'm happy for it to happen for other common ones, I just won't go looking for them! Thanks. Here is another case wit

Moving XSSFRelation out of XSSFWorkbook

2008-07-29 Thread Nick Burch
Hi All Currently, within XSSFWorkbook there is an inner class, XSSFRelation. This handles things like content types, relationship types, default file names, loading and saving parts etc. There's also a long list of public static final XSSFRelations defined in there too. In recent weeks, the

Re: java.lang.NegativeArraySizeException

2008-07-30 Thread Nick Burch
On Wed, 30 Jul 2008, jigna joshi wrote: poi-3.0.1-FINAL-20070705.jar, poi-contrib-3.0.1-FINAL-20070705.jar, poi-scratchpad-3.0.1-FINAL-20070705.jar jars for reading content of documents.. I am getting below exception when I try to read password protected document. We added detection of passw

Re: java.lang.NegativeArraySizeException

2008-07-31 Thread Nick Burch
On Thu, 31 Jul 2008, jigna joshi wrote: thanx for d reply in the new release, the EncryptedDocumentException would be thrown that it is written.. but, is there a fix for reading password protected file or just i have to ignore that file.. Reading password protected files is not supported. The d

Re: java.lang.NegativeArraySizeException

2008-07-31 Thread Nick Burch
On Thu, 31 Jul 2008, jigna joshi wrote: I have taken newer release of jars (poi-bin-3.5-beta1-20080718) but, when i try to read .docx file, it gives below exception. com.asite.collab.content.util.DocumentContentSearchException: Error indexing word document. The supplied data appears to be in the

Re: java.lang.NegativeArraySizeException

2008-07-31 Thread Nick Burch
On Thu, 31 Jul 2008, Andy Oliver wrote: http://rechten.uvt.nl/koops/cryptolaw/cls2.htm#us gives kind of a history of this. Because Apache servers are in the US, US law is supreme here, but individuals may have other issues in their home countries. It looks like we're now in the clear to imple

Re: java.lang.NegativeArraySizeException

2008-07-31 Thread Nick Burch
On Thu, 31 Jul 2008, jigna joshi wrote: As i have mentioned in d earlier msg, i am getting org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. POI only supports OLE2 Office documents Exception when i try to read content of .docx file..

Re: java.lang.NegativeArraySizeException

2008-07-31 Thread Nick Burch
On Thu, 31 Jul 2008, Andy Oliver wrote: So it looks to me like it is in the clear. I'll check my old laptops for the prototype code I wrote that semi-implements this. It is against a pretty out of date version (~1.x-ish) but might be relevant at least for the binary formats. Sounds good. Gi

Re: java.lang.NegativeArraySizeException

2008-08-01 Thread Nick Burch
On Fri, 1 Aug 2008, jigna joshi wrote: do you have docmentation (API) for POI3.5.1beta version.. It's all in the /docs/ directory of the download org.apache.xmlbeans.XmlException: error: The document is not a [EMAIL PROTECTED]://schemas.openxmlformats.org/spreadsheetml/2006/main: document ele

Re: missing HSSFPatriarch class in POI final version 3.1

2008-08-04 Thread Nick Burch
On Mon, 4 Aug 2008, MY POI wrote: I downloaded poi latest version 3.1.. But this jar doesnt have the HSSFPatriarch class which it is available in previous versions.. Hmm, no, it does: unzip -l poi-3.1-FINAL.jar | grep HSSFPatriarch 5360 06-29-08 16:43 org/apache/poi/hssf/usermodel/HSS

Re: The document is not a workb...@http://schemas.openxmlformats.org/spreadsheetml/2006/main

2008-08-05 Thread Nick Burch
On Tue, 5 Aug 2008, jigna joshi wrote: Exception: java.io.IOException: org.apache.xmlbeans.XmlException: error: The document is not a [EMAIL PROTECTED]://schemas.openxmlformats.org/spreadsheetml/2006/main: document element namespace mismatch expected "http://schemas.openxmlformats.org/spreadshee

Re: missing HSSFPatriarch class in POI final version 3.1

2008-08-05 Thread Nick Burch
On Tue, 5 Aug 2008, MY POI wrote: Today i downloaded the files. poi-3.1-FINAL-20080629 poi-contrib-3.1-FINAL-20080629 poi-scratchpad-3.1-FINAL-20080629 I have one doubt.The second jar file has contrib\metrics classes.But the first jar doesnt have. That's normal. All three jars contain differe

Re: How to read pptx file

2008-08-06 Thread Nick Burch
On Wed, 6 Aug 2008, jigna joshi wrote: I have written code to read ppt file, but not getting how to read pptx file. i want example working for both ppt and pptx files.. There isn't really a high level interface to xslf yet, only the low level xml beans stuff. Take a look at XSLFPowerPointExtra

Re: missing HSSFPatriarch class in POI final version 3.1

2008-08-06 Thread Nick Burch
On Wed, 6 Aug 2008, MY POI wrote: yes now i understood..But one problem is here.. With Previous jar i can export the data for open office excel files. But current version jar i can view the data only with microsoft files only.. I'm not sure what you're saying here. POI only supports microsoft

HWPF and unicode ranges

2008-08-09 Thread Nick Burch
Hi All I've been doing a lot of work on HWPF today, and have done quite an overhaul of the unicode support for text pieces and ranges. The main upshot is that getRange on a document now returns the right text for unicode and non-unicode, and doesn't sometimes wander off into the header defin

Re: POI 3.1.1 is planned for release

2008-08-12 Thread Nick Burch
On Tue, 12 Aug 2008, Yegor Kozlov wrote: I'm planning to produce the release artifacts in a week's time targeting POI-3.1.1-FINAL in early September. Sounds good to me. I'm also planning to do another poi 3.5 beta release in a day or so, similarly shout if you have code that won't make it in f

Release 3.5 beta 2 (from ooxml branch)

2008-08-15 Thread Nick Burch
Hi All It's a little over a month since our last 3.5 beta release, and in the mean time there have been quite a few bug fixes. So, I think it's time for our next beta. The release artifacts can be downloaded from: http://people.apache.org/~nick/POI-3.5-beta2/ including the main parts

Re: changed API when introducing ss to hssf, add old as @deprecated?

2008-08-27 Thread Nick Burch
On Sun, 24 Aug 2008, Wonne Keysers wrote: While trying to use Jasper Reports (2.0.4) I get the stack trace below. Would it be possible to re-introduce the method org.apache.poi.hssf.usermodel.HSSFSheet.addMergedRegion(Lorg/apache/poi/hssf/util/Region) addMergedRegion(Region) is deprecated in tr

Re: POI 3.5 beta as a pom dependency

2008-09-08 Thread Nick Burch
On Mon, 8 Sep 2008, Paolo Mottadelli wrote: It would be great to provide a maven pom (to manage POI dependencies) for the POI 3.5 beta release. Having that pom, we will be able to include POI 3.5 as a dependency in a maven built project. At the moment I have to manually copy/paste dependencies' j

Re: POI 3.5 beta as a pom dependency

2008-09-09 Thread Nick Burch
On Mon, 8 Sep 2008, Paolo Mottadelli wrote: The think we certainly need to talk to repository about is ooxml-schemas. That's generated from the Ecma supplied xsds by xmlbeans. No idea what the procedure is for getting that into the maven accessible repo. What about making the ooxml-schema packa

Re: OOXML branch and JDK 1.4

2008-09-12 Thread Nick Burch
On Fri, 12 Sep 2008, Yegor Kozlov wrote: Currently only ooxml code uses JDK 1.5 features. The OLE2 stuff is compatible with jdk 1.4. That means we can't use enums, generics and other 1.5 features in HSSF and other OLE2 projects. Back in january, then plan for 3.5 was that it'd be a drop in rep

Re: OOXML branch and JDK 1.4

2008-09-12 Thread Nick Burch
On Fri, 12 Sep 2008, Yegor Kozlov wrote: I got the point about merging. Although my plan would be to release 3.2, switch ooxml to trunk and start using jdk 1.5. I worry then that we wouldn't get an ooxml release before christmas. We'd originally hoped for one in July :/ How about a near sync

Re: OOXML branch and JDK 1.4

2008-09-13 Thread Nick Burch
On Fri, 12 Sep 2008, David Fisher wrote: Summary so far: 5 are +1 ... and 0 -1. I'd say mine's a -1 to changing it just now. I'd like to see the jdk 1.4 requirement dropped, but as previously mentioned I think we ought to get 3.2 and 3.5 out first. Speaking of which, I'll probably build the

Re: POIFSFileSystem.getRoot - NoSuchMethodError

2008-09-17 Thread Nick Burch
On Wed, 17 Sep 2008, Antony Bowesman wrote: Just can work out what's wrong here - I know it's probably a classpath issue, but I'm getting java.lang.NoSuchMethodError: org.apache.poi.poifs.filesystem.POIFSFileSystem.getRoot()Lorg/apache/poi/poifs/filesystem/DirectoryNode Try following the sug

[vote] Release 3.5 beta 3 (from ooxml branch)

2008-09-21 Thread Nick Burch
Hi All It's two months since our last 3.5 beta release which passed (the previous vote failed as too many people were on holiday). Once again, in the mean time there have been quite a few bug fixes. So, I think it's time for our next beta. This beta, beta 3, is was created as of the state of t

Re: Can't find CellRangeAddress Class in poi-3.1-FINAL-20080629.jar

2008-09-24 Thread Nick Burch
On Wed, 24 Sep 2008, leocoppens wrote: Hi, I'm just starting with POI and found a problem I can't solve unless I use a deprecated method (which I don't want) I think CellRangeAddress went in after 3.1 final. Try using a recent nightly build / svn checkout Nick --

Application Period Opens for Travel Assistance to ApacheCon US 2008

2008-09-26 Thread Nick Burch
The Travel Assistance Committee is taking in applications for those wanting to attend ApacheCon US 2008 between the 3rd and 7th November 2008 in New Orleans. The Travel Assistance Committee is looking for people who would like to be able to attend ApacheCon US 2008 who need some financial support

Re: [vote] Release 3.5 beta 3 (from ooxml branch)

2008-09-26 Thread Nick Burch
On Sun, 21 Sep 2008, Nick Burch wrote: Finally, voting will be open until Friday, 26th September. Please vote: Whoops, I forgot to vote before. Strangely enough, I'm +1 Voting'll end tonight Nick - To unsubscri

Re: [vote] Release 3.5 beta 3 (from ooxml branch)

2008-09-28 Thread Nick Burch
On Sun, 21 Sep 2008, Nick Burch wrote: Finally, voting will be open until Friday, 26th September. This vote has passed, with 4 pmc +1 votes. Release artificats should be hitting the mirrors shortly Nick - To unsubscribe, e

[ANNOUNCE] Apache POI 3.5 Beta 3 Released

2008-09-28 Thread Nick Burch
"org.apache.poi" and Version "3.5-beta3". Note that the ooxml support is not available via Maven, as the dependencies are not packaged. For the Apache POI Team Nick Burch - To unsubscribe, e-mail: [EMAIL PROTE

Re: Question about license of a file in poi-scratchpad-3.1-FINAL-20080629.jar

2008-10-07 Thread Nick Burch
On Tue, 7 Oct 2008, Jean T. Anderson wrote: My day job is using POI on a project, and somebody noticed that org/apache/poi/hdgf/chunks/chunks_parse_cmds.tbl in poi-scratchpad-3.1-FINAL-20080629.jar has a GNU Version 3 license. You might find it worth reading: http://svn.apache.org/repo

Re: ERROR

2008-10-16 Thread Nick Burch
On Thu, 16 Oct 2008, Fabio Alves de Araujo Ebner - Dna wrote: Why sometimes i got that error: java.lang.IllegalArgumentException: The end (225) must not be before the start (239) Looks to me like you're asking for some text, between 239 and 225, which is a negative range and hwpf gets unhapp

Re: Help new Warning

2008-10-16 Thread Nick Burch
On Wed, 15 Oct 2008, Fabio Alves de Araujo Ebner - Dna wrote: can ayone know why i got that warning?? Your document seemed to be mostly unicode, but the section definition was in bytes! Trying anyway, but things may well go wrong! POI is now detecting and working around a problem with a sligh

Re: [VOTE] Release of POI 3.2-FINAL

2008-10-16 Thread Nick Burch
On Sat, 11 Oct 2008, Yegor Kozlov wrote: The vote options are: +1 Nick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: OOXML and Maven dependencies

2008-10-27 Thread Nick Burch
On Mon, 27 Oct 2008, Yegor Kozlov wrote: The artifacts for both (1) and (2) are available for review till Friday, October 31. Then I'm going to upload them in the repository. Please review if you are interested in it. I have a feeling that the process for openxml4j will need to be slightly di

Re: Help - Unable to refresh formula

2008-10-27 Thread Nick Burch
On Sat, 25 Oct 2008, m.mail7 wrote: Formula like =MAX(H) is not getting updated till i manually go to formula bar (fx) and hit return. Please suggest me how to update this thru java code. http://poi.apache.org/hssf/eval.html Nick ---

Re: Bug 42420 still happens

2008-10-27 Thread Nick Burch
On Fri, 24 Oct 2008, Seung Lee wrote: My XL chart has two work sheets. Work sheet #1 contains data. Work sheet #2 contains a chart that is based on the data in work sheet #1. Charts are somewhat problematic at the moment. More work is needed on them, but so far no-one's sponsored the needed

Re: importing utility

2008-10-31 Thread Nick Burch
On Sat, 25 Oct 2008, David Durham, Jr. wrote: I wrote an easy to use import utility using POI that I'd like to contribute to this project if there's any interest. Here's the project: http://code.google.com/p/beanfiles/ http://code.google.com/p/beanfiles/wiki/Examples It looks very interesti

Re: Code for extraction of data from Ole10Native

2008-11-12 Thread Nick Burch
On Tue, 11 Nov 2008, Rainer Schwarze wrote: some time ago I wrote some code for retrieving data from an Ole10Native structure. I would like to polish it slightly and submit it. Is there a recommended location in POI class hierarchy / packages for it? I'd say hssf.model or hssf.usermodel, depend

http://poi.apache.org/hssf/

2008-11-13 Thread Nick Burch
Hi All Anyone own up to deploying the new site layout from trunk, without installing a redirect from /hssf/ to /spreadsheet/ ? I've setup a .htaccess redirect, so anyone with links/bookmarks to the old pages can carry on using them just fine. One to watch out for in the future though! Nick

Re: HDGF, chunks_parse_cmds.tbl, and GPLv3

2008-12-08 Thread Nick Burch
On Sun, 7 Dec 2008, Jukka Zitting wrote: We may want to argue on legal-discuss@ whether the GPLv3 section 4 would allow us to treat it as a category B license in http://www.apache.org/legal/resolved.html, but until that I don't think it's a good idea to include any GPLv3 files in Apache svn or

Re: java.io.IOException: Invalid header signature

2008-12-09 Thread Nick Burch
On Tue, 9 Dec 2008, Priyabrata Sahu -X (prsahu - TCS at Cisco) wrote: For some of the specific excel files, I am getting the following error. java.io.IOException: Invalid header signature; read 7888090397404325948, expected -2226271756974174256 This means that your file isn't a valid OLE2 file

Re: HDGF, chunks_parse_cmds.tbl, and GPLv3

2008-12-09 Thread Nick Burch
On Mon, 8 Dec 2008, Nick Burch wrote: So, yes, one for legal-discuss for now. I'll go and subscribe, Yukka do you want to kick of the issue over there to get us started? I have an email ready to go to legal-discuss about this, but I'm holding off for a few days. I'm talking wit

  1   2   3   4   5   6   7   8   9   >