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

Hidden rows and columns

Any row or columns can be hidden using hiddenColumns or hiddenRows attribute in sheets

const sheets = [
{
name: 'Sheet 1',
id: 1,
hiddenRows: [2],
hiddenColumns: [2],
cells: {
1: {
1: {
text: 200.00,
format: '\\S$ #.00'
}
}
}
},
]
<SpreadSheet initialSheets={sheets} />
Edit this page
Previous
« Tooltips
Next
Row and column Sizing »

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.