Re: HSSF Problem

It must be some formatting that 2003 doesn't like. Microsoft says that this is possible, they just don't offer any help as to how to figure out just *what* Excel is complaining about. It sure would be nice if they would issue detailed diagnostic messages.

You may have to use trial an error, starting with a simple, unformatted workbook and sheet and adding each cell feature until you can no longer open the sheet in MSO 2003. That would tell you what part of your code is generating a format that Excel 2003 isn't liking.

The Microsoft KB article is found here : http://support.microsoft.com/default.aspx?scid=kb;en-us;820712

Other references are here: http://ureader.com/message/1498039.aspx

Looks like a common problem. Search using the error string "Damage to the file was so extensive that repairs were not possible."

Pete


Prevesh Kuni wrote:

This is about as useful as eating soup with a fork :)
This is the text of the error message :
Microsoft Office Excel File Repair Log
Errors were detected in file 'C:\Documents and
Settings\KuniP\Desktop\MetCashTest.xls'
The following is a list of repairs:
Damage to the file was so extensive that repairs were not possible.
Excel attempted to recover your formulas and values, but some data may
have been lost or corrupted.
Prevesh Kuni
RPG Developer
Smollan Group SA (Pty) Ltd
(011) 640 8154 kunip@xxxxxxxxxxxxx

Pete@xxxxxxxxxx 2007/11/27 05:27:36 PM >>>

Hmmm. As an Open Office user, I don't use MS Office very much any more

although I have a copy of MSO 2003 and many files saved with previous versions of Excel and I was able to open all of them without an issue.

I didn't see your error message. If it was a graphic it was "sanitized"

out of the email. Do you know what the text of the error message is?

You either have something that is badly formatted and ignored by MSO 2000 or have not installed something in MSO 2003 that allows you to
open spreadsheets from earlier versions of MSO (unlikely). Perhaps with the

message text we could get closer to a solution.

Pete


Prevesh Kuni wrote:

Yes it does open in Office 2000:
The Spreadsheet is saved to the IFS as a .xls, now as an example - we

have two PC's - one with Office 2000 and another with Office 2003, if I
open the same document on the PC with Office 2000 it opens fine with all
of the formulas, printing setup and such, however if I open the document
on the PC with Office 2003 this is the error I receive....

Clicking on yes open the spreadsheet but without all of the formulas

and printing setups that I added?

Pete@xxxxxxxxxx 2007/11/26 04:26 PM >>>

Does it open in Office 2000? I would guess not. Office 2003 should automatically open a spreadsheet created for an earlier version of Office. It might prompt you to save it in a different format but I think MSO 2003 can open any Office document from earlier versions. I

don't recall having to install a "compatibility" component to make

that

happen.

Pete Helgren

Prevesh Kuni wrote:

Hi guys,

I have just written an RPGLE to write to Excel using the HSSF

(Thanks

Scott) - but is this only compatible with Office 2000 because since
installing Office 2003 the Spreadsheet is opening with an error of
unreadable content?

Thanks

Prevesh Kuni
RPG Developer
Smollan Group SA (Pty) Ltd
(011) 640 8154 kunip@xxxxxxxxxxxxx