automatically insert rows in a calc spreadsheet

English
, ,
#1

I have a sheet that has product name, metric weight, decimal pounds, pounds. ounces, price, sales tax, shipping. All those columns are in one row for each product. and there is a sum cell for each column at that bottom of the sheet.

This is going to be a continuous sheet, meaning that there will be rows always entered into it as I add products. Is there a way to automatically insert new rows after I press enter in the shipping cell? The inserted row would go to the row above the row that has the sums for each column. So that I do not have to manually insert every time.? Or is this something better down in BASE?

#2

I have two requests. 1 Edit your post and correct all the typos, difficult for me to understand. Two, could you post a screenshot of this spreadsheet?

#3

Will you use more that 1 million rows in this spreadsheet?
https://wiki.documentfoundation.org/Faq/Calc/022

Why not put the totals in the top row? Then you wont have to add rows?
Better yet… us a pivot table to do the totaling for you on another sheet tab.

#4

Hey now those were some very good ideas!
I suggest you proof read your text, got some typos in there.

#5

I think what you are looking for is Insert Rows.

  1. Select the row for Sum, by pressing the row number to the left most edge of the sheet.
  2. Right click on mouse on the selected row.
  3. Choose Insert Rows->Above.

This will add one row at a time.

To insert multiple rows in one go:

  1. Select a series of rows by pressing
    down on row number (left edge) and
    dragging the mouse cursor down or
    up.
  2. Right click as before on the
    selection and choose Insert
    Rows->Bellow    .

This will add a number of new rows equal to the number you had selected.

Does this answer your question?

#6

I know I can do that buy using INSERT ROWS—> Above. That was not the question. My question was if there was a way or a macro so that when I hit return in the last column of a row that ANOTHER ROW right above the sum row would be inserted AUTOMATICALLY.

#7

As far as I know, no such macro exists. But that is not to say that you cannot create such a macro. A practical solution is to either use the method described in my answer. An alternative solution is to place the Sum at the top most row. It is also possible to have sums on a separate sheet.

#8

Here is a screenshot. I have not added all of the columns yet. The sum row is that next to the last one you see in the screenshot. This is going to be a long list so I am anticipating having to add new rows as I add products. The sheet IS NOT relational. There is no data from other tables nor will there be in future.

image description
image description1254×664 106 KB

#9

I noticed that there are formulas in the line … Fill in line 2 and click on the Save button.

Test file2,

#10

@Shaba1, Here’s a suggestion.

Click Insert Lines Button and fill.

Test file.

ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

#11

I downloaded the test file and everytime I click on that button nothing happens.

#12

@Shaba1, in Win10 + LibO 6.2.5.2(64)

The 2 working.

Test file.

Test file2,

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.