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=20898#action_20898 ] 

Dennis Hamilton commented on OFFICE-3378:

Actually, it is an issue.  The adjustment in question has nothing to do with spreadsheet tables (it can apply to a field that shows the current time in the text of a document).  Also, truncation is an unfortunate choice of term, it should be something like reduction or limitation in some way.  
However the rules are related to what different people want to happen when they have a possibly-larger value and they want to see the minutes from it.

Also, we need to consider the notional (or canonical) values in contrast to the syntactic ones in deciding what values the style applies to.  Then we need to be clear what the result is when the attribute is false and extended values are provided.

For example, assume a duration of P1DT2H170M63S (canonically, P1DT04H51M03S without concern for leap-seconds).

If the highest-order field provided in the style is hours, I assume the result would be presented as PT28H51M03S (formatted) in extended style and as PT04H51M03S in "truncated" style.

If the highest-order field provided in the style is minutes, I assume the result would be presented as PT1731M03S in extende style but PT51M03S in truncated style.

It would be nice if this were available for Days as well, so that one could have large periods of days without having to deal with months and years.

Excel carries times, dates, and whatever is taken as durations as serial days, Number values where the unit is one day.  When cell formats specify hh:mm:ss and the like, the behavior is relative to the time of day within the day of the serial day value.   (E.g., in OOXML -1.25 is 0.75 from the beginning of serial day -2 and the result is 18:00:00.)

As someone who keeps time records for a work month in hours and minutes, I would like it if I could get extended hh, although I have practices that work despite 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]