[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 edited comment on OFFICE-3765 at 4/30/18 2:32 PM:
------------------------------------------------------------------

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

The alignment of the resulting string is not determined by this attribute and it is different between applications. 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.

The description has to fit to all writing directions. "left" or "right" might not be correct. I think, that the previously suggested wording " at the position where it occurs" is sufficient.

The schema, which Michael suggested in his mail [https://lists.oasis-open.org/archives/office/201804/msg00054.html], looks good to me, but it needs a restriction to one element in the text.

Therefore my suggestions:
 ===================================
 <number:fill-character>

The content of this element specifies a Unicode character that is displayed repeatedly at the position where the element occurs. The character specified is repeated as much times as possible, but so that the total resulting string does not exceed the given cell content area.

The distribution of the remaining space is implementation dependent.

—
 To chapter "16.27.1 General" add the sentence:

Data styles shall specify at most one {{<number:fill-character>}} element.


was (Author: regina.henschel):
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
>            Priority: Major
>             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
(v7.7.2#77003)