Howto multiply all cells in array IN PLACE (not referenced)?

[rhauff]

I'm using Gnumeric and other open-source spreadsheets.
What would be the general procedure to multiply all cells by a constant?

My array is A1:ES80 and I want to multiply all by 10. I know I can select a new area of the same size and type =A1:ES80 * 10, Ctrl-Shift-Enter. However then the new array is referenced to the original, and can't be easily saved. I would like to just multiply the original array.
Thanks!

 

[joerd]

In Excel ASAP utilities can do this for you. Otherwise, often you can replace something common to your cell entries by =10* to get what you want. Other than that, I don't see any other option than calculating as you described, then copy/paste values - assuming this exists in Gnumeric.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[rhauff]

Thanks for the reply.

I've tried all types of =10*, =A1*10, =indirect(a1)*10 and can't seem to modify the cell contents. I keep getting invalid expression, or 0 for the answer.

Copy/paste would be fine too, but the new/multiplied array is still referenced to the first. Is there a way to make static numbers?

 

[rhauff]

OK, I found the Paste-Special menu, which allows me to paste as a value (not linked) or even to multiply the source by the destination value!

Thanks for the help.