On Wed Jan 04 2017 12:26:42 GMT-0500 (Eastern Standard Time), Brian Barker <b.m.bar...@btinternet.com> wrote: > At 11:38 04/01/2017 -0500, Charles Marcus wrote: >> This doesn't seem to be working for me, and hasn't for a long time, >> I just keep forgetting to ask and go file a bug if it is broken. I >> have a spreadsheet that has numerous formulas in certain cells in >> each row. With the option referenced in this email subject enabled, >> when I insert a new row, shouldn't it automatically populate the >> corresponding cells in the new row with the formulas from the row >> above (or below if I inserted above)? > > No, I think not. It should do what it claims, i.e. expand references, > not duplicate formulae. It's not really about what is in the new rows > or columns, but about references *elsewhere* to ranges which may or > may not need to include them. If you have a reference somewhere to, > say, B3:B9 and you introduce a new row 6, such references will > automatically be expanded to B3:B10 so as to include the new cell B6 > as well as the original seven cells. This applies irrespective of the > condition of the option you identify. > > If, alternatively, you introduce a new row 10 (or a new row 3) - > adjacent to instead of within the existing range - references > elsewhere will be updated only if the option in question is ticked. > > I trust this helps.
It does, thanks. I understand now what that option does. Now I'm off to create a new feature request to add another option to auto-add formulas when a row is inserted between two other rows that have filled formulas in them. Question - is there a term for when two rows (or columns) have - adjacent - formulas that were filled up/down/across? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
