*Without "expand references"* =SUM(Sheet1.A1:A99) becomes =SUM(Sheet1.A2:A100) after you inserted one new row at Sheet1, row #1. The reference moves down one row. When you insert one row between row #2 and row #99 the reference expands by one row: =SUM(Sheet1.A1:A100) Nothing happens when you insert directly below A1:A99 in row #100.
*With "expand references"* =SUM(Sheet1.A1:A99) becomes =SUM(Sheet1.A1:A100) when you insert one row anywhere between row #1 and row #100 directly below. This applies to all formula expressions with references, namely cell formulas, conditional format, named ranges, database ranges, chart areas, pivot table sources, validation conditions, conditional format conditions and form control sources (list box, combo box). In 99% of all use cases you want this option being checked. Sometimes it can be annoying and then it is good to know how to turn off. -- View this message in context: http://nabble.documentfoundation.org/Calc-Options-Libreoffice-Calc-General-Expand-references-when-new-columns-rows-are-inserted-tp4204347p4204393.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [email protected] 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
