xlCompiler Changelog

Here you can see history of changes in the xlCompiler.

xlCompiler 3.1.6

Released on 02/08/2018
  • Fixed problem with Print Preview dialog
  • Polished VBA Error Reporting
  • Fixed issue with For Each statement

xlCompiler 3.1.4

Released on 01/28/2018
  • Fixed bug with Scrolling in the ListBox control
  • Fixed issue with assigning numers formatted as strings to numeric cells

xlCompiler 3.1.3

Released on 01/23/2018
  • Fixed problems with Print Preview window
  • AddItem method added to the ComboBox shape

xlCompiler 3.1.2

Released on 12/15/2017
  • Open workbook in the Excel file format (XLSM, XLSX, XLS) from the VBA macro
  • WeekNum worksheet function
  • Not Contain Text conditional formatting rule
  • Fixed a few issues in Conditional Formatting
  • Fixed problem with MsForms.DataObject (clipboard operations failed)
  • Fixed wrong date\time values formatting
  • New functions in the VBA Engine: StrComp, Sqrt, Now, TimeValue
  • Fixed problem with TEXT worksheet function
  • Number of fixes relative to the VBA macros
  • Show\Hide ribbon using Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" statement

xlCompiler 3.1.0

Released on 10/03/2017 Major Update

xlCompiler 3.0.11

Released on 04/13/2017
  • We've implemented 3-D Pie Chart
  • Number of small issues with Images, Hyperlinks, Shapes, etc. has been fixed
  • xlCompiler generates Crash Report Files, you can send to us to for investigation

xlCompiler 3.0.10

Released on 03/27/2017
  • We've added GetObject function to access objects in the Running Object Table.
  • Fixed problem with STDEV function
  • Fixed bug with Solid fill

xlCompiler 3.0.9

Released on 03/23/2017
  • You can use CreateObject function, and Set as New statement to create COM Objects in the VBA macros.
  • Pattern and Gradient fill are supported for Shape Objects
  • Background Image on the worksheet
  • Fixed a number of small issues

xlCompiler 3.0.8

Released on 03/16/2017
  • New worksheet functions VAR/VAR.S/VAR.P and STDEV/STDEV.X/STDEV.P are implemented.
  • New VBA objects and functions
  • Print Bar allows to select Printer, Number of copies, pages, paper
  • Fixed problem with clipboard operations in the VBA code

xlCompiler 3.0.7

Released on 03/09/2017
  • Header and Footer from Page Setup options are implemented.
  • New VBA objects and functions
  • Fixed problem with negative values on the Charts
  • Fixed bug with entering data into text fields

xlCompiler 3.0.6

Released on 02/28/2017
  • Fit to Page and Scale options for printing worksheets.
  • Print selected worksheets
  • Options to change URLs to report VBA errors and Activation errors
  • VBA commands to read and write text files
  • Fixed problem with printing images
  • Fixed problems with COUNTIF, CONCATENATE, IFERROR functions
  • Fixed problem with worksheet protection

xlCompiler 3.0.5

Released on 02/20/2017
  • Extended support of VBA macros: new objects, methods and functions
  • Fixed few minor issues.

xlCompiler 3.0.4

Released on 01/26/2017
  • Added support of ActiveX Controls:
    • Button
    • Combo Box
    • Image
    • Label
  • Fixed problem with VLOOKUP worksheet function.
  • Improved support of VBA macros.

xlCompiler 3.0.3

Released on 01/21/2017
  • New Conditional Formatting rules:
    • Color Scale
    • Data Bar
    • Icon Set
  • New Worksheet Functions:
    • MMULT
    • SLOPE
  • Improved Data Labels implementation on the Line and Scatter charts.
  • Display values from Range feature added to Data Labels on charts.

xlCompiler 3.0.2

Released on 01/11/2017
  • Worksheet Protection feature is supported by xlCompiler.
  • Fixed bugs in the CEILING and FLOOR functions.
  • Fixed floating problem occured when loading large files.
  • Changed in the Sample file. We've added example of using protected cells.

xlCompiler 3.0.1

Released on 01/06/2017
  • Zoom feature is supported by xlCompiler.
  • Input and Write VBA statements are now supported.
  • Few minor issues has been fixed.

xlCompiler 3.0.0

Released on 01/02/2017 Major Update
In this update we've published completely reworked product. It includes all changes which were published in xlCompare.
  • Faster calculation engine which requires less memory resources.
  • Ribbon interface.
  • New worksheet functions.
  • Improvement in the VBA macros.
  • New shapes.
  • xlCompiler setup and included files are signed with certificate.

xlCompiler 2.0.25

Released on 11/09/2015
  • Fixed few problems with compiling large workbooks.
  • Fixed memory corruption problem occured when adding new worksheet.
  • Sensitive worksheet data is saved in the encrypted format.

xlCompiler 2.0.24

Released on 09/02/2015
  • COUNTBLANK worksheet function.
  • Scatter charts
  • Polished Line and Bar charts.
  • Fixed a few bugs in the VBA Compilation.

xlCompiler 2.0.23

Released on 08/27/2015
  • New worksheet functions.
  • Reworked Comments.
  • Fixed crash relative to IF worksheet function.
  • Fixed a few bugs in the Text Shapes.

xlCompiler 2.0.22

Released on 08/11/2015
  • This version allows to "bind" compiled application to the target PC. So, you can deploy compiled workbook to your customers and control all activations.
  • You can add End User License Agreement to the workbook.
  • xlCompiler supports Input Message for Data Validation rules.
  • Fixed bug in the MATCH function.
  • Minor bug fixes.

xlCompiler 2.0.21

Released on 07/29/2015
  • xlCompiler application gets reworked interface. You can easily switch between project and output windows, open Excel workbook and Compiled application from the Context Menu.
  • New shapes are supported: List Control, Scrollbar, Spin Button
  • Fixed bug with lost text on the button

xlCompiler 2.0.20

Released on 07/26/2015
  • Fixed bug in the MATCH function

xlCompiler 2.0.19

Released on 07/24/2015
  • Fixed several bugs in the Calculation Engine

xlCompiler 2.0.18

Released on 07/21/2015
  • Fixed bug in the ROUND function
  • Minor bugfixes

xlCompiler 2.0.17

Released on 07/17/2015
  • Fixed frees caused by IF function
  • Minor bugfixes in the calculation engine

xlCompiler 2.0.16

Released on 07/02/2015
  • New worksheet function
  • Minor bugfixes

xlCompiler 2.0.15

Released on 06/26/2015
  • Fixed a bug in the SUMPRODUCT function
  • Minor bugfixes

xlCompiler 2.0.12

Released on 06/21/2015
  • Fixed a few bugs in the Calculation Engine
  • Fixed problems with Conditional Formatting rules
  • Minor bugfixes

xlCompiler 2.0.11

Released on 06/08/2015
  • New VBA functions
  • xlCompiler supports File objects in the VBA code
  • New worksheet functions
  • Fixed bug with Grouping shapes
  • Minor bugfixes

xlCompiler 2.0.10

Released on 05/27/2015
  • Major Update
  • Extended list of supported worksheet functions
  • New VBA functions
  • Fixed some issues in the Charts

xlCompiler 2.0.9

Released on 04/27/2015
  • INT, SUMSQ, FORECAST functions
  • Improved support of the VBA Macros
  • Minor bugfixes

xlCompiler 2.0.8

Released on 04/02/2015
  • Freeze Panes
  • Data Labels on the line chart
  • Fixed problems with print preview
  • OnKey macro statement command
  • Assign hotkey to macro
  • Fixed a few issues with Conditional Formatting

xlCompiler 2.0.7

Released on 03/19/2015
  • Minor update

xlCompiler 2.0.6

Released on 03/11/2015
  • Manual Activation for xlCompiler.
  • New features:
    • Conditional Formatting: Contains Blanks rule
    • Conditional Formatting: Not Contains Blanks rule
    • Conditional Formatting: Contains Text rule
    • Shapes: Flow chart connector
    • Page Setup: Fit to page
    • Size of the output executable is significantly decreased
  • Fixed problem with compiling Validation Rules
  • Fixed problem with lost column width in the compiled workbook

xlCompiler 2.0.3

Released on 02/26/2015
  • Much faster compilation for XLSM\XLSX files.
  • Fixed problems with activation (in some cases xlCompiler rejects valid password)
  • Fixed crash occured on the XLSM files with Group Shapes

xlCompiler 2.0.1

Released on 01/20/2015
  • We've fixed serveral issues in loading XLS files.
  • Check for Updates feature.

xlCompiler 2.0

Released on 01/09/2015
Major Update. We've published updated version of the xlCompiler after testing and polishing it's engine on the xlCompare product.

xlCompiler 1.0.2

Released on 11/20/2013
  • Accounting and Currency number formats.

xlCompiler 1.0.1

Released on 11/13/2013
  • Pie charts are implemented.
  • Fixed seveal bugs in the Column and Bar charts.

xlCompiler 1.0.0

Released on 10/24/2013