Ask Your Question

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

2 Answers

Sort by » oldest newest most voted

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

answered 2019-07-22 00:50:00 +0200

notrandom1 gravatar image

updated 2019-07-22 04:15:26 +0200

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."

edit flag offensive delete link more


Should this be read as "I don't understand I'm on a site where users help users, and when something is not implemented in a program, the users give workarounds; I also declare that a "proper answer" is not what actually works, but what I imagine myself... and I don't understand that it's good to read site's use rules, to understand what's off-topic (so that I could know that if this works in the program not the way I like, I need to file an enhancement request for that, not declare correct answer here "improper" using "Answer" tool where it's wrong)"?

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-22 03:11:45 +0200 )edit

I can understand people being frustrated with the differences between MS Office and LO. But try to understand that these are two completely separate products and each work in their own respective and unique ways. If you brought a hammer but need a screwdriver then who is to blame, the tool manufacturer who produced the hammer?

lazarus477 gravatar imagelazarus477 ( 2019-07-23 02:24:35 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 105 times

Last updated: Jul 23 '19