不想花錢買Office？LibreOffice能取代嗎

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 tdf#99646
- 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 tdf#38093

Table formulas:
- Added several table formulas for Word interoperability
- PRODUCT table formula tdf#123388
- ABS table formula tdf#123354
- SIGN table formula tdf#123390
- COUNT table formula tdf#123356

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

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

Performance:
- Speeded up find/replace operations tdf#119286
- 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

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. tdf#34686 (Martin van Zijl)
- Now you can select items in Autofilter window clicking by all item's row, but not only by checkbox tdf#116675
- 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. tdf#47349 (Justin Luth, Collabora)
- Added "Reset All" button to Solver dialog tdf#134528 (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 tdf#40993, tdf#59585
- Select merged area wholly to fix the selection rectangle during fill, fixing incomplete attribute copying, bad grid and border tdf#43958
- Apply correct linear sequence of numbers by skipping empty overlapped (invisible, i.e. not top-left) cells of the merged areas tdf#88782

Changed spreadsheet functions:
- Now INDIRECT function supports sheet-local scoped names tdf#100818

Performance:
- Improved spell checking performance in Calc core commit bdd149b1
- 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. tdf#122419, tdf#133878

Impress & Draw:
- Adding visible digital signatures to existing PDF files with Draw. Blog post
- Now Impress allows changing animations for several objects at once tdf#126394
- Presentation console has an "Exit" button now tdf#90978
- Presentation console has a "Pause/Resume" button now tdf#128964
- Added realistic soft blurred shadows for objects tdf#48722
- 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. core commit 0643dab6
- New examples in Element pane. core commit 2b29e16e, core commit ad8485eb (Laurent BP)

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 tdf#134646
- Show all supported files by default when adding a new extension in Extension Manager core commit 6a32706e
- Print preview is now updated asynchronously to not block UI when adjusting settings in print dialog core commit 93c833e8

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 tdf#118148
- Syntax diagrams exist for all Basic statements, including a new How to Read Syntax Diagram page tdf#131416

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 tdf#132271
- Add formula import in text tables core commit 68e74bdf and core commit 782700c6
- Export formula fields tdf#118682 and formula cells tdf#133163 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 tdf#123355
- 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 tdf#128195

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 tdf#117463

Notebookbar:
- New widget with styles preview was added to the tabbed Notebookbar. core commit b982be12

Localization:
- New languages/locales with locale data:
- English Kenya [en-KE] tdf#115436)
- English (Hong Kong) [en-HK] tdf#135518)
- 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

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
- [LOCALHELP] Review help pages for Templates
- 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
- Problems connecting to OneDrive and Google Drive
- 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
- FILESAVE XLSX Rotated shapes change their X/Y position on export
- 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
- Crash report service is not documented
- PPT: FILESAVE: Crop image is gone after RT
- Add more tips of the day (and make it module-specific eventually)
- FILESAVE: DOC: Cropped images are lost after RT
- 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)
- 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
- "Freezing Rows or Columns" help uses slightly wrong path
- 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
- EDITING Moving large shape upwards makes its textbox fall out of it
- 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
- [ko] Extend Autocorrect list for Korean language
- Corrupted calc file: invalid number format condition [ Properties opens dialog named "Slide setup"
- 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
- 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
- Border control in property dialogs use black color even on dark theme
- Crash in: swlo.dll
- 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
- Crash swlo!SwNodeIndex::~SwNodeIndex+0x18 (gen)
- FILEOPEN: Calc chart embedded basic custom shape text missing (ODF import)
- impress template thumbnails are blurred
- 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
- 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 )
- FILEOPEN EMF: The EMF image is shifted after opening
- 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
- EDITING Validation circles not updated when circled cells get merged
- Artifacts in some impress templates
- FILEOPEN: error discovered in the file in sub-document content.xml (fastparser)
- 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
- Repeated data in Tables of File Conversion Filter Names
- "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
- 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
- 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 [Ming Hua]
- 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' [Kevin Suo]
- 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.
- GTK3: Sidebar: incorrect extra field in Line Spacing Control