Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.1   10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4    Statistic    FMM    Blog  

XL.Sheet.CellWriteTextAsNumber

Writes a number into cell, but passes it as text.

Component Version macOS Windows Linux Server iOS SDK
XL 10.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.CellWriteTextAsNumber"; bookRef; sheetIndex; Row; Column; Value { ; Format } )   More

Parameters

Parameter Description Example Flags
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-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
Value The new value to write. "123"
Format The format for the cell. This is index from 0 to XL.GetFormatCount-1 in the book's list of formats. 0 Optional

Result

Returns OK or error.

Description

Writes a number into cell, but passes it as text.
Avoids rounding errors with passing number as floating point value.

See also

Release notes

Blog Entries

Created 26th May 2020, last changed 26th May 2020


XL.Sheet.CellWriteText - XL.Sheet.CellWriteTexts

Feedback: Report problem or ask question.