Spread32 Changelog

What's new in Spread32 3.19

Apr 26, 2024
  • Fixed a bug that prevented entry of extended characters, such as the Euro symbol.
  • Fixed a bug with saving formatted text in drawing objects.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.18 (Apr 10, 2024)

  • Bug fixes and enhancements.
  • Added support for mixed fonts (e.g. superscript and subscript) in cells, objects and charts.
  • Improved VBA Excel Object Model Support (see here)
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.17 (Nov 5, 2023)

  • Bug fixes and enhancements.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.16 (Oct 5, 2023)

  • Bug fixes and enhancements.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.14 (Jun 11, 2023)

  • Bug fixes and enhancements.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.13 (Dec 22, 2022)

  • Bug fixes and enhancements.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.12 (Aug 3, 2022)

  • Bug fixes and enhancements.
  • Added support for VBA.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.11 (Jun 8, 2021)

  • Bug fixes.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.10 (May 3, 2021)

  • Bug fixes and enhancements.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.09 (Apr 9, 2021)

  • Bug fixes and enhancements.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.07 (Dec 20, 2020)

  • Bug fixes and enhancements.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.06 (Dec 1, 2020)

  • Bug fixes. Added save-as-pdf option, basic for now but will be improved in future versions.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.05 (Nov 4, 2020)

  • Fixed a bug that caused some xlsx files to be corrupted when saved.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.04 (Oct 22, 2020)

  • Bug fixes, enhancements, improved chart formatting, support for OpenDocument files.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 3.03 (Oct 12, 2020)

  • Bug fixes, increased compatibility with xlsx files.
  • Shareware Version published here.
  • Registered Version will be e-mailed to existing registered users, and is available for purchase on request.

New in Spread32 2.05 (Jan 11, 2016)

  • (HPC Pro SH4 is still version 1.20)
  • (PPC SH3 is still version 1.20)
  • Fixed a bug with the RESULT macro function when returning references.
  • Fixed a bug with the NETWORKDAYS worksheet function.
  • Fixed a bug with the MESSAGE macro function.
  • Fixed a bug with the IF worksheet function in array formulas.
  • Fixed a bug with opening of CSV files with long names.
  • Fixed a bug with the LOOKUP worksheet function.
  • Fixed a bug with the FREADLN macro function when reading long lines.
  • Fixed a bug with the displaying of tooltip text for buttons.
  • Fixed a bug with the EXEC macro function in the CE version.
  • Fixed a bug with the CREATE.OBJECT macro function return value.
  • Fixed a bug with screen updating while running nested macro functions.
  • Can now open Excel files as old as Excel 2.1.
  • Files can be dragged/dropped into the application window to open them.
  • Increased length of text allowed for hyperlinks.
  • Application window position is now saved and restored.
  • Sort dialog box is now bigger.
  • Validation list selection now counts as a worksheet change event and can trigger a macro.
  • Find/Replace and Delete now ignore hidden rows when a filter is active.
  • The CHAR worksheet function now uses ANSI code page.
  • Added Insert > Name > Paste menu option.
  • Added LIST.NAMES macro function.
  • Many other improvements.

New in Spread32 2.04 (Jan 11, 2016)

  • (HPC SH3 is still version 2.03)
  • (PPC SH3 is still version 1.20)
  • (HPC Pro SH4 is still version 1.20)
  • Fixed a bug where AutoShape menu items were not being drawn correctly in WM6.0.
  • Fixed bugs in the INFO("ORIGIN"), ROUND, ROUNDDOWN and ROUNDUP worksheet functions.
  • Fixed bugs in the ARGUMENT, CALL, INPUT, REFTEXT and SET.VALUE macro functions.
  • Fixed a bug in the range intersection operator.
  • Fixed a bug in saving in Excel 95 format.
  • Fixed a bug in updating of formula references in sorted cells.
  • Fixed a bug with references to external files.
  • Fixed a bug with the default font in Chinese version.
  • Speeded up copy/paste operations.
  • Added support for loading old (before Excel 5) files.
  • Added support for copying and pasting cells containing objects.
  • Added support for selecting cells and ranges with keyboard during formula entry.
  • Added Text To Columns menu option.
  • Added the GET.WINDOW, RESULT, SAVE.COPY.AS, TEXT.TO.COLUMNS and VOLATILE macro functions.
  • Added Ctrl+= keyboard shortcut for AutoSum.
  • On Pocket PC, pop-up keyboard is automatically shown when Formula bar is clicked.
  • Improved navigation of Data Validation, AutoFilter and Object drop-down list boxes using keyboard and mouse.
  • Added Undo facility for Move and Copy Sheet.
  • Changed AutoSum to use SUBTOTAL instead of SUM when a filter is active.
  • Changed sorting to be stable (rows or columns are not moved unnecessarily).
  • Changed lookup functions to allow wildcards.

New in Spread32 2.03 (Jan 11, 2016)

  • (Some SH3/4 versions are still at level 1.20)
  • Fixed a bug with conditional formatting.
  • Fixed a bug with some financial functions that allow non-integer terms.
  • Fixed a bug with writing to the INI file where used instead of registry.
  • Fixed a bug with F1 help display.
  • Fixed a bug with data validation in merged cells.
  • Fixed a bug with processing of whole-column references.
  • Fixed a memory leak in Find/Replace processing.
  • Fixed a bug with the processing of CALL function parameters.
  • Fixed a bug with loading chart ranges in Excel 95 format.
  • Fixed a bug with selection dragging when panes are frozen.
  • Fixed a bug with text changing case when saved.
  • Doesn't remove unlocked attribute when cutting cells on protected sheet.
  • Uses Unicode formula bar where possible for entry/edit of non-english text.
  • Allow fixed decimal places up to 30.
  • CSV load now handles items of any length.
  • Speeded up CSV save.
  • Tab key now skips locked cells on protected sheets.
  • Allow more rows/column when selecting sort keys.
  • Improved support for very large xls files.
  • Improved date parsing.
  • Improved Goal Seek routine.
  • Increased size of Data > Form dialog box.
  • Allow longer text strings in Find/Replace dialog box.
  • Keep target cells in view when using Shift+Ctrl+Arrow keys.
  • Added support for Shift+Page Up/Down, Alt+Page Up/Down.
  • Removed object selection by double-click (except for BE-300 version), so that buttons and spin controls can be clicked as fast as you like without accidentally selecting them.
  • Added Ctrl+insert for copy, Shift+insert for paste.
  • Handle UNC hyperlinks.
  • Support Paste Special from system clipboard.
  • Added Entry assistant toolbar, because I miss the Escape key when entering data.
  • Added Paste Special > Transpose option.
  • Added GET.WORKBOOK function.
  • Added GET.WORKSPACE function.
  • Allow CHITEST with d.o.f. of 1.
  • Support items 50 & 51 for GET.OBJECT command.
  • Added Romanian version.
  • Fixed some menu option translations in Brazilian Portuguese version.

New in Spread32 2.02 (Jan 11, 2016)

  • (Some SH3/4 versions are still at level 1.20)
  • Fixed a bug that caused spurious "out of memory" errors when loading a file.
  • Fixed a bug with blank items in explicit validation lists.
  • Fixed a bug with rendering of monochrome jpeg images.
  • Fixed a bug with display of date values in formula bar on Pocket PC.
  • Fixed a bug with Pocket PC window sometimes not being resized.
  • Fixed a bug with loading csv files containing numbers formatted as text.
  • Fixed a bug with storing of recent file list in Spread32.ini file.
  • Fixed a bug with formatting cells as text.
  • Fixed a bug with saving files to path names containing dots.
  • Sped up file loading.
  • Added Insert>Drawing>Autoshape menu option.
  • Added Insert>Hyperlink menu option.
  • Added Format>Sheet>Zoom>Selection menu option.
  • Added Format>Program>Full screen menu option.
  • Added support for rotated text.
  • Added CREATE.OBJECT macro command for polygons.
  • Added EXEC macro command.
  • Added EXTEND.POLYGON macro command.
  • Added FORMAT.SHAPE macro command.
  • Added FULL.SCREEN macro command.
  • Added GET.DOCUMENT macro command.
  • Changed INDIRECT function to support defined names.
  • Added Brazilian Portuguese HPC MIPS version.
  • Added Brazilian Portuguese CE .Net ARM V4I version.

New in Spread32 2.01 (Jan 11, 2016)

  • Just some bug fixes to version 2.00:
  • Fixed a bug with entering function names containing accented characters.
  • Fixed a bug with passing of cell references to user-defined functions.
  • Fixed a bug with exponentiation of error values.
  • Fixed a bug with the TEXTREF function.
  • Fixed a memory leak in the FOR.CELL macro function.
  • Fixed a bug with discontinuous ranges in charts.
  • Fixed a bug with recalculation of dependent cells on secondary sheets.
  • Fixed a bug with the LOOKUP & MATCH functions not searching the entire range.

New in Spread32 2.00 (Jan 11, 2016)

  • (No new version for SH3 or SH4 devices at this time, due to compiler problems)
  • A complete rewrite of the software. Changes in this version include (but are not limited to):
  • Faster loading and saving, smaller memory requirements for loaded files.
  • Added support for pocket excel templates.
  • Added support for whole-column and whole-row reference notation.
  • Added support for 3d references.
  • Added support for references to external files.
  • Added the ABSREF, ACTIVATE.NEXT, ACTIVATE.PREV, ASSIGN.TO.OBJECT, ATTACH.TEXT, AXES, BRING.TO.FRONT, CANCEL.KEY, CHECKBOX.PROPERTIES, CREATE.OBJECT, DATA.LABEL, DEFINE.NAME, DELETE.FORMAT, DELETE.NAME, DOCUMENTS, DUPLICATE, ECHO, EDIT.SERIES, ENABLE.OBJECT, ERROR, FILE.CLOSE, FILES, FORMAT.LEGEND, FORMAT.MOVE, FORMAT.TEXT, FORMULA.ARRAY, FORMULA.CONVERT, FORMULA.FILL, FREEZE.PANES, GALLERY.AREA, GALLERY.BAR, GALLERY.COLUMN, GALLERY.DOUGHNUT, GALLERY.LINE, GALLERY.PIE, GALLERY.RADAR, GALLERY.SCATTER, GET.CELL, GET.FORMULA, GET.NAME, GRIDLINES, HALT, HIDE.OBJECT, INSERT.TITLE, LABEL.PROPERTIES, LEGEND, LISTBOX.PROPERTIES, NAMES, NEW, OBJECT.PROPERTIES, ON.DOUBLECLICK, ON.ENTRY, OPEN, OPEN.DIALOG, OPTIONS.VIEW, PATTERNS(line), PATTERNS(rectangle), PATTERNS(column chart), PATTERNS(line chart), QUIT, RELREF, RESTART, SAVE.AS, SAVE.DIALOG, SCALE, SCROLLBAR.PROPERTIES, SELECT(object), SELECT(chart_object), SEND.TO.BACK, SET.CONTROL.VALUE and TEXT.BOX macro commands.
  • Improved accuracy and range of statistical functions.
  • Added formatting toolbar.
  • Added chart font formatting.