FireDAC Components for Excel Online

Build 21.0.7930

ValueRenderOption

Determines how the provider renders values in the output.

Syntax


property ValueRenderOption: String;

Possible Values

FormattedValue, UnformattedValue, Formula

Data Type

String

Default Value

"FormattedValue"

Remarks

Determines how the component 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". For this reason, every column containing a formula will be exposed as String type regardless of the set TypeDetectionScheme.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930