Description: When I have a formula in a row or column, and I insert a column or row, the formula is not extended to take that into account. Steps to Reproduce: 1. Create a simple formula in a row or column 2. Insert a row or column Actual Results: The new cell does not contain the formula nor are the other cells updated to reflect the new addition Expected Results: Would like to see an option to extend formulae, as there are options to extend formatting and references. Reproducible: Always User Profile Reset: No Additional Info: Version: 6.0.4.2 (x64) Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU threads: 4; OS: Windows 6.1; UI render: default; Locale: en-GB (en_GB); Calc: group User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.183 Safari/537.36 Vivaldi/1.97.1183.3
Not sure if it is a good idea. What happens if you insert a row between two different formulas? Best regards. JBF
There is the [Ctrl+D] shortcut, selecting a range after the last row with data/formulas they are copied on the selected cells.
You mean, that you want a short way for "insert new row, copy content of previous row, paste into new row"? Then do this: Mark the row, drag down a cell from that row while pressing Ctrl+Alt.
I have just looked at Excel to see how that handles the same operation, and it is the same as LO. It's not about the shortcut to be honest, as I know about those, I thought it was different to what Excel did. What does differ, which is annoying, is the cutting and pasting of a row. Excel does this much better than LO. But that's another conversion.
(In reply to Vas from comment #4) > I have just looked at Excel to see how that handles the same operation, and > it is the same as LO. > > It's not about the shortcut to be honest, as I know about those, I thought > it was different to what Excel did. What does differ, which is annoying, is > the cutting and pasting of a row. Excel does this much better than LO. But > that's another conversion. I believe the annoyance you mention is dealt with in bug 99457. I guess we can close this.