[OASIS Issue Tracker] Created: (OFFICE-3428) Support calculatedvalues from multiple formula engines

Support calculated values from multiple formula engines
-------------------------------------------------------

                 Key: OFFICE-3428
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3428
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Sub-task
          Components: OpenFormula
    Affects Versions: ODF 1.2 CD 05
            Reporter: Robert Weir 


In OpenFormula, it's possible to do formula including a way to
describe non-standard formula.

It would be interesting to be able to add information about formula
engines and values.

What would be interesting is to be able to do is the following:
Letting the formula's be calculated with a formula engine.
Saving the cells values with a calculated value attribute and formula
engine attribute.
Calculate the formulas with another formula engine.
Saving also the new values with a calculated value attribute and
formula engine attribute.



It needs something to preserve the calculated value of that cell and
which formula engine that did it. Preferably in a way so that multiple
values from multiple formula engines and versions can be stored
parallel.

To avoid problems, software should, without extra input, show the most
recent results.

A function to show the name of the formula engine currently used would
be handy.
Also a function to show a list of all formula engines (+version if
applicable) with their values.

This would be very handy to compare things from different formula
engines in the future.

Was inspired by the bottom of this blog post, where formula engines
are mentioned:
http://www.robweir.com/blog/2010/07/odf12-public-review.html


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira