OAK version history

Top  Previous  Next

Version

Released

Description

4.40.030

19 September 2018

Public release based on 4.40.024

Fixed a problem with quotation marks in sheet names in map operation.

Fixed an error that occured then pruning multiple ranges.

4.40.028-029

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.40.027

 

"Rough cut" release of future features.

4.40.026

 

Version internal to Operis in which its consultants trial the changes in later external releases.

4.40.025

 

"Rough cut" release of future features.

4.40.024

26 June 2018

Public release based on 4.40.018

Fixed a failure to count references in the reference tracker

4.40.020-23

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.40.019

 

"Rough cut" release of future features

4.40.018

1 January 2018

Public release based on 4.40.017

Removed result-limiting optimisation in reconstructor

4.40.017

16 November 2017

Public release based on 4.40.015

Fixed problem with non-reference names crashing the cross reference report

Changed to FIPS-compliant decryption throughout

4.40.016

 

Reserved

4.40.015

23 October 2017

Public release based on 4.40.013

Changed to FIPS-compliant decryption for reading site licenses.

4.40.014

 

Reserved

4.40.013

2 October 2017

Public release based on 4.40.007

Fixed title of Fan Out Precedents options form.

Improved error reporting and preinstallation checking in multiplatform installer.

4.40.011-12

 

Reserved.

4.40.010

3 September 2017

"Rough cut" release of future features.

4.40.008-009

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.40.007

10 July 2017

Public release based on 4.40.003

Improved error handling in summary risk analysis

Restored COM/VBA API for the R1C1 vs A1 range comparison.

Adjusted installer setup for 32-bit Excel.

4.40.004-006

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.40.003

6 June 2017

Public release based on 4.40.001

Merged 32 and 64 bit editions into a single msi file.

Fixed wildcard search and replace in worksheet manager.

Fix for Desktop Edition being restricted to Essentials limits.

4.40.002

 

Version internal to Operis in which its consultants trial the changes in later external releases.

4.40.001

13 May 2017

Public release based on 4.40.000

Fixed issue with activation of 4.3 serial number not being persisted.

4.40.000

27 April 2017

Initial public release of OAK 4.4 series

Two licensing levels - Essentials / Professional

Enhanced color options in Map tool

New workbook reference report in summary tool

Updated to use the .NET 4.5.2 Framework

Removed dependence on MS-Office Primary Interop Assemblies

Removed support for Excel 2000, 2002/XP and 2003.

4.30.038-042

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.30.037

 

"Rough cut" release of OAK 4.4 features.

4.30.035, 036

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.30.034

14 January 2017

Public release based on 4.30.030

Added R1C1 comparisons to range compare tool

Fixed error comparing ranges

Summarize more robust to errors in risk analysis feature

Updated CompareRanges API functions to handle R1C1 formulas.

4.30.032,033

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.30.031

 

"Rough cut" release of OAK 4.4 features.

4.30.030

3 May 2016

Public release based on 4.30.013

Updated to use Microsoft .NET 3.5 Framework

Improvements in license activation process

Additional pre-installation check

SHA256 code signing

4.30.015,017,019,021,023,025,027,029

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.30.014,016,018,020,022,024,026,028

 

"Rough cut" releases of OAK 4.4 features

4.30.013

22 January 2016

Public release based on 4.30.012

Optimization in interaction with Excel

4.30.012

 

Hot-fix release based on 4.30.009

Fixed problem using COM/VBA API in non-English Excel

4.30.011

 

Version internal to Operis in which its consultants trial the changes in later external releases.

4.30.010

 

"Rough cut" release of OAK 4.4 features.

4.30.009

9 November 2015

Public release based on 4.30.006

Simplified license activation for email and phone activations

Updated advertising for Operis financial modelling book

Removed feedback form as it wasn't being used.

Removed documentation for Excel 2000-2003.

Bug fixes:

oData read from worksheet offset when cell A1 is merged

oBytes downloaded label on update progress form too short.

4.30.008

 

Version internal to Operis in which its consultants trial the changes in later external releases.

4.30.007

 

"Rough cut" releases of OAK 4.4 features.

4.30.006

30 July 2015

Public release based on 4.30.000

Bug fixes:

Slightly more informative error reporting regarding license errors

Map colors not working for names and print area

VBAProjects remaining after workbooks processed by OAK are closed

Error creating report with more than 255 worksheets.

4.20.002,004

 

"Rough cut" releases of OAK 4.4 features.

4.30.001,003,005

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.30.000

17 February 2015

Initial public release of OAK 4.3 series.

Summarize: new risk analysis report

Compare: name comparison, advanced alignment, reports type of change and alignment details, detects changes in array dimensions.

Prune inactive path prunes more functions

Deapply names now has option to ignore named constants

Build Names Database shows name visibility

Increased robustness and improved cancellability of long running map, summarize and compare operations.

New Desktop Edition that runs OAK outside of Excel for improved memory use.

Changed references to "hardwired constants" to "hardcoded constants" in API.

4.20.062-067

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.20.061

11 September 2014

"Rough cut" releases of OAK 4.3 features.

4.20.059-060

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.20.058

28 August 2014

"Rough cut" releases of OAK 4.3 features.

4.20.053-057

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.20.052

11 February 2014

"Rough cut" release of OAK 4.3 features.

4.20.051

22 November 2013

Public release based on 4.20.050

Fix for type library registration.

Fix for text menus in Excel pre-2007 and optionally post-2003.

Fix for error when clicking some column headers in the worksheet manager.

4.20.050

14 October 2013

Public release based on 4.20.038

Fix for failure of summarize tool to list distinct formulas when that is all that is requested of it.

Updated Operis address details in various places

Added references to Excel 2013 and Windows 8 to the documentation.

4.20.039,041-043,045,047,049

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.20.040,044,046,048

 

"Rough cut" releases of OAK 4.3 features.

4.20.038

22 December 2012

Public release based on 4.20.022

Enabled user-local storage of site license files.

Updated installer for Windows 8

Changed UI and documentation references to "hardwired constants" to "hardcoded constants"

4.20.037

 

Modified comparison to detect more detail in date and currency formatted cells.

4.20.023-025,027-029,031-033,035

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.20.023,026,030,034,036

 

"Rough cut" releases of OAK 4.3 features.

4.20.022

26 June 2012

Public release of OAK mostly based on 4.20.009

Significantly reduced memory use in the summarize tool

Fixed:

oSecond summary with the report in the same workbook fails

oSummarize reports all prefixed cell references as off-sheet, even if they are not.

oOAK operations performed with Excel's events enabled.

oWorksheet Manager selection tool fails to recognize an open-ended range (e.g. 1-)

4.20.011-016, 4.20.018-020

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.20.010,017,021

 

"Rough cut" releases of OAK 4.3 features.

4.20.009

8 Feb 2012

Public release based on 4.20.008

Fix for a problem with the Worksheet Manager which leaves calculation switched off.

4.20.008

8 Feb 2012

A version based on 4.20.000 for customers who hold site licenses for OAK.

New Operis colors and logo

4.20.002,003,005

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.20.001,004,006

 

"Rough cut" releases of OAK 4.3 features.

4.20.000

10 Oct 2011

Initial public release of OAK 4.2 series.

Public release of Worksheet Manager

4.10.022-023

21 Sept 2011

"Rough cut" releases of OAK 4.2 features:

Various improvements to the compare ranges tool and reports.

4.10.021

 

Version internal to Operis in which its consultants trial the changes in later external releases.

4.10.020

29 July 2011

"Rough cut" releases of OAK 4.2 features:

Minor changes to compare tool.

4.10.019

 

Version internal to Operis in which its consultants trial the changes in later external releases.

4.10.018

19 June 2011

"Rough cut" release of OAK 4.2 features:

Fixed problem pruning IF with references to blank cells.

Documentation largely complete.

4.10.016-017

 

Version internal to Operis in which its consultants trial the changes in later external releases.

4.10.015

29 May 2011

"Rough cut" release of OAK 4.2 features:

Added awareness of Excel bits to installer and update mechanism.

4.10.014

19 May 2011

"Rough cut" release of OAK 4.2 features.

4.10.012

1 April 2011

A version based on 4.00.010 for companies who hold site licenses for OAK.

4.10.011

21 April 2011

"Rough cut" release of OAK 4.2 features.

4.10.003-010

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.10.002

20 July 2010

"Rough cut" release of OAK 4.2 features:

4.10.001

11 June 2010

"Rough cut" release of 4.2 features.

4.10.000

12 June 2010

Initial public release of OAK 4.1 series.

4.00.024

 

A version internal to Operis in which its consultants trial the changes in later external releases.

4.00.023

28 May 2010

"Rough cut" release of OAK 4.1 and 4.2 features:

Added OAK 4.1 documentation

Added workaround for Excel's out of memory error on map/summarize/compare

4.00.022

 

A version internal to Operis in which its consultants trial the changes in later external releases.

4.00.021

15 April 2010

"Rough cut" release of OAK 4.1 and 4.2 features

Summarize, Map and Compare modified to be more memory efficient in Excel 2007 and 2010.

Added multiple workbook selection to Remove Compare Modifications, Remove Color Formatting and Unhide Cells features.

4.00.020

 

A version internal to Operis in which its consultants trial the changes in later external releases.

Fixed pruning of formulas in a single merged cell.

4.00.019

1 April 2010

"Rough cut" release of OAK 4.1 and 4.2 features

4.00.016-018

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.00.015

18 March 2010

Unpublished external release based on 4.00.009 for selected users

Fixed problem with licensing on Win x64 computers.

4.00.014

28 January 2010

A version based on 4.00.000 for customers who hold site licenses for OAK.

4.00.009-013

 

Versions internal to Operis in which its consultants trial the changes in later external releases.

4.00.008

11 August 2009

A version based on 4.00.009 for companies who hold site licenses for OAK.

4.00.007

10 August 2009

Help updated to 4.00.007

4.00.006

8 July 2009

A version based on 4.00.005 for companies who hold site licenses for OAK.

4.00.005

 

A version internal to Operis in which its consultants trial the changes in later external releases.

Improved handling of too many cell formats condition.

Checks that Deapply names is not obstructed by some or all worksheets being protected before it embarks on this sometimes time consuming action rather than announcing the obstacle after it has done most of the work.

4.00.004

15 June 2009

A version released for Operis training courses.

Implements an important bugfix: alignment option was intermittently not working when comparing large (Excel 2007) worksheets

Also

Search selection dialog didn't remember setting of Match case check box between invocations

Reconstructer dialog defaults didn't match what is described in help.

4.00.003

 

A version internal to Operis which trials various bugfixes.  Specifically

Conditional search dialog showed Value2 field when displayed a second time after looking for specified cell value.

Discrepancy analyzer crashed if reference to unopened workbook was by name rather than reference.

Reconstructed formula showed discrepancy compared with original in a particular instance.

=0-Something (or any binary operation involving a constant) blocked confine to additions in reconstructer.

Pruner picked wrong branch of an IF in a particular instance.

Option to prune in discrepancy analyser resulted in crash when encountering COUNTIF(..) in a particular instance.

Pruner crashed in two particular instances.

Pruner crashed where INDIRECT(..) mentions string expression rather than reference.

Recreate names is much faster in Excel 2007 as OAK now delegates the work to the renaming functionality now available in that version of Excel (so long as the user chooses the Workspace scope; narrower scopes continue to be done formula by formula by OAK)

4.00.002

21 April 2009

A version based on 4.00.000 for customers who hold site licenses for OAK.

Also fixes some bugs

Exception logging was less informative than intended

Deapply names crashed if worksheet is protected

Comparison crashed when comparing a worksheet in compatibility mode with one in large (Excel 2007) mode.

4.00.001

 

A version internal to Operis which is identical to 4.00.000 except for the inclusion of certain prototype features undergoing trial.

4.00.000

8 April 2009

Compared with earlier versions, OAK 4

has been rewritten in C#, which makes it very much faster than earlier versions which were written in VBA

is multithreaded, which means that it is more responsive to user interruption of commands

when loaded into Excel 2007, implements the new Office ribbon interface (but still offers the old menus in earlier versions of Excel)

is capable of handling the much larger spreadsheets that are possible in Excel 2007

implements new technologies which actually interpret Excel formulas, on which are built useful new functions that can reconstruct, prune, simplify, dename, and analyse discrepancies between formulas, all of which are useful in checking spreadsheets, particularly through the development of parallel reconstructions of calculations

exposes its entire interface to COM, meaning that it can be scripted using a programming language such as VBA.