Ask Your Question

Reference does not exist [closed]

asked 2018-03-18 19:49:43 +0200

Vishwa gravatar image

updated 2020-08-11 14:57:53 +0200

Alex Kemp gravatar image

Want to copy-paste output values in the same sheet in the same tab which was I using a sum formula.

image description

My problem is to add values using a sum formula. I just click on one cell and type like =b2+b29. Once typed it added the total value in b50.

Now I want to copy the value from b50 cell value and need to paste in b2. I copied but was not able to paste, because it throws the error Reference does not exist. I know two cell values should be there; then only a formula can work. But once calculated, not able to paste into any other sheet.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-11 14:58:12.192509


Screen shots don't help.

floris v gravatar imagefloris v ( 2018-03-18 20:06:57 +0200 )edit

Could you help me to find the solution which way is best for resolve this issue ?

Vishwa gravatar imageVishwa ( 2018-03-18 23:51:33 +0200 )edit

More details are needed. Show the formula of the cell pasted and the cell copied from. Tell the exact steps needed to reproduce the problem. Finally, the tags are not good. This is not about "common" components but specifically about Calc. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-03-19 15:27:59 +0200 )edit

Hi Jim,

My problem is want to add value in libreoffice using sum formula i just click on one cell and type like (=b2+b29) . once typed it added total value in b50. now i want to copy the value from b50 cell value and need to paste in b2 . when i am copied but not able to paste it s throw error Reference does not exist . i know two cell value should be there than only formula can work but once calculated not able paste any other sheet also. hope you understand. Sorry for the tag confusion.

Vishwa gravatar imageVishwa ( 2018-03-19 18:57:37 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-03-20 18:58:25 +0200

Jim K gravatar image

You cannot paste the formula =B2+B29 into cell B2 because that is a circular reference. Similarly, entering the formula =B2 into cell B2 produces an error.

However, you can paste the value only. To do this, copy from B50 and paste special Ctrl+Shift-V. Do not mark "Formulas."

edit flag offensive delete link more


Hi Jim,

Thanks lot :). My problem was resolved..

Vishwa gravatar imageVishwa ( 2018-03-20 19:12:50 +0200 )edit

Question Tools

1 follower


Asked: 2018-03-18 19:49:43 +0200

Seen: 811 times

Last updated: Mar 20 '18