PipeDream 4.62.02 (05 Mar 2023)

Fix redraw of title bar when it is updated (very old bug!).

Multiple instances of PipeDream 4 can now be launched.

Document file buffering size now determined at run-time. This is:

• 4KB for systems with less than 4MB of memory,
• 16KB for systems up to 16MB memory;
• 32KB for 'modern' systems.

WimpSlot required at startup reduced further (for 4KB page size systems).

ROOL DDE 31b build environment used.

PipeDream 4.62.01 (30 Dec 2022)

Actually supply HelpMess with this one (!RunImage is unchanged; still announces as 4.62)

PipeDream 4.62 (28 Dec 2022)

Fix for loading chart UI sprites on non-RISC OS 5 systems.

Fix for rapidly flashing action buttons in dialogue boxes on RISC OS 3.1.

WimpSlot required at startup reduced - in total it is about 44 KiB less compared to 4.61.

Chart UI templates are only loaded when needed (saves about 20 KiB).

Interactive Help messages are only loaded when needed (saves about 8 KiB).

List of HTML colour names used by @C@ is now loaded as needed. The file ColMapHTML may be found in Resources.RISC_OS.Neutral. You could modify this file to add custom colours but beware that any changes to the one supplied in the application directory may not survive updates! Instead, it would be better to create a directory called RISC_OS in Boot:Choices.PipeDream and put the modified file in there.

Lotus 1-2-3 converter detection is performed on each attempted load of Lotus files rather than just once. Allows user to not have to restart PipeDream 4 if converter had not been 'seen', or has been moved due to reinstallation.

Window title bars no longer contain 'PipeDream: ' prefix - more consistent with current usage.

ROOL DDE 31a build environment used. This allows PipeDream 4 to directly call SWIs in many cases. Yay.

PipeDream 4.61 (12 Dec 2022)

Engineering format for the TEXT() spreadsheet function updated to match Resolution 3 of the 27th CGPM (2022) - 'On the extension of the range of SI prefixes'. This adds the following to the list of SI prefixes to be used for multiples and sub-multiples of units:

• Q : 10^30
• R : 10^27
• r : 10^-27
• q : 10^-30

Prior to this release, PipeDream used prefixes that had been proposed by Jeff K. Aronson in the 1990s for these multiples and sub-multiples, with the prefixes W, X, x, w corresponding to the new prefixes Q, R, r, q.

Several redundant RISC_OSLib functions removed. some others replaced with inline ASM blocks.

Interactive Help messages more consistent with RISC OS User and Style Guides.

'PipeDream 4' used more throughout to discriminate vs PipeDream 3.

4.60.03 (23 Oct 2022)

Cosmetic fixes for menu and toolbar icons running on RISC OS 3.1.

HTML documentation now encoded as UTF-8.

4.57.01 (21 Mar 2020)

!RunImage is squeezed for faster loading from slow devices.

Improved packaging giving homepage and indicating compatibility.

4.57 (20 Dec 2019)

Mathematical spreadsheet functions added: BASE(), DECIMAL().

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

Formatting a very large number with a small radix using the TEXT() spreadsheet function no longer overflows the temporary buffer causing subsequent error.

Checks for integer overflow when adding to/subtracting from date/time components.

Checks for attempt to divide by a denormalised (i.e. very very small) number; this would previously have given FP error rather than Divide by zero error.

PipeDream accepts dates entered in ISO 8601 date format (or as dd/mm/yy) when either typed or imported from CSV.

Note: PipeDream allows single digits in dates when checking against the ISO 8601 date format, where two digits are strictly required in the month and day components, for compatibility with some CSV files from odd sources (banking data).

PipeDream chart files now use a newly allocated file type, &A77 (PDChart). This can help other applications identify PipeDream chart files as trivially renderable using the Drawfile module. A Draw tag from the newly allocated Colton Software vendor range is used to identify the block of PipeDream instructions used to generate the chart. Chart files are now padded at the end to a multiple of four bytes with the digit zero rather than space.

Note: PipeDream will continue to attempt to load previously saved chart files of file type &DDE (PDream) as before, although they will be immediately re-saved with the new file type and use the new Draw tag unless Choices – 'New chart files' is unticked.

Some missing spreadsheet function documentation added.

ROOL DDE 29a build environment used.

4.56.02 (19 Mar 2019)

Fix for CHOOSE() spreadsheet function when used with range or array parameters. This had been broken since 4.52/04.

ROOL DDE 28 build environment used.

4.56.01 (21 Dec 2018)

Define Function Key compatibility issue with old files fixed.

4.56 (17 Dec 2018)

PipeDream menus and keyboard shortcuts are now a little more Style Guide compliant. Users who prefer the previous behaviour may wish to head to the iconbar menu and turn on Classic menus and Save Choices.

Fixed chart text object editing bug.

Fixed chart loading bug introduced in 4.50/45.

Fixed spreadsheet range recognition code so that the end cell reference of a range of cells is correctly updated when it is used to define a name. This had been broken since 4.55.00.

Updated spreadsheet cell reference recognition code to accept a leading percent to indicate 'Bad reference'. This is needed as saved documents with such bad references (e.g. when the referenced cell has been deleted) would otherwise fail to load correctly.

Fixed subtraction code: subtracting extremely large numbers of individually small integers could have eventually given an undetected integer overflow.

Fixed execution of command files from the Do command file dialogue box.

Speed-up for M_DETERM() and M_INVERSE() for large sparse matrices.

DDB() spreadsheet function accepts an extra parameter, factor (optional). The default is 2.0.

INDEX() spreadsheet function will now accept zero for the column and/or row number.

If the column number is zero, the whole of the specified row(s) is returned.

If the row number is zero, the whole of the specified column(s) is returned.

INDEX() spreadsheet function will now accept zero for the optional column and/or row size.

If the column size is zero, the rest of the specified row(s) beginning at the given column number is returned.

If the row size is zero, the whole of the specified column(s) beginning at the given row number is returned.

SERIESSUM() spreadsheet function has been backported from Fireworkz. An example of its use is given in the PipeDream-Examples package.

Text @-field handling enhanced to allow colour and font change information contained in referenced cells to be inserted into the referencing cell's output when @cell_reference@ is used and a global font is in use.

Text @-field handling enhanced to allow use of HTML format colour strings: @C:#rrggbb@, @C:rgb(r,g,b)@, @C:html_colour_name@.

Text @-field handling enhanced to allow use of format strings with date, time and page number fields: @D:date_format@, @N:time_format@ and @P:number_format@. @D@, @N@ and @P@ without format strings give the same results as before. The format strings are those used by the TEXT() spreadsheet function.

Examples:
@D:yyyy-mm-dd@ displays the current date in ISO 8601 format,
@T:hh:mm@ displays the current time without seconds,
@P:r#@ displays page numbers as lower-case Roman numerals.

Note that both current date and time components are passed to @D@ and @N@ to enable a composite date with time string to be displayed.
Example:
@D:yyyy-mm-dd\Thh:mm:ss@ displays an ISO 8601 date/time.

Typing a text-@ character or clicking on a highlight toolbar button (e.g. Bold) enters the data as text when the caret is in an empty cell regardless of the New cell format option.

Insert colour command (\EITC) added to the Edit menu. This command allows the user to choose a colour using the ColourPicker module and inserts the corresponding @C:r,g,b@ sequence.

Insert date (\EITD), time (\EITN) and page number (\EITP) commands added to the Edit menu. These commands allow the user to choose an appropriate format string and insert the corresponding text-@ sequence with the chosen format string.

Chart – Fill Style dialogue box now works in &gt 16 colour modes and centres Markers / Pictures in the icon.

Insert option on Choices menu replaced by Overtype option for clarity.

Replicate command restored to short menus.

Replicate Left (\BRL) and Replicate Up (\BRU) commands implemented and added to long menus. These may also be accessed by clicking Adjust on the Replicate Right and Replicate Down buttons respectively.

Fixed running a PipeDream command file when PipeDream is not running. This had been broken since 4.52.00.

When running on a version of RISC OS where clicking in the Filer causes the Filer to acquire the input focus, double-clicking a PipeDream Command file in the Filer will execute that command file in the context of the document that had the input focus before it was acquired by the Filer.

Record command file will once again create command files in the same directory as the current document. If the current document has not been saved, it will create the command file in <Choices$Write>.PipeDream.CmdFiles.

Do command file will now list any command files found in the same directory as the current document (and in any subdirectory CmdFiles thereof) in addition to those found on the path.

Dump dictionary and Merge dictionary processing enormously speeded up on newer systems.

Colour handling has been improved to allow selection of arbitrary colours for each PipeDream display element using the ColourPicker module. Previously such selection was restricted to the Window Manager 16-colour palette. Where a newly selected colour exactly matches that in the Window Manager 16-colour palette, its palette index is displayed, otherwise the corresponding HTML colour code #RRGGBB is displayed.

The PipeDream colour constructs have been extended to store new colours and now take the extended form: %OP%C<c>,<index>{,0xBBGGRR00} (the hexadecimal colour parameter is omitted for exactly matching colours).

English date format relabelled as D.M.Y in the Options dialogue box and referred to as British-style in documentation. American date format similarly relabelled as M.D.Y

The Load file dialogue box is now only created as a RISC OS sub-menu if it is invoked by traversing the RISC OS menu structure using the arrow at the right of the Load menu option. If the Load file dialogue box is invoked by clicking on the Load menu option, from a command sequence (^FL) or a user-defined mapped keystroke, it is opened as a standalone dialogue box. This allows the user to then find a directory viewer containing files to be loaded without the dialogue box collapsing. A file may then be dragged into the Load file dialogue box, filling the file name field, and options relevant to loading that file selected. To cancel the dialogue box, press ESCAPE or click the Cancel button. Note that no other PipeDream dialogue boxes can be invoked whilst the Load dialogue box is being shown as a standalone dialogue box.

Save / Discard / Cancel and Yes / No dialogue boxes have been cosmetically improved by splitting the message that was output into a (possibly quite long) statement followed by a shorter discrete question.

A Web button (and a PipeDream logo) has been added to the About this program dialogue box. This uses the PipeDream$Web variable set by !Run.

Window Manager flags bit is set to save and restore FP state over SWI Wimp_Poll and Wimp_PollIdle calls rather than doing it manually.

The PipeDream application and file icons have been smartened up to better match the actual PipeDream 4 logo artwork.

180 DPI application and file icons supplied in RISC OS 5 style.

Toolbar icons appearance improved and 180 DPI toolbar icons supplied; some toolbar icons are now derived from the public domain Tango Icon Library.

Toolbar is slightly less tall, leaving some more room for data.

Mark document / Clear selection toolbar button added, replacing the box to the left of the column headings.

Using one of the highlight toolbar buttons with a marked block now redraws correctly. Additionally, the corresponding option is set in the Remove highlights dialogue box in case you wish to remove the highlights thus set.

Clicking Adjust on the Left justify toolbar button will restore the default justification on the marked block (or current cell).

Clicking Adjust on the Decimal places toolbar button will restore the default format on the marked block (or current cell).

Clicking Adjust on toolbar buttons with no alternate function defined will no longer execute the standard function used when Select is clicked.

Formula Editing Window buttons more consistent with toolbar buttons.

Copy / Cut / Paste toolbar buttons added to Formula Editing Window.

Clicking Adjust on the Tick button transfers the formula line contents to the Formula Editing Window.

Multi-line Formula Editing Window and Chart text editing window only use fonts if a Desktop font is in use.

Unintentional zero page access when loading blank file name fixed.

Top level Help menu entry added.

Interactive Help messages are now given for the Formula Editing Window buttons.

Interactive Help messages are now more consistent with the RISC OS Style Guide recommendations and use Help tokens where possible.

Writeable icons in Spell – Create / Open / Pack user dictionary dialogue boxes use RISC OS Style Guide compliant app...