-i-and-j-case-sensitive-in-column-formulas
Last Update: 5/16/2019
From Origin 2017, workbook supports Spreadsheet Cell Notation (SCN). With it, you can use column Short Name to refer to that column in the column formulas, which makes it a simpler, easier-to-read syntax In most cases, the column Short Name is not case sensitive. For example, if you enter lowercase letter "a" in the column formula, it will be considered as column A and converted to capital letter "A" automatically. However, the lowercase letter "i" and "j" are pre-defined variables in column formula, referring to row index and column index respectively. If you want to refer to column I and J, you must use capital letters.
Keywords:Set Column Value, column function, column equation, cell formula, col(I), col(J)