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
On Saturday 2009 January 17 14:20:25 Raquel wrote:
>I've upgraded from Etch to Lenny. Today I'm working on a spreadsheet
>and notice that when I copy a cell, to paste somewhere else, that
>there is a "border" put around the cell I copy.
It goes away next time you copy. It's just a visual indicat
On Sat, Jan 17, 2009 at 12:20:25 -0800, Raquel (raq...@thericehouse.net) wrote:
> I've upgraded from Etch to Lenny. Today I'm working on a spreadsheet
> and notice that when I copy a cell, to paste somewhere else, that
> there is a "border" put around the cell I copy. I go into "Format
> Cells
I've upgraded from Etch to Lenny. Today I'm working on a spreadsheet
and notice that when I copy a cell, to paste somewhere else, that
there is a "border" put around the cell I copy. I go into "Format
Cells => Borders" to try getting rid of the "border" that has been
placed around the cell. The
hi,
anyone else seeing REALLY slow printing in openoffice-calc?
If I print a selection to either printer, it pegs the cpu for 15-30
seconds. top says it soffice.bin that's doing it. once soffice.bin
frees up pages spit right out. its frustrating. I had seen this
behavior before (mayb
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Rene Engelhard wrote:
> George Borisov wrote:
> > > .oO ( Maybe I should really merge Ubuntus's split between -gtk/-gnome
> > > (which they did also for xome xfve reasons) - but fixed up.. )
> >
> > Yes please.
>
> OK.
>
> I'll look. It probabl
Hi,
George Borisov wrote:
> > .oO ( Maybe I should really merge Ubuntus's split between -gtk/-gnome
> > (which they did also for xome xfve reasons) - but fixed up.. )
>
> Yes please.
OK.
I'll look. It probably won't be in the next upload (2.0.3rc6-1), though,
but maybe afterwards.
Regards,
Re
Rene Engelhard wrote:
>
> Did you try installing openoffice.org-gnome (which contains a plugin
> for using Gtk at the UI which apparently also will do it for XFCE)?
> It'll install "some" GNOME libs, though.
Some... 8-|
> Does it help?
Yes, that did the trick, thanks. :-D
> .oO ( Maybe I shou
Hi,
George Borisov wrote:
> I've just installed OpenOffice Calc on Debian (unstable) for the first time.
>
> The problem is that the interface font used it simply huge!
>
> I am running Xfce4. I have checked my DPI settings and these are set to
> 96x96. I have also tri
Hello,
I've just installed OpenOffice Calc on Debian (unstable) for the first time.
The problem is that the interface font used it simply huge!
I am running Xfce4. I have checked my DPI settings and these are set to
96x96. I have also tried the font replacement thing suggested in
README.D
25 matches
Mail list logo
