Re: HSSF Problem

[Pete Helgren <Pete@xxxxxxxxxx>]

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 
> >
> >
> >