Bug 15232 - VBA Macros cause 'File Not Found' errors in Excel 97
Summary: VBA Macros cause 'File Not Found' errors in Excel 97
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 1.5
Hardware: PC other
: P3 blocker (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-12-10 14:39 UTC by max
Modified: 2004-11-16 19:05 UTC (History)
0 users


Attachments
original workbook file w/ a 'Calculate' macro in the second worksheet (19.50 KB, application/vnd.ms-excel)
2002-12-10 14:41 UTC, max 		Details
Resulting corrupted file (14.50 KB, application/vnd.ms-excel)
2002-12-10 15:02 UTC, max 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description max 2002-12-10 14:39:30 UTC 
code scenario:
1. open an .xls workbook with a simple macro that re-computes a worsheet on 
activation
2. populate some rows
3. write to another file

no exceptions are thrown, but when trying to open in Excel97, several message 
boxes come up with 'File Not Found' message , and the file never loads
Comment 1 max 2002-12-10 14:41:24 UTC 
Created attachment 4111 [details]
original workbook file w/ a 'Calculate' macro in the second worksheet
Comment 2 max 2002-12-10 14:43:47 UTC 
actually, the jar version is 1.9.0-dev
also tried with 1.5
Comment 3 max 2002-12-10 15:02:51 UTC 
Created attachment 4113 [details]
Resulting corrupted file
Comment 4 Avik Sengupta 2002-12-10 15:17:13 UTC 
1. Where exactly does POI fit in, in the code scenario? I assume it is step 2?

2. POI1.5 did not support writing sheets with macros. You will have to use the
latest dev release. (In any case, if  you are using 1.5, you should upgrade to
1.5.1)
Comment 5 max 2002-12-10 15:41:17 UTC 
my bad, i thought i tried it w/ 1.9.0-dev - but had an old jar somewhere in 
eclipse...

seems to work ok now

THANX!