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


Groups > linux.debian.user > #158067

Re: how to sum a column in openoffice calc

From David Wright <deblis@lionunicorn.co.uk>
Newsgroups linux.debian.user
Subject Re: how to sum a column in openoffice calc
Date 2015-09-19 05:10 +0200
Message-ID <qagHf-5Gn-7@gated-at.bofh.it> (permalink)
References <qa2Eh-29u-3@gated-at.bofh.it> <qabxT-6k6-7@gated-at.bofh.it>
Organization linux.* mail to news gateway

Show all headers | View raw


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.

Back to linux.debian.user | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

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

csiph-web