From Newsgroup: comp.sys.acorn.apps


Good day.
I have a small number of important cells grouped together in the larger spreadsheet and they must never be edited/changed.

Is it possible in Eureka to lock only these cells, but leave the rest of
the sheet editable?

Thanks
Dave
--

Dave Triffid
--- Synchronet 3.21a-Linux NewsLink 1.2

From Newsgroup: comp.sys.acorn.apps

On 27 Sep 2025, dave@triffid.co.uk wrote:

Is it possible in Eureka to lock only these cells, but leave the rest of
the sheet editable?

Yes, though it's not obvious because you have to specify the _unlocked_
cells in an otherwise locked sheet. I don't think I should try further summarising what the Eureka manual page B-30 actually says, so here goes:

"Eureka offers two levels of security for protecting cell contents from modification and inspection.

A _locked_ cell cannot be changed, provided the worksheet is protected; attempts to modify it directly, format it, move it, paste over it, or
shift its location via the Insert and Delete commands are denied. You can, however, copy a locked cell to another cell. By default, all cells on a
new worksheet start out locked; however, the locked attribute only takes effect when worksheet protection is enabled via Options->Protect Document. Thus, the normal state allows editing of cells. Once you have enabled worksheet protection, you will not be able to do much in the way of
modifying a locked cell, so if you intend for the user to be able to alter
the cell, you should unlock it prior to protecting the worksheet.

To lock or unlock a cell, perform the following steps:

1. Select the range or ranges you wish to modify.
2. Choose Format->Protection, or Ctrl-Shift-F2. The cell protection
dialogue appears.
3. Select or deselect the _Locked_ button as desired.
4. Click _OK_."

Bernard
--
b.boase@bcs.org
--- Synchronet 3.21a-Linux NewsLink 1.2

From Newsgroup: comp.sys.acorn.apps

In article <b744f5645c.boase@bernard>,
<b.boase@bcs.org> wrote:

On 27 Sep 2025, dave@triffid.co.uk wrote:

Is it possible in Eureka to lock only these cells, but leave the rest
of the sheet editable?

Yes, though it's not obvious because you have to specify the _unlocked_
cells in an otherwise locked sheet. I don't think I should try further summarising what the Eureka manual page B-30 actually says, so here goes:

"Eureka offers two levels of security for protecting cell contents from modification and inspection.

A _locked_ cell cannot be changed, provided the worksheet is protected; attempts to modify it directly, format it, move it, paste over it, or
shift its location via the Insert and Delete commands are denied. You
can, however, copy a locked cell to another cell. By default, all cells
on a new worksheet start out locked; however, the locked attribute only
takes effect when worksheet protection is enabled via Options->Protect Document. Thus, the normal state allows editing of cells. Once you have enabled worksheet protection, you will not be able to do much in the
way of modifying a locked cell, so if you intend for the user to be
able to alter the cell, you should unlock it prior to protecting the worksheet.

To lock or unlock a cell, perform the following steps:

1. Select the range or ranges you wish to modify. 2. Choose Format->Protection, or Ctrl-Shift-F2. The cell protection dialogue
appears. 3. Select or deselect the _Locked_ button as desired. 4. Click _OK_."

Bernard

Thank you for your thoughts Bernard, but again as with many times in the
past I've just about given up.

From the past, in my Eureka Manual I have my notes of the specific steps
to make it work, but it only works sometimes. :-(

This evening I'll revisit my notes and see... :-/

Thanks for the thoughts...

Dave
--

Dave Triffid
--- Synchronet 3.21a-Linux NewsLink 1.2

From Newsgroup: comp.sys.acorn.apps

[Snip everything]

It seems, I sorted this little annoyance out many years ago, and after
writing easy to understand notes on how to do it, I put them in the Eureka Manual at page B30.

During an office refurb/redecoration some years ago the Eureka manual
along with other stuff was put in the loft out of the way.

Retrieved the manual today and there it was... my notes... Gave them a
test or two and it worked.

Yehaw!

Dave
--

Dave Triffid
--- Synchronet 3.21a-Linux NewsLink 1.2

From Newsgroup: comp.sys.acorn.apps

On 01 Oct, dave@triffid.co.uk wrote:

[Snip everything]

It seems, I sorted this little annoyance out many years ago, and after writing easy to understand notes on how to do it, I put them in the
Eureka Manual at page B30.

During an office refurb/redecoration some years ago the Eureka manual
along with other stuff was put in the loft out of the way.

Retrieved the manual today and there it was... my notes... Gave them a
test or two and it worked.

Yehaw!

Dave

The methodology for this action in Spreadsheets is quite arse about face.

It should be a simple case of selecting the cells you want to protect and clicking/menu option to lock them instead of the rigmarole required... :-(

Dave
--

Dave Triffid
--- Synchronet 3.21a-Linux NewsLink 1.2

From Newsgroup: comp.sys.acorn.apps

Am Wed, 01 Oct 2025 20:57:51 +0100 schrieb Dave:

On 01 Oct, dave@triffid.co.uk wrote:

[Snip everything]

It seems, I sorted this little annoyance out many years ago, and after
writing easy to understand notes on how to do it, I put them in the
Eureka Manual at page B30.

During an office refurb/redecoration some years ago the Eureka manual
along with other stuff was put in the loft out of the way.

Retrieved the manual today and there it was... my notes... Gave them a
test or two and it worked.

Yehaw!

Dave

The methodology for this action in Spreadsheets is quite arse about
face.

It should be a simple case of selecting the cells you want to protect
and clicking/menu option to lock them instead of the rigmarole
required... :-(

But thats probably not the way a spreadsheet worked in the 1980s.

I could imagine that another variant to reach Your target is: Create 2
sheets. Protect one of them. Copy the relevant cells into the other sheet
as links. Eventually this could give You some "protected" cells or
coloumns. Never tried this - its just an idea that came to mind.
--- Synchronet 3.21a-Linux NewsLink 1.2