Fri Sep 9 06:43:57 EDT 2011


Time to get to know Calc

How to?

 - Insert a number of rows, keeping formula?

   That doesn't work, but it's possible to insert multiple rows by
   selecting the number of rows to insert, then use insert row.  To
   copy the formula, just select one box which has a formula, and drag
   its corner black square down.

 - Keyboard shortcut for row insert?

   Don't know, but it's possible to add an insert/delete rows button
   to the toolbar.

 - Quickly enter product of two rows?

   Looks like it needs to be done manually:  =PRODUCT(<start>:<end>)