Created attachment 157514 [details] A small Excel image showing this view Please support Excel's "Use R1C1 reference style" It's unfortunate that people aren't more familiar with this (originally implemented in Multiplan) but it's generally a much better way to understand relationships between cells than using the LetterNumber approach. E.g, RC means the current cell R[1]C means the cell at next row but same column from where you are R[-1]C[1] means the cell at the previous row and next column from where you are R[1]C2 means column2 of the next row Etc. See example image
Try Tools - Options - LibreOffice Calc - Formula and in the Formula Syntax list there is "Excel R1C1" option.
My apologies for reporting this as a feature request - it was not obvious that the feature already exists. Note that on a Mac, this option is not under the "Tools" menu, it's under "Preferences.