Copying Cells 2

[dik]

I've accidentally set a 'switch'. I'm using the Libreoffice Program (Excel workalike). When I copy cells, it is copying the value of the cell and not the formula for the cell and updating the data.

The 6154 should be 6190 and not the value from the previous Saturday. In addition the 2024-03-16 should be 2024-03-23. Again, not the date of the previous Saturday. Can anyone offer a suggestion? It's copying the actual cell values, not the formula values. Something like a Copy Special action.

-----*****-----
So strange to see the singularity approaching while the entire planet is rapidly turning into a hellscape. -John Coates

-Dik

 

[IDS]

Sounds like a LibreOffice thing.

Is there a Paste Special option?

What happens if you choose that?

Or is there a file property option to "always paste as values" that you might have enabled?


Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[3DDave]

Control-Shift-V is the shortcut for paste value.

Perhaps the shift button is stuck?

 

[dik]

Shift button is OK... There is a Paste Special and I can use it to past formulae... program used to default to this with <Ctrl><V>





-----*****-----
So strange to see the singularity approaching while the entire planet is rapidly turning into a hellscape. -John Coates

-Dik

 

[3DDave]

https://ask.libreoffice.org/t/how-to-make-ctrl-v-function-as-paste-unformatted-text/56239/2

 

[IDS]

I discover I don't know how to edit the keyboard shortcuts in Excel, and from a quick search I couldn't find anything that works in the latest version. The Microsoft instructions only seem to apply to Word.

Any ideas?


Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[dik]

Thanks Dave... appears to do the trick. I don't know how I 'turned it off'.

-----*****-----
So strange to see the singularity approaching while the entire planet is rapidly turning into a hellscape. -John Coates

-Dik