[ 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
