Spreadsheet people please come in!

[iGas]

=SUM(D1😀26)

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]

=SUM(D1😀26)

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.

 

[iGas]

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

Thanks

It look like the version I have is broken, because the formula worked in Google Doc.

 

[Numenorean]

=SUM(D1😀26)

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]

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.

 

[her209]

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

Do you have a wife or girlfriend or both?

 

[Anubis]

=SUM(D1😀26)

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 😀 in the middle of your equation

 

[iGas]

i see the issue, there is a 😀 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]

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]

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.

 

[Hacp]

Just use excel.

 

[iGas]

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.