\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, but the canonical form is "#ccff00".

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

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

bold

Sets the cell font to bold, if set to true.

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, but the canonical form is "#ccff00".

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value string

Example

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

enable

Disables the cell, if set to false.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value boolean

Example

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

fontFamily

The font family for 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.See Create or delete 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, e.g. 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

Sets the cell font to italic, if set to true.

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

Sets the cell font to underline, if set to true.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value boolean

Example

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

validation

The validation rule 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

Will wrap the cell content if set to true.

Returns

\Kendo\UI\SpreadsheetSheetRowCell

Parameters

$value boolean

Example

<?php
$cell = new \Kendo\UI\SpreadsheetSheetRowCell();
$cell->wrap(true);
?>
Is this article helpful? Yes / No
Thank you for your feedback!

Give article feedback

Tell us how we can improve this article

close
Dummy