\Kendo\UI\SpreadsheetSheetRowCell

A PHP class representing the cell setting of SpreadsheetSheetRowCells.

Methods

background

The background color of the cell. Many standard CSS formats are supported. However, the canonical form is #ccff00.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->background('value');
?>

bold

If set to true, sets the cell font to bold.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value boolean

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->bold(true);
?>

borderBottom

The style information for the bottom border of the cell.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value \Kendo\UI\SpreadsheetSheetRowCellBorderBottom|array

Example - using \Kendo\UI\SpreadsheetSheetRowCellBorderBottom

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$borderBottom = new \Kendo\UI\SpreadsheetSheetRowCellBorderBottom();
$color = 'value';
$borderBottom->color($color);
$cell->borderBottom($borderBottom);
?>

Example - using array

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$color = 'value';
$cell->borderBottom(array('color' => $color));
?>

borderLeft

The style information for the left border of the cell.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value \Kendo\UI\SpreadsheetSheetRowCellBorderLeft|array

Example - using \Kendo\UI\SpreadsheetSheetRowCellBorderLeft

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$borderLeft = new \Kendo\UI\SpreadsheetSheetRowCellBorderLeft();
$color = 'value';
$borderLeft->color($color);
$cell->borderLeft($borderLeft);
?>

Example - using array

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$color = 'value';
$cell->borderLeft(array('color' => $color));
?>

borderRight

The style information for the right border of the cell.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value \Kendo\UI\SpreadsheetSheetRowCellBorderRight|array

Example - using \Kendo\UI\SpreadsheetSheetRowCellBorderRight

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$borderRight = new \Kendo\UI\SpreadsheetSheetRowCellBorderRight();
$color = 'value';
$borderRight->color($color);
$cell->borderRight($borderRight);
?>

Example - using array

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$color = 'value';
$cell->borderRight(array('color' => $color));
?>

borderTop

The style information for the top border of the cell.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value \Kendo\UI\SpreadsheetSheetRowCellBorderTop|array

Example - using \Kendo\UI\SpreadsheetSheetRowCellBorderTop

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$borderTop = new \Kendo\UI\SpreadsheetSheetRowCellBorderTop();
$color = 'value';
$borderTop->color($color);
$cell->borderTop($borderTop);
?>

Example - using array

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$color = 'value';
$cell->borderTop(array('color' => $color));
?>

color

The font color of the cell. Many standard CSS formats are supported. However, the canonical form is #ccff00.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->color('value');
?>

comment

The comment of the cell - a tooltip that appears when the cell is hovered.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->comment('value');
?>

enable

If set to false, disables the cell.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value boolean

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->enable(true);
?>

fontFamily

The font family of the cell.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->fontFamily('value');
?>

fontSize

The font size of the cell in pixels.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value float

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->fontSize(1);
?>

format

The format of the cell text. For more information, refer to the article on creating or deleting a custom number format on MS Office.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->format('value');
?>

formula

The cell formula without the leading equals sign, for example, A1 * 10.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->formula('value');
?>

index

The zero-based index of the cell. Required to ensure correct positioning.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value float

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->index(1);
?>

italic

If set to true, sets the cell font to italic.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value boolean

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->italic(true);
?>

The hyperlink (URL) of the cell.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->link('value');
?>

textAlign

Specifies the text alignment in the cell

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->textAlign('value');
?>

underline

If set to true, sets the cell font to underline.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value boolean

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->underline(true);
?>

validation

The validation rule that is applied to the cell.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value \Kendo\UI\SpreadsheetSheetRowCellValidation|array

Example - using \Kendo\UI\SpreadsheetSheetRowCellValidation

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$validation = new \Kendo\UI\SpreadsheetSheetRowCellValidation();
$allowNulls = true;
$validation->allowNulls($allowNulls);
$cell->validation($validation);
?>

Example - using array

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$allowNulls = true;
$cell->validation(array('allowNulls' => $allowNulls));
?>

value

The cell value.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value float|string|boolean|date

Example - using float

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->value(1);
?>

Example - using string

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->value('value');
?>

Example - using boolean

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->value(true);
?>

Example - using date

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->value(new date());
?>

verticalAlign

Specifies the text vertical alignment in the cell

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->verticalAlign('value');
?>

wrap

If set to true, wraps the cell content.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value boolean

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->wrap(true);
?>
In this article
Not finding the help you need?