Fedora 30 snd Calc -

[Bob Goodwin]

I need help getting LibreOffice Calc to accept a simple math function, 
=E1+G2-F2 and use it.

Can someone point me to a good instruction for entering it? I simply 
want to add two columns, E and G, and subtract F. I've done this before 
with out a problem, can't seem to make it work in a new install ...

Bob

[Clifford Snow]

I'm running 6.2.6.2 of Calc. The calculations work as expected. The formula
is =E1+G2-F2 which equals 6

Col                  E
F                    G
1 5 3 4
2 6 4 5

On Sun, Sep 1, 2019 at 1:30 PM Bob Goodwin  wrote:
> I need help getting LibreOffice Calc to accept a simple math function,
> =E1+G2-F2 and use it.
>
> Can someone point me to a good instruction for entering it? I simply
> want to add two columns, E and G, and subtract F. I've done this before
> with out a problem, can't seem to make it work in a new install ...
>
> Bob
>
> --
> Bob Goodwin - Zuni, Virginia, USA
> http://www.qrz.com/db/W2BOD
> box10  FEDORA-29/64bit LINUX XFCE Fastmail POP3
>
> users mailing list -- [e-mail]
> To unsubscribe send an email to [e-mail]
> Fedora Code of Conduct:
> https://docs.fedoraproject.org/en-US/project/code-of-conduct/
> List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
> List Archives:
> https://lists.fedoraproject.org/archives/list/[e-mail]

[Ed Greshko]

On 9/2/19 4:29 AM, Bob Goodwin wrote:
> I need help getting LibreOffice Calc to accept a simple math function, =E1+G2-F2 and use it.
>
> Can someone point me to a good instruction for entering it? I simply want to add two columns, E and G, and subtract F. I've done this before with out a problem, can't seem to make it work in a new install ...

I do not know what you want to do based on the words you've used.

You say "columns", but the elements E1, G2, and F2 define "cells".   With the letter designating the "column" of the cell and the number the "row" of the cell.

Why don't you place you're calc file some where for folks to look at it?

[Bob Goodwin]

On 09/01/19 17:28, Ed Greshko wrote:
> Why don't you place you're calc file some where for folks to look at it?

I don't know how to respond to that. LibreOffice calc loos like one big 
GUI to me. I can't find a text config. file  to offer?

[Ed Greshko]

On 9/2/19 5:48 AM, Bob Goodwin wrote:
> On 09/01/19 17:28, Ed Greshko wrote:
> > Why don't you place you're calc file some where for folks to look at it?
>
> I don't know how to respond to that. LibreOffice calc loos like one big GUI to me. I can't find a text config. file  to offer?

When you save your work you get a file called "something.ods" (normally).

Put that file on google drive or someplace for people to download.

[Ed Greshko]

On 9/2/19 5:51 AM, Ed Greshko wrote:
> On 9/2/19 5:48 AM, Bob Goodwin wrote:
> > On 09/01/19 17:28, Ed Greshko wrote:
> > > Why don't you place you're calc file some where for folks to look at it?
> >
> > I don't know how to respond to that. LibreOffice calc loos like one big GUI to me. I can't find a text config. file  to offer?
>
> When you save your work you get a file called "something.ods" (normally).
>
> Put that file on google drive or someplace for people to download.

You can get the file is_this_it.ods using this link

https://drive.google.com/file/d/1MplVir1dNx0w2nF9--dS_-AqfcH7YlWl/view?usp=s...

Google Drive is "smart" and opens it in "Google Sheets".  So you will need to download it and open it in Calc
to see the work.