Office shootout: OpenOffice.org Calc vs. Microsoft Excel
Posted by: Anonymous
on October 12, 2007 04:11 PM
Calc's drag and drop is no where near as good as Excel's. Makes manipulating SS difficult. In Excel and Calc if you drag field(s) they both overwrite. If you hold shift key while dragging in Excel it moves the data without overwriting (try doing equivalent in Calc take multiple steps), Calc does same as if no shift modify. If you hold down control key while dragging both Excel and Calc copy fields overwriting existing. If you hold down control and shift keys while dragging in Excel it does a copy/insert (again very useful and hard to do without), in Calc it overwrites a link to referenced fields (which in not very useful).