Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #157990 > unrolled thread

Re: how to sum a column in openoffice calc

Back to article view | Back to linux.debian.user

Contents

  Re: how to sum a column in openoffice calc Li Wei <rootof3@yahoo.com> - 2015-09-16 23:20 +0200
    Re: how to sum a column in openoffice calc Floris <jkfloris@dds.nl> - 2015-09-16 23:30 +0200
      Re: how to sum a column in openoffice calc Carl Fink <carl@finknetwork.com> - 2015-09-17 02:40 +0200
    Re: how to sum a column in openoffice calc Sven Arvidsson <sa@whiz.se> - 2015-09-17 16:40 +0200
    Re: how to sum a column in openoffice calc Siard <shiems146@kpnplanet.nl> - 2015-09-17 17:10 +0200
      Re: how to sum a column in openoffice calc Li Wei <rootof3@yahoo.com> - 2015-09-17 18:50 +0200
        Re: how to sum a column in openoffice calc Siard <shiems146@kpnplanet.nl> - 2015-09-17 22:40 +0200
        Re: how to sum a column in openoffice calc Curt <curty@free.fr> - 2015-09-18 14:10 +0200
          Re: how to sum a column in openoffice calc Li Wei <rootof3@yahoo.com> - 2015-09-18 23:40 +0200
            Re: how to sum a column in openoffice calc David Wright <deblis@lionunicorn.co.uk> - 2015-09-19 05:10 +0200
              (solved) Re: how to sum a column in openoffice calc Li Wei <rootof3@yahoo.com> - 2015-09-19 06:00 +0200

#157990 — Re: how to sum a column in openoffice calc

[Multipart message — attachments visible in raw view] — view raw

Thanks to all those who reply!

I have prefix equal sign, but it doesn't work
I have attach the calc file, it's in Chinese, (sorry)
my question is how to display sum(N1:N8) in cell N9

Thanks!

--------------------------------------------
On Wed, 9/16/15, Curt <curty@free.fr> wrote:

 Subject: Re: how to sum a column in openoffice calc
 To: debian-user@lists.debian.org
 Date: Wednesday, September 16, 2015, 11:26 AM
 
 On 2015-09-16, Lars Noodén <lars.nooden@gmail.com>
 wrote:
 >> 
 > Wouldn't that be "=SUM(N1:N8)" instead, with an equal
 sign?
 >
 
 That works for me.
 
 I just hit that Greek letter (epsilon?).

[toc] | [next] | [standalone]

#157991

Op Wed, 16 Sep 2015 23:13:34 +0200 schreef Li Wei <rootof3@yahoo.com>:

> Thanks to all those who reply!
>
> I have prefix equal sign, but it doesn't work
> I have attach the calc file, it's in Chinese, (sorry)
> my question is how to display sum(N1:N8) in cell N9
>
> Thanks!
>


What is your decimal separator?

Go to Tools --> Options --> language Settings --> Languages

Because when I replace the dots, with a comma the formula
=SUM(N1:N8) works

Success,

floris

[toc] | [prev] | [next] | [standalone]

#157997

On Wed, Sep 16, 2015 at 11:27:12PM +0200, Floris wrote:

> What is your decimal separator?
> 
> Go to Tools --> Options --> language Settings --> Languages
> 
> Because when I replace the dots, with a comma the formula
> =SUM(N1:N8) works

Interestingly, on my system the items in those cells are not numbers at all.
They're labels (text) that therefore add up to zero.
-- 
Carl Fink                           nitpicking@nitpicking.com 

Read my blog at blog.nitpicking.com.  Reviews!  Observations!
Stupid mistakes you can correct!

[toc] | [prev] | [next] | [standalone]

#158018

[Multipart message — attachments visible in raw view] — view raw

On Wed, 2015-09-16 at 14:13 -0700, Li Wei wrote:
> Thanks to all those who reply!
> 
> I have prefix equal sign, but it doesn't work
> I have attach the calc file, it's in Chinese, (sorry)
> my question is how to display sum(N1:N8) in cell N9

Hi,

There are also mailing lists specifically for LibreOffice:
https://www.libreoffice.org/get-help/mailing-lists/

and also in Chinese:
https://wiki.documentfoundation.org/Local_Mailing_Lists#Chinese

You might get faster help there.


-- 
Cheers,
Sven Arvidsson
http://www.whiz.se
PGP Key ID 6FAB5CD5

[toc] | [prev] | [next] | [standalone]

#158021

Li Wei wrote:
> I have attach the calc file, it's in Chinese, (sorry)
> my question is how to display sum(N1:N8) in cell N9

I can see it now.  N1:N8 do not contain numbers; they contain
alphanumeric strings.  If you select N1, then this is what you see in
the formula bar:  '-755.68
The apostroph it starts with, shows that this string is alphanumeric.

I don't know how you got those numbers there in the first place. There
must be a better way.
But there is a workaround.  Insert a new column O (next to N) and put
this formula in O1:  =N1+0   (0 = zero)
In LibreOffice, an addition like this converts the alphanumeric string
into a number.
Now copy O1 to O2:O8 and you'll see that SUM(O1:O8) in O9 works.

[toc] | [prev] | [next] | [standalone]

#158027

I have not realized the problem is so difficult
I'd rather do manual calculation, it's one-time task
The file is paste from a Excel file

Thanks anyway!

--------------------------------------------
On Thu, 9/17/15, Siard <shiems146@kpnplanet.nl> wrote:

 
 I can see it now.  N1:N8 do not contain numbers; they
 contain
 alphanumeric strings.  If you select N1, then this is
 what you see in
 the formula bar:  '-755.68
 The apostroph it starts with, shows that this string is
 alphanumeric.
 
 I don't know how you got those numbers there in the first
 place. There
 must be a better way.
 But there is a workaround.  Insert a new column O (next
 to N) and put
 this formula in O1:  =N1+0   (0 = zero)
 In LibreOffice, an addition like this converts the
 alphanumeric string
 into a number.
 Now copy O1 to O2:O8 and you'll see that SUM(O1:O8) in O9
 works.
 
 

[toc] | [prev] | [next] | [standalone]

#158032

Li Wei wrote:
> I have not realized the problem is so difficult
> I'd rather do manual calculation, it's one-time task
> The file is paste from a Excel file

Pasting from an Excel file looks odd to me, I guess it gives
unpredictable results.
Better open the Excel file with LO and paste it from there.

[toc] | [prev] | [next] | [standalone]

#158048

On 2015-09-17, Li Wei <rootof3@yahoo.com> wrote:

> I have not realized the problem is so difficult
> I'd rather do manual calculation, it's one-time task
> The file is paste from a Excel file

I know how you feel.  Have you tried opening the
Excel file directly in Open Office Calc?

[toc] | [prev] | [next] | [standalone]

#158060

I don't have Excel
I open the file with oocalc
sort it and select part of it
then copy/paste to a new file in oocalc

--------------------------------------------
On Fri, 9/18/15, Curt <curty@free.fr> wrote:

 Subject: Re: how to sum a column in openoffice calc
 To: debian-user@lists.debian.org
 Date: Friday, September 18, 2015, 8:06 AM
 
 
 I know how you feel.  Have you tried opening the
 Excel file directly in Open Office Calc?
 
 

[toc] | [prev] | [next] | [standalone]

#158067

Quoting Li Wei (rootof3@yahoo.com):
> I don't have Excel
> I open the file with oocalc

It was suggested in Carl Fink's posting
https://lists.debian.org/debian-user/2015/09/msg00743.html
that the numbers that you are trying to sum are not numbers at all.
Could you check that out and respond. It would help to do this
immediately after you reach this stage, ie after opening the
excel file in oocalc ... 

> sort it and select part of it
> then copy/paste to a new file in oocalc

... and check a second time at this stage, ie after pasting into
the new spreadsheet.

Cheers,
David.

[toc] | [prev] | [next] | [standalone]

#158068 — (solved) Re: how to sum a column in openoffice calc

I have complete the task using galculator manually
Thanks anyway!
 
--------------------------------------------
On Fri, 9/18/15, David Wright <deblis@lionunicorn.co.uk> wrote:

 Subject: Re: how to sum a column in openoffice calc
 To: debian-user@lists.debian.org
 Date: Friday, September 18, 2015, 11:06 PM
 
 
 It was suggested in Carl
 Fink's posting
 https://lists.debian.org/debian-user/2015/09/msg00743.html
 that the numbers that you are trying to sum are
 not numbers at all.
 Could you check that out
 and respond. It would help to do this
 immediately after you reach this stage, ie
 after opening the
 excel file in oocalc ...
 
 
 ... and check
 a second time at this stage, ie after pasting into
 the new spreadsheet.
 
 Cheers,
 David.
 
 

[toc] | [prev] | [standalone]

Back to top | Article view | linux.debian.user

csiph-web