Workbook review
The workbook review is designed to provide the reviewer with an overview of any differences found within and between workbooks and the ability to drill down into the details.
The workbook review covers more than changes to cell values. It includes a review of changes to documents and macro changes as well.
The ComplyXL workbook review is able to detect whether any change has been made to a workbook though it may not necessarily be able to to show you the specific change.
Worksheet review
A review of any worksheet differences can be accessed either from the detailed workbook review or directly from one of the worksheet comparison options. The screen shot below shows an example of a link provided from the workbook details review when ComplyXL identifies changes to a contained worksheet.
Sometimes ComplyXL will identify changes to a worksheet but changes that do not affect cell value, formulas, formats, names or merged cell ranges. An example is a change to a chart. That a change has been made will be detected, however ComplyXL is unable to determine the specific change made to a chart.
The worksheet review details the differences detected between two worksheets row-by-row and cell-by-cell. The worksheet review lists all rows that contain changed cells and then the individual cells containing changes. Although the most common features of a cell are its value and formula, cells are described by many other properties such as the font and color used to display the value, whether it is locked, part of a merged cell group and so on.
For cells that ComplyXL detects are different it will list the the properties that have changed and include the current values. If available, the current formulas will also be included.
What is the "Raw cell value"?
No comments:
Post a Comment