On 2024-12-02, Ian McCall <[email protected]> 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)

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)

On 2. Dec 2024 at 12:19:49 CET, "Ian McCall" <[email protected]> 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)

On 4 Dec 2024, Bernd Froehlich wrote
(in article <[email protected]>):

On 2. Dec 2024 at 12:19:49 CET, "Ian McCall"<[email protected]> 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)

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)

On 2 Dec 2024, Ian McCall wrote
(in article<[email protected]>):

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)

On 15 Jan 2025 at 15:27:20 GMT, "Ian McCall" <[email protected]> wrote:

On 2 Dec 2024, Ian McCall wrote
(in article<[email protected]>):

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)

On 17 Jan 2025 at 08:34:25 GMT, John Hill wrote:

On 15 Jan 2025 at 15:27:20 GMT, "Ian McCall" <[email protected]> wrote:

On 2 Dec 2024, Ian McCall wrote
(in article<[email protected]>):

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)