Ask Your Question
0

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

asked 2019-07-22 00:55:12 +0200

notrandom1 gravatar image

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

Comments

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?

notrandom1 gravatar imagenotrandom1 ( 2019-07-27 16:35:28 +0200 )edit

3 Answers

Sort by » oldest newest most voted
0

answered 2019-07-27 16:39:23 +0200

notrandom1 gravatar image

updated 2019-07-27 16:40:33 +0200

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.

edit flag offensive delete link more
0

answered 2019-07-22 13:36:10 +0200

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

image description

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

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 Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more

Comments

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

erAck gravatar imageerAck ( 2019-07-22 14:04:53 +0200 )edit

Paste formulas yes ...

image description

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2019-07-22 14:42:00 +0200 )edit
0

answered 2019-07-22 08:03:32 +0200

gtomorrow gravatar image

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.

edit flag offensive delete link more

Comments

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.

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-22 08:09:43 +0200 )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!

gtomorrow gravatar imagegtomorrow ( 2019-07-22 09:05:49 +0200 )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.

Mike Kaganski gravatar imageMike Kaganski ( 2019-07-22 09:12:25 +0200 )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 :)

gtomorrow gravatar imagegtomorrow ( 2019-07-22 09:37:25 +0200 )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?

notrandom1 gravatar imagenotrandom1 ( 2019-07-23 14:22:57 +0200 )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!

gtomorrow gravatar imagegtomorrow ( 2019-07-23 18:17:43 +0200 )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.

notrandom1 gravatar imagenotrandom1 ( 2019-07-23 23:29:05 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-07-22 00:55:12 +0200

Seen: 61 times

Last updated: Jul 27