TEXT() now allows the second argument to be an empty format string for interoperability with other implementations.Note that the default case-sensitivity of the functions is not changed the affected functions: AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, HLOOKUP, LOOKUP, MATCH, SEARCH, SUMIF, SUMIFS, VLOOKUP are case-insensitive by default, so the sensitivity only changes after first (?-i) in the regular expression tdf#78840 (Mike Kaganski, Collabora) Functions that allow using regular expressions now correctly honor case-insensitivity flags (?i) / (?-i) in the expression.RAND.NV() and RANDBETWEEN.NV() non-volatile random number generating functions that are not recalculated on every input like RAND() and RANDBETWEEN() are.Find & Replace is ~50% faster tdf#119286 (Noel Grandin, Collabora).See this screencast about the usage: Hungarian, as well as an Old Hungarian template document with embedded Noto Old Hungarian font. ” (Romanian)Īs an RTL (Right-To-Left) AutoCorrect feature in Hungarian, words, numbers and some kind of punctuation are transliterated to Old Hungarian (or Szekler/Székely) writing, turning on the right to left writing direction using Writer’s Complex Text Layout support during typing. Replace ASCII quotation mark " with second level quotation marks inside primary level quotation in Hungarian and Romanian (these languages use apostrophe and single quotation marks instead of the equally important double angle quotes in Single Quotes AutoCorrect) tdf#133524.Replace character sequences > with double angle quotes « and » in Aragonese, Asturian, Catalan, Finnish, Galician, German, Hungarian, Polish, Portuguese, Romanian, Spanish, Swedish, Ukrainian and with single angle quotes ‹ and › in Swiss French, where these quotation marks are in use, but their actual Single and Double Quotes replacement doesn't support them tdf#133524.
10.5 Improvements of PPTX import/export filter.10.4 Improvements of XLSX import/export filter.10.3 Improvements of DOCX import/export filter.10.2 Improvements of the EMF+ import filter.