Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #21747

    jjasmith4
    Participant

    When I’m working on a CSV/TSV file, unless I deliberately select from the second row to end of file, and then in the Advanced Sort dialog box make sure “In Selection Only” is checked on (which should happen automatically, as it does in the Find/Replace dialog box), the Advanced Sort operation sorts headers as data. It should be possible to freeze the headers, as one can do in Excel, and Advanced Sort should have a “My data has headers” option, also like Excel’s, to ignore the top row when sorting.

    #21748

    Yutaka Emura
    Keymaster

    You can select the number of headings in the Heading button in the CSV/Sort toolbar. Alternatively, you can specify the “Lines of headings” text box in the CSV page of the Customize dialog box.

    #21749

    jjasmith4
    Participant

    OK, got it. To me it’s unclear what the button’s tooltip “Heading” and the choices’ tooltips “Heading (0-4)” mean. How about “Heading rows (n)”, where n is the current setting, and “(0-4) heading rows”?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Share with friends... Tweet about this on TwitterShare on FacebookShare on Google+Email this to someone