It would be a great time saver if there was a translation function that worked like a reference function. Especially if you work internationally and have to enter 2 languages in e.g. a list to make it easier to understand, this function would be very practical, because you would have to enter it once and then you could transfer it to the other cells.
For example: column A is German and column B should contain the corresponding English translations. Instead of having to translate everything manually, a function would be simpler here, which would transfer the following information: If A1 says "Pferd", then give me "Horse" in English in B1.
I hope I could explain my idea well

Please improve the ASC and JIS functions so that:
they can apply to:
- only romajis,
- only katakanas,
- both of them
For instance, this could be like:
- ASC(Text,-1) / JIS(Text, -1) would apply only to romajis
- ASC(Text,1) / JIS(Text,1) would apply to katakanas only
- ASC(Text,0) / ASC(Text) / JIS(Text,0) / JIS(Text) would apply to both, just as the present versions.

This would be very helpful for a variety of usages.
The main usage would be to force romajis to single-byte while forcing kanas to double-byte.
In fact, in many cases, ones would prefer transform only romajis (as double-byte romajis take really too much place on display) but would like to keep double-byte kanas as they are much more readable.
Especially interesting for accounting applications. i.e. to homogenize text data coming from various banks/card companies when importing into accounting apps.

Please improve the ASC and JIS functions to that:
they can apply to:
- only romajis,
- only katakanas,
- both of them
For instance, this could be like:
- ASC(Text,-1) / JIS(Text, -1) would apply only to romajis
- ASC(Text,1) / JIS(Text,1) would apply to katakanas only
- ASC(Text,0) / ASC(Text) / JIS(Text,0) / JIS(Text) would apply to both, just as the present versions.

This would be very helpful for a variety of usages.
The main usage would be to force romajis to single-byte while forcing kanas to double-byte.
In fact, in many cases, ones would prefer transform only romajis (as double-byte romajis take really too much place) but would like to keep double-byte kanas as they are much more readable.
Especially interesting for accounting applications. i.e. to homogenize text data coming from various banks/card companies when importing into accounting apps.

I'm on a Mac OS10.14.6 using Excel v16.34. Neither the Enter nor Return nor Tab key will auto-select the Done button to finalize a created formula and then bring me to the next cell over or down.

I've hesitated to move from Excel 2011 because I'm able to, for instance, put my cursor in a cell, double-click SUM in the function dialog box (which I keep open in the window), drag/select the range of cells I want to add, then hit the Tab button to finalize the formula and move me to the cell to the right, to then use the COUNT function, using the same technique.

I've checked this feature numerous times in the 365 version of Excel over the past several years, but it has never worked. When you have dozens of these tasks to complete those keystrokes matter.

The attached picture shows the cells selected, but the "Done" button in the function dialog needs to be clicked with the mouse.

It would be amazing if you could implement a function that allows you to set a temporary variable to use within a formula! Something like the syntax used in OpenRefine's "with()" control (borrowing their syntax for my example - link to their wiki below).

Syntax:
WITH( [Function A], [Variable Name: string], [Function B] )

[Function A] would get evaluated first, and then the result could be referenced within [Function B] using the [Variable Name] string (essentially as if it was a named range). With this you can reuse a value in a formula multiple times without needing to repeat the function.

This would:
- eliminate (or at least reduce) the need to create helper cells / columns
- reduce the need to write long, messy, complicated formulas that repeat the same function calculations
- lower the amount of overhead when parsing formulas

Here's an example. This is using a pretty simple formula just that returns a status string output. Granted, theres a bunch of ways to do this, but just for illustration:

Current possible method 1 - repeating formula:

target cell:
=IF(A4="OUT","excluded in "&IF(ISERROR(MATCH(B4,Sheet2!$C:$C,0)),"both","list A but included in list B (!)"),IF(ISERROR(MATCH(B4,Sheet2!$C:$C,0)),"included in list A but excluded from list B (!)",""))

Current possible method 2 - helper cell:

helper cell (C4):
=ISERROR(MATCH(B4,Sheet2!$C:$C,0))
target cell:
=IF(A4="OUT","excluded in "&IF(C4,"both","list A but included in list B (!)"),IF(C4,"included in list A but excluded from list B (!)",""))

Proposed method - using "with" function:

=WITH(IF(A4="OUT","ex","in"),"var1",WITH(IF(ISERROR(MATCH(B4,Sheet2!$C:$C,0)),"ex","in"),"var2",IF(var1=var2,IF(var1="ex","excluded in both",""),var1&"cluded in list A but "&var2&"cluded in list B (!)")))

https://github.com/OpenRefine/OpenRefine/wiki/GREL-Controls#withexpression-o-variable-v-expression-e