Fireworkz32
Dave Symes
spreadsheets from Eureka to Fireworkz32.
I have a snaggypoo that's driving me up the wall, so I'm hoping the
solution is easy, or perhaps it's a BUG afterall.
I've created a Style called "Reconcile", the only things set in it are the
Font "Selwyn" and the size 10 point.
This Style has been applied to a column in which I will enter a tick by
pressing the "b" key (Alt-98 if you prefer that way) or a cross "c" key
(Alt 99).
In Fwz32 this is not working as expected, or as it does works in other
applications.
In Fwz32 pressing "b" does indeed get the tick, but pressing "c" doesn't
get the cross, instead it enters four other characters from just a single
"c" keypress.
The four Selwyn characters are Alt-67,97,115,111 in that order.
Why am I not getting my cross when I press "c"?
Why am I getting four other characters from one keypress?
Cheers
Dave S
--
David
Dave Symes <d...@ukgateway.net> wrote:
Works using dingbats
Best wishes
--
Dave Wisnia, Leeds
Steve Fryatt
<4dac6f...@ukgateway.net>:
> I'm still in the long and tedious process of converting all my business
> spreadsheets from Eureka to Fireworkz32.
>
> I have a snaggypoo that's driving me up the wall, so I'm hoping the
> solution is easy, or perhaps it's a BUG afterall.
>
> I've created a Style called "Reconcile", the only things set in it are
> the Font "Selwyn" and the size 10 point.
>
> This Style has been applied to a column in which I will enter a tick by
> pressing the "b" key (Alt-98 if you prefer that way) or a cross "c" key
> (Alt 99).
>
> In Fwz32 this is not working as expected, or as it does works in other
> applications.
>
> In Fwz32 pressing "b" does indeed get the tick, but pressing "c" doesn't
> get the cross, instead it enters four other characters from just a
> single "c" keypress.
>
> The four Selwyn characters are Alt-67,97,115,111 in that order.
It doesn't do that here -- Fireworkz32 1.32/06, on RISC OS 5. Typing "b"
or "c" gives the tick or cross as expected.
> Why am I not getting my cross when I press "c"? Why am I getting four
> other characters from one keypress?
You aren't running some kind of macro tool, are you?
--
Steve Fryatt - Leeds, England
Dave Symes
> Best wishes
Sorry nope! not here it doesn't, but I appreciate your suggestion.
I've already tried Dingbats and the problem was worse.
In that I get a tick, but I also get three of, what look like pencil stubs.
The cross also arrives with the three pencil stubs.
I have absolutely no idea what's going on here, but then I find FWZ32 on
the whole a strange creature when compared to Excel or Eureka.
Any additional thoughts David?
Anyone?
Cheers
Dave S
--
Dave Symes
Steve Fryatt <ne...@stevefryatt.org.uk> wrote:
> You aren't running some kind of macro tool, are you?
> Steve Fryatt - Leeds, England
Erm! I wouldn't know a macro tool if it came up and bit my bum.
I've been doing a bit more testing...
If I open a new bog standard Fwz32 spreadsheet and set up the Reconcile
style and apply it to a column, then the Selwyn "b" or "c" works okay.
So it must be something in my sheet that's responsible, but what I wonder?
Cheers
Dave S
--
Dave Symes
> Cheers
> Dave S
It seems you were right Steve.
As with my Eureka sheets there are macros?? active.
Typing the letter c followed by a return enters the word "Cash" into the
cell, typing the letter d writes "Delta" and q writes "Cheq" etc.
Trouble is, I not only have no memory of writing the macros, I have no
idea how to do it in Fwz32 but they exist in this particular sheet.
Dave S
--
Christopher Rayson
<URL:mailto:d...@ukgateway.net> wrote:
> As with my Eureka sheets there are macros?? active.
> Typing the letter c followed by a return enters the word "Cash" into the
> cell, typing the letter d writes "Delta" and q writes "Cheq" etc.
>
> Trouble is, I not only have no memory of writing the macros, I have no
> idea how to do it in Fwz32 but they exist in this particular sheet.
I suspect you have 'names' defined.
Bring up the functions menu ('Extra -> Functions' or click on the 'f' button
in the top row of the button bar) and choose 'Names...' to view the Names
window, from where these can be added/edited/deleted.
(This is for FireworkzPro, I expect Fireworkz32 is similar?)
Incidentally, you can use the the 'Number' attribute of a style to insert
ticks/crosses for true/false values automatically; set the typeface to Selwyn
as before, and also, in the 'Formats' box under the 'Number' tab, tick the
'Number' option and enter:
"b";"b";"c"
into the icon field. Cells with this style applied will then show a tick if
they contain a non-zero number, and a cross otherwise; if they contain a
comparison (eg "A1>0") or other formula with a true/false value, the glyph
displayed will reflect its outcome.
Hope some of that helps,
Chris
Dave Symes
> "b";"b";"c"
Aha! Christopher, That's it... Bringing up the Names dialogue and I can
see the names I have defined, and for ease of use I've made them the same
as the ones I've been using in Eureka for the past nnn years.
At present, I only have Fwz32 in use when I'm constructing Fwz versions of
my existing business Eureka sheets, so it's easy to forget (lack of
continual use) what I've been doing, or how I 'dun' it.
I suppose I'll have to change the name for cash, probably "L" for lolly,
what a PITA, I don't get this problem/clash in Eureka.
Thanks for the advice, much appreciated.
Cheers
Dave S
--
Steve Fryatt
<4dacfc...@ukgateway.net>:
> In article <ant19181...@cjr43.acad.cai.cam.ac.uk>,
> Christopher Rayson <chris...@yahoo.com> wrote:
>
> > Incidentally, you can use the the 'Number' attribute of a style to
> > insert ticks/crosses for true/false values automatically; set the
> > typeface to Selwyn as before, and also, in the 'Formats' box under the
> > 'Number' tab, tick the 'Number' option and enter:
>
> > "b";"b";"c"
>
> > into the icon field. Cells with this style applied will then show a
> > tick if they contain a non-zero number, and a cross otherwise; if they
> > contain a comparison (eg "A1>0") or other formula with a true/false
> > value, the glyph displayed will reflect its outcome.
>
> Aha! Christopher, That's it... Bringing up the Names dialogue and I can
> see the names I have defined, and for ease of use I've made them the
> same as the ones I've been using in Eureka for the past nnn years.
>
> At present, I only have Fwz32 in use when I'm constructing Fwz versions of
> my existing business Eureka sheets, so it's easy to forget (lack of
> continual use) what I've been doing, or how I 'dun' it.
>
> I suppose I'll have to change the name for cash, probably "L" for lolly,
> what a PITA, I don't get this problem/clash in Eureka.
Why not try Christopher's suggestion of setting the Reconcile style to
show tick and cross for true/false values instead of the raw characters?
--
Steve Fryatt - Leeds, England
Harriet Bazley
Dave Symes wrote:
[snip]
>
> As with my Eureka sheets there are macros?? active.
> Typing the letter c followed by a return enters the word "Cash" into the
> cell, typing the letter d writes "Delta" and q writes "Cheq" etc.
>
> Trouble is, I not only have no memory of writing the macros, I have no
> idea how to do it in Fwz32 but they exist in this particular sheet.
>
Fireworkz files are basically plain text files with various style
definitions and lists of where the regions affected are; if you hold
down Shift and open the offending spreadsheet you should be able to
search for the offending words and locate the macro definition line.
If you delete this it should delete the macro.
But I too would be interested to know what a macro definition looks like
in a Fireworkz sheet, let alone how to create one from the desktop!
--
Harriet Bazley == Loyaulte me lie ==
When you breathe you inspire; when you do not breathe, you expire.
Dave Symes
Steve Fryatt <ne...@stevefryatt.org.uk> wrote:
> Why not try Christopher's suggestion of setting the Reconcile style to
> show tick and cross for true/false values instead of the raw characters?
Well, I guess there are two reason...
1) I don't see how it would help in the circumstances I'm using the sheet.
At the end of the month, I have the data entered into the spreadsheet, and
I have in my hand some bits of old fashioned paper.
My task now is to check the entries in the spreadsheet, and then leave a
visible marker for my accountant that the paper and sheet figures agree or
don't agree... Tick for agree, cross for don't agree...
Like for example: Because of lax office work, some people take forever to
get a cheque into the bank, consequently when I check my bank statements
against the spreadsheet record of payments made by cheque, the cheque paid
to Fred Bloggs, has not been processed through my bank account... "Cross".
The sheet has no way of knowing if that is true or false.
Cheers
Dave S
Oh yes, nearly forgot.
2) In these particular circumstances of use, I have no idea what the
"True/False values" means.
D.
--
Christopher Rayson
<URL:mailto:d...@ukgateway.net> wrote:
> > Why not try Christopher's suggestion of setting the Reconcile style to
> > show tick and cross for true/false values instead of the raw characters?
>
> Well, I guess there are two reason...
>
> 1) I don't see how it would help in the circumstances I'm using the sheet.
> [snip]
> 2) In these particular circumstances of use, I have no idea what the
> "True/False values" means.
In reverse order...
2) Ah, forgot to mention that - I meant to say, in your particular case, it
means 1 or 0; i.e. if you define the style as described, any zeros you enter
will be shown as crosses, and any ones (or other non-zero numbers) will be
ticks.
1) It isn't any more work than entering 'b's and 'c's; it makes some kind of
sense if you export the document as text/CSV, or if the Selwyn font isn't
available; and it gets round the macro problem[*], because 0 and 1 aren't
going to be expanded to anything, I hope.
Chris
[*] Which is probably my fault:
http://groups.google.com/group/comp.sys.acorn.apps/msg/e2bb5fce43f1df50?dmode=source&hl=en
Steve Fryatt
<4dad30...@ukgateway.net>:
> In article <56ea10ad...@helvellyn.stevefryatt.org.uk>,
> Steve Fryatt <ne...@stevefryatt.org.uk> wrote:
>
> > Why not try Christopher's suggestion of setting the Reconcile style to
> > show tick and cross for true/false values instead of the raw
> > characters?
>
> Well, I guess there are two reason...
>
> 1) I don't see how it would help in the circumstances I'm using the
> sheet.
>
> At the end of the month, I have the data entered into the spreadsheet,
> and I have in my hand some bits of old fashioned paper. My task now is
> to check the entries in the spreadsheet, and then leave a visible marker
> for my accountant that the paper and sheet figures agree or don't
> agree... Tick for agree, cross for don't agree...
Yes, so instead of typing "b" or "c", you would type "1" (true) or "0"
(false). That's "true" for agree; "false" for disagree. The only
real difference in your case is that they don't clash with the obvious
initial letter macros you have set up.
> Like for example: Because of lax office work, some people take forever
> to get a cheque into the bank, consequently when I check my bank
> statements against the spreadsheet record of payments made by cheque,
> the cheque paid to Fred Bloggs, has not been processed through my bank
> account... "Cross". The sheet has no way of knowing if that is true or
> false.
I assumed that it would be obvious in the context that you're just making
use of the facility in Fireworkz; if you do find a way of making the
computer reconcile your bank statements automatically, however, please let
us know... :-)
> 2) In these particular circumstances of use, I have no idea what the
> "True/False values" means.
In general, "true" is non-zero and "false" is zero (BBC BASIC uses the
slightly more restrictive definition of "true" = -1 and "false" = 0)
Dave Symes
Steve Fryatt <ne...@stevefryatt.org.uk> wrote:
> Yes, so instead of typing "b" or "c", you would type "1" (true) or "0"
> (false). That's "true" for agree; "false" for disagree. The only
> real difference in your case is that they don't clash with the obvious
> initial letter macros you have set up.
Thank for that Steve, I now see the advantage.
Cheers
Dave S
--
Matthew Barnett
>
> In general, "true" is non-zero and "false" is zero (BBC BASIC uses the
> slightly more restrictive definition of "true" = -1 and "false" = 0)
>
as true, and you also need to remember that AND, OR and NOT are bitwise
operators.
Dave Symes
> I'm still in the long and tedious process of converting all my business
> spreadsheets from Eureka to Fireworkz32.
Continuing my sad life converting things from Eureka to FWZ32, and boy is
it a sad hard life.
The rationale behind some things in this application seem to have been
designed by a person in Care.
However, we'll pass that over for the time being. (Dr Who).
I need some kindly person not residing in a loony bin (Which is where I'll
be before long) to have a chat with me by private email, about how I get
this thing to print exactly what I want it to print, and not what it
fancies it wants to print.
Gerald did do some explaining somewhile back, but I still can't make any
sense of it.
Cheers
Dave S
--
Dave Symes
> I wrote... and the saga continues.
> > I'm still in the long and tedious process of converting all my business
> > spreadsheets from Eureka to Fireworkz32.
> Continuing my sad life converting things from Eureka to FWZ32, and boy is
> it a sad hard life.
[Snip]
After turning over the house the afternoon, I eventually found the FWZ
manual and the notes I'd written in it the last time Gerald sorted my
printing mess.
Thanks to John Devine for contacting me with a help offer.
Now sorted.
Cheers
Dave S
--
Dave Symes
Please.
Say I always, only want only the summary page of my sheet printed when I
click the print icon. ( page 5.1).
How do I get this saved with the sheet, so that I don't have to re-set it
up, every time I want to print?
Cheers
Dave S
--