-1 for all sheets, each sheet is exported to an individual file of the base file name concatenated with the sheet name, for example sample-Sheet1.csv, sample-Sheet2.csv and sample-Sheet3.csv.0 or absent means the default behaviour, first sheet from command line, or current sheet in macro filter options, exported to sample.csv.Soffice -convert-to csv:"Text - txt - csv (StarCalc)":44,34,UTF8,1,0,false,true,false,false,false,-1 sample.ods 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 Alphabetical indexes, tables of contents and user-defined indexes will now generate clickable hyperlinks to document index entry marks core commit 7685c074 (Michael Stahl, allotropia).12.3 Improvements to proofing tools and language supportĪbout This Page Writer General improvements.12.2 Additional languages in the language list.12.1 New languages/locales with locale data.10.5 Improvements of PPTX import/export filter.10.4 Improvements of XLSX import/export filter.10.2 Improvements of DOCX import/export filter.10.1 Improvements of DOC import/export filter.2.5 Custom color metadata field shadings.
0 kommentar(er)
