ValueFormat enumeration (JavaScript API for Office v1.1)

JavaScript API for Office v1.1

Specifies whether values, such as numbers and dates, returned by the invoked method are returned with their formatting applied.

Last modified: June 12, 2014

Office.ValueFormat

Values

Enumeration

Value

Description

Office.ValueFormat.Formatted

"formatted"

Return formatted data.

Office.ValueFormat.Unformatted

"unformatted"

Return unformatted data.

For example, if the valueFormat parameter is specified as "formatted", a number formatted as currency, or a date formatted as mm/dd/yy in the host application will have its formatting preserved. If the valueFormat parameter is specified as "unformatted", a date will be returned in its underlying sequential serial number form.

App types

Content apps, Task pane apps

Supported clients

Excel 2013, Excel Online, Excel 2013 SP1, Excel 2013 RT, Word 2013, Word 2013 SP1, Word 2013 RT, Project Professional 2013, and Project 2013 SP1

Library

Office.js

Namespace

Office

Show:
© 2014 Microsoft