RE: Some text formatting may have changed in this file because th ema ximum number of fonts was exceeded

["Greene, Kimberly (MAN-Corporate)" <Ki...@cox.com>]

Here is a bit of what I did. I did not create a new instance of HSSFCell for
each cell.
                listData = new ExcelCellData[7];
                for (int ii = 0; ii < 7; ii++)
                {
                    listData[ii] = new ExcelCellData();
                    listData[ii].setCellType(HSSFCell.CELL_TYPE_STRING);
                }

                listData[0].setCellValueString(item.getInvoiceNbr());
                listData[1].setCellValueString(arditem.getYear());
                listData[2].setCellValueString(arditem.getModel());
                listData[3].setCellValueString(arditem.getVIN());

                listData[4].setCellType(HSSFCell.CELL_TYPE_NUMERIC);

Regards,

Kimberly Greene
Consultant to Manheim Interactive
678-645-2349

 -----Original Message-----
From: 	Avik Sengupta [mailto:avik@apache.org] 
Sent:	Wednesday, December 11, 2002 11:58 AM
To:	POI Users List
Subject:	Re: Some text formatting may have changed in this file
because thema ximum number of fonts was exceeded

I presume you are writing the xl file using poi? Are you creating a new
HSSFCellStyle and/or HSSFFont object for each cell? That is usually a
problem. Try to reuse the object instances. 


On Wed, 2002-12-11 at 22:13, Greene, Kimberly (MAN-Corporate) wrote:
> When exporting using HSSF in the poi version released May 2002  I receive
> the following message when the number of total records is 7787(over 2
excel
> tabs). There are 2 fonts being used(Arial and Arial Bold) and 3 cell
> formats(string, date, and numeric)
> If anyone has seen this problem or has a potential resolution please
share.
> "Some text formatting may have changed in this file because the maximum
> number of
> fonts was exceeded. It may help to close other documents and try again"
> NOTE: there are no other documents open.
> 
> Regards,
> 
> Kimberly Greene
> Consultant to Manheim Interactive
> 678-645-2349
> 
> 
> --
> To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
> 




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>