Groups | Search | Server Info | Login | Register

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

Eureka Spreadsheet question

Show all headers | View raw

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

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