[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=20895#action_20895 ] Andreas Guelzow commented on OFFICE-3378: ------------------------------------------ As strange as it may sound, yes. If you have access to Excel, try the following: type 3:0:0 into a cell not surprisingly you will see 3:00:00 now type 48:0:0 into the _same_ cell you will see 0:00:00 Essentially 3:0:0 forces the cell to be set to teh default time format, and that means hours are truncated modulo 24. Since then spreadsheets have behaved like that. > 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]