Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 31 Jan 2020 20:47:57 +0100is there a way to store a formula and "paste" it on command?https://ask.libreoffice.org/en/question/227407/is-there-a-way-to-store-a-formula-and-paste-it-on-command/I have a formula that I use on certain cells in the M column. My method is first I copy a cell that contains the formula, then I do a special paste of 'formula only' into the new cell, now the cell has the formula which is what is desired, works fine but.. This process can be time consuming as I have to find a cell in the column and paste formula only into the cell I decide on.
Is it possible to have a more efficient method to apply the formula onto a cell? I tired to keep the text of the formula on a separate sheet but pasting just the text does not keep the row numbers in sequence as with the $ sign..
Thank you.
here's a copy of the formula I'd like to readily apply to cells for context
=IF(ISNA(VLOOKUP(A4,'Sheet1'.$A$3:$M$1358,MATCH($M$2,$'Sheet1'.$A$2:$'Sheet1'.$M$2,0),0)),"",VLOOKUP(A4,'Sheet1'.$A$3:$M$1358,MATCH($M$2,$'Sheet1'.$A$2:$'Sheet1'.$M$2,0),0))clos911Fri, 31 Jan 2020 20:47:57 +0100https://ask.libreoffice.org/en/question/227407/