Hugo Hacker News

LibreOffice 7.2 Community is strong on interoperability

commoner 2021-08-19 12:42:57 +0000 UTC [ - ]

The most interesting new feature of LibreOffice 7.2 is the heads-up display, which can quickly search for any menu option. It resembles the command palette in Visual Studio Code. The keyboard shortcut to activate the HUD is Shift + Esc.

GIF demo: https://www.omgubuntu.co.uk/2021/08/libreoffice-7-2-release-...

dsego 2021-08-19 13:03:22 +0000 UTC [ - ]

This is also known as a command palette in other programs, like sublime, vs code, win terminal and others.

I think Ubuntu had the right idea with building a similar feature into Unity, so every program could use it.

https://askubuntu.com/questions/131617/how-do-i-use-the-hud

ptx 2021-08-19 14:52:06 +0000 UTC [ - ]

Didn't Mac OS X do this years ago?

Edit: Since 2007: http://hints.macworld.com/article.php?story=2007102708084461...

dsego 2021-08-19 16:14:47 +0000 UTC [ - ]

Yes, but it's a bit gimmicky, more for novices and discovery than power users.

orangepanda 2021-08-19 13:25:13 +0000 UTC [ - ]

Wouldnt Microsoft Office's Search box be a better comparison?

https://support.microsoft.com/en-us/topic/find-what-you-need...

fartcannon 2021-08-19 13:33:53 +0000 UTC [ - ]

I was thinking it's a lot like AutoCAD.

Squarex 2021-08-19 12:59:16 +0000 UTC [ - ]

It's great but why does every app have to have a different shortcut. vscode, intllij idea and now libreoffice.

ChuckNorris89 2021-08-19 11:00:07 +0000 UTC [ - ]

Thank God. I'm a big fan of libre office but could never fully switch to it as 1/10 documents created in Word would just look broken when opened in libre.

>Microsoft files are still based on the proprietary format deprecated by the ISO in April 2008, and not on the ISO approved standard, so they embed a large amount of hidden artificial complexity.

Why isn't there an anti-trust lawsuit against this artificial monopoly on office formats?

thaumasiotes 2021-08-19 11:54:31 +0000 UTC [ - ]

>> Microsoft files are still based on the proprietary format deprecated by the ISO in April 2008, and not on the ISO approved standard, so they embed a large amount of hidden artificial complexity.

> Why isn't there an anti-trust lawsuit against this artificial monopoly on office formats?

What? You want it to be illegal for Microsoft to use a file format of their own design when implementing their own software?

marcodiego 2021-08-19 12:31:49 +0000 UTC [ - ]

Microsoft pressured ISO to approve their format but NEVER implemented it according to the specification. In the meantime, many governments adopted MSO with the promise that compatibility would evetually be the norm. It never happened.

I don't know if an anti-trust lawsuit is adequate, but governments should ban adoption of proprietary formats entirely.

fsflover 2021-08-19 12:38:58 +0000 UTC [ - ]

the_third_wave 2021-08-19 15:30:02 +0000 UTC [ - ]

Microsoft produced the boondoggle 'Office Open XML' formwat in reaction to the moves made by several large organisations to standardise on the Open Document format as used by OpenOffice et al. Microsoft reacted like they often did: they created their own 'open' format, deceptively named 'Office Open XML' to make it easy to confuse with the OpenOffice XML-based format and submitted it to standardisation bodies in the hope that one would bite. ISO - which already standardised the Open Document format - did, giving Microsoft a weapon to wield in any bidding war on which file format should be adopted as a standard.

I called OOXML a boondoggle because that what it was. Microsoft's documentation of the format consisted of a several thousand pages long semi-binary dump of the files produced by Microsoft Office - which are not much more than memory dumps containing binary blobs, poured into an XML container with vague descriptions of what the data types actually were - often no more than 'as produced by Microsoft Office version x.y'. A large portion of the original OOXML files consisted of blobs of binary MS Office data, making it close to impossible to implement that version by non-Microsoft entities. When pressured Microsoft agreed that the current versions of Microsoft Office were not producing 'standard-compliant' OOXML but that this would change in newer versions. Well, the future came, the OOXML format was cleaned up and documented so as to be interoperable but Microsoft never adapted Microsoft Office to the standard, instead producing its own iteration of 'the standard'.

In short, the only reason why they every produced OOXML - the 'standard' - was to use it as a club to wield in negotiations. They never meant for it to be an actual data interchange standard, they never aimed at having third parties stand on a like footing with regard to which version of OOXML was meant to be canonical. It was, and still is, meant to be a box to tick on a compliance list for getting large contracts, not a file format standard to which their products would be tailored. Their vision is whatever is produced by the latest incarnation of Microsoft Office is 'the standard', just like before.

The real question to be answered here is why ISO went along with this charade when they already had a working file format standard in the Open Document format. They could just have said 'no' like other standards bodies did, Microsoft could have been made to implement the ODF format and the world would be a better, more interoperable place.

So indeed, Microsoft should not be allowed to use a file format of their own design when implementing their own software while selling it as if it abides by an ISO standard.

fsflover 2021-08-19 12:00:31 +0000 UTC [ - ]

Yes, if they use it unfairly against the competitors while being a monopoly.

thaumasiotes 2021-08-19 13:59:52 +0000 UTC [ - ]

How would they do that?

fsflover 2021-08-19 14:06:59 +0000 UTC [ - ]

By using proprietary file formats rather than open standards, which forces users who share data into adopting the same software.

thaumasiotes 2021-08-19 14:25:51 +0000 UTC [ - ]

So your position is that any use of their own format is abusive in itself? The anticompetitive part of Microsoft Word is the bare fact that it exists? Under what circumstances would it be legal to use your own file format?

fsflover 2021-08-19 14:30:44 +0000 UTC [ - ]

The anticompetitive part is that MS Word has >90% (?) market and forces its users into proprietary formats. Now, anyone who wants to use an alternative software will likely have to interact with the users of MS Word and will have to buy and install MS Word.

thaumasiotes 2021-08-19 14:46:57 +0000 UTC [ - ]

If that were true, MS Word would never have gotten off the ground in the first place.

fsflover 2021-08-19 14:53:53 +0000 UTC [ - ]

I don't see any connection here.

thaumasiotes 2021-08-19 14:56:40 +0000 UTC [ - ]

Word was not the first word processor. Everything you're angry at Word about now was also true of the popular word processors that preceded it.

fsflover 2021-08-19 15:04:53 +0000 UTC [ - ]

At that time, word processors were not as widespread and user-friendly. Word was more user-friendly than alternatives, I think, and attracted many new users.

Or maybe it was just a luck for MS, who knows...

0zymandiass 2021-08-19 12:37:54 +0000 UTC [ - ]

Ironically, Microsoft Office also fails to render most of my ODP/ODT files correctly, which are open standards. One might infer it's by design...

squarefoot 2021-08-19 13:06:28 +0000 UTC [ - ]

> 1/10 documents created in Word would just look broken when opened in libre.

Versioning might play a role here. On Office I've often observed the tendency to use by default the latest format available, no matter if the poor guy on the other side will have to upgrade the suite to load it, therefore LibreOffice might come late since its developers for some time have to debug what Office already implements. I now set up all LO installations i do for me and other people to output where possible (Word, Excel, Powerpoint) in Office 97-2003 formats, so they hardly give problems on Windows machines. Nobody complained so far, as it is extremely unlikely that those "ancient" but well oiled formats don't support the features needed by 99.9% of users.

davidgerard 2021-08-19 13:22:16 +0000 UTC [ - ]

> as 1/10 documents created in Word would just look broken when opened in libre.

I don't believe you. Bug report numbers?

zxspectrum1982 2021-08-19 15:33:29 +0000 UTC [ - ]

LibreOffice Base is the only application I still use from time to time. I replaced Writer, Calc and Impress with WPS Office and never looked back.

https://linux.wps.com/

It's free but not open source but still it's so much lighter and fast and compatible than LibreOffice...

owly 2021-08-19 11:11:40 +0000 UTC [ - ]

Has anyone here successfully migrated a large organization from MSFT to Libre? How was user adoption and feedback? Any specific issues to report when collaborating with external organizations using MSFT?

xcambar 2021-08-19 12:38:53 +0000 UTC [ - ]

My current employer is a juggernaut (10k+ employees worldwide). I've had that discussion, and among answers I've received, the most prominent were:

* compatibility with external docs (incoming) and external systems (outgoing)

* the whole Office365 suite provides sharing out of the box

* preexisting knowledge of the Office suite

* Excel is just better

It looks like the most unfair advantage of Office is that it is already everywhere.

2Gkashmiri 2021-08-19 12:47:13 +0000 UTC [ - ]

I often had compatibility bugs with excel files around 2-3 years ago. What would happen is, I see a visual bug for example and the next update often fixed it.

For the last year or so I have switched completely to LO which has been a little rough but not difficult.

Calc has native =regex which is a killer feature

fartcannon 2021-08-19 13:36:55 +0000 UTC [ - ]

And you can script it with python.. which is just incredible.

ChuckNorris89 2021-08-19 11:45:28 +0000 UTC [ - ]

I saw the hospital in my hometown be fully on libre, although on Windows 10.

commoner 2021-08-19 12:37:14 +0000 UTC [ - ]

There are a ton of case studies listed in https://en.wikipedia.org/wiki/OpenDocument_adoption that might be useful.

owly 2021-08-19 15:51:37 +0000 UTC [ - ]

Thanks all!

spacemanmatt 2021-08-19 15:34:34 +0000 UTC [ - ]

I just wish I could get the DB form builder to work without crashing. I've become quite the Calc fan, due to needing to deal with Excel docs from my team constantly. (Also, csvkit is saving my bacon)

teilo 2021-08-19 15:28:11 +0000 UTC [ - ]

This is the first LibreOffice in ages that made me trash my user preferences (on Mac). It was unusable after installing over 7.1. Completely locked up on almost everything.

roenxi 2021-08-19 12:58:05 +0000 UTC [ - ]

Linux user, 100% LibreOffice, no choice & no complaints. But it is funny how MS office just always seems to have the edge.

Honestly this is one of the areas where I think a government sponsorship program to encourage open formats and the tools to work with them would be good. MS Office is one of the great productivity tools of the 21st century. It is unbelievable how much has been done with it. But the document locking will be long term harmful.

LibreOffice is competing with a software leviathan here. There aren't many beasts bigger than Office.

2Gkashmiri 2021-08-19 12:43:53 +0000 UTC [ - ]

The changelog lists a lot of compatibility bug fixes with ms office files in the recent updates including this one so one might say they are going in the right direction.

I have around a dozen bugs open on their bugs page which gets some attention but I suggest everyone to do bug reporting. Heck, I often write bug reports for lazy people which would get picked up.

sdze 2021-08-19 12:29:38 +0000 UTC [ - ]

Did they finally manage to render a nice UI for mac Retina displays?

commoner 2021-08-19 12:33:31 +0000 UTC [ - ]

Yes, the HiDPI bug on macOS was fixed in LibreOffice 7.1.2:

https://bugs.documentfoundation.org/show_bug.cgi?id=138122

sdze 2021-08-19 13:42:55 +0000 UTC [ - ]

Thx

ubermonkey 2021-08-19 12:42:58 +0000 UTC [ - ]

If they had focused on true interop with Office a decade ago, then they'd have more traction (and credibility) here.

Back when Office was absurdly expensive, the need for a free/Free option was pretty huge. I don't see that need now -- I mean, I get that there are free-as-in-freedom types who will always choose LO over MS Office, and good on them for it, but that's an uncommon position. In every collaborative business context I've ever been in, using something OTHER than true-blue MS Office was a recipe for sadness. This-or-that formatting wouldn't work. Macros wouldn't work. Templates and styles wouldn't work. It's always been a nightmare.

We'd put up with it if there was literally no other way, but now that Office is both affordable and much, much more broadly available, I don't see any reason to experiment with LO at all.

davidgerard 2021-08-19 13:24:35 +0000 UTC [ - ]

I sincerely believe this is actually a made-up problem. It has literally always been an excuse, not an actual issue.

My evidence: nobody EVER bags Google Docs over its terrible DOCX compatibility. It makes an absolute hash of DOCX.

Have you ever heard anyone complain of this? No you haven't.

The claim that this was the killer issue was always just an excuse.

ubermonkey 2021-08-19 16:11:43 +0000 UTC [ - ]

>My evidence: nobody EVER bags Google Docs over its terrible DOCX compatibility. It makes an absolute hash of DOCX.

This is probably because most orgs that use Google Docs don't care about DOCX compatibility. But the vast majority of offices use MS Office, so Docx compatibility is a big damn deal.

But! I will say that I absolutely HAVE heard many, many people reference the lack of docx compatibility as a reason NOT to use Google Docs -- or anything else that isn't Office.

Even if we entertain your idea, though, and this isn't really a reason people don't use LO (even though it is), what then is the REAL reason people don't use LO?

fartcannon 2021-08-19 13:38:34 +0000 UTC [ - ]

FUD, to use the old term.