On Thu, 2006-01-26 at 07:48 +1000, Max Aboutproperty wrote: > Hi Anthony, > I am using Windows XP with the latest updates. > I was using OpenOffice Ver 1.4 (I believe). > I installed Ver 2.0 yesterday. > Then deleted Ver 1.4. > Then I discovered the problem with the spreadsheet. > I downloaded another copy of Ver 2 from a different server. > Installed that, still the same problem. > I have completely removed all versions and re-installed ver2
Not sure but I think this was mentioned in this list within the past two days. The problem seems to be that some of the Help files are missing from that windows release. Please see http://www.oooforum.org/forum/viewtopic.phtml?t=28931 for a fix > > Using your Help, the functions LOOKUP and IF are listed but there is not > any help ? > The formula that I have used in the past is : > =LOOKUP(1;M12:M791;J12:J791) > > I have a notebook computer also running Windows XP with the latest updates. > It is using OpenOffice Ver 1.1, which works fine. > Cheers, > Max. > Try 1.1.5. It of the 1.1.x series can read the new ODF files. > > Anthony Chilco wrote: > > > Hi Max, > > A little more information would go a long way to getting you the help > > you need. Tell us what your operating system is and give some examples > > of the formulae that don't work and the results that you are getting. > > tc > > > > You appear not to be subscribed to the users mailing list. You could > > miss many of the replies to your post unless you do subscribe. Just > > send a blank message addressed to <[EMAIL PROTECTED]> > > using the e-mail account through which you want to receive it. You > > will receive a message asking you to confirm your subscription by > > replying to it. See http://support.openoffice.org/index.html for more > > options. > > > > Max Aboutproperty wrote: > > > >> I have used ver 1.1.0 > >> Created spreadsheets using "lookup" and "if". > >> I installed ver 2.0 30 minutes ago. > >> My spreadsheets do not work. > >> Have re-installed ver 2.0 > >> No joy. > >> Cheers, > >> Max. > >> > >> > > > > > -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
