Some questions:
1. HSSFFont: Are the font's IDs the same for every machine? If so, is it
just a matter of someone putting in all the fonts other than Arial as
constants in this class?
HSSFCellStyle: The javadoc gives a couple examples with colors;
cs.setFillBackgroundColor(HSSFCellStyle.RED);
cs.setFillForgroundColor(HSSFSeCellStyle.RED); // Typo!
But the colors aren't listed in the javadoc as they are for many other
settings like setFillPattern(). Fortunately they come up in VAJ using
auto-complete. My questions are:
2. Are the colors constant across all machine settings?
3. Are the colors listed the only choices?
4. There wouldn't happen to be a short-cut/macro to set all cells in a row
to a certain partial HSSFCellStyle? For example I want to alternate row
colors but have all with the same font and yet keep the columns' number
styles the same :) Hmm, yeah, I suppose that would lead to more confusion
than clarity having it possible to specify at more than the cell's level 8)
HSSFSheet.setColumnWidth(): I've tried using this a little, and I thought
the javadoc said that the width parameter was to represent 1/256th of a
character's width. It's not showing up in that manner (ie. 5*256 shows a
little more than 4 question mark characters) and I'm wondering if this is
due to 2 different factors:
5. That Excel shows some extra space on both sides of a given string inside
a cell
6. If the 1/256th is based on a font different from the default.
And if I didn't say it before: Thanks for this product!
-Chris
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
