diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:48:59 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:48:59 +0000 |
| commit | c484829272cd13a738e35412498e12f2c9a194ac (patch) | |
| tree | a1f5ec09629ee895bd3963fa8820b45f2f4c574b /misc/notes/column-width-and-row-height.txt | |
| parent | Initial commit. (diff) | |
| download | liborcus-upstream/0.19.2.tar.xz liborcus-upstream/0.19.2.zip | |
Adding upstream version 0.19.2.upstream/0.19.2upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'misc/notes/column-width-and-row-height.txt')
| -rw-r--r-- | misc/notes/column-width-and-row-height.txt | 69 |
1 files changed, 69 insertions, 0 deletions
diff --git a/misc/notes/column-width-and-row-height.txt b/misc/notes/column-width-and-row-height.txt new file mode 100644 index 0000000..336d9c9 --- /dev/null +++ b/misc/notes/column-width-and-row-height.txt @@ -0,0 +1,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. |