allowCellOverflow Method

Gets or sets a value that indicates whether data can overflow into adjacent empty cells.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var returnValue; // Type: Object
returnValue = instance.allowCellOverflow(value);

function allowCellOverflow( 
   value : boolean
) : Object;

Parameters

value: Whether data can overflow.

Return Value

true if data can overflow; otherwise, false.

Example

This example uses the allowCellOverflow method.

Javascript

sheet.allowCellOverflow(true);
sheet.getCell(0,3, GcSpread.Sheets.SheetArea.viewport).hAlign(GcSpread.Sheets.HorizontalAlign.left);
sheet.getCell(1,3, GcSpread.Sheets.SheetArea.viewport).hAlign(GcSpread.Sheets.HorizontalAlign.center);
sheet.getCell(2,3, GcSpread.Sheets.SheetArea.viewport).hAlign(GcSpread.Sheets.HorizontalAlign.right);
sheet.getCell(3,3, GcSpread.Sheets.SheetArea.viewport).hAlign(GcSpread.Sheets.HorizontalAlign.general);
sheet.setValue(0,3,"Horizontal Align is left",3);
sheet.setValue(1,3,"Horizontal Align is center",3);
sheet.setValue(2,3,"Horizontal Align is right",3);
sheet.setValue(3,3,"Horizontal Align is general",3);

Remarks

The default value is false.

Reference

Sheet type
Allowing Cell Overflow