OOo 2.0 Calc doesn't copy formulas when inserting rows

[sparky]

I find that when I insert a row (in the middle of an existing spreadsheet full of formulas), Calc doesn't fill in the formulas like Excel. I would REALLY like it to fill in the formulas so I don't have to copy or drag them from previous rows. Any way to get it to do this? Any plans to fix this in future versions?

Example:

Initially, let's say that
Cell A1 contains a numerical value of 10.
Cell A2 contains the formula "=A1+10" (so its value is 20)
Cell A3 contains the formula "=A2+10" (so its value is 30)
Cell A4 contains the formula "=A3+10" (so its value is 40)

Now I select row 3 and perform an Insert Row operation. This has the effect of moving what were previously cells A3 and A4 down. The problems are twofold:
(1) The new cell A3 is totally blank. What I wanted was for it to continue the formula trend, i.e., to fill in "=A2+10" like Excel does.
(2) The formulas that were moved down to cells A4 and A5 refer to the old cells, rather than being adjusted (like Excel) to "= <the cell immediately above> +10".

I regard this as misbehavior.

Note that selecting the Options checkbox to "Expand refences when new columns/rows are inserted" does *NOT* fix the problem.

Is this ONLY a problem in 2.0? (I'm running under Windows XP.) Is this an intentional "feature"? (You know, one man's "bug" is another man's "feature".)

I have noticed some other posts alluding to this problem but haven't seen any clear-cut answers.

Help?

[sant]

I use OO2.2 and excel 2003 under windows XP.

I replicated the senario you describe and found that both programs do exactly the same thing, that is insert a blank row, move the formulas below the insert point down and preserve first moved formula referecing the cell above the insert point and changing the following formulas to reflect thier new relative positions. There is one difference here, when I copy the formula above the insertion point into the created blank cell in the sequence, OO2.2 simply duplicates the formula no questions asked while excel takes the trouble to point out that the copied formula is not consistent with the rest of the sequence and and gives the option to change all the following formulas to suit accepting this changes all the following formulas to reflect the change. You can do this manually in OO2.2 by simply copying the top formula down the cell sequence by dragging in the usual way. I don't find either programs way of doing things an inconveinience, I like the idea of doing the changes for myself, that way I get what I want - this is not misbehavior, freedom of choice is a good thing. Example: I can set up a sequence of dependant calculations and then insert blank rows to allow additional formatting without my calculations being affected by the program deliberatly inserting new formulas on the fly. If you require this it may be possible to change the way the two programs operate in thier default options but I could not find a way of doing this in the help files. I have an old excell sheet which does what you require using macros to insert a new row at the bottom of a database and fill in common fornulas and data, you can do this using starbasic in OO2.2.