- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
-
Features
- Workbook
- Worksheet
- Rows and Columns
- Headers
-
Cells
- Work with Cells
- Cell Types
- Cell Format
- Cell States
- Cell Range
- Get Dirty Status
- Cell Buttons
- Cell Dropdowns
- Cell Comments
- Hyperlink
- Auto Merge Cells
- AutoFit
- Auto Fill Data
- Mask Input
- Shrink to Fit
- Cell Overflow
- Ellipsis or Tips for Cell Overflow
- Cell Alignment and Indentation
- Cell Padding and Label Styles
- Cell Span
- Cell Tags
- Styles
- Cell Decoration
- Cell Colors
- Borders, Gridlines and Diagonal Lines
-
Quote Prefix
- Insert Cut or Copied Cells
- Rotate Text In Cells
- Vertical Text Direction
- Text Decoration
- Rich Text
- Wrap Text
- Drag and Drop
- Drag and Merge
- Edit Mode Always
- Watermark
- Display Zero as Blank
- IME Mode
- Pattern Fill and Gradient Fill
- Paste Options
- 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
Quote Prefix
The quote prefix feature in SpreadJS works in a similar way as Excel does. You can use a single quote to store a string value without parsing. When a user inputs a value in a cell with quote prefix ' (single quote), the input value will be converted and stored as a string.
The following images show how the quote prefix works in a SpreadJS worksheet. The image on the left shows cell B3 in edit mode and the image on the right shows the same cell in display mode.
You can still display a single quote in the text by typing the single quote twice.
The image on the right displays the result of typing two single quotes when the cell is no longer in the edit mode.
While working with the quote prefix in SpreadJS, you can also perform the copy and paste operations on cells, and execute the drag fill and drag and move operations in a spreadsheet.
Note: Formatter will not take any effect when you use quote prefix in cells. Also, the Quote Prefix feature in SpreadJS doesn't provide support for copy from Excel and copy to Excel operations.