[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-3378) 19.367number:truncate-on-overflow - meaning of modulo? - not well-defined? - seedescription
[ http://tools.oasis-open.org/issues/browse/OFFICE-3378?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20899#action_20899 ] Andreas Guelzow commented on OFFICE-3378: ------------------------------------------ First a note re Dennis' last line: Excel, Gnumeric, OOo all have "extended hh" usually denoted "[hh]". "hh" is used for time "[hh]" for duration. According to MerriamWebsters "truncate" means " to shorten by or as if by cutting off". THis is exactly what we are doing here. We are cutting off superfluous information. number:truncate-on-overflow may not be restricted to spreadsheets but it has its uses there too (and surely the concept has a longer history in spreadsheets than in text fields.) There is no question in my mind that for durations one usually prefers number:truncate-on-overflow=FALSE. On the other hand for times umber:truncate-on-overflow=TRUE is muc more useful. If I calculate some event ending time as a time plus a duration, I may want to just give the time on that day, this truncation allows me to do that. I would think that whether the default is TRUE or FALSE is really arbitrary. (In fact I would prefer if there weren't any defaults anyways.) It is good practice for any producer to specify all attribute values rather than to rely on defaults. > 19.367 number:truncate-on-overflow - meaning of modulo? - not well-defined? - see description > --------------------------------------------------------------------------------------------- > > Key: OFFICE-3378 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-3378 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Bug > Components: Part 1 (Schema) > Affects Versions: ODF 1.2 CD 05 > Reporter: Patrick Durusau > Fix For: ODF 1.2 CD 06 > > > We had a long discussion in http://tools.oasis-open.org/issues/browse/OFFICE-1689 about this attribute but missed the use of "modulo." > From what I have found, for example: > http://en.wikipedia.org/wiki/Modulo_operation > http://mathworld.wolfram.com/ModularArithmetic.html > http://www.cafeaulait.org/course/week2/15.html > http://msdn.microsoft.com/en-us/library/se0w9esz%28VS.71%29.aspx > So the remainder of 24 modulo 24 is 0. > So the remainder of 48 modulo 24 is 0. > So the remainder of 72 modulo 24 is 0. > That can't be what we meant. > Rather I think we meant to have the quotient plus any remainder. > Yes? > Apologies for missing this in our prior discussion. It seems so clear now. -- 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]