[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Commented: (OFFICE-3765) [spreadsheet] Proposal: <number:fill-character> element for data styles
[ http://tools.oasis-open.org/issues/browse/OFFICE-3765?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=31413#action_31413 ]
Andreas Guelzow commented on OFFICE-3765:
------------------------------------------
Data styles should not affect comparison of cell content since they only describe how the content is presented. Since fill characters would be part of the data styles they should not affect comparison at all.
In LibreOffice if yo specify a data format as "99;88;77" (without quotes) and enter 4 in the cell, then a 99 is shown but the cell does not test equal to 99 (but it does test equal to 99). Gnumeric behaves the same and I would think that all common spreadsheet programs compare the cell content rather than the shown string as formatted by the data style.
> [spreadsheet] Proposal: <number:fill-character> element for data styles
> -----------------------------------------------------------------------
>
> Key: OFFICE-3765
> URL: http://tools.oasis-open.org/issues/browse/OFFICE-3765
> Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
> Issue Type: Improvement
> Components: Table
> Environment: This is an enhancement, described in terms of changes to OpenDocument-v1.2
> Reporter: Thorsten Behrens
> Assignee: Thorsten Behrens
> 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 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]