Try using fillForegoundColor instead of fillBackgroundColor. Something like:
header = {
font = headerFont;
fillForegroundColor = 22;
fillPattern = "SOLID_FOREGROUND";
wrapText = true;
alignment = "ALIGN_CENTER";
verticalAlignment = "VERTICAL_CENTER";
};
Amiel
On Sat, Apr 16, 2011 at 1:58 AM, Theodore Petrosky <[email protected]>wrote:
>
>
> >
> > Message: 7
> > Date: Fri, 15 Apr 2011 16:06:11 +0200
> > From: Anjo Krank <[email protected]>
> > Subject: Re: exporting to excel and styles
> > To: "[email protected]
> > Dev Apple"
> > <[email protected]>
> > Message-ID: <[email protected]>
> > Content-Type: text/plain; charset=us-ascii
> >
> > IIRC, a color number. One to 16 (64?)? Check the docs for
> > POI.
>
>
> That's what I thought so I tried all the numbers from 1 to 16 and nada. I
> stuck an NSLog in to see if my addition was happening and I see it is.
>
> Styles = {default = {alignment = "ALIGN_RIGHT"; font = "default"; }; header
> = {fillBackgroundColor = "5"; alignment = "ALIGN_CENTER"; font = "bold"; };
> bold = {alignment = "ALIGN_LEFT"; font = "bold"; }; normal = {alignment =
> "ALIGN_LEFT"; width = "250"; font = "default"; }; }; Fonts = {default =
> {name = "Arial"; fontHeightInPoints = "10"; }; bold = {name = "Arial Black";
> }; };
>
> I have a style header that aligns center and bolds the face. these
> attributes show just fine. the background fill doesn't.
>
> I will keep hacking. I wish I saw a columnWidth setting!!!
>
> Ted
>
>
>
> >
> > Cheers, Anjo
> >
> > Am 15.04.2011 um 15:57 schrieb Theodore Petrosky:
> >
> > > I keep hunting for documentation on the styles
> > available in exporting to excel. for instance I see a
> > fillBackgroundColor and this comment:
> > >
> > > Styles:
> > > id="foo"
> > > font="someFontID"
> > >
> > alignment="ALIGN_GENERAL|ALIGN_LEFT|ALIGN_CENTER|ALIGN_RIGHT"
> > >
> >
> verticalAlignment="VERTICAL_TOP|VERTICAL_CENTER|VERTICAL_BOTTOM|VERTICAL_JUSTIFY"
> > >
> > borderLeft_borderRight_borderTop_borderBottom=
> > >
> >
> "BORDER_NONE|BORDER_THIN|BORDER_MEDIUM|BORDER_DASHED|BORDER_HAIR|BORDER_DOUBLE|BORDER_DOTTED|
> > >
> >
> >
> BORDER_MEDIUM_DASHED|BORDER_DASH_DOT|BORDER_MEDIUM_DASH_DOT|BORDER_DASH_DOT_DOT|
> > >
> >
> > BORDER_MEDIUM_DASH_DOT_DOT|BORDER_SLANTED_DASH_DOT"
> > >
> > leftBorderColor_rightBorderColor_topBorderColor_bottomBorderColor="0-xx"
> > >
> >
> fillPattern="NO_FILL|SOLID_FOREGROUND|FINE_DOTS|ALT_BARS|SPARSE_DOTS|THICK_HORZ_BANDS|THICK_VERT_BANDS|THICK_BACKWARD_DIAG|
> > >
> >
> THICK_FORWARD_DIAG|BIG_SPOTS|BRICKS|THIN_HORZ_BANDS|THIN_VERT_BANDS|THIN_BACKWARD_DIAG|THIN_FORWARD_DIAG|SQUARES|DIAMONDS"
> > > hidden="true"
> > > locked="true"
> > > wrapText="true"
> > > indention="0"
> > > rotation="-90...90"
> > > fillBackgroundColor="0-xx"
> > > format="some format string"
> > > */
> > >
> > > What is "0-xx"?
> > >
> > > Ted
> > >
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/bosyotech%40gmail.com
>
> This email sent to [email protected]
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
