Trabajando con expresiones

Aspose.Tasks for Java API puede usar campos de tareas, recursos y proyectos como una fórmula en expresiones. Los campos como el trabajo, el costo, los campos numéricos, la fecha y hora, los campos booleanos y de proyectos, como el recuento de tareas y el recuento de recursos, se pueden usar en expresiones de fórmula en un atributo extendido.

Uso de tareas y campos de recursos en cálculos de fórmula

// 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());