Auto Label Row Cell Formula support


Version: 2026b

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-12257


If user add column label row with formula with parameter (this), when adding new columns, such formula will be applied to new columns.

Using mean formula as an example.

  1. Click any column label row header and choose P button on mini toolbar to add User Parameter.

  2. Choose Formula Mean.
    --> Mean row will be added in worksheet to show mean value of each column. If you double click the last mean cell, it shows =mean(This)

  3. Add new columns and fill with data.
    --> Mean value will be auto calculated in new columns as well.

To turn this feature off, set system variable @ALFN=0