Hi, and welcome to the forum.
rspu wrote:The contents of the original rows are NOT MOVED DOWNWARD …
You state what does not happen. That information is of little value. Instead, you should explain what does
happen and your expectation
of what will happen. We sometimes find that Calc's behavior is correct but expectations are incorrect.
rspu wrote:V3.4: Data in cells below Insert>"Entire Row" do NOT shift down.
Where do you find Insert>"Entire Row"? I cannot find that menu or toolbar icon on my OpenOffice Calc program.
rspu wrote:Any time I insert entire row, The contents of the original rows are NOT MOVED DOWNWARD, despite the help that claims they are:
If the goal is to insert a row, I use menu Insert → Rows. If I use menu Insert → Cells → Entire row → OK, that also inserts a row, but it is more complicated. Either of those procedures moves the data in the insertion area down when I use them.
When I insert rows, the new rows are inserted above
the highlighted row. Cells in the new rows are formatted like the corresponding cells in the row before
That is how row insertion should work in Calc. If you experience different behavior, attach a document
demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself)
. Specify which cell or cell range is selected and what specific action you take to insert a row. There are several methods, and we need to know which one you are using. If your attachment has multiple sheets, specify which sheet you are using. Tell us what happens to the data below the insertion on your system
. Also tell us your goal since we may know another way to achieve it.
Inserting rows is exactly equivalent to moving
rows down. This tutorial explains how dependent formulas are changed when rows are inserted, with the Expand References
option set and also with it not set.
[Tutorial] Formula Adjustments during Copy and Move
Hint: It is a waste of your time to post duplicate topics for the same problem. We just delete the duplicates.
[Tutorial] Ten concepts that every Calc user should know
rspu wrote:Also, the Totals summation calcs do not automatically adjust their cell boundaries to reflect their expanded field.
Open two topics if you have two problems. Attach a document demonstrating the situation with your summation calculation. Explain your goal. My guess is that the "Formula adjustments" tutorial explains the situation and may suggest how you can get Calc to work the way you want.