News: 1626355808

  ARM Give a man a fire and he's warm for a day, but set fire to him and he's warm for the rest of his life (Terry Pratchett, Jingo)

LibreOffice 7.2 release candidate reveals effort to be Microsoft-compatible

(2021/07/15)


The Document Foundation has released LibreOffice 7.2 RC1, including a large number of fixes intended to improve import and export compatibility with Microsoft Office.

Version 7.2 of LibreOffice, the most popular free and open-source productivity suite, is set for full release in mid-August. New versions appear roughly every six months: 7.0 arrived in August 2020, and [1]7.1 in February 2021 .

The [2]list of what's new is extensive, though most new features are small tweaks or bug fixes. One of the more notable is the ability to have multiple columns in text boxes in LibreOffice documents including Writer, Calc, and Impress – these being word processor, spreadsheet, and presentation graphics.

[3]

Writer is already multi-column capable in the main page, but this is for text boxes that you can float anywhere, in the manner of a desktop publishing application. At the moment, this feature is hard to find – you need to select text box, find Text Attributes in the Text box and shape menu – and seems a little buggy (on one text box we could not get it to work), but this is only RC1.

[4]

LibreOffice 7.2 Impress with new Candy template

In Writer there were also improved indexing with clickable hyperlinks to index marks in the document, background fills which can cover the page inside or including the margins, gutter margins in page styles, and some more improvements that are quite obscure, such as custom shading for annotated text ranges.

In Calc users now have the option of a "fat-cross" cursor instead of the usual arrow; Autofilter, for excluding rows via a drop-down at the top of a column, can now use colour as a criterion; and some functions have been tweaked. Impress and Draw have refreshed templates.

[5]

The new UNO inspector now built into the core product

There is a big new feature for macro and extension developers, which is a developer tool panel for inspecting Universal Network Objects (UNO). UNO is the Apache OpenOffice and LibreOffice component model, performing a similar role to that of COM in Microsoft Office. Such tools have previously existed as extensions, but this one is built in and found under the Tools menu in all the main LibreOffice applications.

[6]US Patent Office to take only DOCX in future – or PDFs if you pay extra

[7]Lessons have not been learned: Microsoft's Modern Comments leave users reaching for the rollback button

[8]The Document Foundation updates LibreOffice Community to 7.1.1

[9]'It's where the industry is heading': LibreOffice team working on WebAssembly port

The tool lets you drill down into a document and see the interface names, services, properties, and methods of every object. It is also a journey into the past: the classes all beginning com.sun.star, referencing both Star Office (the original name of the suite) and Sun (which acquired Star Office). Handy for developers, no use to end users, except as a fascinating glimpse into the internals of the software.

The feature is the outcome of a Document Foundation [10]tender issued last year: "In order to make working with UNO objects easier and to avoid the need to always install extensions before debugging."

[11]

That aside, the major change in this release is formed of dozens of fixes and improvements to compatibility with Microsoft Office. LibreOffice is mainly supported by companies which offer commercial support for the product, and one can guess that features like "fix lost tables in footnotes and endnotes by converting them to floating tables during the import, and removing floating at the DOCX export" are a consequence of pain experienced by customers either trying to use LibreOffice with Microsoft's formats (.docx, .xlsx, .pptx) as the defaults, or importing and exporting to these formats to exchange documents with their customers and business partners.

[12]

Dozens of fixes to Microsoft Office compatibility, of which this is only a partial list

Microsoft Office also supports the OpenDocument (ODF) formats used by LibreOffice, but although compatibility is good for most general-purpose documents, it can be problematic in cases which depend on precise formatting or advanced features. When Microsoft introduced its rival XML document standard, Office Open XML, the most stinging critique from those who investigated it in depth was that at times the specification essentially said "do it like in Microsoft Office," making it hard to develop alternative conforming applications.

LibreOffice users will therefore be appreciative of the efforts to fix more corner-cases in OOXML import and export, though it is a shame that so much developer time has to be expended on compatibility work rather than core features. ®

Get our [13]Tech Resources



[1] https://www.theregister.com/2021/02/16/libreoffice_team_working_on_port/

[2] https://wiki.documentfoundation.org/ReleaseNotes/7.2

[3] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/front&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2YPBbmy9@CqmZmGauWBOHlwAAANI&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0

[4] https://regmedia.co.uk/2021/07/15/libreoffice.jpg

[5] https://regmedia.co.uk/2021/07/15/devtools.png

[6] https://www.theregister.com/2021/05/27/uspto_pdf_charge/

[7] https://www.theregister.com/2021/05/20/word_modern_comment/

[8] https://www.theregister.com/2021/03/05/libreoffice_7_1_1/

[9] https://www.theregister.com/2021/02/16/libreoffice_team_working_on_port/

[10] https://blog.documentfoundation.org/blog/2020/07/27/tender-for-implementing-support-for-a-dedicated-built-in-uno-object-inspection-tool-in-libreoffice-202007-02/

[11] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/front&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44YPBbmy9@CqmZmGauWBOHlwAAANI&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0

[12] https://regmedia.co.uk/2021/07/15/fixes.jpg

[13] https://whitepapers.theregister.com/



"improve import and export compatibility with Microsoft Office"

Pascal Monett

I applaud the effort, but it is misdirected.

It is Borkzilla that should improve its compatibility with the Open Office standard.

That said, we all know what standards mean to Borkzilla . . .

Re: "improve import and export compatibility with Microsoft Office"

Anonymous Coward

I agree, but if they can tread into MS territory it opens up options.

We've looked at open office and libre office before in health care and been very close to adopting one or the other over MS office - that would be huge if we did.

Backwards and clinical system compatibility has always held us back.

Re: "improve import and export compatibility with Microsoft Office"

AMBxx

Given Microsoft's dominant market share, why would they spend time improving compatibility with anything else?

Bit like testing a website compatibility with users of old browsers - they might make a lot of noise, but there aren't very many of them, so don't waste your time.

Use early Microsoft formats where possible for interchange

Duncan Macdonald

If you are using LibreOffice and want to send a document or spreadsheet to another person where you do not know what he/she is using then the best bet is to send it in old Microsoft formats (Word 97 for documents, Excel 97 for spreadsheets). All versions of MS office (and LibreOffice/OpenOffice) seem to be able to read these formats without corruption - this is not always true for later formats.

Re: Use early Microsoft formats where possible for interchange

Snake

True. Or, even better if the recipient only needs to read your output, convert to PDF.

Personally I hate when general senders email us their DOC or XLS file directly. Thanks to VBA et al, it is a giant security risk to open up anyone else's files (even though I have auto run turned off on my own desktop, of course).

Just because I have auto run turned off and know not to allow the script does not mean that others follow the same rigid guidelines; I immediately delete all emails with a document attachment so as to prevent the others from attempting to open the file. I'll ask if anyone needs that email restored and then check it myself before allowing them to continue.

Re: Use early Microsoft formats where possible for interchange

Tom Chiverton 1

Because nobody ever put a self executing virus in a PDF...

Any fool can paint a picture, but it takes a wise person to be able to sell
it.