Return-Path: 
 <users-return-90559-apmail-cocoon-users-archive=cocoon.apache.org@cocoon.apache.org>
Delivered-To: apmail-cocoon-users-archive@www.apache.org
Received: (qmail 44706 invoked from network); 28 Feb 2007 14:24:45 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 28 Feb 2007 14:24:45 -0000
Received: (qmail 24416 invoked by uid 500); 28 Feb 2007 14:24:49 -0000
Delivered-To: apmail-cocoon-users-archive@cocoon.apache.org
Received: (qmail 24364 invoked by uid 500); 28 Feb 2007 14:24:48 -0000
Mailing-List: contact users-help@cocoon.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:users-help@cocoon.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@cocoon.apache.org>
List-Post: <mailto:users@cocoon.apache.org>
Reply-To: users@cocoon.apache.org
List-Id: <users.cocoon.apache.org>
Delivered-To: mailing list users@cocoon.apache.org
Received: (qmail 24353 invoked by uid 99); 28 Feb 2007 14:24:48 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Feb 2007 06:24:48 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of gary.larsen@envisn.com
 designates 216.57.116.7 as permitted sender)
Received: from [216.57.116.7] (HELO mx2.pshift.com) (216.57.116.7)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Feb 2007 06:24:36 -0800
Received: from JAVAGUY1 (unverified [216.204.134.74]) by mx2.pshift.com
  (Vircom SMTPRS 4.4.568.0) with ESMTP id <B0294090605@mx2.pshift.com> for
 <users@cocoon.apache.org>;
  Wed, 28 Feb 2007 09:23:25 -0500
X-Modus-BlackList: 216.204.134.74=OK;gary.larsen@envisn.com=OK
X-Modus-RBL: 216.204.134.74=OK
X-Modus-Trusted: 216.204.134.74=NO
X-Modus-Audit: FALSE;0;0;0
From: "Gary Larsen" <gary.larsen@envisn.com>
To: <users@cocoon.apache.org>
Subject: HSSFSerializer cell style
Date: Wed, 28 Feb 2007 09:29:16 -0500
Message-ID: <000401c75b44$d3fa04b0$4f01a8c0@envisnofc.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 11
Thread-Index: AcdbRNNEWziP0c7UTxCZbMWDvw039A==
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-Virus-Checked: Checked by ClamAV on apache.org

It seems that the only way to apply styles to cells is with <StyleRegion>
but in my case it's difficult to predict beforehand which cells will need
formatting.

Is there a way to apply formatting in the <Cell> element?  I found this in
the Gnumeric File Format doc:

	<gmr:Cell Col="0" Row="0" Style="0">

And this structure in an email:

	<CellStyles>
		<Style No="1" ....>
		</Style>
	</CellStyles>			

That HSSFSerializer chokes on that but this is accepted:

	<CellStyles>
		<CellStyle No="1" Back="9800:CC00:F800"/>
		<CellStyle No="LeftAlign" HAlign="2"/>
	</CellStyles>			

But appling the style to a cell has no effect:

	<gmr:Cell Col="1" ValueType="30" Style="LeftAlign">

Does anyone know if this is possible?

Thanks,
Gary


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org