That's it. I figured it out about 10 minutes ago. I caught it in the code
that I wasn't resetting the counter on the column.
OpenOffice's warning is a little vague, don't you think. I would think
they know the difference in rows & columns.
Thanks for your help.
Justin Wesbrooks
Information Systems
Anderson Merchandisers
[EMAIL PROTECTED]
800.999.0904 ext. 4855
Laubach Shawn Contr
OC-ALC/PSB To: "'POI Users List'"
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
er.af.mil> Subject: RE: Error opening file
[Virus Scanned]
10/10/2002 04:13 PM
Please respond to "POI
Users List"
The thing I notice the quickest is column numbers of 0xd22 (3362). Excel
only goes out to 255, I beleive. This would be the prime suspect. Looking
at your code, it does not look like to reset to your column counters at
all.
They just keep getting larger and larger.
Shawn Laubach
SAIC - Web Developer
B-1B System Support Management Division
OC-ALC/LAB, Building 3001, Tinker AFB, Oklahoma
dsn: 336-2473 comm: 405-736-2473 mobile: 405-245-9562
-----Original Message-----
From: Justin Wesbrooks [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 3:26 PM
To: [EMAIL PROTECTED]
Subject: Error opening file [Virus Scanned]
I have created a spreadsheet with approx. 2000 rows. When I try to open
the spreadsheet in Excel 2000 I get the following error...
The instruction at"0x77fcb375" referenced memory at "0xfffffff8". The
memory could not be "read".
Excel then shuts down.
When I try to open the spreadsheet in OpenOffice, I get the following
warning...
Warning loading document.
file:///C:/Documents%20and%20Settings/user/Desktop/workbook.xls:
The maximum number of rows has been exceeded. Excess rows were not
imported!.
However, OpenOffice actually opens the spreadsheet and EVERYTHING is there.
There are only
1892 rows to load. Could I be doing something that makes the 2 programs
think there are more rows
than actually exist??
(See attached file: workbook.xls)
(See attached file: POITest.java)
Justin Wesbrooks
Information Systems
Anderson Merchandisers
[EMAIL PROTECTED]
800.999.0904 ext. 4855
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
