The Exontrol eXPivot tool provides a powerful way to summarize and analyze data, similar to a pivot table.
It can automatically sort, count, total, or calculate averages from the data in a table or spreadsheet.
Users can set up and modify the summary structure by dragging and dropping fields interactively.
The eXPivot component also allows users to customize its appearance with skins, each offering a unique visual experience that enhances usability and presentation.
|
First Look of eXPivot:
|
|
Features of eXPivot include:
|
- Skinnable Interface support (ability to apply a skin to any background part)
- Easy way to define the control's visual appearance in design mode, using XP-Theme elements or EBN objects
- PDF, BMP, JPG, GIF, PNG, TIFF, EMF support (Ability to save/export the control's content to PDF, BMP, JPG, GIF, PNG, TIFF, EMF formats)
- Interactive context menu to define the format to be displayed, including the colors, font, and so on
- Summarizes the data by Drag and Drop, or by code
- Ability to import data from ADO/DAO datasource/datacontext, TXT, XML or by drag and drop from other sources
- Export data as TXT, CSV, XML, EMF or by drag and drop
- Ability to drag/filter the values of a column to the pivot bar, so the chart displays the associated function by value
- SUM, AVG, COUNT, MIN or MAX implementation, for numbers, string or date expressions
- Ability to display multiple aggregate functions on the same cell
- Ability to add new aggregate functions, using built-in predefined operators
- Total / Subtotal rows support
- Automatically update the Total/Subtotal rows, once a filter is applied, so the aggregate rows reflect the visible data only
- Computed fields support
- Undo / Redo support
- Easy way to save / restore the control's layout, column positions and size, sorting, filtering, scrolling and so on
- Ability to define the content of the columns / rows context menu
- Compact or Expanded mode support
- FilterBar / FilterPrompt support
- Built-in HTML, Decorative Text, Tooltip, Mouse Wheel, Icons, Pictures support and more
- Print and Print-Preview support, including Fit-To-Page
|
|
General information about eXPivot product:
|
Identifier:
|
Exontrol.Pivot, exontrol.EXPIVOTLib.expivot, wpf.exontrol.EXPIVOTLib.expivot
|
Version:
|
19.0.0.2
|
Files:
|
expivot.dll, expivot.ocx, exontrol.expivot.dll, expivot.net, wpf.exontrol.expivot.dll, expivot.wpf
|
Available As:
|
|
Available since:
|
2013129
|
Compatible with:
|
Access, AutoIt, C#, C++, Clarion, Delphi, Dynamics AX, Dynamics NAV, FORTH, HTML, LabVIEW, Lotus Notes, Power++, PowerBuilder, Progress, Smalltalk, twinBASIC, VB, VB.NET, VB6, VBA, Visual Objects, VFP, VFP Advanced (x64), xBasic, X++, Xbase++, uniPaas (eDeveloper)
|
Lines of code:
|
237,059 (205,068 excluding comments and empty lines)
|
Includes:
|
Objects 12, Functions 373, Events 13, Definitions 29
|
See Also:
|
|
|
Shortcut links:
|
|