XCell Compiler

XCell Compiler Changelog

 

v3.3 – 2024-03-21

added:

  • Ability to copy “Application name”, “Application version”, “Author legal copyright” into the appropriate compiled EXE file property.
  • “Shift + Alt + Ctrl + C” shortcut key combination to call XCell Compiler compilation form.

changed:

  • the maximum duration of the compiled workbook trial period has been increased up to 366 days.

fixed:

  • error when WithEvent declared variable handler procedure names were obfuscated during VBA code protecting.

 

v3.2 – 2024-01-22

added:

  • Excel GUI adjustment features.
  • Notification about the availability of a new version of the product.
  • Added “Save to file” button in the EULA dialog.

changed:

  • The amount of application version number fields has been increased from 3 to 4 fields.
  • Application version number field can contain up to 4 digits, so the maximum value for a single field is now 9999.
  • Compiled EXE option viewer reworked.

fixed:

  • error in VLOOKUP function
  • error in table syntax parsing

 

v3.1 – 2022-03-24

added:

  •  ‘Accelerated compilation’ option for fast compilation large and/or complex workbooks with big amount of formulas or graphical objects.

changed:

  • XCell Compiler help file (XCell.chm) has been removed from installer. All articles from help file are available on https://xcellcompiler.com web site.

fixed:

  • errors in SUBTOTAL, OFFSET, IPMT, MODE, AND, OR functions.
  • errors in XCell Compiler Dashboard.

v3.0 – 2021-07-22

added:

  • ‘Work Folder’ path, where all temporarily files will be created during workbook compilation.
    This folder should exist and should not contain any files before compilation.
    The path to the ‘Work Folder’ should be added into the antivirus software exception list to avoid false positive detections during workbook compilation.
  • ‘Exception from Compilation’ dialog to allow the indexing of cell ranges where formulas will not be compiled.
  • detection of VBA UDF volatile functions in the VBA parser if the user defined functions in the VBA code contain the ‘Application.Volatile’ statement.
  • “dateto” switch for INFO cell function to show the date of expiration of the trial period or the registration key.

changed:

  • Excel Add-Ins collection, which should be enabled in Excel when the compiled EXE is started, was moved from the compilation options form to a separate ‘Enable Add-Ins’ dialog.

fixed:

  • error in GETPIVOTDATA function.
  • error in TEXTJOIN function.
  • formula parser error when the formula is started with ‘=@’

 

v2.8 – 2021-01-05

added:

  • XCell Compiler Dashboard – application with basic product diagnostic information.
  • new XCell Compiler activation approach, as “Apply Registration Key” button on XCell Compiler about box or dashboard.

changed:

  • Windows XP support is discontinued.
  • Compiled application registration key generation is transfered to new version of computer ID. This new computer ID is longer and more stable.
    Registration keys generated with previous version of computer ID will continue to work as before.

 

v2.7 – 2020-04-05

added:

  • new feature ‘Quick protection’. This feature improves calculation performance when worksheets have password protection.
  • support for SINGLE, FIELDVALUE, FILTER, SORT, UNIQUE, XMATCH, XLOOKUP, SORTBY, RANDARRAY, SEQUENCE functions.

fixed:

  • error in XNPV function

 

v2.6.12 – 2019-11-12
fixed:

  • error in function INDEX
  • error in function INDIRECT when non English sheet name was used in English version of Excel
  • memory leaking

misc:

  • performance improvement for workbooks with password protected worksheets

 

v2.6.8 – 2019-07-29
fixed:

  • recalculation before saving didn’t work when manual calculation mode with “Recalculate workbook before saving” flag enabled.

v2.6.5 – 2019-05-13
added:

  •  new tag <?EXEPATH?> for custom resource dictionaries. This tag is substituted by path of the started EXE file location at run-time.
  •  use the text “\r” as a value of this resource in resource dictionaries to mark resource as empty line.

changed:

  • The <?EXEPATH?> tag is used in NO_REGKEY_MSG resource in examples of dictionaries.

fixed:

  • error in POWER operator and function for negative power of zero, like : 0^-2
  • error in BulkRegKeyGen utility.

v2.6.2 – 2019-03-15
fixed:

  • error in VBA parser when Japanese language symbols are present in VBA code

 

v2.6 – 2019-02-22
changed:

  • XCell Compiler computer ID calculation algorithm was modified in order to make computer ID more stable.

misc:

  • internal improvements and bug fixes.

 

v2.5.16
fixed:

  • error in VBA literal removing algorithm.

 

v2.5.13
added:

  • reminder for the product maintenance period expiration.
  • most popular virtual machines detection.
    If you do not want your compiled workbook be able to start in a virtual machine environment then you need to disable “Allow to run on virtual machines” option.

 

v2.5.12
added:

  • support of high DPI monitors with resolution scaling.
  • DoneExCopyFormulas run-time method to copy compiled formulas from one place of a compiled workbook to another.
  • detection of the lack of the latest service pack for Excel 2003, Excel 2007, Excel 2010 and Excel 2013.
    The product will not work if the latest service pack for Excel is not installed, and compiled workbook will not start for the same reason.
  • mdlXCellRuntimeAssistance.bas file placed into XCell Compiler installation folder.
    The file is located in <XCell Compiler installation folder>/Samples folder.
    This VBA source file contains auxiliary wrapper functions for XCell Compiler run-time API methods.
    You need to import this file into your VBA project in order to use these methods.

fixed:

  • Excel crash during compiled workbook exit in Excel 2010 and Excel 2013

 

v2.5.9
changed:

  • logic of detection of VBA code syntax errors before compilation.
    Now if VBA code contains syntax error it is possible to continue a workbook compilation.

 

v2.5.7
fixed:

  • error in cell formulas with table syntax.

 

v2.5.6
fixed:

  • error in VBA literal removing mode for integer literal with value 256 or &HFF

 

v2.5.5
fixed:

  • VBA parser error.
  • adjusted correct appearance and closing of splash screen on start of compiled workbook.

 

v2.5.1
fixed:

  • XCMD.exe utility.

added:

  • “XCell Compiler Helper” Excel Add-In (dnxclrinitxfu.xla) to fix command line compilation.