Category Archives: howto

Removing Excel rows with POI

When generating Excel Sheets it is sometimes necessary to remove rows which match a given criteria afterwards. The first idea for this would be to use removeRow(Row row) but this has the problem that it deletes all the row contents and leaves the empty row in your sheet which is probably not what you want. […]
Also posted in coding, english, Java | Tagged , , , , | Leave a comment

Solution for the IntelliJ issue on macOS Sierra

Jetbrains has come up with a solution for the scrolling problem with IntelliJ IDEA based IDEs under macOS Sierra. They released a modified JDK8 which hast to be set as boot JDK for IntelliJ. You can download the JDK here. For setting it as the boot JDK you need to got to action menu. This […]
Also posted in Apple, english, Java, macOS, Tools | Tagged , , , , , , , | Leave a comment

eclipse workspace in use

As I’m a huge fan of IntelliJ IDEA I don’t use eclipse very often during the last years but I have a dedicated project where I need to regularly use for creating deployments and connect with some remote test servers. So I have to deal with eclipse and its problems, too. A recurring problem for […]
Also posted in coding, english, Java, Tools | Tagged , , , , | Leave a comment

Using CellUtil with POI to avoid too many cell styles in Excel

When you create Excel documents with the popular Apache POI library it is possible that you encounter a problem where Excel tells you there are “Too many different cell formats”. A possible source for this is that you probably have a loop structure in which you define a new cell style for every cell you […]
Also posted in Allgemein, coding, english, Java | Tagged , , , , , , | Leave a comment

My git svn workflow

Using a remote subversion repository with git locally requires some adoptions to the local git usage compared to working in a pure git environment. The reason for this is that the remote subversion don’t know about many of the concepts the local git supports (local branches or multiple local commits before checkin for example). Because […]
Also posted in coding, english, git, Tools | Tagged , , , , , , , | Leave a comment