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]
