LibreOffice 7.1.0

What's new in this version:

General improvements:
- Writer now has support for anchoring shapes relative to the bottom of the page content frame. blog post
- Default anchor for newly added images can be set per Tools ▸ Options ▸ LibreOffice Writer ▸ Formatting Aids
- Writer now supports locale-independent templates blog post
- Writer can now detect Unicode type even if imported text file does not have a BOM

Outline folding mode:
- Added a new Writer outline folding mode (as experimental feature). You should enable experimental features in Tools ▸ Options ▸ LibreOffice ▸ Advanced dialog to see "Show outline content visibility button" checkbox in Tools ▸ Options ▸ LibreOffice Writer ▸ View dialog. After checking it you'll can see a button with arrow near any selected heading in your document. Click on it to fold all text from the current heading to next heading. Right click on it to fold all text from current heading to next the same level heading with all its subheadings

Table formulas:
- Added several table formulas for Word interoperability
- PRODUCT table formula
- ABS table formula
- SIGN table formula
- COUNT table formula

Style inspector:
- Added Style Inspector for displaying all the attributes of Paragraph Styles, Character Styles and manually formatted (Direct Formatting) properties. Read the necessity of this tool here

Fields:
- Input fields now can be toggled with View ▸ Field Names core commit 926a1a16 (Michael Stahl, CIB)
- Empty fields can be selected with the mouse core commit 2c7bf354 (Samuel Mehrbrodt, CIB)
- Word compatible Fields can now be toggled to hide either the command or the result with View ▸ Field Names (Michael Stahl, CIB)

Performance:
- Speeded up find/replace operations (Noel Grandin, Collabora)

ODF subtable conversion:
- Simple cases of subtables in legacy ODF documents initially created by OpenOffice.org 2.2 and older can now be converted to modern rowspan tables on import, typically improving the quality of a subsequent export to Word formats or HTML drastically. core commit e366c928(Michael Stahl, CIB)

Calc:
General improvements:
- Added an option to disable paste with Enter key. You can find it in a dialog from menu Tools ▸ Options ▸ LibreOffice Calc ▸ General.(Martin van Zijl)
- Now you can select items in Autofilter window clicking by all item's row, but not only by checkbox (Attila Szűcs, NISZ)
- Fixed an issue in formula input box when Calc fail to set the formula reference if you have freeze rows/columns enabled in a sheet.(Justin Luth, Collabora)
- Added "Reset All" button to Solver dialog (Rafael Lima)

Fill with merged cells:
- Fix lost merging and bad linear sequence of numbers during fill with merged cells
- Copy merged cell structure like other spreadsheets do- Select merged area wholly to fix the selection rectangle during fill, fixing incomplete attribute copying, bad grid and border- Apply correct linear sequence of numbers by skipping empty overlapped (invisible, i.e. not top-left) cells of the merged areas- Changed spreadsheet functions:
- Now INDIRECT function supports sheet-local scoped names

Performance:
- Improved spell checking performance in Calc core commit
- Improved performance when searching in Autofilter. Previously if the record contains a lot of unique values Calc will be very slow if you type-in a character in the autofilter search box. Now the search is instant.

Impress & Draw:
- Adding visible digital signatures to existing PDF files with Draw. Blog post
- Now Impress allows changing animations for several objects at once
- Presentation console has an "Exit" button now
- Presentation console has a "Pause/Resume" button now
- Added realistic soft blurred shadows for objects
- Added new physics based animation capabilities and new animation effect presets that use them. Namely Fall Simulated, Shoot right/left and return, Fall and fade out

- Math:
- Math has now a full support of HTML colors. Some of them have been added to the UI on Attributes section in Element pane.
- New examples in Element panel

Scripting:
The ScriptForge libraries:
- An extensible and robust collection of macro scripting resources for LibreOffice to be invoked from user Basic or Python scripts

about data containers:
- an extensive set of primitives for array handling, including sorts, set operations and interfaces with csv files and Calc sheets
- an extensive set of primitives for string handling, including replacements, regular expressions, encodings, hashing and localization
- a Dictionary mapping class
- a coherent error handling for both user and ScriptForge scripts
- complete FileSystem and TextStream classes for file and directory handling, and text files read & write
- detailed context information: platform, operating system, directories, ...
- interconnection of Basic and Python modules
- easy access to and management of actual windows and documents
- specific modules for
- automation on Calc sheets
- management of dialogs and their controls
- access to data contained in databases
- ScriptForge libraries documentation is undergoing review. ScriptForge help pages will be available from release 7.2 onwards.

Python:
Core / General:
- Improve finding a matching printer paper size for the printed document (Samuel Mehrbrodt, CIB)
- Show all supported files by default when adding a new extension in Extension Manager core commit 6a32706e (Samuel Mehrbrodt, CIB)
- Print preview is now updated asynchronously to not block UI when adjusting settings in print dialog core commit 93c833e8 (Samuel Mehrbrodt, CIB)

New dialog: additions:
- In various places, it should be possible to get more content such as macros or templates from external storage. This requirement is now fulfilled with the Additions Dialog. blog post (Yusuf Keten, GSoC; mentors: Muhammet Kara (Collabora), Heiko Tietze)

What and why:
- Without this dialog, when we want to install an extension we need to search it from the webpage, download and install it using the Extension Manager. With this dialog, we can now get and install extensions with one-click. This dialog is appropriate for searching and installing not only general extensions but also other types of extensions such as templates, macros, icons, etc. The main purpose of creating this dialog is to improve user experience. Therefore, nearly every detail of the extensions exist in the user interface. This simplicity is designed and created thanks to the web API, power of extension manager, and additions dialog.
- Note: Please visit the blog post to learn how to link Additions to other dialogs.
- Interaction added to Sidebar > Gallery, Templates Manager, Options > Dictionaries, Options > Icon Themes

Specifications:
User:
- can change the sorting filter according to the desire. Options are download number, rating, and comment number.
- can see which extensions are installed with this feature. Installed extensions are disabled on the list.
- can see the name, description, screenshot, rating, comment number, download number of the extensions from the list.
- can access the extension webpage and the comment section of the extension with the links on the UI.

LibreOffice Help:
- Reactivated extended tips in dialogs
- Syntax diagrams exist for all Basic statements, including a new How to Read Syntax Diagram page

Filters:
- Now detecting 0-byte files based on extension blog post
- Improvements of DOCX import/export filter:
- Add support for change tracking in floating table
- Add formula import in text tables core
- Export formula fields and formula cells in text tables
- Added a workaround for ABOVE/BELOW/LEFT/RIGHT arguments in SUM, AVERAGE, etc. table functions importing. Now Writer converts that arguments into cell range like and saves into DOCX as a cell range. Be careful with this new behavior
- Better handling of cached field results in Writer. a blog post
- Support keeping the spacing below the last paragraph in the header in doc/docx files (Samuel Mehrbrodt, CIB)

Improvements of PPTX import/export filter:
- Several SmartArt improvements when importing from PPTX blog post 1 blog post 2

GUI:
Dialogs:
- New dialog to select the User Interface flavor, aiming to pick the right UI at first start

Notebookbar:
- New widget with styles preview was added to the tabbed Notebookbar

Localization:
New languages/locales with locale data:
- English Kenya
- English (Hong Kong) [en-HK]
- Improvements to proofing tools and language support

See details on the changes:
- Albanian. The hyphenation dictionary was added and Hunspell files were encoded into UTF-8
- English (GB). The spelling dictionary was updated
- French. The spelling dictionary was updated
- Hungarian. The hyphenation dictionary was updated
- Italian. The spelling and hyphenation dictionaries were updated
- Korean. New spelling dictionaries was added
- Occitan. The spelling dictionary was updated
- Portuguese (Brazil). The spelling dictionary was updated
- Portuguese (Portugal). The spelling dictionary was updated
- Slovenian. The thesaurus was updated
- Spanish (all). The spelling dictionaries were updated

Bugs-fixed:
- wrapper object use after free
- uninitialized scalar field
- uninitialized scalar field
- uninitialized scalar field
- null deref
- recursion too deep
- divide-by-zero
- LibreOffice 7.0.3.1 crashed on invalid row index used in StarBasic macro
-VML Callout shapes are incorrectly imported for 2007 DOCX (OK if resaved in MSO to newer DOCX)
-Calc EDITING: Cells, containing call to Macro Function as Array doesn't update, even if press F9 [Andreas Heinisch]
-Form fields 'Image Button' do not work in Forms
-EDITING: Fields in tablecontrols of a form could not be moved/sorted
-EDITING: Table of Content (ToC) doesn't cross mark deleted text with Track changes Shown
-EDITING: Spellchecking tracked and shown changes - erratic underlining
-extended tips missing for menu items
-XLSX:vlookup formula changed in path to external csv file after saved and re-opened
-suggestion: warning that automatic wrapping text in LO Calc needs to be set Optimal in case of some xls import
-Make default type of anchoring optional
- If hidden characters exist in headings, they appear visible in the table of contents
- Problem with help advice for changing default template [Seth Chaiklin]
- [LOCALHELP] Review help pages for Templates [Seth Chaiklin]
- View jumps to cursor when activating or deactivating record changes and showing or hiding changes
- Crash report url/link should be clickable in Crash Report dialog [Seth Chaiklin]
- Problems connecting to OneDrive and Google Drive [Christian Lohmaier]
- DOC(X): Copy-pasting bulleted list entries insert page break
- Apply button doesn't change the document to modified
- FILEOPEN XLSX, Conditional formatting goes missing when opened in LO.
- Handling of templates potentially unclear in respect to where files are stored [Seth Chaiklin]
- FILESAVE XLSX Rotated shapes change their X/Y position on export [Szabolcs Toth]
- EDITOR ODT Writer inserts all data from filtered range
- FIREBIRD: Datatype Binary(fix) [CHAR] couldn't be filled with content
- Command labels for Select to Start of Word, select to End of Word need correction [shubham656]
- Crash report service is not documented [Seth Chaiklin]
- PPT: FILESAVE: Crop image is gone after RT [Xisco Fauli]
- Add more tips of the day (and make it module-specific eventually) [andreas kainz]
- FILESAVE: DOC: Cropped images are lost after RT [Xisco Fauli]
- FILEOPEN PPTX: shadow effect for table completely missing
- No focus on any object double clicked in Navigator after a shape object is double click in Navigator
- [LOCALHELP] Add BASIC syntax diagrams to Help [Alain Romedenne]
- Validity dialog height [Roman Kuznetsov]
- Icon of updates button on right end of menu bar is still not visible with kf5 and gtk3 vcl (or again not visible)
- UI: Paragraph style name field should be grayed out for default styles (can't be editted) [shubham656]
- Slow performance in autofilter if the record contains many unique values (10 seconds after 5.4 vs. 2 seconds before)
- Loss of nominated Chart data series Labels when target cells hidden or grouped & collapsed [Ouyang Leyan]
- caps on dashes are missing in edit mode
- [ENHANCEMENT] Implement a "Redefine Model" Button on Calc Solver [Rafael Lima]
- "Freezing Rows or Columns" help uses slightly wrong path [Seth Chaiklin]
- assertion in SwTextNode::~SwTextNode()
- Crash on macOS 10.13 opening local HSQLDB-based odb file in Base on LibreOffice 7 rc1
- EDITING Shape with textbox copied with Ctrl+dragging creates incorrectly placed textbox [Attila Bakos (NISZ)]
- EDITING Moving large shape upwards makes its textbox fall out of it [Daniel Arato (NISZ)]
- LO 6.4.6.1 and 7.0.1 fail with error 1045 when accessing MySQL database using native connector [Michael Stahl]
- FILEOPEN DOCX Empty headers size is applied instead of page top margin
- Image not exported to rtf/doc/docx
- Remove Euro Converter Wizard from Wizard menu [Christian Lohmaier]
- [ko] Extend Autocorrect list for Korean language [DaeHyun Sung]
- Corrupted calc file: invalid number format condition [ Properties opens dialog named "Slide setup" [Ayhan Yalçınsoy]
- LO Base Firebird: crash, when deleting tables and changed relationship isn't changed in database file
- ChangesInMargin: Crash on Undo of characters deleted by pressing Delete ( part 2 )
- CRASH When deleting shape+textframe anchored to page [Attila Bakos (NISZ)]
- FILESAVE RTF Language, font family, and font size mess up
- Unchecking use Skia For all Rendering isn't stored, it's activated again after restart
- FILEOPEN DOCX with text box opens modified [Daniel Arato (NISZ)]
- Border control in property dialogs use black color even on dark theme
- Crash in: swlo.dll [Xisco Fauli]
- EDITING Merged cells don’t lose detective circles when correct value is entered
- FILEOPEN XLSX Hidden pie chart legend entry visible
- FILEOPEN XLSX Rotated X axis labels are not wrapped
- [Draw] [Impress][UI]: Menu items with identical (or very similar) labels but different actions [Ayhan Yalçınsoy]
- Crash swlo!SwNodeIndex::~SwNodeIndex+0x18 (gen)
- FILEOPEN: Calc chart embedded basic custom shape text missing (ODF import)
- impress template thumbnails are blurred [Noel Grandin]
- Wrong colors used in icon-themes/colibre/svx/res/frmsel*.png
- fade-to-white transition on Impress does not stay saved
- ROUND() large numbers to decimals and to negative -5 decimals inaccurate
- Crash when customizing sidebar tab bar
- Adding a menu bar entry given by a PopupMenuController in an extension doesn't work with GTK [Thomas Viehmann]
- Edit Print Range: focus set to wrong input box
- CRASH: Undoing paste after editing comment
- Bullets and Numbering toolbar dropdown list and dialog miss scroll bar
- BitmapEx.Replace() is not working
- Crash when creating different scenarios ( steps in comment 4 ) [Noel Grandin]
- FILEOPEN EMF: The EMF image is shifted after opening [Bartosz Kosiorek]
- Clicking "Page Margins" button sets left and right margins to 0
- ChangesInMargin: fix Undo of embedded deletions (in paragraph level)
- Support for multiple code point emojis is missing [Tor Lillqvist]
- EDITING Validation circles not updated when circled cells get merged
- Artifacts in some impress templates [Noel Grandin]
- FILEOPEN: error discovered in the file in sub-document content.xml (fastparser) [Noel Grandin]
- It moves Formula's tooltip when you type a formula in Formula bar in Calc
- CRASH: Undoing comment hovering (steps in comment 11)
- FILEOPEN DOCX Drawing shapes placed on chart open in the top left corner
- Applying Formatting Aids twice crashes the application
- Vertical aligned text in nested table is hidden
- CRASH: Undoing paragraph deletion ( track changes )
- LibreOffice not splitting table cells automatically for docx files
- three improvements in File > Templates and associated .uno commands [Seth Chaiklin]
- Repeated data in Tables of File Conversion Filter Names [Balaharipreetha Muthu]
- "Apply to All" button in select preferred UI dialog can't be translated
- FORMCONTROLS: Date in formatted fields is set back to number when saving control properties
- RENAMING SHEET: Improve content of warning per Comment 7 [Seth Chaiklin]
- Pasting Calc data into Writer table hangs Writer CRASH (steps in comment 4)
- Entering text in the data field combo box in Base Control Properties is backwards
- FILESAVE XLSX Crash if Spreadsheet contain external reference that is not used in cells
- Crash when opening chart properties after creation [Aron Budea]
- After renaming sheet with Alt-click, clicking away loses the new name
- Line Width and Transparency in sidebar isn't disabled for chart area when line is set to none
- when managing Named Ranges changes are applied even if you press the "Cancel" button
- Rename "Recent Files" to "Recent Documents" in Start Center -- to be consistent with File > Recent Documents [Seth Chaiklin]
- Crash in table creation wizard when clicking next
- EDITING Deletions with Backspace/Delete not unified in changes-in-margin mode
- Named range manager always display "Document (Global)" when launching
- Make the font replacement table easier to understand
- The Type bar in Options - LibreOffice - Paths dialog does not invert the list of paths
- FILEOPEN DOCX Rotated drawing in chart has wrong width/height
- FILEOPEN DOCX Empty paragraph after two consecutive breaks gets numbering
- CRASH: Opening animation sidebar pane after inserting a shape
- gradient missing under RTL from writer comment margins
- No tooltips for Sidebar tab bar buttons (Windows, kf5, gen)
- Setting width of rotated custom shape results in wrong rotation angle
- JPEG looks as a black rectangle in Writer
- Clicking the position and size box without an object selected disables future selection.
-short read
-08 null deref
-70 [abrt] libreoffice-core: (anonymous namespace)::signalHandlerFunction(): soffice.bin killed by SIGABRT
-conditional style with no conditions is displayed as un-conditional style after reloading document
-SIDEBAR: Paragraph dialog and SideBar Paragraph Content Panel -- using different source for their Line spacing values
-TOOLTIP: Page number tooltip doesnt appear in document with a single page
-AutoCorrect: After Removal of Replacement Entry the Replacement Itself is still Performed.
- autocorrect incorrectly includes characters in change tracking
- FILEOPEN: XLSX - Unable to interpret 'Formula is' type conditional formatting rule
- UI / german translation: dialogues in english if path has umlauts (accented chars)
- Hanging punctuation doesn't work
- Conditional Formatting CELLIS and BEGINSWITH not working correctly (Xlsx)
- Accessibility: Writer crashes while browsing the images if Orca is on
- Release Notes button leads to English RN on Chinese system
- Impress: Animated video GIF, WMV, AVI do not play anymore in GDI with some video cards- OK with Shift+F5 on slide (OK in OpenGL or Skia)
- "Insert > Field > More Fields" dialog is too high/tall - the OK/Cancel buttons get hidden behind the bottom panel of 'gnome-panel'
- Android Viewer: Doesn't display form controls [Armin Le Grand (allotropia)]
- Go back in presenting mode leads to dropped animation steps
- FILEOPEN PPTX: text box renders vertically instead of horizontally
- *.appdata.xml should be installed in /usr/share/metainfo
- "Sort" Dialogue Box Too Large for Long Sort Keys
- The left arrow key causes objects to disappear.
- Grid does not work in RTL sheet.
- Hatch background changes after saving and re-opening
- ROUND() large numbers to decimals and to negative -5 decimals inaccurate
- Cursor position wrong when using functions in a table (GTK3)
- Number format preview uses dark background and font
- Crash in LO Base in MS Windows when creating auto-number using a variety of number types
- Crash when deleting cell rows (multi_type_vector::position#1707: block position not found!) ( steps in comment 7 )
- FILESAVE: RTF: Incorrect font properties
- FILEOPEN DOCX Image in table disappears after opening
- Some imported tif images are being truncated and thereby corrupted
- UI: The border dots in properties -> table borders arrows have purple background (not skia)
- Selecting a tree view row with a check box entry toggles the entry
- Last paragraph of inserted text from ODT file does not retain paragraph style.
- Format - Title Page dialog specifies a Page 1 restart for non-title page, but that is lost on fileopen.
- CRASH: adding a new animation after defining a motion path
- Position and size of rotated and cropped image off after DOCX export
- Object not properly filled with gradient after scroll down up (not skia specific)
- Assertion error when saving docx file to doc
- Deprecation warnings when building against Python 3.9
- FILEOPEN DOCX: A shape in front of textbox is position behind textbox (fine with DOC)
- elementary: Proposal to Revert All Blue-Violet Color Arrow Pair to One Coherent Color
- FILESAVE XLSX Conditional formatting of “Cell value“ type and condition “contains” or “does not contain” does not get saved
- elementary: Update Arrow for Import and Export Icons
- elementary: Update Pencil Element to Be Yellow
- elementary: Update shapes and line to be violet
- elementary: Update Color to Follow Upstream's Brand
- CRASH on Paste from clipboard into dialog or other floating window, paste to document canvas is fine; Windows only?
- EDITING Changes-in-margin: $2 appears in margin after undoing paragraph deletion
- faulty expressions cells show incorrect value
- Crash when deleting page break and undo
- Incorrect bounds on formula DEC2HEX
- [UI] elementary: icons for (work)sheet does not represent actual sheet
- Title Page: Page number in "Reset page numbering after this page" defaults to 0 instead of 1
- [UI] elementary: Proposal to remove green header row part in table icon
- EDITING: Closing of query from design view leads to crash
- example Euler-Lagrange equation is wrong
- UI: LibreOffice product flavor Community branding
- A new "Community Edition" motif for Start Center
- [UI] elementary: Change Comment/Note/Annotation Appearance to Be Rounded Rectangle Bubble
- FILESAVE XLSX Conditional formatting is not applied in RT file in Excel
- "Select All" type selection with a table in it is removed when switching between windows. [Tamás Zolnai]
- GTK3: Sidebar: incorrect extra field in Line Spacing Control