LibreOffice Calc - Switch to Excel R1C1 formula syntax

Ask a question




To enable this option under LibreOffice Calc:
  • Launch LibreOffice select the Calc application.
  • Click on Tools > Options.
  • Go to LibreOffice Calc > Formula.
  • Use the drop menu next to "Formula syntax" to make your selection:
  • Click on OK to validate.
Jean-François Pillou

Jean-François Pillou - Founder of CCM
Better known as Jeff, Jean-François Pillou is the founder of CommentCaMarche.net. He is also CEO of CCM Benchmark and digital director at the Figaro Group.

Learn more about the CCM team