The R1C1 Converter Add-on for Google Sheets™ simplifies working with R1C1 formulas by automatically or manually converting them to A1 notation, ensuring compatibility and accuracy in your spreadsheets. Key features include:

Automatic Conversion: Detects and converts R1C1 formulas to A1 notation when you edit or paste cells, including those displaying errors like #NAME? or #REF!.
Manual Conversion: Use the custom "R1C1 Converter" menu to convert formulas in a single cell or a selected range with one click.
Error Detection: Identifies and processes R1C1 formulas in cells showing errors, ensuring reliable conversions.
Formula Storage: Stores original R1C1 formulas in your spreadsheet’s document properties, allowing you to view them later via the "Show Original R1C1 Formulas" feature.
User-Friendly Feedback: Displays toast notifications to confirm conversions or report issues, keeping you informed.
Clear Memory Option: Easily clear stored R1C1 formulas for a specific sheet through an intuitive dialog interface.
Whether you're copying R1C1 formulas from external sources or working with complex spreadsheets, this Add-on streamlines the process, saving time and reducing errors. Perfect for users who need seamless formula conversion in Google Sheets™.

Google Sheets™ is a trademark of Google LLC.