[OASIS Issue Tracker] (OFFICE-3765) [spreadsheet] Proposal: <number:fill-character> element for data styles

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

    [ https://issues.oasis-open.org/browse/OFFICE-3765?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=69689#comment-69689 ] 

Regina Henschel commented on OFFICE-3765:
-----------------------------------------

The alignment of the resulting string is not determined by this attribute and it is different between applications. Therefore my suggestion:
===================================
* Start of style:
         * Put the character specified as much times as possible before the display string, so that the total resulting string does not exceed the given cell width.
* End of style:
         * Put the character specified as much times as possible after the display string, so that the total resulting string does not exceed the given cell width.
* Within style:
         * Splits the display string in two parts at the position where the element occurs. Put the character specified as much times as possible between these two parts, so that the total resulting string does not exceed the given cell width.
The distribution of the remaining space is implementation dependent.
=====================================
LibreOffice takes the total resulting string and aligns it according left/center/right alignment setting of the cell. In cell alignment setting "justify" it is left aligned. The behavior in Excel is not consistence. Sometimes it acts like LibreOffice, but sometimes it aligns the display string right in all cell alignment cases and aligns the inserted character string part left/center/right in the remaining space.

Differences are not obvious in normal use. To see it, use a very wide fill character, e.g. U+2E3A, a "two-em dash".


> [spreadsheet] Proposal: <number:fill-character> element for data styles
> -----------------------------------------------------------------------
>
>                 Key: OFFICE-3765
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3765
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Improvement
>          Components: Part 1 (Schema), Table
>         Environment: This is an enhancement, described in terms of changes to OpenDocument-v1.2
>            Reporter: Thorsten Behrens 
>            Assignee: Andras Timar
>             Fix For: ODF 1.3
>
>
> Improve interoperability with other spreadsheet implementations, by enabling round-trip of fill characters (used to fill empty space in cells, not occupied e.g. by the actual cell content)



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)