XL.Sheet.CellIsStyledText
-------------------------

Queries whether cell has styled text.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [10.2](newinversion102.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.Sheet.CellIsStyledText"; BookRef; SheetIndex; Row; Column ) 

**MBS**( **"XL.Sheet.CellIsStyledText";** /\* Queries whether cell has styled text. \*/  
**$BookRef**; /\* The reference number for the workbook.e.g. $ref \*/   
**$SheetIndex**; /\* The index of the sheet. This number ranges from 0 to [XL.Book.SheetCount](XLBookSheetCount.md)-1.e.g. 0 \*/   
**$Row**; /\* The row for the cell. First row has index 0. \*/   
**$Column**) /\* The column for the cell. First column has index 0. \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference number for the workbook. | $ref |
| SheetIndex | The index of the sheet. This number ranges from 0 to [XL.Book.SheetCount](XLBookSheetCount.md)-1. | 0 |
| Row | The row for the cell. First row has index 0. | $row |
| Column | The column for the cell. First column has index 0. | $column |

### Result

Returns 1, 0 or error.

### Description

Queries whether cell has styled text.  
Returns 1 for styled text or zero for plain text.  
### Examples

Read whether cell has styled text:

 Set Variable \[$b ; Value: MBS ( "XL.Sheet.CellIsStyledText"; $bookRef ; $sheetIndex ; $Row ; $Column ) \]  
### See also

- [XL.Book.SheetCount](XLBookSheetCount.md)
- [XL.Sheet.CellReadStyledText](XLSheetCellReadStyledText.md)
- [XL.Sheet.CellWriteStyledText](XLSheetCellWriteStyledText.md)
- [XL.Sheet.CellWriteText](XLSheetCellWriteText.md)

### Release notes

- **Version 10.2**
    - Added [XL.Sheet.CellIsStyledText](https://www.mbsplugins.eu/XLSheetCellIsStyledText.shtml), [XL.Sheet.CellReadStyledText](https://www.mbsplugins.eu/XLSheetCellReadStyledText.shtml) and [XL.Sheet.CellWriteStyledText](https://www.mbsplugins.eu/XLSheetCellWriteStyledText.shtml) functions.

### Blog Entries

- [News about the MBS FileMaker Plugin 10.2](https://www.mbsplugins.de/archive/2020-05-19/News_about_the_MBS_FileMaker_P/monkeybreadsoftware_blog_filemaker)
- [Neues MBS FileMaker Plugin 10.2](https://www.mbsplugins.de/archive/2020-05-12/Neues_MBS_FileMaker_Plugin_102/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin 10.2 - More than 6200 Functions In One Plugin](https://www.mbsplugins.de/archive/2020-05-12/MBS_FileMaker_Plugin_102_-_Mor/monkeybreadsoftware_blog_filemaker)
- [Use formatted text in Excel files with FileMaker and LibXL](https://www.mbsplugins.de/archive/2020-04-23/Use_formatted_text_in_Excel_fi/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 10.2pr4](https://www.mbsplugins.de/archive/2020-04-20/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 18th April 2020 , last changed 19th April 2020

  
[XL.Sheet.CellIsFormula](XLSheetCellIsFormula.md) - [XL.Sheet.CellReadBlank](XLSheetCellReadBlank.md)

[HTML Version](XLSheetCellIsStyledText.shtml)