This gap between an underlying value and the formatted display in the Excel UI can result in confusion and errors during add-in calculations. The underlying number value is not changed, even when a cell in the Excel UI is formatted as currency or a date. The Excel UI formatting layer is capable of adding currency, date, and other types of formatting to cells that contain the four original data types, but this formatting layer only controls the display of the original data types in the Excel UI. Prior to the data types addition, the Excel JavaScript API supported string, number, boolean, and error data types. You can also explore the Script Lab samples in our OfficeDev/office-js-snippets repository. To start experimenting with data types right away, install Script Lab in Excel and check out the Data types section in our Samples library.
0 kommentar(er)
