Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Spreadsheet > Visual Elements > Dialogs > PivotTable Solve Order Dialog
All docs
V24.1
WinForms Controls
.NET/.NET Core Support
Prerequisites
What's Installed
Build an Application
Controls and Libraries
Forms and User Controls
Messages, Notifications, and Dialogs
Editors and Simple Controls
Ribbon, Bars and Menu
Application UI Manager
Docking Library
Data Grid
Vertical Grid
Property Grid
Pivot Grid
Tree List
Gantt Control
Chart Control
Diagrams
Gauges
Map Control
Scheduler
Spreadsheet
Product Information
Spreadsheet Control API
Get Started
Spreadsheet Document
Supported Formats
Cell Basics
Formulas
Defined Names
Data Binding
Data Validation
Data Presentation
Data Grouping
Tables
Pivot Tables
Charts and Graphics
Form Controls
Printing
Events
Mail Merge
Protection
Operation Restrictions
Find and Replace
Visual Elements
Formulas
Name Box
Pop-Up Menus
Dialogs
Format Cells Dialog
Paste Special Dialog
Edit Hyperlink Dialog
Symbol Dialog
Create Table Dialog
Change Chart Type Dialog
Find and Replace Dialog
Encrypt Document Dialog
Password Dialog
Protect Workbook Dialog
Protect Sheet Dialog
User Permissions Dialog
Insert Function Dialog
Function Arguments Dialog
Name Manager
New Name Dialog
Create Names from Selection Dialog
Subtotal Dialog
Data Validation Dialog
Properties Dialog
Page Setup Dialog
Print Preview Dialog
Header and Footer Dialog
Create PivotTable Dialog
Move PivotTable Dialog
Change PivotTable Data Source Dialog
PivotTable Field List
PivotTable Field Settings Dialog
PivotTable Value Field Settings Dialog
PivotTable Sort Dialog
Insert Calculated Field Dialog
Insert Calculated Item Dialog
PivotTable Solve Order Dialog
PivotTable Options Dialog
New Formatting Rule Dialog
Conditional Formatting Rules Manager
Services
Keyboard Shortcuts
Examples
Rich Text Editor
Spell Checker
Form Layout Managers
Navigation Controls
Printing-Exporting
PDF Viewer
Reporting
Office File API
Snap
TreeMap Control
Sunburst Control
Sankey Diagram Control
Heatmap Control
Common Features
Security Considerations
UI Templates
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

PivotTable Solve Order Dialog

The Solve Order dialog allows end-users to specify the formula used to determine the cell value affected by multiple calculated items.

XtraSpreadsheet_Dialogs_SolveOrder

End-users can invoke this dialog by:

  • Selecting a cell with a miscalculated value;

  • Clicking the Solve Order… item in the Fields, Items, & Sets drop-down menu. Add the Calculations ribbon group to enable this button (refer to the Getting Started for details on how to provide a Ribbon UI for the SpreadsheetControl).

    XtraSpreadsheet_Dialogs_SolveOrder_Ribbon

The Solve Order dialog lists formulas for all calculated items in the PivotTable report. Only the last formula in the list is used to calculate the target cell value. End-users can reorder formulas in the list using the Move Up and Move Down buttons. Clicking the Delete button removes the selected calculated item.

See Also