diff options
Diffstat (limited to 'helpcontent2/source/text/shared/01/SetOptimalColumnWidth.xhp')
| -rw-r--r-- | helpcontent2/source/text/shared/01/SetOptimalColumnWidth.xhp | 88 |
1 files changed, 88 insertions, 0 deletions
diff --git a/helpcontent2/source/text/shared/01/SetOptimalColumnWidth.xhp b/helpcontent2/source/text/shared/01/SetOptimalColumnWidth.xhp new file mode 100644 index 0000000000..0a37727902 --- /dev/null +++ b/helpcontent2/source/text/shared/01/SetOptimalColumnWidth.xhp @@ -0,0 +1,88 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + + <meta> + <topic id="textshared01SetOptimalColumnWidthxhp" indexer="include" status="PUBLISH"> + <title id="tit">Optimal Column Width</title> + <filename>/text/shared/01/SetOptimalColumnWidth.xhp</filename> + </topic> + </meta> + <body> +<bookmark branch="hid/.uno:SetOptimalColumnWidth" id="bm_id8687648" localize="false"/> +<bookmark branch="index" id="bm_id3155628"> +<bookmark_value>spreadsheets; optimal column widths</bookmark_value> +<bookmark_value>columns; optimal widths</bookmark_value> +<bookmark_value>optimal column widths</bookmark_value> +<bookmark_value>optimal column widths;text table</bookmark_value> +<bookmark_value>text table;optimal column widths</bookmark_value> +</bookmark> +<bookmark branch="hid/modules/scalc/ui/optimalcolwidthdialog/OptimalColWidthDialog" id="bm_id2742569" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/optimalcolwidthdialog/@@nowidget@@" id="bm_id2742569" localize="false"/> +<bookmark branch="hid/.uno:SetOptimalColumnWidthDirect" id="bm_id3153254" localize="false"/> + <section id="optimal_column_width"> + <h1 id="hd_id3149500"><variable id="optimal_column_width_h1"><link href="text/shared/01/SetOptimalColumnWidth.xhp">Optimal Column Width</link></variable></h1> + <switch select="appl"> + <case select="WRITER"> + <paragraph role="paragraph" id="par_id3149050"><variable id="column_width_text"><ahelp hid=".uno:SetOptimalColumnWidth">Adjust column widths among columns with selected cells, according to the paragraph length in each selected cell. Widen the table, up to page width, if necessary.</ahelp></variable></paragraph> + </case> + <case select="CALC"/> + <default> + <paragraph role="paragraph" id="par_id811655764710135"><ahelp hid=".uno:SetOptimalColumnWidth">Adjust column width for selected columns to fit the column’s content, without changing the width of the table or the unselected columns.</ahelp> + </paragraph> + </default> + </switch> + </section> + <section id="howtoget"> + <embed href="text/shared/00/00040500.xhp#optimal_column_width"/> + </section> + <switch select="appl"> + <case select="WRITER"> + <paragraph role="paragraph" id="par_id611656069528584"><menuitem>Optimal Column Width</menuitem> attempts to give a column width for the selected cells so that the longest paragraph in each cell can, as a minimum, <emph>fit</emph> exactly on a single line, though it is possible and common for columns to be wider than an exact fit.</paragraph> + <paragraph role="paragraph" id="par_id601656102623025">The final distribution of column widths depends on several factors, such as the paragraph length of selected cells, the initial width of the columns with selected cells, and whether the table can be widened. Space is also included for any horizontal cell padding, paragraph padding, and paragraph indents. The width of the table is never reduced, and unselected columns are not changed.</paragraph> + <paragraph role="paragraph" id="par_id651656105163827">The following list indicates how column widths are distributed for the selected cells. If the first step succeeds in distributing column widths for the selected cells so that all paragraphs in the cell are on a single line, then the process stops, otherwise the second step is attempted, if possible. The third step describes how column widths are distributed when it is not possible to fit all the selected cells after the second step.</paragraph> + <list type="ordered"> + <listitem> + <paragraph id="par_id221656101892491" role="listitem">Distribute column widths proportionally according to the longest paragraph in each cell, but remaining within the total column width for cell selection.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id641656101994507" role="listitem">If some cells cannot fit exactly in the total width of the selection, and the table can be expanded (up to the page width), then expand the table width until all cells are fit exactly.</paragraph> + </listitem> + <listitem> + <paragraph id="par_id511656102101362" role="listitem">If the table width is at the page margin, and more than one selected cell does not fit exactly, then give as much width as possible to the first cell that cannot be fit exactly, and an equal (smaller) column width to the other cells that cannot be fit.</paragraph> + </listitem> + </list> + <paragraph role="paragraph" id="par_id471656104869532">Step 1 is often sufficient for tables whose cells are primarily short paragraphs, while Step 3 is usually needed if many columns or rows are selected and/or selected cells have longer paragraphs.</paragraph> + </case> + <case select="CALC"> + <bookmark branch="hid/modules/scalc/ui/optimalcolwidthdialog/value" id="bm_id3153192" localize="false"/> + <h2 id="hd_id3150767">Add</h2> + <paragraph role="paragraph" id="par_id3150449" ><ahelp hid="modules/scalc/ui/optimalcolwidthdialog/value">Defines additional spacing between the longest entry in a column and the vertical column borders.</ahelp></paragraph> + <bookmark branch="hid/modules/scalc/ui/optimalcolwidthdialog/default" id="bm_id3155855" localize="false"/> + <h2 id="hd_id3145785">Default value</h2> + <paragraph role="paragraph" id="par_id3146120" ><ahelp hid="modules/scalc/ui/optimalcolwidthdialog/default">Defines the optimal column width in order to display the entire contents of the column.</ahelp> The additional spacing for the optimal column width is preset to 2 mm.</paragraph> + </case> + <default> + <paragraph role="paragraph" id="par_id601656069480524"><menuitem>Optimal Column Width</menuitem> attempts to give a column width for the selected columns so that the longest paragraph in each column can, as a minimum, <emph>fit</emph> exactly on a single line, though it is possible and common for columns to be wider than an exact fit.</paragraph> + <paragraph role="paragraph" id="par_id721655819449619">The final distribution of column widths depends on several factors, such as the paragraph length and initial width of the selected columns. Space is also included for any horizontal cell padding, paragraph padding, and paragraph indents. The width of the table is never reduced, and unselected columns are not changed.</paragraph> + <paragraph role="paragraph" id="par_id581656107648277">The option distributes column widths proportionally according to the longest paragraph in each column, but remaining within the total column width for the selected columns. When selected columns cannot be fit exactly, then the first column that cannot be fit exactly gets as much width as possible, while any additional columns that cannot be fit exactly get a smaller column width, which is equal for each of these additional columns.</paragraph> + </default> + </switch> + <section id="relatedtopics"> + <embed href="text/shared/02/04210000.xhp#optimizeh1"/> + <switch select="appl"> + <case select="WRITER"> + <paragraph role="paragraph" id="par_id681693927087020" localize="false"><embedvar href="text/swriter/01/TableAutoFitMenu.xhp#h1" markup="ignore"/></paragraph> + <embed href="text/swriter/guide/table_sizing.xhp#table_sizing"/> + </case> + </switch> + </section> +</body> +</helpdocument> |