You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2011/02/15 17:37:06 UTC
DO NOT REPLY [Bug 50787] New: XSSFColor.getRgbWithTint() returns
incorrect color for theme colors from 3-4 columns (brown and blue tints)
https://issues.apache.org/bugzilla/show_bug.cgi?id=50787
Summary: XSSFColor.getRgbWithTint() returns incorrect color for
theme colors from 3-4 columns (brown and blue tints)
Product: POI
Version: 3.7
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: dev@poi.apache.org
ReportedBy: andrei.astrouski@gmail.com
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
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 50787] XSSFColor.getRgbWithTint() returns
incorrect color for theme colors from 3-4 columns (brown and blue tints)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50787
--- Comment #3 from Nick Burch <ni...@alfresco.com> 2011-02-16 06:40:15 EST ---
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?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 50787] XSSFColor.getRgbWithTint() returns
incorrect color for theme colors from 3-4 columns (brown and blue tints)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50787
Nick Burch <ni...@alfresco.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Nick Burch <ni...@alfresco.com> 2011-02-15 11:53:05 EST ---
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?
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 50787] XSSFColor.getRgbWithTint() returns
incorrect color for theme colors from 3-4 columns (brown and blue tints)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50787
--- Comment #4 from andrei <an...@gmail.com> 2011-02-16 08:00:08 EST ---
Unfortunately I am not able yet to fix it
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 50787] XSSFColor.getRgbWithTint() returns
incorrect color for theme colors from 3-4 columns (brown and blue tints)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50787
--- Comment #8 from Nick Burch <ni...@alfresco.com> 2011-03-04 12:16:40 EST ---
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.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 50787] XSSFColor.getRgbWithTint() returns
incorrect color for theme colors from 3-4 columns (brown and blue tints)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50787
--- Comment #5 from Nick Burch <ni...@alfresco.com> 2011-02-18 10:50:57 EST ---
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.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 50787] XSSFColor.getRgbWithTint() returns
incorrect color for theme colors from 3-4 columns (brown and blue tints)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50787
--- Comment #7 from andrei <an...@gmail.com> 2011-02-22 13:01:42 EST ---
Created an attachment (id=26689)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26689)
Excel-POI theme colors converting
Please see attachment
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 50787] XSSFColor.getRgbWithTint() returns
incorrect color for theme colors from 3-4 columns (brown and blue tints)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50787
--- Comment #2 from andrei <an...@gmail.com> 2011-02-16 05:43:30 EST ---
Problem in applying tint to rgb. Algorithm you use applies tint to the brown
and blue colors incorrectly.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 50787] XSSFColor.getRgbWithTint() returns
incorrect color for theme colors from 3-4 columns (brown and blue tints)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50787
--- Comment #6 from Nick Burch <ni...@alfresco.com> 2011-02-18 10:54:10 EST ---
(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!)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 50787] XSSFColor.getRgbWithTint() returns incorrect color for
theme colors from 3-4 columns (brown and blue tints)
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50787
andrei <an...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|3.7 |3.8
Severity|normal |major
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org