I wrote a bit about the evolution of cell references in the spreadsheet formula language https://bean.nilenso.com/blog/posts/relative-references/