Formules d'écriture et de lecture avec Aspose.Tasks pour Java

Aspose.Tasks pour l’API Java prend en charge les formules de lecture / écriture aux fichiers du projet MPP. La propriété de formule de l’extensionAttributeDefinition fournit l’interface pour lire la valeur de formule. Cet article décrit comment lire les formules des attributs étendus locaux et d’entreprise du fichier MPP.

Écriture de formules dans des attributs étendus aux formats de fichiers MPP

// The path to the documents directory.
String dataDir = Utils.getDataDir(WriteReadFormula.class);

Project project = new Project(dataDir + "New project 2010.mpp");
project.set(Prj.NEW_TASKS_ARE_MANUAL, new NullableBool(false));

// create new custom field (Task Text1) with formula which will double task cost
ExtendedAttributeDefinition attr = ExtendedAttributeDefinition.createTaskDefinition(CustomFieldType.Text,
        ExtendedAttributeTask.Text1, "Custom");
attr.setAlias("Double Costs");
attr.setFormula("[Cost]*2");

project.getExtendedAttributes().add(attr);

// add a task to see the result in MSP
Task task = project.getRootTask().getChildren().add("Task");
// set task cost
task.set(Tsk.COST, BigDecimal.valueOf(100));
// see the result in the attached screenshot (result.jpg)
project.save(dataDir + "saved.mpp", SaveFileFormat.MPP);

Reading Formulas in Local and Enterprise Extended Attributes from MPP file

// The path to the documents directory.
String dataDir = Utils.getDataDir(WriteReadFormula.class);

Project proj = new Project(dataDir + "FormulaField.mpp"); // attached test mpp
ExtendedAttributeDefinition attr = proj.getExtendedAttributes().get(0);

System.out.println("Attribute Formula: " + attr.getFormula());

Read-Only Access to Custom Field Values when Using Formulas

// The path to the documents directory.
String dataDir = Utils.getDataDir(WriteReadFormula.class);

Project project = new Project();

ExtendedAttributeDefinition attribute = ExtendedAttributeDefinition.createTaskDefinition(CustomFieldType.Cost,
        ExtendedAttributeTask.Cost1, "");
attribute.setFormula("[Cost]-[Actual Cost]");

project.getExtendedAttributes().add(attribute);

// Add task
Task task = project.getRootTask().getChildren().add("Task");

// Create extended attribute
ExtendedAttribute extendedAttribute = attribute.createExtendedAttribute();
task.getExtendedAttributes().add(extendedAttribute);

// Display if extended attributes are read only or not
System.out.println(
        extendedAttribute.getValueReadOnly() == true ? "Value is Read only" : "Value is not read only");
extendedAttribute.setTextValue("-36755");
System.out.println(
        extendedAttribute.getTextValue() == " " ? "Formula values are read-only" : "Values are not read-only");