The root of the problem use of text in a2 that is then used in the indirect function.
=IF(AH3="N","Sheet3!",IF(AH3="T","Sheet4!","Sheet1!"))
Excel uses the exclamation mark for sheet references and OOo uses a period. The import routine won't change the contents of a2 to OOo format because it is not part of on indirect function explicitly, but by reference. If you change the text in excel and save it, you'll get all REF# errors which will cause all the formulae in e5 to h200 to be in error. I can't spend any more time on it right now. It's an interesting problem, so I will look at it again.
tc
John King wrote:
I have been sent an xls file that throws up errors when opened in both ooo1.1.4 and 2beta, on both windows and linux.
It works perfectly when used on MSOffice 2000.
The file uses the INDIRECT function extensively, and I suspect that is where the problem lies, but I do not know enough about spreadsheets to be able to judge properly whether it suffers from the same problems as are listed in Issues under the use of INDIRECT, particularly as it does not seem to use named ranges, which seem to cause problems with ooo at the moment when importing xls files.
I have placed the file on:
http://www.greenking.demon.co.uk/oootest/programsooo2test.xls
for any calc experts out there who could check if the reasons it will not work in ooo have already been listed in Issues, or whether it is a new bug.
There are a lot of hidden rows/columns and some hidden sheets. Not to stop prying eyes, but simply because most of the users would only be confused by extraneous material.
The errors arise on the 'Programme' sheet - error:508
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
