...At home I want something that works, functions well and doesn't require my work place IT team to keep it running. I don't give a rip about image. I care about reliability and performance. My two iPhones (one that is 4.5 years old) and iPads work perfectly. I'm seeking the same performance in a laptop or desktop computer.
Go squeeze some fish. (0:
You mentioned spreadsheets in your original post. Microsoft sells MS Office for both Mac and Windows, but being Microsoft, they left one trap for the unwary Mac user in it. If you create a spreadsheet on a Windows machine and then open it on a Mac all of the dates will be different by 3 years and 364 days. Same if you create it on a Mac and open it on a Windows box. (Maybe it is 4 years and 1day?)
The reason for this is that dates are stored as a number of days from some reference date. In Windows this is Jan 1,1900. Macs use Jan 1, 1904.
Why did Apple choose such a weird date? Well, you have to go way back to the dawn of the personal computer age. Memory was scarce, and cpu cycles were slow. Due to the rules of the Gregorian calendar we use, 1900 was not a leap year, but 2000 was. The calculation that transforms the number of days into a date which is displayed is much easier if every fourth year the spreadsheet is going to encounter is a leap year. So Apple opted to start in 1904. Microsoft in started in 1900, and the calculation is slower on a Windows machine.
In newer versions of Excel, there is a preference, at least on my Mac for which date system to use. If I get a spreadsheet created on a Windows machine I have to change this preference to use the 1904 date system, so anything I add has the right dates.
* * * * * *
Of course complex formatting is always iffy when going from Windows to Mac, or vice versa.
This is about the only big incompatibility I have found going from one OS to the other, and I place the problem squarely with Microsoft. Memory is cheap and plentiful in computers these days, and cpus are much, much faster. Excel should be able to keep track of which machine created each cell of a spreadsheet and display dates correctly on either OS.
* * * * * * *
I like my Mac very much, I can use Windows, but hate every second.