"current cell" style disappears

[Jim Nagel]

Would it be possible to protect the "Current cell" style from being
deleted when working on a Fireworkz spreadsheet?

I've never quite worked out what makes it disappear, but it happens
often and it's annyoing! Perhaps it's when I delete a selection of
cells containing the current one -- but then isn't it usually the case
that a selected region includes the current cell?

My workaround is to keep a template file called "Curcell" on the
pinboard, handy to drop into the sheet whenever it happens.

--
Jim Nagel www.archivemag.co.uk

[Lazybownz]

I have done some tests using Fireworkz for Windows V1.34/10. I changed the Current Cell Style to use a red border, made a few dummy entries, Deleted entries containing the current cell but the new Current Cell Style remains with a red border. What Style changes do you make so that I can reproduce more accurately what you are doing. 

 

 

 

[Jim Nagel]

Lazybownz wrote on 3 Jan:

> I have done some tests using Fireworkz for Windows V1.34/10. I changed the
> Current Cell Style to use a red border, made a few dummy entries, Deleted
> entries containing the current cell but the new Current Cell Style remains
> with a red border. What Style changes do you make so that I can reproduce
> more accurately what you are doing.

My "Current cell" style is similar: red border, faintly tinted fill.
I doubt whether the particular style definition is relevant.

Just to be clear, "Current cell" does not disappear from the Styles
list when my problem happens, but the current cell (say B3) in my
sheet is no longer distinguished in any way: no border, no fill. If I
click in A4 to make it current, A4 likewise not take on the coloured
border or fill.
If, from the Styles menu, I go to "Current cell" style and Apply,
then A4 in my sheet takes on that style -- but unfortunately keeps it
even if I make (say) C5 current. (However, the workaround I described
in the original message does restore correct Current Cell behaviour.)

I still haven't worked out what causes the "Current cell" style to
become disconnected from the current cell. Trouble is, it's usually
several steps later before I notice it has happened. For instance,
just now I opened a sheet I was working on yesterday and only now
notice that the problem must have happened sometime late yesterday.
Perhaps it has to do with copying a row or group of rows to a
different position in the sheet -- I was doing a lot of that
yesterday.

I could email you a copy of that sheet privately in case there are
clues within the raw file, if you're familiar with Fireworkz innards.

--
Jim Nagel www.archivemag.co.uk

[Lazybownz]

I am familiar with the 'innards' of Fireworkz.

 

There is a couple of lines which define and then apply the Style called Current cell.

 

My best guess is that your original file is, in some way, corrupted so that Fireworkz gets confused about what Style it should apply to the cell which is at the input focus. Please send me a copy of a file which is behaving in the way you describe so that I can look at the 'innards'.

 

[Jim Nagel]

Revising an old thread.

Jim Nagel wrote on 2013 Jan 03:
> Would it be possible to protect the "Current cell" style from being
> deleted when working on a Fireworkz spreadsheet?

> I've never quite worked out what makes it disappear, but it happens often
> and it's annyoing! Perhaps it's when I delete a selection of cells
> containing the current one -- but then isn't it usually the case that a
> selected region includes the current cell?

Indeed a selected region must ipso facto contain the current cell!

> My workaround is to keep a template file called "Curcell" on the pinboard,

> handy to drop (anywhere) into the sheet whenever the glitch happens.


The problem I raised in 2013 about the "current cell" style disappearing
from the current cell is still a pain. I think I have a better clue now
of what causes it:

I have a few cells with various styles applied, such as italic or coloured
background (I've always used F11 to make bright yellow highlight a query).
The only way of removing such styles, as far as I have ever discovered, is
to select a range that covers all the cells I want to deal with, maybe a
slightly larger area, and then from menu do Style > Regions > Clear

And then of course the Current Cell style gets cleared too. Grrr.

(Just to be clear, the *definition* of the "Current cell" style remains in
the style menu, but that style is no longer apparent on the cell with
input focus. The current cell cannot be distinguished from others.)

Would it be possible to devise a less blunderbuss method of clearing
styles from a certain cell (or range of cells)?
Maybe a new item in the Styles dialogue? "Un-apply"? (ie, not the
same thing as "Delete")
Or make the keystroke that applies the style into a toggle? (ie, if the
style is already set, the same key will now un-set it). Other apps (e.g.
Impression) behave in this way.
When the region happens to contain instances of several styles (e.g.
bold and a background colour) it would be welcome if one of these styles
could be cleared without affecting the others. At present, Regions>Clear
removes *all* styles, leaving the user to re-apply the ones that should
have been kept.


--
Jim Nagel www.archivemag.co.uk
|| See you at the show? www.riscos-swshow.co.uk Feb 16