How to remove @-operator warning in Numbers app after version 14.4 update?

Question

Level 1

4 points

How to remove @-operator warning in Numbers app after version 14.4 update?

Hello,

after the update to version 14.4 I now get a warning (blue triangle) for all the cells that Numbers added the new @-operator in order for the functions to work as intended before the update.

While I appreciate it that Numbers is letting me know it has changed something, it is kind of annoying that I get those blue triangles again every time I open the file.

Might this happen because I collaborate with somebody else on this project who probably has not the current version of Numbers?

Could somebody please help?

[Re-Titled by Moderator]

Posted on Apr 6, 2025 4:38 AM

Reply

Answer 1

Top-ranking reply

MBR-Berlin Author

Level 1

4 points

Apr 6, 2025 11:44 AM in response to SGIII

It is exactly the same just with an @ in the front!

old formula: INDIRECT(CONCAT($B$1,"::",REFERENCE.NAME(AB22,cell,A1)),A1)

new formula @INDIRECT(CONCAT($B$1,"::",REFERENCE.NAME(AB22,cell,A1)),A1)

but thats not the problem I'm having! I just want to get rid of the warning that just informs me that the formula has been changed according to the new rules of Numbers 14.4 ....

But I just removed the other participant in the project and the blue triangles stay away after reopening the document. So problem solved. As soon as I get hold of them I'll ask them to update their Numbers.

Reply

Answer 2

SGIII

Level 8

37,550 points

Apr 9, 2025 6:32 PM in response to MBR-Berlin

MBR-Berlin wrote:

I don't care if there has to be an @ now I just want to get rid of the blue triangles

Click on one of the triangles and you should see an option to clear them all.

SG

Reply

Answer 3

SGIII

Level 8

37,550 points

Apr 6, 2025 10:11 AM in response to MBR-Berlin

What are the formulas where you see the @?

Screenshot?

SG

Reply

Answer 4

MBR-Berlin Author

Level 1

4 points

Apr 6, 2025 11:14 AM in response to SGIII

Hi SG,

the @ was added in front of every INDIRECT function. Apparently @ is the new explicit intersection operator. Although I only reference single cells it was put in front of every INDIRECT function I use. And in this project I used it a lot and it would take a lot of work to delete all the @s. But it seems to work as intended with the @s, so thats not the problem. I just want to get rid of the blue warning triangles...

Here's one example of the warning message:

This formula produces multiple results in newer versions of Numbers. It has been modified using the “@“ operator to return the intersection of its cell references instead. Original formula: INDIRECT(CONCAT($B$1,"::",REFERENCE.NAME(AB22,cell,A1)),A1)

I don't care if there has to be an @ now I just want to get rid of the blue triangles, wich seem to reappear every time I open the file again.

Reply