Recalculation Button in Worksheets

Overview

This feature enhances error management and recalculation workflows in worksheet data projections. Users can now easily identify calculation errors, sort and group by calculation status, and trigger recalculation for any row or selection directly from the UI.

Key Features

Visual Feedback for Errors

• Data projection rows with calculation errors are highlighted in red in the worksheet grid for immediate visibility.

Calculation Status Property

• A new property, Calculation Status, is available in the Arrange Panel.

• Drag Calculation Status into the Rows section to add a column showing each row’s status: Completed or Error.

• The Calculation Status column supports sorting, so you can group or order rows by their calculation state.

Recalculation Actions

• Context Menu: Right-click any row to access a dropdown menu with a new Recalculate option (alongside Delete).

• 

• Toolbar Button: A new toolbar button triggers recalculation for all selected rows.

• 

• Both methods support multi-row selection for bulk recalculation.

• Recalculation can be triggered for any row, regardless of its current status.

Spinner and Row Update

• When recalculation is triggered (via context menu or toolbar), a spinner appears on affected rows.

• After recalculation completes, the rows update with the default animation.

How to Use

1. Identify Errors: Rows with calculation errors are highlighted in red. If a recalculation fails (e.g., server error 500), an error message will be shown. For persistent issues, contact Centage Support.

2. Add Calculation Status Column:

   • Open the Arrange Panel.

   • Drag Calculation Status into the Rows section.

   • Use the column to view and sort by status.

3. Recalculate Rows:

   • Select one or more rows.

   • Right-click and choose Recalculate, or use the toolbar button.

   • A spinner will indicate recalculation is in progress.

   • Rows update automatically when done.