I know it’s possible to insert a blank row before the current row using Insert → Rows. Is there a way to insert a blank row after the current row, so that all the subsequent rows are moved down 1 (but the current row remains in place)?
Use case: I have a SUM total at the bottom of my table and if I go to insert a new data row just before the total line, the range to the SUM function is not updated, whereas if I insert a new data row anywhere else the range is updated as I expect it to be.
I am trying to think of a UI where inserting after the current selection, be it a line of text in a word processor or a row in a spreadsheet, is usual. Can’t think of any. Is there a particular reason why you require this behaviour? It would seem UI-inconsistent.
If I understand right there is an option in:
Menu/Tools/Options/LibreOffice calc/General - Expand references when new columns/rows are inserted.
I still wish there was a keyboard shortcut for insert after, but this solves the key issue I was facing. Thanks.
Excellent, I didn’t know about this settings. Thanks.
New to me also. Thanks.
I don’t think this is possible. Why don’t you select one row bellow and do the Insert | Rows.
If some feature insert “after” row is implemented then there is no guarantee that your formula in cell B4 is going to accept new row. Your formula uses data range B1:B3 and inserting a new row in row four does not have any effect on range B1:B3. The only way of solving this problem - some workaround - is to leave cell B4 empty and then add formula in B5=SUM(B1:B4). If adding a new row, it is included into selection range of formula. Not the best solution…
@L-user, gah! I did not read your comment before I posted my answer (because of the ridiculous new (more) feature on comments). I pose a couple of workarounds in my answer below, but you are right in your assessment, so I will edit my answer.