incubator-ooo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ksch...@apache.org
Subject svn commit: r1204763 [20/45] - in /incubator/ooo/ooo-site/trunk/content/documentation: HOW_TO/ HOW_TO/data_source/ HOW_TO/data_source/link_tablehtml/ HOW_TO/drawing_graphics/ HOW_TO/files_performances/ HOW_TO/formula/ HOW_TO/img/ HOW_TO/impress/ HOW_TO...
Date Tue, 22 Nov 2011 00:55:19 GMT
Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/007.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/007.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/007.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/007.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,151 @@
+<meta http-equiv="REFRESH" content="0;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="006.html" accesskey="p">Previous</a>-<a href="008.html"
+ accesskey="n">Next</a></p>
+<h3>How do I print my spreadsheets?
+</h3>
+<p>In general, the best way to print large spreadsheets
+is to first preview the print output, then adjust the print settings to
+arrive at the desired effect. The following mini-procedures explain the
+main options for printing spreadsheets.</p>
+<p><b>Previewing the print area:</b></p>
+<ul>
+  <li>With the spreadsheet open, go to <b>File &gt; Page Preview</b>
+in the drop-down menus.</li>
+  <li>In the window that appears, use the navigation buttons on the
+tool bar to view the print. If the spreadsheet is
+too large for one page, some columns may appear on additional pages.</li>
+  <li>To close the preview window, click the <b>Close Preview</b>
+button
+to the right of the navigation buttons on the toolbar.</li>
+  <li>Make adjustments to the print settings, then preview again.
+Repeat until the print displays in the desired format.</li>
+</ul>
+<p><b><i>Note:</i></b> This command will allow you to see
+the current page number assignments for the data that you want to
+print. This is
+especially useful when only a portion of the spreadsheet is to be
+printed, or when several print ranges are associated with one Calc file.</p>
+<p><b>Formatting the page:</b></p>
+<ul>
+  <li>With the spreadsheet open, go to <b>Format &gt; Page...</b> in
+the
+drop-down menus. </li>
+  <li>In the dialog that appears, select the <b>Page</b> tab.</li>
+  <li>Set the paper size.</li>
+  <li>Specify the Orientation of the page: click on the
+checkbox next to Portrait or Landscape.</li>
+  <li>Adjust the margins, if needed.</li>
+  <li>Set the table alignment to align the table to the page.</li>
+  <li>Click <span style="font-weight: bold;">OK</span>, or click other
+tabs in this box to acess more formatting options.<br>
+  </li>
+</ul>
+<p><b>Adjusting the page breaks:</b></p>
+<ul>
+  <li>With the spreadsheet open, select <b>View &gt; Page
+Break Preview</b>.</li>
+  <li>Place the cursor exactly on top of one of the (blue) page edge
+lines, then drag each edge to adjust the page boundaries as desired.</li>
+  <li>To toggle this view off, select <b>View &gt; Page
+Break Preview</b>.</li>
+</ul>
+<p><b><i>Note:</i></b> If everything appears gray, this means that
+no print ranges are defined. If a print range is defined, the
+printing area will show up with a white background with a blue outline
+at the page boundary. A gray 'Page N', where 'N' is the page sequence
+number <i>for the sheet</i>, will appear in the middle of the print
+area. If no range is defined for printing, follow the instructions
+below.</p>
+<p><b>Setting the area to be printed:</b></p>
+<ul>
+  <li>Go to the desired sheet.</li>
+  <li>Click and drag to select (highlight) the area of the sheet to be
+printed.</li>
+  <li>In the drop-down menus, go to <b>Format &gt; Print Ranges &gt;
+Add</b>.</li>
+  <li>Repeat the above steps for each sheet of the file
+to be
+printed.</li>
+</ul>
+<p><b>Adjusting the printout to fit onto one page:</b></p>
+<ul>
+  <li>With the spreadsheet open, select <b>Format &gt; Page...</b></li>
+  <li>In the dialog that appears, select the <b>Sheet</b> tab.</li>
+  <li>In the lower right corner of the dialog, there is a <b>Reduce/enlarge
+printout</b> scale control. Enter a value that you think will make
+the data fit on the page.</li>
+  <li>Click <b>OK</b>.</li>
+  <li>Use <b>Page Preview</b> (instructions above) to see a
+preview of what will print. Readjust if necessary.</li>
+</ul>
+<p><b>Adjusting the maximum number of pages on which the print
+should fit:</b></p>
+<ul>
+  <li>With the spreadsheet open, select <b>Format &gt; Page...</b></li>
+  <li>In the dialog that appears, select the <b>Sheet</b> tab.</li>
+  <li>At bottom of the dialog there is a scale control labeled, <b>Fit
+printout on number of pages</b>. Click the checkbox
+next to
+it; then enter the desired number of pages for the printout.</li>
+  <li>Click <b>OK</b>.</li>
+  <li>Use <b>Page Preview</b> (instructions above) to see a
+preview of what will print. Readjust if necessary.</li>
+</ul>
+<p><b>Printing only a portion of the spreadsheet (a range of rows or
+columns):</b></p>
+<ul>
+  <li>In the spreadsheet where the data lives, click and drag the mouse
+over the cells to select (highlight) the rows or
+columns to be
+printed.</li>
+  <li>Select <b>Format &gt; Print Ranges</b>.</li>
+  <li>In the print dialog that appears, click the checkbox next to <b>Edit...</b>
+at lower left.</li>
+  <li>Click <b>OK</b>.</li>
+</ul>
+<p><b><i>Note:</i></b> Printing a selected range of data is also
+controlled by print scaling. If the data selected does not fit on the
+desired number
+of pages, adjust the Scale using either of the scaling procedures above
+(scale by percentage or by number of pages allowed).</p>
+<p><b>Editing the print range:</b></p>
+<ul>
+  <li>With the spreadsheet open, select <b>Format &gt; Print Ranges
+&gt; Edit</b>.</li>
+  <li>In the print dialog that appears, look at the <b>Print range</b>
+setting. It is probably set to <b>user
+defined</b> and shows a range of cells.</li>
+  <li>Adjust the cell definition in the range of cells, or select <b>None
+    </b> to clear the print range.</li>
+  <li>Click <b>OK</b>.</li>
+  <li>If there are no settings, or they are cleared, use one of the
+other methods
+shown to set your print ranges.</li>
+</ul>
+<p><b>Printing a spreadsheet in the middle of the paper:</b></p>
+<ul>
+  <li>With the spreadsheet open, select <b>Format &gt; Page...</b></li>
+  <li>In the dialog that appears, select the <b>Page</b> tab.</li>
+  <li>In the <b>Table alignment</b> section, select (or deselect as
+desired) the
+boxes next to <b>Horizontal</b> and <b>Vertical</b>. A
+visual of the
+table alignment settings will show in the small graphic on the same
+page as
+these parameters.</li>
+</ul>
+<p><b>For more information:</b></p>
+<ul>
+  <li><a
+ href="http://documentation.openoffice.org/HOW_TO/spreadsheet/calc5_EN.html">How
+to Set the Printing Settings</a> </li>
+</ul>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="006.html" accesskey="p">Previous</a>-<a href="008.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/007.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/008.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/008.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/008.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/008.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,34 @@
+<meta http-equiv="REFRESH" content="0;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="007.html" accesskey="p">Previous</a>-<a href="009.html"
+ accesskey="n">Next</a></p>
+<h3>How do I make a wide title cell extend across
+several columns in my spreadsheet?</h3>
+<p>Follow these instructions:
+</p>
+<ol>
+  <li>Select the multiple cells in which the title is to appear. Do
+this by clicking in the first cell, then hold down the mouse button and
+drag the selection box across the last cell of your chosen area.</li>
+  <li>From the pull-down menu, select <b>Format &gt; Merge Cells &gt;
+Define</b>. The cells selected in the step above now appear as one.</li>
+</ol>
+<p>Many times, the title or merged-area created needs the text centered
+or aligned within it. To do this: </p>
+<ol>
+  <li>Click on the title cell to select it.</li>
+  <li>From the pull-down menu, select <b>Format &gt; Cells</b>.</li>
+  <li>On the dialog that appears, select the <b>Alignment</b> tab.</li>
+  <li>Both the <b>Horizontal</b> and <b>Vertical</b> alignment of
+text can be set here, where other adjustments to cell text are allowed
+as well. The alignments can also be defined more simply by clicking on
+the alignment buttons on the toolbar above the spreadsheet.</li>
+</ol>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="007.html" accesskey="p">Previous</a>-<a href="009.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/008.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/009.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/009.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/009.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/009.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,33 @@
+<meta http-equiv="REFRESH" content="0;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="008.html" accesskey="p">Previous</a>-<a href="010.html"
+ accesskey="n">Next</a></p>
+<h3>How do I rotate a column title so that it fits
+above my very narrow column?</h3>
+<p> There are a few options. Follow these instructions: </p>
+<ol>
+  <li>Select the cells where you wish to rotate the text.</li>
+  <li>From the pull down menu, go to <b>Format &gt; Cells...</b></li>
+  <li>In the dialog that appears, click on the <b>Alignment</b> tab.</li>
+</ol>
+In the Text Direction section of the <b>Alignment</b> box, try these
+options:
+<ul>
+  <li>Click on the button labeled <b>ABCD</b>. (Letters on the button
+are arranged from top to bottom.) This box will arrange your title with
+the first character at the top of the cell, the second character
+underneath it, as shown in the label on the button. Click <b>OK</b> to
+see the effect.</li>
+  <li>Alternatively, drag the little dot on the circle to the bottom of
+the circle (or enter <b>270</b> in the Degrees box). This will rotate
+the text in the selected cell by 270 degrees. Click <b>OK</b> to see
+the effect. Experiment with placement of the dot to learn more.</li>
+</ul>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="008.html" accesskey="p">Previous</a>-<a href="010.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/009.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/010.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/010.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/010.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/010.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,31 @@
+<meta http-equiv="REFRESH" content="0;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="009.html" accesskey="p">Previous</a>-<a href="011.html"
+ accesskey="n">Next</a></p>
+<h3>How do I create a chart in a spreadsheet that is
+automatically updated when the data is changed?</h3>
+<p> Follow these steps:</p>
+<ol>
+  <li>From the pull down menus, select: <b>Tools &gt; Options</b>.</li>
+  <li>In the left column of the dialog that appears, select: <b>Spreadsheet
+&gt; General</b>. </li>
+  <li>On the page that appears, in the Updating section under <b>Update
+links when opening</b>, click the checkbox next to <b>Always</b>.</li>
+</ol>
+<p><b>Note:</b> This is a global setting and will affect all
+spreadsheet charts and linked information from spreadsheets. If this is
+not desirable, click the checkbox next to <b>On request</b>. With this
+selected, a dialog box will pop up when each file with links to a
+spreadsheet is opened, where you can choose whether or not to update
+the item with newer information from the linked spreadsheet.</p>
+<p><b>See also:</b> <a href="052.html">How do I extend the range of
+data shown in my chart after I add new
+data to my spreadsheet?</a></p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="009.html" accesskey="p">Previous</a>-<a href="011.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/010.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/011.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/011.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/011.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/011.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,52 @@
+<meta http-equiv="REFRESH" content="0;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="010.html" accesskey="p">Previous</a>-<a href="012.html"
+ accesskey="n">Next</a></p>
+<h3>How do I protect cells in my spreadsheet?</h3>
+<p>Cell protection is active for all cells by default.
+If only certain cells are to be protected, this setting must be turned
+off.</p>
+<ul>
+  <li>Select the entire spreadsheet. (A quick way is to click the
+little
+gray box above row 1 and to the left of column A.)</li>
+  <li>From the pull-down menus, select <b>Format &gt; Cells</b>.</li>
+  <li>In the dialog that appears, select
+the <b>Cell Protection</b> tab.</li>
+  <li>Uncheck the box next to <b>Protected</b> to
+remove the protection on all cells.</li> 
+</ul>
+<p>To select a range of cells to protect, or to select
+non-adjacent
+cells to protect:</p>
+<ul>
+  <li>Hold down the <b>Ctrl</b> key while clicking on the
+non-adjacent
+cells to highlight the ones that are to be protected.</li>
+  <li>When all of the desired cells are selected, in the pull-down
+menus, go to <b>Format &gt;
+Cells...</b></li>
+  <li>In the dialog that appears, select
+the <b>Cell Protection</b> tab.</li>
+  <li>Click on the box next to <b>Protect</b>.</li>
+  <li>Click <b>OK</b>.</li>
+</ul>
+<p>Once the cells are marked for protection, the protection
+option
+must be enabled at the sheet or spreadsheet level:</p>
+<ul>
+  <li>From the pull-down menus, select <b>Tools &gt; Protect
+Document &gt; Sheet</b> or <b>Tools &gt; Protect Document &gt; Document</b>.</li>
+  <li>In the dialog that appears, provide
+a password , then confirm it by typing it again.</li>
+  <li>Click <b>OK</b>.</li>
+  <li>The protected cells will now be uneditable.</li>
+</ul>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="010.html" accesskey="p">Previous</a>-<a href="012.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/011.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/012.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/012.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/012.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/012.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,29 @@
+<meta http-equiv="REFRESH" content="0;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="011.html" accesskey="p">Previous</a>-<a href="013.html"
+ accesskey="n">Next</a></p>
+<h3>How do I output my spreadsheet data as an ASCII,
+delimited text file?</h3>
+<p>Follow these steps:
+</p>
+<ol>
+  <li>From the pull down menus, select: <b>File &gt; Save As...</b></li>
+  <li>In the <b>Save as</b> dialog that appears, select File type <b>Text
+CSV (.csv; .txt)</b> from the list of spreadsheet file types.</li>
+  <li>Click to enable the box next to <b>Edit filter settings</b>.</li>
+  <li>Click <b>Save</b>.</li>
+  <li>In the <b>Export of text files</b> dialog box that pops up,
+enter the field and text delimiters of your choice. The default <b>Field
+delimiter</b> is <b>[Tab]</b>. The <b>Text delimiter</b> is the
+character that will surround any text entries in your spreadsheet, to
+keep each phrase together as an entity, when the file is exported into
+ASCII format.</li>
+</ol>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="011.html" accesskey="p">Previous</a>-<a href="013.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/012.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/013.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/013.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/013.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/013.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,27 @@
+<meta http-equiv="REFRESH" content="0;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="012.html" accesskey="p">Previous</a>-<a href="014.html"
+ accesskey="n">Next</a></p>
+<h3>Some of the rows in my spreadsheet are hidden. How
+do I see all the rows?</h3>
+<p>The <b>Show</b> command will cause all rows or columns in a
+selected area to be visible on the display.</p>
+<ul>
+  <li>Select the area of the spreadsheet where rows are hidden. To
+select the entire spreadsheet, go to <b>Edit &gt; Select All</b> in
+the pull-down menus, or use the <b>Control-A</b> keystroke
+combination. </li>
+  <li>To show all rows, select: <b>Format &gt; Row &gt; Show</b>.</li>
+  <li>Similarly, to show all columns, select: <b>Format &gt; Column
+&gt; Show</b>.</li>
+  <li>After the area is selected, <b>Show</b> also appears in the
+right-click menu, if only columns or rows are hidden.</li>
+</ul>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="012.html" accesskey="p">Previous</a>-<a href="014.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/013.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/014.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/014.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/014.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/014.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,23 @@
+<meta http-equiv="REFRESH" content="0;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="013.html" accesskey="p">Previous</a>-<a href="015.html"
+ accesskey="n">Next</a></p>
+<h3>How do I format cells in OpenOffice.org Spreadsheet
+so that the rows number automatically?</h3>
+<p>One method (this example assumes that you wish to put your row
+numbers in column A):</p>
+<ol>
+  <li>Enter the formula <b>=row(a1)</b> in cell A1.</li>
+  <li>Extend the cell by dragging the bottom right corner all the way
+down column A.</li>
+</ol>
+<p><b>Note:</b> If you add or insert new rows, you will have to copy
+the formula to the new cells.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="013.html" accesskey="p">Previous</a>-<a href="015.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/014.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/015.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/015.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/015.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/015.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,211 @@
+<meta http-equiv="REFRESH" content="0;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="014.html" accesskey="p">Previous</a>-<a href="016.html"
+ accesskey="n">Next</a></p>
+<h3>What do each of the error codes (Err:NNN) in
+OpenOffice.org spreadsheets mean?</h3>
+<table border="2" cellpadding="2" cellspacing="2">
+  <tbody>
+    <tr>
+      <th> Error Code </th>
+      <th> Cleartext </th>
+      <th> Explanation </th>
+    </tr>
+    <tr>
+      <td> 501 </td>
+      <td> Invalid character </td>
+      <td> The error is a character that is invalid in this context,
+e.g.
+=1Eq instead of =1E2. </td>
+    </tr>
+    <tr>
+      <td> 502 </td>
+      <td> Invalid argument </td>
+      <td> A function argument has an invalid value, e.g. a negative
+number for the root function. </td>
+    </tr>
+    <tr>
+      <td> 503 </td>
+      <td> Invalid floating point operation </td>
+      <td> Division by 0 or other calculation that would result in an
+overflow of the defined value range.</td>
+    </tr>
+    <tr>
+      <td> 504 </td>
+      <td> Parmeter list error </td>
+      <td> A function parameter is an invalid type, e.g. text instead
+of number, or domain reference instead of cell reference. </td>
+    </tr>
+    <tr>
+      <td> 505 </td>
+      <td> Internal syntax error </td>
+      <td> <br/>
+      </td>
+    </tr>
+    <tr>
+      <td> 506 </td>
+      <td> Invalid semicolon </td>
+      <td> <br/>
+      </td>
+    </tr>
+    <tr>
+      <td> 507 </td>
+      <td> Error: Pair missing </td>
+      <td> <br/>
+      </td>
+    </tr>
+    <tr>
+      <td> 508 </td>
+      <td> Error: Pair missing </td>
+      <td> For example, closing parenthesis without opening parenthesis
+or missing closing parenthesis in the middle of the formula (missing
+closing parenthesis at the end of a formula is added automatically). </td>
+    </tr>
+    <tr>
+      <td> 509 </td>
+      <td>Missing operator </td>
+      <td> E.g. =2(3+4) * operator missing between the 2 and the (. </td>
+    </tr>
+    <tr>
+      <td> 510 </td>
+      <td> Missing variable </td>
+      <td> Two operators in a row, e.g. =1+*2. </td>
+    </tr>
+    <tr>
+      <td> 511 </td>
+      <td> Missing variable </td>
+      <td> The function requires more variables than are provided, e.g.
+AND() and OR() without parameter. </td>
+    </tr>
+    <tr>
+      <td> 512 </td>
+      <td>Formula overflow </td>
+      <td> Compiler: as the name indicates, the internal number of
+tokens
+that has nothing to do with the formula string length is indicated
+(max. 512) rather than the number of operators, variables, parentheses,
+etc. Interpreter: Formulas that create several matrices at once (max.
+150), including basic functions that would receive too large an array
+as a parameter (max. 0xFFFE, i.e. 65534 bytes). </td>
+    </tr>
+    <tr>
+      <td> 513 </td>
+      <td> String overflow </td>
+      <td> Compiler: an identifier in the formula exceeds 255
+characters.
+Interpreter: a result of a string operation exceeds 255 characters. </td>
+    </tr>
+    <tr>
+      <td> 514 </td>
+      <td> Internal overflow </td>
+      <td> Sort operations with too much numerical data (max. 100000)
+or calculation stack overflow. </td>
+    </tr>
+    <tr>
+      <td> 515 </td>
+      <td>Internal syntax error </td>
+      <td> <br/>
+      </td>
+    </tr>
+    <tr>
+      <td> 516 </td>
+      <td> Internal syntax error </td>
+      <td> A matrix is expected on the calculation stack but is not
+available. </td>
+    </tr>
+    <tr>
+      <td> 517 </td>
+      <td> Internal syntax error </td>
+      <td> Unknown OpCode, e.g. a document with a newer function is
+loaded in an older version that does not contain the function. </td>
+    </tr>
+    <tr>
+      <td>518 </td>
+      <td> Internal syntax error </td>
+      <td> A variable was supposed to be popped from the calculation
+stack but is not available. </td>
+    </tr>
+    <tr>
+      <td> 519 </td>
+      <td> No result (#VALUE is in the cell rather than Err:519!) </td>
+      <td> A function could not deliver a value that corresponds to the
+definition or a cell referenced in the formula contains text rather
+than a number. </td>
+    </tr>
+    <tr>
+      <td> 520 </td>
+      <td> Internal syntax error </td>
+      <td> The compiler created an unknown compiler code. </td>
+    </tr>
+    <tr>
+      <td>521 </td>
+      <td> Internal syntax error </td>
+      <td> No result on the calculation stack. </td>
+    </tr>
+    <tr>
+      <td> 522 </td>
+      <td> Circular reference </td>
+      <td> A formula refers directly or indirectly to itself and the
+iterations are not activated under Tools/Options/Table
+Document/Calculate. </td>
+    </tr>
+    <tr>
+      <td> 523 </td>
+      <td> The calculation procedure does not converge </td>
+      <td> Some financial statistics functions miss a targeted value or
+iterations of circular references do not reach the minimum change
+within the maximum steps set. </td>
+    </tr>
+    <tr>
+      <td>524 </td>
+      <td> Invalid reference (#REF is in the cell rather than Err:524) </td>
+      <td> Compiler: a column/row description name could not be
+resolved.
+Interpreter: in the formula, a cell is referenced whose column, row or
+table was deleted. </td>
+    </tr>
+    <tr>
+      <td>525 </td>
+      <td> Invalid name (#NAME is in the cell rather than Err:525) </td>
+      <td> Compiler; An identifier could not be resolved (no reference,
+no domain name, no column/row description, no macro, etc.) Interpreter:
+same as runtime, e.g. basic function or AddIn, not found </td>
+    </tr>
+    <tr>
+      <td>526 </td>
+      <td>Internal syntax error </td>
+      <td> Obsolete, no longer used, but could come from old documents
+if the result was a formula from a domain. </td>
+    </tr>
+    <tr>
+      <td>527 </td>
+      <td>Internal overflow </td>
+      <td> Interpreter: references too encapsulated (cell references
+cell, the cell references, the cell references,...) </td>
+    </tr>
+  </tbody>
+</table>
+<p><b>Note:</b> a '###' in a cell is not an error, but an indication
+that the
+column is too narrow to display the data properly. For more information
+read <a href="002.html">I
+see '###' in a cell that formerly held data. How can
+I see my data again?</a></p>
+<p><b>Hint: </b>The error code definitions live in the Help files.</p>
+<ol>
+  <li>In an OpenOffice.org window, go to the <b>Help</b> drop-down
+menu, then select <b>Contents</b>.</li>
+  <li>Select the <b>Index</b> tab by clicking on it.</li>
+  <li>In the <b>Search</b> input box, type <b>error codes</b>. An
+index list will pop up, with "error codes" in it.</li>
+  <li>Under the error codes section in the index list, double-click on <b>OpenOffice.org
+Calc</b>. This brings up the page of calc error codes.</li>
+</ol>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="014.html" accesskey="p">Previous</a>-<a href="016.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/015.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/016.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/016.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/016.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/016.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,22 @@
+<meta http-equiv="REFRESH" content="0;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="015.html" accesskey="p">Previous</a>-<a href="017.html"
+ accesskey="n">Next</a></p>
+<h3>How can I use cells from different Calc files?</h3>
+<p>You can open the source file, select and copy onto the clipboard
+(CTRL + C) the desired cells and then in the target file you should
+select a target cell and choose <b>Edit &gt; Paste Special</b> from
+the Menu Bar and enable the link option in the choice shown in the
+dialog box that opens.</p>
+<p>A more direct way to do this is to write a formula of the following
+kind in the formula bar or in a target cell: <br>
+<b>=DDE(soffice; YourFilePath; SourceSheetName.SourceCellName)</b></p>
+<p><b> Example:</b> =DDE(soffice;c:\myfile.sxi;MySheet.A1) </p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="015.html" accesskey="p">Previous</a>-<a href="017.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/016.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/017.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/017.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/017.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/017.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,31 @@
+<meta http-equiv="REFRESH" content="0;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="016.html" accesskey="p">Previous</a>-<a href="018.html"
+ accesskey="n">Next</a></p>
+<h3>How I change the order of sheets in my spreadsheet?</h3>
+<p>The simplest method to move a sheet is to grab its tab with the
+mouse, click on the tab with the mouse and hold the mouse button down,
+then drag the tab to its new position amongst the other tabs in the
+workbook. There are other methods to move (or copy) sheets too:</p>
+<ol>
+  <li>Select the sheet you want to move.</li>
+  <li>While still positioned over the sheet tab, click the right mouse
+button to access the context menu, then choose <b>Move/Copy Sheet...</b>,
+or in the pull-down menus go to <b>Edit &gt; Sheet &gt; Move/Copy...</b></li>
+  <li>In the Move/Copy dialog that appears, be sure that the check box
+labeled <b>Copy</b> is not set unintentionally. Place a tick at <b>Copy</b>
+only if you wish to copy the sheet instead of move it.</li>
+  <li>Specify where to move the sheet in the Move/Copy pop-up box.
+Select an open document from the drop down menu labeled <b>To document</b>.
+Choose the position of the sheet in that document from the drop-down
+menu labeled <b>Insert before</b>.</li>
+  <li>Click <b>OK</b>.</li>
+</ol>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="016.html" accesskey="p">Previous</a>-<a href="018.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/017.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/018.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/018.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/018.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/018.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,20 @@
+<meta http-equiv="REFRESH" content="0;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="017.html" accesskey="p">Previous</a>-<a href="019.html"
+ accesskey="n">Next</a></p>
+<h3>How can I rename a sheet?</h3>
+<ol>
+  <li>Select the sheet to be renamed. </li>
+  <li>While still positioned over the sheet tab, click the right mouse
+button to access the context menu, then choose <b>Rename Sheet...</b>.</li>
+  <li>Enter the new name.</li>
+  <li>Click <b>OK</b>.</li>
+</ol>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="017.html" accesskey="p">Previous</a>-<a href="019.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/018.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/019.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/019.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/019.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/019.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,24 @@
+<meta http-equiv="REFRESH" content="0;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="018.html" accesskey="p">Previous</a>-<a href="020.html"
+ accesskey="n">Next</a></p>
+<h3>How is a variable date inserted into a spreadsheet
+cell?</h3>
+<p>Insert a function into a cell by following these instructions:</p>
+<ol>
+  <li>Select the cell that will hold the function.</li>
+  <li>From the pull-down menus, select <b>Insert &gt; Function</b>.</li>
+  <li>Pick <b>Date&amp;Time</b> as the <b>Category</b>.</li>
+  <li>Double-click the<b>Today</b> function for the current date, or
+double-click the <b>Now</b> function for the current date and time.</li>
+  <li>Click <b>OK</b>. The cell should now contain the selected
+function.</li>
+</ol>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="018.html" accesskey="p">Previous</a>-<a href="020.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/019.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/020.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/020.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/020.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/020.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,31 @@
+<meta http-equiv="REFRESH" content="0;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="019.html" accesskey="p">Previous</a>-<a href="021.html"
+ accesskey="n">Next</a></p>
+<h3>How are thick lines or borders created around my
+cells?</h3>
+<p>Creating a border:</p>
+<ol>
+  <li>Select the cells where you wish to apply a border.</li>
+  <li>From the pull-down menus, select <b>Format &gt; Cells...</b>
+then click on the <b>Borders</b> tab.</li>
+  <li>In the <b>Line Arrangement</b> section, under <b>Default</b>,
+click on the icon that best shows the style of border you wish to use,
+or</li>
+  <li>Under <b>User Defined</b>, select custom border styles by
+clicking on the individual lines shown bordering four 'dummy' cells.</li>
+</ol>
+<p>Changing the width of a border:</p>
+<ol>
+  <li>In the <b>Line</b> section, under <b>Style</b>, click on the
+desired line for your border, and</li>
+  <li>Under <b>Color</b>, choose the desired color for your border.</li>
+</ol>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="019.html" accesskey="p">Previous</a>-<a href="021.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/020.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/021.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/021.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/021.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/021.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,37 @@
+<meta http-equiv="REFRESH" content="0;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="020.html" accesskey="p">Previous</a>-<a href="022.html"
+ accesskey="n">Next</a></p>
+<h3>How do I insert a page number in the form of 'Page
+1 of N' on each page of a spreadsheet?</h3>
+<p>Page numbers can be inserted into the header or footer sections of a
+spreadsheet. These will be visible only in the Page Preview mode and on
+the print. The page numbers will not be visible on, nor are they
+related to, the calc sheets themselves. The page numbers reflect the
+defined print areas of the workbook. To insert page numbers, follow
+these instructions:</p>
+<ul>
+  <li>From the pull-down menus, select <b>Edit &gt; Headers &amp;
+Footers...</b></li>
+  <li>Select either the Header tab or the Footer tab.</li>
+  <li>Click in the area where the page number blurb will display (Left,
+Center, or Right) to place the cursor inside the box.</li>
+  <li>Type <b>Page</b>, then add one space character.</li>
+  <li>The available data fields are represented by a row of icons below
+the left, center, and right input areas. Click on the document icon
+with ONE number sign [ # ] to insert the page number field. </li>
+  <li>Type a space, <b>of</b>, and another space.</li>
+  <li>Click on the document icon with TWO number signs [ ## ] to insert
+the page total field.</li>
+  <li>Click <b>OK</b>.</li>
+</ul>
+<p><b>Note:</b> The data fields available int the header and footer
+settings are the only data fields and formats available in spreadsheets.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="020.html" accesskey="p">Previous</a>-<a href="022.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/021.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/022.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/022.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/022.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/022.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,27 @@
+<meta http-equiv="REFRESH" content="0;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="021.html" accesskey="p">Previous</a>-<a href="023.html"
+ accesskey="n">Next</a></p>
+<h3>A large OpenOffice.org spreadsheet was converted
+from another application. Some of my rows are missing! What happened?</h3>
+<p>OpenOffice.org spreadsheets supports 32,000 rows, maximum.
+Spreadsheets converted from other applications that contain more than
+32,000 rows will be truncated.</p>
+<p><b>Hint:</b> Split large spreadsheets from other applications into
+smaller worksheets, so that each has fewer than 32,000 rows prior to
+converting them. A range containing fewer than 32,000 rows will convert
+correctly.</p>
+<p><b>For more information:</b>
+</p>
+<ul>
+  <li><a href="023.html">What
+is the maximum number of cells in an OpenOffice.org spreadsheet?</a></li>
+</ul>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="021.html" accesskey="p">Previous</a>-<a href="023.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/022.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/023.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/023.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/023.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/023.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,24 @@
+<meta http-equiv="REFRESH" content="0;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="022.html" accesskey="p">Previous</a>-<a href="024.html"
+ accesskey="n">Next</a></p>
+<h3>What is the maximum number of cells in an
+OpenOffice.org spreadsheet?</h3>
+<p>The maximum number of rows per sheet is 32,000. The maximum number
+of columns per sheet is 256. The maximum number of cells per sheet is
+8,192,000. And the maximum number of sheets per workbook is 256.</p>
+<p><b>Where this can be a hindrance:</b>
+</p>
+<ul>
+  <li><a href="022.html">A
+large OpenOffice.org spreadsheet was converted from another
+application. Some of my rows are missing! What happened?</a></li>
+</ul>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="022.html" accesskey="p">Previous</a>-<a href="024.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/023.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/024.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/024.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/024.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/024.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,40 @@
+<meta http-equiv="REFRESH" content="0;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="023.html" accesskey="p">Previous</a>-<a href="025.html"
+ accesskey="n">Next</a></p>
+<h3>How do I insert superscript or subscript text in my
+spreadsheet?</h3>
+<p>There are several possible paths to alter characters:</p>
+<ol>
+  <li>Select the individual character(s) to be made
+superscript/subscript. To do this, click on the cell where the text
+resides. Now at the input line above the spreadsheet, select the
+characters to be altered by clicking before the first one with the
+mouse, then drag the highlight box over the character(s) you want to
+change, and release the mouse button. The character(s) you wish to
+change should now be highlighted. </li>
+  <li>In the pull-down menus, go to <b>Format &gt; Character...</b>,
+or click with the right mouse button (right-click) and select <b>Character...</b>
+from the pop-up menu.</li>
+  <li>Click on the <b>Font Position</b> tab.</li>
+  <li>Click so that a dot appears near your choice of <b>Superscript</b>
+or <b>Subscript</b>. There are other adjustments included there if you
+need them, but the defaults work ok too.</li>
+</ol>
+<p>To access this feature via keyboard commands, select the text to be
+altered, then use the the following keystroke combinations:</p>
+<ul>
+  <li>for Superscript use: <b>CTRL</b> + <b>SHIFT</b> + <b>P</b></li>
+  <li>for Subscript use: <b>CTRL</b> + <b>SHIFT</b> + <b>B</b></li>
+</ul>
+<p>These commands also work for the word processor.</p>
+<p><b>Note:</b> Cell height may require an adjustment to accommodate
+the new character.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="023.html" accesskey="p">Previous</a>-<a href="025.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/024.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/025.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/025.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/025.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/025.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,20 @@
+<meta http-equiv="REFRESH" content="0;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="024.html" accesskey="p">Previous</a>-<a href="026.html"
+ accesskey="n">Next</a></p>
+<p><b>Is it possible to open an Excel file that is protected by a
+password in Calc?</b></p>
+<p>With 1.1.x releases of OpenOffice.org, it is not possible to do this directly. Such a file can be opened
+from Calc only if you remove the password using the original
+application.</p>
+<p>
+2.x versions of OpenOffice.org, will open these with the password.
+</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="024.html" accesskey="p">Previous</a>-<a href="026.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/025.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/026.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/026.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/026.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/026.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,26 @@
+<meta http-equiv="REFRESH" content="0;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="025.html" accesskey="p">Previous</a>-<a href="027.html"
+ accesskey="n">Next</a></p>
+<p><b>How can I use decimal signs (dots) instead of commas to display
+rational figures?</b></p>
+<p>In some localized Windows OSes such as the French and Italian ones,
+the rational figures and numbers are displayed, by system default,
+using a comma. It is possible to avoid this behavior:</p>
+<ol>
+  <li> from the Menu Bar. </li>
+  <li> Tab of the pop-up window that will appear, change the language
+option to English. </li>
+</ol>
+<p>Another way to obtain the same result is to right click on the cell
+and choose the <b>'Format Cell' </b>quick menu option, displaying the
+pop-up cell properties window. Afterwards, follow the procedure
+described above.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="025.html" accesskey="p">Previous</a>-<a href="027.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/026.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/027.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/027.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/027.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/027.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,22 @@
+<meta http-equiv="REFRESH" content="0;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="026.html" accesskey="p">Previous</a>-<a href="028.html"
+ accesskey="n">Next</a></p>
+<h3>I want to select two cells that are not adjacent, but holding down
+the CTRL key does not seem to work. How can I perform this action?</h3>
+<p>If you click in a cell, it is not selected, but focused. To select a
+cell:</p>
+<ul>
+  <li>Hold down the <b>SHIFT</b> key and then click on the cell.</li>
+  <li>After having done so, you'll be able to select multiple
+non-adjacent cells, by holding down the <b>CTRL</b> key as you select
+new cells.</li>
+</ul>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="026.html" accesskey="p">Previous</a>-<a href="028.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/027.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/028.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/028.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/028.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/028.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,42 @@
+<meta http-equiv="REFRESH" content="0;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="027.html" accesskey="p">Previous</a>-<a href="029.html"
+ accesskey="n">Next</a></p>
+<h3>How can I create my own sort lists?
+</h3>
+<p>Sometimes it is useful to use sort lists to control the order of
+your data, especially if the data is better sorted in an order that is
+not alphabetical or numerical. Examples of this are the days of the
+week or the months of the year. Sort lists can be used to fill data
+into cells too.</p>
+<p><b>To automatically fill data into cells from sort lists:</b></p>
+<ol>
+  <li>Insert a
+day of the week, or other list item, into a cell.</li>
+  <li>Next, select this cell, then drag the black square at the lower
+right
+corner across other cells in the same row or column.</li>
+  <li>The other days of the week, or other items in the list related to
+the word chosen the first step will
+automatically fill into the selected cells.</li>
+</ol>
+<p><b>To create your own sort list:</b></p>
+<ol>
+  <li>Using the drop-down menu, go to <b>Tools &gt; Options</b>.</li>
+  <li>In the left column expand <b>Spreadsheet</b> and go to <b>Sort
+Lists</b>.</li>
+  <li>In the pop-up window that will appear, select <b>New</b>.</li>
+  <li>Under Entries, type your list, in the order you want, and
+separate each word by a comma. Do not use spaces.</li>
+  <li>When your list is complete, click <b>Add</b>.</li>
+  <li>To learn more, click the <b>Help</b> button in the sort list
+options box.</li>
+</ol>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="027.html" accesskey="p">Previous</a>-<a href="029.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/028.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/029.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/029.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/029.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/029.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,48 @@
+<meta http-equiv="REFRESH" content="0;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="028.html" accesskey="p">Previous</a>-<a href="030.html"
+ accesskey="n">Next</a></p>
+<h3>Is there any way to merge a text file with separated fields (*.txt,
+*.csv) into a Calc file?</h3>
+<p>Text files cannot be inserted into a Calc spreadsheet, because a
+table or range must be specified in this OOo feature. For text files,
+use the <b>Import</b> feature instead. Reference <a href="001.html">How
+do I open a tab-delimited text file in a Calc spreadsheet?</a> for more
+information.</p>
+<p>External data in formats that include tables or ranges, such as web
+pages and spreadsheets, <i>can</i> be inserted into a Calc worksheet.
+It looks like a cool feature. I'm just learning about it too!
+</p>
+<ol>
+  <li>Open a new calc sheet, and choose <b>Insert &gt; External Data...</b>
+from the Menu Bar.</li>
+  <li>In the <b>External Data</b> pop-up window that appears, click
+the <b>[...]</b> radio button. This pulls up yet another pop-up box,
+entitled <b>Insert</b>.
+  <ul>
+    <li>Browse to the file, and click on it so that its name appears in
+the <b>File name</b> field.</li>
+    <li>In the <b>File type</b> field, select the file format that
+matches that of the file with the table in it. </li>
+    <li>Click <b>Insert</b>. This brings back the <b>External Data</b>
+pop-up box.</li>
+  </ul>
+</li>
+  <li>Now in the <b>Available Tables/Ranges</b> section of the <b>External
+Data</b> pop-up box, a list of tables and ranges appears. Click on a
+range to select it.</li>
+  <li>Once a table or range is selected, you can click <b>OK</b> to
+import the data to the Calc sheet.</li>
+
+</ol>
+<p>There is an update control option available too. Click on the <b>Help</b>
+button to see a blurb about it, and play with it to learn more. If you
+can add more details to this FAQ about it, please do! </p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="028.html" accesskey="p">Previous</a>-<a href="030.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/029.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/030.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/030.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/030.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/030.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,24 @@
+<meta http-equiv="REFRESH" content="0;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="029.html" accesskey="p">Previous</a>-<a href="031.html"
+ accesskey="n">Next</a></p>
+<h3>How can I wrap text within a cell?
+</h3>
+<p>To wrap text within a cell, or merged set of cells: </p>
+<ol>
+  <li>Select a cell or group of cells. </li>
+  <li>Right-click the selected area and go to <b>Format cells...</b>,
+or in the pull-down menus, go to <b>Format &gt; Cells...</b></li>
+  <li>Click on the <b>Alignment</b> tab.</li>
+  <li>Under the Properties section, tick <b>Automatic line break</b>.</li>
+  <li>Click <b>OK</b>.</li>
+</ol>
+Now the contents of the cell will be wrapped to fit the cell.
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="029.html" accesskey="p">Previous</a>-<a href="031.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/030.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/031.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/031.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/031.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/031.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,36 @@
+<meta http-equiv="REFRESH" content="0;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>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/031.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/032.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/032.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/032.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/032.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,18 @@
+<meta http-equiv="REFRESH" content="0;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="031.html" accesskey="p">Previous</a>-<a href="033.html"
+ accesskey="n">Next</a></p>
+<h3>In MS Excel I can center my text so that the text will flow both to
+the left and right if the cells are empty; how can I do this in Calc?
+</h3>
+<p>It is possible in Calc for the text to flow across empty cells on
+the right side of a cell. However text flow outside of the left edge of
+a cell is not yet supported in Calc.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="031.html" accesskey="p">Previous</a>-<a href="033.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/032.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/033.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/033.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/033.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/033.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,16 @@
+<meta http-equiv="REFRESH" content="0;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="032.html" accesskey="p">Previous</a>-<a href="034.html"
+ accesskey="n">Next</a></p>
+<h3>How do I use styles and formatting?</h3>
+<p>The documentation project has provided a document for this entitled <a
+ href="http://documentation.openoffice.org/HOW_TO/spreadsheet/calc4_EN.html">How
+to Format a Spreadsheet</a>.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="032.html" accesskey="p">Previous</a>-<a href="034.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/033.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/034.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/034.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/034.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/034.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,27 @@
+<meta http-equiv="REFRESH" content="0;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="033.html" accesskey="p">Previous</a>-<a href="035.html"
+ accesskey="n">Next</a></p>
+<h3>Can I use a spreadsheet file with more than 32,000 rows?
+</h3>
+<p>The current stable releases of Calc allow a maximum of 65536 rows.
+However, with the 1.1.x release, this is well known, and it is a limitation in comparison to Microsoft
+Office 2000.
+</p>
+<p>So, if you use 1.1.x, the 32000 limit may a real problem for your application. Nonetheless, there are
+a few options to consider. Frequently when you are hitting the row
+limit, it is a symptom of a spreadsheet design which could be improved:</p>
+<ul>
+  <li>Restructure the rows. Split the data into several files or
+several spreadsheets within one file.</li>
+  <li>Use a real database. This is the most frequent thing people are
+trying to accomplish by having such a large number of rows in a sheet.</li>
+</ul>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="033.html" accesskey="p">Previous</a>-<a href="035.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/034.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/035.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/035.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/035.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/035.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,17 @@
+<meta http-equiv="REFRESH" content="0;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="034.html" accesskey="p">Previous</a>-<a href="036.html"
+ accesskey="n">Next</a></p>
+<h3>My formula from an Excel worksheet doesn't work!
+</h3>
+<p>This can be caused by many reasons, with the most common reason
+being that OpenOffice.org uses semi-colons (;) between arguments,
+instead of commas (,) like in Excel.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="034.html" accesskey="p">Previous</a>-<a href="036.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/035.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/036.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/036.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/036.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/036.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,31 @@
+<meta http-equiv="REFRESH" content="0;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="035.html" accesskey="p">Previous</a>-<a href="037.html"
+ accesskey="n">Next</a></p>
+<h3>Why does Calc refuse to open my text file?
+</h3>
+<p>A text file must be imported into Calc using <b>.csv</b> or <b>.txt</b>
+format. Otherwise, the file will automatically open in Writer.</p>
+<ol>
+  <li>Rename the file so that it uses the .csv file extension. </li>
+  <li>In the <b>File &gt; Open</b> dialog, set the <b>File type</b>
+field
+to <b>Text CSV</b>. This is quite a way down in the list so it is easy
+to miss. It is grouped with the spreadsheet file types. </li>
+</ol>
+<p><b>For more information:</b></p>
+<ul>
+  <li>In the pull-down menus, go to <b>Help &gt; Contents &gt; Index</b>
+and type <b>csv files;spreadsheets</b> in the <b>Search term</b>
+input bar.</li>
+  <li><a href="001.html">How
+do I open a tab-delimited file in a Calc spreadsheet?</a></li>
+</ul>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="035.html" accesskey="p">Previous</a>-<a href="037.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/036.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/037.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/037.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/037.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/037.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,24 @@
+<meta http-equiv="REFRESH" content="0;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="036.html" accesskey="p">Previous</a>-<a href="038.html"
+ accesskey="n">Next</a></p>
+<h3>How do I add trailing characters to a cell?</h3>
+<p>If what you have are index numbers like "DCP_5509" in column B and
+you want to add a common suffix like "myparty.jpg" to the end of this
+existing data, then enter the function <b>=CONCATENATE(B1;"myparty.jpg")</b>
+into a new cell that will show the index number from cell B1 with the
+new suffix attached. Next, apply this function to the rest of the cells
+in the new column. Copy the first cell in the new column, then paste it
+to the remaining cells in that column. Now the new column displays
+"DCP_5509myparty.jpg" and the like.</p>
+<p><b>Note: </b>Alter the function to <b>=CONCATENATE("myparty.jpg";B1)</b>
+to add the additional characters as a prefix to the existing data from
+cell B1.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="036.html" accesskey="p">Previous</a>-<a href="038.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/037.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/038.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/038.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/038.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/038.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,20 @@
+<meta http-equiv="REFRESH" content="0;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="037.html" accesskey="p">Previous</a>-<a href="039.html"
+ accesskey="n">Next</a></p>
+<h3>How are notes within cells displayed?</h3>
+<p>To create a Note for a cell, use <b>Insert &gt; Note</b>. The Note
+can be set to show permanently: do a right-click in the cell, then
+select <b>Show Note</b>. The note can also be set to display when
+hovering over the cell, if the Tips selection is enabled: Click on <b>Help
+&gt; Tips</b>. As long as the tick is displayed next to Tips, notes for
+cells will always be displayed when the mouse hovers over cells with
+notes.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="037.html" accesskey="p">Previous</a>-<a href="039.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/038.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/039.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/039.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/039.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/039.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,19 @@
+<meta http-equiv="REFRESH" content="0;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="038.html" accesskey="p">Previous</a>-<a href="040.html"
+ accesskey="n">Next</a></p>
+<h3>Why does deleting filtered rows remove other rows too?</h3>
+<p>When using Calc filters, selections that span a range of cells
+include filtered and hidden rows. Deleting a range of rows with a
+filter enabled will delete all rows in that range, whether they are
+visible or hidden, not just the visible rows. To select multiple rows
+individually, select the first row, then use Ctrl+click to select each
+additional row.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="038.html" accesskey="p">Previous</a>-<a href="040.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/039.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/040.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/040.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/040.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/040.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,15 @@
+<meta http-equiv="REFRESH" content="0;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="039.html" accesskey="p">Previous</a>-<a href="041.html"
+ accesskey="n">Next</a></p>
+<h3>How can I start Calc instead of Writer?</h3>
+<p>By passing <b>-calc</b> as an argument on the command line when
+executing openoffice.org.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="039.html" accesskey="p">Previous</a>-<a href="041.html"
+ accesskey="n">Next</a></p>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/040.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/041.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/041.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/041.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/faqs/spreadsheet/041.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,20 @@
+<meta http-equiv="REFRESH" content="0;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="040.html" accesskey="p">Previous</a>-<a href="042.html"
+ accesskey="n">Next</a></p>
+<h3>Why does Calc print out all the sheets in the file?</h3>
+<p>By default, Calc is configured to do just that. But the setting can
+be changed so that only the current sheet is printed too. Go to <b>File
+&gt; Print &gt; Options</b> and then tick the box labeled <b>Print
+only selected sheets for Document</b>. To make the change permanent for
+all occurrences of OOo Calc, go to <b>Tools &gt; Options &gt;
+Spreadsheet &gt; Print</b> and select the same option: <b>Print only
+selected sheets for Document</b>.</p>
+<p><a href="../../index.html">Documentation</a> / <a
+ href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
+ href="040.html" accesskey="p">Previous</a>-<a href="042.html"
+ accesskey="n">Next</a></p>



Mime
View raw message