"Barry Hylton Davies" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I downloaded OpenOffice yesterday and have been browsing around. I am most impressed.
However, I am unable to use OpenOffice.org Calc. For example, how to add the contents of 2 cells? I have tried various ways but without success. Under the relevant entry in Help, I am told that this is not available/couldn't be found, followed by: "The following data could be helpful in locating the error. Help ID: text%2Fscalc%2Fmain0000.xhp" Help! Regards, Barry Hylton Davies To add cells use =cell1+cell2+cell3 etc where cell1, etc are cell references such a A5, C8, etc. These are relative addresses to the cell the formula is in. If copied to another cell the references change. To refer to a fixed cell use a $ in front of column or row. For example $A$5. These are real addresses and do not change of a cell is copied but will change if a cell is moved. BTW: This is pretty standard within spreadsheets. The only thing I have found different in OpenOffice.org is that semi-colons are used instead of commas in formulas. -- Dennis Disclaimer: The above is my opinion. I do not guarantee it. Be sure to back up any files involved and use at your own risk. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]