Understanding the Edit Design Data Interface

Understanding the Edit Design Data Interface

The Edit Design Data interface is a spreadsheet editor, similar to Microsoft Excel. 


The interface includes tools located at the top of the window. Below the tool icons is a drop-down list of defined names that can be used to locate the cell’s reference. Beside the drop-down is the formula bar. Formulas will be displayed and can be edited using the formula bar. Below the formula bar is the spreadsheet. At the bottom of the spreadsheet, area are the tabs that the product contains. At the bottom of the interface are different save and close options.

The tools available (from left to right) include:
  1. Save – Allows you to save the changes made to the spreadsheet.
  2. Close Subassembly – Allows you to close out of a subassembly or nested subassembly.
    3. This icon is only visible when a subassembly or nested subassembly file is open. When a nested subassembly is open, the icon will have a green arrow.
  3. Cut – Allows you to cut a cell, or range of cells, from the spreadsheet.
  4. Copy – Allows you to copy a cell, or range of cells, from the spreadsheet.
  5. Paste – Allows you to paste a cut or copied cell, or range of cells, to another location.
  6. Insert Function – Allows you to access the Formula Editor, which can be used to read or write formulas.
  7. Force Recalculation – Allows you to force formulas and equations to recalculate.
  8. Undo – Allows you to undo changes.
  9. Redo – Allows you to redo changes that were undone.
  10. Find and Replace – Allows you to find every mention of the keyword entered, and replace every instance. 
  11. Name Manager – Opens the Name Manager window. 
  12. Filter Parts – Allows you to view included parts (parts with a quantity greater than 0) or all parts.
  13. Toggle Part Thickness Column – Allows you to hide or view the thickness column.
  14. Toggle Hidden Columns A through P – Hides or Displays hidden columns. 
  15. Show Spreadsheet Errors – Allows you to find any errors within the selected spreadsheet tab.
  16. Set Standard Column Widths – Allows you to set standard widths for the columns within the selected spreadsheet.
  17. Workbook Designer – Allows you to access the Workbook Designer interface. Workbook designer includes more spreadsheet tools and allows you to access the other workbooks within the project.

A noticeable feature that is built into Edit Design Data is the conditional formatting to make cells with formulas appear with red text. Black text indicates a static value.


    • Related Articles

    • Accessing the Edit Design Data Interface

      Accessing the Edit Design Data InterfaceThere are several ways to access the Edit Design Data interface: When drawing products (Draw > Draw Products), you can right-click in the product list, expand the “More” list at the bottom of the menu, and ...

    • Working Within the Subassemblies Tab

      Working Within the Subassemblies Tab The Subassemblies tab is where the subassemblies for the product are located. The majority of library products contain subassemblies. Subassemblies are products within products. Subassemblies can be added manually ...

    • Understanding the OFFSETPOLYLINE Spreadsheet Function

      The OFFSETPOLYLINE Spreadsheet Function allows for vector points to be entered, from a polyline token, for example, and the function then returns the vector coordinates offset by the desired amount. The OFFSETPOLYLINE function is formatted as such: ...

    • Working Within the Cut Parts Tab

      Working Within the Cut Parts Tab The Cut Parts tab is where parts within the product are located. If the Cut Parts tab does not contain any parts, they may be contained in a subassembly. Parts can be added manually to the Cut Parts tab. A minimum of ...

    • Working Within the Hardware Parts Tab

      Working Within the Hardware Parts Tab The Hardware Parts tab is where hardware items for the product are located. Note: If the Hardware Parts tab does not contain any hardware items, they may be contained in a subassembly. Hardware items can be ...

    • Recent Articles

    • Microvellum Foundation Library Release Notes | Build 24.1025

      The following release notes apply to Microvellum Foundation Library build 24.1025. Additions Added new global variable “Remove Stop Dado On Bottom Edge” for wood drawer boxes. Check this option to run the dado through at the bottom of the sub front ...

    • Toolbox Release Notes | Build 24.1.1030.641

      The following release notes apply to Toolbox build 24.1.1030.641 Routing and Profile Fixes Several issues were found with routing and polyline paths: Fig. 1: Horizontal routes off of a part disappearing (left) and appearing correctly (right). When ...

    • Toolbox Release Notes | Build 24.1.1010.641

      The following release notes apply to Toolbox build 24.1.1010.641 Biesse Winstore Fix Several issues with the Biesse Winstore plugin have been resolved: There was an issue that would sometimes occur wherein materials that were intended to stack wound ...

    • Toolbox Release Notes | Build 24.1.1001.641

      The following release notes apply to Toolbox build 24.1.1001.641 HBore Toolfile Fix Fig. 1: The location in the Toolfile UI where the error would occur. There was an issue reported with the functionality of the Horizontal Boring Machine setting in ...

    • Microvellum Foundation Library Release Notes | Build 24.0919

      The following release notes apply to Microvellum Foundation Library build 24.0919 Additions Added 5 new special Wine Rack products and 9 new Wine Rack Insert subassemblies. Products: Master Vertical Wine Rack Corner Frame Master Vertical Wine Rack ...