Build 3.0.0.84 of xlsgen fixes a problem in Excel.

A customer made a request about some behavior in xlsgen and inadvertedly this ended up being a problem in Excel. Particularly a regression introduced in Excel 2003, that was never fixed.

So the problem can be found in Excel 2003, Excel 2007, Excel 2010 and Excel 2013.

But not in Excel XP. Oddly enough, that's why the entire customer org stayed on Excel XP.

No more. The bug was an internal inconsistency in shared formulas records in Excel .XLS files. Shared formulas is a mechanism for writing a formula once in a range where all other formulas can be deduced by linear offsets.

When such file exhibiting the bug is opened in Excel 2003, Excel 2007, Excel 2010, Excel 2013, the cell will show a #REF? error, and the formula bar will be =#REF?. In Excel XP, the cell value is correct and consistent, and so is the formula bar.

If this file is open and then written using xlsgen 3.0.0.84, the bugs are automatically identified and fixed, and all of a sudden the file can be opened in all Excel versions.