okay so what's going on with office software

the OnlyOffice mess is garden variety xenophobia that people who know better on here are amplifying, that's easy

what the fuck is going on with LibreOffice and Collabora

@whitequark wait wdym xenophobia? wtf did I miss?
@solonovamax @whitequark this I assume: www.techspot.com/news/111952-new-onlyoffice-fork-europe-answer-microsoft-office.html

Though I must say, on the other hand Only office seems to be trying to catch 22 that AGPL license (requiring use od their logo and preventing use of their trademarks, which would include their logo, at the same time). I think even if they took it to court they might lose this as 7(b)mandates the requirement for attribution to be "reasonable", and this quite clearly is not, but I'm not a copyright lawyer.
A new OnlyOffice fork is Europe's answer to Microsoft Office

Developed by a consortium including Nextcloud, Ionos, and Proton, Euro-Office builds directly on the open-source OnlyOffice codebase. It offers a word processor, spreadsheet editor, presentation tool, and...

TechSpot
@whitequark as someone who's tried libreoffice/collabora/nextcloud stack and tried separating it all, yeah
the entire companies and projects seem to just be all over the place and not have the right docs for what you actually need to know, it's mainly just marketing words and architecture with not much on how/why re: deployment in any situation
i have no idea about how it's being run though

we Really wish we could find a good hostable & desktop office solution, preferably with multiple tables per spreadsheet like apple numbers, but we're just stuck using apple numbers and libreoffice via smb which makes macOS very unhappy on a train's wifi
@whitequark has LibreOffice gotten any better recently? god it was awful the last time I tried to use it, and I'll never forget the time one of my students who (with good intentions) moved some of our documents over to it and they were so irrevocably fucked afterwards that we just discarded all of the work he had done
@regehr you'd have to be more specific for me to give you an answer, like what was awful?
@whitequark it just didn't really seem to work, had trouble with basic document formatting and saving and loading and stuff. was a few years ago
@regehr always worked for me, even back when i was in high school. the interface is a little revolting but i feel the same about msoffice. hasn't had much issues making .docx's for my company a month ago for example
@whitequark @regehr I don't have particular issues with LibreOffice except some very slow loading of some files, I don't know why.
@whitequark might have been specific to what we were doing, I don't know. it's nice to have an alternative to the MS stuff, but I don't really use that either, unless forced, for work reasons
@regehr @whitequark I'm on Mac most recently, but lockups/force-quit are fairly common. I use it only when absolutely necessary, and remember to save often.
@regehr @whitequark I similarly found Write to fall short on basic "being a word processor" tasks like reliably formatting & loading/saving when I last used it 4 or 5 years back. Calc seemed less janky at the time.
@gsuberland @regehr yeah worth mentioning I've almost exclusively used Calc, that could be why
@whitequark @gsuberland I've not used that one at all, but nice to know!

@regehr @whitequark @gsuberland I use Write regularly but I don't really do anything wild with layout, if I want to do anything more complex than including some images I'll switch over to a desktop publishing tool.

So it works great for me 😅

@regehr @whitequark @gsuberland I use calc and write somewhere regularly. It's okay is, office 2000-like. But under Ubuntu with XFCE it has a terrible bug under exactly that combination with little chance of fixing. But it works well enough to be the only alternative for me rn

@regehr @whitequark interop with MS Office was not even minimum viable product quality at the time, too. documents made in Word would be unusably broken when loaded in Write, with stuff off the edge of the page, overlapping text in tables, different fonts and sizes, etc.

if it's gotten to an actually usable standard that would be very good news.

@gsuberland @whitequark what you are describing matches what I remember. just like not really possible to accomplish basic tasks.
@regehr @gsuberland @whitequark
I made a presentation with LibreOffice in 2019 and SVG rendering was so broken that I had to rasterize all my SVG images. As an example it was rendering the Chromium logo as an octagon instead of a circle.
@regehr @gsuberland @whitequark
Found it (it was a hexagon, not an octagon but the point is the same)
And this is not some specially crafted example, all my SVGs were broken in a similar way
@regehr @gsuberland @whitequark Perhaps I was just lucky, but I used it a lot in 2023 for school and I always managed to open files made in Word just fine in Write, and files I made in Write also looked completely normal in Word, it just worked flawlessly for me (the other libreoffice programs also worked fine but I didn't use them as much). Maybe it just got a lot better with time.
@lilyyllyyllyly @regehr @whitequark certainly possible! would be good if it is like that now.
@gsuberland @regehr @whitequark The file compatibility stuff is really hard; while the MS files XML is publicly specified, it's not very well specified, and there are multiple different embedded formats within those - which may or not be compatible even between MS products. I've fixed a few LO bugs now; last october I did a particularly funny Powerpoint numbered-lists import bug that showed incorrect death stats for a motorbiking club (most were not from biking :-) )
@penguin42 @regehr @whitequark yup. I used to work on this stuff at an old job, around 2012. the OpenXML spec tells you how the documents are structured, but doesn't tell you about special behaviours for specific IDs and indices that are de-facto reserved by MS Office. but that's not really an excuse for how bad it is when it comes to text going off page and tables being broken, cos I got both of those working myself in about 2 days as one of my first Office interop tasks back then.
@gsuberland @regehr @whitequark Right, I agree it does need improving. And yes about the docs not specifying behaviour - compare to say the PDF spec which are very well written; IMHO document format specs should be written as a strict explanation of how to transform the input into a result.
@penguin42 @gsuberland @whitequark I like to imagine the MS devs gritting their teeth and whispering "fuck you" every few minutes as they work on anything remotely supporting interop with their products
@regehr @gsuberland @whitequark That may also happen when the Office 365 online devs deal with compatibility with the desktop or Mac code 🙂
@gsuberland @penguin42 @whitequark I feel like a commercial product dominating the "office" domain was inevitable, since open source would never respond to the whims of large corporate customers the way MS did. but still, this all sucks.

@penguin42 @regehr @whitequark and that was in Delphi without an XML library. just rawdogged the strings. horrible but it worked.

for Excel interop I ended up writing a Delphi-to-.NET marshalling interop layer so I could load the ClosedXML library, which absolutely slaps and takes a lot of the pain away.

@gsuberland @regehr @whitequark How much did you actually implement? I mean it's not that hard to read/generate files with a handful of features; e.g. parsing a report generated by a specific company/word version, or generating a report with a handful of features - the tricky bit is implementing all of it; they say people only use a few % of a programs features, alas everyone uses a different few %.
@penguin42 @regehr @whitequark oh I know it's hard to implement all of it, but I had all the different font styles, sizes, etc. at the paragraph (named style) and formatted section levels, bulleted lists, links, tables with border styles, auto/explicit sizing, merged cells, images, and some other stuff, and supporting load/save. the biggest hurdle was just initially figuring out the reserved ranges where you couldn't set styles, once I got that done the rest came quick.
@penguin42 @regehr @whitequark obviously I wasn't also trying to render this to screen, but still

@regehr @gsuberland @whitequark

Around 15 years ago I was writing things in Libreoffice and then just printing them to PDF and submitting that. Never had a professor complain. It may not fit all workflows, but at least back then it was good enough to get me through college without a blink

@whitequark as I understand it Collaobra are a company that has lots of LO long time contributors and sell support etc - they also have a (open source) web based version with collaborative editing. LO was doing that a while ago but didn't get far and decided not to continue; but when Collabora announced their release, someone in TDF made an announcement that LO was working on it again (with no new code?), and then somehow the Collabora folks were pushed out of the board as competing interests.
@penguin42 right, yes, I got that. it's the "somehow" bit that makes me go "wtf"
@whitequark Yeh I'm not sure how it happened; I guess you could say that Collabora's web based version is now a LO competitor - so maybe that's reasonable; but as I understand it it shares a lot of code, and they do a heck of a lot of the LO work.
@penguin42 @whitequark as I recall there was a comment that the rules to be a board member involved not litigating LO, and so there was a rumor that something had occurred that suddenly threw that into effect
Let's put an end to the speculation - TDF Community Blog

Ideally, we would have preferred to avoid this post. However, the articles and comments published in response to Collabora’s and Michael Meeks’ biased posts compel us to provide this background information on the events that led to the current situation. Unfortunately, we have to start from the very beginning, but we’ll try to keep it brief. The launch of the LibreOffice project and The Document Foundation was handled with great enthusiasm by the founding group. They were driven by a noble goal, but also by a bit of healthy recklessness. After all, it was impossible to imagine what would happen after September 28, 2010, the date of the announcement. At the time, nobody could imagine that the companies that had supported OpenOffice.org until then would create a project to kill LibreOffice. Also, if the project were to be successful, it would require resources greater than those available, and above all, a deep management experience. Fortunately, the project grew quite rapidly. However, the founders’ different backgrounds and opinions were at the same time the reason for some bold decisions – many of which right – as well as a few mistakes, which are the root cause of some of the current

TDF Community Blog
@penguin42 @StaticRocket hm, that makes an unfortunate amount of sense.
@whitequark @penguin42 ah, yeah way more sensible than the rumors. Still crazy that they had a deadlock in their decision to rectify something that was jeopardizing their nonprofit status for that long.

@penguin42 @whitequark I am so out of date! Last I heard was when Microsoft gave up trying to trip over other office products and started supporting open standards. Was that a decade ago?

I smell signs of skulduggery, and I doubt it's all on one side...

Meanwhile I've been using Libre on Linux because it works, and Collabora on Android, for the same reason, blissfully unaware of all this manoeuvring :-)

edit: corrected trying error

@RupertReynolds @whitequark While it could be skullduggery, the other valid explanation is that even MS don't know how their format works.