[OASIS Issue Tracker] Commented: (OFFICE-3426) Making the "=" ashould in formula.

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/OFFICE-3426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21733#action_21733 ] 

Dennis Hamilton commented on OFFICE-3426:
-----------------------------------------

Yes, I believe this is a misunderstanding.  In the cells, we can always tell the difference between a formula and a text value that looks like a formula.  How these are differentiated on entry in the UI is not a matter for our concern.

In the markup in ODF 1.2, we also always know the difference. 

In OpenFormula, of course, there is nothing but formulas so the distinction is irrelevant.  That there are also provisions from extracting formulas from references is how we deal with that case.

That seems to about cover it.

> Making the "=" a should in formula.
> -----------------------------------
>
>                 Key: OFFICE-3426
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3426
>             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 
>            Assignee: David Wheeler 
>            Priority: Minor
>             Fix For: ODF 1.2 CD 06
>
>
> Making the "=" a should in formula.
> Because it would be handy to do the following:
> Cell A1 and A2, in A2 there s a formula, the cell shows the result of
> that formula.
> In cell A1 I want to store how the formula looks.
> I would need for this:
> something to distinguish formula that are formula and formula that are
> just strings that I want to show.
> Another handy thing would be a FormulaToString(cell) function that
> takes a cell as input and shows a string that is the textual
> representation of the formula and not the value calculated by the
> formula.

-- 
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