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!

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.

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

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.

SUMPRODUCT(ABS( range ))
 

For the benefit of future Googlers, you can use

SUMPRODUCT(ABS(A1:A100))

to do this.

For the actual benefit of future googlers, the above reply is not what OP was asking.

They were asking for a way to take the absolute value of a range of numbers.

The ABS function is single valued, so you have to make a column.
A fairly fast way to do this is in the B1 cell put ABS(A1) at the beginning of the column,
then copy paste or copy-"drag the corner"-paste into the range you want it.

Calc is not smart enough to create a column.