Category: Development

LibreOffice’s native file format is OpenDocument, a fully open and standardised format that’s great for sharing documents and long-term data storage. Of course, LibreOffice does its best to open files made by other office software as well, even if they’re stored in pseudo-“standards” with cryptic and obfuscated contents. Compatibility with PowerPoint PPT(X) presentations is therefore a challenge, but developers are working hard on improvements…

In September 2019, we announced an initiative to improve the support of PPT and PPTX files in LibreOffice. A summary of achievements was published later that year. Now it is time for another review.

Everyone is invited to participate in the PowerPoint support initiative, either in development or testing. If you are interested in joining, please send an email to ilmari.lauhakangas@libreoffice.org.

Import/export

nd101 (PPT/X team):
Preserve table background colour when importing PPTX file

Preserve text position when importing PPTX file

---

Ayhan Yalçınsoy:
Export the scaling handle of custom shape

---

Gülşah Köse (Collabora):

Import table style in PPTX

Missing bullet in Smartart

Extra margin on second list level in SmartArt

---

Tamás Bunth (Collabora):

Chart labels in PPTX appear as “[PERCENTAGE]”

Performance

Gülşah Köse (Collabora):

Presentation does not move forward in Linux (not smooth in Windows)

A big thanks to everyone who helped out! We look forward to further updates.

Macros help users to automate common tasks in LibreOffice. In September 2019 we announced a new team in our community to work on macro support. A progress report was published in November 2019, so let’s review everything that happened since then.

If you are interested in contributing to the macro team (development, testing or documentation), we’d love to hear from you – please send an email to ilmari.lauhakangas@libreoffice.org and we’ll get in touch.

Wiki docs

Thanks to Nathan Ullberg, many wiki articles previously only available in French can now be read in English as well. Nathan also updated existing articles and created an article about manipulating LineShape objects in Impress. Detailed lists of his work can be found on his wiki user page.

Alain Romedenne worked alongside Nathan with the macro articles and translations. He added LibreOffice Basic cheatsheets from Jean-François Nifenecker into the wiki and created a new article concerning input/output to screen with Python. Alain also started creating syntax diagrams for LibreOffice Basic.

Code contributions from macro team members

Andreas Heinisch:

• cInt function treats, as decimal
• Tab label too low within macro editor
• Typename function does not return the correct data type of a numeric constant
• Consider an underscore to be part of a string
• Adding variable to Watch window performs incorrectly if variable name contains_underscores
• Default values of string type and object type for optional parameters are not processed
• Data Type Characters with literals don’t affect resulting value type
• Don’t convert missing parameters to requested type

Alain Romedenne:

• Tests for VBA Enum statement, VBA Err object raise method and LibreOffice Basic Property Get/Set

Code contributions from honorary associate members

Mike Kaganski (Collabora):

• A missing optional argument is treated as a not declared variable
• ReDim is slow when array custom type is explicitly known
• Unicode vs. password protected user libraries
• XTextTableCursor::setPropertyValue(“BackColor”, x) sets paragraph background color, not cell background
• Use actual string leading characters for correct precondition match
• Searching the CharEscapement attribute using regexes replaces additional text
• Various internal improvements to array handling and stability

Samuel Mehrbrodt (CIB):

• Base macros cannot be digitally signed
• Can’t compare text range in table with text range in body text
• XItemListener::itemStateChanged not fired when changing selection with arrows

Jan-Marek Glogowski (CIB):

• Don’t ask to add a trusted macro signature, if trusted macro signatures are read-only
• Creating a new document from a template removes the signature from all Macros
• Crash when terminating the StarDesktop from running a document macro

Caolán McNamara (Red Hat):

• Selecting items in a visible list box in a dialog is very slow
• Problem scrolling past lines 999 & 1000 in the LibreOffice Calc Macro editor, in either direction if View – Line Numbers enabled

Stephan Bergmann (Red Hat):

• Various internal improvements to stability

Help content

Improved by Alain Romedenne:

• IsObject Function
• Error Function
• Using Procedures and Functions
• Using Variables

Added by Alain Romedenne:

• Property statement

Improved by Mike Kaganski (Collabora):

• IsObject Function

Improved by Stephan Bergmann (Red Hat):

• Chr Function
• ChrW Function [VBA]

Thanks to everyone who worked on these tasks! Everyone is welcome to join our community and get involved – just email ilmari.lauhakangas@libreoffice.org and we’ll get back to you.

LibreOffice’s native file format is OpenDocument, a fully open and standardised format that’s great for sharing documents and long-term data storage. Of course, LibreOffice does its best to open files made by other office software as well, even if they’re stored in pseudo-“standards” with cryptic and obfuscated contents. Compatibility with PowerPoint PPT(X) presentations is therefore a challenge, but developers are working hard on improvements…

A few months ago, we announced an initiative to improve the support of PPT and PPTX files in LibreOffice. Lots of great work happened since then and the results are collected below!

Everyone is invited to participate in the PowerPoint support initiative, either in development or testing. If you are interested in joining, please send an email to ilmari.lauhakangas@libreoffice.org.

Import/export

Stephan Bergmann (Red Hat):

Speed up loading a PPT file with equation objects

---

Noel Grandin (Collabora):

Speed up loading a PPT file with equation objects

---

Miklos Vajna (Collabora):

Add PPTX import/export for semi-transparent shape text

PPTX import: don’t set shape fill from the style in case the background fill is already set

PPTX import: fixed duplication of math objects

---

Tamás Zolnai (Collabora):

PPTX export: don’t change shape’s background transparency

PPTX export: don’t lose the gradient background fill of a slide

---

Xisco Faulí (TDF):

PPTX import: display shapes with washout mode

PPTX export: handle image colour/graphics modes correctly

PPTX import: don’t lose text highlighting in table cells

PPTX export: save text highlighting

PPTX import: respect no fill colour for text

---

Gülşah Köse (Collabora):

PPTX import: implement z-rotation of 3D text transformation

PPTX export: preserve textbox rotation attribute

---

Tamás Bunth (Collabora):

PPTX import: custom date as custom XTextField

---

Mark Hung (PPT/X team):

PPTX import/export: handle complex text properly

PPTX import: reset font settings, if necessary

---

Luke Deller (PPT/X team):

PPTX import: Fix IsTransparent() for unloaded graphics

---

Housekeeping

Julien Nabet:

Save/restore locking properly in ImplSdPPTImport::Import

sd: prefix members of SdrPowerPointImport

cppcheck: fix 2 funcArgOrderDifferent

---

Various

Mike Kaganski (Collabora):

PPTX export: disable undo during save

Thanks to everyone for their great work!