At 17:07 11/12/2008 +0200, Dotan Cohen wrote:
In Calc, when I add new rows via the context menu (right click on any particular row) the new row is placed above the row that was clicked on, yet it has the settings (font size, background colour, etc) as the row _above_ the row I clicked on. I could not find a configuration option for this. Is this intended behaviour?
The first part is easy to explain. If you select multiple (contiguous) rows and then insert rows, the new rows replace the selected ones and the selected ones are necessarily moved down to make room. The old rows are now below the inserted ones; in other words, the new ones were inserted above the selected ones. When you right-click on a row, you incidentally select that row, and the result is special case of this more general one.
The question of inherited formatting is not so easy. I suppose the designers had to choose one way or the other and thought that, where there were blocks of rows differently formatted, it would be more likely for a user to want to add rows at the bottom of a block than at its head. But I'm only guessing. No: I don't see where you can change this. One workaround would be to copy the row and then use Paste Special... (also available in the context menu) to paste it back where it is. In the Paste Special dialogue, select Down under "Shift cells". If desired, with the inserted row still selected, then either choose Cut from the context menu or just press Backspace to clear the values from the inserted row. (This is probably easier to do than the explanation sounds, of course!)
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
