AAAA!!! How Excel on Mac annoys me. I need to have json strings in a column. That is, the cell should include something like this:
“classId”: “T”
If I simply transfer this line through the clipboard into the cell, it becomes classId: “T”, that is, the quotes around classId are automatically removed. What the heck? I need to transfer 90 lines, and they are getting killed in the process.
Well, okay, I decide to import them via CSV importer. Where I directly indicate that the separator is a tab. The same nonsense.
Well, I think, it’s freaking out because of the quotes. Let me replace all quotes with tildes, import them, and then replace them back with quotes in Excel. Cool, it imports, but doesn’t replace! As it turns out, the tilde in Microsoft is an escape character, and to replace a tilde, you need to replace two tildes in a row ~~. Of course, this isn’t written in the Find & Replace window.
Next, I need to do the same thing, but end up with two columns, the first would have classId, and the second – this piece of JSON — “classId” : “T”. If I copy from the test file to Excel through the clipboard, it somehow decides that the delimiter is a space, not a tab, and gives me several columns, the first storing classId”classId”, and the second – : “T”. What the hell Excel tries to recognize format from the clipboard???
Next, if I copy from any office application text to ChatGPT, besides the text, an image of this text is also copied. I constantly have to delete it because ChatGPT is surprised why a picture was attached. And this is only with office applications.
Next, I need to copy a list of 50 lines into Excel, filling cells after applying a filter to one of the columns. That is, I have around 200 lines there, I filter by criterion 50, and I want to insert text so that the first line fills the first filtered cell (with an absolute number of 13, for example), and the second fills the cell below (with an absolute number of 21). I take this list into the clipboard, and do Paste into the column, and see not 50 lines, but conditionally 10. Because, apparently, the other 40 were inserted into cells that are not visible because of the filter – that is, into cells between 13 and 21 from the example above.
In addition, all formulas in Excel have different names and syntax depending on the system language and locale. That is, it’s enough that parameter separators may be commas in one case, and semicolons in another, so the function names look different for different languages.
So, they have this function DSTDEVP (standard deviation for population with condition). If you move from a computer where the system language is set to English to a computer where the interface is not in English, then the formulas have these names:
English: DSTDEVP
Spanish: DESVEST.PB
French: ECARTYPEPB
German: STABW.DB
Italian: DEV.ST.P.DA
Portuguese: DESVPAD.PB
Russian: СТАНДОТКЛНУСЛ
It had to be complicated. Of course, my knowledge of French is not enough to make DSTDEVP into ECARTYPEPB. I had French set up so I wouldn’t forget, but because of such things, I switched back to English, keeping French on my phone. Yes, it’s worth noting that making the Microsoft Office language different from the system language without “hacks” is not possible. The hack is to physically delete the system language localization files from the Microsoft Office package, and then it defaults back to English.
Of course, I know solutions for all these problems. But darn it, how does Microsoft manage to keep a leadership in the market with such lousy applications. Yes, everything else is worse. Various OpenOffice and native Numbers (never seen a live user), unfortunately, have even more disadvantages.
Hi, I'm Rauf Aliev. 