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/03/01 15:03:58 UTC

DO NOT REPLY [Bug 50846] New: XSSFCellStyle.get*BorderXSSFColor().getRgb() returns null for theme colors

https://issues.apache.org/bugzilla/show_bug.cgi?id=50846

           Summary: XSSFCellStyle.get*BorderXSSFColor().getRgb() returns
                    null for theme colors
           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 Excel doc.
2. Set border color with the theme palette.
3. Call from POI
cell.getCellStyle().getTopBorderXSSFColor().getRgb()

Actual result: null
Expected: rgb

-- 
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 50846] XSSFCellStyle.get*BorderXSSFColor().getRgb() returns null for theme colors

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50846

--- Comment #7 from andrei <an...@gmail.com> 2011-03-09 07:56:53 EST ---
StylesTable (including XSSFCellBorder) is initialized with null theme and only
after that setTheme(ThemesTable) is called. So XSSFCellBorder has null theme.

-- 
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 50846] XSSFCellStyle.get*BorderXSSFColor().getRgb() returns null for theme colors

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50846

--- Comment #4 from andrei <an...@gmail.com> 2011-03-09 07:46:56 EST ---
Created an attachment (id=26748)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=26748)
BorderColorTest.java

-- 
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 50846] XSSFCellStyle.get*BorderXSSFColor().getRgb() returns null for theme colors

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50846

--- Comment #3 from Nick Burch <ni...@alfresco.com> 2011-03-04 09:38:22 EST ---
I think I've solved this in r1077968.

However, I didn't have a suitable file to hand to write a unit test for this
with. Any chance you could upload a sample file with two styles, one which has
the border set with theme colours, and one with the border set with non-theme
(i.e. normal) colours? We can then use that for a unit test.

-- 
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 50846] XSSFCellStyle.get*BorderXSSFColor().getRgb() returns null for theme colors

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50846

Nick Burch <ni...@alfresco.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|                            |FIXED

--- Comment #8 from Nick Burch <ni...@alfresco.com> 2011-03-18 11:19:27 EDT ---
Thanks for the file and the unit test. I've switched XSSFCellBorder to behaving
more like XSSFFont in how it gets the theme table. That then allows your unit
test to pass fine. Fixed in r1082946.

-- 
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 50846] XSSFCellStyle.get*BorderXSSFColor().getRgb() returns null for theme colors

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50846

--- Comment #5 from andrei <an...@gmail.com> 2011-03-09 07:47:27 EST ---
Created an attachment (id=26749)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=26749)
BorderColorTest.xlsx

-- 
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 50846] XSSFCellStyle.get*BorderXSSFColor().getRgb() returns null for theme colors

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50846

--- Comment #2 from andrei <an...@gmail.com> 2011-03-02 10:03:34 EST ---
It's reproduced

-- 
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 50846] XSSFCellStyle.get*BorderXSSFColor().getRgb() returns null for theme colors

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50846

--- Comment #6 from andrei <an...@gmail.com> 2011-03-09 07:50:22 EST ---
Unfortunately the bug is still reproduced

-- 
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 50846] XSSFCellStyle.get*BorderXSSFColor().getRgb() returns null for theme colors

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50846

Nick Burch <ni...@alfresco.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #1 from Nick Burch <ni...@alfresco.com> 2011-03-01 11:03:22 EST ---
Does this apply to a recent nightly build / svn checkout?

(I think it probably does, but I wanted to double check given all the other
xssf colour changes and fixes recently)

-- 
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