Changes List
п»їFastCube FMX 2021.1 ------------------- + Add support for RAD Studio 11 + Axis position changes on DblClick in the axis field popup + Added search in the popup list of unique values by pasting from the clipboard + Added "Copy" menu item to the axis menu. Item copies dimension value to clipboard * Fixed keyboard handling in the popup grid list (grid must have CanFocus = True) * DataZone gets the focus and therefore keyboard handling on the grid focus (grid must have CanFocus = True) FastCube FMX 1.5 ------------------- + Added support for RAD Studio 10.4 + Added cell highlight option compared with average value (TfcxAverageHighlight). + Added most/least N cell highlight option (TfcxTopHighlight). + Added repeatable/unique cell highlight option (TfcxUniqueHighlight). + Added cell highlight based on expressions (TfcxExpressionHighlight). + Added negative value settings for ContinuousHighlight with Kind = ContinuousHighlightKind.BarChart + Added event TfcxCustomToolbar.BeforeDialogExecute * Major refactoring of the TfcxContinousHighlight with breaking of the compatibility: Before: TfcxContinuousHighlightValueType enum had BoundByRow, BoundByCol, PercentByRow, PercentByCol, PercentileByRow, PercentileByCol elements. Now: Those elements replaced by Bound, Percent and Percentile elements. Added new enum TfcxHighlightScanDirection and the approptiate property ScanDirection common for all Highlight types with the Auto, Rows and Columns elements. New saves wont correctly work in the old version. Effect: Highlight setup simplification due to reduced combobox lists. Auto element suit for most cases and does not break highlight (as before) after "Measures" field move from the rows to the columns and vice versa. - Fixed errors with PopupMenu showing FastCube FMX 1.4 ------------------- + Added support for RAD Studio 10.3 Rio + Added method TfcxContinuousHighlight.ImageReverseOrder to set reverse order or icon highlight + Added methods TfcxSlice.SetTotalPosition(const Value: TfcxTotalPosition) and TfcxAxisContainer.SetTotalPosition(const Value: TfcxTotalPosition) + Added property TDimensions.DetailValue: Variant - current detail value for total calculation by formula based on subtotals. + Added property TfcxCubeDataColumns.VisibleIndex[ACubeFieldName: String]: integer + Added automatic changing of Y-axis fields header height in report + Adding/removing measure runs events OnBeforeAddSliceFieldToRegion, OnAfterAddSliceFieldToRegion and OnBeforeRemoveSliceFieldFromRegion + Added chs_Created in TfcxChangeInSlice (creating base empty slice) + Added procedure TfcxMeasuresContainer.Recalculate + Added property TfcxCube.AbortLoading: boolean to abort data loading in event OnProgress + Added export to Microsoft Excel 2007 (.xlsx) + Added support for RAD Studio 10.2 Tokyo + Added support for RAD Studio 10.1 Berlin + Added published properties Restrictions: TfcxZoneRestrictions for Zones to prohibit schema change by users + Slice fields display format is stored in schema + Added events TfcxSlice.OnBeforeRemoveSliceFieldFromRegion, OnBeforeAddSliceFieldToRegion and OnAfterAddSliceFieldToRegion + Added property TfcxMeasureField.ChangeNULLtoZero: boolean + Added property TfcxSlice.OnInterpreterCreated: TfcxInterpreterCreated + Added property TfcxpSliceGridReport.Orientation: TPrinterOrientation + Added functions TfcxMeasuresContainer.ChangeCalcMeasureScript + Apply percent format to "display as percent" cells while export to XLS + Added support of ShortInt fields + Added restoring selected cell after loading schema + Added export to CSV * Reimplemented XML-A export * If cell value is both minimum and maximum of the column/row then treat it as maximum for highlight rules - Fixed error with splitting of Null date - Fixed error with TIBBCDField in RAD Studio 10.* - Fixed error in TfcxSourceFieldProperties.AssignTo - Fixed error: Integer Overoverflow in CompareSQLTimeStamp - Fixed errors in German translations (thanks to Ralf Stegemann) - Fixed error: value does not load from database when field size greater 8192 byte - Fixed error with creating measures with missed base field during loading schema - Fixed error with Unassigned and 0 - Fixed error with creating SliceGrid and CubeGrid in RAD Studio 10.2 Tokyo - Fixed error with PopupMenu in ToolBar - Fixed error with Highlights - Fixed error with HideZero - Fixed error with Dataset in TfcxpCube - Fixed error in ColOffsetValue and RowOffsetValue - Fixed error with comparing Date in Ranges - Replacing " " to "_" in function name in measure editor - Added repainting axis after changing of slice field format. - Slice field format change does not influence format of other fields of the same type. - Fixed small errors in HideZero and hidden cells - Fixed small errors in exports - Fixed error in ODS export - Fixed error with TfcxScriptStringList in RAD Studio 10.1 Berlin - Fixed error with Calculated Field - Fixed error in TreeLike axis - Fixed error with DisplayAs = da_ColRank - Fixed error with VarSQLTimeStamp - Fixed error of loading old version cube - Fixed error of using Percentile - Fixed error groups expanding - Fixed error in recompile.exe - Fixed errors in language resources - Fixed error in HTML and Excel exports (error with property RepeatValues) FastCube FMX 1.1 ------------------- + Added property TfcxAxisContainer.DimCaption[ALevel: TfcxSmallCount; AVisIndex: Integer]: TfcxString + Added OnPrepareSaveDialog event for export components. This allows to setup save dialog before showing it to user. + Additional totals uses property CalcTotalsOnTotals + Added sorting in CubeGrid and DetailGrid + Added TfcxSlice.ApplyDefaultSettings + Added TfcxSlice.ResetDisplayLabelOfFields + Added aggregate function Weighted arithmetic mean + Added aggregate function Median + Added support of Embarcadero Rad Studio XE8 (Delphi XE8/C++Builder XE8) * Acceleration and optimization calculation of measures * Hide "Sort" menu item for "Measures" field since it has no sense for it * Renamed property TfcxMeasureField.SliceField2 to TfcxMeasureField.SliceFieldDistinct * Reimplemented XML-A export - Fixed errors in HTML and Excel exports - Fixed error in HTML and Excel exports (error with property RepeatValues) - Fixed error in TfcxAxisContainer.DimValue - Fixed error with SmallInt - Fixed: SliceFieldExtra is not saved in Measure Editor - Fixed errors of calculation of totals which based on other totals - Fixed errors of measures calculation - Fixed error of loading filters with NULL value - Fixed error with attributes referenced from main dataset - Fixed error in TfcxMeasuresContainer.SetPosition - Fixed error in HideZero - Fixed error in TfcxAxisContainer.DimValue - Fixed memory allocation error in xls Export on 64bit platforms FastCube FMX 1.0