xlCompiler Changelog

Here you can see history of changes in the xlCompiler.

xlCompiler 3.8.24

Released on 09/23/2020
  • Command to Print worksheet to PDF.
  • Fixed issue with entering expired Activation Key.
  • Fixed problem with printing long text on the wrong page.
  • Fixed crash in the INDEX function.
  • Minor updates and fixes.

xlCompiler 3.8.22

Released on 09/14/2020
  • Option to Hide main application window.
  • Option to Run application as Singleton.
  • New reworked Activation Interface.
  • Activation information is available in the VBA code.
  • Generate Activation Keys for Trial version.
  • Improvements in the VBA support of Ribbon Controls.
  • Implemented Intersection Operator in the worksheet formulas
  • Fixed calculation issue with IRR worksheet function
  • Fixed calculation issue with SMALL worksheet function
  • Fixed issue with saving files on the external drives.
  • Fixed issue with formatting for localized numeric values.
  • Fixed bug with Click event in the Label control.
  • Fixed issue with wrong shape position in the printed document.
  • Fixed issue with flickering in the Main Window.
  • Minor updates and fixes.

xlCompiler 3.8.4

Released on 08/20/2020
  • CONCAT function added to xlCompiler.
  • Fixed issue with wrong paper size when printing.
  • Fixed compatibility problem with XLSM file format.
  • Fixed crash in the INDEX worksheet function.
  • Fixed drawing issue with Frame control.
  • Minor updates and fixes.

xlCompiler 3.8.0

Released on 08/08/2020
  • xlCompiler supports Equations on the worksheets.
  • Fixed crash when calling external functions from the VBA code.
  • Fixed issue with saving inserted rows.
  • Minor updates and fixes.

xlCompiler 3.7.28

Released on 08/04/2020
  • Enable Selection and Context Menu in the TextBox control.
  • Fixed issue with saving inserted images.
  • Minor updates and fixes.

xlCompiler 3.7.27

Released on 07/29/2020
  • ExportAsFixedFormat method exports data to PDF format.
  • xlCompiler supports Page Breaks on the worksheet.
  • xlCompiler supports arrays in the VLOOKUP worksheet function.
  • Fixed synchronization issue between Scrollbar and Mouse Wheel in the Multiline TextBox.
  • Fixed issue with entering Expiration Code.
  • Fixed Input Prompt positioning issue.
  • Fixed Chart Legend drawing issue.
  • Minor updates and fixes.

xlCompiler 3.7.19

Released on 07/19/2020
  • Improvements and fixes in the Ribbon Controls.
  • Enable Right Click Menu commands using VBA macro.
  • Fixed issue with printing Charts.
  • Fixed issue with aspect ratio on inserting images into worksheets.
  • Number of improvements in the VBA Engine.
  • Fixed issue with type conversion in the MIN and MAX worksheet functions.
  • Minor updates and fixes.

xlCompiler 3.7.14

Released on 07/07/2020
  • Load images into Visual Basic forms and worksheet shapes, using VBA code.
  • xlCompiler supports Multipage TextBox control.
  • Minor updates and fixes.

xlCompiler 3.7.12

Released on 07/04/2020
  • CONVERT worksheet function is supported.
  • Worksheet_BeforeDoubleClick event is implemented.
  • Number of improvements and fixes in the VBE Engine.
  • Fixed crash when opening worksheet with chart.
  • Minor updates and fixes.

xlCompiler 3.7.7

Released on 06/25/2020
  • Web Browser control is supported by xlCompiler.
  • xlCompiler copies data into clipboard in the Image format also.
  • Fixed problem with loading some ActiveX controls.
  • Fixed crash when opening worksheet with chart.
  • Minor updates and fixes.

xlCompiler 3.7.5

Released on 06/09/2020
  • Fixed problem with printing merged cells.
  • Fixed few calculation issues.

xlCompiler 3.7.4

Released on 06/01/2020
  • Fixed issue with Evaluate visual basic function.
  • Fixed problem with saving merged cells.
  • Minor updates and fixes.

xlCompiler 3.7.3

Released on 05/22/2020
  • New worksheet functions.
  • Fixed issue with wrong cell recalculation.
  • Fixed Internal Compiler Error on opening XLSM files.
  • Minor updates and fixes.

xlCompiler 3.7.2

Released on 05/13/2020
  • Fixed few minor issues with Lookup functions.
  • Fixed issue with Worksheet Protection options. xlCompiler supports SHA-512 algorithm.
  • Fixed crash on opening XLSM files.
  • Minor updates and fixes.

xlCompiler 3.7.1

Released on 05/06/2020
  • New worksheet functions:COSH, SINH, TANH.
  • Improvements in the VBA Engine.
  • Fixed crash when saving changed data.
  • Minor updates and fixes.

xlCompiler 3.7.0

Released on 05/04/2020
  • New Worksheet and Visual Basic functions.
  • Fixed few issues with opening files in the XLSX format.
  • Fixed some calculation issues in the Array Formulas.
  • Minor updates and fixes.

xlCompiler 3.6.5

Released on 04/20/2020
  • Added Undo - Redo commands to the Ribbon.
  • Fixed issue with editing protected cells.
  • Fixed issue with copiing cells values between worksheets.

xlCompiler 3.6.4

Released on 04/16/2020
  • Fixed problem with merged cell formatting.
  • Minor updates and fixes.

xlCompiler 3.6.3

Released on 04/13/2020
  • Faster XLSM file loading.
  • Fixed issue with VBA macro compilation.
  • Minor updates and fixes.

xlCompiler 3.6.1

Released on 04/06/2020
  • Reworked Calculation and Visual Basic Engines.
  • New worksheet and Visual Basic functions.
  • Reworked interface.
  • Improved compatibility with XLSM file format.
  • Minor updates and fixes.

xlCompiler 3.5.1

Released on 10/03/2019
  • New worksheet and Visual Basic functions.
  • Improved supports of the Conditional Formatting Rules.
  • Improvements in the Visual Basic Engine.
  • Faster opening of the XLSM files.

xlCompiler 3.5.0

Released on 09/09/2019
  • New worksheet and Visual Basic functions.
  • Improvements in the Calculation Engine.
  • Improvements in the Visual Basic Engine.
  • Minor updates and fixes.

xlCompiler 3.4.6

Released on 06/04/2019
  • Custom Validation Rule, based on the formula.
  • Few fixes and improvements in the Visual Basic Engine.
  • Fixed problem with custom text formatting.
  • Minor updates and fixes.

xlCompiler 3.4.5

Released on 05/18/2019
  • Save changed data in the storage file with customized extension, instead of text XML file.
  • Create file association for compiled application.
  • New worksheet functions.
  • Faster loading XLSM\XLSX files.
  • Fixed a few compatibility issues with Visual Basic Macros.
  • Fixed crash when opening XLSM workbook.
  • Minor updates and fixes.

xlCompiler 3.4.4

Released on 05/09/2019
  • New Financial worksheet functions.
  • Fixed drawing bug in the Scatter chart.
  • Fixed crash when opening worksheet with Scatter chart.
  • Fixed crash in the Calculation Engine.
  • Fixed problem with accessing Range.Formula property.
  • Minor updates and fixes.

xlCompiler 3.4.2

Released on 05/03/2019
  • Improved support of the Excel Object Model in Visual Basic macros.
  • Minor updates and fixes.

xlCompiler 3.4.1

Released on 04/18/2019
  • User Interface was adopted for 4K monitors.
  • Area Chart is supported.
  • Fixed problems with Auto Filter on the worksheet.
  • Fixed number of issue in drawing charts.
  • Fixed issue with calculating Defined Names.
  • Number of improvements and fixes in the Visual Basic engine.
  • Copy and Save To File command in the Output window.

xlCompiler 3.4.0

Released on 04/02/2019
  • Ability to open Excel workbooks in the XLS\XLSX\XLSM file formats.
  • Fixed few issues with frozen areas on the worksheet.
  • Fixed issue with printing large charts.
  • Minor improvements and fixes.

xlCompiler 3.3.4

Released on 03/12/2019
  • Fixed few issues with Printing.
  • Fixed problem with Data Validation.
  • TypeOf statement in the VBA is supported.
  • Minor improvements and fixes.

xlCompiler 3.3.3

Released on 03/07/2019
  • Fixed problem with date formatting.
  • New worksheet finctions.
  • Minor improvements in the Calculation Engine.

xlCompiler 3.3.2

Released on 02/28/2019
  • Fixed few formatting problems.
  • Performance improvements in the Calculation Engine.
  • Minor improvements and fixes.

xlCompiler 3.3.1

Released on 02/16/2019
  • Fixed problems with formatting under non-US locale.
  • Performance improvements in the Calculation Engine.
  • Zoom commands on the Tools tab.
  • Fixed problems with setting Print Area.
  • Minor improvements and fixes.

xlCompiler 3.3.0

Released on 02/08/2019
  • New formula functions
  • New Visual Basic functions and objects are supported
  • Performance improvements in the Calculation Engine.
  • Fixed few problems Visual Basic Engine.
  • Fixed compatibility issues with XLSM file format.
  • Hotkeys for Zoom.
  • Minor improvements and fixes.

xlCompiler 3.2.4

Released on 12/12/2018
  • Fixed problem with IRR function
  • New Activation option: Hardware Based Activation Key.
  • Fixed few problems in the VB code compilation.
  • Minor improvements and fixes.

xlCompiler 3.2.3

Released on 12/04/2018
  • Radar Chart is supported by xlCompiler
  • Filter on the worksheet.
  • Fixed few problem in the VB code compilation.
  • Fixed problem with Row Source property set on the Shapes.

xlCompiler 3.2.0

Released on 11/19/2018
  • New Worksheet and Visual Basic functions
  • Faster calculations
  • Minor updates and fixes

xlCompiler 3.1.16

Released on 07/05/2018
  • New Statistical and Math worksheet functions
  • Class modules in the Visual Basic project are supported by xlCompiler
  • New Visual Basic functions
  • Faster workbook loading
  • Improved calculations in the Lookup functions

xlCompiler 3.1.15

Released on 06/20/2018
  • New worksheet functions
  • New Visual Basic functions
  • Embedded OLE Objects
  • Number of improvements and fixes in the VBA macros

xlCompiler 3.1.10

Released on 04/10/2018
  • Number of improvements and fixes in the VBA macros

xlCompiler 3.1.9

Released on 04/03/2018
  • Scroll Area worksheet property is supported
  • Fixed problem with activating merged area by clicking on the hyperlink
  • Several improvements in the VBA code

xlCompiler 3.1.8

Released on 03/15/2018
  • Option to block Save operations in the compiled workbook. Now you can create a workbook which is always read-only.
  • New Protection Option: Expiration Date
  • Number of fixes relative to the Shapes, Formatting and Printing

xlCompiler 3.1.7

Released on 03/08/2018
  • New functions and objects in the VBA engine
  • Changes relative to moving our website to HTTPS protocol

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:
    • GAMMALN
    • INTERCEPT
    • MMULT
    • PERCENTILE
    • PERCENTRANK
    • 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.
  • New functions: REPT, SUMIFS, IFERROR, PROPER, DATEDIF.

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