Steps: 1. Create Excel doc. 2. Set border color with the theme palette. 3. Call from POI cell.getCellStyle().getTopBorderXSSFColor().getRgb() Actual result: null Expected: rgb
Does this apply to a recent nightly build / svn checkout? (I think it probably does, but I wanted to double check given all the other xssf colour changes and fixes recently)
It's reproduced
I think I've solved this in r1077968. However, I didn't have a suitable file to hand to write a unit test for this with. Any chance you could upload a sample file with two styles, one which has the border set with theme colours, and one with the border set with non-theme (i.e. normal) colours? We can then use that for a unit test.
Created attachment 26748 [details] BorderColorTest.java
Created attachment 26749 [details] BorderColorTest.xlsx
Unfortunately the bug is still reproduced
StylesTable (including XSSFCellBorder) is initialized with null theme and only after that setTheme(ThemesTable) is called. So XSSFCellBorder has null theme.
Thanks for the file and the unit test. I've switched XSSFCellBorder to behaving more like XSSFFont in how it gets the theme table. That then allows your unit test to pass fine. Fixed in r1082946.