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 2009/08/17 06:30:02 UTC
DO NOT REPLY [Bug 47698] New: Incorrect cell colors.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47698
Summary: Incorrect cell colors.
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: nguyenhongthangnl@gmail.com
--- Comment #0 from Thang Nguyen <ng...@gmail.com> 2009-08-16 21:30:02 PDT ---
Created an attachment (id=24142)
this is the file to show affter using poi 3.5-dev write to new files.
Hi,
I want to ask you about the cell color on poi 3.5-dev, this is my function to
use for this solution.
public static void main(String[] args) throws Exception {
String file = "files\\Color\\color2.xls"; (file input)
String newFile = file + "_new.xls"; (file output)
HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(file));
//(create new style for new file)
HSSFCellStyle style = wb.createCellStyle();
wb.write(new FileOutputStream(newFile));
}
on input file I filled a cell with color RBG: (221, 217, 195) and I run main
method to create CellStyle but file output display yellow color ( 255,255,152)
not the same with input file. I don't know what's happen? Please help me.
Please see details attach files.
Thanks.
--
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 47698] Incorrect cell colors.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47698
--- Comment #1 from Khanh <kh...@jexpa.com> 2009-08-17 03:03:27 PDT ---
I am also facing this issue. The problem occurred if:
- The file create with Excel 2007
- Use custom color for some cells
- Save file as Excel 2003 workbook
- The colored cells are convert to Excel 2003 palette color(FINE)
Problem:
- Open the file by POI
- Create a cellstyle, does not map this new stye to any cell
- The colored cells are gone into weird color (OOPS!)
It bug critical for me, any idea are appreciated.
Thanks
--
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
Re: DO NOT REPLY [Bug 47698] New: Incorrect cell colors.
Posted by MSB <ma...@tiscali.co.uk>.
Is that all the code you are executing?
Yours
Mark B
Bugzilla from bugzilla@apache.org wrote:
>
> https://issues.apache.org/bugzilla/show_bug.cgi?id=47698
>
> Summary: Incorrect cell colors.
> Product: POI
> Version: 3.5-dev
> Platform: PC
> OS/Version: Windows XP
> Status: NEW
> Severity: normal
> Priority: P2
> Component: HSSF
> AssignedTo: dev@poi.apache.org
> ReportedBy: nguyenhongthangnl@gmail.com
>
>
> --- Comment #0 from Thang Nguyen <ng...@gmail.com> 2009-08-16
> 21:30:02 PDT ---
> Created an attachment (id=24142)
> this is the file to show affter using poi 3.5-dev write to new files.
>
> Hi,
>
> I want to ask you about the cell color on poi 3.5-dev, this is my function
> to
> use for this solution.
>
> public static void main(String[] args) throws Exception {
>
> String file = "files\\Color\\color2.xls"; (file input)
> String newFile = file + "_new.xls"; (file output)
>
> HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(file));
> //(create new style for new file)
> HSSFCellStyle style = wb.createCellStyle();
>
> wb.write(new FileOutputStream(newFile));
>
> }
>
> on input file I filled a cell with color RBG: (221, 217, 195) and I run
> main
> method to create CellStyle but file output display yellow color (
> 255,255,152)
> not the same with input file. I don't know what's happen? Please help me.
>
>
> Please see details attach files.
>
> Thanks.
>
> --
> 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
>
>
>
--
View this message in context: http://www.nabble.com/DO-NOT-REPLY--Bug-47698--New%3A-Incorrect-cell-colors.-tp25000867p25008692.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47698] Incorrect cell colors.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47698
--- Comment #2 from Khanh <kh...@jexpa.com> 2009-08-19 19:33:38 PDT ---
*** Bug 47697 has been marked as a duplicate of this bug. ***
--
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