|Summary:||unable to add background color to a cell|
|Component:||XSSF||Assignee:||POI Developers List <dev>|
problem what I faced
test case file
Afflicted fill entries from xl/styles.xml
less a patch and more of a hint where the problem starts
Description crazysuru 2013-01-04 16:18:59 UTC
Created attachment 29815 [details] problem what I faced
Comment 1 Dominik Stadler 2013-06-01 11:57:19 UTC
Can you provide a unit-test which shows the problem? It might be caused by processing before the few lines in the screenshot and thus might be hard to reproduce without this.
Comment 4 Eric Riese 2014-07-16 20:07:16 UTC
Created attachment 31823 [details] Afflicted fill entries from xl/styles.xml The first fill was preexisting in the file which was originally generated by Excel. The other two were created with POI. As per the Open XML SDK 2.0 Productivity Tool for Microsoft Office "The attribute 'rgb' has invalid value 'FF0000'. The actual length according to datatype 'hexBinary' is not equal to the specified length. The expected length is 4."
Comment 5 Nick Burch 2014-07-24 16:07:57 UTC
(In reply to Eric Riese from comment #4) > As per the Open XML SDK 2.0 Productivity Tool for Microsoft Office > "The attribute 'rgb' has invalid value 'FF0000'. The actual length according > to datatype 'hexBinary' is not equal to the specified length. The expected > length is 4." Some .xlsx colours require a 4 hex form (ARGB), others require a 3 hex form (RGB). At first glance, it would appear that the wrong kind is getting written Any chance someone could step into the colour and style code with a debugger, and see what is getting written where and why, to try to narrow down where the bug is coming in?