Remove Formula/Links


Version: 2022b

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-25001


A new dialog has been introduced that allows you to convert all formula and links to values in your Origin project.

Then save the project and share with colleagues

Labtalk command doc -wf <linktype> <scope>

<linktype> - 1=col formula, 2=cell formula, 4 = worksheet script, 8 = button script, 16 - DDE link

<scope> -- default = 0 is for entire project, 1 = active book only, 2= active sheet only, 3 = old Edit > Remove Link menu that will only remove the selected range.

E.g.

  • doc -wf 3 1; //clear column and cell formula for active sheet only

  • doc -wf 16 //clear DDE links in entire project