An option has been added to allow DiffEngineX to compare Excel defined names.
Excel allows names with either workbook or worksheet-level scope to be created. Workbook-level scope names are only compared when Whole Workbooks is selected on the main part of the user-interface. Likewise if /sheets is supplied as a command-line argument, workbook-level scope names are not compared.
Ranges and formulae referred to by names are always reported in R1C1 notation regardless of DiffEngineX's A1 or R1C1 notation setting.
This is because a cell reference in R1C1 notation is self-contained. Cell references in A1 notation can only be understood with reference to what Excel regards is the Active Cell at a particular moment in time, if they have any part of them that is a relative rather than absolute reference.
For example the Excel defined name and definition of CellBelow = Sheet1!R[1]C unambiguously refers to the cell 1 row down and 0 columns across, regardless of what the Active Cell happens to be at the time
However in A1 notation the same Excel defined name and defintion is
CellBelow = Sheet1!D18 when the Active Cell is $D$17
and
Cell Below = Sheet1!E18 when the Active Cell is $E$17
and
CellBelow = Sheet1!J3 when the ActiveCell is $J$2.
As such, due to relative references, it is better to compare name definitions in R1C1 notation.
Extra Point:
If a workbook of interest is compared against a blank spreadsheet, this new option will effectively report on all the defined names.
