- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
-
Features
- Workbook
- Worksheet
- Rows and Columns
- Headers
- Cells
- Data Binding
- TableSheet
- GanttSheet
- JSON Schema with SpreadJS
- SpreadJS File Format
- Data Validation
- Conditional Formatting
- Sort
- Group
- Formulas
- Serialization
- Keyboard Actions
- Shapes
- Form Controls
- Floating Objects
- Barcodes
- Charts
- Sparklines
- Tables
- Pivot Table
- Slicer
- Theme
- Culture
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
Sheet Area Offset
SpreadJS allows users to ensure that the entire sheet is rendered completely. You can configure sheet area offset in order to ensure that the left/top borders, gridlines, double lines and selection border of first column/row is rendered completely when the row header or the column header is hidden.You can move the sheet area by setting the offset from the host left or top point as per your requirements. By default, the value is {left:0, top:0} in order to keep the downward compatibility.
The following image illustrates the significance of setting the sheet area offset in a worksheet.
Shared below is a table that describes different scenarios along with their descriptions that you may need to refer while working with sheet area offset in a spreadsheet:
Scenario | Description |
|---|---|
When the row header is visible | The first column refers to the first visible column of the row header.The selection border renders completely. |
When the row header is hidden | The first column refers to the left column of the viewport.The selection left border will not be clipped and can be rendered completely.The double lines in left will be rendered partially. |
When the column header is visible | The first row refers to the first visible row of the column header.The selection border renders completely. |
When the column header is hidden | The first row refers to the top row of the viewport.The selection top border will not be clipped and can be rendered completely.The double lines in top will be rendered partially. |
When the selection starts from first row/column | The left/top selection border will be lost. |
When the worksheet has row outlines or column outlines | The double line is not rendered completely.The selection border will be rendered completely covering the outline area. |
While printing the worksheet | If the print option: showBorder is set to false, and the sheet option: sheetAreaOffset contains the default value, it will set the offset to 2 pixels for rendering the double lines in left/top border.If the print option: showBorder is set to true, the behavior will remain same as before. |
While scrolling the worksheet in touch-enabled devices | The double lines in left or top will always be rendered besides the sheet.The left or top border can be rendered completely. |
Using Code
This example shows how to set the sheet area offset in a worksheet.
sheet.options.sheetAreaOffset= {left : 2, top : 2};