Skip to content

GroupFormula Property

Description

Excel-like calculations (i.e., sum of all rows) to be performed and displayed in the item's caption.

Property Type

Read-write property

Syntax (Visual Basic)

Public Property GroupFormula() As String

Remarks

Formula support for GridRecordItem.

If presented, the Item Caption will show the results of the calculations based on the given formula.

Examples

  • SUM(R2C3:R8C4) - given range
  • SUM(R*C3:R*C4) - means all rows (parent rows only in case of hierarchy)
  • SUM(R2C*:R8C*) - means all columns
  • SUM(R*C*:R*C*) - means all

The given item is always excluded from the loop - no circular references.

Similar for child records:

  • SUMSUB(R2C3:R8C4) - given range for children
  • SUMSUB(R*C3:R*C4) - means all child rows
  • SUMSUB(R2C*:R8C*) - means all columns
  • SUMSUB(R*C*:R*C*) - means all

Thus, the parent item can show subtotal, and the bottom item can show total by all.

If the user is doing data entry at runtime in an interactive way, they will need to press F5 to call ReCalc at the end to see the results.

You can call ReCalc at any time to recalculate the values in the cells.

See Also

Copyright (c) 1998-2024 Codejock Technologies. All rights reserved.