https://bugs.documentfoundation.org/show_bug.cgi?id=161066
--- Comment #5 from elias estatistics <[email protected]> --- I didnt know about F4. This did what I asked. Thanks. Yeah i know what you mean: what ranges to be unlocked. This is somewhat problematic. when pressing F4, a new popup windows appears and you write in it which ranges to be unlocked eg. 1,2 (1st,2nd) cause 3rd and 4th you are not like to unlock them. Also, the window may shows by default all possible ranges to be unlocked and you select which ones you want to unlock. However, F4 behavior must change. Cause now you must lock them again. In this new way, when unlocking happens, the formula is automatically copied and locked automatically again (the parts that you defined to be unlocked), so you do not need to lock it again. eg. IFERROR(INDEX(C$2:D$11, SMALL(IF(D$2:D$11=1,ROW(A$1:A$10)), ROW(A1))),"") Note that if F4 is intented for different purpose, a new key combination must be found for that. -- You are receiving this mail because: You are the assignee for the bug.
