Note that this will be the last 1.x branch release before the 2.x release. We will maintain both branches in parallel for a time; but users are requested to update to version 2.0 once that is fully available.
Added
-
Added
removeComment()method for Worksheet PR #2875 -
Add point size option for scatter charts Issue #2298 PR #2801
-
Basic support for Xlsx reading/writing Chart Sheets PR #2830
Note that a ChartSheet is still only written as a normal Worksheet containing a single chart, not as an actual ChartSheet.
-
Added Worksheet visibility in Ods Reader PR #2851 and Gnumeric Reader PR #2853
-
Added Worksheet visibility in Ods Writer PR #2850
-
Allow Csv Reader to treat string as contents of file Issue #1285 PR #2792
-
Allow Csv Reader to store null string rather than leave cell empty Issue #2840 PR #2842
-
Provide new Worksheet methods to identify if a row or column is "empty", making allowance for different definitions of "empty":
- Treat rows/columns containing no cell records as empty (default)
- Treat cells containing a null value as empty
- Treat cells containing an empty string as empty
Changed
-
Modify
rangeBoundaries(),rangeDimension()andgetRangeBoundaries()Coordinate methods to work with row/column ranges as well as with cell ranges and cells PR #2926 -
Better enforcement of value modification to match specified datatype when using
setValueExplicit() -
Relax validation of merge cells to allow merge for a single cell reference Issue #2776
-
Memory and speed improvements, particularly for the Cell Collection, and the Writers.
See the Discussion section on github for details of performance across versions
-
Improved performance for removing rows/columns from a worksheet
Deprecated
- Nothing
Removed
- Nothing
Fixed
- Xls Reader resolving absolute named ranges to relative ranges Issue #2826 PR #2827
- Null value handling in the Excel Math/Trig PRODUCT() function Issue #2833 PR #2834
- Invalid Print Area defined in Xlsx corrupts internal storage of print area Issue #2848 PR #2849
- Time interval formatting Issue #2768 PR #2772
- Copy from Xls(x) to Html/Pdf loses drawings PR #2788
- Html Reader converting cell containing 0 to null string Issue #2810 PR #2813
- Many fixes for Charts, especially, but not limited to, Scatter, Bubble, and Surface charts. Issue #2762 Issue #2299 Issue #2700 Issue #2817 Issue #2763 Issue #2219 Issue #2863 PR #2828 PR #2841 PR #2846 PR #2852 PR #2856 PR #2865 PR #2872 PR #2879 PR #2898 PR #2906 PR #2922 PR #2923
- Adjust both coordinates for two-cell anchors when rows/columns are added/deleted. Issue #2908 PR #2909
- Keep calculated string results below 32K. PR #2921
- Filter out illegal Unicode char values FFFE/FFFF. Issue #2897 PR #2910
- Better handling of REF errors and propagation of all errors in Calculation engine. PR #2902
- Calculating Engine regexp for Column/Row references when there are multiple quoted worksheet references in the formula Issue #2874 PR #2899