1 Reply Latest reply on Sep 29, 2015 2:05 PM by diego.medrano

    Automated format copying

    Ethan Oppenheim

      Is there a way to call the 'Copy Formatting' function which is shown when right clicking on a given worksheet?


      My idea is to have 1 master workbook with every type of graph pre-formatted. Then use this to standardize formatting and templates across all other workbooks.


      Ideally, a script would get the unformatted workbook passed as a parameter and then go through each worksheet, identifying the graph being displayed, and apply the corresponding format from the master to that worksheet.


      Maybe there's something from the javascript API that can be leveraged?