title: How to prevent Google Spreadsheets from translating function names?
body: <p>A colleague who has a French-language system, and myself (using an English language system) collaborate on a google sheet.</p>
  
  <p>When I copy this formula (in this example from B5 to B6):</p>
  
  <pre><code>=INDIRECT(SUBSTITUTE(ADDRESS(1;COLUMN();4);"1";"") &amp; ROW() - 1)
  -if(ecritures!$H5=B$1;ecritures!$K5;0)+if(ecritures!$I5=B$1;ecritures!$K5;0)
  </code></pre>
  
  <p>Upon pasting, Google Sheets changes COLUMN() to COLONNE() (which is the French word for "Column"), causing:</p>
  
  <pre><code>=INDIRECT(SUBSTITUTE(ADDRESS(1;COLONNE();4);"1";"") &amp; ROW() - 1)
  -IF(ecritures!$H6=B$1;ecritures!$K6;0)+IF(ecritures!$I6=B$1;ecritures!$K6;0)
  </code></pre>
  
  <p>This causes B6 to display: #NAME (Unknown function: 'COLONNE'.)</p>
  
  <p>Is there a way to paste a formula from one cell to another while preventing Google Sheets from trying to translate function names?</p>
  
  <p><a href="https://i.stack.imgur.com/KqbnY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KqbnY.png" alt="enter image description here"></a></p>