Get a cell formula in R1C1-style notation, in the user's language and number-formatting locale

%3CLINGO-SUB%20id%3D%22lingo-sub-2738702%22%20slang%3D%22en-US%22%3EGet%20a%20cell%20formula%20in%20R1C1-style%20notation%2C%20in%20the%20user's%20language%20and%20number-formatting%20locale%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2738702%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fjavascript%2Fapi%2Fexcel%2Fexcel.range%3Fview%3Dexcel-js-preview%23formulasLocal%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ethis%20page%3C%2FA%3E%2C%20there%20are%203%20APIs%20to%20get%20formulas%20of%20a%20cell%3A%20%60formulas%60%2C%20%60formulasLocal%60%20and%20%60formulasR1C1%60.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20realized%20that%2C%20unlike%20%60formulasLocal%60%2C%20%60formulasR1C1%60%20returns%20a%20formula%20in%20English%20and%20English's%20number-formatting.%20Does%20anyone%20know%20if%20it%20is%20possible%20to%20get%20a%20formula%20in%26nbsp%3BR1C1-style%20notation%2C%20in%20the%20user's%20language%20and%20number-formatting%20locale%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2738702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hello,

 

From this page, there are 3 APIs to get formulas of a cell: `formulas`, `formulasLocal` and `formulasR1C1`.

 

I just realized that, unlike `formulasLocal`, `formulasR1C1` returns a formula in English and English's number-formatting. Does anyone know if it is possible to get a formula in R1C1-style notation, in the user's language and number-formatting locale?

 

Thank you

0 Replies