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] (OFFICE-3765) [spreadsheet] Proposal: <number:fill-character> element for data styles


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

Michael Stahl updated OFFICE-3765:
----------------------------------
    Proposal: 
Updated 30 April 2018 to reflect proposal up for TC approval:

 

Regina Henschel's proposal for the text (changed does not to shall not in the second sentence)

New element:

<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 many times as possible, but the total resulting string shall not exceed the given cell content area.

Fill characters may not fill all the available space in a cell. 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.

Michael Stahl's schema prooposal:

--- Downloads/OpenDocument-v1.2-os-schema.rng	2018-04-06 13:21:47.000000000 +0200
+++ OFFICE-3765.rng-v2	2018-04-26 16:29:04.895877657 +0200
@@ -12608,20 +12608,20 @@
 	<define name="number-number-style">
 		<element name="number:number-style">
 			<ref name="common-data-style-attlist"/>
 			<optional>
 				<ref name="style-text-properties"/>
 			</optional>
 			<optional>
-				<ref name="number-text"/>
+				<ref name="number-text-with-fillchar"/>
 			</optional>
 			<optional>
 				<ref name="any-number"/>
 				<optional>
-					<ref name="number-text"/>
+					<ref name="number-text-with-fillchar"/>
 				</optional>
 			</optional>
 			<zeroOrMore>
 				<ref name="style-map"/>
 			</zeroOrMore>
 		</element>
 	</define>
@@ -12712,15 +12712,15 @@
 		<element name="number:currency-style">
 			<ref name="common-data-style-attlist"/>
 			<ref name="common-auto-reorder-attlist"/>
 			<optional>
 				<ref name="style-text-properties"/>
 			</optional>
 			<optional>
-				<ref name="number-text"/>
+				<ref name="number-text-with-fillchar"/>
 			</optional>
 			<optional>
 				<choice>
 					<group>
 						<ref name="number-and-text"/>
 						<optional>
 							<ref name="currency-symbol-and-text"/>
@@ -12738,21 +12738,21 @@
 				<ref name="style-map"/>
 			</zeroOrMore>
 		</element>
 	</define>
 	<define name="currency-symbol-and-text">
 		<ref name="number-currency-symbol"/>
 		<optional>
-			<ref name="number-text"/>
+			<ref name="number-text-with-fillchar"/>
 		</optional>
 	</define>
 	<define name="number-and-text">
 		<ref name="number-number"/>
 		<optional>
-			<ref name="number-text"/>
+			<ref name="number-text-with-fillchar"/>
 		</optional>
 	</define>
 	<define name="number-currency-symbol">
 		<element name="number:currency-symbol">
 			<ref name="number-currency-symbol-attlist"/>
 			<text/>
 		</element>
@@ -12782,15 +12782,15 @@
 	<define name="number-percentage-style">
 		<element name="number:percentage-style">
 			<ref name="common-data-style-attlist"/>
 			<optional>
 				<ref name="style-text-properties"/>
 			</optional>
 			<optional>
-				<ref name="number-text"/>
+				<ref name="number-text-with-fillchar"/>
 			</optional>
 			<optional>
 				<ref name="number-and-text"/>
 			</optional>
 			<zeroOrMore>
 				<ref name="style-map"/>
 			</zeroOrMore>
@@ -12801,20 +12801,20 @@
 			<ref name="common-data-style-attlist"/>
 			<ref name="common-auto-reorder-attlist"/>
 			<ref name="common-format-source-attlist"/>
 			<optional>
 				<ref name="style-text-properties"/>
 			</optional>
 			<optional>
-				<ref name="number-text"/>
+				<ref name="number-text-with-fillchar"/>
 			</optional>
 			<oneOrMore>
 				<ref name="any-date"/>
 				<optional>
-					<ref name="number-text"/>
+					<ref name="number-text-with-fillchar"/>
 				</optional>
 			</oneOrMore>
 			<zeroOrMore>
 				<ref name="style-map"/>
 			</zeroOrMore>
 		</element>
 	</define>
@@ -12958,20 +12958,20 @@
 			<ref name="number-time-style-attlist"/>
 			<ref name="common-data-style-attlist"/>
 			<ref name="common-format-source-attlist"/>
 			<optional>
 				<ref name="style-text-properties"/>
 			</optional>
 			<optional>
-				<ref name="number-text"/>
+				<ref name="number-text-with-fillchar"/>
 			</optional>
 			<oneOrMore>
 				<ref name="any-time"/>
 				<optional>
-					<ref name="number-text"/>
+					<ref name="number-text-with-fillchar"/>
 				</optional>
 			</oneOrMore>
 			<zeroOrMore>
 				<ref name="style-map"/>
 			</zeroOrMore>
 		</element>
 	</define>
@@ -13078,27 +13078,43 @@
 	<define name="number-text-style">
 		<element name="number:text-style">
 			<ref name="common-data-style-attlist"/>
 			<optional>
 				<ref name="style-text-properties"/>
 			</optional>
 			<optional>
-				<ref name="number-text"/>
+				<ref name="number-text-with-fillchar"/>
 			</optional>
 			<zeroOrMore>
 				<ref name="number-text-content"/>
 				<optional>
-					<ref name="number-text"/>
+					<ref name="number-text-with-fillchar"/>
 				</optional>
 			</zeroOrMore>
 			<zeroOrMore>
 				<ref name="style-map"/>
 			</zeroOrMore>
 		</element>
 	</define>
+	<define name="number-text-with-fillchar">
+		<optional>
+			<ref name="number-text"/>
+		</optional>
+		<optional>
+			<ref name="number-fill-character"/>
+			<optional>
+				<ref name="number-text"/>
+			</optional>
+		</optional>
+	</define>
+	<define name="number-fill-character">
+		<element name="number:fill-character">
+			<text/>
+		</element>
+	</define>
 	<define name="number-text">
 		<element name="number:text">
 			<text/>
 		</element>
 	</define>
 	<define name="number-text-content">
 		<element name="number:text-content">


  was:
Updated 30 April 2018 to reflect proposal up for TC approval:

 

Regina henschel's proposal for the text (changed does not to shall not in the second sentence)

New element:

<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 many times as possible, but the total resulting string shall not exceed the given cell content area.

Fill characters may not fill all the available space in a cell. 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.

Michael Stahl's schema prooposal:

--- Downloads/OpenDocument-v1.2-os-schema.rng 2018-04-06 13:21:47.000000000 +0200
+++ OFFICE-3765.rng-v2 2018-04-26 16:29:04.895877657 +0200
@@ -12608,20 +12608,20 @@
 <define name="number-number-style">
 <element name="number:number-style">
 <ref name="common-data-style-attlist"/>
 <optional>
 <ref name="style-text-properties"/>
 </optional>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 <optional>
 <ref name="any-number"/>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 </optional>
 <zeroOrMore>
 <ref name="style-map"/>
 </zeroOrMore>
 </element>
 </define>
@@ -12712,15 +12712,15 @@
 <element name="number:currency-style">
 <ref name="common-data-style-attlist"/>
 <ref name="common-auto-reorder-attlist"/>
 <optional>
 <ref name="style-text-properties"/>
 </optional>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 <optional>
 <choice>
 <group>
 <ref name="number-and-text"/>
 <optional>
 <ref name="currency-symbol-and-text"/>
@@ -12738,21 +12738,21 @@
 <ref name="style-map"/>
 </zeroOrMore>
 </element>
 </define>
 <define name="currency-symbol-and-text">
 <ref name="number-currency-symbol"/>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 </define>
 <define name="number-and-text">
 <ref name="number-number"/>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 </define>
 <define name="number-currency-symbol">
 <element name="number:currency-symbol">
 <ref name="number-currency-symbol-attlist"/>
 <text/>
 </element>
@@ -12782,15 +12782,15 @@
 <define name="number-percentage-style">
 <element name="number:percentage-style">
 <ref name="common-data-style-attlist"/>
 <optional>
 <ref name="style-text-properties"/>
 </optional>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 <optional>
 <ref name="number-and-text"/>
 </optional>
 <zeroOrMore>
 <ref name="style-map"/>
 </zeroOrMore>
@@ -12801,20 +12801,20 @@
 <ref name="common-data-style-attlist"/>
 <ref name="common-auto-reorder-attlist"/>
 <ref name="common-format-source-attlist"/>
 <optional>
 <ref name="style-text-properties"/>
 </optional>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 <oneOrMore>
 <ref name="any-date"/>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 </oneOrMore>
 <zeroOrMore>
 <ref name="style-map"/>
 </zeroOrMore>
 </element>
 </define>
@@ -12958,20 +12958,20 @@
 <ref name="number-time-style-attlist"/>
 <ref name="common-data-style-attlist"/>
 <ref name="common-format-source-attlist"/>
 <optional>
 <ref name="style-text-properties"/>
 </optional>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 <oneOrMore>
 <ref name="any-time"/>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 </oneOrMore>
 <zeroOrMore>
 <ref name="style-map"/>
 </zeroOrMore>
 </element>
 </define>
@@ -13078,27 +13078,43 @@
 <define name="number-text-style">
 <element name="number:text-style">
 <ref name="common-data-style-attlist"/>
 <optional>
 <ref name="style-text-properties"/>
 </optional>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 <zeroOrMore>
 <ref name="number-text-content"/>
 <optional>
- <ref name="number-text"/>
+ <ref name="number-text-with-fillchar"/>
 </optional>
 </zeroOrMore>
 <zeroOrMore>
 <ref name="style-map"/>
 </zeroOrMore>
 </element>
 </define>
+ <define name="number-text-with-fillchar">
+ <optional>
+ <ref name="number-text"/>
+ </optional>
+ <optional>
+ <ref name="number-fill-character"/>
+ <optional>
+ <ref name="number-text"/>
+ </optional>
+ </optional>
+ </define>
+ <define name="number-fill-character">
+ <element name="number:fill-character">
+ <text/>
+ </element>
+ </define>
 <define name="number-text">
 <element name="number:text">
 <text/>
 </element>
 </define>
 <define name="number-text-content">

 


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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]