[Solved] Evaluate math expression

Discuss the spreadsheet application
Post Reply
ws-garcia
Posts: 2
Joined: Tue Apr 02, 2024 3:45 pm

[Solved] Evaluate math expression

Post by ws-garcia »

In Excel there is an Eval function for evaluating expressions given as String value. Is there a way to achieve a goal similar that one in OO? For example, an user is able to evaluate expressiona like sin(90) + cos(30)/3.
Last edited by ws-garcia on Wed Apr 03, 2024 5:29 pm, edited 1 time in total.
OpenOffice 4.1.15 Windows 10
User avatar
RoryOF
Moderator
Posts: 34611
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Evaluate math expression

Post by RoryOF »

Select the cell, then put an = sign before the formula when it shows in the Formula bar. You may beed to turn on /;View /Formula Bar to see the Formula bar.You may (I'm not not certain) need to bracket the complete expression, viz.:
=(sin(90) +cos(30)/3)
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
keme
Volunteer
Posts: 3703
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Evaluate math expression

Post by keme »

User avatar
robleyd
Moderator
Posts: 5080
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Evaluate math expression

Post by robleyd »

Cross posted on AskLibreOffice where some discussion has ensued.

If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
ws-garcia
Posts: 2
Joined: Tue Apr 02, 2024 3:45 pm

Re: Evaluate math expression

Post by ws-garcia »

If you cross post, as a courtesy please let us know that you have done so
So yes, I cross posted to get a quick answer while this post keep unapproved state. I received a useful information yet, pointing there is no way to take literally strings an evaluate a function without using spreadsheets and cells in OO or LO.
OpenOffice 4.1.15 Windows 10
Post Reply