Bob Lack schrieb:
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?
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.
Best regards
Daniel
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
