This feature has been sought for at least twice on AskLO. Frankly I don't know how it works in M$ Office, I think it's automatic but can be toggled in settings. Best would be global toggle and per-document toggle if technically possible, and the global toggle can be set to - always allow (document can disable) - let document decide - never allow
Please describe what you mean. If you know, paste the link to AskLO. Thanks
(In reply to raal from comment #1) > Please describe what you mean. If you know, paste the link to AskLO. Thanks 1) Right click on any row's number below or above a row that has at least 1 formula, such as §=ROW()§ 2) Choose §Insert Rows Above§ 3) The formulas another row had is replicated to the new row without copypasting AskLO links I were able to find right away: - https://ask.libreoffice.org/en/question/17859/automatic-formula-when-add-row/ - https://ask.libreoffice.org/en/question/47622/can-i-autofill-formulas-in-a-column-down-to-each-new-row-added/ SuperUser link: http://superuser.com/questions/525105/libreoffice-calc-how-do-i-copy-formulas-but-not-values-from-a-row
(In reply to Jouni Järvinen from comment #2) > 1) Right click on any row's number below or above a row that has at least 1 > formula, such as §=ROW()§ > 2) Choose §Insert Rows Above§ > 3) The formulas another row had is replicated to the new row without > copypasting Could not repro. Win 7 Pro 64-bit, Version: 5.0.2.2 (x64) Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe Locale: fi-FI (fi_FI)
(In reply to Beluga from comment #3) > (In reply to Jouni Järvinen from comment #2) > > 1) Right click on any row's number below or above a row that has at least 1 > > formula, such as §=ROW()§ > > 2) Choose §Insert Rows Above§ > > 3) The formulas another row had is replicated to the new row without > > copypasting > > Could not repro. > > Win 7 Pro 64-bit, Version: 5.0.2.2 (x64) > Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe > Locale: fi-FI (fi_FI) I did this and reproduced consistently, on 32-bit LO 5.0.2.2 with British English GUI: 1) For A1-3 put §=ROW()§ 2) Right-click on row 2's number on the left and choose §Insert Rows Above§ 3) The new A2 is blank while others, the new A3-4 and the old A1, contain their respective numbers
(In reply to Jouni Järvinen from comment #4) > their respective numbers and their code.
(In reply to Jouni Järvinen from comment #4) > I did this and reproduced consistently, on 32-bit LO 5.0.2.2 with British > English GUI: > > 1) For A1-3 put §=ROW()§ > 2) Right-click on row 2's number on the left and choose §Insert Rows Above§ > 3) The new A2 is blank while others, the new A3-4 and the old A1, contain > their respective numbers Ah, ok, sorry, I misunderstood.