# How to copy/paste values (instead of formula) in Spreadsheet (Desktop, not Android) **URL:** \ **Category:** Calc\ **Created:** [January 6, 2022, 1:45pm UTC](https://forum.collaboraonline.com/t/how-to-copy-paste-values-instead-of-formula-in-spreadsheet-desktop-not-android/797 "2022-01-06T13:45:31Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![collahund](https://avatars.discourse-cdn.com/v4/letter/c/f05b48/32.png) [@collahund](https://forum.collaboraonline.com/u/collahund)\ **Post date:** [January 6, 2022, 1:45pm UTC](https://forum.collaboraonline.com/t/how-to-copy-paste-values-instead-of-formula-in-spreadsheet-desktop-not-android/797/1 "2022-01-06T13:45:31Z")
In my use-case, if I copy & paste a cell, I want to copy/paste the value, but what I get is the function/formula. Let’s say the function is “=B2_H2" and the value is “15”, then I want to copy the 15 to paste it into some other cell or software, but what I get is "=B2_H2”. How can I fix this? ---
**Author:** ![pedro.silva](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.collaboraonline.com/pedro.silva/32/4_2.png) [@pedro.silva](https://forum.collaboraonline.com/u/pedro.silva)\ **Post date:** [January 14, 2022, 11:18am UTC](https://forum.collaboraonline.com/t/how-to-copy-paste-values-instead-of-formula-in-spreadsheet-desktop-not-android/797/2 "2022-01-14T11:18:04Z")
Hi @collahund you probably want to trigger the paste special (by pressing `insert` key on your keyboard): ![image](https://europe1.discourse-cdn.com/flex013/uploads/collaboraonline/original/1X/af6e915b5ff6a7abe64c6e0f0c837b09bf8bab01.png) ---
**Author:** ![collahund](https://avatars.discourse-cdn.com/v4/letter/c/f05b48/32.png) [@collahund](https://forum.collaboraonline.com/u/collahund)\ **Post date:** [January 15, 2022, 3:00pm UTC](https://forum.collaboraonline.com/t/how-to-copy-paste-values-instead-of-formula-in-spreadsheet-desktop-not-android/797/3 "2022-01-15T15:00:15Z")
Thank you for this hint. It helps. However, most of the keyboards we use don’t have an insert key. I figured out that one can press Ctrl-Alt-Shift-V to trigger the same. But then an overlay appears saying: “your browser has very limited access to the clipboard - please press now Ctrl-V for more options”. If I press Ctrl-V the paste special window finally opens. Although technically a solution to (part of) my problem, this is extremely impractical during actual work. Do you know of a way to solve this “limited access to the clipboard”-problem? The main problem I have, however, is that I need to paste values _from_ Collabora into _different applications_. And there your solution does not work. Also using the Windows standard Ctrl-Shift-V (to paste unformatted text) does not work. I always get the formula instead of the values. Can you think of a way to solve these two issues? ---
**Author:** ![collahund](https://avatars.discourse-cdn.com/v4/letter/c/f05b48/32.png) [@collahund](https://forum.collaboraonline.com/u/collahund)\ **Post date:** [January 27, 2022, 12:11pm UTC](https://forum.collaboraonline.com/t/how-to-copy-paste-values-instead-of-formula-in-spreadsheet-desktop-not-android/797/4 "2022-01-27T12:11:58Z")
Hey @pedro.silva maybe I’m going at this in some untypical way? Were you able to reproduce my issue, mainly the second one? ---
**Author:** ![pedro.silva](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.collaboraonline.com/pedro.silva/32/4_2.png) [@pedro.silva](https://forum.collaboraonline.com/u/pedro.silva)\ **Post date:** [June 27, 2024, 8:57am UTC](https://forum.collaboraonline.com/t/how-to-copy-paste-values-instead-of-formula-in-spreadsheet-desktop-not-android/797/5 "2024-06-27T08:57:50Z")
> The main problem I have, however, is that I need to paste values _from_ Collabora into _different applications_. And there your solution does not work. Also using the Windows standard Ctrl-Shift-V (to paste unformatted text) does not work. I always get the formula instead of the values. Hello @collahund, the copy paste user flow has been improved and we are not in the CODE 24.04. I was not able to reproduce what you described. Meaning, I was able to copy cells (example `=ISOWEEKNUM(B1)` […]) and paste it outside of Collabora Online (text editors but more importantly in other spreadsheet programs) by simply using the ctrl + c and then ctrl + v. However, the clipboard popup appears when the selected content is large. In that case you can press again ctrl + c to confirm that you really want to copy it locally (download them). ---
**Author:** ![pedro.silva](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.collaboraonline.com/pedro.silva/32/4_2.png) [@pedro.silva](https://forum.collaboraonline.com/u/pedro.silva)\ **Post date:** [June 27, 2024, 8:58am UTC](https://forum.collaboraonline.com/t/how-to-copy-paste-values-instead-of-formula-in-spreadsheet-desktop-not-android/797/6 "2024-06-27T08:58:36Z")
---
**Author:** ![darshan](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.collaboraonline.com/darshan/32/2230_2.png) [@darshan](https://forum.collaboraonline.com/u/darshan)\ **Post date:** [August 6, 2024, 12:51pm UTC](https://forum.collaboraonline.com/t/how-to-copy-paste-values-instead-of-formula-in-spreadsheet-desktop-not-android/797/7 "2024-08-06T12:51:56Z")