poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dale Bronk" <dbr...@windscape.com>
Subject RE: Excel not calculating
Date Fri, 13 Dec 2002 00:14:48 GMT

Ok...  I found where/how to enter this as a macro.  Problem is it really
doesn't help and causes the output from POI HSSF to not be able to be
opened.

I added the macro in my POI saved excel workbook and it worked great.  I
then added the macro into my base excel workbook.  Ran my program that reads
my base workbook, enters data into a couple entry cells, and then saves it
out to a new excel file.  When trying to open the new file I get a File Not
Found error.  Looks like POI does not handle macros and the users are going
to be loading data into these sheets a ton so I can't have them manually
enter the macro each time.

Any other solutions?  This is a huge show stopper for me.  Any one know why
Excel does not recalc even when I click F9-recalc?

My entire design is based on this working so I am beginning to panic a bit
as the alternative is really ugly.

Thanks,
Dale



-----Original Message-----
From: Dennis Doubleday [mailto:dennis@righthandmanager.com]
Sent: Thursday, December 12, 2002 10:35 AM
To: 'POI Users List'
Subject: RE: Excel not calculating



I have the following in my templates:

Private Sub Workbook_Open()
    Application.ScreenUpdating = False
    'Make the entire workbook recalculate. Can be
    'done with Application.CalculateFull in Excel2000
    'but this is back-compatible to Excel97.
    SendKeys "%^{F9}", True
End Sub

Seems to work.



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






Mime
View raw message