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