How to display the list of formulae in a Numbers spreadsheet

Thanks Yellowbox. That is an answer that fits the question.

So it was not hidden somewhere, but removed. Or, as you say, “lost”.

Not the time or place here to mention other feautures or outright bugs.

Thanks again,

Robert.

The link in your first suggestion leads to “page not found”.

The second suggestion has nothing to do with the question.

Can I or can I not display the list of all formulae used, or can I not? If so, how?

Please read the question:

In Numbers'09 it was possible to display the list of all the formulae used in a sheet.

How is this done now?

Can I or can I not display the list of all formulae used, or can I not? If so, how?

Numbers'09 had this view option?

Where is the equivalent, if it exists?

Thanks SGIII,

It looks like what I want.

However, a quick search tells me it's a thing available under Monterey only.

I'm not going there, and I'm not ever going on any cloud (except my own).

It is possible to get the formulae from an AppleScript, but that is inordinately slow.

So, effectively, it's a feature that, for me, is gone.

Best,

Robert.

(and if anyone can tell me how I can set the date-time format in this forum to something non-US, I'd be grateful too, because I could not find that either).

Hi SGIII:

We are actually in agreement.

For keyboard shortcuts I've been using Keyboard Maestro for many years, and some of my shortcuts do have applescripts behind them.

I'm not at all opposed to automator or applescript or anything else. However, I do need to limit the number of different things I use, because each will need some maintenance, and some are too slow.

I'm using Numbers 11.2 on Big Sur. But it's not important.

Generally I'm more into generating documents than into consuming. The eye-candy of information display is of little use to me. Rather, I want to be productive, so as to spend as little time as possible in front of a screen. If an operation can be done from the keyboard, I certainly prefer that to any other interaction.

And yes, Numbers has progressed in what it can do (my spreadsheet history started with Microsoft Multiplan on a 1984 Macintosh with 128k bytes of memory and a single disquette).

But the human interface to Numbers has regressed: inspectors have gone, things got “big”, to accommodate the finger-interface of touch screens, formula editing has become a pain (except maybe for beginners) and so on. So it's not the core I'm having an issue with, but the productivity of the interface.

I could probably write a book akin to “The Humane Interface” of Jef Raskin (https://en.wikipedia.org/wiki/The_Humane_Interface). Just to mention one irritating recent drift: in many applications I can no longer just hit command-D when I do not want to save a document, and the worst thing is that it has become different for different applications. It seems the whole idea of the “Interface Guidelines” has disappeared.

Thanks and have fun,

Robert.

PS: this is a photo of the world's first working touch screen prototype, built in 1973 at CERN, and it happens to be in my possession. It is the same technology now used in smartphones and tablets:

And yet another bug:

This is the advanced setting in my system preferences for how to treat currencies:

i.e. a dot for decimal separation.

Now, in Numbers: in a cell with automatic format:

(1) when I type 8€ it produces €8,00 i.e. it uses a comma and it puts the € in front, therefore does not consider what I typed as text, and indeed aligns it right. (I dislike currency symbols in front, but I do know why that is the custom)

(2) but then I added a comment by putting "(Carroz)" after it, and that was interpreted as text, removed the decimals and aligned left!

(3) taking the comment away again made it into a currency.

(4) if now in another cell I type a formula like 2*D12 (where D12 is the automatic cell containing the "€8,00") then that cell immediately gets €16,00 (with the unwanted comma)

This would all be fine, as long as I can switch these half-witted interventions OFF.

Can I? If so where?

(no need to answer, unless you really do know where to switch it all OFF. I'm writing a critique of Numbers and will post it on my site sometime)