Lists

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: exporting to excel and styles

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: exporting to excel and styles

Subject: Re: exporting to excel and styles
From: Amiel Montecillo <email@hidden>
Date: Sat, 16 Apr 2011 08:24:47 +0800

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@hidden> wrote:

>
> Message: 7
> Date: Fri, 15 Apr 2011 16:06:11 +0200
> From: Anjo Krank <email@hidden>
> Subject: Re: exporting to excel and styles
> To: "email@hidden
> Dev Apple"
> <email@hidden>
> Message-ID: <email@hidden">email@hidden>
> 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@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References:
	>Re: exporting to excel and styles (From: Theodore Petrosky <email@hidden>)

Prev by Date: Re: AjaxFileUpload how to refresh Component Content SOLVED
Next by Date: Re: exporting to excel and styles
Previous by thread: Re: exporting to excel and styles
Next by thread: Re: exporting to excel and styles
Index(es):
- Date
- Thread