spreadsheet which cells have been modified neooffice

Please help or, God forbid my attempt to extricate myself from Micro$oft will be over. This is so easy in Excel and can be done from sheet to sheet or workbook identically simply by typing = in a cell plus the cell reference from another sheet or workbook gotten by windowing to it and clicking on the cell you want to link to. Surely someone out there knows the answer to this. I'm still waiting for an explanation on simple linking between separate spread sheets. I tried to follow step by step but it is confusing and doesn't help. I had a hard time understanding just what the point of the explanation was. I tried following the method in the help menu using the Navigator and it didn't work for me either. But I have to get the same links to work between NeoOffice workbooks. I am quiet impressed at how it opens Excel Workbooks with links all over the place correctly. The first I tried to convert was linked to another workbook. I am trying to convert my Excel Workbooks to NeoOffice. Haven't tried linking with in the same workbook yet. I am linking to a cell on a completely different spreadsheet (workbook in Excel). Hope this encourages and doesn't confuse!Īre you talking about referring to a cell on another sheet within the same Calc document, or referring to a cell in an entirely different document? At least when I'm linking two cells on separate worksheets within the same workbook.įor example, using the technique you describe, my Sheet 1 A1 cell has this formula when I link to cell B2 on sheet 2: But so does hitting return in exactly the way you describe. I hit 'tab' to rather than 'return' and it works for me. I can get the link in the target cell but it returns #NAME? I have read the help file several times and tried to do as it says to no avail.

I often would perform math by adding one linked cell to another or some such operation.įor the life of me I can't figure out how to do this in NeoOffice. The cell reference then was linked to the sheet and displayed as the value for the new cell.

To link a value/cell from one spread sheet to another simply required that you have both sheets open and you type = on the target cell then window to or click on the sourse sheet, select the cell and hit return or enter. I am a virgin user of NeoOffice so please excuse what may be a stupid question. Posted: Fri 2:12 pm Post subject: Linking Cells NeoOffice :: View topic - Linking Cells Linking Cells NeoOffice announcements have moved to the NeoOffice News website This website is an archive and is no longer active

Spreadsheet which cells have been modified neooffice