FireDAC Components for Excel Online

Build 21.0.7930

ValueInputOption

Determines how the provider parses values the user submits to Excel Online.

Syntax


property ValueInputOption: String;

Possible Values

UserEntered, Raw

Data Type

String

Default Value

"UserEntered"

Remarks

Determines how the component parses values the user submits to Excel Online.

RawThe values the user has entered will not be parsed and will be stored as-is.
UserEnteredThe values will be parsed as if the user typed them into the UI. Numbers will stay as numbers, but strings may be converted to numbers, dates, etc., following the same rules that are applied when entering text into a cell via the Excel Online UI.

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