I fully support this. This is a very easy to implement. 99% of the documents don't require specific msoffice undocumented features
Technology
This is a most excellent place for technology news and articles.
Our Rules
- Follow the lemmy.world rules.
- Only tech related news or articles.
- Be excellent to each other!
- Mod approved content bots can post up to 10 articles per day.
- Threads asking for personal tech support may be deleted.
- Politics threads may be removed.
- No memes allowed as posts, OK to post as comments.
- Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
- Check for duplicates before posting, duplicates may be removed
- Accounts 7 days and younger will have their posts automatically removed.
Approved Bots
Yes, it would probably force microsoft to adhere to the specs if their files didn't work more users.
The actual article— Hacker News.
And also:
The European Commission has accepted our request, and starting from today – Friday March 6 – has added the Open Document Format ODS version of the spreadsheet to be used to provide the feedback. We are grateful to the people working at DG CONNECT, the Commission’s Directorate-General for Communications Networks, Content and Technology, for responding to our request within 24 hours. At this point, the rest of this message is no longer relevant, and the call for action is no longer necessary.
which complicates compatibility with open-source software such as LibreOffice.
Or any competitor. Which is why this "standard" should be declared anticompetitive.
"OOXML" is literally just an XML serialization of MS Office internal data structures that Microsoft bribed the standards body to push through.
"bribed" is a gross simplifiction of the almost hilariously evil plot they pulled to get OOXML certified. They actually bribed a couple of smaller nation states to become IETF members and vote for Microsoft's standard. It was a major scandal back in the day but formally legal.
I remember that plot also gumming up IETF business because the bribed nations just stopped participating after voting for Microsoft.
I remember, only trouble is a lot of people at the time didn't care or were paid loads of money to not care.
Also the name Office Open XML right at the time OpenOffice was the only one about before oracle came in and fucked it over
It's like noticing a car crash and looking back... you know you shouldn't and yet it's somehow mesmerizing. So... where can I actually read about this please?
FYI: it wasn't a bribe. It was a temporary takeover of the standards body. They paid for memberships of a bunch of new people on the board for the critical vote.
So, a bribe with the proper bureaucratic steps?
I think saying that they "bribed the standards body" suggests the body was in on it. The actual allegation (I don't know any facts, just these comments) seems to be that the body was subverted by other countries that were bribed by Microsoft. Being someone who doesn't know the details there's a worthwhile distinction there. Though that still opens questions about the board's reaction, and I might read up on it all later.
Let me assure you that the original board that was voting for Open Office's proposal was absolutely pissed off, short of dissolving but eventually unable to revert the decision because of it's formal correctness.
I kinda get it though. I think every single time in my life I’ve sent a document in the non-Microsoft format I’ve got a reply saying they couldn’t open it. That’s from LibreOffice and from Mac.
Trying to get tech illiterate people to use LibreOffice and to export their documents as PDF but they just keep sending the original files every single time... nightmare material
"Don't use that proprietary format ! Use PDF instead !"
PDF is also an issue.
There are often also accessibility issues with PDF files depending on how they were created.
For best results, print your word doc and scan it back in on a flatbet scanner. Fun fact you don't even need to keep the piece of paper square to the scanner.
Or just take a picture of your monitor and text it.
Hire a barbershop quartet to sing it to them.
Unrelated anecdote, my brother's then wife post a picture of them on Facebook. Our aunt saw it, took a picture of her monitor with her phone, went to the store to have them print the photo out on photo paper, and then mailed it to my brother.
So he got his original photo back, but at a greatly reduced quality and with monitor glare added!
PDF can be opened anywhere, that's my point.
* Only if you dont use the many still proprietary extensions of PDF I suppose.
Anyway I'm not sure following the Adobe standard in our institutions is the smartest move.
In college my professor wouldn't accept pdfs for assignments because I guess he couldn't check the metadata or make comments or something.
So I literally had to download MS office just to submit assignments in their format...
There are some people who míght learn from a ransomware attack. Only if it personally hits them, of course.
And everytime I get a document in a Microsoft format I send a reply asking if this or that is supposed to look that way or be that value. Yet it's the open format and tools that's an issue somehow.
One thing I do like from LibreOffice is the ability to save to PDF but also embed the original document inside it.
That way almost anyone can see it as intended, and the original is still there for editing.
Whoa I didn’t know that was an option, is it part of the export menu? That would make some of my - we needed to change something after all - situations much easier at work.
Either the person is lying, because MS Office claims compatibility with OpenDocument files, or it isn't actually compatible and Microsoft itself is lying.
Give me CSV or give me death
Death it is, CSV is horrible effectively unstandardized trash that has led to uncountable hours of efforts wasted due to subtly corrupted data through incompatible serialization settings.
It actively makes the world a worse place by existing.
i will also accept LibreOffice's format for formula purposes
CSV does not allow storing formulas, just results. It is a good format to share data, but it is not a good format to store spreadsheets which very often contain such formulas.
Formulas are just strings, no reason you couldn't store over in a CSV.
Maybe your software doesn't want you to do that, but that's a problem with that specific software.
Do you know of any software which stores formulas in CSV?
It's an option when saving in LibreOffice Calc.
Would be a pretty straightforward macro to (un)quote the formulas in Excel or Google Sheets etc.
I didn't know calc could do that, cool!
csv is a pretty good data sharing format, but not very well suited for spreadsheets. Just because you can shove anything you want in there doesn't mean you should.
I think it's perfectly well suited to spreadsheet. It's more-or-less perfect for tabular human-readable data. If you want to embed fancy things like OLE objecta and ActiveX controls and helpful animated characters then you may well be better served with another format.