blob: 336d9c9e8997cb948b6d67938fc7fdd238d6a92a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
== XLSX ==
Spec name: Office Open XML Part 4 - Markup Language Reference.pdf
=== Column Width ===
<cols>
<col min="1" max="2" width="13.140625" customWidth="1"/>
<col min="4" max="10" width="6.7109375" customWidth="1"/>
</cols>
Spec location: 3.3.1.12 col (Column Width & Formatting) (page 1946)
Column width measured as the number of characters of the maximum
digit width of the numbers 0, 1, 2, ..., 9 as rendered in the normal
style's font. There are 4 pixels of margin padding (two on each
side), plus 1 pixel padding for the gridlines.
width = Truncate([{Number of Characters} * {Maximum Digit Width} +
{5 pixel padding}]/{Maximum Digit Width}*256)/256
Using the Calibri font as an example, the maximum digit width of 11
point font size is 7 pixels (at 96 dpi). In fact, each digit is the
same width for this font. Therefore if the cell width is 8
characters wide, the value of this attribute shall be
Truncate([8*7+5]/7*256)/256 = 8.7109375.
=== Row Height ===
<row r="10" spans="1:10" ht="40.5" customHeight="1">
<c r="D10">
<v>11.1</v>
</c>
</row>
Spec location: 3.3.1.71 row (Row) (page 2012)
Row height measured in point size. There is no margin padding on
row height.
== ODS ==
=== Column Width & Row Height ===
<style:style style:name="co1" style:family="table-column">
<style:table-column-properties fo:break-before="auto" style:column-width="0.8925in"/>
</style:style>
<style:style style:name="ro1" style:family="table-row">
<style:table-row-properties style:row-height="0.178in" fo:break-before="auto" style:use-optimal-row-height="true"/>
</style:style>
<table:table table:name="Test1" table:style-name="ta1" table:print="false">
<table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
<table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
<table:table-column table:style-name="co4" table:number-columns-repeated="2" table:default-cell-style-name="Default"/>
<table:table-row table:style-name="ro2">
<table:table-cell office:value-type="string">
<text:p>Name</text:p>
</table:table-cell>
<table:table-cell office:value-type="string">
<text:p>Value</text:p>
</table:table-cell>
<table:table-cell table:number-columns-repeated="6"/>
</table:table-row>
</table:table>
Spec doesn't say much, but it appears that the order of these
<table:table-column> elements is significant & determines which column
gets which automatic style, from left to right.
|
