You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by 19...@gmail.com on 2016/12/19 23:03:01 UTC
when using spreadsheet
How do I get the total of a column and when putting numbers in then highlighting the column instead of getting SUM= how can I get numbers as SUM= does not tell me much ie= 13425
Sent from Mail for Windows 10
Re: when using spreadsheet
Posted by Girvin Herr <gi...@fastmail.com>.
Another thing to check if Alan's suggestion doesn't work or especially
if not all formulas are displayed is to make sure there are no blanks
(spaces) at the beginning of the =SUM line. The = (equal character)
must be the first character and it is not always obvious. That bit me a
while back and I spent hours trying to figure why some cells had the
correct result value and others had the formula displayed.
HTH
Girvin Herr
On 12/20/2016 01:27 PM, Alan B wrote:
> Tony,
>
> If you mean that you see the text "=SUM(xxx:xxx)" displayed instead of the
> number result then it is likelyi the "Display Formulas" option may be
> ticked.
>
> To disable the "Display Formulas" option and cause the number result to
> display...
>
> Select "Tools -> Options...:" from the menu
>
> Select the "LibreOffice Calc -> View" path from the list of options on the
> left
>
> To the right, under the "Display" options check if "Formulas" is tic'd. If
> it is, remove the tic.
>
> Click "OK".
>
> Number results will now be displayed.
>
>
> On Mon, Dec 19, 2016 at 10:47 PM, Martin Groenescheij <
> Martin@groenescheij.com> wrote:
>
>>
>> On 20/12/16 10:03 AM, 1939tony@gmail.com wrote:
>>
>>> How do I get the total of a column and when putting numbers in then
>>> highlighting the column instead of getting SUM= how can I get numbers as
>>> SUM= does not tell me much ie= 13425
>>>
>> The Sum= sums the content of all selected cells, if you want the total of
>> a column just select that column.
>> By the way if you right click on Sum= you see other options e.g. Average
>> or Count
>>
>>
>>> Sent from Mail for Windows 10
>>>
>>>
>>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: users-help@openoffice.apache.org
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: when using spreadsheet
Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
On 22/12/16 4:03 AM, Florence Padilla wrote:
> Hi, I'm having a problem with open office too if anyone can help.
And you have a problem with emailing too!
There is no need to include emails from another thread.
> My open
> office only works on one account on my computer but not the other account.
> How do I get it to work on all accounts?? I download the app like normal
> but afterwards when it comes time to open the app, a "fatal error" message
> comes up..
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: when using spreadsheet
Posted by Julian Thomas <jt...@jt-mj.net>.
> On Dec 21, 2016, at 12:03, Florence Padilla <fl...@gmail.com> wrote:
>
> My open
> office only works on one account on my computer but not the other account.
> How do I get it to work on all accounts?? I download the app like normal
> but afterwards when it comes time to open the app, a "fatal error" message
> comes up..
For a start - what operating system? Where did you go to download the second copy? What is the exact 'fatal error' message?
----
Julian Thomas - http://jt-mj.net
He is a self-made man and worships his creator -- John Bright
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: when using spreadsheet
Posted by Florence Padilla <fl...@gmail.com>.
Hi, I'm having a problem with open office too if anyone can help. My open
office only works on one account on my computer but not the other account.
How do I get it to work on all accounts?? I download the app like normal
but afterwards when it comes time to open the app, a "fatal error" message
comes up..
On Tue, Dec 20, 2016 at 5:15 PM Joseph B <jo...@gmail.com> wrote:
> Ok, thanks
>
>
>
>
>
> On Tue, Dec 20, 2016 at 4:13 PM, Martin Groenescheij <
>
> Martin@groenescheij.com> wrote:
>
>
>
> >
>
> >
>
> > On 21/12/16 9:01 AM, Joseph B wrote:
>
> >
>
> >> How do I get off this list
>
> >>
>
> >
>
> > Somewhere down the bottom you see the "To unsubscribe" instructions
>
> >
>
> >
>
> >
>
> >> On Dec 20, 2016 3:27 PM, "Alan B" <ab...@gmail.com> wrote:
>
> >>
>
> >> Tony,
>
> >>>
>
> >>> If you mean that you see the text "=SUM(xxx:xxx)" displayed instead of
>
> >>> the
>
> >>> number result then it is likelyi the "Display Formulas" option may be
>
> >>> ticked.
>
> >>>
>
> >>> To disable the "Display Formulas" option and cause the number result to
>
> >>> display...
>
> >>>
>
> >>> Select "Tools -> Options...:" from the menu
>
> >>>
>
> >>> Select the "LibreOffice Calc -> View" path from the list of options on
>
> >>> the
>
> >>> left
>
> >>>
>
> >>> To the right, under the "Display" options check if "Formulas" is tic'd.
>
> >>> If
>
> >>> it is, remove the tic.
>
> >>>
>
> >>> Click "OK".
>
> >>>
>
> >>> Number results will now be displayed.
>
> >>>
>
> >>>
>
> >>> On Mon, Dec 19, 2016 at 10:47 PM, Martin Groenescheij <
>
> >>> Martin@groenescheij.com> wrote:
>
> >>>
>
> >>>
>
> >>>> On 20/12/16 10:03 AM, 1939tony@gmail.com wrote:
>
> >>>>
>
> >>>> How do I get the total of a column and when putting numbers in then
>
> >>>>> highlighting the column instead of getting SUM= how can I get numbers
>
> >>>>> as
>
> >>>>> SUM= does not tell me much ie= 13425
>
> >>>>>
>
> >>>>> The Sum= sums the content of all selected cells, if you want the
> total
>
> >>>> of
>
> >>>> a column just select that column.
>
> >>>> By the way if you right click on Sum= you see other options e.g.
> Average
>
> >>>> or Count
>
> >>>>
>
> >>>>
>
> >>>> Sent from Mail for Windows 10
>
> >>>>>
>
> >>>>>
>
> >>>>>
>
> >>>>> ---------------------------------------------------------------------
>
> >>>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>
> >>>> For additional commands, e-mail: users-help@openoffice.apache.org
>
> >>>>
>
> >>>>
>
> >>>>
>
> >>> --
>
> >>> Alan Boba
>
> >>> CISSP, CCENT, ITIL v3 Foundations 2011
>
> >>>
>
> >>>
>
> >
>
> > ---------------------------------------------------------------------
>
> > To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>
> > For additional commands, e-mail: users-help@openoffice.apache.org
>
> >
>
> >
>
>
Re: when using spreadsheet
Posted by Joseph B <jo...@gmail.com>.
Ok, thanks
On Tue, Dec 20, 2016 at 4:13 PM, Martin Groenescheij <
Martin@groenescheij.com> wrote:
>
>
> On 21/12/16 9:01 AM, Joseph B wrote:
>
>> How do I get off this list
>>
>
> Somewhere down the bottom you see the "To unsubscribe" instructions
>
>
>
>> On Dec 20, 2016 3:27 PM, "Alan B" <ab...@gmail.com> wrote:
>>
>> Tony,
>>>
>>> If you mean that you see the text "=SUM(xxx:xxx)" displayed instead of
>>> the
>>> number result then it is likelyi the "Display Formulas" option may be
>>> ticked.
>>>
>>> To disable the "Display Formulas" option and cause the number result to
>>> display...
>>>
>>> Select "Tools -> Options...:" from the menu
>>>
>>> Select the "LibreOffice Calc -> View" path from the list of options on
>>> the
>>> left
>>>
>>> To the right, under the "Display" options check if "Formulas" is tic'd.
>>> If
>>> it is, remove the tic.
>>>
>>> Click "OK".
>>>
>>> Number results will now be displayed.
>>>
>>>
>>> On Mon, Dec 19, 2016 at 10:47 PM, Martin Groenescheij <
>>> Martin@groenescheij.com> wrote:
>>>
>>>
>>>> On 20/12/16 10:03 AM, 1939tony@gmail.com wrote:
>>>>
>>>> How do I get the total of a column and when putting numbers in then
>>>>> highlighting the column instead of getting SUM= how can I get numbers
>>>>> as
>>>>> SUM= does not tell me much ie= 13425
>>>>>
>>>>> The Sum= sums the content of all selected cells, if you want the total
>>>> of
>>>> a column just select that column.
>>>> By the way if you right click on Sum= you see other options e.g. Average
>>>> or Count
>>>>
>>>>
>>>> Sent from Mail for Windows 10
>>>>>
>>>>>
>>>>>
>>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>>>> For additional commands, e-mail: users-help@openoffice.apache.org
>>>>
>>>>
>>>>
>>> --
>>> Alan Boba
>>> CISSP, CCENT, ITIL v3 Foundations 2011
>>>
>>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
Re: when using spreadsheet
Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
On 21/12/16 9:01 AM, Joseph B wrote:
> How do I get off this list
Somewhere down the bottom you see the "To unsubscribe" instructions
>
> On Dec 20, 2016 3:27 PM, "Alan B" <ab...@gmail.com> wrote:
>
>> Tony,
>>
>> If you mean that you see the text "=SUM(xxx:xxx)" displayed instead of the
>> number result then it is likelyi the "Display Formulas" option may be
>> ticked.
>>
>> To disable the "Display Formulas" option and cause the number result to
>> display...
>>
>> Select "Tools -> Options...:" from the menu
>>
>> Select the "LibreOffice Calc -> View" path from the list of options on the
>> left
>>
>> To the right, under the "Display" options check if "Formulas" is tic'd. If
>> it is, remove the tic.
>>
>> Click "OK".
>>
>> Number results will now be displayed.
>>
>>
>> On Mon, Dec 19, 2016 at 10:47 PM, Martin Groenescheij <
>> Martin@groenescheij.com> wrote:
>>
>>>
>>> On 20/12/16 10:03 AM, 1939tony@gmail.com wrote:
>>>
>>>> How do I get the total of a column and when putting numbers in then
>>>> highlighting the column instead of getting SUM= how can I get numbers as
>>>> SUM= does not tell me much ie= 13425
>>>>
>>> The Sum= sums the content of all selected cells, if you want the total of
>>> a column just select that column.
>>> By the way if you right click on Sum= you see other options e.g. Average
>>> or Count
>>>
>>>
>>>> Sent from Mail for Windows 10
>>>>
>>>>
>>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>>> For additional commands, e-mail: users-help@openoffice.apache.org
>>>
>>>
>>
>> --
>> Alan Boba
>> CISSP, CCENT, ITIL v3 Foundations 2011
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: when using spreadsheet
Posted by Joseph B <jo...@gmail.com>.
How do I get off this list
On Dec 20, 2016 3:27 PM, "Alan B" <ab...@gmail.com> wrote:
> Tony,
>
> If you mean that you see the text "=SUM(xxx:xxx)" displayed instead of the
> number result then it is likelyi the "Display Formulas" option may be
> ticked.
>
> To disable the "Display Formulas" option and cause the number result to
> display...
>
> Select "Tools -> Options...:" from the menu
>
> Select the "LibreOffice Calc -> View" path from the list of options on the
> left
>
> To the right, under the "Display" options check if "Formulas" is tic'd. If
> it is, remove the tic.
>
> Click "OK".
>
> Number results will now be displayed.
>
>
> On Mon, Dec 19, 2016 at 10:47 PM, Martin Groenescheij <
> Martin@groenescheij.com> wrote:
>
> >
> >
> > On 20/12/16 10:03 AM, 1939tony@gmail.com wrote:
> >
> >> How do I get the total of a column and when putting numbers in then
> >> highlighting the column instead of getting SUM= how can I get numbers as
> >> SUM= does not tell me much ie= 13425
> >>
> >
> > The Sum= sums the content of all selected cells, if you want the total of
> > a column just select that column.
> > By the way if you right click on Sum= you see other options e.g. Average
> > or Count
> >
> >
> >> Sent from Mail for Windows 10
> >>
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> > For additional commands, e-mail: users-help@openoffice.apache.org
> >
> >
>
>
> --
> Alan Boba
> CISSP, CCENT, ITIL v3 Foundations 2011
>
Re: when using spreadsheet
Posted by Alan B <ab...@gmail.com>.
Tony,
If you mean that you see the text "=SUM(xxx:xxx)" displayed instead of the
number result then it is likelyi the "Display Formulas" option may be
ticked.
To disable the "Display Formulas" option and cause the number result to
display...
Select "Tools -> Options...:" from the menu
Select the "LibreOffice Calc -> View" path from the list of options on the
left
To the right, under the "Display" options check if "Formulas" is tic'd. If
it is, remove the tic.
Click "OK".
Number results will now be displayed.
On Mon, Dec 19, 2016 at 10:47 PM, Martin Groenescheij <
Martin@groenescheij.com> wrote:
>
>
> On 20/12/16 10:03 AM, 1939tony@gmail.com wrote:
>
>> How do I get the total of a column and when putting numbers in then
>> highlighting the column instead of getting SUM= how can I get numbers as
>> SUM= does not tell me much ie= 13425
>>
>
> The Sum= sums the content of all selected cells, if you want the total of
> a column just select that column.
> By the way if you right click on Sum= you see other options e.g. Average
> or Count
>
>
>> Sent from Mail for Windows 10
>>
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
--
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011
Re: when using spreadsheet
Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
On 23/12/16 7:15 AM, VinceB. wrote:
>
> Martin:
> Please help me: where, exactly, or how do I click on "Sum=" ? This
> does not work when I click on the Sum icon that is located near the
> "=" icon. Do you mean while the formula is shown within the address bar?
> I would like to see those other options. :-)
You see it at the bottom gray bar about 75% from the left (if you sit
in front of the screen).
> Regards,
> VinceB.
>
>
> On 12/19/2016 10:47 PM, Martin Groenescheij wrote:
>>
>>
>> By the way if you right click on Sum= you see other options e.g.
>> Average or Count
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: when using spreadsheet
Posted by "VinceB." <wa...@verizon.net>.
Martin:
Please help me: where, exactly, or how do I click on "Sum=" ? This does
not work when I click on the Sum icon that is located near the "="
icon. Do you mean while the formula is shown within the address bar?
I would like to see those other options. :-)
Regards,
VinceB.
On 12/19/2016 10:47 PM, Martin Groenescheij wrote:
>
>
> By the way if you right click on Sum= you see other options e.g.
> Average or Count
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: when using spreadsheet
Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
On 20/12/16 10:03 AM, 1939tony@gmail.com wrote:
> How do I get the total of a column and when putting numbers in then highlighting the column instead of getting SUM= how can I get numbers as SUM= does not tell me much ie= 13425
The Sum= sums the content of all selected cells, if you want the total
of a column just select that column.
By the way if you right click on Sum= you see other options e.g. Average
or Count
>
> Sent from Mail for Windows 10
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org