Tagged: advanced-sort cell-mode
- AuthorPosts
- May 3, 2017 at 8:51 am #21747jjasmith4Participant
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.
May 3, 2017 at 9:09 am #21748Yutaka EmuraKeymasterYou 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.
May 3, 2017 at 9:57 am #21749jjasmith4ParticipantOK, 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”?
- AuthorPosts
- You must be logged in to reply to this topic.