Spreadsheet people please come in!

Status
Not open for further replies.

iGas

Diamond Member
Feb 7, 2009
6,240
1
0
=SUM(D1:D26)

Did I get that right in Openoffice Cal? Oddly enough the result is 0 using Debian package 1:3.2.1-6

I want the total sum from D column cell 1 to D column cell 26.

Thanks
 

AnonymouseUser

Diamond Member
May 14, 2003
9,943
107
106
=SUM(D1:D26)

Did I get that right in Openoffice Cal? Oddly enough the result is 0 using Debian package 1:3.2.1-6

I want the total sum from D column cell 1 to D column cell 26.

Thanks

Just checked in oocalc 3.2.09 and yes, it works as intended.
 

Numenorean

Diamond Member
Oct 26, 2008
4,442
1
0
=SUM(D1:D26)

Did I get that right in Openoffice Cal? Oddly enough the result is 0 using Debian package 1:3.2.1-6

I want the total sum from D column cell 1 to D column cell 26.

Thanks

I get 0 as well when I sum D1 : D26. What's the problem?
 

iGas

Diamond Member
Feb 7, 2009
6,240
1
0
I get 0 as well when I sum D1 : D26. What's the problem?
Was checking to see if I screwed up or was it OO, and it turn out that OO Cal doesn't work as intended.

PS. I was trying to sum my CC statement to see where the $1878.96 went.
 

Anubis

No Lifer
Aug 31, 2001
78,712
427
126
tbqhwy.com
=SUM(D1:D26)

Did I get that right in Openoffice Cal? Oddly enough the result is 0 using Debian package 1:3.2.1-6

I want the total sum from D column cell 1 to D column cell 26.

Thanks

i see the issue, there is a :D in the middle of your equation
 

iGas

Diamond Member
Feb 7, 2009
6,240
1
0
i see the issue, there is a :D in the middle of your equation
haha

So far SUM function doesn't work for me with OpenOffice, LibreOffice, and Gnumeric under Linux Mint Debian Edition, however it worked in Google Doc spreadsheet online.
 

PsiStar

Golden Member
Dec 21, 2005
1,184
0
76
haha

So far SUM function doesn't work for me with OpenOffice, LibreOffice, and Gnumeric under Linux Mint Debian Edition, however it worked in Google Doc spreadsheet online.
you have a malware ... or some other crap thing, but I am just the suspicious sort. When it works elsewhere, for others, but not on my machine, I start running CCleaner, Ad-Aware, and/or any other friggin' thing I have that looks for crap.
 

iGas

Diamond Member
Feb 7, 2009
6,240
1
0
you have a malware ... or some other crap thing, but I am just the suspicious sort. When it works elsewhere, for others, but not on my machine, I start running CCleaner, Ad-Aware, and/or any other friggin' thing I have that looks for crap.
Unlikely but it could be a bug. I'm using Linux Mint Debian Edition.
 

iGas

Diamond Member
Feb 7, 2009
6,240
1
0
I pin point the problem to Linux Mint as the culprit.

Google Doc spreadsheet work on line, so as Openoffice and Libre Office under Windows 7.
 
Status
Not open for further replies.