Ask Your Question
0

How can I cut and paste in the formula bar within the spreadsheet?

asked 2018-05-23 14:20:13 +0100

bjm1950 gravatar image

How can I cut and paste in the formula bar within the spreadsheet? This is handy for editing for formulae. It does not work with a mouse or Cntl C and Cntl V

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2018-05-23 16:20:59 +0100

kompilainenn gravatar image

context menu in the formula bar will be only in LO 6.1 for me Ctrl+C and Ctrl+V works fine in Windows: 1. Select cell with formula 2. Select text in the formula bar 3. push Ctrl+C and then key Esc 4. Select another cell 5. Set cursor into the formula bar 6. Ctrl+V and Enter

edit flag offensive delete link more

Comments

Thanks I am trying to copy and paste part of a formula. The highlighted area cannot be copied from what I can see.

bjm1950 gravatar imagebjm1950 ( 2018-05-24 10:24:28 +0100 )edit

I tried copy only part of formula from formula bar. It works fine.

kompilainenn gravatar imagekompilainenn ( 2018-05-24 12:40:20 +0100 )edit
0

answered 2018-06-09 07:38:18 +0100

Xoristzatziki gravatar image

You can copy part or all of the formula only using keyboard shortcuts. No right click menu exists.

edit flag offensive delete link more

Comments

Thanks, I'll give it a bash!

bjm1950 gravatar imagebjm1950 ( 2018-06-09 14:09:43 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-23 14:20:13 +0100

Seen: 57 times

Last updated: Jun 09 '18