I am dealing with a monster excel document sport schedule (26 columns x 596 lines) in which the majority of the space is unimportant white space, with boarders to mark groups of cells containing relevant information.
The problem is that when an item moves up/down, or flip-flops within a boardered section of cells, BeyondCompare reads it as changed, when it really is the same information in the same section, just a line higher/lower or in a different order.
For example, the document might say:
"Sat, Dec. 1 - Texas @ Kansas, USC @ Cal";
and then it switches to:
"Sat, Dec. 1 - USC @ Cal, Texas @ Kansas".
They are the same games for the same date, but it is marked as changed because the order is different.
Similarly, if Dec. 1 marks lines 568-583, and the Texas @ Kansas game was first on line 568 and now is on 579, the entire section is marked as changed, when really it is still the same game for the same date just moved up/down.
Is there a way to tell Beyond Compare to ignore this type of change?
Please help!
The problem is that when an item moves up/down, or flip-flops within a boardered section of cells, BeyondCompare reads it as changed, when it really is the same information in the same section, just a line higher/lower or in a different order.
For example, the document might say:
"Sat, Dec. 1 - Texas @ Kansas, USC @ Cal";
and then it switches to:
"Sat, Dec. 1 - USC @ Cal, Texas @ Kansas".
They are the same games for the same date, but it is marked as changed because the order is different.
Similarly, if Dec. 1 marks lines 568-583, and the Texas @ Kansas game was first on line 568 and now is on 579, the entire section is marked as changed, when really it is still the same game for the same date just moved up/down.
Is there a way to tell Beyond Compare to ignore this type of change?
Please help!
Comment