Fireworkz 2.24 released

[Stuart Swales]

Bit more functionality here.

2.24 (22 Mar 2020)

Date spreadsheet functions added:

DAYS(),
ISOWEEKNUM().

Mathematical spreadsheet functions added:

BASE(),
DECIMAL(),
GCD(),
LCM().

Engineering spreadsheet functions added:

BIN2DEC(),
BIN2HEX(),
BIN2OCT(),
BITAND(),
BITLSHIFT(),
BITOR(),
BITRSHIFT(),
BITXOR(),
DEC2BIN(),
DEC2HEX(),
DEC2OCT(),
HEX2BIN(),
HEX2DEC(),
HEX2OCT(),
OCT2BIN(),
OCT2DEC(),
OCT2HEX().

The C_COMPLEX() spreadsheet function may take a single parameter as the real part of the resulting complex number with imaginary part zero.

The DAYNAME() and WEEKDAY() spreadsheet functions may now take a mode parameter to control the calculation.

The DDB() spreadsheet function may now use a non-integer period for calculation.

The TRIM() and VALUE() spreadsheet functions can accept text strings longer than 200 characters as input.

RISC OS: !RunImage is squeezed for faster loading from slow devices.

RISC OS: Improved packaging giving homepage and indicating compatibility.

Yet to appear in !Packman, but give it time...

Or head over to https://www.croftnuisk.co.uk/coltsoft/fireworkz/

[Michael]

Thanks for the new version of Fireworks.

However, I have found a VERY SERIOUS bug in the new release in the WEEKDAY function.

Entering WEEKDAY(25.4.2020) gives 6, whereas it should give 7. The days are being numbered from 0-6, with Sunday being 0. The only way to get the days of the week from 1-7 starting on Sunday is to give 16 as the mode parameter, but this is NOT the behaviour of a mode 16 as described in the manual!

DAYNAME works fine.

This change has broken key software of mine.

--
You received this message because you are subscribed to the Google Groups "Colton Software Fireworkz" group.
To unsubscribe from this group and stop receiving emails from it, send an email to colton-software-fi...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/colton-software-fireworkz/7b1cbc32-5d1c-4937-a008-9d86914cde8a%40googlegroups.com.

--

Michael
myb...@gmail.com

[David Feugey]

Hi Stuart.

Fireworkz is perfect for old windows systems.

Unfortunately, it's compiled with modern processor options, and crashes under XP with a 586 class processor.

Probably MMX, SSE or Pentium options. Tests are done with a Vortex processor @ 933 MHz.

Would it be possible to make some tests of compilation with different options?

Thanks!

[Stuart Swales]

Indeed it is David - SSE option is used.

I'll spin you a build with no enhanced instructions. I don't think that they'd be helping much!

Stuart

[David Feugey]

Cool.

You can use the mail temp...@riscos.fr

I plan to make some videos around Fireworkz (and probably Pipedream, that will have the same problem) on the Win32 part of the ROSFR channel :)

So that will help a lot!

David

[Stuart Swales]

As much as people have wanted one, there hasn't been a (released) PC PipeDream since the '80s! We did do some of the PipeDream 3 development on a PC but sadly never got round to a proper build of that.

Stuart

On Saturday, 11 April 2020 18:47:03 UTC+1, David Feugey wrote:

Cool.

[David Feugey]

No problem.

To be honest, I'm still trying to understand what Pipedream can do Fireworkz would not :)