1. Feedback
  2. JavaScript
  3. 24392

Welcome to the JavaScript feedback portal. We’re happy you’re here! If you have feedback on how to improve the JavaScript, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

2
Votes

Add support for applying formatting to an entire column in an optimized way

Feature Description

Introduce end-to-end support for applying formatting to entire columns in the Spreadsheet component via both UI and API. This feature enhances usability by enabling quick, consistent styling of full columns for font, colors, borders, number formats, and related text options. The feature addresses the need to efficiently format large swaths of data, ensuring consistency for existing and newly added cells.

Key Innovation: 

Implement a performance-optimized storage model that assigns styles at the

column-model level (in addition to the cell level), eliminating redundant styles across cells. This reduces the overall size of the generated Sheet Model JSON and dramatically improves import/export performance.


Scope includes:

  • Full-column selection via headers
  • Toolbar/ribbon integration for formatting operations
  • Context menu entry for quick access
  • Multi-column operations with Ctrl/Shift selection
  • Persistence with undo/redo support
  • Dynamic updates for inserted columns
  • Compatibility with conditional formatting and data validation
  • Optimized import/export that detects and stores styles column-wise, emitting column default styles rather than per-cell repetition
  • Import/export preservation across Excel, CSV, and other formats

Reference: