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/is there a way to select the "Block Margins" of vlookup results? (calc)https://ask.libreoffice.org/en/question/226748/is-there-a-way-to-select-the-block-margins-of-vlookup-results-calc/I have a sheet with formulas for vlookup.
I use keyboard shortcuts to "Select to Lower Block Margin" and "Select to Right Block Margin".
I use those two shortcuts very often on cells with text and cells with numbers. I would like to be able to use the same shortcuts on formula results.. when I use the shortcut "Select to Lower Block Margin" on the cells with the formula it will selects all the way to the bottom row 1048576..
any help is appreciatedclos911Mon, 27 Jan 2020 03:47:46 +0100https://ask.libreoffice.org/en/question/226748/