I have complete the task using galculator manually
Thanks anyway!
On Fri, 9/18/15, David Wright 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
Quoting Li Wei (root...@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 wou
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 wrote:
Subject: Re: how to sum a column in openoffice calc
To: debian-user@lists.debian.org
Date: F
On 2015-09-17, 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
I know how you feel. Have you tried opening the
Excel file directly in Open Office Calc?
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 ther
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 wrote:
I can see it now. N1:N8 do not contain numbers; they
contain
a
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 i
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 Libr
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 no
Op Wed, 16 Sep 2015 23:13:34 +0200 schreef Li Wei :
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 --
On Wed, Sep 16, 2015 at 03:12:22PM +0200, Sven Arvidsson wrote:
> On Wed, 2015-09-16 at 06:02 -0700, Li Wei wrote:
> > I want sum of a column of values
> > I enter "SUM(N1:N8)" in cell N9
> > but can't get cell N9 to display sum
> >
> > Thanks in advance!!!
> >
> > PS: I'm in China and can't use
On 2015-09-16, Lisi Reisz wrote:
> On Wednesday 16 September 2015 16:26:58 Curt wrote:
>> On 2015-09-16, Lars Noodén wrote:
>> > Wouldn't that be "=SUM(N1:N8)" instead, with an equal sign?
>>
>> That works for me.
>>
>> I just hit that Greek letter (epsilon?).
>
> I don't know the actual thing, b
On Wednesday 16 September 2015 16:26:58 Curt wrote:
> On 2015-09-16, Lars Noodén wrote:
> > Wouldn't that be "=SUM(N1:N8)" instead, with an equal sign?
>
> That works for me.
>
> I just hit that Greek letter (epsilon?).
I don't know the actual thing, but it is much more likely to be upper case
s
On 2015-09-16, Lars Noodén wrote:
>>
> Wouldn't that be "=SUM(N1:N8)" instead, with an equal sign?
>
That works for me.
I just hit that Greek letter (epsilon?).
On Wed, 2015-09-16 at 06:02 -0700, Li Wei wrote:
> I want sum of a column of values
> I enter "SUM(N1:N8)" in cell N9
> but can't get cell N9 to display sum
>
> Thanks in advance!!!
>
> PS: I'm in China and can't use google to find answer
Hi,
See
https://help.libreoffice.org/Writer/Calculating
On 09/16/2015 04:02 PM, Li Wei wrote:
> I want sum of a column of values
> I enter "SUM(N1:N8)" in cell N9
> but can't get cell N9 to display sum
>
> Thanks in advance!!!
>
> PS: I'm in China and can't use google to find answer
>
>
Wouldn't that be "=SUM(N1:N8)" instead, with an equal sign?
Re
16 matches
Mail list logo
