# How to apply a text formatted formula with new data

Sorry, guys, I think this is a trivial question, but I couldn't find this answer in my researchs.

This question is a follow up of this one (just in case someone needs more details): https://ask.libreoffice.org/en/questi...

I have two spreadsheets: one with rules and respective formulas; and the other with my choices of rules (a rule could not be chosen, or even be chosen more than once). The second spreadsheet has each rule attached to its respective formula retrieved by:

=FORMULA(INDIRECT("Sheet1.C"&MATCH(A1,Sheet1.$A$1:$A$999,1)))


So, I have in the second spreadsheet a "text formatted" formula.

Let's say that I have these:

Sheet1.A1: ID1 Sheet1.B1: 34 Sheet1.C1: "XX" Sheet1.D1: Sheet1.$B1*C1 Sheet2.A1: ID1 Sheet2.C1: 10 Sheet2.D1: '= Sheet1.$B1*C1 (result of the formula above)

How do I apply the formula in Sheet2.D1 to Sheet2.E1, for example, to get the resulting 340?

edit retag close merge delete

Sort by » oldest newest most voted

Sorry, I haven't found any type of evaluation of textual formulas in Libre Calc.

I'm assuming there is no way to do this.

more