\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');
?>
html
If set to true, renders the cell value as HTML. It is important to sanitize the value of the cell on the server for passing safe html because there is no client-side sanitizing. When editing a cell the new value can be checked and prevented in the client changing event.
Returns
\Kendo\UI\SpreadsheetSheetRowCell
Parameters
$value boolean
Example
<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->html(true);
?>
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);
?>
link
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);
?>