FireDAC Components for Excel Online

Build 21.0.7930

AllowFormula

Whether or not to treat values starting with an equals (=) sign as formulas during inserts and updates.

Syntax


property AllowFormula: Boolean;

Data Type

Boolean

Default Value

true

Remarks

Set this value to true to treat values beginning with an equals (=) sign as formulas on inserts and updates. Set the value to false to treat all values used in inserts and updates as strings.

For example, with AllowFormula set to true, the following will insert a formula into the B column that will sum cells B1:B5:

INSERT INTO Excel_Sheet (A, B) VALUES ('Bill', '=SUM(B1:B5)')

Note: If True, 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