content/documentation/faqs/spreadsheet/031.html

<meta http-equiv="REFRESH" content="10;url=http://wiki.services.openoffice.org/wiki/Documentation/FAQ">
<h3>This page is outdated. You will be redirected to <a href="http://wiki.services.openoffice.org/wiki/Documentation/FAQ">http://wiki.services.openoffice.org
/wiki/Documentation/FAQ</a> shortly.</h3>
<div style="margin-bottom: 10em;"></div>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="030.html" accesskey="p">Previous</a>-<a href="032.html"
 accesskey="n">Next</a></p>
<h3>If a cell is centre-justified, and the text is wider than the cell,
it automatically left-justifies. Can I fix this?
</h3>
<p>This is a known bug in Calc that is shown in Issue <a
 href="http://www.openoffice.org/issues/show_bug.cgi?id=1171">#1171</a>.
This
problem is fixed in the OOo1.9m26 developer snapshot version of
OpenOffice.org and will be available in the stable version of
OpenOffice.org 2.0.
To obtain the latest versions of OOo, visit the <a
 href="http://download.openoffice.org/index.html">Download Central</a>
page.</p>
<p><b>Note there is a work-around:</b></p>
<ol>
  <li>Merge the cell with adjacent cells: Select the cells you wish to
merge, then select <b>Format &gt; Merge Cells... &gt; Define</b> from
the drop-down menus.</li>
  <li>Center the data in the merge cell: Click the <b>Align Center
Horizontally</b> button
on the tool bar, or use the drop-down menus to select <b> Format &gt;
Cell</b>, click the <b>Alignment</b>
tab, then choose <b>Center</b> from the <b>Horizontal</b> drop-down
menu in the <b>Text alignment</b> section.</li>
</ol>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="030.html" accesskey="p">Previous</a>-<a href="032.html"
 accesskey="n">Next</a></p>