It has come to my attention that the Quick Guide for HSSF/XSSF is getting a bit out of date, particularly with respect to deprecations in the last several releases. Maybe someone should go through it thoroughly and update with current best practices/new Enums, etc.
I'll update the enums. Side note: If we ever want to prioritize it, we could generate our quick guide from compiled and tested example code. Tika does this. This would allow refactoring tools in IDE's to be able to keep the documentation up to date with the latest deprecations.
Other changes: short -> int
BorderStyle: r1818054
For Apache Tika, all the examples on the website are pulled in from java programs stored in the examples area, which area unit tested. It wouldn't be too much work to do something similar, but likely would need some custom Forest plugin. Otherwise, some bits of the howto are also available in the POI examples area, eg src/org/apache/poi/xssf/eventusermodel/examples/FromHowTo.java, maybe we could look to do that more?
*** Bug 62075 has been marked as a duplicate of this bug. ***
HorizontalAlignment and VerticalAlignment: r1823922
FillPattern: r1823924
short -> int: r1823925
republished site: r1823926. I don't see any other CellStyle constants that were replaced with enums. There are probably some newer POI and Java idioms (Java 8: try-with-resources) that could be updated.
(In reply to Javen O'Neal from comment #9) > I don't see any other CellStyle constants that were replaced with enums. ...in the latest Spreadsheet Quick Guide. So the Quick Guide is up-to-date with respect to enums.
I did some more changes, mostly simple try-with-resources. I don't think we should put everything under strict Java 8 usage as that would make the sample-code less easy to read, these are code-snippets anyway. I am closing this as fixed for now as the main purpose is done, we will adjust the guides some more as we go along anyway.
Latest changes are at r1828472