Michael, 

  It is a chart embedded in a worksheet. I rebuilt the entire template from
scratch - copying cell by cell (if I copied an entire worksheet I would
experience the crashing behavior. Even if I removed the sheet from the
workbook after copying it, the crashing behavior would still exist). So far
so good. I just have to update the page layouts for printing. If that works
then I should be good to go. I still don't know what was causing the thing
to crash though.

-----Original Message-----
From: Michael Zalewski [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 09, 2004 8:25 PM
To: POI Users List
Subject: RE: Problems with 2.0, 2.5


By 'chart page' do you mean a ChartSheet?

I think POI does not deal well with ChartSheets (only Worksheets, and maybe
MacroSheets). ChartSheets and DialogSheets don't have rows or columns or
Index or DbCell records, and HSSF mangles these by putting those records
into the workbook stream.

If it is a ChartSheet, try embedding the chart on a Worksheet.

-----Original Message-----
From: Veit, Michael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 09, 2004 9:27 AM
To: '[EMAIL PROTECTED]'
Subject: Problems with 2.0, 2.5

I have a couple of issues:

I am copying an excel file and then modifying it. It contains images and
charts/graphs.

POI 2.0 - copies & modifies fine but upon save in Excel it crashes.

POI 2.5 - just copying w/o modifying - can't open in Excel - "unable to read
file" message.

It seems to be the chart page - when removed everything is ok, but
unfortunately I can't leave that off the spreadsheet.

I've tried saving the original file (the one being copied) as different xls
formats, with the same results.

I think the copying of images and graphs is supported in POI.

Specs:

Excel 2002 (10.5815.4219) SP-2
JDK  1.4
Win2K Prof, Server

Anyone have a clue?

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to