On Tuesday 21 June 2005 23:57, + Bob Lack wrote: > [ MODERATED ] *********************** > Hello, > > I'm just getting to grips with the spreadsheet, but there is one quirk I > can't seem to sort out. Help, please! > > I want to edit an existing spreadheet. It was built in Excel and imported > to Open Office. In Excel (and any other spreadsheet I have ever used) > selecting a cell displays the cell's contents on the input line, which aids > editting. For some reason with Open Office when I select a cell the input > line remains blank. I can use the input line to over-write what is already > there, but I can't see what is already there to edit it. Meanwhile the cell > contents remains displayed normally in the cell itself. > > No doubt there is a "hide" switch somewhere, but I can't find it! So, > please, what do I have to do to get a cell's existing contents to display > in the input line?
As you are not subscribed you may not have seen that: On Thursday 23 June 2005 15:52, Daniel Rentz wrote: > > Seems that the cell has hidden formulas. > > Just unprotect the sheet (Tools -> Protect -> Sheet). You can change the > cell protection here (Format -> Cell -> Protect -> Hide Formula), if you > want to protect the sheet again. Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
