Same formula for 500 columns

Comments

1 comment

  • Konsta Danyliuk

    Hello Umasankar.
    The easiest way to introduce the same formula to 500 columns is to:

    1. Build the Workbook until the Sheet where you want to introduce the formula to 500 columns.
    2. Add the desired formula to the 1st column.
    3. Download Workbooks JSON definition via REST API.
    4. Use a convenient text editor to duplicate the formula required number of times. You might want to put together a short script that helps you.
    5. Upload the Workbook back to Datameer via REST API.

    I hope this approach helps you to proceed further with your use-case.

    0
    Comment actions Permalink

Please sign in to leave a comment.