2.00.05 (10 Jun 2016)

Apply specified styles to empty cells when importing Microsoft Excel worksheets.

Use cell alignment and background colour information when importing Microsoft Excel worksheets.

2.00.04 (06 Jun 2016)

Fix for importing compound documents with non-standard headers.

Fix for importing Microsoft Excel worksheets with self-referential XF records.

2.00.03 (22 Nov 2015)

Fix for LOOKUP() and MATCH() spreadsheet functions with horizontal arrays. This was broken in 1.34/11.

Fix for full release history URL with new CMS.

Windows: Fixed the spelling of the new spreadsheet functions PERCENTRANK.INC() and PERCENTRANK.EXC() in the status line help.

2.00.02 (11 Nov 2015)

Fix for inline sequence size change perturbing style applications.

This is a critical backwards compatibility fix for all users.

Any documents created or modified in 2.00.00 or 2.00.01 that contain text with style/effect applications to the right of inline sequences (e.g. Insert date, Tab, Unicode) may need to have bits of style edited off with the region editor or reapplied.

RISC OS: No longer offers Microsoft Excel as an export format (non-Pro).

2.00.01 (05 Nov 2015)

Fixed another error in null event handling for row formatting.

RISC OS: Fix for styles in text when exported as Draw file.

2.00 (20 Oct 2015)

Fireworkz Pro

Microsoft Excel export (as binary file format) module provided. This currently supports export in BIFF5 format, wrapped as a compound document as per Microsoft Excel 97.

The Fireworkz & (AND), ¦ (OR) and ! (NOT) logical operators are translated to the equivalent Microsoft Excel functions when exporting as BIFF.

HTML help is supplied fully expanded within !Fireworkz rather than as a ZIP archive, so SparkFS is no longer needed at run-time. Note that this requires you to install Fireworkz Pro on a long filenames capable filing system.

Correct Fireworkz Pro icon used in !SpritesR5.

Pinboard icon in !SpritesR5 updated for RISC OS 5 style.

Pinboard icon in !Sprites22 and !SpritesR4 updated for RISC OS 4 style.

Dynamic area (if used) is labelled as Fireworkz Pro workspace.

Value list box popup menu width dynamically sized using desktop font metrics.

New spreadsheet functions

A large number of spreadsheet functions have been implemented in Fireworkz to assist Microsoft Excel file loading, most of which are useful additions in any case.

For details about any of the newly added spreadsheet functions, please see see Printed documentation Addenda and Errata.

Wherever possible, these new spreadsheet function names are compatible with the Open Document Format for Office Applications (OpenDocument) 1.2 standard (ODF) and Microsoft Excel 2013 to allow for easy future disambiguation. Loading formulae from (and saving them to) Excel BIFF files translates from (and to) the appropriate BIFF function number automatically. Note that some of the newest functions do not have BIFF function number equivalents.

A number of these new functions require underscores in Fireworkz to disambiguate them from cell references (e.g. DAYS_360(), SUM_X2MY2()).

M_UNIT() has an underscore for consistency with other Fireworkz matrix functions.

Compatibility spreadsheet functions added:

ODF.BETADIST(),
ODF.FV(),
ODF.IMABS(),
ODF.IMAGINARY(),
ODF.IMARGUMENT(),
ODF.IMCONJUGATE(),
ODF.IMCOS(),
ODF.IMDIV(),
ODF.IMEXP(),
ODF.IMLN(),
ODF.IMLOG10(),
ODF.IMLOG2(),
ODF.IMPOWER(),
ODF.IMPRODUCT(),
ODF.IMREAL(),
ODF.IMSIN(),
ODF.IMSQRT(),
ODF.IMSUB(),
ODF.IMSUM(),
ODF.INDEX(),
ODF.INT(),
ODF.IRR(),
ODF.LOG10(),
ODF.PMT(),
ODF.TDIST(),
ODF.TYPE().

Database spreadsheet function added:

DPRODUCT().

Date spreadsheet function added:

DAYS_360().

Engineering spreadsheet functions added:

BESSELI(),
BESSELJ(),
BESSELK(),
BESSELY(),
C_COMPLEX() (as ODF COMPLEX),
C_CONJUGATE() (as ODF IMCONJUGATE),
C_IMAGINARY() (as ODF IMAGINARY),
C_REAL() (as ODF IMREAL),
C_ROUND(),
C_SQRT() (as ODF IMSQRT),
DELTA(),
ERF(),
ERFC(),
GESTEP().

Financial spreadsheet functions added:

DB(),
FVSCHEDULE().

Logical spreadsheet functions added:

AND(),
FALSE,
OR(),
NOT(),
TRUE,
XOR().

Lookup spreadsheet function added:

ADDRESS().

Mathematical spreadsheet functions added:

CEILING(),
EVEN(),
FACTDOUBLE(),
FLOOR(),
MROUND(),
MULTINOMIAL(),
ODD(),
PRODUCT(),
POWER(),
QUOTIENT(),
RANDBETWEEN(),
ROUNDDOWN(),
ROUNDUP(),
SERIESSUM(),
SUMPRODUCT(),
SUMSQ(),
SUM_X2MY2(),
SUM_X2PY2(),
SUM_XMY2(),
TRUNC().

Matrix spreadsheet function added:

M_UNIT().

Miscellaneous spreadsheet functions:

COUNTBLANK(),
ISBLANK(),
ISERR(),
ISERROR(),
ISEVEN(),
ISLOGICAL(),
ISNA(),
ISNONTEXT(),
ISNUMBER(),
ISODD(),
ISREF(),
ISTEXT().

Statistical spreadsheet functions added:

AVEDEV(),
AVERAGEA(),
BETA.DIST(),
BINOM.DIST(),
BINOM.DIST.RANGE(),
BINOM.INV(),
CHISQ.DIST(),
CHISQ.DIST.RT(),
CHISQ.INV(),
CHISQ.INV.RT(),
CHISQ.TEST(),
COMBINA(),
CONFIDENCE.NORM(),
CONFIDENCE.T(),
COVARIANCE.P(),
COVARIANCE.S(),
CORREL(),
DEVSQ(),
EXPON.DIST(),
F.DIST(),
F.DIST.RT(),
F.INV(),
F.INV.RT(),
F.TEST(),
FISHER(),
FISHERINV(),
FORECAST(),
FREQUENCY(),
GAMMA(),
GAMMA.DIST(),
GAMMA.INV(),
HYPGEOM.DIST(),
INTERCEPT(),
KURT(),
LARGE(),
LOGNORM.DIST(),
LOGNORM.INV(),
MAXA(),
MINA(),
MODE.SNGL(),
NEGBINOM.DIST(),
NORM.DIST(),
NORM.INV(),
NORM.S.DIST(),
NORM.S.INV(),
PEARSON(),
PERCENTILE.EXC(),
PERCENTILE.INC(),
PERCENTRANK.EXC(),
PERCENTRANK.INC(),
PHI(),
POISSON.DIST(),
PROB(),
QUARTILE.EXC(),
QUARTILE.INC(),
RANK.EQ(),
RSQ(),
SKEW(),
SKEW.P(),
SLOPE(),
SMALL(),
STANDARDIZE(),
STDEVA(),
STDEVSPA(),
STEYX(),
T.DIST(),
T.DIST.2T(),
T.DIST.RT(),
T.INV(),
T.INV.2T(),
T.TEST(),
TRIMMEAN(),
VARA(),
VARPA(),
WEIBULL.DIST(),
Z.TEST().

String spreadsheet functions added:

CLEAN(),
DOLLAR(),
FIXED(),
N(),
SUBSTITUTE(),
T().

Implementation notes

FORECAST(), INTERCEPT(), PEARSON(), RSQ(), SLOPE(), STEYX() are implemented using a two-pass approach, first independently computing the mean values, then computing values (such as the sum of the squares, products) using the difference between each value and the corresponding mean value. This approach helps avoid many round-off errors and is also employed by Microsoft Excel 2003 and later.

AVEDEV(), COVARIANCE.P(), COVARIANCE.S(), CORREL(), KURT(), SKEW(), SKEW.P() are also calculated using this two-pass approach.

DEVSQ() is calculated using a one-pass 'calculator' approach using sum-of-squares and square-of-sums as with VAR() etc.

Spreadsheet enhancements

For details about any of the modified spreadsheet functions, please see see Printed Documentation Addenda and Errata.

AVG(), MAX() and MIN() spreadsheet functions may now be applied to ranges of date / time values.

BIN() spreadsheet function has always taken an arbitrary dimensioned array or range of data as its first parameter. Previously only the first column of this data would have been binned; now all the supplied data is binned.

CHAR() spreadsheet function no longer allows Fireworkz' internal inline escape character (ASCII 21) to be inserted into a string (would subsequently crash the te...