[Solved] Is there a way to do that?

Discuss the spreadsheet application
Post Reply
xamlet
Posts: 3
Joined: Thu Aug 04, 2011 6:40 pm

[Solved] Is there a way to do that?

Post by xamlet »

Hi guys,
i'm not exactly the newbie with OO but today i got a problem to find a solution.

so I have a cells with simple math operations like a*b+c*d+e*f i need them shown on table and in the next cell i need to have sum from that. I tryed alot of things but with no success i would be very happy if someone can show me a decision of my problem. Maybe its a really stupid question but i didn't find any way to make it run.

Thanks in advice
Last edited by xamlet on Thu Aug 04, 2011 8:57 pm, edited 1 time in total.
OpenOffice 3.3.0 on Apple MAC OS X 10.6.8
jrkrideau
Volunteer
Posts: 3814
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Is there a way to do that?

Post by jrkrideau »

xamlet wrote:Hi guys,
i'm not exactly the newbie with OO but today i got a problem to find a solution.

so I have a cells with simple math operations like a*b+c*d+e*f i need them shown on table and in the next cell i need to have sum from that. I tryed alot of things but with no success i would be very happy if someone can show me a decision of my problem. Maybe its a really stupid question but i didn't find any way to make it run.

Thanks in advice
Can you give us an example? I am not clear on what you want summed.
LibreOffice 7.1.5.2; Ubuntu 21.10
xamlet
Posts: 3
Joined: Thu Aug 04, 2011 6:40 pm

Re: Is there a way to do that?

Post by xamlet »

i need to have in one cell 1*100+2*40+3*25 that should be printable as it is, and in other cell i need to have the end result from that currently 255.
OpenOffice 3.3.0 on Apple MAC OS X 10.6.8
mriosv
Volunteer
Posts: 651
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)

Re: Is there a way to do that?

Post by mriosv »

If in
A1: =1*100+2*50+3*25
in
A2: =FORMULA(A1)
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
xamlet
Posts: 3
Joined: Thu Aug 04, 2011 6:40 pm

Re: Is there a way to do that?

Post by xamlet »

it is not the exactly what i needed but its a step in right direction
for me it would be the best thing to have A1 with 1*100+2*50+3*25 without "=" and than to have it calculated in A2
but anyway hope that will helps me alot
Thanks
OpenOffice 3.3.0 on Apple MAC OS X 10.6.8
User avatar
Hagar Delest
Moderator
Posts: 30993
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Is there a way to do that?

Post by Hagar Delest »

Code: Select all

=RIGHT(FORMULA(A2);LEN(FORMULA(A2))-1)
Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.
LibreOffice 7.4 on Xubuntu 22.10 and 7.4 portable on Windows 10
User avatar
JohnSUN-Pensioner
Volunteer
Posts: 876
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine
Contact:

Re: Is there a way to do that?

Post by JohnSUN-Pensioner »

I think I understood! You will need an analog of function EVAL()?
Try to read this discussion. It is the Russian language. But the Google-translator to help you. There are interesting not so much a debate as applied solutions.
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Post Reply