Created attachment 32982 [details] Generates an XSSF spreadsheet with various cell alignments This is a re-statement of bug number 56981 because 56981 is incomplete. This may actually be an OpenOffice/LibreOffice bug. Horizontal and Vertical cell alignment does not work correctly in XSSF spreadsheets. I am using POI 3.13 Beta1, and both the latest versions of OpenOffice and LibreOffice (as of 8/7/15). The cell alignments **do work correctly** with MS Excel, leading me to believe it may be an Open/LibreOffice bug. The attached code generates a spreadsheet with left/center/right and top/center/bottom horizontal and vertical alignment. (9 cells total). If you look at it with OpenOffice, it is obviously wrong. With MS Excel it is correct.
Can you try generating a file with that alignment in Excel? If so, then try loading it in AOO/LO and see how it looks? And load it in POI, read back the alignments, and see what POI sees?
(In reply to Nick Burch from comment #1) > Can you try generating a file with that alignment in Excel? If so, then try > loading it in AOO/LO and see how it looks? And load it in POI, read back the > alignments, and see what POI sees? If I read the file into Excel and then save it, it will then read correctly in Libreoffice. Also, if I just read the file back into POI, the cell alignments are correct.