Schreiben und Lesen von Formeln mit Aspose.Tasks FÜR JAVA

Aspose.Tasks FÜR JAVA API unterstützt das Lesen/Schreiben von Formeln für MPP -Projektdateien. Die Formeleigenschaft der extendedAttributedefinition liefert die Schnittstelle zum Lesen des Formelwerts. In diesem Artikel wird beschrieben, wie Formeln aus lokalen und Enterprise Extended Attribute aus der MPP -Datei gelesen werden.

Schreiben von Formeln in erweiterten Attributen an MPP -Dateiformate **

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