|Summary:||XSSFColor.getRgbWithTint() returns incorrect color for theme colors from 3-4 columns (brown and blue tints)|
|Component:||XSSF||Assignee:||POI Developers List <dev>|
|Bug Depends on:|
|Attachments:||Excel-POI theme colors converting|
Description andrei 2011-02-15 11:37:04 UTC
Steps: 1. Create xlsx doc. 2. Set fill color for cell with theme colors from 3 or 4 columns (brown or blue tints). 3. Call cell.getFillForegroundXSSFColor().getRgbWithTint(). Actual: incorrect color (color is similar but not exactly the same) Expected: correct color
Comment 1 Nick Burch 2011-02-15 11:53:05 UTC
Is it a problem with what goes into the file, or with how we return it? Since a .xlsx file is a zip of xml files, any chance you could take a look inside and see what value actually got stored by excel? Are we returning that, or are we getting that wrong?
Comment 2 andrei 2011-02-16 05:43:30 UTC
Problem in applying tint to rgb. Algorithm you use applies tint to the brown and blue colors incorrectly.
Comment 3 Nick Burch 2011-02-16 06:40:15 UTC
The support for tint came from a user contributed patch from bug #48432 Are you able to identify the logic we should correct it to?
Comment 4 andrei 2011-02-16 08:00:08 UTC
Unfortunately I am not able yet to fix it
Comment 5 Nick Burch 2011-02-18 10:50:57 UTC
Are you able to figure out what the values should be easily? If so, could you pick say half a dozen colours, and then apply three different tint to each? From that, work out what the values should be, as compared to what they are, and we might have a good shot at spotting what's wrong with the current logic.
Comment 6 Nick Burch 2011-02-18 10:54:10 UTC
(There is some information from Microsoft on how to do the tinting and shading at http://social.msdn.microsoft.com/Forums/en/oxmlsdk/thread/f6d26f2c-114f-4a0d-8bca-a27442aec4d0 but we'll want a few sets of numbers for a unit test no matter what!)
Comment 7 andrei 2011-02-22 13:01:42 UTC
Created attachment 26689 [details] Excel-POI theme colors converting Please see attachment
Comment 8 Nick Burch 2011-03-04 12:16:40 UTC
Do you know what the text in the excel cells is supposed to be showing? When I use an image editor to check the colours in the png, then I find that the POI colours match the hex strings in them. However, the excel cell colours are not the same as the hex string. For example, D6 says 8A8149, but my image editor says that the colour is 948b54. Equally, K7 says E16207 but my image editor claims it's e46d0a FWIW, H7 reads 6A8832 but my image editor says it's 75923c. It's POI equivalent says 748C42, and my image editor says 748c42 so agrees again, so it's not just the "incorrect" ones where something odd is going on.