Re: Sonar statistics for Apache POI

2014-03-31 Thread Nick Burch
On Mon, 31 Mar 2014, Dominik Stadler wrote: thanks to SonarSource and their public SonarQube instance we now finally have weekly code quality reports for Apache POI on http://nemo.sonarqube.org/dashboard/index/574959 available. Hmm, interesting! Based on that, two things spring to mind: *

Re: Digital signature on MS-Office documents

2014-03-20 Thread Nick Burch
On Wed, 19 Mar 2014, ff_bogard wrote: Please, could someone point me in the right direction to digitally sign an Office document (docx, xlsx, pptx) using Apache POI? There was a proposed feature from Ugo to implement this several years ago, but there were a few issues found with it. Sadly Ugo

Removing 1.5 workarounds now we're on 1.6

2014-03-04 Thread Nick Burch
Hi All As previously discussed, the next version of Apache POI will require Java 1.6, and the trunk build has been updated to use that This means that our 1.5 workarounds can now be removed! I've just zapped one from the date stuff, and it looks like StandardDecryptor may have one that can

Re: Site not building?

2014-02-19 Thread Nick Burch
On Wed, 19 Feb 2014, kiwiwings wrote: did you update to forrest.properties in the poi root directory? Hmm, we seem to have two different forrest.properties files: https://svn.apache.org/repos/asf/poi/site/forrest.properties https://svn.apache.org/repos/asf/poi/trunk/forrest.properties And

Re: Site not building?

2014-02-19 Thread Nick Burch
On Wed, 19 Feb 2014, Andreas Beeker wrote: I've linked the site-file into the trunk. Hopefully the svn update works for you guys. Looks to, thanks for sorting this Nick - To unsubscribe, e-mail:

Site not building?

2014-02-18 Thread Nick Burch
Is anyone else able to build the site at the moment? When I try, it fails with an error about the changelog file: [java] X [0] changes.html BROKEN: The processing instruction target matching [xX][mM][lL] is not allowed. [java] Total time: 0 minutes 4 seconds

Re: Site not building?

2014-02-18 Thread Nick Burch
On Wed, 19 Feb 2014, Andreas Beeker wrote: My error was that I simply copied the license header before the xml declaration and then haven't checked for its validity ... anyways it's fixed now. Thanks for fixing this. I can confirm that I can once again build the site! Thanks Nick

Re: Rule M2.4 exception

2014-02-14 Thread Nick Burch
On Fri, 14 Feb 2014, Andrew Weiss wrote: Are you still concerned about: org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Rule M2.4 exception : this error should NEVER happen, if so please send a mail to the developers team, thanks ! I am using 3.9, downloaded about a month ago.

Re: XSSF/HSSF contribution/suggestion

2014-02-05 Thread Nick Burch
On Thu, 23 Jan 2014, Johannes Kinscher wrote: The reason I'm writing is that I'm using POI now for more than two years and I'd like to make some improvements to the API regarding spreadsheets (XSSF/HSSF). The problem in most cases is, that the API contains non-intuitive ways of doing things

Re: svn commit: r1563540 - in /poi: site/src/documentation/content/xdocs/ trunk/src/ooxml/java/org/apache/poi/openxml4j/opc/ trunk/src/ooxml/java/org/apache/poi/xssf/usermodel/ trunk/src/ooxml/testcas

2014-02-02 Thread Nick Burch
On Sun, 2 Feb 2014, kiwiwi...@apache.org wrote: public final class PackageRelationshipCollection implements - IterablePackageRelationship { +IterablePackageRelationship { private static POILogger logger = POILogFactory.getLogger(PackageRelationshipCollection.class);

Re: Exception in thread main java.lang.NoClassDefFoundError: org/apache/poi/ss/formula/udf/IndexedUDFFinder

2014-02-02 Thread Nick Burch
On Sat, 1 Feb 2014, Nihali wrote: poi-ooxml-schemas-3.8.jar,poi-ooxml-3.10-beta2.jar,poi-3.8.jar,dom4j-1.6.1.jar and xmlbeans-2.3.0.jar You must have a consistent set of POI jars, you can't just mix between release as you're doing there. 3.8 + 3.10 beta2 mix of jars = broken, as you've

Re: [VOTE] Release POI 3.10-FINAL - Take 2

2014-02-02 Thread Nick Burch
On Sat, 1 Feb 2014, Yegor Kozlov wrote: A candidate for the POI-3.10-FINAL release is available at https://dist.apache.org/repos/dist/dev/poi/ Signatures are good, hashes match, rat check on the source package passes, source package builds without error, so the main things are good

Re: [VOTE] Release POI 3.10-FINAL - Take 2

2014-02-02 Thread Nick Burch
On Sun, 2 Feb 2014, Nick Burch wrote: Secondly, the NOTICE has Copyright 2009 The Apache Software Foundation in it. Not sure if that should be 2003-2013 (first release in Jakarta was 2003), or just 2014 (for the current year)? Not a blocker either, but one we need to work out then fix soonish

Re: Abandon JDK 1.5 support?

2014-01-26 Thread Nick Burch
On Sun, 26 Jan 2014, Andreas Beeker wrote: I regularly need to workaround limitations in the jdk 1.5 api. Sometimes this is not so straightforward, as with the latest svn commit, which uses NavigableSet features of 1.6. If you look in the codebase, you'll see a few bits that only work on

Re: svn commit: r1561500 [1/3] - in /poi/trunk/src/ooxml/java/org/apache/poi: util/java7_util/ xssf/usermodel/helpers/

2014-01-26 Thread Nick Burch
On Sun, 26 Jan 2014, kiwiwi...@apache.org wrote: Author: kiwiwings Date: Sun Jan 26 15:01:12 2014 New Revision: 1561500 URL: http://svn.apache.org/r1561500 Log: As Jdk 1.5 doesn't provide NavigableMap/Set classes of JDK 1.6, we temporarily use the open jdk classes instead, until POI has

Re: XLSB support

2014-01-24 Thread Nick Burch
On Sat, 25 Jan 2014, Nirk Niggler wrote: What is the current status of XLSB support? Is this on the roadmap? None, and no It would be rather a lot of work, as you'd both need to update records to cope with the longer/different format, then redo all the marshling stuff to handle the very

Re: [VOTE] Release POI 3.10-FINAL

2014-01-20 Thread Nick Burch
On Mon, 20 Jan 2014, Yegor Kozlov wrote: Should we include rat-check in the dist target? it should be pedantic IMO. There is no point to generate a release with missing licence headers. Before a release, I'd say that everything either needs a license header, or have been listed in the

Re: [VOTE] Release POI 3.10-FINAL

2014-01-19 Thread Nick Burch
On Thu, 16 Jan 2014, Yegor Kozlov wrote: A candidate for the POI-3.10-FINAL release is available at: https://dist.apache.org/repos/dist/dev/poi/ Sorry, but I'm going to have to -1 this release Several of the files in the src package seem to be missing license headers, as shown from ant

Re: Another beta?

2014-01-15 Thread Nick Burch
On Wed, 15 Jan 2014, Andreas Beeker wrote: I'll be busy with #56004 in the next few weeks and therefore won't touch many patches. So I currently would prefer to have a final soon. It might be best if you took a branch off of trunk, and worked on the WMF support on there. That way, we can all

Re: Another beta?

2014-01-15 Thread Nick Burch
On Tue, 14 Jan 2014, Dave Fisher wrote: I think you hang out on the Tika dev list. Do you know when the next major release of Tika is coming? When do we need to release to be included? I'm told was going to coming out in November or December, so who knows... Very soon though! Another beta

Another beta?

2014-01-14 Thread Nick Burch
Hi All It has been a while since our last beta, and the change list http://poi.apache.org/changes.html seems to show we've fixed rather a lot of bugs since 3.10 beta 2. However, we still have some community contributed patches that haven't been applied, and a few bugs that I've heard various

Re: svn commit: r1546385 - in /poi: tags/REL_3_9/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFSheet.java trunk/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java trunk/test-data/

2013-11-28 Thread Nick Burch
On Thu, 28 Nov 2013, cen...@apache.org wrote: Modified: poi/tags/REL_3_9/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFSheet.java poi/trunk/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSheet.java Normally nothing in the tags area should be changed - it should be a

Re: Is there any Constant for Date Type as CELL_TYPE_NUMERIC is for Numeric Type

2013-11-21 Thread Nick Burch
On Wed, 20 Nov 2013, Javed Akhtar wrote: Is there any Constant for Date Type as CELL_TYPE_NUMERIC is for Numeric Type. No, dates are just numbers with special formatting applied How to check the Date type Cell. See http://poi.apache.org/spreadsheet/quick-guide.html#CellContents for an

Re: Fwd: Build failed in Jenkins: POI #179

2013-11-19 Thread Nick Burch
On Tue, 19 Nov 2013, Dominik Stadler wrote: Jenkins build fails with the following since the changes for Bug 53475, the same fails locally for me as well, anything missing here? I've just done a clean and a build, all tests pass just fine for me on Linux. java.security.InvalidKeyException:

Re: Eval Fromulas in separate threads

2013-11-18 Thread Nick Burch
On Mon, 18 Nov 2013, Дмитрий Омелечко wrote: I have big, complex worksheet and time limit for calc output cells from this math model. Is it possible to run formula evaluation of the same worksheet in different threads? My hunch is no. In general, POI requires that one and only one thread

Re: Priority of PivotTables using external connections

2013-10-31 Thread Nick Burch
On Thu, 31 Oct 2013, Sofia Larsson wrote: We are currently developing support for creating pivot tables in POI and thought it would be great if this could be part of the framework in the future! Contributions are always welcome! There's some information on the POI site -

Re: Tests for dev-tools like BiffViewer et.al.

2013-10-25 Thread Nick Burch
On Sat, 26 Oct 2013, Dominik Stadler wrote: Failed: WORKBOOK_in_capitals.xls I'd expect to work, especially if HSSFWorkbook is happy Failed: NoGutsRecords.xls Might be expected to fail Failed: BOOK_in_capitals.xls I'd expect to work, especially if HSSFWorkbook is happy Failed:

Re: Tests for dev-tools like BiffViewer et.al.

2013-10-25 Thread Nick Burch
On Fri, 25 Oct 2013, Nirk Niggler wrote: I haven't dug deep into the code, but a cursory glance of the POIFS code reveals no effort to convert the names to uppercase. Nope, POIFS doesn't do any name conversion. Things like HSSFWorkbook do however Nick

Re: Intersection formula patch (issue 52111)

2013-10-07 Thread Nick Burch
On Mon, 7 Oct 2013, Matt Hillsdon wrote: I've added a patch that adds formula parsing support for the intersection operator on https://issues.apache.org/bugzilla/show_bug.cgi?id=52111 I just wanted to check whether I've got the process wrong as it didn't seem to show up on this list (perhaps

Re: [ANNOUNCE] Apache POI 3.10 Beta 2 released

2013-09-22 Thread Nick Burch
On Fri, 20 Sep 2013, Dominik Stadler wrote: what are the next steps on POI? Do we stabilize a bit more and release 3.10 before doing more risky stuff? Or do some more bugfixes before starting the 3.10 release process again? Given we've had 2 betas so far, it would probably confuse users if we

Re: Adding macros to .docx and removing macros from .docm

2013-09-17 Thread Nick Burch
On Mon, 16 Sep 2013, Rabea Gransberger wrote: Some time ago I needed code to add a macro from a docm file to a docx and remove it again after execution. At that time the code to do this was not present in POI and thus I wrote it. Are you interested in a contribution of code to do this? This

Re: help with publishing 3.10-beta2 to maven

2013-09-06 Thread Nick Burch
On Fri, 6 Sep 2013, Allison, Timothy B. wrote: Log-in on people.apache.org deploy Maven artifacts {code} cd build/dist ./mvn-deploy.sh {code} According to mvn-deploy.sh, I have to have a link to my private key and enter my passphrase in the clear in xml on the people.apache.org server. Is

Re: Apache POI Relative file hyperlink

2013-09-03 Thread Nick Burch
On Tue, 3 Sep 2013, ProgramadorJunior wrote: I'm trying to create an hyperlink to a file using APACHE POI XSSF and a relative path. When opening the .xlsx file created with *Microsft Excel* the relative path is modified and it is not well linked. Microsoft Excel adds some '../../' in front of

Re: POI tests failure

2013-08-25 Thread Nick Burch
On Sun, 25 Aug 2013, honyk wrote: While all changes are built correctly, when I run tests (on HEAD revision), I am getting many errors: How are you running the tests? ant test or something else (eg in eclipse?) 1. Some of them are caused by missing 'POI.testdata.path' property. How can I

Broken test on head

2013-08-23 Thread Nick Burch
Hi All Is anyone else seeing a broken test on head? [junit] Running org.apache.poi.hssf.eventusermodel.TestEventWorkbookBuilder [junit] Tests run: 4, Failures: 1, Errors: 0, Time elapsed: 0.033 sec Testcase: testFormulas took 0.022 sec FAILED expected:SUM([Sh3]!A1:A4) but

Re: svn commit: r1516313 - in /poi/trunk: src/java/org/apache/poi/hssf/model/InternalWorkbook.java src/testcases/org/apache/poi/hssf/usermodel/TestHSSFWorkbook.java test-data/spreadsheet/50298.xls

2013-08-21 Thread Nick Burch
On Wed, 21 Aug 2013, cen...@apache.org wrote: -import org.apache.poi.ddf.EscherBSERecord; -import org.apache.poi.ddf.EscherBoolProperty; -import org.apache.poi.ddf.EscherContainerRecord; ... -import org.apache.poi.hssf.record.BOFRecord; -import org.apache.poi.hssf.record.BackupRecord; -import

Re: writing XSSF broken in latest trunk

2013-08-20 Thread Nick Burch
On Tue, 20 Aug 2013, Dominik Stadler wrote: I have identified the commit below as being responsible, I have reverted it for now to ensure we do more investigation before putting that fix into place once again. Unfortunately no unit test captured this, only Excel reported the files as being

Re: writing XSSF broken in latest trunk

2013-08-20 Thread Nick Burch
On Tue, 20 Aug 2013, Dominik Stadler wrote: Unfortunately OpenOffice opens the file just fine... Pesky... Someone might be able to script something up using COM to launch Excel for a bunch of files, which might allow windows users to easily test, but I fear it'd be a lot more icky :/ Nick

Re: Apache POI and Maven modules (mavenization)?

2013-08-13 Thread Nick Burch
On Tue, 13 Aug 2013, cedric walter wrote: Any plan or roadmap to move away from the custom ANT build.xml in favor of Maven (mavenization)? Is it actually possible for maven to support all the targets in the POI build.xml file, without writing custom plugins / having to have Maven call ant to

Re: Is a Workbook still valid after writing out?

2013-08-05 Thread Nick Burch
On Mon, 5 Aug 2013, Dominik Stadler wrote: While browsing through some bug-reports I saw that some of them are caused by first writing out the Workbook (mostly XSSF) and then trying to continue to use it, this leads to XmlValueDisconnectedException and other exceptions as it seems some data

Re: svn commit: r1508691 - in /poi/trunk: src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSimpleShape.java src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFDrawing.java test-data/spreadsheet

2013-07-31 Thread Nick Burch
On Wed, 31 Jul 2013, talli...@apache.org wrote: Added: poi/trunk/test-data/spreadsheet/WithTextBox2.xlsx (with props) Modified: poi/trunk/src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSimpleShape.java poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFDrawing.java

RE: svn commit: r1508691 - in /poi/trunk: src/ooxml/java/org/apache/poi/xssf/usermodel/XSSFSimpleShape.java src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFDrawing.java test-data/spreadsheet

2013-07-31 Thread Nick Burch
On Wed, 31 Jul 2013, Allison, Timothy B. wrote: Sorry about that and for the ignorance exhibited by this: commit isn't working on status.xml (status -u shows the update; diff doesn't)... do I svn cp my updated copy to

Re: Build failed in Jenkins: POI #125

2013-07-30 Thread Nick Burch
On Tue, 30 Jul 2013, Dominik Stadler wrote: I would like to adjust the build-steps and Jenkins Job somewhat so that we read the unit test results and thus see what actually failed in cases like this one. According to

Re: Build failed in Jenkins: POI #125

2013-07-30 Thread Nick Burch
On Tue, 30 Jul 2013, Dominik Stadler wrote: Yes, I am on these lists now. Great! Yegor - can you please perform the ldap modify magic[1] for Dominik? Nick [1] http://wiki.apache.org/general/Jenkins?action=showredirect=Hudson#How_do_I_get_an_account

Re: svn commit: r1508180 - /poi/trunk/KEYS

2013-07-29 Thread Nick Burch
On Mon, 29 Jul 2013, talli...@apache.org wrote: Author: tallison Date: Mon Jul 29 18:58:26 2013 New Revision: 1508180 URL: http://svn.apache.org/r1508180 Log: added key to KEYS Quick reminder for everyone who might be helping with releases - you want to get your PGP key into the web of

RE: Next release?

2013-07-26 Thread Nick Burch
On Fri, 26 Jul 2013, Allison, Timothy B. wrote: I'd be willing to learn this process and give beta2 a shot probably in the middle of this coming week. Would that be soon enough? Any pointers/documentation on the steps required? There's quite a bit in the docs area of the site:

Re: MS OneNote

2013-07-26 Thread Nick Burch
On Fri, 26 Jul 2013, Mike Hugo wrote: I'm looking into basic support (text extraction) for MS OneNote. I found this bug https://issues.apache.org/bugzilla/show_bug.cgi?id=50750 that has some sample files attached. Does anyone have any pointers as to where I should get started? Use

Re: Next release?

2013-07-25 Thread Nick Burch
On Thu, 25 Jul 2013, vlad dev wrote: I would really appreciate if the patch for POI 55294 would be included in the next release. Can I do something more to make it happen? See my message yesterday for advice:

Re: Next release?

2013-07-24 Thread Nick Burch
On Mon, 22 Jul 2013, Darren Roberts wrote: Having only submitted one very minor patch (54969, but I'm working on a major enhancement to XSSFTextBox at the moment) my opinion probably doesn't count for much, but my vote would be to have a push to include as many of the outstanding patches in

RE: Next release?

2013-07-24 Thread Nick Burch
On Wed, 24 Jul 2013, Allison, Timothy B. wrote: My personal preference would be to wait for the POI 55292 patch to be applied (so that we can also fix Tika-1100). I'll have a chance to review it and its updates tomorrow (I hope), and if the community agrees with any mods I might have, I'll

Next release?

2013-07-22 Thread Nick Burch
Hi All It has been about 3 weeks now since the 3.10 beta 1 release. We've had a handful of bugs fixed then, but nothing major. Quite a few patches still outstanding in bugzilla though... What do we think about another release? 3.10 final? beta 2 to give time to apply a few more patches?

Re: Code authorship

2013-07-22 Thread Nick Burch
On Mon, 22 Jul 2013, Darren Roberts wrote: Just wondering what the form is when using code from elsewhere in the POI project when it comes to denoting authorship? We're trying to remove the @author tags, to follow the current ASF best practice. (There isn't just one person who owns the code,

Re: Exception opening XSSFWorkbook

2013-07-16 Thread Nick Burch
On Tue, 16 Jul 2013, scotterickson88 wrote: We recently migrated from java 1.6 classic to java 1.6 32 bit IBM iseries v5r4 to Power i v7r1 and when I try to open a workbook ( I can create one just fine ) It gives me an error. I traced it down to this: Thanks in advance, Caused by:

Re: [Vote] Tim Allison as new POI Committer + PMC member

2013-07-08 Thread Nick Burch
On Wed, 3 Jul 2013, Nick Burch wrote: Tim Allison talli...@mitre.org has been doing some great work recently[1] on submitting new patches around text extraction, and helping clarify + test existing bugs. Based on all that, I think he'd be a great addition to the POI committers list Voting

[Vote] Tim Allison as new POI Committer + PMC member

2013-07-03 Thread Nick Burch
Hi All Tim Allison talli...@mitre.org has been doing some great work recently[1] on submitting new patches around text extraction, and helping clarify + test existing bugs. Based on all that, I think he'd be a great addition to the POI committers list Please vote: +1 - Let's add Tim to the

Re: [Vote] Release POI 3.10 beta 1

2013-07-02 Thread Nick Burch
On Wed, 26 Jun 2013, Nick Burch wrote: A candidate for the POI 3.10 beta 1 release is available at: https://dist.apache.org/repos/dist/dev/poi The release candidate was build from the REL_3_10_BETA1 tag: https://svn.apache.org/repos/asf/poi/tags/REL_3_10_BETA1/ It includes all fixes

[ANNOUNCE] Apache POI 3.10 Beta 1 released

2013-07-02 Thread Nick Burch
The Apache POI team is pleased to announce the release of POI 3.10 Beta 1. Featured are numerous bug fixes, and some enhancements (especially in the number of Formula Functions supported). The Apache POI Project's mission is to create and maintain Java APIs for manipulating various file

Re: Validation tool for OOXML documents

2013-07-02 Thread Nick Burch
On Tue, 2 Jul 2013, honyk wrote: is there any tool similar to EpubCheck [1] for OOXML documents? There's a few. One is http://ooxmlvalidator.codeplex.com/, another option is to grab the OOXML SDK http://www.microsoft.com/en-us/download/details.aspx?id=5124 and use the one the one that

RE: [XSLF] Creating slide notes

2013-06-27 Thread Nick Burch
On Wed, 26 Jun 2013, honyk wrote: I'd like to help with implementing the functionality for adding slide notes to the presentation... please throw me a rope... thanks. First step is to work out what XML is needed, and where. Try to get the very minimal amount that'll work. What XML do you

RE: [XSLF] Creating slide notes

2013-06-27 Thread Nick Burch
On Thu, 27 Jun 2013, honyk wrote: Thanks for your effort. There is a model for slide notes available: http://poi.apache.org/apidocs/org/apache/poi/xslf/usermodel/XSLFNotes.html It'll almost certainly need some extending I can read slide notes from the existing presentation, so I know how

[Vote] Release POI 3.10 beta 1

2013-06-25 Thread Nick Burch
Hi All A candidate for the POI 3.10 beta 1 release is available at: https://dist.apache.org/repos/dist/dev/poi The release candidate was build from the REL_3_10_BETA1 tag: https://svn.apache.org/repos/asf/poi/tags/REL_3_10_BETA1/ It includes all fixes, features and changes committed in

Re: Any reason why junit is still at version 3.x

2013-06-23 Thread Nick Burch
On Mon, 24 Jun 2013, Dominik Stadler wrote: Is there any reason why POI is not using a newer JUnit version? I locally upgraded to 4.11 some time ago and was able to run all unit tests successfully, therefore I would like to apply the attached patch, please let me know if there is something

3.10 beta 1 deadline - Friday

2013-06-18 Thread Nick Burch
Hi All I'm planning to roll a release candidate for 3.10 beta 1 + start the release vote this Friday or Saturday, all being well Committers - please try to get your changes into svn by Friday lunchtime, if you'd like them to be in the beta! Otherwise they'll need to wait for beta 2 or final

Re: [VOTE] Cedric Walter as committer

2013-06-18 Thread Nick Burch
On Mon, 17 Jun 2013, Yegor Kozlov wrote: Cedric Walter cedric.wal...@gmail.com has submitted a bunch of outstanding patches in the area of formula support [1]. His contributions seem to be up to our standards, and I had no problems collaborating with him and reviewing his code. It'd be great

Anyone able to review/test some new excel functions?

2013-06-01 Thread Nick Burch
Hi All Over the last few weeks, Cedric Walter has been doing some great work submitting patches to implement excel functions we've been missing until now. Is there anyone here who knows about excel functions, who could cast an eye over them and test them? An independent review will speed up

Re: Contributing to XSLF Code

2013-05-17 Thread Nick Burch
On Fri, 17 May 2013, Eliot Kimber wrote: I am trying to use the XSLF code to implement manipulation and generation of PPTX presentations. I see that there are still some missing features and bugs. I am more than happy to contribute to the code to fill in some of the features I'm looking for.

Re: Basic Question Apache POI

2013-04-10 Thread Nick Burch
On Wed, 10 Apr 2013, vvasude2 wrote: I have a very basic question. For basic use questions, you should use the user list u...@poi.apache.org Nick - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional

Re: Question about items on buglist.

2013-03-08 Thread Nick Burch
On Fri, 8 Mar 2013, A Z wrote: I have been hoping for more support to be added for HWPFDocument. Has anyone noticed them, and is there likely to be any progress at all? We're all volunteers here. The best way to get a new feature into POI is to work on it yourself! If you need help with

Re: Is writing encrypted streams considered in-scope for POI?

2013-02-28 Thread Nick Burch
On Tue, 26 Feb 2013, Daniel Studer wrote: Just curious. I have implemented writing out an encrypted Excel document (RC4/Biff8-only) for work and plan to kick off the (time-consuming, PITA) process of getting approval to submit that to POI project proper. However I've read (from admittedly

Re: problem while striping password from xlsx large file

2013-02-25 Thread Nick Burch
On Fri, 22 Feb 2013, hdumbre wrote: I m using following code, POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(path)); EncryptionInfo info = new EncryptionInfo(fs); Decryptor d = Decryptor.getInstance(info); if (d.verifyPassword(password)) { XSSFWorkbook wb = new

Re: HSLF in 3.9 - table text change?

2013-02-05 Thread Nick Burch
On Tue, 5 Feb 2013, Yegor Kozlov wrote: https://issues.apache.org/bugzilla/show_bug.cgi?id=54111 can it be the cause ? It's not working with the latest build of POI from svn, so whatever it is remains :/ Nick - To

HSLF in 3.9 - table text change?

2013-02-04 Thread Nick Burch
Hi All Does anyone know of any changes in HSLF between 3.8 and 3.9 which might have changed how text in tables on slides behave? Only I've just upgraded Apache Tika to use 3.9, and a couple of unit tests have started failing, because a call to slide.getTextRuns() is no longer returning this

Re: Question: Why does POI not provide a Function for EDATE ?

2013-01-30 Thread Nick Burch
On 23/01/13 20:46, Detlef Brendle wrote: I started using POI 3.9 recently and was missing an implementation for the EDATE Excel Function (http://office.microsoft.com/en-us/excel-help/edate-function-HP010342465.aspx) I looked at it and implemented it by myself. Here is a groovy implementation

Re: POI Xls file parsing error

2013-01-30 Thread Nick Burch
On 22/01/13 16:05, willcas wrote: I have the exact same issue as trollchik, in http://permalink.gmane.org/gmane.comp.jakarta.poi.user/19545 has anyone ever reached a workaround? I receive an email with an xls attachment that I cant parse when it comes straight from the sender system. If I

Re: poi parsing huge xlsx file with event model.

2013-01-21 Thread Nick Burch
On Mon, 21 Jan 2013, shanth.mys...@gmail.com wrote: Is poi is read entire file into memory.How to read an excel(xlsx) file using event model without any memory issues. Did you try reading the website? eg http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api Nick

Re: src/documentation/content/xdocs/ in trunk?

2013-01-11 Thread Nick Burch
On Fri, 11 Jan 2013, Yegor Kozlov wrote: Deleteing them is the simplest solution. The other option is to keep the docs directory but point it to the new docs location via svn:externals. That makes sense to me, so I've gone ahead and changed it to that Nick

src/documentation/content/xdocs/ in trunk?

2013-01-10 Thread Nick Burch
Hi All Now that we've moved to svnpubsub for handling our website, with the website source and html stored in a different bit of svn, I was wondering if we should remove src/documentation/content/xdocs/ (+associated references) from trunk? As I understand it, those files are now no longer

Re: Fixing our website to still work in 2013

2012-12-17 Thread Nick Burch
On Mon, 17 Dec 2012, Yegor Kozlov wrote: I'm for svnpubsub, as it seems the shortest way. I guess we could move to that, and plan to do it in a way that we can use the cms later with minimal changes? As I understand, we will need to keep the generated html somewhere in svn and then ask

Fixing our website to still work in 2013

2012-12-16 Thread Nick Burch
Hi All For those who didn't see the emails from infra@, the current way we maintain our website (rsync of built files to people.a.o) will stop working on the 31st Dec, and we'll then no longer be able to update our site. (It'll still be there, just we won't be able to change it) I

Re: Paragraph.isInList() method in API but not in Jar of poi-3.8-beta5.jar

2012-12-06 Thread Nick Burch
On Thu, 6 Dec 2012, babwitu wrote: There is a method* Paragraph.isInList()* in POI API( http://poi.apache.org/apidocs/org/apache/poi/hwpf/usermodel/Paragraph.html http://poi.apache.org/apidocs/org/apache/poi/hwpf/usermodel/Paragraph.html ). But when I gone through the* poi-3.8-beta5.jar and

Re: [Bug 54043] getHtmlBody

2012-10-25 Thread Nick Burch
On Thu, 25 Oct 2012, Apache wrote: Could I have a example from a MSG file with the body in HTML or RTF? So I can use well the both methods getHtmlBody() and getRtfBody(). http://svn.apache.org/repos/asf/poi/trunk/test-data/hsmf/ has lots of sample files Nick

Re: [Bug 54043] getHtmlBody

2012-10-24 Thread Nick Burch
On Wed, 24 Oct 2012, Apache wrote: Please, in my opinion if and calling the JAVA POI method getHtmlBody to process and html format MSG and it is returning nothing I think it is a bug. Are you sure that your file has a real HTML body? Lots of Outlook files have an RTF body rather than a HTML

Re: [Bug 54043] getHtmlBody

2012-10-24 Thread Nick Burch
On Wed, 24 Oct 2012, Apache wrote: I see the properties of the MSG files and the Content-types are; -- Content-Type: application/ms-tnef; name=winmail.dat -- Content-Type: multipart/mixed; -- Content-Type: text/plain; charset=ISO-8859-1 It has a TNEF encoded RTF message body by the looks of

Re: getJavaDate(double date, java.util.TimeZone tz)

2012-08-13 Thread Nick Burch
On Mon, 13 Aug 2012, Max Birkoff wrote: I see in POI javadoc: http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DateUtil.html that this method: getJavaDate(double date, java.util.TimeZone tz) is implemented. However when I javap the jar: $ javap -classpath .

Re: getJavaDate(double date, java.util.TimeZone tz)

2012-08-13 Thread Nick Burch
On Mon, 13 Aug 2012, Max Birkoff wrote: I ran against: poi-bin-3.8-20120326.zip is there a newer version? JavaDocs are always build from svn, so try there / a nightly build There's likely to be a new version very soon, now that the hard work on HSSF drawings from GSOC has been merged in!

Re: OpenXML4JRuntimeException: Rule M2.4 exception : this error should NEVER happen

2012-07-27 Thread Nick Burch
On 25/07/12 15:03, Batchelor, James wrote: I received the following exception in a java program I am using to learn about the POI project: org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Rule M2.4 exception : this error should NEVER happen, if so please send a mail to the

Re: OpenXML4JRuntimeException: Rule M2.4 exception : this error should NEVER happen

2012-07-27 Thread Nick Burch
On Fri, 27 Jul 2012, Batchelor, James wrote: It is an existing file. I created a new xlsx file using Excel and populated cells A1 through D4 with A1,B1...etc. Then I was reading from a cell and writing to a cell. If you open the file in poi, and save it straight away without making any

RE: OpenXML4JRuntimeException: Rule M2.4 exception : this error should NEVER happen

2012-07-27 Thread Nick Burch
On Fri, 27 Jul 2012, Batchelor, James wrote: If I open the file in Excel prior to running and do a save-as, then run the program it still has an error. Could you please open a new bug in bugzilla for this, and attach the problem file there? Thanks Nick

Re: Sort the attachments files

2012-07-13 Thread Nick Burch
On 13/07/12 08:04, Apache wrote: I use the poi-scratchpad-3.8-beta5-20111217.jar to get the Attachments Files from a MSG file. That version is 6 months old, as a general hint you might want to upgrade to a newer version for bug fixes I have two questions, how process the plugin the

Re: Read .msg file inside other .msg file

2012-07-11 Thread Nick Burch
On 11/07/12 09:03, lucaro wrote: Is there any other way to write embedded message into the file? The problem looks to be that outlook is expecting more than just that bit of the file when the message goes to live on its own. You'll need to track down what those extra bits are, then manually

Re: Read .msg file inside other .msg file

2012-07-10 Thread Nick Burch
On 10/07/12 07:31, lucaro wrote: can anyone help me, How to read .msg file inside another .msg file. They're stored as a special kind of attachment First up, get the attachments http://poi.apache.org/apidocs/org/apache/poi/hsmf/MAPIMessage.html#getAttachmentFiles() Loop over the attachment

Re: Read .msg file inside other .msg file

2012-07-10 Thread Nick Burch
On Tue, 10 Jul 2012, lucaro wrote: Now, I am able to get Embeded msg But want to dump this in a new file I tried mapIMessage.write(outputstream); its giving me error: java.lang.UnsupportedOperationException: Writing isn't yet supported for HSMF, sorry Grab the POIFS directory from the

Re: Removing attachments from .MSG file

2012-07-06 Thread Nick Burch
On 06/07/12 12:22, nitinjaiin wrote: The rquirement is to remove the attachments from the .MSG file and save the .MSG file without the attachments. Is it possible using POI? If yes can you please share the code? What kind of attachments - other msg files, or anything else? (The outlook file

Re: Removing attachments from .MSG file

2012-07-06 Thread Nick Burch
On Fri, 6 Jul 2012, nitinjaiin wrote: The attachments could be .MSGs or any other file like .doc, .xls etc. I am unable to save the original .MSG file without the attachments. Multiple warnings can be included if it is not possible without the warnings. You'll want to do a filtered copy of

Re: Removing attachments from .MSG file

2012-07-06 Thread Nick Burch
On Fri, 6 Jul 2012, nitinjaiin wrote: I want to remove all the attachments in an email and save the email without the attachments, is it possible? Yes, but you'll have to write some code yourself. See my email for details of the building blocks you'll want to use Nick

Re: Removing attachments from .MSG file

2012-07-06 Thread Nick Burch
On Fri, 6 Jul 2012, nitinjaiin wrote: Can you also let me know if the same is also possible when the file format is .EML? What do you mean by an eml? I can think of several different formats that have all been known to use that file extension... Nick

Re: Removing attachments from .MSG file

2012-07-06 Thread Nick Burch
On Fri, 6 Jul 2012, nitinjaiin wrote: .EML mail message What kind? Lots of applications and file formats use .eml as their extension What application? What format? What mimetype? etc Nick - To unsubscribe, e-mail:

Does anyone use the PDF versions of the website pages?

2012-06-30 Thread Nick Burch
Hi All Currently, the POI website is build with Apache Forrest, which allows us to automatically generate PDF versions of all of our pages, alongside the HTML version. For example, as well as the HTML version of the component overview page: http://poi.apache.org/overview.html There's also

Re: [POI - XLSX] Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook

2012-05-29 Thread Nick Burch
On Tue, 29 May 2012, toplinuxer wrote: I think this problem is blocked when instantiate Class It should never take an hour to instantiate a class! I suggest you dig out some profiling and diagnostic tools, and try to work out what on earth your JVM is up to for that time Nick

Re: Upgrading to POI3.5 from 2.5 because what to read .xls and .xlsx using ss model but not working properly

2012-05-24 Thread Nick Burch
You appear to have just dumped a huge pile of code into an email, without any explanation, so as it stands you're unlikely to get a lot of help... As a general tip though, try with POI 3.8 Final rather than 3.5, as it has several years work of bug fixes Nick

<    1   2   3   4   5   6   7   >