2008/12/11 Brian Barker <[EMAIL PROTECTED]>: > 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. >
This is clear, intuitive, and obvious. This much I knew. > 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!) > Well, no, the easiest way to insert a new row with the formatting of row x is to right-click on row x+1 and perform the operation. In fact, I have defined a keyboard shortcut for new rows and when I activate that shortcut I get a new row right where I was, but I get the formatting of the row above! This looks like a bug to me. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת ا-ب-ت-ث-ج-ح-خ-د-ذ-ر-ز-س-ش-ص-ض-ط-ظ-ع-غ-ف-ق-ك-ل-م-ن-ه-و-ي А-Б-В-Г-Д-Е-Ё-Ж-З-И-Й-К-Л-М-Н-О-П-Р-С-Т-У-Ф-Х-Ц-Ч-Ш-Щ-Ъ-Ы-Ь-Э-Ю-Я а-б-в-г-д-е-ё-ж-з-и-й-к-л-м-н-о-п-р-с-т-у-ф-х-ц-ч-ш-щ-ъ-ы-ь-э-ю-я ä-ö-ü-ß-Ä-Ö-Ü
