New Features
General
- Customize which actions are shown in the toolbars
- More column-related actions in the project context menu, also for multiple selected columns
- New option to skip storing column and matrix data in the saved file
- Improved spinbox localization
- New Changed column in the Project Explorer to highlight objects modified since the last save
- Markdown support in Notes
Analysis
- Save and load custom functions for fit curves, equation curves, and function values
- Add option to enable/disable parameter error scaling (relative vs. absolute sigma) for fit curves
- Baseline correction analysis directly in the plot
- LOWESS (Locally Weighted Scatterplot Smoothing) smooth method
- Auto-recalculate option for analysis curves — automatically re-run the analysis on algorithm parameter changes
Time Series Analysis
- Seasonal decomposition using STL and MSTL methods
Spreadsheet
- Zoom support (Ctrl+Mouse Wheel, Ctrl+Plus/Minus, slider in the status bar)
- Drop entire rows when a condition is met for selected columns (Drop Values Dialog)
- More informative tooltip texts for spreadsheets and columns showing their usage across the project
- Average 2-period moving range shown in the column statistics
- Create plot areas on separate worksheets from the Plot Data dialog — one worksheet per column
- Transpose columns and rows
- Column formula can now be defined directly in the dock widget
- DateTime functions (today, now, date, datedif, year, month, day, hour, minute, second, etc.) for column formulas (BUG: 497924)
Worksheet
- Inset plot areas — plot areas nested inside another plot area
- Improved axis tick placement — no longer forced to axis edges when it doesn't look right
- Position center and limit lines in Process Behavior Charts based on user-defined specifications
- Use colors from a specified color map for plots, in addition to the current theme palette
- Stacked line plots
- Apply analysis (fit, smooth, etc.) to multiple curves simultaneously
- New chart type: Pareto Chart
- Made all plot navigations (zoom, shift, pan) undo-/redoable (BUG 470792)
Import
- Import entire directories — import multiple files in one step
- Support for Unix timestamps and Windows timestamps in ASCII files (ms precision)
- Import arrays from JSON files containing plain data
- Import data from Apache Parquet, Arrow IPC (Feather) and Apache ORC files
Examples & Datasets
- New All category in the Examples dialog to browse all collections at once
- More user-friendly dataset names in the import dialog
- Added datasets from OpenIntro
- Added datasets from UCI Machine Learning Repository
Performance Improvements
- Improved drawing performance
- Faster import of JSON files with a large number of elements
- Faster save/load of text columns
- Faster save/load of datetime columns
- Faster cutting of cells in the spreadsheet
- Faster handling of masked values in the spreadsheet with reduced memory consumption (BUG 521940)
Bug Fixes
- Fix displayed locale of constants
- Rename psi constant to psqi to avoid clash with the psi function
- Fix crash when loading a project with a workbook as the first child
- Fix updating column count in the spreadsheet dock on data import
- Fix appending data to spreadsheets from XLSX files
- Fix bar chart rendering with log scales
- Undo background color of text labels