https://bugs.documentfoundation.org/show_bug.cgi?id=149356
--- Comment #30 from Colin <[email protected]> --- (In reply to Colin from comment #26) > 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 > XXXXXXXX Select A1:G1 - XXXXXX OOPS, IGNORE THIS IT'S A CUT N'PASTE ERROR > 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.
