Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 23 Jul 2019 02:24:35 +0200Calc Copy column of formulas and paste into word proccessorhttps://ask.libreoffice.org/en/question/194302/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.Fri, 17 May 2019 23:52:16 +0200https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/Answer by karolus for <p>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.</p>
https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?answer=194303#post-id-194303Put in B1 the formula **`=FORMULA(A1)`** pull down to B10 and c&p this into Notepad++Sat, 18 May 2019 01:02:44 +0200https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?answer=194303#post-id-194303Answer by lazarus477 for <p>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.</p>
https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?answer=201853#post-id-201853What is wrong with the answer that **karolus**, gave? Does it not solve your problem?Mon, 22 Jul 2019 01:21:12 +0200https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?answer=201853#post-id-201853Answer by notrandom1 for <p>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.</p>
https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?answer=201846#post-id-201846I 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."Mon, 22 Jul 2019 00:50:00 +0200https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?answer=201846#post-id-201846Comment by Mike Kaganski for <p>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.
<strong><em>Edit: addition words after latest post</em></strong>
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."</p>
https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?comment=201860#post-id-201860Should 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](https://wiki.documentfoundation.org/Ask/Getting_Started), 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](https://bugs.documentfoundation.org) for that, not declare correct answer here "improper" using "Answer" tool where it's wrong)"?Mon, 22 Jul 2019 03:11:45 +0200https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?comment=201860#post-id-201860Comment by lazarus477 for <p>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.
<strong><em>Edit: addition words after latest post</em></strong>
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."</p>
https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?comment=201971#post-id-201971I 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?Tue, 23 Jul 2019 02:24:35 +0200https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?comment=201971#post-id-201971Answer by lazarus477 for <p>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.</p>
https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?answer=201970#post-id-201970I 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?Tue, 23 Jul 2019 02:20:35 +0200https://ask.libreoffice.org/en/question/194302/calc-copy-column-of-formulas-and-paste-into-word-proccessor/?answer=201970#post-id-201970