poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Medina (AM)" <amed...@offix.de>
Subject AW: problem with too many Date-Cells
Date Thu, 06 Mar 2008 16:25:50 GMT

Ah thanks,

its working now :)


-----Ursprüngliche Nachricht-----
Von: Nick Burch [mailto:nick@torchbox.com] 
Gesendet: Donnerstag, 6. März 2008 16:59
An: POI Users List
Betreff: Re: problem with too many Date-Cells

On Thu, 6 Mar 2008, Alexander Medina (AM) wrote:
> We're exporting large Excelsheets with plenty of date values. If we have 
> more than ~4000 cells with date values, Excel says that there are too 
> many different cellformats and removes them from the sheet

See http://poi.apache.org/hssf/quick-guide.html#WorkingWithFonts

Your mistake is to create one cell style per cell, which is bad. Create 
any styles you need only once, and apply them to each cell that needs it

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message