FastExcel V3 Whats New

FastExcel V3 Whats New

The current build of FastExcel V3 is 231.655.789.380

Changes in recent builds:

  • Build 231.655.789.380
    • Fix for Escaped Structured Reference column names in Profile Formulas
    • Miscellanous changes to Formula Indenter
  • Build 231.652.784.380
    • AVLOOKUP2 examples file in FastExcelV3/Examples install sub-folder
    • Updated Help file and PDF
    • Fix for Profile Worksheet not finding any formulas
  • Build 230.651.784.380
    • Fix for French Language Excel: Profile and Clean Commands
  • Build 229.651.783.380
    • Fix for Indenter Editer: Evaluate expressions larger than 256 characters
  • Build 229.651.782.380
    • Fix for Indenter Editer: formulas starting with =-
  • Build 229.651.781.380
    • Profiler chnages for Windows 10 and Excel 2016
    • Profiler fix for RAM greater than 16 GB
  • Build 229.649.781.380
    • Sheet Manager now modeless and resizeable
    • Sheet Manager double-click to activate workbook
    • Clean workbook buffer for rows and columns
  • Build 229.649.780.380
    • More Fixes for Viewer/Indenter/editer in Non-english Locales
    • Fix for Profile Formulas in French locale
    • Change formatting for all Profile command reports
  • Build 229.648.779.380
    • Fixes for Viewer/Indenter/editer in Non-english Locales
    • Fix for Back and Next in Viewer/Indenter
    • Fix for Name Map
    • Make unwanted UDFs no longer visible
    • Minor Help changes
  • Build 228.648.778.380
    • Fix for all Rgx and Rgx.Case functions AMATCH and AVLOOKUP, including Help
    • Fix for Internationl decimal separator in GROUPS
    • Fix for #Value in COMPARE.LISTS with multi-threaded full calculation
    • Updated Help with more function examples
    • Install creates an examples subfolder with Function Example files
  • Build 228.647.778.378
    • Fix for one-dimensional array problem in Indenter/Viewer
    • Improved Debug settings
    • Fix for LINTER2D bug
    • Fix for problems with Break On All Errors settings
    • Change wording on Release Licenses
  • Build 225.647.777.377
    • Range Calculate - option to ignore screen refresh time
    • Improved accuracy when timing expressions
  • Build 224.646.777.377
    • Viewer/Indenter - fixes for Arrow Keys and Expand/Contract selection
  • Build 224.646.776.377
    • Viewer/Indenter - More Fixes for SDI in Excel 2013
    • Scroll settings option on GoTo
    • Unhide settings option on GoTo
    • Fix for Evaluate and F9 debug on single cell
    • Warning message on selecting multiple non-unique formulas
    • Minor updates to Help
  • Build 224.645.774.377
    • Viewer/Indenter - Fixes for Structured References
    • Viewer/Indenter - Fixes for SDI in Excel 2013
    • Minor updates to Help
  • Build 224.645.773.377
    • Redesign and Rewrite of the Viewer/Indenter - now version 2
    • Workbook Cleaner changes - fixes and parameter for the size of a cleaning step
    • Fix for entering formulas from the FastExcel Ribbon
    • Updates to NM Pro
    • Updated Help and Manuals
  • Build 224.645.765.375
    • Silent install option
    • Workbook Profile: Option to ignore constants
    • Time Macro: Fix for workbook names containing spaces
    • Indenter-Viewer: Fix Indenting bug
    • Indenter-Viewer: Improvements to evaluate
    • Indenter-Viewer: Fix out of stack space with Auto-Refresh array formulas
    • COMPARE.LISTS: New options 5 and 6 show result lists without count
    • VSORT: fix for use in single-cell array formulas
    • AVLOOKUP2: improved performance with array data
    • AVLOOKUP2: fix for memory with multi-cell array formulas
    • Updated Help and Manuals
  • Build 223.644.764.376
    • Fix to PAD.ARRAY when reducing the size of an array in a multi-cell array formula
    • Examples for PAD.ARRAY
  • Build 223.644.764.375
    • QLM Logging
    • Name Manager - fix for >100000 Names
    • GROUPS function - add to Function selector, fix for invalid Regex handling
    • Help & PDF updates - Using SpeedTools functions from VBA
    • Excel 2003 - Add Licenses command to FastExcel Menu
  • Build 222.644.763.374
    • Licensing: QLM 7.2.14298.1
    • Profile Formulas: fix for detecting XLL typestrings
    • Calc Options fix for calculating with buttons
    • Name Manager 2 small fixes
  • Build 221.643.762.374
    • Replaced DIGITS function with GROUPS function
      • Numeric, alphabetic and Regex-based groups
      • Start and End search position parameters
  • Build 221.643.762.368
    • fixed Multi-threading problem when determining Used Range
    • 2 new Text functions: DIGITS and Rgx.MID
    • Upgraded SpeedTools to Boost 1.56
    • Install fixes for licensing and French
    • Fix for Sheet Manager Listbox
    • Fix for Application.Calculation failure in XL 2013 when using FXL calculation startup
    • Fix for Clean Workbook with ScrollArea
  • Build 220.643.761.317
    • Licensing: Upgraded QLM Licensing to V7
    • Licensing: Added Release Licenses button to simplify moving a license to a different machine
    • Help: Added Contextual help for FastExcel Profiling output and updates for Licensing improvements
    • Profiler: Time is not volatile
    • Profiler: improved Drill-Down sequence
    • Manager: fixed Sheet Manager switching to Manual Calculation.
  • Build 219.642.760.317
    • Added options to Clean Workbook for zero-sized or zero height/width shapes
    • Fix for Clean Workbook removing empty sheets
    • Fix for View/Edit formulas double-click a name containing a period
  • Build 218.642.758.317
    • Clean used range allows for anchored shapes and comments beyond the last data cell.
    • Name Manager Pro fix for Traditional Chinese
    • Fixes for Clean Used Range
    • Name Manager Pro - List Names also lists Tables
    • Added License Button in the Help Group on the FastExcel Tab of the ribbon.
  • Build 217.642.757.317
    • fix for starting Excel by double-clicking a file
    • fix for initialisation of SpeedTools functions when starting Excel with an empty workbook
    • fix for Dynamic Range Wizard and Unicode locales
    • fix for Dynamic Range Wizard using INDEX and COUNTROWS,COUNTUSEDROWS,COUNTUSEDCOLS
  • Build 215.642.755.317
    • fix for counts and lengths in Profile Worksheet
    • fix for selecting Tables in Name Manager Pro in Excel 2003
  • Build 214.640.754.317
    • Reduced size of Install File
    • XLL+7.06
    • View/Edit - Fixed Parser bug in recognising function names
    • View/Edit - Can insert Defined Names from other workbooks
    • View/Edit - More fixes for Evaluate and Double-Click
  • Build 213.640.753.316
    • Support for Excel 2003 fixed
    • Bug fixes for Evaluate and Double-click goto in Viewer/Indenter
    • Simplified Drill-Down useage
    • Install retry option when Excel open during install
    • Install no longer installs for Excel 2002
    • Help available for functions, user guide, optimising calculations and contextual help
  • Build 211.639.752.316
    • Bug fixes in COMPARE.LISTS
    • ViewerIndenter: Evaluates on change in selection using a mouse
    • ViewerIndenter: double-click in the Formula Box goes to the selection.
    • Fix for help for SpeedTools functions from within the Function Wizard
    • Fix for Help on Calculation settings, Dynamic Range Wizard etc.
    • Formula Help is partially fixed.
  • Build 210.638.751.315 fixes bugs reported since the start of Beta 3
  • Build 209 fixes a problem with using Alt-F4 to close all open workbooks and exit Excel
  • Build 750 contains a performance improvement for Formula Viewer/Editer

Changes in previous builds include

  • Integration of SpeedTools into FastExcel V3
  • Ribbon Group moved from Formulas to the FastExcel V3 Tab
  • Fix for Compare.Lists
  • Fix for Function Wizard Help
  • Updated help and PDF manual
  • Extended SORT options for LISTDISTINCTS, LISTDISTINCTS.COUNT, LISTDISTINCTS.SUM, LISTDISTINCTS.AVG: ascending or descending sort on the distinct items or the column of counts/sums/averages.
  • Fix for limitation on using F4 when launching functions from the SpeedTools functions menu
  • Updated help and PDF manual
  • The install package distinguishes between .NET 3.5 and .NET 4.0
  • Bugfix for the AVLOOKUP family using a numeric missing value error return
  • Bug fixes for Sorting options in VSORTS and the LISTDISTINCTS family of functions
  • ASUMIFS and ACOUNTIFS return a row of sums or counts if entered as a multicell array formula with the Return_Column parameter set to 0
  • Improved error handling in the installation program
  • Choice of 32-bit or 64-bit installation under 64-bit OS (choose same bitness as Excel)
  • Fix for Licensing problems with some 64-bit OS versions
  • VLINTERP2 additional parameter for Lookup Column number
  • Fix for Licensing problems with 32-bit Excel on 64-bit OS
  • Fix for Help with 64-bit Excel
  • Toolbar added in Excel 2007 and later
  • IsFormula function changed to HasFormula
  • Double-click on a chosen function to launch the function wizard
  • Trial License reminder shows only at the first Excel session in a day
  • Added getting started and Installation to help and manuals
  • Updated Help and PDF Manual
  • Link to Purchase SpeedTools webpage
  • Improved tab order on the forms
  • Use Collating sort rather than binary sort in LISTDISTINCTS family sort option
  • Ability to use {=TRANSPOSE(LISTDISTINCTS(...)) } to return a horizontal array of distincts
  • Option for Named Lookup memory
  • Improvements and bug fixes to Clearing and Retrieving Lookup memory, storing Lookup memory in workbooks
  • MemLookup and MemMatch option for vertical or horizontal lookup
  • MemLookup finds the Lookup Column using either header row labels or column numbers
  • Default memory type changed to Book-Sheet-Row for all Lookup functions
  • REVERSE.TEXT has additional argument giving the number of characters to return
  • The download is a zip file containing the installation exe
  • Default Options changed to Exact Match and Unsorted for all Lookup functions
  • Resized Dialogs for Function selection
  • Build Number reflects both XLA and XLL changes
  • FILTER.MATCH now returns 1-based relative row numbers rather than zero-based relative row numbers
  • FILTER.IFS returns #Value rather than #Bad Oper message when the DataRange is an array
  • Fix for Excel 2013 SDI multiple workbooks problem and Choosing functions from the SpeedTools Function library.

Known problems :

© 2001-2014 Decision Models  Legal Disclaimer Privacy Statement E-Mail Webmaster