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 2010/05/07 09:25:43 UTC
DO NOT REPLY [Bug 49262] New: HSSFPalette not contain exist cell
foregroundcolor
https://issues.apache.org/bugzilla/show_bug.cgi?id=49262
Summary: HSSFPalette not contain exist cell foregroundcolor
Product: POI
Version: 3.6
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: longxibo@sina.com
I use office2007 created a xls,in Cell X1,fill foregroundcolor is
RGB(79,129,189).
But when I use HSSFWorkbook open this xls and getCustomPalette,In return
HSSFPalette object can't found Color RGB(79,129,189).
java code as follows:
HSSFWorkbook wb;
FileInputStream finput=null;
File file;
file = new File("D:\\mysoft\\rpsp-sample\\testfile\\testcopycell.xls");
try {
finput = new FileInputStream(file);
wb = new HSSFWorkbook(finput);
HSSFPalette palette = wb.getCustomPalette();
System.out.print(palette);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
finput.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
--
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 49262] HSSFPalette not contain exist cell
foregroundcolor
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49262
--- Comment #3 from longxibo@sina.com 2010-06-07 22:12:34 EDT ---
(In reply to comment #2)
> Your file really doesn't seem to have a cell with that color.
> Opening open the file, I see the dark blue is 51,51,153 (X1) and the light blue
> is 153,229,229 (Y1). So, poi won't find the color you mentioned, because it
> isn't there...
You certitude open that xls with office2007? I upload the intercept picture
--
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 49262] HSSFPalette not contain exist cell
foregroundcolor
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49262
longxibo@sina.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|INVALID |
--
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 49262] HSSFPalette not contain exist cell
foregroundcolor
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49262
--- Comment #4 from longxibo@sina.com 2010-06-07 22:55:57 EDT ---
Created an attachment (id=25543)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=25543)
a xls cell foreground intercept picture
--
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 49262] HSSFPalette not contain exist cell
foregroundcolor
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49262
Nick Burch <ni...@alfresco.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |RESOLVED
Resolution| |INVALID
--- Comment #5 from Nick Burch <ni...@alfresco.com> 2010-06-10 07:35:43 EDT ---
In your screenshot, I can see your excel claiming the colour is 79/129/189.
Loading the screenshot into an image program I can confirm that the colour
shown really is 79/129/189
However, when I load the excel file up, the blue I see isn't the same blue that
was in your screenshot. I see a darker blue of 51,51,153. Looking in the excel
file at the palette records, the colour really is defined as 51,51,153. The
colour 79,129,189 isn't in the palette.
So, I think there must be something very odd going on with your copy of excel.
It is showing you one colour, but recording a quite different one. Not sure
what we can do to help here - if the colour doesn't get put in the file, we
can't read it back out again...
--
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 49262] HSSFPalette not contain exist cell
foregroundcolor
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49262
--- Comment #1 from longxibo@sina.com 2010-05-07 03:37:50 EDT ---
Created an attachment (id=25412)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=25412)
for fixbug
d
--
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 49262] HSSFPalette not contain exist cell
foregroundcolor
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49262
Nick Burch <ni...@alfresco.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
--- Comment #2 from Nick Burch <ni...@alfresco.com> 2010-05-28 11:27:48 EDT ---
Your file really doesn't seem to have a cell with that color.
Opening open the file, I see the dark blue is 51,51,153 (X1) and the light blue
is 153,229,229 (Y1). So, poi won't find the color you mentioned, because it
isn't there...
--
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