12 ms·
What’s wrong with its copy paste? It’s missing a few things but what’s there is great. The type situation is terrible I agree. I can’t even count the number of
by formercoder 6y ago
What’s wrong with its copy paste? It’s missing a few things but what’s there is great. The type situation is terrible I agree. I can’t even count the number of times I’ve screwed up a currency conversion or not known what currency a cell was. Why can’t it know that dollars are dollars and when I multiple my euros per dollar I get euros?
- ineedasername 6y agoCopy/paste can be really weird. Take these three scenarios: 1) Copy some cells. Type something into another cell before pasting it. Your copy buffer is gone, you can't paste what you copied. 2) You copied some cells, pasted them. You arrow over a few cells to inspect a formula and then hit enter: You just pasted over the surrounding area with whatever you've copied previously. 3) You copied some cells, you pasted them somewhere. Now you want to insert a new column, but when you right click the option is missing, replaced with "insert copied cells". The clear the copy buffer you go to random empty cell, type a space to clear the buffer (see #1 above) and now you can insert a new column. On the plus side though, copy/pasting formatting is pretty useful, so is transpose.
- phonon 6y agohttps://web.archive.org/web/20160725070440/http://discuss.fogcreek.com/newyork/default.asp?cmd=show&ixPost=3479 https://web.archive.org/web/20160725070440/http://discuss.fo...
- ineedasername 6y agoI don't accept that explanation as sufficient considering that Google Sheets handles this just fine.
- beowulfey 6y agoI think you can also clear the copy buffer instantly by pressing Esc.
- ineedasername 6y agoThanks! I don't know if my google-fu has been lacking when I've tried to find a solution before, but I'd never found that info before.
- formercoder 6y agoAh these are fair points. Have probably gotten so used to them by now that I don’t get annoyed by them.