2.2.7 clrAllData

Menu Information

File: Clone current Project...

Brief Information

Clear import data to make Analysis Template Project

Additional Information

Minimum Origin Version Required: 2020

Command Line Usage

1. clrAllData mode:=1;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name 		Variable
Name 		I/O
and
Type 		Default
Value 		Description
Add Date Connectors addconn

Input

int

0
 Specify whether to add Data Connectors to worksheet containing import data when clone the current project: 0=false, 1=true
Clear Data mode

Input

int

0
 Specify whether to clear data when clone the current project

Option list:

  • 0:Clear All
    Cear all data but keep all windows and operations in the current project. You can use this option to save the entire project as an analysis template.
  • 1:Clear Imported Data and Delete Calculations
    Clear imported data and delete all columns and sheets resulted from calculation.
  • 2:Clear All and Set Recalculate to None
    Clear all data and set recalculation mode to None.
  • 3:Clear Raw Data (Exclude Cell Link)
    Clear all raw data but keep the cell links, such as cell references, cell formula etc..

Description

This X-Function is used to clone the current project and allows you to decide what should be kept and what can be cleared in the cloned project. If the project file has been modified since opening, you are prompted to save the operations and graph customizations in the project file before cloning. A new UNTITLED.opju is created and immediately opened after duplication.

English | Deutsch | 日本語