OAK version history

This page in 2007
Top  Previous  Next

Version

Released

Description

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.