Ask Your Question
0

[Calc v4.2.4.2] How apply an operation to all selected cells? [closed]

asked 2014-07-01 12:55:32 +0100

loostro gravatar image

updated 2015-09-02 22:37:33 +0100

Alex Kemp gravatar image

I recieved a sheet with some numeric data.

I'd like to multiply all cells by given factor. By multiply I mean, I want to edit/change all selected cells values to initial value x multiply factor.

There are thousand cells in the sheet, so editing it manually would cost me many hours of work.

Example data:

Row | A    | B    | C   
----|------|------|-----
1   | 100  | 5    | 20 
2   | 1.20 | 1    | 5.95

I'd like to select A1:C2 and multiply all values by x 1.2 (120% of initial value). Expected result would be:

Row | A    | B    | C   
----|------|------|-----
1   | 120  | 6    | 24 
2   | 1.44 | 1.20 | 7.14

Is this possible? How?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-27 10:44:43.524094

1 Answer

Sort by » oldest newest most voted
1

answered 2014-07-01 19:39:43 +0100

Regina gravatar image

Write your factor 1.2 somewhere and copy it into clipboard. Mark the whole target area, in the example A1:C2. Use Paste Specialfrom menu Edit. In part Selection check only Numbers and uncheck the others. In part Operations select Multiply. OK.

Literal values are multiplied directly. Literal text and literal boolean values are ignored. Formulas will be changed to =(<old expression>)*1.2. Formulas, which result in text, will cause an error, because text * number is not defined.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-07-01 12:55:32 +0100

Seen: 2,704 times

Last updated: Jul 01 '14