Improved file opening speed for some big XLSX files tdf#79049 (Noel Grandin, Collabora).
Improved speed when filtering tdf#133878 (Luboš Luňák, Collabora).Improved speed of some XLSX file opening and scrolling tdf#130326 (Noel Grandin, Collabora and Caolán McNamara, RedHat).Improved speed of pasting formulas with VLOOKUP function tdf#92456 (Noel Grandin, Collabora).(It previously only could take a cell range.) tdf#58585 (Andreas Heinisch) IRR() can now take an array for the Values parameter.ROUND() has its artificial limitation on the second parameter (rounding position) removed, for which the argument previously had to be in the interval and otherwise the function returned error.That was changed to calculate 1-2-3-4 in "natural" left to right order as may be expected. Previously, RAWSUBTRACT(1 2 3 4) calculated 1-4-3-2 as encountered on the arguments stack. RAWSUBTRACT() now processes arguments from left to right.CELL() now evaluates the top left cell of a given cell range argument as second parameter instead of the usual intersecting position for scalar parameters, for interoperability and compliance with the ODF OpenFormula standard definition.New spreadsheet functions Changed spreadsheet functions The AutoFilter dropdown now has a "Clear Filter" button to clear all criteria (in both the dropdown and the Standard Filter dialog).You can choose to filter rows based on text/background color
0 kommentar(er)
