Amiel, thanks, your hint really did the trick. I am using the exportExcel example from the ERComponentTour. this example puts the font and style info in a plist.
from your example, I added the key for fillPattern and this fixed my issue. Do you know if there is a way to control column width? Ted --- On Fri, 4/15/11, Amiel Montecillo <[email protected]> wrote: From: Amiel Montecillo <[email protected]> Subject: Re: exporting to excel and styles To: "Theodore Petrosky" <[email protected]> Cc: [email protected] Date: Friday, April 15, 2011, 8:24 PM 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]
