Every spreadsheet I've used has managed to annoy me, but LibreOffice and Apple's Numbers both manage to do it even with simple spreadsheets with simple (or even no) calculations. Excel at least waits until I'm doing something slightly complicated before irritating me.

Example: create four rows of four cells each, like this:

  1  2  3  4
  2  4  6  8
  3  6  9 12
  4  8 12 16

Select rows 1 and 3 (but not 2), copy, and paste just below row 4.

In Excel, that pastes a copy of row 1 at row 5, and a copy of row 2 at row 6.

In Numbers, row 1 is copied to 5, and row 3 is copied to 7.

In LibreOffice, row 1 is copied to 5, and row 3 is not copied.

So we have three ways to handle copy/paste of a non-contiguous selection: make it contiguous on paste (Excel), past non-contiguously (Numbers), and just copy the topmost row (it's topmost, not first row selected--if you select row 3, then non-contiguously add row 1, it is row 1 that copy grabs) (LibreOffice).

I'm not sure which of these is actually the most right from a theoretical perspective, but I bet Excel is the one most likely to be based on data about which method best matches what users actually do with the spreadsheets.

Joel Spolsky has an article [1] where he talks about what they found when he was on the Excel team at Microsoft and they actually started visiting customers to see how they used Excel. A couple quotes:

> Over the next two weeks we visited dozens of Excel customers, and did not see anyone using Excel to actually perform what you would call “calculations.” Almost all of them were using Excel because it was a convenient way to create a table.

and

> What was I talking about? Oh yeah… most people just used Excel to make lists. Suddenly we understood why Lotus Improv, which was this fancy futuristic spreadsheet that was going to make Excel obsolete, had failed completely: because it was great at calculations, but terrible at creating tables, and everyone was using Excel for tables, not calculations.

Looking at my own spreadsheets...I find that most of them are indeed really just lists or tables with maybe a little calculation. The few that I would say are actually heavily calculation oriented would probably do just as well in LibreOffice or Numbers.

[1] https://www.joelonsoftware.com/2012/01/06/how-trello-is-diff...