1 <?xml version=
"1.0" encoding=
"UTF-8"?>
4 <!--***********************************************************************
6 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 * Copyright 2008 by Sun Microsystems, Inc.
10 * OpenOffice.org - a multi-platform office productivity suite
12 * $RCSfile: 05040200.xhp,v $
15 * This file is part of OpenOffice.org.
17 * OpenOffice.org is free software: you can redistribute it and/or modify
18 * it under the terms of the GNU Lesser General Public License version 3
19 * only, as published by the Free Software Foundation.
21 * OpenOffice.org is distributed in the hope that it will be useful,
22 * but WITHOUT ANY WARRANTY; without even the implied warranty of
23 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 * GNU Lesser General Public License version 3 for more details
25 * (a copy is included in the LICENSE file that accompanied this code).
27 * You should have received a copy of the GNU Lesser General Public License
28 * version 3 along with OpenOffice.org. If not, see
29 * <http://www.openoffice.org/license.html>
30 * for a copy of the LGPLv3 License.
32 ************************************************************************-->
34 <helpdocument version=
"1.0">
36 <topic id=
"textscalc0105040200xml" indexer=
"include" status=
"PUBLISH">
37 <title id=
"tit" xml-lang=
"en-US">Optimal Column Width
</title>
38 <filename>/text/scalc/
01/
05040200.xhp
</filename>
41 <created date=
"2003-10-31T00:00:00">Sun Microsystems, Inc.
</created>
42 <lastedited date=
"2004-08-10T10:16:19">converted from old format - fpe
</lastedited>
46 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3155628"><bookmark_value>spreadsheets; optimal column widths
</bookmark_value>
47 <bookmark_value>columns; optimal widths
</bookmark_value>
48 <bookmark_value>optimal column widths
</bookmark_value>
50 <bookmark xml-lang=
"en-US" branch=
"hid/FN_TABLE_ADJUST_CELLS" id=
"bm_id2742569" localize=
"false"/><!-- HID added by script -->
51 <bookmark xml-lang=
"en-US" branch=
"hid/.uno:SetOptimalColumnWidth" id=
"bm_id3156326" localize=
"false"/>
52 <bookmark xml-lang=
"en-US" branch=
"hid/FID_COL_OPT_DIRECT" id=
"bm_id6407209" localize=
"false"/><!-- HID added by script -->
53 <bookmark xml-lang=
"en-US" branch=
"hid/.uno:SetOptimalColumnWidthDirect" id=
"bm_id3153254" localize=
"false"/>
54 <paragraph role=
"heading" id=
"hd_id3155628" xml-lang=
"en-US" level=
"1" l10n=
"U" oldref=
"1">Optimal Column Width
</paragraph>
55 <paragraph role=
"paragraph" id=
"par_id3145068" xml-lang=
"en-US" l10n=
"U" oldref=
"2"><variable id=
"optitext"><ahelp hid=
".uno:SetOptimalColumnWidthDi">Defines the optimal column width for selected columns.
</ahelp>
56 </variable> The optimal column width depends on the longest entry within a column. You can choose from the available
<link href=
"text/shared/00/00000003.xhp#metrik" name=
"measurement units">measurement units
</link>.
</paragraph>
57 <section id=
"howtoget">
58 <embed href=
"text/scalc/00/00000405.xhp#fospob"/>
60 <bookmark xml-lang=
"en-US" branch=
"hid/SC:METRICFIELD:RID_SCDLG_COL_OPT:ED_VALUE" id=
"bm_id3153192" localize=
"false"/>
61 <paragraph role=
"heading" id=
"hd_id3150767" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"3">Add
</paragraph>
62 <paragraph role=
"paragraph" id=
"par_id3150449" xml-lang=
"en-US" l10n=
"U" oldref=
"4"><ahelp hid=
"SC:METRICFIELD:RID_SCDLG_COL_OPT:ED_VALUE">Defines additional spacing between the longest entry in a column and the vertical column borders.
</ahelp></paragraph>
63 <bookmark xml-lang=
"en-US" branch=
"hid/SC:CHECKBOX:RID_SCDLG_COL_OPT:BTN_DEFVAL" id=
"bm_id3155855" localize=
"false"/>
64 <paragraph role=
"heading" id=
"hd_id3145785" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"5">Default value
</paragraph>
65 <paragraph role=
"paragraph" id=
"par_id3146120" xml-lang=
"en-US" l10n=
"U" oldref=
"6"><ahelp hid=
"SC:CHECKBOX:RID_SCDLG_COL_OPT:BTN_DEFVAL">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
0.1 in.
</paragraph>