LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 06-08-2012, 10:29 PM   #1
Adwat
LQ Newbie
 
Registered: May 2012
Posts: 14

Rep: Reputation: Disabled
Absolute value of a column in Libreoffice calc


Hi,
I'm using Libreoffice calc. Can someone help me with calculating the absolute value of an entire column. Is there a command for that. I don't really want to do it for each element as the # of elements are huge.
Thanks!
 
Old 06-09-2012, 04:58 PM   #2
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian Squeeze
Posts: 5,805

Rep: Reputation: 324Reputation: 324Reputation: 324Reputation: 324
It's fairly simple to do. Assume a column of 100 elements. In cell A101, use the Sum() function to sum the first 100 elements. In cell A102, use the formula =ABS(A101) to return the absolute value of the sum in cell A101.
 
Old 06-09-2012, 05:00 PM   #3
Adwat
LQ Newbie
 
Registered: May 2012
Posts: 14

Original Poster
Rep: Reputation: Disabled
Hi,
Thanks for your reply.
However I do not want the absolute value of the sum of the elements of a column.
I want the absolute value of each and every element of the column. And paste it into the adjacent column.

Thanks!

Best,
Adwait

Quote:
Originally Posted by bigrigdriver View Post
It's fairly simple to do. Assume a column of 100 elements. In cell A101, use the Sum() function to sum the first 100 elements. In cell A102, use the formula =ABS(A101) to return the absolute value of the sum in cell A101.
 
Old 06-09-2012, 05:13 PM   #4
bigrigdriver
LQ Addict
 
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian Squeeze
Posts: 5,805

Rep: Reputation: 324Reputation: 324Reputation: 324Reputation: 324
Assume the 100 elements I mentioned are in column A. Then, in column B, proceed as follows:
In B1, add the formula =ABS(A1)
In B2, add the formula =ABS(A2)
In B3, add the formula =ABS(A3)

Then select the three cells B1:B3

Grab the bottom right corner and drag it to the bottom of the column at B100. The formulas should progress in numerical order to =ABS(A100).

I know it isn't what you want, but it's all I know.

Last edited by bigrigdriver; 06-09-2012 at 05:14 PM.
 
  


Reply

Tags
libreoffice


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
[SOLVED] path to libreoffice writer and calc Xubuntu 12.04 keyboard shortcut ubume2 Ubuntu 0 05-18-2012 09:20 AM
Libreoffice Calc - Hyperlink Problems Myrlin Linux - Desktop 6 11-04-2011 07:16 AM
[SOLVED] How to "link" one column to another in OpenOffice Calc resetreset Linux - Software 2 07-28-2011 10:52 AM
protect/lock a cell in libreoffice calc knobby67 Linux - Software 4 07-14-2011 05:29 PM
Import fixed-width column text document in OpenOffice.org Calc Marel Linux - Desktop 3 05-05-2008 04:23 PM


All times are GMT -5. The time now is 09:02 AM.

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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration