https://bugs.documentfoundation.org/show_bug.cgi?id=161066
--- Comment #2 from elias estatistics <[email protected]> --- Created attachment 194791 --> https://bugs.documentfoundation.org/attachment.cgi?id=194791&action=edit picture of calc data here you can see what i means in the picture. How i can apply "IFERROR(INDEX($C$6:$D$11, SMALL(IF(D6=1,ROW($A$1:$A$10)), ROW(A1))),"")" for data B and C with a single step? cells "$C$6:$D$11" are locked inside the formula. If I cut-paste the formula below for Data B it will not do it. I must set again all cells. However, if cells "$C$6:$D$11" were unlocked temporarily with eg. cntrl+x and then cntrl+u, then paste it below, it will do it without any other editing (except D6 to D15 in "IF"! It will be a HUGE addon for libre calc! of course when paste it below, cells must be locked again in their new position. eg. for DATA B: IFERROR(INDEX($C$15:$D$20, SMALL(IF(D15=1,ROW($A$1:$A$10)), ROW(A1))),"") -- You are receiving this mail because: You are the assignee for the bug.
