Ask Your Question

Insert row *after* the current row? [closed]

asked 2013-09-30 23:01:02 +0200

updated 2013-10-02 18:41:56 +0200

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.

image description

image description

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-10 10:34:34.455236


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.

oweng gravatar imageoweng ( 2013-10-02 01:48:28 +0200 )edit

@oweng I added a use case to explain why I think this would be useful

mlk gravatar imagemlk ( 2013-10-02 18:43:22 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-10-03 03:36:51 +0200

m.a.riosv gravatar image

If I understand right there is an option in:
Menu/Tools/Options/LibreOffice calc/General - Expand references when new columns/rows are inserted.

edit flag offensive delete link more


I still wish there was a keyboard shortcut for insert after, but this solves the key issue I was facing. Thanks.

mlk gravatar imagemlk ( 2013-10-03 04:41:20 +0200 )edit

Excellent, I didn't know about this settings. Thanks.

L-user gravatar imageL-user ( 2013-10-03 07:18:14 +0200 )edit

New to me also. Thanks.

oweng gravatar imageoweng ( 2013-10-04 09:56:34 +0200 )edit

answered 2013-10-01 18:27:02 +0200

L-user gravatar image

I don't think this is possible. Why don't you select one row bellow and do the Insert | Rows.

edit flag offensive delete link more


@L-user I added a use case to explain why I think this would be useful

mlk gravatar imagemlk ( 2013-10-02 18:42:56 +0200 )edit

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 gravatar imageL-user ( 2013-10-02 19:27:41 +0200 )edit

@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.

oweng gravatar imageoweng ( 2013-10-03 02:12:27 +0200 )edit

Question Tools

1 follower


Asked: 2013-09-30 23:01:02 +0200

Seen: 4,258 times

Last updated: Oct 03 '13