CData ADO.NET Provider for Excel Online 2019J - Online Help

Value Render Option

CData ADO.NET Provider for Excel Online 2019J - Build 19.0.7354

Determines how the provider renders values in the output.

データ型

string

デフォルト値

"FormattedValue"

解説

Determines how the 本製品 renders values in the output.

FormattedValueValues will be calculated and formatted in the reply according to the cell's formatting. Formatting is based on the workbook's locale, not the requesting user's locale. For example, if A1 is 1.23 and A2 is "=A1" and formatted as currency, then A2 would return "$1.23".
UnformattedValueValues will be calculated but not formatted in the reply. For example, if A1 is 1.23 and A2 is "=A1" and formatted as currency, then A2 would return the number 1.23.
Formula Values will not be calculated and instead the reply will include the formulas. For example, if A1 is 1.23 and A2 is "=A1" and formatted as currency, then A2 would return "=A1".

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0