Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 22 Feb 2018 17:14:49 +0100Is it possible to convert a text string to a formula?https://ask.libreoffice.org/en/question/147171/is-it-possible-to-convert-a-text-string-to-a-formula/Is it possible to convert text to a formula or to otherwise run a formula in a different cell?
I am working on a series of spreadsheets for an RPG, each fine contains a dozen or so character sheets with identical formulae if I want to change one formula I have to then go through every player character and non-player Character sheet and paste in the new formula, is it possible to emulate Excel's Evaluate function?
for example,
Formulas.B2 contains the formula =MID(CELL("filename",A1),FIND("$",CELL("filename",A1))+1,255)
would it be possible to have something along the lines of =Evaluate(Formula($Formulas.B1)) that way only writing the formula once without having to make it a named expression it would also mean that canges to any formual will impact all sheets rather than one sheet at a time?hhaddowThu, 22 Feb 2018 17:14:49 +0100https://ask.libreoffice.org/en/question/147171/