Gridlines

Gridlines are visual elements in spreadsheets used to distinguish cells. They help users view and organize data more easily. Univer provides functionality to show and hide gridlines, as well as the ability to set the color of gridlines.

Facade API

Toggle Gridlines Visibility

TypeScript

const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet()// Hide gridlinesfWorkSheet.setHiddenGridlines(true)// Show gridlinesfWorkSheet.setHiddenGridlines(false)

Get Current Gridlines Visibility Status

TypeScript

const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet()// Check if gridlines are hiddenif (fWorkSheet.hasHiddenGridLines()) {  console.log('Gridlines are hidden')}

Set Gridlines Color

TypeScript

const fWorkSheet = univerAPI.getActiveWorkbook().getActiveSheet()// Set gridlines color to redfWorkSheet.setGridLinesColor('#ff0000')console.log(fWorkSheet.getGridLinesColor()) // #ff0000

How is this guide?