LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Desktop
User Name
Password
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.

Notices


Reply
  Search this Thread
Old 11-21-2007, 01:39 PM   #1
Zaskar
Member
 
Registered: Feb 2004
Location: NY
Distribution: Debian (Testing)
Posts: 219

Rep: Reputation: 30
Open Office Calc question


I have a question about Open Office Calc.

Whenever I try to do any math in there its as if the numbers aren't treated as values. like lets say in A1 I have 2 and in A2 I have 3, then in A3 I put =A1+A2 it will display 23, like it concatenated them instead. And if I replace "+" with any other math symbol like * or / it will just display 'True" or "False"

How do I get it to handle the numbers in a way that will let me Add/Subtract/Multiply/Divide?

Thanks guys.
 
Old 11-21-2007, 01:45 PM   #2
pljvaldez
LQ Guru
 
Registered: Dec 2005
Location: Somewhere on the String
Distribution: Debian Wheezy (x86)
Posts: 6,094

Rep: Reputation: 272Reputation: 272Reputation: 272
Make sure the cells are formatted as "number", not "text" or some other type of data.
 
Old 11-21-2007, 01:51 PM   #3
Zaskar
Member
 
Registered: Feb 2004
Location: NY
Distribution: Debian (Testing)
Posts: 219

Original Poster
Rep: Reputation: 30
Quote:
Originally Posted by pljvaldez View Post
Make sure the cells are formatted as "number", not "text" or some other type of data.
Right now their set as Number, and then General. And that is what its producing :/
 
Old 11-21-2007, 03:03 PM   #4
forrestt
Senior Member
 
Registered: Mar 2004
Location: Cary, NC, USA
Distribution: Fedora, Kubuntu, RedHat, CentOS, SuSe
Posts: 1,288

Rep: Reputation: 99
I can't get it to perform like you are describing at all. If I format cells like numbers, I get 2,3,5. If I format them as text I get 2,3,=a1+a2. If I just format the first two as text I get 2,3,5. If I just format the last one as text I get 2,3,=a1+a2. I'm running OO.o 2.3.0-6.6

HTH

Forrest
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Office shootout: OpenOffice.org Calc vs. Microsoft Excel LXer Syndicated Linux News 0 10-11-2007 06:40 PM
Open Office question trackrat General 3 03-28-2007 07:14 AM
elapsed time formula for open office calc philosophe Linux - Software 1 03-30-2005 06:32 AM
Question about open office lellyville Linux - Software 6 03-06-2005 12:38 AM
Open Office Question jsin Red Hat 1 11-01-2003 10:09 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Desktop

All times are GMT -5. The time now is 10:40 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration