[OASIS Issue Tracker] Commented: (OFFICE-1895) RIGHTB and friendsis incompletely specified

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/OFFICE-1895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15608#action_15608 ] 

Andreas Guelzow  commented on OFFICE-1895:
------------------------------------------

I don't think that works. The "right-most number of bytes from T using Length" may not be valid text. 

Suppose you have rightb("Lévy",3) where "Lévy" is stored in UTF-8 encoding. Then the 3 right-most bytes are (in hex): a9 76 79 
This is not valid text. I think we would have two options:
(a) returning the maximum-length right portion of that byte sequence that is valid, ie. "vy" or
(b) return an error.

Gnumeric currently does the former, I don't know what Excel is doing.

> RIGHTB and friends is incompletely specified
> --------------------------------------------
>
>                 Key: OFFICE-1895
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1895
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Andreas Guelzow 
>            Assignee: Eric Patterson
>             Fix For: ODF 1.2
>
>
> 6.6.6 RIGHTB
> Summary: Return a selected number of text characters from the right, using byte position.
> This description fails to indicate what happens in the likely situation that the selected bytes do not form a complete character sequence. Should that be an error or move to a correct position?
> Similarly for  the otehr ...B functions

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