In Cell Mode the Sort operations sort headers as data

[jjasmith4]

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.

[Yutaka Emura]

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.

[jjasmith4]

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”?

[Author]

Posts