Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (nike.apache.org: local policy)
From: "Martin Studer" <martin.studer@mirai-solutions.com>
To: <user@poi.apache.org>
Subject: User-defined cell styles in HSSF and XSSF
Date: Fri, 30 Jul 2010 12:25:12 +0200
Message-ID: <000901cb2fd1$7eb48060$7c1d8120$@studer@mirai-solutions.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_000A_01CB2FE2.423D5060"
Thread-Index: Acsv0X6HRW+RgrqrQLqgLrYEXbAQqw==
Content-Language: de-ch

------=_NextPart_000_000A_01CB2FE2.423D5060
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi all,

 
I'm using POI 3.7-beta1 and currently working with (user-)named CellStyles
(HSSF and XSSF workbooks).

 
For HSSF workbooks I wanted to do something like this:

 
HSSFWorkbook wb = ...

HSSFCellStyle cs = wb.createCellStyle();

cs.setUserStyleName(name);

 
However, when I try to do that I get an "Unable to set user specified style
names for built in styles!" exception. When I'm creating a new cell style, I
shouldn't be getting a built-in style, should I?

 
Also, for XSSF workbooks I currently didn't find a way to directly deal with
user defined style names. Is this something which is planned for the 3.7
release?

 
Thank you for your help,

Martin

 
------=_NextPart_000_000A_01CB2FE2.423D5060--