![]() ![]() ![]() tdf#135762 (Caolán McNamara, Red Hat Eike Rathke, Red Hat) command line spreadsheet conversion or export filter options string accepts a new optional 12th numeric parameter, which makes it possible to export the entire document to individual sheets. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |