Ask LibreOffice  RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 27 Jul 2019 16:39:23 +0200Calc "show formula"  will not paste formula to notepad, only valueshttps://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/Hello all.
In excel I am able to "show formula" 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.
Mon, 22 Jul 2019 00:55:12 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/Comment by notrandom1 for <p>Hello all.
In excel I am able to "show formula" 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.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=202435#postid202435Ugh... The easiest thing to do was purchase Microsoft on the cheap via eBay and "legit".
I'll try Libre again in 3 years. hopefully, "partial fixes" won't be a thing by then.
Half ass'n it eh?Sat, 27 Jul 2019 16:35:28 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=202435#postid202435Answer by notrandom1 for <p>Hello all.
In excel I am able to "show formula" 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.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?answer=202436#postid202436Ugh... The easiest thing to do was purchase Microsoft on the cheap via eBay and "legit".
I'll try Libre again in 3 years. hopefully, "partial fixes" won't be a thing by then.
Half ass'n it eh? Pushing away potential users eh? yea... the libre way.Sat, 27 Jul 2019 16:39:23 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?answer=202436#postid202436Answer by Schiavinatto for <p>Hello all.
In excel I am able to "show formula" 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.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?answer=201919#postid201919With the worksheet open, go to Tools / Options / LibreOffice Calc / View, under Display check Formulas. Then copy and paste.
![image description](/upfiles/1563795218409551.png)


**ATTENTION:** If you would like to give more details to your question, use **edit** in question or **add a comment** below. Thank you.
If the answer met your need, please click on the ball <img alt="Descrição da imagem" src="/upfiles/14057372472796181.jpg" style="maxwidth: 65px; height: auto;"> to the left of the answer, to finish the question.
Mon, 22 Jul 2019 13:36:10 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?answer=201919#postid201919Comment by erAck for <p>With the worksheet open, go to Tools / Options / LibreOffice Calc / View, under Display check Formulas. Then copy and paste.</p>
<p><img alt="image description" src="/upfiles/1563795218409551.png"></p>
<h2></h2>
<p><strong>ATTENTION:</strong> If you would like to give more details to your question, use <strong>edit</strong> in question or <strong>add a comment</strong> below. Thank you. </p>
<p>If the answer met your need, please click on the ball <img alt="Descrição da imagem" src="/upfiles/14057372472796181.jpg"> to the left of the answer, to finish the question. </p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201920#postid201920Did you actually try? This does *not* paste formulas to plain text.Mon, 22 Jul 2019 14:04:53 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201920#postid201920Comment by Schiavinatto for <p>With the worksheet open, go to Tools / Options / LibreOffice Calc / View, under Display check Formulas. Then copy and paste.</p>
<p><img alt="image description" src="/upfiles/1563795218409551.png"></p>
<h2></h2>
<p><strong>ATTENTION:</strong> If you would like to give more details to your question, use <strong>edit</strong> in question or <strong>add a comment</strong> below. Thank you. </p>
<p>If the answer met your need, please click on the ball <img alt="Descrição da imagem" src="/upfiles/14057372472796181.jpg"> to the left of the answer, to finish the question. </p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201924#postid201924Paste formulas yes ...
![image description](/upfiles/1563799304604196.png)Mon, 22 Jul 2019 14:42:00 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201924#postid201924Answer by gtomorrow for <p>Hello all.
In excel I am able to "show formula" 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.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?answer=201869#postid201869Copy from the formula bar instead of from the cell. Otherwise, if you need to copy a range of formulas, [do this](http://file:///Applications/LibreOffice.app/Contents/Resources/help/enUS/text/scalc/guide/formula_value.html).
Have a wonderful day.Mon, 22 Jul 2019 08:03:32 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?answer=201869#postid201869Comment by gtomorrow for <p>Copy from the formula bar instead of from the cell. Otherwise, if you need to copy a range of formulas, <a href="http://file:///Applications/LibreOffice.app/Contents/Resources/help/enUS/text/scalc/guide/formula_value.html">do this</a>.</p>
<p>Have a wonderful day.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201883#postid201883Everything's cool, Mike! Unless @notrandom1 elaborates on what is his problem (beyond Calc != Excel) instead of having [an online hissyfit](https://ask.libreoffice.org/en/question/194302/calccopycolumnofformulasandpasteintowordproccessor/?answer=201846#postid201846) I guess we'll never be sure. P.S., re: HTML help, I'm kind of going to miss the old Help system! Call me sentimental :)Mon, 22 Jul 2019 09:37:25 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201883#postid201883Comment by Mike Kaganski for <p>Copy from the formula bar instead of from the cell. Otherwise, if you need to copy a range of formulas, <a href="http://file:///Applications/LibreOffice.app/Contents/Resources/help/enUS/text/scalc/guide/formula_value.html">do this</a>.</p>
<p>Have a wonderful day.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201879#postid201879Your answer isn't wrong at all, and please excuse me if I wrote it the way it looked that way. I only meant that OP has quite specific needs  so that workarounds don't fit OP's expectations.
The help is HTML since 6.0.Mon, 22 Jul 2019 09:12:25 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201879#postid201879Comment by Mike Kaganski for <p>Copy from the formula bar instead of from the cell. Otherwise, if you need to copy a range of formulas, <a href="http://file:///Applications/LibreOffice.app/Contents/Resources/help/enUS/text/scalc/guide/formula_value.html">do this</a>.</p>
<p>Have a wonderful day.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201871#postid201871You seem to have pasted a local help url; the corresponding online url is [https://help.libreoffice.org/latest/enUS/text/scalc/guide/formula_value.html](https://help.libreoffice.org/latest/enUS/text/scalc/guide/formula_value.html). But that seems to be not what OP wants, given the ["answer" at another question](https://ask.libreoffice.org/en/question/194302/calccopycolumnofformulasandpasteintowordproccessor/#201846).Mon, 22 Jul 2019 08:09:43 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201871#postid201871Comment by gtomorrow for <p>Copy from the formula bar instead of from the cell. Otherwise, if you need to copy a range of formulas, <a href="http://file:///Applications/LibreOffice.app/Contents/Resources/help/enUS/text/scalc/guide/formula_value.html">do this</a>.</p>
<p>Have a wonderful day.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201878#postid201878So sorry, Mike. I hadn't realized that the Help file was local since it became HTML (since when?). Thanks for spotting and correcting the link. Nevertheless, there's more ways than one to skin that proverbial cat. I'm unfamiliar with how Excel operates but from what I gather there's a menu item "Show Formulas" which there isn't in LO. I tested before posting and it works. Let's just say my answer isn't wrong. Peace!Mon, 22 Jul 2019 09:05:49 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=201878#postid201878Comment by notrandom1 for <p>Copy from the formula bar instead of from the cell. Otherwise, if you need to copy a range of formulas, <a href="http://file:///Applications/LibreOffice.app/Contents/Resources/help/enUS/text/scalc/guide/formula_value.html">do this</a>.</p>
<p>Have a wonderful day.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=202039#postid202039Guys. Thanks for your input, I really appreciate the replies.
Not sure if I can elaborate any further, and I feel if I tried, it'll only confuse you more. I can only get even more simple... Within excel, just like Libre, exist the option to "SHOW FORMULA". Copy one or many cells then paste onto NOTEPAD.... It should look something like this (worked on google sheets)
***Shown Formulas are copied AS FORMULAS***
=2+4
=3*8
=5/2
Instead, when I paste I get this...
***Values (NOT WHAT IS WANTED)***
6
24
2.5
Can someone try on google sheets so you may understand the situation?
Just fill a bunch of cells with calculations/FORMULAS ( =2+3 )... then enable "SHOW FORMULA" and copy those cells.
Paste onto notepad. See all those pretty, pretty FORMULAS?Tue, 23 Jul 2019 14:22:57 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=202039#postid202039Comment by gtomorrow for <p>Copy from the formula bar instead of from the cell. Otherwise, if you need to copy a range of formulas, <a href="http://file:///Applications/LibreOffice.app/Contents/Resources/help/enUS/text/scalc/guide/formula_value.html">do this</a>.</p>
<p>Have a wonderful day.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=202067#postid202067@notrandom1 did you even try my solution? I assure you, unless there's something you're not telling us, by [changing the Preference setting to show formulas](https://help.libreoffice.org/latest/enUS/text/scalc/guide/formula_value.html), you can copy and paste the pretty, pretty FORMULAS into any other program. I tested it myself before I answered **and** just now. All I can tell you is if you buy me a ticket to wherever you are, I'll come hold your hand while you copy and paste the pretty, pretty FORMULAS. Cheers!Tue, 23 Jul 2019 18:17:43 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=202067#postid202067Comment by notrandom1 for <p>Copy from the formula bar instead of from the cell. Otherwise, if you need to copy a range of formulas, <a href="http://file:///Applications/LibreOffice.app/Contents/Resources/help/enUS/text/scalc/guide/formula_value.html">do this</a>.</p>
<p>Have a wonderful day.</p>
https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=202090#postid202090Hey! ok... that worked "for the most part" you got me, though only partially.
Here's the new problem... When copying formulas that refer to another page on the file, it pastes incorrectly.
(Copied shown formula)
=$'K. Calc'.K32
(Pasted shown formula)***(pasted onto notepad)
=$#REF!.K32
A small example of pasted formulas: (#REF! refers to another page, the same file. But is not pasted correctly)
=H13*Z3 =$#REF!.A10
=H14*Z3 =$#REF!.A18
=H15*Z3 2.75
=H16*Z3 1.00
=H17*Z3 0.25
=H19*Z3 =$#REF!.K30
=H20*Z3 =$#REF!.K31
=H21*Z3 =$#REF!.K32
Exact copies of formulas are key here. Thanks for your input everyone.Tue, 23 Jul 2019 23:29:05 +0200https://ask.libreoffice.org/en/question/201847/calcshowformulawillnotpasteformulatonotepadonlyvalues/?comment=202090#postid202090