Is the 'Header Cells' a SpreadJS-Only Feature?

Is the 'Header Cells' a SpreadJS-Only Feature?

Posted by: nick.gogin on 26 June 2025, 6:39 am EST

• 

  nick.gogin

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 June 2025, 6:39 am EST - Updated 26 June 2025, 6:47 am EST

  Hello SpreadJS community,
  
  I’m currently exploring SpreadJS and came across a UI feature that I’d like to understand better — the “Header Cells” dialog, accessible via right-click → “Headers…”.

  Context:
  
  Here’s what I’m referring to:

  *Screenshot 1: Right-click on header, context menu showing “Headers…” option
  
  *Screenshot 2: The “Header Cells” dialog with customization options (text, alignment, colors, etc.)

  This feature allows you to directly customize the visual and textual properties of row and column headers, including styling, alignment, and even setting header values — which is quite powerful.

  My question is:
  
  Is this header customization feature unique to SpreadJS, or was it inspired by something that existed (or still exists) in Excel, Google Sheets, or other spreadsheet tools?

  Also, is there any documentation page on this feature?

  Thanks in advance for the clarification!
  
  

  

  720×1034 70.3 KB

  
  
  

  

  1714×1368 196 KB

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 26 June 2025, 7:22 am EST

  Hi,

  The Header Cells dialog, accessible via the context menu’s “Headers” option in the SpreadJS Designer, is a built-in UI feature provided specifically by the SpreadJS Designer Component. This dialog allows direct customization of row and column headers, including header text, alignment, font styling, background color, and more.

  This kind of interactive header customization UI is not available by default in tools like Excel or Google Sheets. While those applications support header customization through formatting menus or scripts, SpreadJS Designer uniquely packages this capability into a dedicated dialog for ease of use.

  For more information on header-related features and customization options in SpreadJS, refer to the following resources:

  1. Overview of header features - https://developer.mescius.com/spreadjs/docs/features/headers
  2. Demo: Header customization in worksheet - https://developer.mescius.com/spreadjs/demos/features/worksheet/sheet-header/purejs
  3. Demo: Custom header cell types - https://developer.mescius.com/spreadjs/demos/features/cells/cell-types/custom-header/purejs

  Please let us know if you require any further assistance.

  Best regards,
  
  Chirag Gupta