Saturday, July 7, 2012

Formula Evaluation in Apache POI (or jxls)

Wasted an afternoon on this. If you create formulas in Apache POI or jxls, you need to force Excel to recalculate, otherwise you get the value from your template.  See link below !

Formula Evaluation: wb.setForceFormulaRecalculation(true);

Monday, March 19, 2012

Installing QJoyPad on Linux (Ubuntu, Mint)

After searching high and low, stumbled upon this post on how to install qjoypad, a useful application to turn a USB gamepad into a keyboard for playing games, or for using gamepads as control devices for sports refereeing applications.  The article is in French. Search qjoypad in the page (it is at the bottom).  I was not able to use apt-get to retrieve the package as stated, but adding the repository to synaptic, giving it the GPG authentication key, and using synaptic to retrieve the package all worked just fine.

Much easier than downloading half the universe to compile the thing.

Monday, February 20, 2012

Packaging third-party jars with project

A problem with Maven is when some jars are not publicly available, yet need to be published with the project -- otherwise the source won't compile or the program won't run. When doing it for yourself, you can always "mvn install" the jars so they are found in the local cache, or push them to a local repository. But this doesn't work when others need to checkout your source... And the winner is...

Leonid Dubinsky's Blog: Maven in-project repository