EXCELL Protection
 

There needs to be better protection on locked cells.

It is possible to alter the formatting of a locked cell by pasting into the
cell. Example pasting an entry copied from a % format into a currancy format
changes the cell to %. This also follows with coulours etc.

Secondly a formula in a locked cell can be corrupted by inadvertantly
removing cells that it refers to and then replacing them.

Mald

Hi
have you protected the sheet? (Tools - Protection')

--
Regards
Frank Kabel
Frankfurt, Germany

Mald wrote:
There needs to be better protection on locked cells.

It is possible to alter the formatting of a locked cell by pasting
into the cell. Example pasting an entry copied from a % format into
a currancy format changes the cell to %. This also follows with
coulours etc.

Secondly a formula in a locked cell can be corrupted by inadvertantly
removing cells that it refers to and then replacing them.

Mald

I was looking through the archives in Google at work trying to get a head
start in reading the Excel posts, (don't tell the boss! <g) and I found
that this post is entered in Google as

*1 new message of 1 Message - 1 author *

as if there was no initial post although the previous text could be
unhidden.

Does anyone know if this is a fault in Goolge's new interface, should it be
reported to them and if so how do you do it?

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Frank Kabel" wrote in message
...
Hi
have you protected the sheet? (Tools - Protection')

--
Regards
Frank Kabel
Frankfurt, Germany

Mald wrote:
There needs to be better protection on locked cells.

It is possible to alter the formatting of a locked cell by pasting
into the cell. Example pasting an entry copied from a % format into
a currancy format changes the cell to %. This also follows with
coulours etc.

Secondly a formula in a locked cell can be corrupted by inadvertantly
removing cells that it refers to and then replacing them.

Mald

I'm not sure what causes this, but I've seen it a few times in the older
interface, too.

http://www.google.com/contact/index.html

may get you close.

Sandy Mann wrote:

I was looking through the archives in Google at work trying to get a head
start in reading the Excel posts, (don't tell the boss! <g) and I found
that this post is entered in Google as

*1 new message of 1 Message - 1 author *

as if there was no initial post although the previous text could be
unhidden.

Does anyone know if this is a fault in Goolge's new interface, should it be
reported to them and if so how do you do it?

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk

"Frank Kabel" wrote in message
...
Hi
have you protected the sheet? (Tools - Protection')

--
Regards
Frank Kabel
Frankfurt, Germany

Mald wrote:
There needs to be better protection on locked cells.

It is possible to alter the formatting of a locked cell by pasting
into the cell. Example pasting an entry copied from a % format into
a currancy format changes the cell to %. This also follows with
coulours etc.

Secondly a formula in a locked cell can be corrupted by inadvertantly
removing cells that it refers to and then replacing them.

Mald



--

Dave Peterson

Thank you Dave,

I had never noticed it before but then with many threads of similar subjects
being lumped together it was probably not so obvious. Anyway for what its
worth I e-mailed them.

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Dave Peterson" wrote in message
...
I'm not sure what causes this, but I've seen it a few times in the older
interface, too.

http://www.google.com/contact/index.html

may get you close.

Sandy Mann wrote:

I was looking through the archives in Google at work trying to get a
head
start in reading the Excel posts, (don't tell the boss! <g) and I found
that this post is entered in Google as

*1 new message of 1 Message - 1 author *

as if there was no initial post although the previous text could be
unhidden.

Does anyone know if this is a fault in Goolge's new interface, should it
be
reported to them and if so how do you do it?

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk

"Frank Kabel" wrote in message
...
Hi
have you protected the sheet? (Tools - Protection')

--
Regards
Frank Kabel
Frankfurt, Germany

Mald wrote:
There needs to be better protection on locked cells.

It is possible to alter the formatting of a locked cell by pasting
into the cell. Example pasting an entry copied from a % format into
a currancy format changes the cell to %. This also follows with
coulours etc.

Secondly a formula in a locked cell can be corrupted by
inadvertantly
removing cells that it refers to and then replacing them.

Mald



--

Dave Peterson

I got an answer from Google which is reproduced below Because you cannot
request a post is removed in the these NG's it never occurred to me that
that could be the reason.


Start of Google's Reply ***************************

Hi Sandy,

Thank you for your note. It appears that this message has been removed
from the Google Groups Beta archive by the original author.

Please contact us again should you have any further questions.

Regards,
The Google Team

End of Google's Reply *******************************

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"Dave Peterson" wrote in message
...
I'm not sure what causes this, but I've seen it a few times in the older
interface, too.

http://www.google.com/contact/index.html

may get you close.

Sandy Mann wrote:

I was looking through the archives in Google at work trying to get a
head
start in reading the Excel posts, (don't tell the boss! <g) and I found
that this post is entered in Google as

*1 new message of 1 Message - 1 author *

as if there was no initial post although the previous text could be
unhidden.

Does anyone know if this is a fault in Goolge's new interface, should it
be
reported to them and if so how do you do it?

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk

"Frank Kabel" wrote in message
...
Hi
have you protected the sheet? (Tools - Protection')

--
Regards
Frank Kabel
Frankfurt, Germany

Mald wrote:
There needs to be better protection on locked cells.

It is possible to alter the formatting of a locked cell by pasting
into the cell. Example pasting an entry copied from a % format into
a currancy format changes the cell to %. This also follows with
coulours etc.

Secondly a formula in a locked cell can be corrupted by
inadvertantly
removing cells that it refers to and then replacing them.

Mald



--

Dave Peterson

Thanks for the update.

Sandy Mann wrote:

I got an answer from Google which is reproduced below Because you cannot
request a post is removed in the these NG's it never occurred to me that
that could be the reason.

Start of Google's Reply ***************************

Hi Sandy,

Thank you for your note. It appears that this message has been removed
from the Google Groups Beta archive by the original author.

Please contact us again should you have any further questions.

Regards,
The Google Team

End of Google's Reply *******************************

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk

"Dave Peterson" wrote in message
...
I'm not sure what causes this, but I've seen it a few times in the older
interface, too.

http://www.google.com/contact/index.html

may get you close.

Sandy Mann wrote:

I was looking through the archives in Google at work trying to get a
head
start in reading the Excel posts, (don't tell the boss! <g) and I found
that this post is entered in Google as

*1 new message of 1 Message - 1 author *

as if there was no initial post although the previous text could be
unhidden.

Does anyone know if this is a fault in Goolge's new interface, should it
be
reported to them and if so how do you do it?

Regards

Sandy

--
to e-mail direct replace @mailintor.com with @tiscali.co.uk

"Frank Kabel" wrote in message
...
Hi
have you protected the sheet? (Tools - Protection')

--
Regards
Frank Kabel
Frankfurt, Germany

Mald wrote:
There needs to be better protection on locked cells.

It is possible to alter the formatting of a locked cell by pasting
into the cell. Example pasting an entry copied from a % format into
a currancy format changes the cell to %. This also follows with
coulours etc.

Secondly a formula in a locked cell can be corrupted by
inadvertantly
removing cells that it refers to and then replacing them.

Mald



--

Dave Peterson

--

Dave Peterson