Undetected background-colour (support xslx created outside of fxl)

[zackteo]

fxl/test/zero_one/fxl/core_test.clj

Line 30 in a2f36e9

;; TODO: background-colour seems to be undetected!

Based on some tests, it seems that the colours in the test/resources/dummy-spreadsheet.xslx are incompatible with .getFillForegroundColor. Colours are however read correctly from files generated with fxl.

This might be a limitation of org.apache.poi.xssf.usermodel? Have to see how dummy-spreadsheet.xslx was created. Proprietary excel issues?

[zackteo]

"A deprecated indexing scheme for colours that is still required for some records, and for backwards compatibility with OLE2 formats."

https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/IndexedColors.html

[zackteo]

https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFColor.html#setIndexed-int-
Can probably use setRGB and getRGB in the long term

[zackteo]

(-> cell
    .getCellStyle
    .getFillForegroundXSSFColor
    .getARGBHex
    ;; .getFillForegroundColor
    ;; colours/colours-lookup
)

[zackteo]

https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/ExtendedColor.html#getARGBHex--
getARGBHex & setARGBHex