I guess the first trap should really be: "You cannot read any CSS property in isolation, as just like what the name implies, defaults and what values end up doing cascades through all the rules your document ends up using"
CSS cascade for text properties more or less makes sense.
I have been unable to comprehend CSS layout from any perspective: page designer, implementer, user, anything. It must have someone in mind but I have no idea who I that is.
https://every-layout.dev has by far the best explanations and coherent usage of CSS I've encountered since I started doing webdev for a living in 1998.
The percentage difference in usage between the #100 command ("Accept Change") and the #400 command ("Reset Picture") is about the same in difference between #1 and #11 ("Change Font Size")
The commands you mentioned seem irrelevant here. I never use any advanced features, i.e. those not available in LibreOffice or incompatible with MS Word, and I don't know anybody who does.
Can you give me an example of such advanced features? I really don't understand what outstanding feature did they pack in this "Excel" which has no alternative?
If the only problem is migrating from XLSX to some other format I'm sure this is trivial and some tooling must be available.
There are complex reports that every European-regulated finance entity needs to submit to their regulator. They are always complicated, but they are only sometimes well-specified. The formats evolve over time.
There is a cottage industry of fintech firms that issue their clients with a generator for each of these reports. These generators will be (a) an excel template file and (b) an excel macro file.
The regulators are not technically sophisticated, but the federated technology solution allows each to own its regional turf, so this is the model rather than centralised systems.
If the regulator makes a mess of receiving one of your reports, they will probably suggest that you screwed up. But if you are using the same excel-generator as a lot of other firms, they will be getting the same feedback from other firms. If you did make a mistake, you can seek help from consulting firms who do not understand the underlying format, but know the excel templates.
There are people whose day-to-day work is updating and synchronising the sheets to internal documentation. It gets worse every year.
Sometimes the formats are defined as XBRL documents. Even then, in practice it is excel but one step removed. On the positive side - if you run a linux desktop you have decent odds to avoid these projects, due to the excel connection.
The problem is not the "advanced features" within Excel but how they are used. If an excel sheet is basically just a front for a visual basic Programm it doesn't easily open anywhere.
As Google's JavaScript API also doesn't work in open office and whatever else they all have in extra layers.
However i am not sure when and why I encountered such a software last time, but my dad is a Visual Basic guy and has done a lot of these weird sheets for internal business stuff.
VBA is the famous example, but Power Query deserves a shout out. I use it to make tables that pull their data from other tables with custom transformation logic.
Google Sheets didn't even support tables until fairly recently.
LibreOffice still doesn't have tables! Not to mention the new(ish) functions in Excel, like LET and LAMBDA.
Power Query the language is nice, I kinda like it. I've read the UI and engine works quite well in PowerBI, but I haven't used it.
The Excel engine is way too slow though. Apparently they're two entirely separate implementations, for some architectural reason, not exactly sure why.
Excel's Power Query editor on the other hand, is an affront to every god from every religion ever. Calling it an "advanced editor", while lacking even the most basic functionality, is just further proof of their heresy.
Power Pivot is one I encounter on the regular, you can't even use it on Excel for Mac, Windows or Bust
CFO was/is an excel wiz, so he would whip up crazy Rube Goldbergs with Power Pivot (And Power Query), that couldn't be modified by mac users (They can open the files, but they can't interact with it, not even changing filters
PowerQuery is another one, also not available outside of Excel for Windows, not Mac or Web
A lot of it is stuff that should be handled by SQL more properly, but the data people usually can't keep up with the Excel wiz
You didn't really mention any real feature besides Visual Basic, which clearly has alternatives in other spreadsheet apps. You have to run your VBA through converter script, and the fix incompatibilities in your macros but again, for a Visual Basic guy it is trivial... The rest of the things you mentioned is a good old `rsync` repacked.
But you're right, they surely added a bunch of smaller stuff to keep everything connected, and I'm kind of underestimating it since I never used that ecosystem but heard rumors and complaints from other people who had to use it :)
I'm not dismissing onedrive here but I wanted to say monseur was cheating when he mentioned onedrive/sharepoint as real features of Excel application – they are not directly related to the essence of spreadsheet editing and can be substituted with any solution which does the job, even Dropbox itself.
>There's no serious alternative to Excel for those who rely on its advanced features.
this is just silly, it really means "There's no serious alternative to Excel for those who rely on exclusive Visual Basic macros"
> I'm not dismissing onedrive here but I wanted to say monseur was cheating when he mentioned onedrive/sharepoint as real features of Excel application – they are not directly related to the essence of spreadsheet editing and can be substituted with any solution which does the job, even Dropbox itself.
Not true. Sharepoint and OneDrive are key enablers for real time collaboration. It lets multiple people work on the same file at the same time using native desktop applications. Dropbox has tried to bolt stuff like that on, but it is janky as heck. OpenOffice, etc can't integrate with Excel for real time collaboration (honestly, I'm not sure they support any level of real time collab with anything). Google Sheets won't integrate with Excel for real time. Google is great for collaboration, but sticking everything in Google's cloud system isn't dramatically better than being stuck on Microsoft's stuff. Also Google Sheets just doesn't work as well as Excel.
SharePoint/OneDrive Lists can be directly edited in Excel. The Power platform can directly access/manipulate/transform Excel files in the cloud or on-prem via the Power BI Gateway.
You don't seem to have much of a familiarity with this ecosystem. If you're curious, I'd suggest hunting down these things on learn.microsoft.com, but to dismiss them is only showing your lack of understanding.
So you do all this work, retrain other users, spend a not-so-trivial amount of time and money and risk breaking stuff, all for not paying $22 monthly per user?
I get it, it would be a technically better solution, remove Microsoft lock-in etc, but the cost-benefit analysis isn’t that good in this case.
I once broke some Python by changing a = a + b to a += b.
If a and b are lists, the latter modifies the existing list (which may be referenced elsewhere) instead of creating a new one.
I think Python is the only language I've encountered that uses the + operator with mutable reference semantics like this. It seems like a poor design choice.
This is one of the absolute worst design mistakes in Python. The example you give (that `a = a + b` and `a += b` aren't equivalent) is bad enough:
>>> a = b = [1, 2, 3] >>> a = b = [1, 2, 3]
>>> a = a + [4] >>> a += [4]
>>> a, b >>> a, b
([1, 2, 3, 4], [1, 2, 3]) ([1, 2, 3, 4], [1, 2, 3, 4])
What's worse is that sometimes, they are equivalent:
>>> a = b = (1, 2, 3) >>> a = b = (1, 2, 3)
>>> a = a + (4,) >>> a += (4,)
>>> a, b >>> a, b
((1, 2, 3, 4), (1, 2, 3)) ((1, 2, 3, 4), (1, 2, 3))
And even worse, in order to support a version of `a += b` that sometimes modifies `a` (e.g. with lists), and sometimes doesn't (with tuples), the implementation of the `+=` operator is convoluted, which can lead to:
>>> t = ([1, 2, 3], ['a'])
>>> t[0] += [4]
TypeError: 'tuple' object does not support item assignment
>>> t
([1, 2, 3, 4], ['a'])
The operation raises a TypeError, despite having succeeded!
Are you sure you are not experiencing some selection bias yourself, where you only recall the validation attempts that landed as patronizing or insincere, and do not notice when they are adeptly executed?
I am not sure if the author actually put any thought into the foundation of interactivity on the web, or if they just asked the AI to write a nice-sounding introduction to their article about new button capabilities.
I think I might find this story interesting if I had something to set the scene for me. But this is written on the assumption that everyone already knows what's going on, so it just loses me.
From MDN: "For block boxes, inline boxes, inline blocks, and all table layout boxes auto resolves to 0."
https://developer.mozilla.org/en-US/docs/Web/CSS/min-width
reply