표현으로 작업합니다

ASPOSE.TASK의 Java API는 작업, 리소스 및 프로젝트 필드를 표현식의 공식으로 사용할 수 있습니다. 작업, 비용, 번호 필드, DateTime, 부울 및 작업 수 및 자원 수와 같은 프로젝트 필드와 같은 필드는 확장 된 속성의 공식 표현식에 사용할 수 있습니다.

공식 계산에서 작업 및 리소스 필드 사용

// Create new project instance
   Project project = new Project();
        
java.util.Calendar cal = java.util.Calendar.getInstance();
cal.set(2015, 26, 3, 8,0,0);
        
project.set(Prj.START_DATE, cal.getTime());
        
   // Add new task with extended attribute
   Task task = project.getRootTask().getChildren().add("Task");
   ExtendedAttributeDefinition extendedAttributeDefinition = ExtendedAttributeDefinition.createTaskDefinition(CustomFieldType.Text, ExtendedAttributeTask.Text5, "My Ext Attr");
   project.getExtendedAttributes().add(extendedAttributeDefinition);
   ExtendedAttribute extendedAttribute = extendedAttributeDefinition.createExtendedAttribute();
   task.getExtendedAttributes().add(extendedAttribute);

   // Add resource and resource assignment
   Resource rsc = project.getResources().add("Rsc");
   ResourceAssignment assn = project.getResourceAssignments().add(task, rsc);
   return project;

// see this helper method below
Project project = CreateTestProjectWithCustomField();
        
ExtendedAttributeDefinition attr = project.getExtendedAttributes().get(0);
attr.setAlias("Days from finish to deadline");
attr.setFormula("[Deadline] - [Finish]");
        
java.util.Calendar cal = java.util.Calendar.getInstance();
cal.set(2015, 26, 3, 8,0,0);

Task task = project.getRootTask().getChildren().getById(1);
task.set(Tsk.DEADLINE, cal.getTime());

project.save("SaveFile.mpp", SaveFileFormat.MPP);

Using Arithmetic Expression

Project project = CreateTestProjectWithCustomField();
      
// Set arithmetic formula for extended attribute
ExtendedAttributeDefinition attr = project.getExtendedAttributes().get(0);
attr.setAlias("Arithmetic Expression");
attr.setFormula("(1+3*(2+ -5)+8/2)^3");

// Display extended attribute value
Task task = project.getRootTask().getChildren().getById(1);
System.out.println(task.getExtendedAttributes().get(0).getNumericValue());

Using Task Number Fields

Project project = CreateTestProjectWithCustomField();

// Set Formula
ExtendedAttributeDefinition attr = project.getExtendedAttributes().get(0);
attr.setAlias("Task number fields");
attr.setFormula("(([Outline Level] + [Priority] + [% Complete])/2");

Task task = project.getRootTask().getChildren().getById(1);

// Print extended attribute value before and after updating task percent complete
System.out.println(task.getExtendedAttributes().get(0).getNumericValue());

task.set(Tsk.PERCENT_COMPLETE, 50);
System.out.println(task.getExtendedAttributes().get(0).getNumericValue());

Formula With Boolean Values

Project project = CreateTestProjectWithCustomField();

// Set formula for extended attribute
project.getExtendedAttributes().get(0).setFormula("[Critical]-[Marked]+4+[Active]-Not [Active]");
        
// Print value of extened attribute
Task task = project.getRootTask().getChildren().getById(1);
System.out.println("Formula with boolean values" + task.getExtendedAttributes().get(0).getTextValue());

Formula With Project Fields

Project project = CreateTestProjectWithCustomField();

// Set formula for extended attribute
project.getExtendedAttributes().get(0).setFormula("\"Total tasks: \" & [Task Count] & \" Total resources: \" & [Resource Count]");
        
// Print value of extened attribute
Task task = project.getRootTask().getChildren().getById(1);
System.out.println("Formula with boolean values" + task.getExtendedAttributes().get(0).getTextValue());