Calc "show formula" - will not paste formula to notepad, only values

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.

edit retag close merge delete

Ugh... 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?

( 2019-07-27 16:35:28 +0100 )edit

Sort by » oldest newest most voted

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

more

With the worksheet open, go to Tools / Options / LibreOffice Calc / View, under Display check Formulas. Then copy and paste.

-----------------------------------------------------------------------------

ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

more

Did you actually try? This does not paste formulas to plain text.

( 2019-07-22 14:04:53 +0100 )edit

Paste formulas yes ...

( 2019-07-22 14:42:00 +0100 )edit

Copy from the formula bar instead of from the cell. Otherwise, if you need to copy a range of formulas, do this.

Have a wonderful day.

more

You seem to have pasted a local help url; the corresponding online url is https://help.libreoffice.org/latest/en-US/text/scalc/guide/formula_value.html. But that seems to be not what OP wants, given the "answer" at another question.

( 2019-07-22 08:09:43 +0100 )edit

So 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!

( 2019-07-22 09:05:49 +0100 )edit

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

( 2019-07-22 09:12:25 +0100 )edit

Everything's cool, Mike! Unless @notrandom1 elaborates on what is his problem (beyond Calc != Excel) instead of having an online hissy-fit 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 :)

( 2019-07-22 09:37:25 +0100 )edit

Guys. 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?

( 2019-07-23 14:22:57 +0100 )edit

@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, 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!

( 2019-07-23 18:17:43 +0100 )edit

Hey! 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.

( 2019-07-23 23:29:05 +0100 )edit