OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: [OASIS Issue Tracker] Commented: (OFFICE-550) Public Comment: Re:[office-comment] Unit system tracking



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

David Wheeler  commented on OFFICE-550:
---------------------------------------

Unit system tracking is an interesting idea, but it's much harder than you may think.
Some unit systems don't have the same zero (e.g., Farenheit vs. Celcius vs. Kelvin).
Some "units" aren't really units (e.g., degrees vs. radians vs. gradians, which theoretically are all unitless).
Do money systems count as a unit system, even though the conversion
factors are complex?

Most importantly, spreadsheet implementations generally do NOT implement
arbitrary unit system tracking, and there's always a big risk of standardizing anything
where there's little implementation experience.

The CONVERT() function provides the necessary functionality for PERFORMING
unit system conversion (though without, of course, unit system tracking).
For many users, this seems to be sufficient.

I propose that we reject this for now, since there simply isn't much experience
with spreadsheets that perform unit system tracking.  Should there BE
a spreadsheet implementation that successfully adds unit system tracking,
we can use that as the starting point.


> Public Comment: Re: [office-comment] Unit system tracking
> ---------------------------------------------------------
>
>                 Key: OFFICE-550
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-550
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: New Feature
>          Components: OpenFormula
>    Affects Versions: ODF-Next
>            Reporter: Robert Weir 
>             Fix For: ODF-Next
>
>
> Copied from office-comment list
> Original author: Leonard Mada <discoleo@gmx.net> 
> Original date: 9 Aug 2007 21:23:26 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/200708/msg00000.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

        


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]