LibreOffice Calc - Switch to Excel R1C1 formula syntax

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.
Published by jad05. Latest update on April 7, 2012 at 09:49 AM by jad05.
This document, titled "LibreOffice Calc - Switch to Excel R1C1 formula syntax ," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
LibreOffice Calc - Display helplines while moving objects
LibreOffice Calc - Hide the comment indicatior