#57 Comparisons with hidden rows - bug or feature?

[Douglas Terry]

Occasionally I open a comparison file with a filter enabled that is hiding some rows. I don't realize they are filtered until I start the compare. After the compare any equivalent lines in the other file that are unhidden will then show up as new/deleted line indications when in fact there is no difference if unhidden (ie filters were off). I can see it being useful to do comparisons with filters and this perhaps this expected behaviour or maybe this is a bug and you should be comparing even against hidden lines. If not a bug then as a feature request perhaps there should be a checkbox to enable hidden line comparison (i.e. it walks through the rows independent of its hidden state to do the comparison). In my case I would 99% of the time check this enable hidden line comparison box, while others may want it the other way so it should be a saved session setting.

[SteveT]

Okay, so cell-by-cell includes hidden/filtered cells because the cells are examined directly (i.e. A1 returns A1 regardless of whether it is displayed). Database Compare uses the Excel Findfunction which ignores filtered cells, unless formulas are searched for instead of values (this still does not seem to work). I will have to add some filter checking and either halt, or automatically remove the filter.

Steve

[SteveT]

I can successfully untidy rows/columns and remove filter so that all cells are compared.

Sent from Yahoo Mail on Android