הערות הפצה/6.4
TDF LibreOffice Document Liberation Project בלוגים קהילתיים Weblate Nextcloud Redmine Ask LibreOffice תרומה
Writer
- Added option to mark comments as resolved in Writer (Scott Clarke, Codethink) tdf#119228
-
A resolved comment
-
The menu of a resolved comment
-
An example of a visible resolved comment
-
The same comment made invisible
- Fix missing change tracking layout of numbers and bullets of lists (László Németh, NISZ) tdf#42748
-
Original list
-
Joined list item 1–2, split list item 2, removed list item 3 in Hide Changes mode
-
Original Show Changes mode: numbers didn’t show tracked changes
-
Now: numbers are formatted by according to tracked changes
- The btLr text direction is now available in Writer Text Frames as well blog post (Miklos Vajna, Collabora)
-
Bottom-to-top, left-to-right text in frames
-
The bottom-to-top, left-to-right text direction in frames can be adjusted from the properties menu.
- It is now possible to comment on Writer images and charts, blog post (Miklos Vajna, Collabora)
-
A comment added to an image in Writer.
-
A comment added to a chart in Writer.
- It is now possible to automatically avoid overlapping shapes with a new wrap option, blog post (Miklos Vajna, Collabora)
- Add proposal for anchored object overlapping to OASIS ODF draft 9e827baed18bbcd410029dbcb81ac5a0da2cc6b4
- Make it possible to set anchored object to overlap tdf#124600
-
The "Allow overlap" checkbox is located in the edit option of the Wrap function for shapes.
-
Uncheck "Allow overlap" to automatically disable the overlapping of shapes.
- Improved performance when importing files with many bookmarks (Michael Stahl, CIB) b5b607cf5afe6ebf5964102770a52965f5b98533
- Selection of drawing objects anchored at-paragraph works more consistently and user-friendly now (Michael Stahl, CIB) 91b2325808a75174f284c48c8b8afc118fad74e4
- A banner (or "infobar") is now shown when a document can't be formatted properly because of missing hyphenation rules. (Samuel Mehrbrodt, CIB) tdf#128191
טבלאות
שיפורים חשובים בטיפול בטבלאות (László Németh, NISZ)
- Fast table moving & deletion: Cut command cuts the selected table instead of removing its text content tdf#118311
- Fast table row/column moving & deletion tdf#127759
- Cut command cuts the selected table rows or columns, if they are selected by enhanced table selection (clicking in front of them)
- After that, paste command inserts the removed table part before the actual row/column
- New Paste Special menu options for pasting table data into tables (in table popup menu and Writer’s Edit menu)
- Paste Special menu option "Paste as Nested Table" tdf#37156
-
Paste nested tables in Writer
- Paste Special menu options "Paste as Rows Above" and "Paste as Columns Before" tdf#64902
- Improved drag & drop mouse operations to move table data
- move the selected table instead of duplicate it tdf#84806
- move rows and columns (selected by enhanced table selection) and wholly selected tables by inserting new table rows above or columns before instead of overwriting cells of the target table. In the case of moving (not copying, i.e. without using the key Ctrl during drag & drop), the selected rows and columns are removed completely, instead of emptying their cells. tdf#35570
Calc
- Improved selecting cells which contain hyperlinks (Samuel Mehrbrodt, CIB) tdf#126393
- On
MM:SS
or[MM]:SS
orMM:SS.00
or[MM]:SS.00
pre-formatted cells a two digit groups input like 12:34 is now accepted as minutes:seconds value instead of the usual hours:minutes:00 value; to force the usual hours:minutes:seconds input on such cells enter three digit groups like 12:34:00. (Eike Rathke, Red Hat, Inc.) tdf#76441 - Improved scalability of formula-groups computation on CPUs with large number of cores by potentially threading multiple independent formula-groups together. (Dennis Francis, Collabora) 845e1c
- Implemented a parallelized version of super scalar sample sort algorithm (read the paper here) to speed up sorting. This is now used in pivot-table creation where some sorting is required. (Dennis Francis, Collabora) 46d0af
- Shading of columns/rows headers is removed; the headers are drawn flat now. (Heiko Tietze) tdf#127508
- Deleted a 15 symbols limit to password length for XLSX files (Eike Rathke, Red Hat) tdf#97086
שיפורי ביצועים
- speed up opening of XLSX file with lots of comments (Noel Grandin, Collabora) tdf#129228
- speed up loading Calc documents with lots of COUNTIF() (Noel Grandin, Collabora) tdf#128812
- speed up saving XLS with lots of styles (Noel Grandin, Collabora) tdf#126021
- speed up loading of change-tracking ODS files (Noel Grandin, Collabora) tdf#125688
- speed up copy operation with lots of comments in Calc (Noel Grandin, Collabora) tdf#76324
Whole sheet export
Thanks to the new Whole Sheet Export setting of the PDF export options, it is now possible to export your files in Calc to PDF with all pages on a sheet as one page in the PDF. This allows the users to see the full content of a spreadsheet document in a pdf form, without the usual slicing of the sheets into printable pages.
68dc00 c11d96 e23496 45122e (Muhammet Kara, Collabora)
How to use it?
- Open your spreadsheet document in LibreOffice Calc
- From the menu, select ▸
- On the General tab of the PDF Options dialog, check the option named Full-Sheet Previews (since version 6.4.1 renamed to Whole sheet export)
- Click the Export button, and choose a location for your preview pdf
- Enjoy your pdf file of full sheet previews
-
Full-Sheet Previews option
-
Sample spreadsheet
-
Usual PDF output of the sample sheet
-
Full-sheet preview pdf of the sample sheet
Available in the Online API
The new full-sheet preview feature has also been added to the Online REST API. The command below can be used to get a full-sheet preview output of a spreadsheet document in the PDF format:
curl --insecure -F "data=@YourSpreadSheetDocument.ods" -F "FullSheetPreview=true" https://localhost:9980/lool/convert-to/pdf > out.pdf
Please note that using the --insecure
option is only needed while testing the feature on a local setup, and we recommended against using it for non-testing cases.
XML Source
- XML structure containing nested repeat elements can now be imported. (Kohei Yoshida)
- It is no longer an experimental feature, and is enabled by default without having to enable experimental features. (Kohei Yoshida)
- Improved stability and fixed some rare-occurring crashes. (Stephan Bergmann, Kohei Yoshida)
פונקציות גיליונות נתונים שהשתנו
Impress / Draw
- הפריט ‚הסרת היפר קישור’ נוסף לתפריט ההקשר ב־Impress (Samuel Mehrbrodt, CIB) tdf#111707
- הפריט ‚איחוד טקסט’ שמשלב מספר תיבות בחירה לאחת (בעיקר כדי להקל על עריכת תוכן מפוזר ב־PDF). (Justin Luth, SIL) tdf#118370
-
Combine text boxes from e.g. imported PDF files in Draw
- מעתה אינטראקציה מופעלת רק במצב הצגה (when clicking on an object). למצב עריכה, נוסף תפריט הקשר „הפעלת אינטראקציה” . (Samuel Mehrbrodt, CIB) tdf#125748
- מפות תמונות מכבדות את ההגדרות שדורשות Ctrl-לחיצה כדי לפתוח קישור (Samuel Mehrbrodt, CIB)
- Hyperlink in Image Maps now work in Slideshow too (Samuel Mehrbrodt, CIB) tdf#74045
Performance improvements
- Speed up opening of some PPT files (Noel Grandin, Collabora) tdf#121740
- Speed up: Long operation during typing in list with animations (Serge Krot, CIB) tdf#129708
Base
Access2Base callable from Python: The Access2Base API for Base users can from the 6.4 release on be invoked either from Basic (as usual) or from Python. In the latter case, the Python process may be running from inside or outside (via sockets) the LibreOffice process. Basic and Python may be mixed in the same application.
Example: run from a Python console (or from a Python script)
<div lang="en" dir="ltr" class="mw-content-ltr">
from access2base import *
db = Application.OpenDatabase('C:\...\... .odb')
rs = db.OpenRecordset('SELECT * FROM [EXPENSES]')
data = rs.GetRows(1000) # data contains a tuple of (max 1000) Expenses records
</div>
More to read on the documentation page.
(Jean-Pierre Ledure)
Firebird embedded database creation put back experimental considering the number of bugs.
BASIC
- Macros: When converting Hex strings of negative value, treat the high-order bit always as sign bit, e.g., &H8000 = -2^15, &HFFFF = -1, and &H7FFFFFFF = 2^31-1. Behaviour is identical in either modes, i.e., LibO Basic, with Option Compatible, and Option VBA Support 0/1. (Andreas Heinisch) tdf#62326
- Implement Save As Word 2000 and Save As for Word.VBA-document (Tor Lillqvist, Collabora) 0f1458cff56e2be9614acc9357fd10099bb5e8ab
- Fix handling for function that does not has closing parenthesis. (Pierre Lepage; Mike Kaganski, Collabora) tdf#80731
ליבה / כללי
- הנתיבים הפנימיים מופיעים מעתה במנשק המשתמש (Samuel Mehrbrodt, CIB) tdf#126088
- הוספת תיבת סימון כדי להפעיל/להשבית שליחה של דיווחי קריסות אל TDF (Gabor Kelemen) tdf#107471
- Hyperlink context menus were unified. Every hyperlink now has the following context menu entries: (Samuel Mehrbrodt, CIB)
- Open Hyperlink
- Edit Hyperlink
- Copy Hyperlink location
- Remove Hyperlink
- Generate QR Code feature is added in LO (Shubham Goyal, GSoC; mentors: Thorsten Behrens, Samuel Mehrbrodt)
- To generate a QR code in LO apps (Impress, Draw, Writer or Calc), go to ▸ ▸
- The QR code generator takes 3 inputs:
- URL/Text: For which QR code is to be made.
- Correction: Select the complexity of QR code. More complex QR can recover better if destroyed. "Low" is preferable for long URLs.
- Border: A border around the generated QR code-
-
QR Code Generator
-
Generated QR with above parameters
- Extend redaction feature with Autoredaction, blog post (Muhammet Kara, Collabora)
- Speed up compiling (Luboš Luňák, Collabora) ceb26770b3d1c5c2ffaf73f8f589c5e169e6db06 dc79dc76f18148296ae18ed7251cf61505e25d44
עזרה של LibreOffice
- דפי עזרה לפונקציית פורייה של Calc וניתוח פורייה. הגשה (Olivier Hallot)
- Help (online version) has now a local search engine xapian-omega with faster and more precise search results. (Olivier Hallot)
- Many Help pages have now localized screenshots for a better user experience. For example, here, here and here. (Olivier Hallot)
-
Screenshots of dialogs in Help pages
מסננים
Improvements of Excel 2003 XML import filter:
NOTE: The core functionality of importing Excel 2003 XML files is provided by the orcus library.
- Fixed issues with importing files encoded with UTF-16. (Kohei Yoshida) tdf#123553
- Fixed issues with importing files containing named color values. (Kohei Yoshida) tdf#126515 tdf#123880
- Fixed several XML parsing issues that affected importing of certain files. (Kohei Yoshida)
Improvements of DOC and DOCX import/export filter:
- Fix character formatting in combination of table and paragraph styles in docx import (Miklos Vajna, Collabora) c424a1f509205cfbaa3421bddfd6514b340a798a
- Subscript/Superscript (escapement): many improvements preventing position creep on every save, allowing escapement in character styles, more accurate placement of "automatic" escapement, and support for greater than 100% escapement. (NISZ and SIL) tdf#99602 tdf#120412
- The DOCX VML import now supports tbRl text direction for Writer Text Frames (used for e.g. Japanese text), blog post (Miklos Vajna, Collabora)
- Word-style continuous endnotes (not on separate page) are now supported and used for DOC files, blog post (Miklos Vajna, Collabora) 4814e8ca
- Improved import/export of DOCX abstract numbering (Michael Stahl, CIB) tdf#95848
- Improved import/export of DOCX list label formatting (Michael Stahl, CIB) tdf#64222
- Improved handling of Word text fields, including working Undo/Redo and a configuration option
Office::Common::Filter::Microsoft::Import::ForceImportWWFieldsAsGenericFields
to round-trip even nested fields in RTF and DOCX (Michael Stahl, CIB) - Improved import of DOCX continuous section breaks with different headers (Michael Stahl, CIB) tdf#112202
- Export of indexes to RTF is now possible (Michael Stahl, CIB) tdf#129574
שיפורים במסנן ייבוא/ייצוא של PPTX:
- SmartArt improving import and export (Grzegorz Araminowicz, Collabora) 5457ddf2f529daf5962abcba76dbaeccff0de826 29855141a874fa2d0d36959af6ae765eb3a05408
- Make gradient as slide background in Powerpoint PPTX roundtrip correctly (Tamás Zolnai, Collabora) tdf#127379
- Math objects from PPTX are now handled better, ignoring their replacement image, blog post (Miklos Vajna, Collabora)
Document Signatures
- Keep ODF macro signatures when modifying a document or creating a document from a signed template without changing macro code (Jan-Marek Glogowski, CIB) tdf#42316
מנשק משתמש
שיפורים כלליים
- להדמיות הממוזערות של המסמכים במרכז הפתיחה יש מעתה סמל שמציין מה המודול שלהן (Heiko Tietze, TDF) tdf#125756
Sidebar
- Added Table panel to Writer's Sidebar (Tamás Zolnai, Collabora) 83658678e69ba83979c659e37fd3c950942139f9
- Table panel now has more tools(Roman Kuznetsov) tdf#128683
-
New Table panel on Writer's Sidebar
- 6.4.1The Navigator now grays out the content categories that are not applicable to the currently opened document, reducing visual busyness. (Jim Raykowski) tdf#129625
-
Navigator with grayed out categories
ערכת סמלים
- Breeze & Sifr icon themes got SVG variant of dark version. (Luca Carlon & Rizal Muttaqin) tdf#128849
- Sifr icon theme got extra large 32px*32px support. (Rizal Muttaqin) tdf#129846
מקוון
- Make Impress side-bar available on iOS (Tomaž Vajngerl, Collabora) 173595f7c4ce8e2dc2fedfa78eedbff2f9efdb20
- Use the iOS Spelling function on Mac (Tor Lillqvist, Collabora) 2e28b198007b525ee66b9864677acdd8ff0d85c7
- Table properties in Writer - one of the many new features in LibreOffice online 6.4.0. multiple commits (Szymon Kłos, Ashod Nakashian, Pedro Pinto Silva, Collabora)
-
Side bar with Table properties in Writer online
- Add Table Resize Handles for iOS/Mobile (Tomaž Vajngerl, Collabora) tdf#126959
-
Table handles in Writer online
- In Writer online you have now full control over the Table of Contents multiple commits (Andras Timar, Collabora)
-
Full Table of Content dialog in Writer
- In addition to conditional formatting on the toolbar, there is now an (improved) Conditional Formatting dialog for iOS/Online (Mert Tümer, Collabora) d2b4b608696e7a6ba7ed15c97972aa8ed3707bb2
-
Full conditional formatting in Calc online
- Make it possible to move graphic elements to front or backwards on iOS/Mobile (Tomaž Vajngerl, Collabora) tdf#125566
- The sidebar now provides a wide range of features for selected charts. multiple commits (Ashod Nakashian, Henry Castro, Pranav Kant, Collabora)
-
Side bar with chart function in Calc online
- Color picker for text and background in presentations, lines in spreadsheets and presentations, text and background for floating frames in text documents. multiple commits (Szymon Kłos, Pranav Kant, Marco Cecchetti, Collabora)
-
Color picker in Writer online
- You can now use the full Function wizard in Calc online. multiple commits (Pedro Pinto Silva, Michael Meeks, Muhammet Kara, Collabora)
-
Full Function wizard in Calc online
- In Calc online you can now choose your favourite zoom percentage between 33% and 200%. commit (Michael Meeks, Collabora)
- More improvements... (Michael Meeks, Tor Lillqvist, Tomaž Vajngerl, Dennis Francis, Andras Timar, Muhammet Kara, Miklos Vajna, Ashod, Jan Holesovsky, Ashod Nakashian, Mike Kaganski, Collabora)
תפריט
נוספה אפשרות להסתיר את הסרגל (Samuel Mehrbrodt, CIB)
שורת מצב
נוסף תפריט נגלל לשורת המצב כדי לאפשר החלפה מהירה של שפת המסמך (Samuel Mehrbrodt, CIB)
התאמה אישית
שיטת ה־PostMessage הבאה נוספה כדי לאפשר את התאמת מנשק המשתמש: (Samuel Mehrbodt, CIB)
Remove_Statusbar_Element
כדי להסיר רכיבים משורת המצב
התאמות לשוניות
- Slovenian thesaurus updated (now contains more than 20.000 words) & icon and description added to sl dictionary extension. commit, commit (Martin Srebotnjak)
- AutoText in Writer: Complete all translated user interfaces with Formula Numbering (FN + F3) and Lorem Ipsum dummy text (LOREM + F3) (Laurent BP) tdf#81436
Scripting
Python
The bundled CPython has been upgraded to release 3.7.6
(Michael Stahl, CIB) b10be5d48433076f0b7238d818020f708553e114
הסרה / השבתה של תכונות
Java
הוסרה התמיכה בגרסאות 6 ו־7 של Java. נכון להיום Java 8 היא הגרסה הוותיקה ביותר הנתמכת.
GUI
GTK+2 VCL plugin
The GTK+2 VCL backend has been removed.
1ae450504cf57457f9702684b1517fda1dd3c481
תאימות פלטפורמה
Windows
- Allow setting a process memory limit for soffice.bin. (Jan-Marek Glogowski, CIB)
- This can be activated by editing the
bootstrap.ini
file. For more information read the comments at https://gerrit.libreoffice.org/#/c/78819/
[Win32] LimitMaximumMemoryInMB=0 ExcludeChildProcessesFromLimit=true
- Don't rely on Windows own recent-folder handling in the native file picker (Jan-Marek Glogowski, CIB) tdf#43021
- LibreOffice already saves and restores its recent folder, and Windows handling interferes with file pickers used from scripting languages.
Linux
Kf5 / Qt5
Kf5/Qt5 VCL plugin continues to close the functionality gap w.r.t. other VCL backends. Independent from fixed bugs, the most user visible improvements and changes are:
- Renaming the VCL plugin from kde5 to kf5 tdf#125922
- Fixed touchpad scrolling tdf#125201
- Fixed primary selection and other clipboard related problems by implementing a lazy clipboard tdf#122239
- Better support for modifier handling during drag-and-drop operations tdf#126560
- Correct grouping of LibreOffice module windows and dialogs in task bars tdf#125921 tdf#129071
- Qt theming of tabbed widgets tdf#105884
(Jan-Marek Glogowski, Katarina Behrens, CIB; Michael Weghorn, LHM)
The full list of bugs fixed in 6.4 and its maintanance releases can be found here. Further bugs and missing features are tracked via the KDE meta bug tdf#102495.
שינויי API
שינויים ב־API של UNO
General
com.sun.star.uri.XUriReference
andcom.sun.star.uri.XUriReferenceFactory
have been updated from conformance to obsolete RFC 2396 to conformance to RFC 3986. 5bbf9ca7- The behavior of
rtl_convertTextToUnicode
upon erroneous input has been changed slightly. ca6ddfcc - The following new properties have been added to MediaDescriptor. They allow locking down certain aspects per document. (Samuel Mehrbrodt, Serge Krot, CIB)
LockContentExtraction
: Forbids copying/dragging any text from the respective document to another document or applicationLockExport
: Prevents exporting document content to any fileLockPrint
: Disables all print functionsLockSave
: Disables the save functionLockEditDoc
: Disables switching to edit mode from read-only mode
Infobar
Infobar now has a UNO API (XInfobarProvider). You can add, update and remove Infobars via the API.
(Samuel Mehrbrodt, CIB) tdf#97926
- Example for Basic Macro is found in the commit message. 9e3ba7c3
Writer
- The behaviour of the XText::insertTextContent() implementation in Writer with regard to what text formatting is applied to the inserted content has changed in order to restore the behaviour that was in effect before an accidental change in LO 6.1/6.0.4 (Michael Stahl, CIB) 635bd7fbcb1d131627ba98fd9085dd2b11e0d33c
שינויי תצורה
- Improved the
DisableMacrosExecution
setting. When setting that option to true, any macro execution is forbidden (even in Basic/Javascript/Beanshell Editor). Also the corresponding menu entries are disabled now. (Samuel Mehrbrodt, CIB)