Groups | Search | Server Info | Login | Register

Groups > comp.sys.acorn.apps > #19499

Re: Eureka Spreadsheet question

Show all headers | View raw

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

Back to comp.sys.acorn.apps | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Eureka Spreadsheet question Dave <dave@triffid.co.uk> - 2025-09-27 20:46 +0100
  Re: Eureka Spreadsheet question b.boase@bcs.org - 2025-10-01 12:44 +0100
    Eureka Spreadsheet question Dave <dave@triffid.co.uk> - 2025-10-01 16:26 +0100
      Re: Eureka Spreadsheet question Dave <dave@triffid.co.uk> - 2025-10-01 20:52 +0100
        Re: Eureka Spreadsheet question Dave <dave@triffid.co.uk> - 2025-10-01 20:57 +0100
          Re: Eureka Spreadsheet question Sebastian Barthel <naitsabes@freenet.de> - 2025-10-03 13:45 +0000

csiph-web