Thanks Brian,
I am the only one with access to this computer.
Thanks for trying to help.
On 5/20/2016 12:00 AM, Brian Barker wrote:
At 22:26 19/05/2016 -0700, Ron Patterson wrote:
I have a column in my spread sheet ...
May I respectfully suggest that your problem may be that this is not
your spreadsheet but someone else's - in other words that the
difficulties are presented by aspects put in place by another.
... with only one entry in it at the top cell - I have tried
everything to clear this cell - nothing works, not delete, not
turning off cell protection in the Format Menu, not reformatting it,
not writing over it, and not even deleting the column. It is a dead
cell with "LL" in it and nothing less than a bomb will clear this cell.
This sounds as if the cell is protected. You cannot disable cell
protection until you have (possibly temporarily) disabled sheet
protection. Go to Tools | Protect Document > | Sheet... to toggle off
sheet protection. If you need to provide a password, the document's
author wants to prevent you making these changes.
Further, I have rows and the various cells in the fifth and last
column have entries some of which I want to clear. However, they can
neither be deleted not edited nor copied and pasted. Tried all the
above methods. These are again written in stone. There is only one
time consuming work around. The only way I have found to clear these
entries is to insert a new row underneath, Copy the first 4 good
columns to the new row and then delete the row above.
That also fits with the suggestion above.
What a chore. MS Office was so easy. This program fights everything I
try to do.
1. If Microsoft Office was easy, that may have been because you spent
some time learning it. OpenOffice deserves the same courtesy and will
repay it.
2. It's good that everyone has a choice of software.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
