1. Forum
  2. Usenet
  3. UK.COMP.SYS.MAC

  • Re: Numbers is copying values, not formulas

    From Alan B@21:1/5 to Ian McCall on Mon Dec 2 11:40:19 2024
    On 2024-12-02, Ian McCall <ian@eruvia.org> wrote:

    Odd one - I’ve not made any settings changes I’m aware of, but Numbers (v14.2) is now copying values by default, not formulas. I put the version in for completeness, but can’t swear when exactly it started happening as I rarely create sheets but mostly work with ones I create years ago. I’ve also noticed that the ‘Paste formula results’ option in the drop-down menu is greyed out, as if it didn’t know if had a choice of formula or number.

    Running 14.2 here but having none of those problems. I can copy and then paste columns, rows and individual cells containing formulae OK.

    --
    Cheers, Alan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ian McCall@21:1/5 to All on Mon Dec 2 11:19:49 2024
    Odd one - I’ve not made any settings changes I’m aware of, but Numbers (v14.2) is now copying values by default, not formulas. I put the version in for completeness, but can’t swear when exactly it started happening as I rarely create sheets but mostly work with ones I create years ago. I’ve
    also noticed that the ‘Paste formula results’ option in the drop-down
    menu is greyed out, as if it didn’t know if had a choice of formula or number.

    I definitely want it to paste formulas by default - any ideas how to achieve this and what might have happened?

    Cheers,
    Ian

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bernd Froehlich@21:1/5 to Ian McCall on Wed Dec 4 08:08:15 2024
    On 2. Dec 2024 at 12:19:49 CET, "Ian McCall" <ian@eruvia.org> wrote:

    I definitely want it to paste formulas by default - any ideas how to achieve this and what might have happened?

    Are some of the cells (or the whole sheet) protected maybe?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ian McCall@21:1/5 to Bernd Froehlich on Wed Dec 4 18:24:24 2024
    On 4 Dec 2024, Bernd Froehlich wrote
    (in article <lragvfFbu63U1@mid.individual.net>):

    On 2. Dec 2024 at 12:19:49 CET, "Ian McCall"<ian@eruvia.org> wrote:

    I definitely want it to paste formulas by default - any ideas how to achieve
    this and what might have happened?

    Are some of the cells (or the whole sheet) protected maybe?

    Hmm - don’t appear to be. It’s a relatively simple little sheet which tracks the years I’ve owned particular cars.

    So headings are:
    Manufacturer, Model, Year Owned, Final Year, Length of time owned

    That last column is the thing - I can’t just do Length of time owned =
    Final Year - Year Owned (yes, I’m rounding to years) because I still own
    the car in the last row, which means Final Year is just a ‘-‘ character.
    So I have this formula:
    =(IF(ISNUMBER(Final year<Model>), Final year <Model>, YEAR(TODAY()))−Year owned<Model>)

    ....where Model is the actual Model name. To simplify and strip away
    Numbers’ nice cell names and just call the headings A, B, C, D, E while saying for the sake of example we’re looking at row 11:
    E11’s formula: =(IF(ISNUMBER(D11), D11, YEAR(TODAY()))−C11)

    Obviously I just want to now copy that formula for all cells in E (Length of time owner). I’m finding hitting cmd-c then cmd-v is just copying the
    numeric value though, not the formula.

    Cheers,
    Ian

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bruce@21:1/5 to Ian McCall on Wed Dec 4 21:46:34 2024
    On 04/12/2024 18:24, Ian McCall wrote:
    Obviously I just want to now copy that formula for all cells in E (Length of time owner). I’m finding hitting cmd-c then cmd-v is just copying the numeric value though, not the formula.

    Shift-command-v is "paste formula results" in Numbers. Do you have any
    keyboard macro app installed that might be swapping cmd-v with
    shift-command-v?

    Alternatively are you using a non-Mac keyboard (heretic!) such as a PC
    keyboard where the command key might be mis-mapped? Or a switchable
    Bluetooth keyboard and it's switched to PC instead of Mac?

    --
    Bruce Horrocks
    Hampshire, England

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ian McCall@21:1/5 to All on Wed Jan 15 15:27:20 2025
    On 2 Dec 2024, Ian McCall wrote
    (in article<0001HW.2CFDCF55015C37F430666238F@news.individual.net>):


    Odd one - I’ve not made any settings changes I’m aware of, but Numbers (v14.2) is now copying values by default, not formulas.

    For the sake of future searchers, I’ve found the culprit.

    I have Pure Paste,<https://apps.apple.com/gb/app/pure-paste/id1611378436?mt=12>,
    installed. This is interfering (as it’s supposed to do) with the cut’n’paste feature. Adding Numbers to the ‘Exclude’ section has
    fixed the issue.

    Cheers,
    Ian

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From John Hill@21:1/5 to Ian McCall on Fri Jan 17 08:34:25 2025
    On 15 Jan 2025 at 15:27:20 GMT, "Ian McCall" <ian@eruvia.org> wrote:

    On 2 Dec 2024, Ian McCall wrote
    (in article<0001HW.2CFDCF55015C37F430666238F@news.individual.net>):


    Odd one - I’ve not made any settings changes I’m aware of, but Numbers >> (v14.2) is now copying values by default, not formulas.

    For the sake of future searchers, I’ve found the culprit.

    I have Pure Paste,<https://apps.apple.com/gb/app/pure-paste/id1611378436?mt=12>, installed. This is interfering (as it’s supposed to do) with the cut’n’paste feature. Adding Numbers to the ‘Exclude’ section has fixed the issue.

    Cheers,
    Ian

    A timely reminder. I have a situation in which I have been habitually turning Pure Paste off when pasting into Numbers.
    I have now added it to Exclude, where it sits in solitary glory.
    Thank you.

    Old John.
    --
    Lord, grant me the serenity to accept the things I cannot change,
    the courage to change the things I can,
    and the wisdom to know the difference.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From RJH@21:1/5 to John Hill on Fri Jan 17 08:58:02 2025
    On 17 Jan 2025 at 08:34:25 GMT, John Hill wrote:

    On 15 Jan 2025 at 15:27:20 GMT, "Ian McCall" <ian@eruvia.org> wrote:

    On 2 Dec 2024, Ian McCall wrote
    (in article<0001HW.2CFDCF55015C37F430666238F@news.individual.net>):


    Odd one - I’ve not made any settings changes I’m aware of, but Numbers >>> (v14.2) is now copying values by default, not formulas.

    For the sake of future searchers, I’ve found the culprit.

    I have Pure
    Paste,<https://apps.apple.com/gb/app/pure-paste/id1611378436?mt=12>,
    installed. This is interfering (as it’s supposed to do) with the
    cut’n’paste feature. Adding Numbers to the ‘Exclude’ section has
    fixed the issue.

    Cheers,
    Ian

    A timely reminder. I have a situation in which I have been habitually turning Pure Paste off when pasting into Numbers.
    I have now added it to Exclude, where it sits in solitary glory.
    Thank you.


    I've just added it as a precaution. Excel was already there - don't think that was my doing . . .


    --
    Cheers, Rob, Sheffield UK

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)