Media Gallery
About this addon
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.
Metrics Progress
Track how this addon's metrics have evolved over time