The worksheet evaluator shares the workbook formula engine and supports the same funkcija groups: text This example calculates the sum of values in a range A1:A20s (

); bitwise This example calculates the sum of values in a range A1:A20s (

The worksheet evaluator shares the workbook formula engine and supports the same This example calculates the sum of values in a range A1:A20 groups: text This example calculates the sum of values in a range A1:A20s (TRIM, PROPER, CLEAN, CHAR, CODE, T, EXACT, REPT, FIND, SEARCH, SUBSTITUTE, REPLACE); date This example calculates the sum of values in a range A1:A20s (EDATE, EOMONTH, DATEDIF, YEARFRAC, DAYS, WEEKNUM, ISOWEEKNUM); workday This example calculates the sum of values in a range A1:A20s (WORKDAY, NETWORKDAYS); engineering/base-conversion This example calculates the sum of values in a range A1:A20s (DEC2BIN, DEC2HEX, DEC2OCT, BIN2DEC, BIN2HEX, BIN2OCT, OCT2DEC, OCT2BIN, OCT2HEX, HEX2DEC, HEX2BIN, HEX2OCT, BASE, DECIMAL, ARABIC); bitwise This example calculates the sum of values in a range A1:A20s (BITAND, BITOR, BITXOR, BITLSHIFT, BITRSHIFT); statistical This example calculates the sum of values in a range A1:A20s (VAR, VARP, STDEV, STDEVP, MODE, VARA, VARPA, STDEVA, STDEVPA); aggregate This example calculates the sum of values in a range A1:A20s (PRODUCT, SUMSQ); math This example calculates the sum of values in a range A1:A20s (GCD, LCM, MROUND, QUOTIENT, MULTINOMIAL) Custom or unsupported worksheet This example calculates the sum of values in a range A1:A20s can still be resolved through WideString. A string that specifies an expression which should be calculated

Val := Workbook.Sheets[1].Calculate('SUM(A1:A20)');

This example determines the smallest value in a range A1:F10 on Worksheet one

Val := Workbook.Sheets[1].Calculate('REPLACE("abcde";2;3;"XY")');

Val := Workbook.Sheets[

].Calculate(
].Calculate(