Re: Help with desing of excel headers

Not seeing any attached image. I don't think you can do that on this list. Maybe just try to describe what you want? On Wed, Mar 11, 2020 at 3:32 PM AlexDio wrote: > Hello, I'm very new to the world of apache poi, I need to make an excel > with > headers that look like the image attached, how

Re: JDK 14 Early Access build 30 & JDK 15 Early Access build 4 are available.

Does anyone feel like these Java releases are coming way to fast to deal with? On Mon, Jan 6, 2020 at 5:27 AM Rory O'Donnell wrote: > Hi Dominik, > > Happy New Year ! > > *Per the JDK 14 schedule , we are now in Rampdown Phase One* > > *Please advise if you have found any issues while testing

Re: Next version 4.2?

This makes things a lot easier for folks using Maven for dependencies. What is the harm in letting things stay there until 5.0? On Mon, Dec 23, 2019 at 8:37 AM Mark Murphy wrote: > With Semantic versioning, you can't remove deprecates until a major > version change. > > On Sun,

Re: Next version 4.2?

With Semantic versioning, you can't remove deprecates until a major version change. On Sun, Dec 22, 2019 at 3:46 PM Andreas Beeker wrote: > Hi, > > I'd like to remove the deprecates for 4.2. > > What will be our next version? > > Andi > > >

Re: Concatenating, Indexing, and Copying a document to the end of another

In addition, if you were paid to develop the software, it likely belongs to the company that paid you, and you would need to get a signed release to open source it. The Apache foundation is particularly touchy about this. On Wed, Oct 23, 2019 at 5:30 AM pj.fanning wrote: > My personal opinion

Re: [VOTE] XMLBeans 3.2.0 release

According to the Semantic versioning folks, dropping support for a Java version is a breaking change requiring a major version update. On Tue, Sep 17, 2019, 2:40 PM Dominik Stadler wrote: > Hi PJ, > > I now thought a bit about 3.2 vs. 4.0 and came to the conclusion below, > this is naturally

Re: [VOTE] XMLBeans 3.2.0 release

Following semantic versioning, might that be considered a serious enough breaking change to warrant a 4.0.0? Given a version number MAJOR.MINOR.PATCH, increment the: 1. MAJOR version when you make incompatible API changes, 2. MINOR version when you add functionality in a backwards

Seems to be a lot of spam in Bugzilla recently

Is there any way to delete the spam comments in bugzilla, or to prevent them all together?

Git question for the gurus

I get SVN, it works like the other non-open source change management systems I have worked with in the past. I rarely end up confused by what I see happening. But I guess I just don't understand Git. I have a fork of POI on Git Hub JMarkMurphy/poi that I have been keeping synced with the main

Re: [VOTE] xmlbeans 3.0.2 release

Have we been getting any bug notifications for XMLBeans? Or have we ever notified the projects that have dependencies on XMLBeans that it is revived and taking bug reports again? On Sun, Sep 30, 2018 at 1:29 PM pj.fanning wrote: > I would like to complete an xmlbeans 3.0.2 release this week. >

Re: [VOTE] new POI logo

I'm not invested in any of these, but I like the older logo best V0 / C0 / POLL : 0 On Fri, Sep 7, 2018 at 5:18 PM Alain FAGOT BÉAREZ wrote: > V2 / C0 / POLL: 0 > > > > On 7 Sep 2018, at 21:57, Andreas Beeker wrote: > > > > Hi *, > > > > Daniel (humbedooh) created a new logo for us and I

Re: Apache Forrest 0.9 update

Looks good except the Powered by Apache logo is partially blocked by the search tab. On Thu, Jul 19, 2018 at 5:56 PM Andreas Beeker wrote: > Hi, > > I've fixed the rewrite rules and the build. > > AFAIK there's no jenkins job to generate the site - only the javadoc, > otherwise we would need to

Re: publishing poi xmlbeans jars

So where are we on this? On Wed, Mar 7, 2018 at 12:40 PM, Dave Fisher wrote: > Hi - > > Let’s get back on track. > > We want to release XMLBeans 2.7.0 with the org.apache.xmlbeans namespace > for the benefit of all of the users who are dependent on it. If POI does > not

Re: publishing poi xmlbeans jars

forget JiBX, it looks deader than XMLBeans On Thu, Mar 15, 2018 at 9:46 AM, Mark Murphy <jmarkmur...@gmail.com> wrote: > Anyone look at JiBX? it is released under the 3-clause BSD license. > http://jibx.sourceforge.net/jibx-license.html. It contains some code that > is uder

Re: publishing poi xmlbeans jars

Anyone look at JiBX? it is released under the 3-clause BSD license. http://jibx.sourceforge.net/jibx-license.html. It contains some code that is uder the Apache 1.1 license which should be ok, and some code under XPP3 which is not listed by Apache, but appears to be based on the BSD license.

Re: publishing poi xmlbeans jars

I have a question. If we bring it into POI as a sub-project, do we have to change its namespace? If it were added to Commons, would it have to change its namespace? Here is my rational for restoring XMLBeans to an active project or sub-project. XMLBeans is a stable project. It doesn't need much

Re: Single Java 9 module jar?

A poi-all jar may be the path of least resistance, but is it the best way? Under semver, a major version of >0 indicates a stable build, but only spreadsheet claims to be stable. Maybe it would be best to split things by document type and start everything but spreadsheet with a 0.4.0 version

Re: publishing poi xmlbeans jars

direct to POI. > > > > I think we (POI) need to take over the XMLBeans Product. > > > > Regards, > > Dave > > > >> On Mar 2, 2018, at 11:32 AM, Mark Murphy <jmarkmur...@gmail.com> wrote: > >> > >> So Oracle is removing JAXB from Java SE, Depricat

Re: publishing poi xmlbeans jars

So Oracle is removing JAXB from Java SE, Depricated in v9, to be removed in v11. I think we are stuck with XMLBeans for a while anyway. POI can sponsor XMLBeans which can then be put into incubation. At that point we can make updates. At some point XMLBeans emerges from incubation to be either a

Tests that create documents without closing them

Has anyone noticed that we have a lot of test cases that create documents without closing them when they are complete? Does this happen automatically somehow, and I just missed it, or are we using up a lot of memory by keeping documents open?

Maven Build Failure

What causes this in the Maven build? javax.imageio.IIOException: Can't create cache file! at org.apache.poi.hslf.usermodel.TestPicture.macImages(TestPicture.java:150) Caused by: java.nio.file.NoSuchFileException: target/tmp/imageio3327126342253604027.tmp at

Test document Tika-792

I am working on Bug 61787 where documents containing rsidDel=00 are not extracting the correct text. The issue is that rsidxxx attributes are just there to indicate which revision a particular change belongs to, but does not necessarily indicate that a particular revision actually occurred.

Charts

I think I have heard of a charting effort in progress for POI, I am hoping that is in a common module, at least for the XML formats so that we don't have to copy it to each of the document types. Can someone let me know how that is going? I have a patch for XWPF, and I want to make sure it doesn't

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

Re: [Bug 60887] Surface XSSF header/footer attributes

In writing unit tests for bug 60887, I have found an issue that I believe will be confusing to users. I put setters and getters in XSSFHeaderFooter for the global header/footer attributes. The reason I put it there is that these attributes are indeed global for the sheet, they are not specific to

Re: got docx?

Yes, there is no glossary support, and I don't think templates are supported very well either, if at all. I tried once to read a template and save it as a document to another file, and things didn't go well. I'm sure this just scratches the surface. Of course you are looking at things from an

Re: 2006 ML format?

Wow, this is nothing like what I thought it would be. I discovered that you can write a document in this format by selecting save as xml document. On Fri, Nov 18, 2016 at 7:03 AM, Allison, Timothy B. wrote: > Thank you, Javen. I worry that I'll be adding duct tape to

Re: Restarting styled numbered/lettered lists

> Jim Klo via poi.apache.org wrote: > Moving this discussion from user onto the dev list, as that seems a more appropriate place to discuss. > And please don’t take any of what I take below personally - it is offered

Re: [Bug 60329] New: Avoid NPE when styleid is null

Seems to me that style ID is not optional because it is used to refer to the style from elsewhere in the document, and the style ID must also be unique. However, if the style ID is missing from the document, one should be assigned in any manner we choose, and it won't be able to be referenced.

Re: Document validation hook in POIXMLDocument

IOExceptions on to the caller. On Sun, Oct 30, 2016 at 6:37 AM, Nick Burch <apa...@gagravarr.org> wrote: > On Sun, 30 Oct 2016, Mark Murphy wrote: > >> Is there a validation hook in POIXMLDocument that will allow a document to >> validate itself before it writes itse

Document validation hook in POIXMLDocument

Is there a validation hook in POIXMLDocument that will allow a document to validate itself before it writes itself to disk? Here is the use case. An XWPFDocument header or footer must contain at least an empty paragraph. If a header or footer is created without a paragraph, this hook would let me

XWPF automatically creates a blank paragraph in a new header / footer

XWPF automatically creates a blank paragraph in a new header or footer when no paragraphs are assigned during creation. This makes header/footer creation more complicated than it needs to be because it requires the user to either create an array of unbound paragraphs prior to the header / footer,

Re: Functionality injection technique for XWPF

ostic way. > > -Original Message- > From: Mark Murphy [mailto:jmarkmur...@gmail.com] > Sent: Saturday, October 22, 2016 6:37 PM > To: POI Developers List <dev@poi.apache.org> > Subject: Re: Functionality injection technique for XWPF > > I was looking at th

Re: Functionality injection technique for XWPF

I was looking at the WML schema, we could use the groups (EG_) to define interfaces. These are contained in other groups, and also in complex types (CT_). We could use that to build an inheritance structure of interfaces where an EG_ contains another EG_, and also an interface structure for the

Re: Functionality injection technique for XWPF

I found I should be able to do it using reflection to avoid long strings of instanceof conditions which is really the same as duplicating the code, but all inside one class. Any issue with using Reflection? On Sat, Oct 15, 2016 at 8:04 PM, Mark Murphy <jmarkmur...@gmail.com> wrote: > I

Functionality injection technique for XWPF

In working through the XWPF API I see a lot of notation concerning duplicated code. This is because there are a lot of places which need the same functionality, but they are not related in a way that can easily be sub-classed. For example a Document Body can contain Comments, Paragraphs and

Re: Build Fails on OOXML Test, just on my system though

tunately these slaves were rather > unstable in the past, maybe this has improved now. > > Dominik. > > > On Sat, Oct 15, 2016 at 6:29 AM, Mark Murphy <jmarkmur...@gmail.com> > wrote: > > > Windows 7 > > > > svn status contains forrest.properties an

Re: Build Fails on OOXML Test, just on my system though

x, or Mac? > > I know Windows keeps open file handles open, preventing the file from being > deleted or moved. > > Does it still break with "ant clean jenkins"? > > Is "svn status" blank just before running "ant clean jenkins"? > > On

Build Fails on OOXML Test, just on my system though

:ooxml:test org.apache.poi.xssf.streaming.TestSXSSFWorkbookWithCustomZipEntrySource > validateTempFilesAreEncrypted FAILED java.lang.AssertionError at TestSXSSFWorkbookWithCustomZipEntrySource.java:141 I think this is just me because I am using a clean download of the project, and jenkins

We aren't in the middle of a build are we?

I am getting ready to do a commit, and wanted to make sure the jenkins task would run to completion, and noticed it is trying to create 3.16-beta 1, is that just because it is the next release, or are we rolling 3.16 beta 1 already?

Re: 3.15 beta 3 soon?

So does this mean the trunk is locked for beta 3? I have a couple changes to add, but I will not do so if we are going to roll a new beta soon. On Fri, Jul 29, 2016 at 9:28 AM, David North wrote: > On 28/07/16 11:51, Nick Burch wrote: > > On Fri, 22 Jul 2016, Nick

Re: [Bug 59836] New: Replace primitives with enums

Maybe we should have a standard enum template that defines everything that belongs in the enum class. It would be easiest if enums could inherit from each other, or if they weren't final classes, but that doesn't work. I am thinking of some conversion from and to the simple type underlaying it,

Re: [Bug 56205] [PATCH] Upgrade OOXML schema to 3rd edition (transitional)

Just because this has come up, maybe it is coming close to time to make a major revision. The XML schemas are old, and we are coding to Java 1.6. A major version change would give us the ability to make some breaking changes such as replacing XMLBeans, shifting to Java 8 (or even 9), and shifting

Git

Trying to find documentation site on Git, but it does not appear to exist. Is this true?

XWPF Lead

I have been researching the WordprocessingML spec, mostly because I have a need to generate Word documents at work. I have noticed that there is a lot of low hanging fruit in that API, and thought I would offer to take lead in starting to get it into shape. It appears that much of the code is

Re: Strange behavior in XWPF

Where can I find that. I searched for the 58779 bug, but there is no test that references it. Sorry, not really fully up to speed on the entire project yet. On Thu, Jun 2, 2016 at 3:33 PM, Nick Burch wrote: > On Thu, 2 Jun 2016, Murphy, Mark wrote: > >> Read Only doesn't

Re: Strange behavior in XWPF

You can edit a read only file in Excel and Word, you just can't save it over the read only file, you have to do a Save As. I was trying to read a file, modify it, and then write it back out to a different file. Like using a Template. Using POI I was able to make changes to the in-memory

Re: Question about Java style

Just a switch with an enum, I will put it in. On Sat, Mar 12, 2016 at 2:08 PM, Nick Burch <apa...@gagravarr.org> wrote: > On Sat, 12 Mar 2016, Mark Murphy wrote: > >> My new class org.apache.poi.ss.util.CellBorders has some private methods >> that respond to a subset of

Question about Java style

My new class org.apache.poi.ss.util.CellBorders has some private methods that respond to a subset of enum values being passed in. If the methods were private, I would throw an exception if an invalid enum value was passed, but since the methods are private, is that necessary? Well, it isn't

SpreadsheetVersion

I am working through drawing borders in POI without creating needless CellStyles. Still having trouble with BORDER_NONE, I am thinking that I need to make the adjacent borders BORDER_NONE as well, and went looking for a method to retrieve the SpreadsheetVersion. Only found some code for a ternary