Re: HSSF Problem

["Prevesh Kuni" <KuniP@xxxxxxxxxxxxx>]

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