https://bugs.documentfoundation.org/show_bug.cgi?id=149356
--- Comment #26 from Colin <[email protected]> --- Are we just considering the effect upon a single column or multiple selected columns? It's probably fair to say that most users will be replicating formulae and will expect the formula to either adjust its reference cells or use an "absolute content" depending upon the fill type. Auto-Filtered rows and "hidden" columns and rows introduce another dimension - should the fill affect or ignore the "hidden" cells? Most filters are set to "hide" certain data elements for cosmetic or focal objectives. If there is an array with hidden columns and/or rows then I imagine if a formula is contained in a hidden cell affecting the results of other cells on that row the intention is probably to update all formulae - regardless of their visibility. simple proof; enter 1 into A1 enter =A1+1 into B1 Drag-fill B1 to six adjacent columns (G) Select and Group Columns D&E (F12) Hide columns D&E Enter =A1+1 into cell A2 Drag-Fill A2 to G2 Select and Group Rows 5&6 (F12) Hide rows 5&6 Select A1:G1 Select A2:G2 and drag-fill to row 8 Unhide columns and rows Now consider the reasons which may have dictated filtering rows with auto filters or hiding columns because the user didn't want to see a piece of text contained in Column H or wanted to hide calculated values higher than 5 or 6 in column C or even because a user broke down a complex formula with D&E being filled with intermediate "helper" calculations for the results in G Also, remember the objective of filtered rows where the user wishes to change just text content from "in abeyance" to "delivered" by filtering on any number of columns to target the specific rows then changes the top row's text entry and double-clicks, EXPECTING only the targeted rows to change - NOT EVERYTHING between the two extremeties. not shouting - highlighting. -- You are receiving this mail because: You are the assignee for the bug.
