Thank you & apologies for not being clearer on my first attempt. I thought I had included OO v 2.4 and Vista premium as my system. My Dell has a windows experience base score of 5.5
I have spent 90 hours building a spreadsheet to calculate many en-route arrival times, times of ferries to catch and destination arrival time on a minibus journey from N Scotland to Iona. It uses many "IF", "TEXT", "TIME" and "LOOKUP" functions which all depend on one cell where start time is entered. In normal screen with menus atop, when pressing return after entering the start time, all the formulae normally calculate their correct answers. But in full screen some answers are often wrong until I press F9. Under options I have set "Itineration's" to 500 and "min change" to 0.000001 but that does not help. Full screen enables the bottom result line to be visible on the same screen as the start time which is near the top. I taught myself 20 years ago on Lotus Symphony & Smartsuite and only recently after a long break found Open Office which I love. I am wondering if there is information about formulae layout like dependant cells needing to be below or to the right; or restrictions about limits for nested "IF"s - that I have not found in help. Any suggestions much appreciated and thanks to all who bother to read beginners stuff and find the time to reply.
