FireWorkz32
Dave Symes
transferring my business sheets to FWZ32.
Some successes and some failures, due to the strange way FireWorkz does
things. (I'm used to the Excel/Eureka way of doing things).
But that's another story... Back to the plot in hand.
In Eureka I have a series of Names set up so that for example, just typing
=C will actually write the full word "Cash" in the selected cell... and so
on with other names, like =Q will write in "Cheque".
Anyone have ideas how I might achieve similar expansions in FWZ?
Cheers
Dave S
--
Christopher Rayson
<URL:mailto:d...@ukgateway.net> wrote:
> typing =C will actually write the full word "Cash" in the selected cell...
> Anyone have ideas how I might achieve similar expansions in FWZ?
Assuming it works the same way as Fireworkz Pro...
* Open the 'Names' dialogue (from the 'Functions' menu - click the button
with the 'f' to the left of the formula entry icon - or from the main menu,
'Extra' -> 'Functions' -> 'Names...');
* Click on the 'Add...' button;
* In the 'Name' field, enter, eg 'C' and in 'Value', '"Cash"'
(NB including the ""-quotes!);
* Click OK.
Now in theory, entering 'C' into a blank cell should produce 'Cash'.
At least, it does here...
Chris
Dave Symes
> * Click OK.
> Chris
Thanks Chris,
That does the business perfectly.
Cheers
Dave S
PS: Though it does the same as in Eureka, I'd have never fathomed it out
without your info.
D.
--
Dave Symes
Another question please...
Aside from the fact this damn application drives me up the (expletive
delete) wall...
Okay.
I have a series of of cells, the important bit in columns.
* * * * * etc
* * * * *
* * * * *
* * * * *
* * * * *
* * * * *
etc.
Each cell contains a reference to a cell in another sheet (stored in the
same directory).
For example [ZMay]$f$52
I want to hilight one column of cells and do a Search/Replace, replacing
the ZMay with ZJun
I've done that, it doesn't work. Just bleeps and does nothing.
A very simple requirement, that could be done in Eureka with eyes closed.
Hows's it done in this "thing" please?
Cheers
Dave S
--
Dave Symes
Barry Allen (news) <evan...@onetel.net.uk> wrote:
> In article <4cb606...@ukgateway.net>, Dave Symes
> <d...@ukgateway.net> wrote:
> > Each cell contains a reference to a cell in another sheet (stored in
> > the same directory).
> > For example [ZMay]$f$52
> > I want to hilight one column of cells and do a Search/Replace,
> > replacing the ZMay with ZJun
> The only way I can make it work is to 'make' the cells be 'text' first,
> then do the search and replace, then 'make' the cells back to 'number'.
Thanks for that info Barry, I would never have guessed you'd have to do
that, what a damn performance.
Deary Me. I'm still wondering what kind of 'Toy' application I'm trying to
use here.
Totally illogical print engine.
Naffest copy/paste facility I've ever seen.
Weird page setup.
A variety of other Twilight Zone experiences I've banged the desk about,
but have since side stepped and forgotten.
Now a Search and replace that isn't unless you fiddle with the data first.
What next I wonder?
I'm not sure my blood pressure is up to this, I'm already taking Beta
Blockers as it is. :-(
Come back Doug Harrison, Please!
Dave S
--
VinceH (real address)
Barry Allen (news) <evan...@onetel.net.uk> wrote:
> I do find the copy and paste a bit weird where the only way
> you can keep cells fixed is to 'name' them, ie $e$4$n$16 will
> be copied relatively and not be fixed.
eh?
The whole point of the $s is to 'fix' the cell refs so
that they *aren't* copied relatively. It's a long time
since I've used Fireworkz (IIRC my copy isn't SA happy)
but I'm bloody sure it used to behave how I would have
expected it in that respect.
VinceH
--
http://www.vinceh.com/jenna/ 14/5/94-16/5/04 - Rest in peace
Harriet Bazley
Dave Symes wrote:
[snip]
> I want to hilight one column of cells and do a Search/Replace, replacing
> the ZMay with ZJun
>
> I've done that, it doesn't work. Just bleeps and does nothing.
>
> A very simple requirement, that could be done in Eureka with eyes closed.
>
PipeDream has this option as 'search expression slots'. I assumed it
would be in Fireworkz as well, but it seems to be one of the things
(along with chart options) that got lost in the upgrade. :-(
--
Harriet Bazley == Loyaulte me lie ==
NOBODY EXPECTS THE SPANISH INQUISITION!
andy wiseman
"VinceH (real address)" <sp...@softrock.co.uk> wrote:
> In article <4cb64c7e9...@onetel.net.uk>,
> Barry Allen (news) <evan...@onetel.net.uk> wrote:
>
>
> > I do find the copy and paste a bit weird where the only way
> > you can keep cells fixed is to 'name' them, ie $e$4$n$16 will
> > be copied relatively and not be fixed.
>
> eh?
>
> The whole point of the $s is to 'fix' the cell refs so
> that they *aren't* copied relatively. It's a long time
> since I've used Fireworkz (IIRC my copy isn't SA happy)
> but I'm bloody sure it used to behave how I would have
> expected it in that respect.
>
> VinceH
>
Strictly speaking the $s fix references in replication (fill in Excel
speak which sad to say excels at this).
There is a need for both copies as was provided in Pipedream.
The Fireworkz method is the equivalent of PipeDreams copy block to
paste list then paste. The other way, which fixed everything was to
mark the block, move the cursor and use copy. i.e. copy direct in
sheet (a feature much debated as it disappeared from the likes of
edit)
My workaround is exactly the same as for the search - make text, copy,
make number.
For me Firworkz compared with Pipedream took two steps forward and one
back. That's why I still use both depending what I want to do.
Andy
--
Dave Symes
Steven Pampling <steve.p...@dsl.pipex.com> wrote:
[Snip]
> It's not even as though using $ as a fixed rather than relative cell
> reference isn't used in other spreadsheets like (dare I say it.... Excel)
> I'll go and wash my mouth out now...
Steve, you don't need to be so defensive...
MS may 'generally' produce crap applications, but Excel is by far the best
thing they've produced, and thinking about it honestly, it is the best
spreadsheet application of all those I've used.
Cheers
Dave S
--
Dave Higton
Dave Symes <d...@ukgateway.net> wrote:
Hmm. I've just been having some adventures with it at work. It was
unable to count the pages it was printing. (Pages 1 and 2 of 3 when
there were only 2, and pages 1 to 3 of 4 when there were only 3.)
The ability to count seems a basic requirement for a spreadsheet.
It's a pig to use, and I've known it shred my data once.
Dave
Nick Roberts
But that's because MS didn't write Excel - like most of the better
products that they sell, they bought it from someone else.
And actually, Excel isn't all that good if you really try to hammer it
rather than use it to produce end-of-month accounts.
It's limited to only 31 thousand rows - I have a stochastic application
that generates CSV files about 10K lines long for each replication,
and I need to run at least 20 to 30 replications...
Like: the statistical functions are, in general, broken. Even the
standard deviation function is dubious - it only really works if the
source data are not extremely large or extremely small (it uses the
hand-calculator approach to the computation, which means that unnecessary
errors are introduced for extreme values).
Also: There is a standard statistical definition of the word "Rank",
and how it should calculated. Excel provides a RANK function,
supposedly for this purpose - and calculates it differently. If you're
not aware of this, any statistical test based on ranks will give the
wrong answer.
Also: There is a set of source data used as a standard for testing
statistical packages (known as SRTD - Standard Reference Test Data),
which contain a number of "ill-conditioned" datasets - these are
combinations of data that can be expected to expose naive or
badly-thought-out algorithms. Excel falls into just about every trap.
And finally, there is the "MOD" function. MOD(A,B) is supposed to
return A - (INT(A/B) * B) (and the help states that is what it
returns). Unfortunately, for some (non-integral) values of A and B, the
value you get from MOD isn't the same as an explicit computation. And
if you use VB, MOD(A,B) actually returns the mod of the integer parts
of A and B [i.e. INT(A) -(INT(INT(A)/INT(B))*INT(B)]. So in one
package, you can get 3 different solutions, depending on whether you
use the explicit computation, use a standard function, or use the VB
function.
Incidentally - all these problems were originally reported to MS in
1994. They all still appear in the latest version of Excel, which is
amusing when you think that standard MS FUD tactics are based around
the premise that only MS can be trusted to stay around long enough to
provide decent product support.
--
Nick Roberts tigger @ argonet.co.uk
http://www.argonet.co.uk/users/tigger/ http://www.KISS.riscos.org.uk/
http://www.bookmaker.riscos.org.uk/
Roy K Gillard
Nick Roberts <tig...@argonet.co.uk> wrote:
> In message <4cb6c9...@ukgateway.net>
> Dave Symes <d...@ukgateway.net> wrote:
> > In article <4cb69fc382st...@dsl.pipex.com>,
> > Steven Pampling <steve.p...@dsl.pipex.com> wrote:
> >
> > [Snip]
> >
> > > It's not even as though using $ as a fixed rather than relative
> > > cell reference isn't used in other spreadsheets like (dare I say
> > > it.... Excel)
> >
> > > I'll go and wash my mouth out now...
> >
> > Steve, you don't need to be so defensive...
> > MS may 'generally' produce crap applications, but Excel is by far the
> > best thing they've produced, and thinking about it honestly, it is
> > the best spreadsheet application of all those I've used.
> But that's because MS didn't write Excel - like most of the better
> products that they sell, they bought it from someone else.
> And actually, Excel isn't all that good if you really try to hammer it
> rather than use it to produce end-of-month accounts.
[snipped]
> And finally, there is the "MOD" function. MOD(A,B) is supposed to
> return A - (INT(A/B) * B) (and the help states that is what it
> returns). Unfortunately, for some (non-integral) values of A and B, the
> value you get from MOD isn't the same as an explicit computation. And
> if you use VB, MOD(A,B) actually returns the mod of the integer parts
> of A and B [i.e. INT(A) -(INT(INT(A)/INT(B))*INT(B)]. So in one
> package, you can get 3 different solutions, depending on whether you
> use the explicit computation, use a standard function, or use the VB
> function.
> Incidentally - all these problems were originally reported to MS in
> 1994. They all still appear in the latest version of Excel, which is
> amusing when you think that standard MS FUD tactics are based around
> the premise that only MS can be trusted to stay around long enough to
> provide decent product support.
There are more...
Excel has a security loophole with multi-sheet worksheets and protected
cells, which I reported to them many years ago and is still there the last
time I checked (about a year ago) plus a replicate formula fault which you
need to be aware of - it can make simple additions of multiple columns and
rows totally wrong without you noticing it! This has been known for many
years too!
I prefer Lotus 123 which is very similar but doesn't have these faults and
has a macro system for automating that is much better than Excel.
As for the problem with the 32 bit Fireworkz, has anyone contacted and
informed Gerald at Goldline? I have used Fireworkz a great deal and
copying fixed cells used to work both on RISC OS and Windows (and for
some things it is actually better than both Lotus and Excel, but it is
like Techwriter - it works differently and you have to get used to it!)
I haven't used the new version much as I have only recently purchased my
Iyonix but I've just checked it myself and it definitely is faulty.
I will send Gerald a report after this.
Regards,
Roy
--
Email: roy dot matra at virgin dot net
Nick Roberts
Steven Pampling <steve.p...@dsl.pipex.com> wrote:
> In article <c838d6b6...@bc63.argonet.co.uk>,
> Nick Roberts <tig...@argonet.co.uk> wrote:
>
> [Snip]
>
> > But that's because MS didn't write Excel - like most of the better
> > products that they sell, they bought it from someone else.
>
> > And actually, Excel isn't all that good if you really try to hammer
> > it rather than use it to produce end-of-month accounts.
>
> > It's limited to only 31 thousand rows - I have a stochastic
> > application that generates CSV files about 10K lines long for each
> > replication, and I need to run at least 20 to 30 replications...
>
> 65536 actually :-) (1024 * 64)
Hm. I was sure it was 2^31-1 rather than 2^32-1. Well, it's been a long
time, ad in either case it's not enough.
druck
> In message <4cb716802fst...@dsl.pipex.com>
> Steven Pampling <steve.p...@dsl.pipex.com> wrote:
>
> > In article <c838d6b6...@bc63.argonet.co.uk>,
> > > it rather than use it to produce end-of-month accounts.
> >
> > > It's limited to only 31 thousand rows - I have a stochastic
> > > application that generates CSV files about 10K lines long for each
> > > replication, and I need to run at least 20 to 30 replications...
> >
> > 65536 actually :-) (1024 * 64)
>
> Hm. I was sure it was 2^31-1 rather than 2^32-1. Well, it's been a long
> time, ad in either case it's not enough.
I assume its got round the 256 coloumn limit. That was the real killer when I
was trying to OLE in to the damn thing.
---druck
--
The ARM Club Free Software - http://www.armclub.org.uk/free/
The 32bit Conversions Page - http://www.quantumsoft.co.uk/druck/
Dave Higton
> In article <c838d6b6...@bc63.argonet.co.uk>,
> Nick Roberts <tig...@argonet.co.uk> wrote:
>
> > It's limited to only 31 thousand rows - I have a stochastic application
> > that generates CSV files about 10K lines long for each replication,
> > and I need to run at least 20 to 30 replications...
>
> 65536 actually :-) (1024 * 64)
> As my Unix colleague discovered when he decided to do a record list of a
> particular system and then sort it using Excel.
My, my, it has come on. When I last tried this maximum value, it was
16384. A curious value.
Dave
Steve Fryatt
<41e2c3b7...@druck.freeuk.net>:
> On 30 May 2004 Nick Roberts <tig...@argonet.co.uk> wrote:
>
> > In message <4cb716802fst...@dsl.pipex.com>
> > Steven Pampling <steve.p...@dsl.pipex.com> wrote:
[Excel row limit]
> > > 65536 actually :-) (1024 * 64)
> >
> > Hm. I was sure it was 2^31-1 rather than 2^32-1. Well, it's been a
> > long time, ad in either case it's not enough.
>
> I assume its got round the 256 coloumn limit.
I don't know about the very latest version, but Office 200-something that
we use at work still only manages column IU or IV (whichever is 256...).
> That was the real killer when I was trying to OLE in to the damn thing.
I think I've only ever hit it once (though the 65536 row limit has been a
problem a few times).
--
Steve Fryatt - Leeds, England
Dave Symes
My never ending attempts to convert all my Eureka spreadsheets to the
'subject' named application continues as and when I can find time, though
I must confess, I feel it would be easier to climb mount Everest alone and
without Oxygen...
So my next question for the FWZ32 knowledgable is this.
Imagine one spreadsheet made up of two portrait pages... if there was only
one page (A) it would occupy an A4 page and print correctly to an A$ sheet.
|----------|----------|
| | |
| | |
| A | B |
| | |
| | |
|----------|----------|
Page A is the working page, with formulas and data entry points.
Page B is a reference page.
After data entry, I want to print only page A but page B must continue to
exist as it's linked to page A (Formula wise).
How to I do that.
Thank you
Dave S
--
Harriet Bazley
Dave Symes wrote:
> |----------|----------|
> | | |
> | | |
> | A | B |
> | | |
> | | |
> |----------|----------|
>
> Page A is the working page, with formulas and data entry points.
> Page B is a reference page.
>
> After data entry, I want to print only page A but page B must continue to
> exist as it's linked to page A (Formula wise).
>
> How to I do that.
>
Page B would normally be a separate (linked) file.
Simply create the two spreadsheets, preferably save them in the same
directory (makes references shorter), and make the formulae on one page
'pull' in data from the other. Or use a set_value formula on one page
to 'push' the data onto the other. Then you can apply all the
word-processor-type formatting you like to file A, and print just that
sheet, while file B can be as unsightly as you like. It can even be a
PipeDream file!
--
Harriet Bazley == Loyaulte me lie ==
Everyone hates me because I'm paranoid.
Dave Symes
Nonononono!
If it was just a case of creating two spreadsheets and linking them I'd
have done that.
Remember, I'm converting this stuff from Eureka, and I don't want the
extra burden of needing to re-link everything.
'Tis a simple requirement so easily done in Eureka, a two page sheet,
where *I* tell it what page I want printed, it doesn't tell me what it
fancies it will print.
The above note was an example of one sheet, I have others with similar
requirements.
Compared to working with Eureka, Fireworkz is like walking through treacle.
Thanks for your suggestion anyway, appreciated
Cheers
Dave S
PS: I suppose what you are really saying is. It can't be done, in which
case some serious work needs to be done on the print engine.
D.
--
Dave Symes
After a brain bashing session, I've managed to understand a little of the
arcane ways of the FWZ print engine.
|----------|----------|
| | |
| | |
| A | B |
| | |
| | |
|----------|----------|
Page A is the working page, with formulas and data entry points.
Page B is a reference page.
I only want to print page A.
What would normally happen on printing is this.
I'd click on Print, the dialogue would open and I'd click the "Range"
button, and off we'd jolly well go, except that the "thing" would print
both page A and B.
However, since I've had a brain busting session at it I've discovered
this.
I needed to go into "Extra" and set that to "Range" because even though I
might set the first dialogue that opens to Range 1 to 1 the additional
dialogue that opens into Extra, will still be set to "All" and thus print
all the ...king pages.
I've also discovered in these *particular* circumstances. it doesn't
matter what is say on the first print dialogue (Even All pages) as long as
the Extra dialogue is set to Range.
I now understand why I can't get my head around this...
If I extended the sheet to contain another three A4 size pages (A to E) in
the print dialogue it would still show as page 1.
So A would be 1-1, B would be 1-2, C 1-3 and so on.
Then I assume, because I don't have the willpower left to try it out.
A second set of pages underneath A,B... would be 2-1 2-2 etc in the
dialogue.
Now if anyone believes in miracles, the fact that I've not only worked it
out, but understood it enough to write up, is indeed a miracle.
'Tis a shame it needed a miracle to understand something I can do in
Eureka with my hands tied behind my back.
However, I do thank Harriet and Roy for their notes.
Cheers
Dave S
PS: Now onwards to solve the next arcane FWZ problem.
D.
--
Dave Symes
|----------|----------|
| | |
| | |
| A | B |
| | |
| | |
|----------|----------|----------|---
> Then I assume, because I don't have the willpower left to try it out.
> A second set of pages underneath A,B... would be 2-1 2-2 etc in the
> dialogue.
|----------|----------|
| | |
| | |
| A | B | C ...
| | |
| | |
|----------|----------|----------|---
| | |
| | |
| F | G |
| | |
| | |
|----------|----------|----------|---
Sad person that I am I did try it out. :-(
It doesn't work as I thought, F is not 2-1 in the Extra dialogue.
Infact I'm now even more lost than I was before I started, so no miracle
happened.
The only good thing to come out of this, I can at least, by whatever
arcane magic causes it to happen, print page A all by itself from my
original query.
As for the rest, as per usual with FWZ thing I despair.
Dave S
--
Mike Clark
The process of editing links to other separate files can be accomplished
using global selects and acut and paste as well as global editing, via
"make text" and then make number". As a last resort you can export to
another editor such as Zap, carry out sophisticated search and replace
and then re-import into Fireworkz.
>
> 'Tis a simple requirement so easily done in Eureka, a two page sheet,
> where *I* tell it what page I want printed, it doesn't tell me what it
> fancies it will print.
And you can also achieve it in Fireworkz. The print dialogue box which
pops up when you select print from the menu (are you by any chance
using the <Print> key shortcut and thus not seeing the full dialogue?)
gives X and Y co-ordinates for multi-page spreadsheets. You simply enter
the range of X and Y sheets you want printed. Tiz simple and easily done
here in Fireworkz.
>
> The above note was an example of one sheet, I have others with similar
> requirements.
>
> Compared to working with Eureka, Fireworkz is like walking through
> treacle.
I must admit that I have never had a major problem with Fireworkz, but I
did graduate from View, to PipeDream, through all its incarnations up to
PipeDream4 and then on into Sheetz, and finally Fireworkz and
FireworkzPro. At each change my spreadsheets were imported and worked
with little hassle and I found the way the applications worked fairly
straightforward.
Have you thought of subscribing to the Abacus Training "GoldLine"
service? You get a CD Rom full of articles and other peoples worked
examples, hints and ideas. Also Gerald Fitton is always most helpful in
answering questions and it also helps to pay for future updates to the
software.
>
> Thanks for your suggestion anyway, appreciated Cheers Dave S
>
> PS: I suppose what you are really saying is. It can't be done, in which
> case some serious work needs to be done on the print engine.
>
> D.
>
But it can be done, at least in my version.
--
o/ \\ // |\ ,_ o Mike Clark <www.path.cam.ac.uk/~mrc7/>
<\__,\\ // __o | \ / /\, "A mountain climbing, cycling, skiing,
"> || _`\<,_ |__\ \> | immunology lecturer, antibody engineer and
` || (_)/ (_) | \corn computer user"
Dave Symes
>
[Snip]
> |----------|----------|
> | | |
> | | |
> | A | B | C ...
> | | |
> | | |
> |----------|----------|----------|---
> | | |
> | | |
> | F | G |
> | | |
> | | |
> |----------|----------|----------|---
> Sad person that I am I did try it out. :-(
> It doesn't work as I thought, F is not 2-1 in the Extra dialogue.
> Infact I'm now even more lost than I was before I started, so no miracle
> happened.
[Snip]
Sorry to be a bore...
But I'm seriously trying to get to grips with this FWZ print thing.
I'll re-designate the pages exactly as FWZ32 designates them, remembering
that each page *WILL* fit on an A4 sheet of paper.
|----------|----------|
| | |
| A | B |
| | | ...
| x1,y1 | x2,y1 |
| | |
|----------|----------|-------
| | |
| F | G |
| | |
| x1,y2 | x2,y2 |
| | |
|----------|----------|----------
In the standard co-ordinates system (0,0 being top left), that makes
perfect sense.
Say I want to print only page F (x1,y2).
Bring up the Print dialogue.
Leave that at All pages.
Extra.
Range 1-2 (x1,y2).
Doesn't work, it prints all four pages in the order, x1,y1, x2,y1, x1,y2,
x2,y2
Okay...
Print dialogue.
(I have to assume that in the first dialogue page2 means (F x1,y2)
So I set that Range From 2 to 2.
Extra.
So that's got to be 1-2
[OK]
Oh no it's not... it has now printed (A) x1,y1 (F)x1,y2
That must mean...
If there was one, God only knows, I just cannot make any sense of this.
If anyone can, please contact me before I...
1) Waste anymore trees.
2) Book myself in to St Annes (The local loony bin).
Dave S
--
Martin Wuerthner
Dave Symes <d...@ukgateway.net> wrote:
> If anyone can, please contact me before I...
>
> 1) Waste anymore trees.
Are you seriously testing print options by printing to a real printer? I
suggest installing David Pilling's SPrinter, which allows you to print to
a sprite, which is quicker and saves you the ink and the paper.
Martin
--
---------------------------------------------------------------------
Martin Wuerthner MW Software mar...@invalidMW-software.com
remove "invalid" to reply
---------------------------------------------------------------------
Dave Symes
[Snip]
> |----------|----------|
> | | |
> | A | B |
> | | | ...
> | x1,y1 | x2,y1 |
> | | |
> |----------|----------|-------
> | | |
> | F | G |
> | | |
> | x1,y2 | x2,y2 |
> | | |
> |----------|----------|----------
[Snip]
Well boys and girls...
I booked myself into the nut-house for a days treatment and electroshock
therapy.
I've now been released, and my hair is even curlier than is was before I
went in... ;-)
I have, with a new brain, managed to see through a bit of the fog of the
FWZ printing process.
It's all down to a period. (full stop).
So in the "Extra" dialogue it works like this... Well the half a tree I've
used seems to agree...
From the diagram above.
Page A is 1.1
Page B is 2.1
Page F is 1.2
Page G is 2.2
It's the poxy hyphen - there by default in the numbers that's been causing
my confusion.
To print F and G it seems 1.2 - 2.2 is the entry in Extra.
Now the above maybe obvious to power users of FWZ, but I'm used to working
with spreadsheets that have a somewhat different (I consider better)method.
So, as far as this particular problem is concerned. I'm sorted.
Cheers and thanks for the couple of folks who offered their thoughts.
Dave S
PS: But as sure as the Sun rises each morning, I'll be back soon with
another problem.
--
Dave Symes
Martin Wuerthner <mar...@invalidMW-software.com.invalid> wrote:
> In message <4cc40d...@ukgateway.net>
> Dave Symes <d...@ukgateway.net> wrote:
> > If anyone can, please contact me before I...
> >
> > 1) Waste anymore trees.
> Are you seriously testing print options by printing to a real printer? I
> suggest installing David Pilling's SPrinter, which allows you to print to
> a sprite, which is quicker and saves you the ink and the paper.
> Martin
Yes and No... Tongue in cheek really.
SPrinter is installed, but eventually you have to spill the toner...
Dave S
--
Dave Symes
Mike Clark <mr...@cam.ac.uk> wrote:
> The process of editing links to other separate files can be accomplished
> using global selects and acut and paste as well as global editing, via
> "make text" and then make number". As a last resort you can export to
> another editor such as Zap, carry out sophisticated search and replace
> and then re-import into Fireworkz.
Possibly you can Mike, but remember I'm converting these from Eureka, and
believe me there are multiple problems of incompatibility to overcome.
The problems of incompatibility lay mostly at the door of FWz.
I can export a file out of Eureka, and import it into Excel without
problems, formatting remains true, 999% of formulas are okay.
1) A Eureka page of 12 point rows with 10 point Homerton.medium text, that
will print perfectly on an A4 portrait sheet. When converted to FWZ will
not fit, it's generally two Rows too deep.
If the sheet is already full (top to bottom), it's a problem getting it to
fit as I obviously can't reduce either the row size or text size which is
small enough as it is.
2) Eureka doesn't have any facility that I can find to change formulas to
text... So...
(a) If I do a convert between Eur (by whatever I use) and FWz the formulas
get stripped.
(b) If I try to do a global Search/Replace in Eur, changing the errant
part of the Eur formula to match that of FWz, Eur throws a serious wobbly,
because the formula syntax is now wrong... Freezy Eureka Mr D. :-(
Why the Eff there isn't a global formula syntax for all spreadsheets...
Well actually there is, if you use the Excel method/type sheet syntax.
Where was I?
Oh yes...
Related to point 1)
Because I have to hack out two rows to get the sheet to fit, viewing the
Eur sheet on screen to look at the formulas as I manually reconstruct them
in FWz, often is no good because all the relative position have moved.
For example. A link that was say ...f28" on the Eur will now be ...f26 on
the FWz sheet.
I have worked out a way around this, but it involves having a printout so
that I know what the answer from the other sheet, for a particular cell
should be.
My biggy problem is that neither FWz or Eureka are RO *Global* clipboard
compliant. this means I can't copy out of Eureka and paste directly into
FWz.
As a great believer in the Global clipboard, that pees me off to start
with.
Yes they each have a clipboard that works within the application, so you
can copy between Eureka sheets and other Eureka sheets, as you can copy
from a FWz sheets to other FWz sheets, but these clipboards are not
Global, as they'll not function outside of each individual application.
I'm on RO Select which is very Global clipboard active, and to give a
perhaps silly but useful illustration... In a Draw window, I can hilight
something, even an object, do a Ctrl-C then go to a Zap window and do
Ctrl-V to paste it in.
That's a Global clipboard.
At this point... I've rather lost where I was going, so I'll close.
Cheers
Dave S
--
Dave Symes
Barry Allen (news) <evan...@onetel.net.uk> wrote:
> In article <4cc50f...@ukgateway.net>, Dave Symes
> <d...@ukgateway.net> wrote:
> > 1) A Eureka page of 12 point rows with 10 point Homerton.medium text,
> > that will print perfectly on an A4 portrait sheet. When converted to
> > FWZ will not fit, it's generally two Rows too deep. If the sheet is
> > already full (top to bottom), it's a problem getting it to fit as I
> > obviously can't reduce either the row size or text size which is
> > small enough as it is.
> Just a possibility bearing in mind that FWZ can function as a word
> processor as well. Do you have header and foot margins set in the FWZ
> document?
> You probably know this but I'll say it anyway. :o))
> You can usually tell by making FWZ show a 'full' display. If they are
> set then go to Page --> Pages -->Change and untick header and footer.
Thanks for the thought.
Yes I was aware, but it was some while ago that I set up the page sizes,
so it was worth a re-look.
I've got as much page as it's possible to print out of my Laser on an A4
sheet... There's about half a mm spare each top and bottom before the
print image starts to get chopped, so I can't stretch it anymore.
But thanks for the prompt.
Cheers
Dave S
--
Kevin Wells
Dave Symes <d...@ukgateway.net> wrote:
Have you tried the Print Scale?
On the menu slide of Page then click on Scale then Fit one page or Fit
one page X.
--
Kev Wells http://kevsoft.topcities.com
Swinging Arm and Touring Motorcycle Club http://saat.topcities.com
Of Motorway Fuel Prices http://www.mway.0catch.com
There are only so many times I can say sorry and still mean it.
Dave Symes
Kevin Wells <kev....@dsl.pipex.com> wrote:
> In message <4cc51a...@ukgateway.net>
> Dave Symes <d...@ukgateway.net> wrote:
[Snip]
> > I've got as much page as it's possible to print out of my Laser on an
> > A4 sheet... There's about half a mm spare each top and bottom before
> > the print image starts to get chopped, so I can't stretch it anymore.
> >
> > But thanks for the prompt.
> >
> > Cheers
> > Dave S
> >
> Have you tried the Print Scale?
> On the menu slide of Page then click on Scale then Fit one page or Fit
> one page X.
Print Scale on FWz is an abortion of infinite proportions, I cannot find
suitable clean word to illuminate my disgust...
Let me explain.
In Eureka if I ask it to print a page at say 75% it will print the page
I've asked for, and only that page at 75%. so if you like I'm left with
25% of the page blank.
Set the same thing in FWz and it sucks in part of the next page to fill
the difference, so on my sheet of A4 I get page one at 75% and a 25% bit
of page 2.
On the example diagram within my previous posts, assuming I wanted to
print page A 1.1 at 75% it would (does) drag in part of the page to the
left 2.1 and the page below it 1.2.
Unless I recreate all my pages with new sizes to accomodate this scale
action, I can't see how it would help.
But thanks for your input, appreciated.
Cheers
Dave S
--
Dave Symes
> <d...@ukgateway.net> wrote:
> > In article <4cc5188d6...@onetel.net.uk>, Barry Allen (news)
> > <evan...@onetel.net.uk> wrote:
> > > In article <4cc50f...@ukgateway.net>, Dave Symes
> > > <d...@ukgateway.net> wrote:
> > > > 1) A Eureka page of 12 point rows with 10 point Homerton.medium
> > > > text, that will print perfectly on an A4 portrait sheet. When
> > > > converted to FWZ will not fit, it's generally two Rows too deep.
> > > > If the sheet is already full (top to bottom), it's a problem
> > > > getting it to fit as I obviously can't reduce either the row size
> > > > or text size which is small enough as it is.
> > > Just a possibility bearing in mind that FWZ can function as a word
> > > processor as well. Do you have header and foot margins set in the
> > > FWZ document?
> Another few thoughts. :o)) Have you had a play with the 'row height'
> and 'paragraph spacing' looking at 'Above paragraph' and 'Below
> paragraph' spacing. Also I think line spacing can be tweaked. Messing
> about with the Vertical justification can sometimes help make text more
> readable with narrow row spacing.
Interesting thought, and Gerald did mention this in the past, and we did
try it, unfortunately I'm already working at a limit of 10 point Homerton
on 12 point Rows, anything but very, very minor adjustements, start to
lose the ascenders and descenders of the text.
Interesting though, but T shirts and fat ladies I'm afraid...
But that aside, I do appreciate your input.
Thanks
Dave S
PS: I'm resigned to removing the two rows in the transfer from Eur to FWz
and most of the stuff I've so far transferred has already been cut down.
--