table
table copied to clipboard
docs: add Excel-like sorting guide for null/undefined handling
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.