table icon indicating copy to clipboard operation
table copied to clipboard

docs: add Excel-like sorting guide for null/undefined handling

Open jiji-hoon96 opened this issue 4 months ago • 1 comments

Add comprehensive guide for Excel-like sorting behavior Include complete working example with TypeScript Reference community solution from issue #6061 Update API docs to clarify sortUndefined limitations

Refs: #6061

Summary by CodeRabbit

  • Documentation
    • Added a new guide on Excel-like sorting to consistently place empty cells (null/undefined) at the bottom across sort directions, with a custom sorting function and full React example.
    • Clarified that sortUndefined only affects undefined values, not null, and linked to the Excel-like Sorting Guide for handling both.
    • Included step-by-step instructions, global configuration tips, and best practices for normalizing empty values and customizing cell display.

jiji-hoon96 avatar Sep 02 '25 02:09 jiji-hoon96