Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2015
    Location
    So.Cal.
    Posts
    88

    Default Spreadsheet (xls) line hiding

    When comparing spreadsheets, is there are way to hide or show lines that have some particular value in some particular field (or several fields)...?

    i.e. similar to column hiding, but conditioned on field content (of one or more fields).

  2. #2
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    11,609

    Default

    Hello,

    No, we don't quite have this support. The Table Compare does allow you to hide full Columns using the View menu -> Columns dialog.

    Our Find dialog can find specific text, but the Table Compare can't hide specific fields if they have a specific text value. However, if you can define the Unimportance in the Session Settings, Columns tab (numeric or date tolerance), that difference can then be ignored. You can then Ignore Unimportant Differences in the toolbar, where you can then set the Display Filters to only Show Differences, which then wouldn't show these Rows if they only have Unimportant differences.

    You can also open your Excel files in the Text Compare. This loses the ability to see them as Rows/Columns, but has more advanced grammar definition. You would need to download the additional File Format for Excel as a text format, we do not include it by default:
    http://www.scootersoftware.com/downl..._moreformatsv4

    And the types of grammar elements you can define in the Text Compare is here:
    http://www.scootersoftware.com/suppo..._unimportantv3
    Aaron P Scooter Software

  3. #3
    Join Date
    Apr 2015
    Location
    So.Cal.
    Posts
    88

    Default

    ok, thx.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •