Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 20 Mar 2018 19:12:50 +0100Reference does not existhttps://ask.libreoffice.org/en/question/149715/reference-does-not-exist/Want to copy-paste output values in the same sheet in the same tab which was I using a sum formula.
![image description](/upfiles/15213985294014094.jpg)
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.Sun, 18 Mar 2018 19:49:43 +0100https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/Comment by Jim K for <p>Want to copy-paste output values in the same sheet in the same tab which was I using a sum formula.</p>
<p><img alt="image description" src="/upfiles/15213985294014094.jpg"></p>
<p>My problem is to add values using a sum formula. I just click on one cell and type like <code>=b2+b29</code>. Once typed it added the total value in <code>b50</code>.</p>
<p>Now I want to copy the value from <code>b50</code> cell value and need to paste in <code>b2</code>. I copied but was not able to paste, because it throws the error <code>Reference does not exist</code>. 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.</p>
https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?comment=149801#post-id-149801More 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](https://ask.libreoffice.org/en/question/137128/guidelines-for-asking#138301).Mon, 19 Mar 2018 15:27:59 +0100https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?comment=149801#post-id-149801Comment by floris v for <p>Want to copy-paste output values in the same sheet in the same tab which was I using a sum formula.</p>
<p><img alt="image description" src="/upfiles/15213985294014094.jpg"></p>
<p>My problem is to add values using a sum formula. I just click on one cell and type like <code>=b2+b29</code>. Once typed it added the total value in <code>b50</code>.</p>
<p>Now I want to copy the value from <code>b50</code> cell value and need to paste in <code>b2</code>. I copied but was not able to paste, because it throws the error <code>Reference does not exist</code>. 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.</p>
https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?comment=149718#post-id-149718Screen shots don't help.Sun, 18 Mar 2018 20:06:57 +0100https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?comment=149718#post-id-149718Comment by Vishwa for <p>Want to copy-paste output values in the same sheet in the same tab which was I using a sum formula.</p>
<p><img alt="image description" src="/upfiles/15213985294014094.jpg"></p>
<p>My problem is to add values using a sum formula. I just click on one cell and type like <code>=b2+b29</code>. Once typed it added the total value in <code>b50</code>.</p>
<p>Now I want to copy the value from <code>b50</code> cell value and need to paste in <code>b2</code>. I copied but was not able to paste, because it throws the error <code>Reference does not exist</code>. 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.</p>
https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?comment=149828#post-id-149828Hi 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.Mon, 19 Mar 2018 18:57:37 +0100https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?comment=149828#post-id-149828Comment by Vishwa for <p>Want to copy-paste output values in the same sheet in the same tab which was I using a sum formula.</p>
<p><img alt="image description" src="/upfiles/15213985294014094.jpg"></p>
<p>My problem is to add values using a sum formula. I just click on one cell and type like <code>=b2+b29</code>. Once typed it added the total value in <code>b50</code>.</p>
<p>Now I want to copy the value from <code>b50</code> cell value and need to paste in <code>b2</code>. I copied but was not able to paste, because it throws the error <code>Reference does not exist</code>. 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.</p>
https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?comment=149744#post-id-149744Could you help me to find the solution which way is best for resolve this issue ?Sun, 18 Mar 2018 23:51:33 +0100https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?comment=149744#post-id-149744Answer by Jim K for <p>Want to copy-paste output values in the same sheet in the same tab which was I using a sum formula.</p>
<p><img alt="image description" src="/upfiles/15213985294014094.jpg"></p>
<p>My problem is to add values using a sum formula. I just click on one cell and type like <code>=b2+b29</code>. Once typed it added the total value in <code>b50</code>.</p>
<p>Now I want to copy the value from <code>b50</code> cell value and need to paste in <code>b2</code>. I copied but was not able to paste, because it throws the error <code>Reference does not exist</code>. 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.</p>
https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?answer=149962#post-id-149962You 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."Tue, 20 Mar 2018 18:58:25 +0100https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?answer=149962#post-id-149962Comment by Vishwa for <p>You cannot paste the formula <code>=B2+B29</code> into cell <code>B2</code> because that is a circular reference. Similarly, entering the formula <code>=B2</code> into cell <code>B2</code> produces an error.</p>
<p>However, you can paste the value only. To do this, copy from <code>B50</code> and paste special <code>Ctrl+Shift-V</code>. Do not mark "Formulas."</p>
https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?comment=149964#post-id-149964Hi Jim,
Thanks lot :). My problem was resolved..Tue, 20 Mar 2018 19:12:50 +0100https://ask.libreoffice.org/en/question/149715/reference-does-not-exist/?comment=149964#post-id-149964