Evaluate text cell as a formula in Calc

English
#1

Hi,
I can’t find anywhere how to “evaluate” a text cell as a formula in Calc.
eg “25 * 30 * 60”
to be evaluated as “=25 * 30 * 60 / 1000”. (I could manage the /1000 in another cell indeed)

  • I need the text cell.
  • I just need what function to call to evaluate it as a formula.

It seems that this is a known issue/limitation in Calc that doesn’t exist in Excel ?.
I tried to look at INDIRECT, but it’s not even documented in the Calc User Manual, not found in LO help, and it doesn’t seem to do what I need.

#2

Let me repost my comments in IRC here.

There is no “evaluate” function in Calc. It may be implemented using a macro (esp. if you use Python); but why do you need that, at all? Often, when people want it, they actually can equally do the opposite, and have a normal cell with a =25 * 30 * 60 / 1000 formula, plus a cell with a =FORMULA(A1) formula referring to the first one.

Does Excel already implement an Eval?

#3

Will not help, but available:

https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDIRECT

#4

Like as column F in this example ?

#5

See this “help”.
As always with MS Excel help I miss relevant informtion. In this case mainly

  • how are formulas treated if they have parts whose interpretation depends on the locale or user settings?
  • an explicit explanation concerning “What about formulas returning an array?”
  • a clear statement if the function can also be used in a spreadsheet or only in VBA for Excel.

Of course they don’t miss to tell you that you should “Buy Microsoft 365” (whatever this should mean - suppose Office 365).
=== ===
Editing:
I forgot the most relevant problem. It’s now in the first place.

#6

i think to extract all the 20 charakters of that TEXT string into each position of number and operator – in unique resolutions because the math. operators are not equal to the digital operators and the values can be with or without comma/dot.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.