Comparison

Methos

Comparison Priority

Following priorities are preferable.
- Speed-priority
- Accuracy-priority

Agreement rate

Agreement rate is able to be set to determine comparison column/row. This value is not needed to change in most cases.

Detection of sheet

Method for searching comparison sheet is configured.
- Same name
- Same order of display

Example.
File 1 includes “sheet1”, “sheet2” and “sheet3”
File 2 includes “sheet2”, “sheet1” and “sheet3”

In case “Same name”,
File1!sheet1- File12!sheet1
File1!sheet2- File1!sheet2
File11!sheet3- File1!sheet3

In case “Same order of display”,
File!sheet1- File!sheet2
File!sheet2- File!sheet1
File!sheet3- File!sheet3

Comparison of different sheet

Comparison behavior is configured in case any comparison target has not been found.
- Nothing
- Compare in same order

Example
File 1 includes “sheet1”, “sheet2” and “sheet3”
File 2 includes “sheet2”, “sheet1” and “sheet4”
and “Method to search comparison sheet” is set to be “sheets with same names are compared”. “sheet1” and “sheet2” coincide accordingly, however, “sheet3” and “sheet4” don’t. “Compare in sheet order” compares “sheet3” and “sheet4” and” Do nothing” acts nothing.

Rows/Columns

Most similar rows/columns are calculated with ExcelDiff’s originated algorithm, then comparison results are exported to designated file. This behavior works for evaluating added or moved columns/rows. If so many plural similar areas are found, results are not always calculated as intended. To avoid this, following options are available.

Ignore insertion/movement of rows/columns

Columns/rows added or moved are ignored. Searching similar area does not run and simply compares along with rows from 1st row, 2nd row,… . This functionality is particularly effective when numbers of columns/rows are the same each other. However, newly added/deleted columns/rows are not able to be detected, thus all area is recognized to be different.

String

Comparison Option is configured for characters.

- Ignore whitespace of left
- Ignore whitespace of right
- Ignore code of linefeed differences in cell (CRLF/CR/LF)
- Ignore linefeed of top in cell
- Ignore linefeed of tail in cell
- Ignore case
- Ignore half/full character
- Ignore specified characters (*)

* The regular expression can be specified. Please refer to the homepage of Microsoft for the regular expression.

Property of cell

Properties for cells are comparable with this configuration. Comparison speed would be extremely down if you run to compare properties. Therefore, without any particular purpose, we would recommend you to turn off this function.

- Font
- Font Size
- Font Color
- Cell color
- Strikethrough
- Formulas
- Hyperlink

Result

Result file

Format

Format for result file is configured.

Auto If comparison results could be shown within column/row of 65536*256, the result file is created with Excel 97 - 2003 Book(xls), otherwise, “Excel Micro Book(xlsm)” is used if Excel 2007 or later version is installed.

Excel 97 - Excel 2003 Workbook(xls) Comparison result files is able to be created with up to column/row of 65,536*256.

Excel Macro-Enabled Workbook(xlsm) Comparison result files is able to be created with up to column/row of 1,048,576*16,384. Note that Excel 2007 or later version is needed to be installed.

Result Folder

Save folder for comparison result is able to be indicated. If nothing selected, automatically saved under “My Document\ExcelDiff”.

Number of result files

Number of result files saved is indicated.

Result Display

Language of result file

Output language for comparison result file is able to be indicated.

Application language Output language follows setting in Application Option.

Japanese Output language is exported in Japanese.

English Output language is exported in English.

Display form of result file

View format of comparison result is selectable.

- All Display
- Display file 1 only.
- Display file 2 only.
- Display Difference only

Comparison result includes all comparison info. Thus, user is able to modify view option with Tool screen after executing comparison.

Same sheet

Comparison result is configured in case of no differences.

- Write “No Change”
- Write all data
- Don’t create sheet

Difference of sheet composition

Viewing on differences of sheet composition is configured.

- Display message
- Write to result file
- Ignore

Freeze panes with title row/column

Screen is able to be separated with titles.

Display hidden cell

Non-display cells are configured to be viewed.

Reflect cell width/height

Cell width and height at original sheet are able to be transferred.

Color

Color for comparison result is configured.

General

Reading of files

High-speed CSV files reading

With Excel read protocol, CSV files with indents in cells are read with automatic adjustment function for cell height. In many cases, it would take redundant time to read. ExcelDiff is able to shorten the time with its specialized method.

High-speed sheet name reading

Reading speed for sheet names gets increased. Sheets are lined with alphabetical order. This function is particularly effective for reading files with many sheets or heavy load.

Updating linked books

Behaviors for linked books are configured.

Inhibit the confirming message

Confirmation messages when opening books with links to other books are restricted.

Refer to external

This option is able to be preferable for external reference when “Inhibit the confirming message” is available.

- No update
- Update

Refer to remote

This option is able to be preferable for external reference when “Inhibit the confirming message” is available.

- No update
- Update

Passwords of protected workbook/sheet

The list of the password of the protected workbook/sheet can be set by this option.
ExcelDiff automatically unprotect workbook/sheet by using these passwords.

When protection can't be released by these passwords, the password input dialog shows.

Password of workbook

The password of workbook means the password set according to the following procedures.

Excel application startup.

On the file menu, click Save As.

In the Save As dialog box, click Tools followed by General Options.

In the General Options Dialog box you can set "Password to open".

Password of sheet

The password of sheet means the password set according to the following procedures.

<Excel2007>

Excel application startup.

Click [Review]-[Protect Sheet].

The password is set to the displayed dialog.

<Excel2003>

Excel application startup.

Click [Tools]-[Protection]-[Protect Sheet].

The password is set to the displayed dialog.

Macro

Macro is able to be run when comparison gets started.

For example, user is able to convert data with external macros before running comparison. Macros are also available after comparison.

Auto	If comparison results could be shown within column/row of 65536*256, the result file is created with Excel 97 - 2003 Book(xls), otherwise, “Excel Micro Book(xlsm)” is used if Excel 2007 or later version is installed.
Excel 97 - Excel 2003 Workbook(xls)	Comparison result files is able to be created with up to column/row of 65,536*256.
Excel Macro-Enabled Workbook(xlsm)	Comparison result files is able to be created with up to column/row of 1,048,576*16,384. Note that Excel 2007 or later version is needed to be installed.

Application language	Output language follows setting in Application Option.
Japanese	Output language is exported in Japanese.
English	Output language is exported in English.