NEW New parameter useOlapFormattingInExcel for exportTo() was added to configure how to export grid cells in Excel file if formatting is taken from OLAP cube - as a formatted string (true) or as numbers without formatting (false). Previously it was not configurable and the cells were exported as formatted strings.
NEW Now it's possible to save data (for CSV/OCSV data sources) within the report file. Usage:
flexmonster.save("report.xml", "file", null, null, true);Produced file will contain data in OCSV format.
FIX The issue related to non-changing of Grid view after changing a title of calculated formula in Calculated view was fixed.
FIX If an existing formula is used to create a new formula, the old formula in the editor is represented by its name instead of internal code.
FIX The truncation of long names in chart y-labels was fixed.
FIX The positioning of labels on X-axis was fixed.
FIX The issue with horizontal scrolling was fixed.
FIX An exception that occurred when switching to bar line chart with only one measure selected was fixed.
FIX The issue when showChartsWarning option did not turn off the warning on charts was fixed. The <param name = "showChartsWarning">false</ param> in report XML works fine now.
NEW New property excelSheetName was added to export options in exportTo() API call to configure the sheet name when exporting to Excel file.
NEW New alert was added if CSV data file is empty.
Note: it's possible to change the alert message using XML localization file:
<messages> ... <noDataAvailable>Datasource is empty. Please check the CSV file.</noDataAvailable> ... </messages>
To know more about localization: Localizing component
FIX "if" formulas in calculated values work with spaces and without spaces between arguments.
FIX The text NaN that appeared when editing empty value was changed to empty string.
FIX The issue when the previously opened Filter or drill-through was not closed after showGridAndCharts() API call was fixed.
FIX Showing zero values for measures in drill-through (API data source) was fixed.
FIX The exception that happened during the cell data reading with getCell() API call, if the cell is not in the visible view port, was fixed.
FIX The Filter disappearing issue when its height was bigger than the grid's height was fixed.
FIX Visual bug of the editing cell placement on top of the grid's scroll bar was fixed.
FIX Columns resizing issue was fixed.
FIX Bug in Flat charts with Y-axis title was fixed.
FIX Rotation of chart's Y-axis label in Firefox was fixed.
FIX The blinking of preloader message between "Analyzing data..." and the first message with % of data analysed was fixed.
FIX The issue that causes hiding header labels with custom styles was fixed.
FIX Click event returns ID of the member if it defined.
NEW Only measures with properties different from default are being saved in report. All the measures were saved in report before this minor release. This improvement reduces the size of report file.
NEW HTML5 Y-axes have a vertically aligned titles.
NEW HTML5 Displaying X-axis and Legend label names in tooltip.
NEW HTML5 Report's filename parameter supports URL to a blob/file object created by URL.createObjectURL().
FIX Ignorance of configuratorActive parameter in the very first loaded report was fixed.
FIX Restoration of sorting in Flat table for the report based on the same CSV datasource was fixed.
FIX Dashboard demo height in download pack was fixed to show the demo completely.
FIX Showing wide columns on the grid was improved.
FIX Toolbar update: credentials fields for OLAP connection were removed (because this feature isn't available in HTML5).
FIX Wrong filter pop-up placement with long members' names was fixed.
FIX The issue with parsing specific CSV files that contain ":" character in the header was fixed.
FIX The issue when Field List OK button was disabled for Flat table after a CSV file load was fixed.
NEW HTML5 Improved grid performance for IE and Firefox.
NEW Component is fully compatible with Microsoft Edge.
NEW Callback handler for exportTo() API call was implemented.
NEW Number format applied in grid is exported in Excel file.
FIX The issue with showing zero values for measures in drill-through (API data source) has been fixed.
FIX More smooth touch scroll on tablets is available now. Try it!
FIX Losing <hash> issue in saved report XML was fixed.
FIX The X-axis Label name is getting truncated only if a label is longer than 50 characters.
NEW We have prepared a sample ASP.NET MVC 5 project to demonstrate the integration with Flexmonster Pivot Component.
Download link: https://s3.amazonaws.com/flexmonster/downloads/FlexmonsterMVC5.zip
Files to consider:
Scripts/Flexmonster/ - folder with component files;Views/Flexmonster/Index.cshtml - adding component to the page.NEW Horizontal scrolling appears if pivot view has several frozen columns and narrow scrolling area in the classic mode.
NEW The row height is set in exported excel only if the height of row in pivot component is not default.
FIX "dt+" did not work for CSV data source - this was fixed.
FIX Loaded via API 'date string' dates were considered as measures falsely and the component shown all available aggregations for them when only Count and Distinct Count are applicable. This issue was fixed and now 'date string' dates are considered as hierarchies.
FIX Custom column width was not kept when refreshing, sorting, filtering a flat table. Also, custom columns width / rows height were not being saved and restored properly. Both issues were fixed.
FIX The row height and the column width calculations were improved.
FIX The issue with loading TSV files in IE10 was fixed.
FIX Indentation issue in printing was fixed.
FIX The issue when '(blank)' member has wrong order while sorting 'date string' dates was fixed.
FIX Text alignment (right) for PDF export was fixed.
FIX Now all labels are displayed in short style if they are greater than 1M.
FIX CSV Compressor DLL Library for CSV Compressor for .NET was updated to the latest version. It contains several fixes related to CSV parsing. The most important is the correct support of "|" characters in input CSV file. Thus, if you use it please download the latest one from the link below and replace dll in your project with the one from the package.
You can download it within our trial package. It is in "Configured for Relational databases: MySQL, Oracle, etc." package in the download email.