F9 V5 and .NET Framework 4.5 Information

We have updated all our F9 V5 and F9 Viewer products effective Sept. 30, 2015. They now are using Microsoft's .NET Framework 4.5 instead of Framework 3.5. This change is to take advantage of additional and improved development features in the Framework. One result of this is a performance boost for many users - this can vary widely depending on many factors.

.NET Framework 4.5 is already included with Windows version 8 and later and Windows Server version 2012 and later. It can be installed on Windows 7 Service Pack 1, Windows Server 2008 R2 SP1, Windows Server 2008 Service Pack 2, and Windows Vista Service Pack 2. Note: later versions of .NET Framework such as 4.5.1, 4.5.2 and 4.6 are in-place updates to .NET Framework 4.5 and work fine.

When updating your F9 software, just follow the usual procedure.

The F9 installs will install .NET Framework 4.5 if it is not already present but you can alternatively prepare your system by installing it yourself before installing the latest versions of F9 V5 and F9 Viewer. .NET Framework 4.5 can be obtained from Microsoft here.

This change has number of implications. Please review these in case your computer environment or reports are affected:

1)  If your reports use BSPEC formulas whose parameters point to ranges of cells OR if the reference(s) point to empty cells, please replace the BSPEC() formulas with BSPECR() formulas using the same parameters. See below for an example. The F9 Help file for your product describes this as well.

2)  Windows XP and Windows Server 2003 are no longer being supported. We will provide links to "Legacy" installs using .NET Framework 3.5 for a time but these installs were last built Sept 12, 2015 and they will not be maintained or updated. These installs executable filenames start with "N35". If you are on a version of Windows newer than these, please use the latest installs.

3)  If you have both F9V5 and F9 Viewer installed on the same computer, please update both.

4)  All updates from this point forward will be using .NET Framework 4.5.

Go to main download page

BSPECR() Example

Use BSPECR if your parameters are pointing to ranges of cells or if the reference(s) point to empty cells.

For example: =BSPECR(A1:A5,B2:B6,B3,...).