expivot - what's new

12.0.0.7 Nov 13, 2017
*Added: `MIN` and `MAX` binary-operators to get the MIN and MAX value. For instance, the expression `value MIN 10 MAX 100` returns always a value between 10 and 100.
*Added: `sin`, `asin`, `cos`, `acos` unary-operators to get the associated trigonometric functions. For instance `2 * asin(1)` returns the value of PI
*Added: `sqrt` unary-operator returns the square root of the element, so sqrt(81) returns 9, as 9^2 is 81
*Added: date(`now`) unary-operator returns the current date-time ( as double ), while the date(``) returns the current date ( no time included )

12.0.0.6 Sep 11, 2017
*NEW:   PDF (Portable Document Format) Support, or ability to export directly the control's content to a PDF file
*Added: The CopyTo property copies the control's content to PDF format, if the extension of the File argument indicates a pdf extension. For instance, the CopyTo("c:\temp\snapshot.pdf") property saves the control's content in PDF format to snapshot.pdf. The control's content is serialized as it would have no scroll bars. The File argument could indicates more parameters separated by | character, in the following order: filename.pdf | paper size | margins | options where the filename indicates the name of the pdf to be saved, the paper size indicates the size of the paper to be used ( by default A4 paper, 8.27 in x 11.69 in ), margins defines the paper's margins ( by default, 0.5 in 0.5 in 0.5 in 0.5 in ) and options currently can be single which indicates that whole control is saved to a single paged PDF document. For instance, the CopyTo("c:\temp\snapshot.pdf|||single") exports the control's content to single page.
*Added: Improves the performance to load data into the control.

12.0.0.5 Aug 02, 2017
*NEW:   BMP, JPG, GIF, PNG, TIFF, EMF Support (  Ability to save the control's content to BMP, JPG, GIF, PNG, TIFF, EMF formats )
*Added: The CopyTo property copies the control's content to BMP, PNG, JPG, TIF or GIF format. Previously, the CopyTo property can save the control's content to EMF format only. The extension of the File argument indicates the graphical format to be saved. For instance, the CopyTo("c:\temp\snapshot.png") property saves the control's content in PNG format to snapshot.png. If File parameter provides an unknown extension, the control's content is saved in EMF format ( Enhanced Metafile Format ). The control's content is serialized as it would have no scroll bars.
*Added: The exPivotBarReadOnly flag specifies that no change is allowed on pivot bar, so no column/total field can be dropped into the pivot bar ( Read-Only support )

12.0.0.4 May 17, 2017
*Added: Applies the Column.DefaultFormatContent property, when the control displays original data ( not only when displaying aggregate functions )
*Added: Applies the Column.DefaultFormatAppearances property, when the control displays original data ( not only when displaying aggregate functions )
*Added: Double-Clicking the separator between columns, makes the column to resize it, so its content is fully visible
*Fixed: Prevents showing the control's view in design mode, while running on FORTH system ( /COM version )

12.0.0.3 Apr 19, 2017
*NEW:   Ability to change the control's content menu visual appearance using EBN objects
*Added: Background(exContextMenuSelBackColor) property specifies the solid/EBN selection's background color in the control's context menu. The Background(exContextMenuSelBackColor) is valid while it is not zero.
*Added: Background(exContextMenuSelBorderColor) property specifies the solid color to show the selection in the control's context menu. The Background(exContextMenuSelBorderColor) is valid while it is not zero.
*Added: Background(exContextMenuSelForeColor) property specifies the selection's text foreground color in the control's context menu. The Background(exContextMenuSelForeColor) is valid while it is not zero.
*Added: Background(exContextMenuBackColor) property specifies the solid background color for the control's context menu. The Background(exContextMenuBackColor) is valid while it is not zero.
*Added: Background(exContextMenuForeColor) property specifies the text foreground color for the control's context menu. The Background(exContextMenuForeColor) is valid while it is not zero.

12.0.0.2 Mar 08, 2017
*NEW:   Support for EBN 1003 version.
*Added: EBN 1003 implements Colorable Region Support which defines a portion/region of the EBN object where the color of the EBN is applied. For instance, at runtime the identifier 0x1FF0000 applies blue color to all colorable parts that compose the EBN object. The EBN color is not applied to not-colorable portions of the EBNs.
*Added: FormatConditionalAppearance.ContextEditExpression indicates whether the item of the current conditional-format object in the control's content menu displays/edits the conditional expression, at runtime.
*Fixed: Applies content/appearance/conditional appearance of the first column, even if selecting second, third, ... columns when ShowViewCompact property is exViewCompact 

12.0.0.1 Feb 06, 2017
*NEW:   Conditional-Format Support, or ability to highlight values in the pivot giving an expression ( for instance, you can apply a foreground color for positive values only )
*Added: FormatConditionalAppearances property retrieves a collection of FormatConditionalAppearance object, that holds information about expression and font/colors to be applied on matching values.
*Added: FormatConditionalAppearance.Expression property specifies the expression that determines the value to apply the format. For instance, "value > 0" indicates all positive values in the pivot data.
*Added: PivotBarVisibleEnum.exPivotBarAllowFormatConditionalAppearance type specifies whether the Conditonal context menu is shown when user right-clicks the pivot data. ( PivotBarVisible property )

11.0.0.4 Dec 26, 2016
*Added: lfind binary-operator for format/expression. The a lfind b searches the first occurrence of the string b within string a, and returns -1 if not found, or the position of the result ( zero-index ). For instance, `ABCABC` lfind `D` returns -1, while  `ABCABC` lfind `C` returns 2.
*Added: rfind binary-operator for format/expression. The a rfind b searches the last occurrence of the string b within string a, and returns -1 if not found, or the position of the result ( zero-index ). For instance, `ABCABC` rfind `D` returns -1, while  `ABCABC` rfind `C` returns 5.
*Added: reverse unary-operator for format/expression. The reverse(a) reverses the order of the characters in the string a, For instance, the reverse("Mihai") returns "iahiM"
*Fixed: The DataColumn.SortType property has no effect if changing it after the Import / DataSource call.

11.0.0.3 Nov 02, 2016
*Added: Description property changes descriptions for control objects.
*Added: Prevents showing the ,.;!?'")}] characters at the beginning of a new line, when html text is word-wrapping.
*Fixed: The last italic character of a HTML caption may be shown as clipped
*Fixed: The Copy/CopyTo method does not shows the grouped/expandable columns.

11.0.0.2 Sep 12, 2016
*Added: PivotTotalDefaultFormatContent property specifies the default format (key of FormatContent object) to be applied on the Total field when it is displayed in the pivot-table. For instance, PivotTotalDefaultFormatContent property on "numeric" specifies that the Total displays it's data in numeric-format.
*Added: PivotTotalDefaultFormatAppearances property specifies the list of format-appearances ( key of FormatAppearance object), separated by comma, to be applied on the Total field when it is displayed in the pivot-table. For instance, PivotTableDefaultFormatAppearances property on "bold,italic" specifies that the Total field is displayed in bold and italic
*Added: Column.DefaultFormatContent property specifies the default format (key of FormatContent object) to be applied on the column when it is displayed in the pivot-table. For instance, Column.DefaultFormatContent property on "numeric" specifies that the column is displayed in numeric-format.
*Added: Column.DefaultFormatAppearances property specifies the list of format-appearances ( key of FormatAppearance object), separated by comma, to be applied on the column when it is displayed in the pivot-table. For instance, Column.DefaultFormatAppearances property on "bold,italic" specifies that the column is displayed in bold and italic. 

11.0.0.1 Jul 29, 2016
*NEW:   Exontrol Print Scale Support, Adjust To and Fit to Page Wide by Tall Support
*Added: Print.Options = "FitToPage = 75%", adjusts and prints the control's content to 75% of normal size.
*Added: Print.Options = "FitToPage = 2 x 3", indicates that the control's content is print to fit 2 pages wide by 3 tall.
*Added: Print.Options = "FitToPage = 2 x", indicates that the control's content is print to fit 2 pages wide by how many pages tall are required.
*Added: Print.Options = "FitToPage = x 3", indicates that the control's content is print to fit 3 pages tall to how many pages wide are required.

10.2.0.2 May 23, 2016
*NEW:   Ability to retrieve data/value from the cursor
*Added: ValueFromPoint(-1,-1) retrieves the value from the cursor.
*Added: ColumnFromPoint(-1,-1) returns the column from the cursor.
*Fixed: Prevents horizontal scrolling the control's content if the EnsureVisibleColumn is called for any locked column ( CountLockedColumns property ).
*Fixed: Prevents horizontal scrolling the control's content if the user clicks a locked column ( CountLockedColumns property ).

10.2.0.1 Apr 06, 2016
*NEW:   Ability to import/load/handle/display built-HTML within the columns
*Added: The Column.HTML property indicates whether the column handles/displays built-in HTML format.
*Added: The Version property for /NET or /WPF version returns more information about the component/assembly/file.
*Fixed: The control selects items to the cursor, if a short click occurs ( AutoDrag property is not empty, and the SingleSel property is False )

10.1.0.1 Jan 20, 2016
*NEW:   Windows 8 Touch/Pointer Support ( ability to scroll the control's content by touching and dragging )
*Added: AutoDrag property can specify distinct actions for left/right mouse buttons and short/long touch actions. For instance, AutoDrag property on exAutoDragScroll + exAutoDragScrollOnShortTouch indicates that the user can scroll the control's content by clicking the left mouse button, or by short touching the screen.
*Fixed: Can't scroll the control if touching with fingers the buttons of the scroll bar.
*Fixed: The Options parameter of the Import method does not takes the correct value for eor field.

10.0.0.2 Nov 25, 2015
*Added: DisplayPivotRows property specifies the maximum number of rows that can be generated in the control's list
*Fixed: Can't drop the data as text to Microsoft Word application, if the HeaderVisible property is False ( AutoDrag property is exAutoDragCopyText )
*Fixed: A Click event occurs right after DblClick event.
*Fixed: The controls hangs up for a while if the user clicks contiguously any button on the control's scroll bars.
*Fixed: The control's scroll bar is not updated while clicking contiguously any button on the control's scroll bars.

10.0.0.1 Sep 30, 2015
*NEW:   Memory Management Improvements
*Added: IncludeExpandColumn property specifies whether the column itself is displayed in the list (header/chart), while it expanded ( the column contains child columns ).
*Fixed: Reduces the memory usage when importing/loading the data into the control ( 40 - 60% )
*Fixed: Memory-leaks when the data is loaded several times.

9.0.0.4 Sep 14, 2015
*NEW:   Sorting and Incremental-Seach for control's Columns Floating Panel and Context Menu.
*Added: PivotColumnsSortOrder property specifies the order to display the columns on the Columns Floating Panel ( PivotColumnsFloatBarVisible property ). For instance, PivotColumnsSortOrder property on exPivotColumnsAscending, makes the columns floating panel to display the columns alphabetically in ascending order.
*Added: The exPivotBarContextSortAscending flag in control's PivotBarVisible property indicates that the Context Menu of the control's pivot bar displays the columns alphabetically in ascending order.
*Added: The exPivotBarContextSortReverse flag in control's PivotBarVisible property indicates that the Context Menu of the control's pivot bar displays the columns in reverse order. The combination of exPivotBarContextSortAscending and exPivotBarContextSortReverse makes the Context Menu of the control's pivot bar to display the columns alphabetically in descending order ( exPivotBarContextSortDescending ).

9.0.0.3 June 10, 2015 
*NEW:   Ability to specify un-grouping columns.
*Added: DataColumn.AllowGroupBy property specifies whether the user can group by this column. For instance, AllowGroupBy property on exGroupByNone, indicates that the column can not be dropped on the control's pivot bar, or in other words you can not group by this column, using drag and drop or using the pivot's bar context menu.
*Added: Select an available aggregate function/column when dropping a column that generates value-columns in the view.
*Fixed: The control fails if the user un-check all columns from the pivot bar, in the columns header section

9.0.0.2 Apr 22, 2015
*NEW:   Ability to horizontally/vertically scroll the control's content while the AutoDrag property is exAutoDragScroll (touch screen scrolling)
*Fixed: Updates the vertical/horizontal scrolling position while the user is scrolling the control's content using the AutoDrag property on exAutoDragScroll
*Fixed: "Visual C++ Runtime Error!" occurs if using the <fgcolor> or <bgcolor> with no indicating the color. Correct is <fgcolor RRGGBB>, instead <fgcolor>
*Fixed: Ignores the HTML tags from the column's caption when the incremental searching is performed on the Columns Floating Panel ( PivotColumnsFloatBarVisible property ).

9.0.0.1 Feb 16, 2015
*NEW:   Windows 8.1 64-bit compatibility
*Added: The /COM 64-bit version is compatible with Microsoft Office Applications: Excel 2013, Access 2013,...
*Added: The /NET(/WPF) 64-bit version is compatible with Microsoft NET Framework 4, 4.5, 4.5.1, ...
*Added: AllowDrop property gets or sets a value indicating whether the control can be used as the target of a drag-and-drop operation. ( /COM version )
*Fixed: The Export method exports the first value in the column ( ShowBranchRows property on exBranchCompact, or ShowViewCompact on exViewCompact )

8.3.0.4 Dec 22, 2014

*NEW:   Incremental Search and Filter Support for the drop down filter panel. The Incremental search/filter feature for the drop down filter panel is valid while the Filter For field is not displayed. For instance, if the drop down filter list displays hundreds of items, you can start typing and it includes just the items that match your typing characters.
*Added: FilterListEnum.exHideFilterPattern flag hides the Filter For: field in the drop down filter panel. If DisplayFilterList property includes the FilterListEnum.exHideFilterPattern flag no Filter For field is shown, and the incremental search/filter is allowed on the drop down filter window. As soon as you type, the drop down list includes the items that match the typed characters.
*Fixed: Sometimes, the insensitive-case filter does not apply correctly to items that contain accented letters ( French Accents Characters ) like: יטאשךך, ... ( /COM Ansi version only )
*Fixed: Prevents dropping the data when to current pivot table, if the source is the pivot table itself ( AutoDrag property is exAutoDragCopyText )

8.3.0.3 Nov 26, 2014
*Added: The Export method includes expandable columns too
*Fixed: The Export method does not add empty cells at the beginning of the line.
*Added: Includes the expandable columns to dragging data if using the AutoDrag property on exAutoDragCopyText 

8.3.0.2 Oct 01, 2014
*NEW:   Selects the Columns to be shown on the aggregate's context menu based on the Column.SortType property. For instance, if SUM aggregate function is selected, the Columns sub-menu shows the numeric columns only ( SortType property is SortNumeric ). Also, if the AVG aggregate function is checked, the Columns popup displays all numeric, date or date-time columns.
*NEW:   Ability to filter the columns in the Columns float-bar, as soon as you start typing ( incremental filtering ).
*Added: The AutoDrag property drags the child items of dragging item, if the item is expanded and there is no other selected item ( none or one selected item ). If multiple items are selected and dragged, no child items are included in the dragging operation
*Fixed: No TAB character is included between empty cells, when data is dragged using the AutoDrag property on exAutoDragCopyText.

8.3.0.1 Jun 04, 2014
*NEW:   Support for EBN 1002 version.
*Added: The EBN 1002 allows using skin objects with horizontal, vertical stretch and colorable/not-colorable parts of the EBNs.
*Added: Includes the expandable columns to dragging data if using the AutoDrag property on exAutoDragCopyText 
*Fixed: Sometimes, the Column.SortOrder is not applied to a new column on the control's header, if selecting from the context menu.

8.2.0.4 Apr 16, 2014
*Added: The Options parameter of Import method can be "reverse", which has effect for two-dimensional safe arrays only (Source parameter), and it specifies that the first dimension indicates the rows, while the second indicates the columns. By default, the first dimension indicates the columns, and the second the rows
*Fixed: The sorting order of the items in the drop down filter panel, is not keep, for pivot columns in the Rows section of the pivot bar, if the pivot column has been drop as unsorted in the Rows section.
*Fixed: The font decorations like <sha>, <out> and so on are not copied when the ShowViewCompact property is exViewCompact

8.2.0.3 Mar 10, 2014
*NEW:   Ability to compact the aggregate functions.
*Added: ShowViewCompactEnum.exViewCompactAggregates flag, compacts the aggregate functions displayed in the data section . For instance, ShowViewCompact = (exViewCompact Or exViewCompactAggregates) makes the view to merge multiple aggregate functions to the same column, and sub-aggregate functions to be displayed on the branch row rather than child of the branch rows.
*Added: The Reset method syntax changes from Reset() to Reset(IncludeMask,ExcludeMask) where the IncludeMask parameter specifies the pattern of properties to be reset, and ExcludeMask parameter specifies the pattern of properties to be un-reset.
*Added: Column.SortOrder property specifies the sorting order of the pivot column when it is dropped to the control's pivot bar. In other words, you can specify the default sorting order when a pivot column is dropped on the control's pivot bar.

8.2.0.2 Jan 08, 2014
*Added: SelectAll method selects all rows in the data section of the control ( Has effect only if the SingleSel property is False ).
*Added: UnselectAll method unselects all rows in the data section of the control ( Has effect only if the SingleSel property is False ).
*Fixed: Copy the sorting order of the pivot column being dragged to a group by pivot bar ( Columns section )
*Fixed: The window's list view settings ( sorting, filtering, position of the columns ) are not reset once the user calls the Reset method of the control.

8.2.0.1 Dec 04, 2013
*NEW:   Ability to keep the filter/sort settings for all neighbor columns, when the control's ShowViewCompact property is exViewCompact
*Added: LayoutChangingEnum.exPivotDataColumnSort constant. The LayoutStartChanging(LayoutChangingEnum.exPivotDataColumnSort) event notifies the application once the user is about to sort the pivot column ( click and sort the pivot column in the control's pivot bar ). The LayoutEndChanging(LayoutChangingEnum.exPivotDataColumnSort) event occurs once the control sorts the pivot's column.  
*Added: LayoutChangingEnum.exPivotDataColumnFilterChange constant. The LayoutStartChanging(LayoutChangingEnum.exPivotDataColumnFilterChange) event notifies the application once the user clicks the pivot column's drop down filter bar. The LayoutEndChanging(LayoutChangingEnum.exPivotDataColumnFilterChange) event occurs once the control filters the pivot's column. 
*Added: ShowViewCompactEnum.exViewCompactKeepSettings flag, applies the same filter and sort settings to all neighbor pivot columns, while columns are shown as compacted ( multiple aggregate functions in the same column ). For instance, ShowViewCompact = (exViewCompact Or exViewCompactKeepSettings) makes the view to merge multiple aggregate functions to the same column, and the same filter/sorting option is applied to all neighbor columns.

8.1.0.2 Oct 09, 2013
*NEW:   Ability to load data from safe arrays of one or two dimensions
*Added: The Source parameter of the Import method may indicate a safe array of data to load. The safe array must be with 1 or 2 dimensions, else an error occurs. If the Source parameter refers a one-dimensional array, the content of the array indicates the values of the rows. If the Source parameter refers a two-dimensional array, the first dimension indicates the columns, while the second indicates the rows. For instance, in VB6 you can load data to the control using the syntax Pivot1.Import Array(1, 1, 2, 2, 3, 3, 4, 4)
*Fixed: MS Access plays a beep, when the user presses the Backspace key while the control has the focus.
*Fixed: In MS Access, can't use the CTRL+F4 key to close the current form.

8.1.0.1 Sep 02, 2013
*NEW:   Ability to show multiple aggregates values in the same cell.
*Added: ShowViewCompact property indicates whether the view compacts the data being displayed.
*Added: Ability to copy the aggregate function/column ( including the group by columns) by drag and drop, using the CTRL key down.
*Added: The HTML tags are case insensitive, so the < b > is equivalent with < B >

8.0.0.2 Aug 07, 2103
*NEW:   Ability to filter the group-by rows, from defining the layout
*Added: The control's pivot bar displays a plus sign to allow selecting the columns to be added to the layout, while the PivotBarVisible property does not include the exPivotBarHideAddNew flag.
*Fixed: The data is wrong grouped if the first group by row contains empty fields.

8.0.0.1 June 17, 2013
*NEW:   Ability to group the columns section too, not only the rows section
*Added: DisplayPivotFields property retrieves or sets the maximum number of columns to be displayed on the control's list.
*Fixed: The tooltip of the element from the cursor, may not be visible, if a new appearance is applied to any column, using the control's UI context menu. 
*Fixed: Sometimes, the Layout property does not save / restore the control's filtering options.

7.1.0.3 Apr 29, 2013
*NEW:   Ability to group the data using the Add New button, being shown on the pivot bar.
*Added: PivotBarVisibleEnum.exPivotBarHideAddNew prevents showing the add new buttons in the pivot bar
*Fixed: The control fails if calling the Unload Me ( closing the form/dialog/window that hosts the component  ) during a control's event of the /COM control.
*Fixed: The parts with different fonts in the HTML caption are vertically aligned ( instead aligning to the font's baseline ) if the line displays a picture or an icon using the <img> HTML tag.

7.1.0.2 Mar 11, 2013
*NEW:   Subscript and Superscript implementation in HTML captions, using the <off> HTML tag
*Added: <off>, </off> built-in HTML tags defines the vertical offset to display the elemenet, relative to the current position. This tag is inheritable. The <off pixels>, where, pixels indicates the vertical offset to be applied ). For instance, the following text displays a text with Subscript and Superscript such as: "Text <off 4>with subscript</off> <off -4>and superscript</off> support"
*Added: The <fgcolor=0000FF> and <fgcolor FF>, or <bgcolor=00FF00> and <bgcolor FF00>, so no = or full 6 hexa-digits are required to define the color to be applied
*Fixed: The <font> HTML tag is not overwritten when using inside another <font> tag

7.1.0.1 Feb 06, 2013
*NEW:   Ability to show the data that generated the cell by double clicks the result.
*Added: ShowDataOnDblClick property specifies whether the user shows the original data that generated the result when user double clicks a cell. 
*Added: The parent of the value columns shows the aggregate function to be used for all elements on an upper level.
*Added: Shows more data when user double clicks the ... continual row, if the DisplayPivotData property is positive, else the ... are not displayed.

7.0.0.1 Jan 03, 2013
* Initial Release

Copyright 1999-2017 Exontrol. All rights reserved.