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: 9.0   9.1   9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3    Statistic  

XL.Sheet.CellWriteTextAsNumber

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

Component Version macOS Windows Server FileMaker Cloud FileMaker 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 value
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 Optional
The format for the cell. This is index from 0 to XL.GetFormatCount-1 in the book's list of formats.
0

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

Blog Entries

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


XL.Sheet.CellWriteText   -   XL.Sheet.CellWriteTexts

Feedback: Report problem or ask question.




Links
MBS FileMaker Plugins