[Fireworkz Pro 2.10]- absolute reference behaviour

Hi all

I am trying to use fireworkz spreadsheet (version Pro 2.10) and I am a little be surprised on how absolute references are handled.

Indeed, when I copy a cell with a formula including absolute reference (with the $ sign), the copy completly ignore the absolute dimension.
Eg: if a copy the formula
vlookup(c2,[MappingCat]$a$1$b$66,2) in the cell below, it becomes vlookup(c3,[MappingCat]$a$2$b$67,2)… which is absolutely not the expected behaviour.

Thank you for your help.

François

This is going to sound really weird!

The behaviour described has been around a long time, FireworkzPro 1.32/04 (15 Jul 2002), shows the same.

I found two articles in the GoldLine CD which appear to explain the issue. It is due to the ‘intelligent’ way Fireworkz handles Copy and Paste. The absolute, $, reference has no effect at all during Copy and Paste, though the current Manual would seem to indicate otherwise. Obviously then the answer is to force the cell containing the formula to be copied to Text and copy and paste that, then force the cells back to Number.

The other solution is to assign a NAME to the function and that does copy with absolute references.

GoldLine.GOLD.ZL.2000.ZL0003/ZIP.CopyPaste1.!ReadMe
GoldLine.GOLD.ZL.2000.ZL0012/ZIP.CopyPaste2.!ReadMe

This is not a wind up!

P.S. This might be better on the Fireworkz mailing list.

Not sure about Pro but I use the free versions (2.21 is the latest) for RISC OS and Windows and both behave as expected with absolute references. I find the Fireworkz forum https://groups.google.com/forum/#!forum/colton-software-fireworkz very helpful. Stuart Swales who maintains Fireworkz is a regular contributor and if it is a bug he will sort it out for you.

Hi Norman

This is weird, because I tested also with Fireworkz 2.21 (04 May 2017) and I have the same issue.

Cell a1 : 123
Cell b1 : $a$1 —> 123

Copy cell b1 to cell b2
Cell b2 : $a$2 —> WRONG!

Could anyone reproduce this unexpected behaviour?

Or maybe I do not copy it the right way (^C then ^V)

Thank you

François

YES INDEED, I was not using the right way to copy cells…
In order to keep absolute references, you have to use
Main Menu → Edit → Fill cells → … and not copy/paste.

I found it myself… playing around with Fireworkz.

Hope it helps.

François

Hi Francois
Yes you are right, copy and paste does not work correctly. When I tried it, I used the fill down button which does work. Glad that you got that sorted.