Re: Apache POI issue

Hi Wayne, This issue was forwarded to the POI developer list. The Apache Software Foundation is a large set of projects and you should contact the projects directly and not contact random addresses. Issues misdirect to random addresses are most likely to get lost. The POI contact points are describ

Re: Apache POI compatibility with Excel 2019 and Office 365

There is no effort made to validate that every file produced in every version of Excel can be parsed with Apache POI. POI is a volunteer project and no volunteer is interested in doing this work. Files produced with Apache POI should be readable in most recent versions of Excel. We work on issu

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 particul

Re: Apache POI Example page is broken

I tidied up some of the links on the web site. The new 5.0.0 work involves moving around a lot of packages to make code more Jigsaw friendly. On Thursday 30 July 2020, 13:14:38 GMT+2, Nick Burch wrote: On Wed, 29 Jul 2020, Ivan Mladenov wrote: > it seems like Apache POI Examples web

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 http://svn.apache

Re: Apache POI Build Pipeline

svnpubsub is used for publishing the files. See https://www.apache.org/dev/project-site.html So we can call "ant site" and copy/commit the contents of the subdir "build/site" to the designated svn location. Regarding the dependencies: the dependencies are fetched inside the ant build. The Gradle

Re: Apache POI Build Pipeline

svnpubsub is used for publishing the files. See https://www.apache.org/dev/project-site.html So we can call "ant site" and copy/commit the contents of the subdir "build/site" to the designated svn location. Regarding the dependencies: the dependencies are fetched inside the ant build. The Gradle

Re: APACHE POI 4.1.0 compilation on windows 10 with Openjdk10.0.1 version

Hi, please have a look at the FAQ entry "24. Can Apache POI be compiled/used with Java 9 or Java 10?", i.e. Java 10 is not officially anymore supported. Can you upgrade to OpenJdk 12 or higher? If yes, is it working for you? Andi -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f

Re: Apache POI

Dejan, Thank you for letting us know about this problem. I was able to reproduce it, and I've opened a ticket: https://bz.apache.org/bugzilla/show_bug.cgi?id=62815 On Wed, Sep 12, 2018 at 5:58 AM dejan ikodinovic wrote: > > Hi guys, > > I m working on parsing Excel xlsb files using Apache POI 3

Re: Apache POI

Can you open an issue on out bugzilla and post a test file w a unit test? Thank you for sharing this w us! On Wed, Sep 12, 2018 at 5:58 AM dejan ikodinovic wrote: > Hi guys, > > I m working on parsing Excel xlsb files using Apache POI 3.17 version and > have problem for some numbers. > The probl

Re: Apache POI

Could you raise a bugzilla issue and attach an xlsb file? https://bz.apache.org/bugzilla/ xlsb is not an active area of development, I'm afraid. -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html - To

Re: Apache poi-4.0.0 snapshot/beta version

Hi Sonee, thank you for pointing this out - I've fixed the links. The nightly can be found here: https://builds.apache.org/view/P/view/POI/job/POI-DSL-1.8/lastSuccessfulBuild/artifact/build/dist/ Please have a look at #62355 [1] - currently it's quite likely that it will be applied with 4.0.0.

Re: Apache POI 4.0/Java 8

I think that a transition to 4.0.0 would indicate that things are different. So maybe a repackaging is in order. Semver states that anything with a 0.x.x version can contain breaking changes at any time. It is a pre-release kind of thing. Our documentation states that only the Excel package is sta

Re: Apache POI 4.0/Java 8

Are we following the guidelines of http://semver.org? If so, should we declare that (possibly in the 4.0.0 release notes)? Semver.org specifies that adding any deprecation warning would need to be done in a minor release and any removal of a deprecated feature be done in a major release. This is

Re: Apache POI 4.0/Java 8

I agree with Andi about using 4.0.0-SNAPSHOT as the release number. I'd like to make regular 4.0.x releases and to have 4.y release on a similar cadence to the existing 3.z releases (2 or so a year). -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html ---

Re: Apache POI 4.0/Java 8

Please use 4.0.0-SNAPSHOT ... I wouldn't use the term beta anymore, so betas become patch versions 4.0.x Andi On 9/16/17 5:40 PM, Dominik Stadler wrote: > Hi, > > I did most of my changes to switch to Java 8 and adjusted the Jenkins jobs > accordingly. Version is currently at 4.0-beta1, I'll cha

Re: Apache POI 4.0/Java 8

Hi, I did most of my changes to switch to Java 8 and adjusted the Jenkins jobs accordingly. Version is currently at 4.0-beta1, I'll change this to 4.0.0-beta1 soon if nobody beats me to it. I also pushed a number of automatic code-fixes suggested by IntelliJ which should make the code-base a bit

RE: Apache POI 4.0/Java 8

Yes, and our @deprecated messages should be using the new semantic versioning 4.0.0. On Sep 15, 2017 4:06 AM, "Allison, Timothy B." wrote: Thank you, Dominik!!! So, speaking of 4.0...should we move to semantic versioning: 4.0.0? -Original Message- From: Dominik Stadler [mailto:dominik.

RE: Apache POI 4.0/Java 8 - new packages?

, September 15, 2017 9:04 AM To: POI Developers List Subject: RE: Apache POI 4.0/Java 8 - new packages? Speaking of new packages... It looks like there's some interest in moving Tika's mostly bean free/pure-SAX extractors for pptx/docx to POI. What would people think of having an entirely

RE: Apache POI 4.0/Java 8 - new packages?

2017 8:12 AM To: 'POI Developers List' Subject: RE: Apache POI 4.0/Java 8 Here is a somewhat radical idea, and maybe too hard to implement, but maybe we should package this a bit differently like poi-core, poi-ss, poi-wp, poi-misc. And then apply semantic versioning to each package se

RE: Apache POI 4.0/Java 8

FYI - a while back we had already a discussion about format specific packaging: http://apache-poi.1045710.n5.nabble.com/Switch-to-maven-td5722213.html Andi -- Sent from: http://apache-poi.1045710.n5.nabble.com/POI-Dev-f2312866.html --

RE: Apache POI 4.0/Java 8

Sent: Friday, September 15, 2017 7:07 AM To: POI Developers List Subject: RE: Apache POI 4.0/Java 8 Thank you, Dominik!!! So, speaking of 4.0...should we move to semantic versioning: 4.0.0? -Original Message- From: Dominik Stadler [mailto:dominik.stad...@gmx.at] Sent: Thursday, Septemb

RE: Apache POI 4.0/Java 8

I think that would be a good idea. -Original Message- From: Allison, Timothy B. [mailto:talli...@mitre.org] Sent: Friday, September 15, 2017 7:07 AM To: POI Developers List Subject: RE: Apache POI 4.0/Java 8 Thank you, Dominik!!! So, speaking of 4.0...should we move to semantic

RE: Apache POI 4.0/Java 8

Thank you, Dominik!!! So, speaking of 4.0...should we move to semantic versioning: 4.0.0? -Original Message- From: Dominik Stadler [mailto:dominik.stad...@gmx.at] Sent: Thursday, September 14, 2017 1:39 PM To: POI Developers List Subject: Apache POI 4.0/Java 8 Hi, FYI, as 3.17 is out

Fwd: Re: [apache/poi] Trailing commas custom formats (#56)

Luca has a question about PR #56 on GitHub. Seems relevant to some of the recent internationalization work. Anyone more familiar with the subject care to chime in on the GitHub PR? -- Forwarded message -- From: "Luca Martini" Date: Jul 3, 2017 03:52 Subject: Re: [

Re: [apache/poi] make line breaks consistent - always use line feeds (LF) (#20)

Anyone object to a massive EOL conversion? Should we put this off to POI 4.0? doc2unix `find -name "*.java"`; svn propset svn:eol-style `find -name "*.java"`? Do we want to do an indentation whitespace conversion while we're touching all the files and potentially breaking patch files and forks?

Re: Apache POI 3.15 released

Hi, thanks for this work, I think having the notable-change-items also in the status.xml is a good thing because it is easier to remember what changes did happen at the time the changelog is updated compared to when the release is prepared later by one dev who might not be aware that somebody else

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: Apache POI 3.15 released

I added the major changes from the 3.15 release notes [1] to the detailed changelog [2] in r1765977 [3]. [1] https://www.apache.org/dyn/closer.lua/poi/release/RELEASE-NOTES.txt [2] https://poi.apache.org/changes.html [3] https://svn.apache.org/viewvc?view=revision&revision=1765977 We could choose

Re: Apache POI 3.15 released

Sorry, I was aware of that - fixing it fell off my radar. Apologies. On 29/09/16 15:19, Javen O'Neal wrote: > Nevermind. Just need to update the POI homepage to link to release > instead of dev. > > On Thu, Sep 29, 2016 at 4:13 PM, Javen O'Neal wrote: >> The release notes have not made it to the

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 i

Re: Apache POI 3.15 released

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 in the past seem suboptimal. There is no r

Re: Apache POI 3.15 released

Nevermind. Just need to update the POI homepage to link to release instead of dev. On Thu, Sep 29, 2016 at 4:13 PM, Javen O'Neal wrote: > The release notes have not made it to the apache and non-apache > mirrors. The release notes reference "3.15-beta 2" for me. Did the > 3.15 final release notes

Re: Apache POI 3.15 released

The release notes have not made it to the apache and non-apache mirrors. The release notes reference "3.15-beta 2" for me. Did the 3.15 final release notes get published correctly? https://www.apache.org/dyn/closer.lua/poi/dev/RELEASE-NOTES.txt On Thu, Sep 22, 2016 at 7:34 PM, Javen O'Neal wrote

Re: Apache POI 3.15 released

Good point! A one sentence "Apache POI is a Java library for reading and writing Microsoft Office files" should do. We'll add this to our announce template for future releases. On Sep 22, 2016 9:28 AM, "sebb" wrote: > What is the project about? Why should I be interested in it? > [rhetorical qu

Re: Apache POI 3.15 released

What is the project about? Why should I be interested in it? [rhetorical questions] The Announce emails are sent to people not on the developer or user lists. Most will have no idea what the project is about. So the e-mails should contain at least brief details of what the product does, and some

Re: Apache POI 3.14 issue with tables in PPTX files

Hi, rendering tables in XSLF is not yet supported (see [1]) ... that's one of the issues I'm still carrying around with me As you've already mentioned, tables in HSLF are actual just a group of boxes and lines, therefore the groupshape rendering takes place there ... Andi [1] https://bz.a

Re: apache poi 3.12 responding with "Error: Could not find or load main class "

On Sun, Jun 21, 2015 at 8:15 PM, Andreas Beeker wrote: ... > >> fast reply is appreciated... > > I've received your mail just now - so it was sleeping in some outbox for the > last 1,5 days ... And you are asking a bunch of volunteers here where nobody is actually paid for work on POI, so immedi

Re: apache poi 3.12 responding with "Error: Could not find or load main class "

Hmmm ... "... newsheet.class ..." vs. " ... netsheet ... " I'll buy a "t" instead of a "w" > fast reply is appreciated... I've received your mail just now - so it was sleeping in some outbox for the last 1,5 days ... Andi. On 20.06.2015 16:22, rkishore.qa wrote: > Hi experts, > > >

Re: Apache POI excel sheet formula reference to another sheet.

On Mon, 10 Nov 2014, Vinay S V wrote: I have an excel sheet which has a formula reference to another sheet of the same workbook. Currently, I'm on Sheet 1 and trying to set a formula for a cell using *cell.setFormula(Sheet2[#All]).* However, in the workbook, I have created the necessary sh

Re: Apache POI XWPFDocument to Pdf format

On Mon, 9 Jun 2014, Peter Margetiak wrote: // 1) Load DOCX into XWPFDocument InputStreamin=newFileInputStream(newFile("HelloWord.docx")); XWPFDocumentdocument =newXWPFDocument(in); You're better off loading from the File directly, it's lower memory than going via an input stream // 2) Prepa

Re: Apache POI Relative file hyperlink

I found another XML that I think is the one you wanted to look at. Inside the .xlsx in xl/worksheets/_rels there's the file *sheet1.xml.rels* and one of its relationships is /http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink"; TargetMode="External" Target="Encuesta%20de

Re: Apache POI Relative file hyperlink

When I consult the link with Microsoft Excel the path is '../../../../../Encuesta%20de%20bienvenida/E18'. It has added all the dots before the path I wrote in the code. If I open the file with OpenOffice the path appears just as I wrote it, without the dots. Sorry this is my first time working with

Re: Apache POI Relative file hyperlink

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 the

Re: Apache POI and Maven modules (mavenization)?

poi-main and poi-scratchpad fit in Maven more or less OK. My concern is poi-ooxml. This module has lots of unusual stuff, in particular, downloading and building ooxml schemas. Personally, I'm more against Maven than for it. Maven is nice when your project fits in it or you are starting a new on

Re: Apache POI and Maven modules (mavenization)?

Hi, Obviously I am not an Maven expert, but one or two years ago I would have opted to keep away from Maven right away because nearly every Maven-based project I came across failed to build because of broken dependencies. Nowadays this has changed a lot, although there are still cases where depend

Re: Apache POI and Maven modules (mavenization)?

I am pretty convinced that it would even run a lot faster. I have work in some huge projects using maven (50 or more modules).. After looking at all the target in the build.xml, i see that lot are duplicated and just try to create a kind of lifecycle: compile - test - javadoc and so on... Maven wi

Re: Apache POI and Maven modules (mavenization)?

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: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

Fixed in r1154323, junit added. Yegor On Thu, Aug 4, 2011 at 4:54 PM, Yegor Kozlov wrote: > I'm going to fix the   issue by writing   instead. Unicode > chars beyond D7FF are not relevant to this bug and unlikely to cause > problems. > > Yegor > > On Thu, Aug 4, 2011 at 3:41 PM, jguilhermemv wr

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

I'm going to fix the   issue by writing   instead. Unicode chars beyond D7FF are not relevant to this bug and unlikely to cause problems. Yegor On Thu, Aug 4, 2011 at 3:41 PM, jguilhermemv wrote: > Yegor, > > Could you tell us which approach are you going to use to fix this? > > > 2011/8/4 Yegor

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

Yegor, Could you tell us which approach are you going to use to fix this? 2011/8/4 Yegor Kozlov-4 [via Apache POI] < ml-node+4665842-1534849639-237...@n5.nabble.com> > On Wed, Aug 3, 2011 at 8:27 PM, Alex Geller <[hidden > email]> > wrote:

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

On Wed, Aug 3, 2011 at 8:27 PM, Alex Geller wrote: > The bug is in line 1505 of > src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java where the non > breaking space in quoted in HTML manner (" ") instead of using a > unicode escape (" "). >  @Yegor: will you take care of it? Sure, I will

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

On more thought on this. In XML only the following unicode characters are allowed (see http://www.w3.org/TR/xml/#NT-Char): Char ::= #x9 | #xA | #xD | [#x20-#xD7FF] | [#xE000-#xFFFD] | [#x1-#x10] Java strings apparently can contain any character but the 64 reserved "non charac

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

Alex, Thank you for taking part of this discussion. Sure that it will help a lot. Best regards. Jose Guilherme 2011/8/3 Alex Geller [via Apache POI] < ml-node+4662850-998737665-237...@n5.nabble.com> > The bug is in line 1505 of > src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java whe

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

Oops, apparently the text needs to be quoted on this forum. The unicode escape should be " " instead of " ". Regards, Alex -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4662866.html Sent from the POI -

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

The bug is in line 1505 of src/ooxml/java/org/apache/poi/xssf/streaming/SXSSFSheet.java where the non breaking space in quoted in HTML manner (" ") instead of using a unicode escape (" "). @Yegor: will you take care of it? Sorry for the trouble. Regards, Alex -- View this message in context: htt

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

Yegor, Where can I find information about zipping and unzipping these files? Best regards, José Guilherme Macedo Vieira 2011/8/3 Yegor Kozlov > It would be a valuable contribution if you generate two worksheets > containing strings with \u00a0. One with SXSSF and the other with > XSSF. You ca

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

It would be a valuable contribution if you generate two worksheets containing strings with \u00a0. One with SXSSF and the other with XSSF. You can use my code snippet. Then unzip the files, compare and figure out what's wrong with handling \u00a0 in SXSSF. You want to look at sharedStrings.xml an

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

I can help you if you can. We can work together to fix the issues and develop new features. Cheers. José Guilherme Macedo Vieira 2011/8/3 Yegor Kozlov > So far the plan is to release it in late August. > > Yegor > > On Wed, Aug 3, 2011 at 3:01 PM, Guilherme Vieira > wrote: > > Yegor, > > > >

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

So far the plan is to release it in late August. Yegor On Wed, Aug 3, 2011 at 3:01 PM, Guilherme Vieira wrote: > Yegor, > > I'm glad to help you to find this issue. This is exactly the problem. By now > I'm trying to fix it in my own code by replacing these characters. Though > the beta4 is not

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

Yegor, I'm glad to help you to find this issue. This is exactly the problem. By now I'm trying to fix it in my own code by replacing these characters. Though the beta4 is not out yet I'm still using it in my project because I need to write an excel with >100.000 lines. Do you know when the beta4 i

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

The culprit is the non-break space (charcode=\u00a0). I was able to reproduce the trouble with the following code: Workbook wb = new SXSSFWorkbook(); Sheet sh = wb.createSheet(); Row row = sh.createRow(0); row.createCell(0).setCellValue("ALEXANDRE\u00a0MARINHO DE SO

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

Dear Yegor, Your tip didn't work. So I guessed that there was a non-printable character instead of white spaces. That said I tried to encode it with URLEncoder.encode("the name goes here","ASCII"); and guess what? The encoded name is as below: ALEXANDRE%3BF+MARINHO+DE+SOUZA It interesting becaus

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

Tweak your report generator and try the following tricks before passing strings to SXSSFCell: (a) string.replaceAll("\\s+", ""); // replace multiple white spaces with a single space (b) string.replace(' ', '_'); // replace white spaces with underscore Does any of (a) and (b) help? My hunch is

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

So, I've searched column by column in the problematic line in order to identify the problem. The problem is quite weird. It's a string column in the database. This column stores people names. In my problem the name is: ALEXANDRE__MARINHO DE SOUZA Of course, without the underline character. Instea

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

I tried without merged region and it didn't work. So, I noticed that there is a line in the file which present the error. It's the line (2451) and until the line 2450 everything works great. But for some reason when it reach the line 2450 it just doesn't work. I checked if the was any null values,

Re: Apache POI 3.8 (SXSSFWorkbook) - Unreadable Content

On Tue, 2 Aug 2011, jguilhermemv wrote: Regarding the file, it makes use of some CellStyles and Merged Regions. Try without them, and see if that fixes it. You need to narrow your problem down before you can figure out what to correct. Try to identify the simplest file that fails, and the mos

Re: Apache POI HSLF support to embed SWF files in PPT.

Thanks alot for your help. I have been trying to reverse engineer the ppt files with embedded SWF, and it looks like HSLF load the SWF File data in OLEShape, in the _records property of HSLFSlideShow, it uses getExEmbed() method of OLEShape class to retrieve these Objects, and it stores OLEObjAtom

Re: Apache POI HSLF support to embed SWF files in PPT.

The PPT binary format only supports .mpg and .avi movies. Here is a test case that adds a .mpg movie: http://svn.apache.org/repos/asf/poi/trunk/src/scratchpad/testcases/org/apache/poi/hslf/model/TestMovieShape.java SWF is inserted as a ActiveX object. HSLF can read ActiveX shapes (see ActiveXSha