cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

add formulaLocal and formulaR1C1 properties to NamedItem object

add formulaLocal and formulaR1C1 properties to NamedItem object
0

Upvotes

Upvote
 Jan 10 2024
0 Comments 
New

Currently, the NamedItem formula property returns (and accepts) a localized formula. This is bad for portability, as code containing literal formula strings need to be localized.

I suggest to make sure the NamedItem object behaves the same as the Range object, which has these properties:

 

formulas

formulasLocal

formulasR1C1

 

Comment
Similar Ideas
No similar ideas