Live data from Hacker News

Is OOXML Artifically Complex?

hsu.cy

91–100 of 161 posts

Re: Is OOXML Artifically Complex?

#91
post #73

Earlier quoted context omitted.

> We do need for-profit alternatives to Word, and I’m working on one in legal. Wow, big undertaking! What we really need, though, is a for-profit alternative to Excel, that's not Google. I think Excel is more of the Killer App than Word has ever been.

That's Apple Numbers.

... which comes tied to macOS and with it Apple hardware. Neither play well in a shop that uses x86 Windows-only software, and Apple's switch to ARM hasn't made that easier.

Re: Is OOXML Artifically Complex?

#93

Earlier quoted context omitted.

I worked for the Norwegian standard organization at the time. After seing with my own eyes how Microsoft was able to get OOXML approved, I quit doing standards. The OOXML standard is a joke. Three different ways to store basically the exact same thing. Like dates.

What if they could do it, because people like you had quit?

Standards committees being completely divorced from reality of software engineering is why most of the standards are useless.

So the question is whether it was actually a loss.

Re: Is OOXML Artifically Complex?

#94
post #53

> Why Microsoft’s Motive Wasn’t Deliberate Sabotage I absolutely do not agree. Not only is the standard overly complex, Microsoft also indulged in all sorts of unscrupulous activities to corrupt various National Standards Organisations to get it approved through the ISO https://en.wikipedia.org/wiki/Standardization_of_Office_Open... >, which is clear evidence of malicious intent. This is a quote from Richard Stallman…

Specifically what I heard on the grapevine was that Microsoft sponsored a collection of small island nations into the ISO process, in exchange for their vote on OOXML.

Not only small islands nations. For example in Finland Microsoft partners invaded the local working group to get the standard passed in the voting process.

Re: Is OOXML Artifically Complex?

#95

I think the last part is probably the biggest thing holding them back IMO... I tend not to install MS Office products on my personal devices, I haven't run Windows on a personal device in a few years. I've mostly maintained just my resume in word or libre-office format for well over a decade. I can't tell you how many times the LO format lost formatting, or just messed up between version upgrades. Same goes for openi…

Have you tried setting MSWord's default save format to Strict OOXML for inter-operation with LibreOffice?

I've generated the docs in LibreOffice and tried to only use that. My intent wasn't too use MS Word at all.

But I have used Word for work.

Re: Is OOXML Artifically Complex?

#96
post #53

> Why Microsoft’s Motive Wasn’t Deliberate Sabotage I absolutely do not agree. Not only is the standard overly complex, Microsoft also indulged in all sorts of unscrupulous activities to corrupt various National Standards Organisations to get it approved through the ISO https://en.wikipedia.org/wiki/Standardization_of_Office_Open... >, which is clear evidence of malicious intent. This is a quote from Richard Stallman…

I seriously don't see the author's purpose in trying to establish a distinction. If I act like I hate you: say I come and light your house on fire and salt the earth where you raise your crops and poison the water from your family's drinking well, would it not be reasonable to say that I hate you?

If you can then confirm that I have no intention to stop (even though I know I'm hurting you) and all I have to say in my defense is, "Actually I do exactly whatever I want and just don't care about you at all," what is the difference to me at that point?

In practice total indifference is even more toxic than hate, because it denies engagement. I owe no extra charitability for callous indifference being the root cause of the actions taken. Company or person, society reserves the right to judge you on the effects your force of will brings forth on others. They used theirs to kill their competitors.

Re: Is OOXML Artifically Complex?

#98
post #93

Earlier quoted context omitted.

What if they could do it, because people like you had quit?

Standards committees being completely divorced from reality of software engineering is why most of the standards are useless. So the question is whether it was actually a loss.

Like POSIX, OpenGL, OpenCL, Vulkan, C, C++, JavaScript, TCP/IP,....

Re: Is OOXML Artifically Complex?

#99
If you ever write some HTTP endpoint where tabulated data is returned, you could quite reasonably return RFC 4180 style CSV.

However, if your API ever interfaces with users in a corporate environment, parsing simple comma-separated UTF-8 CSV is suddenly quite beyond the reach of however is nibbling at your endpoint, so why not code up a simple little reusable bit of code where you can write any simple tabular data (string, numbers, and dates, in one or more sheets of data made up of rows and columns) that lets you choose the output format? A zip-archive of CSV-files (one per sheet), JSON, ODS, or XLSX; pick your poison.

I did just that, and while it is perfectly doable, any low-level, low-resources, low-dependency approach will mean actually touching the XML in LibreOffice's ODS (fine), and Microsoft's OOXML (…).

This is how you write a date in a cell in both.

ODS:

            
                
                    10/4/2021, 12:34
                
            
            
OK, a bit verbose, but trivial to implement. Format the date however you like — you'll probably use two different formatters on the same datetime instant.

XLSX (OOXML):

            
                
                    39448.5
                
            
Obviously, as you can all plainly see, the date here is 2008-01-01T12:00:00…

And of course it makes perfect sense to hardcode the cell coordinate there. It's not like you would dynamically generate a bunch of cells (…).

Re: Is OOXML Artifically Complex?

#100

If you ever write some HTTP endpoint where tabulated data is returned, you could quite reasonably return RFC 4180 style CSV. However, if your API ever interfaces with users in a corporate environment, parsing simple comma-separated UTF-8 CSV is suddenly quite beyond the reach of however is nibbling at your endpoint, so why not code up a simple little reusable bit of code where you can write any simple tabular data (s…

> However, if your API ever interfaces with users in a corporate environment, parsing simple comma-separated UTF-8 CSV is suddenly quite beyond the reach of however is nibbling at your endpoint

Excel can directly ingest a CSV file served over an URL as data source, with the Accept header manually set to text/csv.

I wrote a backend once that supported this feature so that management could pull whatever data they wanted off an internal application without pestering me. They could literally take the URL of a page and pull it as a CSV file as-is.

Anybody who knows a bit of Excel can pull that data themselves by following a set of simple instructions.

Post reply on HN