Learn
No results for 'undefined'
    Powered by Algolia

    Update frames dynamically

    You can update frames dynamically using the ADD_ROW() function. When a frame is updated like that, as a result you no longer have access to the initial formula - you can only view the resulting frame.

    You can add a rows or a frame to another frame by using the ADD_ROW() function. As the first argument, use the address of the frame which you want to update, as the second argument, use the address of the rows or a frame to add, and, as the third argument, specify whether to add all the rows (true) or only the first row (false, default).

    Let's create an empty frame and update it using the ADD_ROW function.

    1. Create a range of data and turn it into a frame using the FRAME() function, like in the figure below.

    2. Create an empty frame.

    3. In an empty cell, insert the ADD_ROW() function using as the first argument the address of the cell with an empty frame. Use the frame created in step 1 (frame to insert) as the second argument.

    You can delete rows from a frame by using the DELETE_ROWS() function.

    As the first argument, specify the frame to update.

    As the second argument, insert a search expression, where you must specify the column to search in and the value.

    If the frame cell is bound to a component's property, as the third argument, you can specify whether to keep the binding (true) or not(false). Default is true.

    To delete a row at a specific row number, use the DELETE_ROW_AT() function. As the first argument, specify the frame to update.

    As the second argument, enter the row number.

    If the frame cell is bound to a component's property, as the third argument, you can specify whether to keep the binding (true) or not(false). Default is true.

    Try it now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
    Contents