Very interesting Brian. This spreadsheet was saved to AOO from MS
Office. I still have the original MS Spreadsheet and this column has no
entry in the top cell. The column and/or cell can be deleted, edited,
written too, etc. etc. but not in AOO. Also, I found sheet and document
protection and removed the checkmark turned it off and then turned off
cell protection from the format menu. All to no avail. I can't believe
this is so difficult to clear a cell. All the other columns and cells
behave perfectly.
On 5/20/2016 9:57 AM, Brian Barker wrote:
At 06:57 20/05/2016 -0700, Ron Patterson wrote:
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.
Thanks Brian,
I am the only one with access to this computer.
Thanks for trying to help.
Hey, not so fast!
First, no-one suggested that an interloper was interfering with your
system! Instead, I assumed that if you had entered the "LL" yourself
and caused it to be difficult to modify, then you would know what you
had done and why you had done it and how to undo it - and you would
not be asking for help. The obvious guess is that this spreadsheet was
not created from scratch by you but was perhaps provided to you by
someone else - that you were sent it or downloaded it as an existing
spreadsheet. And the original author may have intentionally protected
some parts of the spreadsheet in order to prevent or hinder your
modifying them - whether by accident or by design.
Do you mean, then, that you haven't checked to see if the sheet is
indeed protected, as explained? That's not the way to learn.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
