Results 1 to 3 of 3

Thread: LibreOffice - Paste Special, Values?

  1. #1
    Join Date
    Feb 2008
    Location
    Cornwall, UK
    Beans
    124
    Distro
    Ubuntu 12.04 Precise Pangolin

    LibreOffice - Paste Special, Values?

    In Excel there is a feature - Paste Special, Values. This appears to be missing from LibreOffice. Is the feature buried elsewhere, perhaps under a different name?

    I'm simply trying to paste the results of a formula elsewhere.

    I'm using LibreOffice 3.5.4.2 on Ubuntu 12.04 (Precise)

  2. #2
    Join Date
    Jan 2012
    Location
    US-PA
    Beans
    97
    Distro
    Kubuntu Development Release

    Re: LibreOffice - Paste Special, Values?

    If I do a Paste Special (Ctrl+Shift+V) and only select Numbers, it works for me when pasting numeric values.

    Similarly, I can select Numbers and Text to paste special mixed numeric and text values.

    I am running Libre Office Version 3.6.2.2 (Build ID: 360m1(Build:2)) on a Kubuntu Daily build.

  3. #3
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    8,853
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: LibreOffice - Paste Special, Values?

    You can also uncheck the forumulas box when using Paste Special and leave the rest alone.

    I think this is one of the clunkiest aspects of Libre/OpenOffice Calc.
    If you ask for help, please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •