Folks,
I know understand the document format better (thanks to work on another
issue) and in styles.xml I can see:
<fills count="44">
<fill>
<patternFill patternType="none"/>
</fill>
<fill>
<patternFill patternType="gray125"/>
</fill>
<fill>
<patternFill patternType="solid">
<fgColor rgb="FFC6EFCE"/>
</patternFill>
</fill>...
Which must be the root of my inability to recognize a gray cell.
So XSSFCellStyle has a design problem in that it assuming either a fixed
set of fills or an incomplete
set of fills for the nice enumeration of fills.
Does anyone know how to fix this? No urgency on my part, my code works
well enough and I have
been able to work around the issues it generates.
Thanks, Brian
On Mon, Nov 16, 2015 at 7:07 PM, Brian Milnes <[email protected]>
wrote:
>
> I've got spreadsheet that has multiple gray cells which are blank
> and I'd like to leave blank, and multiple white cells which are blank and
> I would like to fill them.
>
> I want to recognize them and not fill them but I can't get the logic right
> or I have an issue with 3.13.
>
> They both can end up with a
> SOLID_FOREGROUND fill,
> getFillForegroundColor of 0
> and getFillFillForgroundColor of ARGB of -1 -1 -1 -1.
>
> What is the correct way to differentiate empty white versus gray cells?
>
> Thanks, Brian
>
>
>
>
>
--
Brian Milnes
CIO XBRL Cloud
206 406 7576
