na-ka-na
commented
9 years ago Somehow I missed replying to this issue.
Yes I've wanted to do this before but never spent any time trying to think how it should be done more generally. Its even there in my TODO - shifting cells, columns, rows.
Specifying ranges might solve a lot of the problem - but it can get unwieldy fast. Say you add a row in the middle, and a column in the middle. To diff that requires specifying 4 ranges.
Is it possible to add a new feature to compare two workbooks and its worksheets based on the range names instead of using cell based reference. Also to use the range names if available when reporting extra and diff. Couple of reasons for this request 1) Currently, if someone enters a new row in the beginning of the worksheet and then compare then none of the cells match 2) When using range names the cell could actually be located in different cells and not be tied to a particular location 3) Make comparing easier when using range names than cell references.