Menu
Rows n' ColumnsRows n' ColumnsDocumentationFeaturesPricingContact
ChatGitHub
Rows n' ColumnsRows n' Columns
  • Documentation
  • Features
  • Pricing
  • Contact
  • Chat
  • GitHub
  • Spreadsheet
    • Introduction
    • License
    • Formula (beta)
    • Data Formatting
    • Roadmap
    • Credits
  • Getting Started
    • Installation
    • Controlled/Uncontrolled mode
    • Managing state - Controlled mode
    • Configuration
  • Features
    • Initialization
    • Sheets
    • Custom formatting
    • Custom Validation
    • Using images in cells
    • Tab Strip
    • Status Bar
    • Gridlines
    • Cell Renderer
    • Borders
    • Fonts
    • Undo/Redo
    • Selection modes
    • Context menu
    • Scroll Snap
    • UI Customizations
    • Data Validation
    • Datatypes
    • Tooltips
    • Hidden rows and columns
  • Examples
    • Row and column Sizing
    • Frozen rows and columns
    • Merging cells
    • Styling
    • Custom editors
    • Conditional formatting
    • Range Selection
    • AutoFilter views
    • Excel Import/Export
    • CSV Import/Export
    • Hide Sheet Headers
  • Advanced
    • Using ref
    • State reducer

Range Selection

Multiple selection is enabled by default. You can disable it by setting selectionPolicy to single

Example#

<SpreadSheet selectionPolicy='single'>

Callback on Active cell change#

<SpreadSheet
onActiveCellChange={(sheetId: string, cell: CellInterface) => {
console.log(cell.rowIndex, cell.columnIndex)
}}
>

Callback on selection change#

<SpreadSheet
onSelectionChange={(sheetId: string, activeCell, selections: CellInterface) => {
console.log(selections)
}}
>
Edit this page
Previous
« Conditional formatting
Next
AutoFilter views »
  • Example
  • Callback on Active cell change
  • Callback on selection change

Docs

  • What is Spreadsheet
  • Examples
  • Features

Community

  • Discord
  • Twitter

More

  • Privacy policy
  • Terms of use
  • GitHub
Copyright © 2020 Rows n' Columns. Made in Sunny Singapore.