Evan Clark
unread,Apr 1, 2020, 2:51:01 PM4/1/20Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to colton-softw...@googlegroups.com
A bug seems to have crept into Fireworkz 2.24 involving the
if(condition,then,else) function.
A simple test sheet:
a b
|1| 10| |
|2| 20|if(a2<>0,a2-a1,"")|
|3| |if(a3<>0,a3-a2,"")|
Cell b2 displays 10. Cell b3 displays blank.
Cell a3 must be blank to invoke the bug.
Save, then try to reload, and Fireworkz 2.24 (22 March 2020) crashes,
sometimes freezing the machine. Fireworkz 2.22.01 (24 Dec 2019) is OK.
There's a difference in the relevant lines from the saved files:
Version:2.22.01;24 Dec 2019
{StartOfData}
{S:S;C;0;0;10;;General}
{S:S;C;0;1;20;;General}
{S:S;F;1;1;10;if(a2<>0,a2-a1,"")}
{S:S;F;1;2;"";if(a3<>0,a3-a2,"")}
Version:2.24;22 Mar 2020
{StartOfData}
{S:S;C;0;0;10;;General}
{S:S;C;0;1;20;;General}
{S:S;F;1;1;10;if(a2<>0,a2-a1,"")}
{S:S;F;1;2;";if(a3<>0,a3-a2,"")}
^
Note the missing quote character.
This is on an ARMX6, RISC OS 5.25 (24-Aug-18).
Can anyone else reproduce this?
Evan.