I recently made the switch, and my first impressions are pretty good. OpenOffice does, however, have a few behaviors in its Spreadsheet (Calc) app that I can't figure out how to change. Missing these is slowing me down in a major way.
-When I try to copy/paste entire rows or columns, there is no "Insert Copied Cells here" - it will only overwrite, or wait for me to Insert blank lines separately (no good if you need to move 100s of them)
-Every time I hit the Delete key to wipe out a cell, it asks me what kinds of data I want to delete. I want to set a default, and never be asked again.
-Most importantly: When it auto-completes text in a cell, the Tab key no longer moves me to the next cell! Excel interprets Tab to mean "yes, that's the text I want, now move on." Most of my documents are repetitive in nature - it has to do this!
Do any experienced OOO users know how I can change these?
-When I try to copy/paste entire rows or columns, there is no "Insert Copied Cells here" - it will only overwrite, or wait for me to Insert blank lines separately (no good if you need to move 100s of them)
-Every time I hit the Delete key to wipe out a cell, it asks me what kinds of data I want to delete. I want to set a default, and never be asked again.
-Most importantly: When it auto-completes text in a cell, the Tab key no longer moves me to the next cell! Excel interprets Tab to mean "yes, that's the text I want, now move on." Most of my documents are repetitive in nature - it has to do this!
Do any experienced OOO users know how I can change these?