Color Problem

Ok, so I'm reading and writing excel files for work using a program I created to do my work for me and I'm having 1 formatting issue. I cant get java to produce the correct color based on the RGB values I got from an excel template we have at work.

I dont know the exact RGB value b/c I'm not at work, but I believe it was something around
R: 197, G: 217, B: 241

However this was just giving me white, while I needed a light blueish green color. If a tweaked the RGB a bit, it would either turn into medium blue or white (depending on which way I tweaked). I also tried some colors with RGB values I got from a color table I found online, but the colors didnt quite match up there either. If it was supposed to be a medium-dark color, it would appear darker than intended. If it was supposed to be a light-medium color, it would appear practically white or extremely light.

My boss said I can just find a different similar color, but its REALLY pissing me off. Is there something special I should know about Java's Color class? I never have been able to really get the colors right.


BTW, I use SmartXLS to read/write xls files, the API sucks but the email support and the power and ease of use of it is incredible.

The color you specified should be a light bluish color, it should not be white unless your monitor is completely uncalibrated or you are creating the Color incorrectly. How are you creating a new color based upon these values?
For what its worth, here is a small class that I wrote that has helped me to play around with colors while in my IDE: it allows you view the color based upon RGB values (click on the RGB tab - this does not take into account alpha values obviously):

Code java:

---

import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
 
public class ColorTest extends JFrame{
	public ColorTest(){
		super();
 
		JPanel main = new JPanel();
		 chooser = new JColorChooser();
		main.add(chooser);
		JButton button = new JButton("Print New Color");
		button.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				Color c = chooser.getColor();
				System.out.print("new Color(");
				System.out.print(c.getRed());
				System.out.print(", ");
				System.out.print(c.getGreen());
				System.out.print(", ");
				System.out.print(c.getBlue());
				System.out.println(");");
 
			}
		});
		main.add(button);
		getContentPane().add(main);
		pack();
		setVisible(true);
	}
	JColorChooser chooser;
	public static void main(String[] args){
		new ColorTest();
	}
}

---

Well I think the problem may be that for SmartXLS, I need to send Excel the color as a RGB int.

For instance, here is the line where I tell the Excel Cell to be set the color:

RangeStyle.setPatternFG(new Color(197,217,241).RGB());


Now, there is the possibility that I just messed it up entirely, but I got a different cell to turn near purple like I wanted. Here is the API code for this method:
API:

Quote:

---

setPatternFG

public void setPatternFG(int fg)

Sets the color used to display the pattern foreground.

Parameters:
fg - an integer describing the font color as a four-byte integer in the format 0x00RRGGBB.

---

Ok, so I used a method to get the color I needed.

Quote:

---

getPatternFG
public int getPatternFG()Returns the color used to display the pattern foreground.

Returns:
an integer representing the color. The color is returned as a four-byte integer in the format 0x00RRGGBB.

---

This returned 27.

So I tried setPatternFG(27) and got black...

Any thoughts from here?

Foreground would be the color of the letters. Black seems about right.

Thats what I thought a few weeks ago when I started this. For some reason, the API has Foreground set as the Background and I have no idea what background is. The text color is set by using the following method:

Quote:

---

setFontColor
public void setFontColor(int color)Sets the color used to display the font.

Parameters:
color - integer describing the font color as a four-byte integer in the format 0x00RRGGBB.

---