Ask Your Question
0

Calc Copy column of formulas and paste into word proccessor

asked 2019-05-17 23:52:16 +0200

Ivys-Meadow gravatar image

A1-A10 are filled with formulae. I want to copy the formula, not the values, and paste them into Notepad++, but it will only paste values, even if LibO Calc is set to display Formulae, not values.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2019-05-18 01:02:44 +0200

karolus gravatar image

Put in B1 the formula =FORMULA(A1) pull down to B10 and c&p this into Notepad++

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-17 23:52:16 +0200

Seen: 20 times

Last updated: May 18