# Calc Copy column of formulas and paste into word proccessor

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 close merge delete

Sort by » oldest newest most voted

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

more

I really wish someone would give a proper answer. A proper solution. In excel I am able to "show formula" COPY those FORMULAS (not values, not what comes after the math... THE FORMULA)... And I can then copy those formulas to a notepad where, when pasted... it shows all those pretty, pretty FORMULAS. Is there a way to do this? When I try to do so on LibreOffice, only the values (NO FORMULA) are pasted. Edit: addition words after latest post See what I mean? The PROPER answer for you to have given is "your \$hit out of luck, Libreoffice can't do that. Go back to excel."

more