This topic has not yet been rated - Rate this topic

ValueFormat enumeration (apps for Office)

apps for SharePoint

Published: February 26, 2013

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

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.

Supported clients

Excel 2013, Excel Web App, Word 2013, and Project Professional 2013

Library

Office.js

Namespace

Office

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.