diff options
| author | Vladimir Glazounov <vg@openoffice.org> | 2008-11-26 15:57:11 +0000 |
|---|---|---|
| committer | Vladimir Glazounov <vg@openoffice.org> | 2008-11-26 15:57:11 +0000 |
| commit | 5ccd1d319b38120437fe69a3b6884e00cf22ee4e (patch) | |
| tree | 3fbc437a38c99a98250c39533659836eeae1c4c9 /helpcontent2/source/text/scalc/guide | |
| parent | CWS-TOOLING: integrate CWS rtlchart01 (diff) | |
| download | help-5ccd1d319b38120437fe69a3b6884e00cf22ee4e.tar.gz help-5ccd1d319b38120437fe69a3b6884e00cf22ee4e.zip | |
CWS-TOOLING: integrate CWS hcshared19
Diffstat (limited to 'helpcontent2/source/text/scalc/guide')
21 files changed, 185 insertions, 185 deletions
diff --git a/helpcontent2/source/text/scalc/guide/auto_off.xhp b/helpcontent2/source/text/scalc/guide/auto_off.xhp index ad26d12abd..946c53516d 100755 --- a/helpcontent2/source/text/scalc/guide/auto_off.xhp +++ b/helpcontent2/source/text/scalc/guide/auto_off.xhp @@ -1,8 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: auto_off.xhp,v $ - * $Revision: 1.8 $ + * $Revision: 1.8.4.1 $ * * This file is part of OpenOffice.org. * @@ -32,17 +32,13 @@ * ************************************************************************ --> + -<helpdocument version="1.0"> <meta> -<topic id="textscalcguideauto_offxml" indexer="include" status="PUBLISH"> +<topic id="textscalcguideauto_offxml" indexer="include"> <title id="tit" xml-lang="en-US">Deactivating Automatic Changes</title> <filename>/text/scalc/guide/auto_off.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-02-07T10:52:24">converted from old format - fpe</lastedited> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3149456"><bookmark_value>deactivating; automatic changes</bookmark_value> @@ -59,15 +55,15 @@ <bookmark_value>date formats;avoiding conversion to</bookmark_value> <bookmark_value>number completion on/off</bookmark_value> <bookmark_value>text completion on/off</bookmark_value> -</bookmark> +<bookmark_value>word completion on/off</bookmark_value> +</bookmark><comment>mw added one entry</comment> <paragraph role="heading" id="hd_id3149456" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="auto_off"><link href="text/scalc/guide/auto_off.xhp" name="Deactivating Automatic Changes">Deactivating Automatic Changes</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3156442" xml-lang="en-US" l10n="U" oldref="2">By default, $[officename] automatically corrects many common typing errors and applies formatting while you type. You can immediately undo any automatic changes with <switchinline select="sys"><caseinline select="MAC">Command -</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Z.</paragraph> +<paragraph role="paragraph" id="par_id3156442" xml-lang="en-US" l10n="U" oldref="2">By default, $[officename] automatically corrects many common typing errors and applies formatting while you type. You can immediately undo any automatic changes with <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Z.</paragraph> <paragraph role="paragraph" id="par_id3145273" xml-lang="en-US" l10n="U" oldref="3">The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc:</paragraph> <paragraph role="heading" id="hd_id3145748" xml-lang="en-US" level="2" l10n="U" oldref="4">Automatic text or number completion</paragraph> <paragraph role="paragraph" id="par_id3154730" xml-lang="en-US" l10n="U" oldref="5">When making an entry in a cell, $[officename] Calc automatically suggests matching input found in the same column. This function is known as <emph>AutoInput</emph>.</paragraph> -<list type="unordered"> +<list type="ordered"> <listitem> <paragraph role="listitem" id="par_id3153878" xml-lang="en-US" l10n="U" oldref="6">To turn the AutoInput on and off, set or remove the check mark in front of <link href="text/scalc/01/06130000.xhp" name="Tools - Cell Contents - AutoInput"><emph>Tools - Cell Contents - AutoInput</emph></link>.</paragraph> </listitem> diff --git a/helpcontent2/source/text/scalc/guide/background.xhp b/helpcontent2/source/text/scalc/guide/background.xhp index 92247a5dc1..502569fc6e 100644 --- a/helpcontent2/source/text/scalc/guide/background.xhp +++ b/helpcontent2/source/text/scalc/guide/background.xhp @@ -1,9 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -12,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: background.xhp,v $ - * $Revision: 1.4 $ + * $Revision: 1.4.4.1 $ * * This file is part of OpenOffice.org. * @@ -33,58 +32,52 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textscalcguidebackgroundxhp" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Defining Background Colors or Background Graphics</title> +<topic id="textscalcguidebackgroundxhp" indexer="include"> +<title id="tit" xml-lang="en-US">Defining Background Colors or Background Graphics</title> <filename>/text/scalc/guide/background.xhp</filename> </topic> </meta> <body> - - - <bookmark xml-lang="en-US" branch="index" id="bm_id3149346"><bookmark_value>spreadsheets; backgrounds</bookmark_value> <bookmark_value>backgrounds;cell ranges</bookmark_value> <bookmark_value>tables; backgrounds</bookmark_value> <bookmark_value>cells; backgrounds</bookmark_value> -</bookmark> - <comment>MW transferred 3 entries from shared/guide/background.xhp and added a new entry</comment> - <paragraph xml-lang="en-US" id="hd_id3149346" role="heading" level="1" l10n="U" oldref="1"><variable id="background"><link href="text/scalc/guide/background.xhp" name="Defining Background Colors or Background Graphics">Defining Background Colors or Background Graphics</link> -</variable></paragraph> - <comment>MW created this file from splitting shared/guide/background.xhp</comment> - <paragraph xml-lang="en-US" id="par_id9520249" role="paragraph" l10n="NEW">You can define a background color or use a graphic as a background for cell ranges in $[officename] Calc.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3144760" role="heading" level="2" l10n="U" oldref="16">Applying a Background Color to a $[officename] Calc Spreadsheet</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id3155429" role="listitem" l10n="U" oldref="17">Select the cells.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3149260" role="listitem" l10n="U" oldref="18">Choose <emph>Format - Cells</emph> (or <emph>Format Cells</emph> from the context menu).</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3152938" role="listitem" l10n="U" oldref="19">On the <emph>Background</emph> tab page, select the background color.</paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="hd_id3146974" role="heading" level="2" l10n="U" oldref="20">Graphics in the Background of Cells</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id3155414" role="listitem" l10n="CHG" oldref="21">Choose <emph>Insert - Picture - From File</emph>.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3149664" role="listitem" l10n="U" oldref="22">Select the graphic and click <emph>Open</emph>.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153575" role="listitem" l10n="U" oldref="23">The graphic is inserted anchored to the current cell. You can move and scale the graphic as you want. In your context menu you can use the <emph>Arrange - To Background</emph> command to place this in the background. To select a graphic that has been placed in the background, use the <switchinline select="appl"><caseinline select="CALC"><link href="text/scalc/01/02110000.xhp" name="Navigator">Navigator</link> +<bookmark_value>rows, see also cells</bookmark_value> +<bookmark_value>columns, see also cells</bookmark_value> +</bookmark><comment>** Expression is faulty **</comment> +<paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="background"><link href="text/scalc/guide/background.xhp" name="Defining Background Colors or Background Graphics">Defining Background Colors or Background Graphics</link> +</variable></paragraph><comment>MW created this file from splitting shared/guide/background.xhp</comment> +<paragraph role="paragraph" id="par_id9520249" xml-lang="en-US" l10n="NEW">You can define a background color or use a graphic as a background for cell ranges in $[officename] Calc.</paragraph> +<paragraph role="heading" id="hd_id3144760" xml-lang="en-US" level="2" l10n="U" oldref="16">Applying a Background Color to a $[officename] Calc Spreadsheet</paragraph> +<list type="ordered"> +<listitem> +<paragraph role="listitem" id="par_id3155429" xml-lang="en-US" l10n="U" oldref="17">Select the cells.</paragraph> +</listitem> +<listitem> +<paragraph role="listitem" id="par_id3149260" xml-lang="en-US" l10n="U" oldref="18">Choose <emph>Format - Cells</emph> (or <emph>Format Cells</emph> from the context menu).</paragraph> +</listitem> +<listitem> +<paragraph role="listitem" id="par_id3152938" xml-lang="en-US" l10n="U" oldref="19">On the <emph>Background</emph> tab page, select the background color.</paragraph> +</listitem> +</list> +<paragraph role="heading" id="hd_id3146974" xml-lang="en-US" level="2" l10n="U" oldref="20">Graphics in the Background of Cells</paragraph> +<list type="ordered"> +<listitem> +<paragraph role="listitem" id="par_id3155414" xml-lang="en-US" l10n="CHG" oldref="21">Choose <emph>Insert - Picture - From File</emph>.</paragraph> +</listitem> +<listitem> +<paragraph role="listitem" id="par_id3149664" xml-lang="en-US" l10n="U" oldref="22">Select the graphic and click <emph>Open</emph>.</paragraph> +<paragraph role="listitem" id="par_id3153575" xml-lang="en-US" l10n="U" oldref="23">The graphic is inserted anchored to the current cell. You can move and scale the graphic as you want. In your context menu you can use the <emph>Arrange - To Background</emph> command to place this in the background. To select a graphic that has been placed in the background, use the <switchinline select="appl"><caseinline select="CALC"><link href="text/scalc/01/02110000.xhp" name="Navigator">Navigator</link> </caseinline><defaultinline>Navigator</defaultinline></switchinline>.</paragraph> - </listitem> - </list> - <section id="relatedtopics"> - - <paragraph xml-lang="en-US" id="par_id51576" role="paragraph" l10n="NEW"><link href="text/shared/guide/background.xhp">Watermarks</link></paragraph> - <paragraph xml-lang="en-US" id="par_id3156180" role="paragraph" l10n="U" oldref="30"><link href="text/shared/01/05030600.xhp" name="Background tab page"><emph>Background</emph> tab page</link></paragraph> - <paragraph xml-lang="en-US" id="par_id7601245" role="paragraph" l10n="NEW"><link href="text/scalc/guide/format_table.xhp">Formatting Spreadsheets</link></paragraph> - - </section> - </body> +</listitem> +</list> +<section id="relatedtopics"> +<paragraph role="paragraph" id="par_id51576" xml-lang="en-US" l10n="NEW"><link href="text/shared/guide/background.xhp">Watermarks</link></paragraph> +<paragraph role="paragraph" id="par_id3156180" xml-lang="en-US" l10n="U" oldref="30"><link href="text/shared/01/05030600.xhp" name="Background tab page"><emph>Background</emph> tab page</link></paragraph> +<paragraph role="paragraph" id="par_id7601245" xml-lang="en-US" l10n="NEW"><link href="text/scalc/guide/format_table.xhp">Formatting Spreadsheets</link></paragraph> +</section> +</body> </helpdocument> diff --git a/helpcontent2/source/text/scalc/guide/calc_series.xhp b/helpcontent2/source/text/scalc/guide/calc_series.xhp index b3e849d940..2cdce15710 100755 --- a/helpcontent2/source/text/scalc/guide/calc_series.xhp +++ b/helpcontent2/source/text/scalc/guide/calc_series.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: calc_series.xhp,v $ - * $Revision: 1.11 $ + * $Revision: 1.11.4.1 $ * * This file is part of OpenOffice.org. * @@ -74,7 +74,7 @@ </listitem> </list> <paragraph role="tip" id="par_idN106EE" xml-lang="en-US" l10n="NEW">To quickly create a list of consecutive days, enter "Monday" in a cell, and drag the fill handle.</paragraph> -<paragraph role="paragraph" id="par_id9720145" xml-lang="en-US" l10n="NEW">Hold down Ctrl if you do not want to fill the cells with different values.</paragraph> +<paragraph role="paragraph" id="par_id9720145" xml-lang="en-US" l10n="NEW">Hold down <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>if you do not want to fill the cells with different values.</paragraph> <paragraph role="note" id="par_id3154490" xml-lang="en-US" l10n="CHG" oldref="18">If you select two or more adjacent cells that contain different numbers, and drag, the remaining cells are filled with the arithmetic pattern that is recognized in the numbers. The AutoFill function also recognizes customized lists that are defined under <item type="menuitem">Tools - Options - %PRODUCTNAME Calc - Sort Lists</item>.</paragraph> <paragraph role="tip" id="par_idN10737" xml-lang="en-US" l10n="NEW">You can double-click the fill handle to automatically fill all empty columns of the current data block. For example, first enter Jan into A1 and drag the fill handle down to A12 to get the twelve months in the first column. Now enter some values into B1 and C1. Select those two cells, and double-click the fill handle. This fills automatically the data block B1:C12.</paragraph> <paragraph role="heading" id="par_idN10713" xml-lang="en-US" level="2" l10n="NEW">Using a Defined Series</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/csv_files.xhp b/helpcontent2/source/text/scalc/guide/csv_files.xhp index 9cd16689ae..b9108f68f8 100755 --- a/helpcontent2/source/text/scalc/guide/csv_files.xhp +++ b/helpcontent2/source/text/scalc/guide/csv_files.xhp @@ -1,8 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: csv_files.xhp,v $ - * $Revision: 1.9 $ + * $Revision: 1.9.4.1 $ * * This file is part of OpenOffice.org. * @@ -32,33 +32,31 @@ * ************************************************************************ --> + -<helpdocument version="1.0"> <meta> -<topic id="textscalcguidecsv_filesxml" indexer="include" status="PUBLISH"> +<topic id="textscalcguidecsv_filesxml" indexer="include"> <title id="tit" xml-lang="en-US"> Importing and Exporting CSV Files </title> <filename>/text/scalc/guide/csv_files.xhp</filename> </topic> -<history> -<created date="2004-04-27T15:58:35">UFI: new guide</created> -<lastedited date="2006-10-24T12:55:39">UFI: do we need screenshots in this file? FPE: Repaired stored file name and link; dedr: reviewed</lastedited> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id892361"><bookmark_value>number series import</bookmark_value> <bookmark_value>data series import</bookmark_value> -<bookmark_value>importing; text databases</bookmark_value> +<bookmark_value>exporting; tables as text</bookmark_value> +<bookmark_value>importing; tables as text</bookmark_value> <bookmark_value>delimited values and files</bookmark_value> <bookmark_value>comma separated files and values</bookmark_value> <bookmark_value>text file import and export</bookmark_value> <bookmark_value>csv files;importing and exporting</bookmark_value> -</bookmark> +<bookmark_value>tables; importing/exporting as text</bookmark_value> +<bookmark_value>text documents; importing to spreadsheets</bookmark_value> +</bookmark><comment>MW deleted "importing;text data bases" and copied 4 index entries from scalc/guide/csv_formula.xhp</comment> <paragraph role="heading" id="par_idN10862" xml-lang="en-US" level="1" l10n="NEW"><variable id="csv_files"><link href="text/scalc/guide/csv_files.xhp">Opening and Saving Text CSV Files</link> </variable></paragraph> <paragraph role="paragraph" id="par_idN10880" xml-lang="en-US" l10n="NEW">Comma Separated Values (CSV) is text file format that you can use to exchange data from a database or a spreadsheet between applications. Each line in a Text CSV file represents a record in the database, or a row in a spreadsheet. Each field in a database record or cell in a spreadsheet row is usually separated by a comma. However, you can use other characters to delimit a field, such as a tabulator character.</paragraph> <paragraph role="paragraph" id="par_idN10886" xml-lang="en-US" l10n="NEW">If the content of a field or cell contains a comma, the contents of the field or cell <emph>must</emph> be enclosed by single quotes (') or double quotes (").</paragraph> -<paragraph role="note" id="par_idN106FC" xml-lang="en-US" l10n="NEW">When you export a spreadsheet to CSV format, only the data on the current sheet is saved. All other information, including formulas and formatting, is lost.</paragraph> -<paragraph role="heading" id="par_idN10890" xml-lang="en-US" level="2" l10n="CHG">To Open a Text CSV file in Calc</paragraph> +<paragraph role="heading" id="par_idN10890" xml-lang="en-US" level="2" l10n="CHG">To Open a Text CSV File in Calc</paragraph> <list type="ordered"> <listitem> <paragraph role="paragraph" id="par_idN10897" xml-lang="en-US" l10n="NEW">Choose <emph>File - Open</emph>.</paragraph> @@ -83,6 +81,7 @@ </listitem> </list> <paragraph role="heading" id="par_idN108FA" xml-lang="en-US" level="2" l10n="NEW">To Save a Sheet as a Text CSV File</paragraph> +<paragraph role="note" id="par_idN106FC" xml-lang="en-US" l10n="NEW">When you export a spreadsheet to CSV format, only the data on the current sheet is saved. All other information, including formulas and formatting, is lost.</paragraph> <list type="ordered"> <listitem> <paragraph role="paragraph" id="par_idN10901" xml-lang="en-US" l10n="NEW">Open the Calc sheet that you want to save as a Text CSV file.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/csv_formula.xhp b/helpcontent2/source/text/scalc/guide/csv_formula.xhp index 4e00477141..126fe5d3a8 100755 --- a/helpcontent2/source/text/scalc/guide/csv_formula.xhp +++ b/helpcontent2/source/text/scalc/guide/csv_formula.xhp @@ -1,8 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: csv_formula.xhp,v $ - * $Revision: 1.10 $ + * $Revision: 1.10.4.1 $ * * This file is part of OpenOffice.org. * @@ -32,28 +32,21 @@ * ************************************************************************ --> + -<helpdocument version="1.0"> <meta> -<topic id="textscalcguidecsv_formulaxml" indexer="include" status="PUBLISH"> +<topic id="textscalcguidecsv_formulaxml" indexer="include"> <title id="tit" xml-lang="en-US">Importing and Exporting Text Files</title> <filename>/text/scalc/guide/csv_formula.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2007-01-22T13:47:28">converted from old format - fpe</lastedited> -</history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3153726"><bookmark_value>csv files;spreadsheets</bookmark_value> -<bookmark_value>formulas; saving as csv files</bookmark_value> -<bookmark_value>exporting; tables as text</bookmark_value> -<bookmark_value>importing; tables as text</bookmark_value> -<bookmark_value>inserting; text files with data</bookmark_value> -<bookmark_value>tables; importing/exporting as text</bookmark_value> -<bookmark_value>text documents; importing to spreadsheets</bookmark_value> -</bookmark><comment>mw changed "text;" to "text documents;"</comment> -<paragraph role="heading" id="hd_id3153726" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="csv_formula"><link href="text/scalc/guide/csv_formula.xhp" name="Importing and Exporting Text Files">Importing and Exporting Text Files</link> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153726"><bookmark_value>csv files;formulas</bookmark_value> +<bookmark_value>formulas; importing/exporting as csv files</bookmark_value> +<bookmark_value>exporting;formulas as csv files</bookmark_value> +<bookmark_value>importing;csv files with formulas</bookmark_value> +</bookmark><comment>mw deleted "inserting;", copied 4 index entries to scalc/guide/csv_files.xhp, changed "csv files;" and "formulas;" and added 2 index entries</comment> +<paragraph role="heading" id="hd_id3153726" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="csv_formula"><link href="text/scalc/guide/csv_formula.xhp" name="Importing and Exporting Text Files">Importing and Exporting CSV Text Files with Formulas</link> </variable></paragraph> <paragraph role="paragraph" id="par_id3149402" xml-lang="en-US" l10n="U" oldref="2">Comma separated values (CSV) files are text files that contain the cell contents of a single sheet. Commas, semicolons, or other characters can be used as the field delimiters between the cells. Text strings are put in quotation marks, numbers are written without quotation marks.</paragraph> <paragraph role="heading" id="hd_id3150715" xml-lang="en-US" level="2" l10n="U" oldref="15">Importing a CSV File</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp index edd081ace7..a2c3aad4e2 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp @@ -10,7 +10,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: datapilot_createtable.xhp,v $ - * $Revision: 1.6 $ + * $Revision: 1.6.4.1 $ * * This file is part of OpenOffice.org. * @@ -67,7 +67,7 @@ YJ: checked</lastedited> <paragraph role="listitem" id="par_id3146974" xml-lang="en-US" l10n="CHG" oldref="16">By double-clicking on one of the fields in the <emph>Data Fields</emph> area you can call up the <link href="text/scalc/01/12090105.xhp" name="Data Field"><emph>Data Field</emph></link> dialog.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US" l10n="U" oldref="17">Use the <emph>Data Field</emph> dialog to select the calculations to be used for the data. To make a multiple selection, press the Ctrl key while clicking the desired calculation.</paragraph> +<paragraph role="paragraph" id="par_id3156286" xml-lang="en-US" l10n="U" oldref="17">Use the <emph>Data Field</emph> dialog to select the calculations to be used for the data. To make a multiple selection, press the <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>key while clicking the desired calculation.</paragraph> <list type="unordered"> <listitem> <paragraph role="listitem" id="par_id3150329" xml-lang="en-US" l10n="CHG" oldref="13">The order of the buttons can be changed at any time by moving them to a different position in the area with the mouse.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/edit_multitables.xhp b/helpcontent2/source/text/scalc/guide/edit_multitables.xhp index 24807ed91c..71b635961c 100755 --- a/helpcontent2/source/text/scalc/guide/edit_multitables.xhp +++ b/helpcontent2/source/text/scalc/guide/edit_multitables.xhp @@ -12,7 +12,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: edit_multitables.xhp,v $ - * $Revision: 1.10 $ + * $Revision: 1.10.4.1 $ * * This file is part of OpenOffice.org. * @@ -56,8 +56,8 @@ <paragraph xml-lang="en-US" id="par_id3150868" role="paragraph" l10n="U" oldref="6">In $[officename] Calc, you can insert values, text or formulas that are simultaneously copied to other selected sheets of your document.</paragraph> <list type="unordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3153768" role="listitem" l10n="U" oldref="8">Select all desired sheets by holding down the Ctrl key and clicking the corresponding register tabs that are still gray at the bottom margin of the workspace. All selected register tabs are now white.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10614" role="paragraph" l10n="NEW">You can use Shift+Ctrl+Page Up or Page Down to select multiple sheets using the keyboard.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153768" role="listitem" l10n="U" oldref="8">Select all desired sheets by holding down the <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>key and clicking the corresponding register tabs that are still gray at the bottom margin of the workspace. All selected register tabs are now white.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10614" role="paragraph" l10n="NEW">You can use Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up or Page Down to select multiple sheets using the keyboard.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3147435" role="listitem" l10n="U" oldref="7">Now when you insert values, text or formulas into the active sheet, they will also appear in the identical positions in the other selected sheets. For example, data entered in cell A1 of the active sheet is automatically entered into cell A1 of any other seleted sheet.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/finding.xhp b/helpcontent2/source/text/scalc/guide/finding.xhp index 1039f92414..ca65b40dc2 100644 --- a/helpcontent2/source/text/scalc/guide/finding.xhp +++ b/helpcontent2/source/text/scalc/guide/finding.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: finding.xhp,v $ - * $Revision: 1.4 $ + * $Revision: 1.4.4.1 $ * * This file is part of OpenOffice.org. * @@ -88,7 +88,7 @@ <paragraph role="paragraph" id="par_id3808404" xml-lang="en-US" l10n="NEW">When you click <emph>Find</emph>, Calc will select the next cell that contains your text. You can watch and edit the text, then click <emph>Find</emph> again to advance to the next found cell. </paragraph> <list type="unordered"> <listitem> -<paragraph role="paragraph" id="par_id2394482" xml-lang="en-US" l10n="NEW">If you closed the dialog, you can press a key combination (Ctrl+Shift+F) to find the next cell without opening the dialog. </paragraph> +<paragraph role="paragraph" id="par_id2394482" xml-lang="en-US" l10n="NEW">If you closed the dialog, you can press a key combination (<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+F) to find the next cell without opening the dialog. </paragraph> </listitem> <listitem> <paragraph role="paragraph" id="par_id631733" xml-lang="en-US" l10n="NEW">By default, Calc searches the current sheet. Click <emph>More Options</emph>, then enable <emph>Search in all sheets</emph> to search through all sheets of the document.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/format_table.xhp b/helpcontent2/source/text/scalc/guide/format_table.xhp index 6b1ed675ab..e18ccd3af2 100755 --- a/helpcontent2/source/text/scalc/guide/format_table.xhp +++ b/helpcontent2/source/text/scalc/guide/format_table.xhp @@ -13,7 +13,7 @@ * * $RCSfile: format_table.xhp,v $ * - * $Revision: 1.10 $ + * $Revision: 1.10.4.1 $ * * This file is part of OpenOffice.org. * @@ -75,7 +75,7 @@ <paragraph role="heading" id="hd_id3153483" xml-lang="en-US" level="2" l10n="U" oldref="19">Formatting Borders and Backgrounds for Cells and Pages</paragraph> <list type="ordered"> <listitem> -<paragraph role="listitem" id="par_id3154733" xml-lang="en-US" l10n="U" oldref="20">You can assign a format to any group of cells by first selecting the cells (for multiple selection, hold down the Ctrl key when clicking), and then activating the <emph>Format Cells</emph> dialog in <item type="menuitem">Format - Cell</item>. In this dialog, you can select attributes such as shadows and backgrounds.</paragraph> +<paragraph role="listitem" id="par_id3154733" xml-lang="en-US" l10n="U" oldref="20">You can assign a format to any group of cells by first selecting the cells (for multiple selection, hold down the <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>key when clicking), and then activating the <emph>Format Cells</emph> dialog in <item type="menuitem">Format - Cell</item>. In this dialog, you can select attributes such as shadows and backgrounds.</paragraph> </listitem> <listitem> <paragraph role="listitem" id="par_id3145116" xml-lang="en-US" l10n="U" oldref="21">To apply formatting attributes to an entire sheet, choose <emph>Format - Page</emph>. You can define headers and footers, for example, to appear on each printed page.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/formula_copy.xhp b/helpcontent2/source/text/scalc/guide/formula_copy.xhp index d4b7ec2957..5198cc0f1c 100755 --- a/helpcontent2/source/text/scalc/guide/formula_copy.xhp +++ b/helpcontent2/source/text/scalc/guide/formula_copy.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: formula_copy.xhp,v $ - * $Revision: 1.6 $ + * $Revision: 1.6.4.1 $ * * This file is part of OpenOffice.org. * @@ -58,15 +58,13 @@ <paragraph role="listitem" id="par_id3150439" xml-lang="en-US" l10n="U" oldref="30">Select the cell containing the formula.</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3154319" xml-lang="en-US" l10n="U" oldref="31">Choose <emph>Edit - Copy</emph>, or press <switchinline select="sys"><caseinline select="MAC">Command -</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+ C to copy it.</paragraph> +<paragraph role="listitem" id="par_id3154319" xml-lang="en-US" l10n="U" oldref="31">Choose <emph>Edit - Copy</emph>, or press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C to copy it.</paragraph> </listitem> <listitem> <paragraph role="listitem" id="par_id3159155" xml-lang="en-US" l10n="U" oldref="32">Select the cell into which you want the formula to be copied.</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3153728" xml-lang="en-US" l10n="U" oldref="33">Choose <emph>Edit - Paste</emph>, or press <switchinline select="sys"><caseinline select="MAC">Command -</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V. The formula will be positioned in the new cell.</paragraph> +<paragraph role="listitem" id="par_id3153728" xml-lang="en-US" l10n="U" oldref="33">Choose <emph>Edit - Paste</emph>, or press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V. The formula will be positioned in the new cell.</paragraph> </listitem> </list> <paragraph role="paragraph" id="par_id3149961" xml-lang="en-US" l10n="U" oldref="34">If you want to copy a formula into multiple cells, there is a quick and easy way to copy into adjacent cell areas:</paragraph> @@ -84,8 +82,7 @@ <paragraph role="listitem" id="par_id3153714" xml-lang="en-US" l10n="U" oldref="15">When you release the mouse button, the formula will be copied into the cells and automatically adjusted.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id3156385" xml-lang="en-US" l10n="U" oldref="53">If you do not want values and texts to be automatically adjusted, then hold down the <switchinline select="sys"><caseinline select="MAC">Command -</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key when dragging. Formulas, however, are always adjusted accordingly.</paragraph> +<paragraph role="paragraph" id="par_id3156385" xml-lang="en-US" l10n="U" oldref="53">If you do not want values and texts to be automatically adjusted, then hold down the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> key when dragging. Formulas, however, are always adjusted accordingly.</paragraph> </section> <section id="relatedtopics"> <embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> diff --git a/helpcontent2/source/text/scalc/guide/keyboard.xhp b/helpcontent2/source/text/scalc/guide/keyboard.xhp index a7bbe6ab5f..b8c81b0617 100644 --- a/helpcontent2/source/text/scalc/guide/keyboard.xhp +++ b/helpcontent2/source/text/scalc/guide/keyboard.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: keyboard.xhp,v $ - * $Revision: 1.10 $ + * $Revision: 1.10.4.1 $ * * This file is part of OpenOffice.org. * @@ -83,7 +83,7 @@ </listitem> <listitem> <paragraph role="listitem" id="par_id3149403" xml-lang="en-US" l10n="U" oldref="19"> -<item type="keycode">Ctrl+1</item> to <item type="keycode">Ctrl+8</item> - show all levels up to the specified number; hide all higher levels.</paragraph> +<switchinline select="sys"><caseinline select="MAC">Command+1 to Command+8</caseinline><defaultinline>Ctrl+1 to Ctrl+8</defaultinline></switchinline> - show all levels up to the specified number; hide all higher levels.</paragraph> </listitem> <listitem> <paragraph role="listitem" id="par_id3150329" xml-lang="en-US" l10n="U" oldref="20">Use <item type="keycode">+</item> or <item type="keycode">-</item> to show or hide the focused outline group.</paragraph> @@ -104,10 +104,10 @@ <paragraph role="listitem" id="par_id3155333" xml-lang="en-US" l10n="CHG" oldref="7">Press <item type="keycode">F6</item> until the <emph>Drawing</emph> toolbar is selected.</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3150345" xml-lang="en-US" l10n="U" oldref="4">If the selection tool is active, press <item type="keycode">Ctrl+Enter</item>. This selects the first drawing object or graphic in the sheet.</paragraph> +<paragraph role="listitem" id="par_id3150345" xml-lang="en-US" l10n="U" oldref="4">If the selection tool is active, press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter. This selects the first drawing object or graphic in the sheet.</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3159240" xml-lang="en-US" l10n="U" oldref="3">With <item type="keycode">Ctrl+F6</item> you set the focus to the document.</paragraph> +<paragraph role="listitem" id="par_id3159240" xml-lang="en-US" l10n="U" oldref="3">With <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F6 you set the focus to the document.</paragraph> <paragraph role="listitem" id="par_id3155379" xml-lang="en-US" l10n="U" oldref="2">Now you can use <item type="keycode">Tab</item> to select the next drawing object or graphic and <item type="keycode">Shift+Tab</item> to select the previous one.</paragraph> </listitem> </list> diff --git a/helpcontent2/source/text/scalc/guide/makefile.mk b/helpcontent2/source/text/scalc/guide/makefile.mk index 9817814421..b3aa776e36 100644 --- a/helpcontent2/source/text/scalc/guide/makefile.mk +++ b/helpcontent2/source/text/scalc/guide/makefile.mk @@ -8,7 +8,7 @@ # # $RCSfile: makefile.mk,v $ # -# $Revision: 1.18 $ +# $Revision: 1.18.4.4 $ # # This file is part of OpenOffice.org. # diff --git a/helpcontent2/source/text/scalc/guide/mark_cells.xhp b/helpcontent2/source/text/scalc/guide/mark_cells.xhp index c426c60f2b..3f34af06f0 100755 --- a/helpcontent2/source/text/scalc/guide/mark_cells.xhp +++ b/helpcontent2/source/text/scalc/guide/mark_cells.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: mark_cells.xhp,v $ - * $Revision: 1.7 $ + * $Revision: 1.7.4.1 $ * * This file is part of OpenOffice.org. * @@ -67,8 +67,7 @@ </listitem> </list> <paragraph role="heading" id="hd_id3154942" xml-lang="en-US" level="2" l10n="U" oldref="6">Select various dispersed cells</paragraph> -<paragraph role="paragraph" id="par_id3156284" xml-lang="en-US" l10n="U" oldref="7">Mark at least one cell. Then while pressing <switchinline select="sys"><caseinline select="MAC">Command -</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, click each of the additional cells.</paragraph> +<paragraph role="paragraph" id="par_id3156284" xml-lang="en-US" l10n="U" oldref="7">Mark at least one cell. Then while pressing <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, click each of the additional cells.</paragraph> <paragraph role="heading" id="hd_id3146971" xml-lang="en-US" level="2" l10n="U" oldref="8">Switch marking mode</paragraph> <paragraph role="paragraph" id="par_id3155064" xml-lang="en-US" l10n="U" oldref="9">On the status bar, click the box with the legend STD / EXT / ADD to switch the marking mode:</paragraph> <table id="tbl_id3145643"> @@ -101,7 +100,7 @@ <paragraph role="paragraph" id="par_id3145587" xml-lang="en-US" l10n="U" oldref="16">ADD</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3154368" xml-lang="en-US" l10n="U" oldref="17">A mouse click in a cell adds it to the already marked cells. A mouse click in a marked cell unmarks it. Alternatively, Ctrl-click the cells.</paragraph> +<paragraph role="paragraph" id="par_id3154368" xml-lang="en-US" l10n="U" oldref="17">A mouse click in a cell adds it to the already marked cells. A mouse click in a marked cell unmarks it. Alternatively, <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>-click the cells.</paragraph> </tablecell> </tablerow> </table> diff --git a/helpcontent2/source/text/scalc/guide/matrixformula.xhp b/helpcontent2/source/text/scalc/guide/matrixformula.xhp index 00fd60959a..8bfeed24c7 100755 --- a/helpcontent2/source/text/scalc/guide/matrixformula.xhp +++ b/helpcontent2/source/text/scalc/guide/matrixformula.xhp @@ -10,7 +10,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: matrixformula.xhp,v $ - * $Revision: 1.6 $ + * $Revision: 1.6.4.1 $ * * This file is part of OpenOffice.org. * @@ -71,8 +71,7 @@ <paragraph role="listitem" id="par_id3154018" xml-lang="en-US" l10n="U" oldref="21">Select the numbers in the second column in cells B1:B10.</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3150716" xml-lang="en-US" l10n="U" oldref="22">End the input with the matrix key combination: Shift+<switchinline select="sys"><caseinline select="MAC">Command -</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter.</paragraph> +<paragraph role="listitem" id="par_id3150716" xml-lang="en-US" l10n="U" oldref="22">End the input with the matrix key combination: Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter.</paragraph> </listitem> </list> <paragraph role="paragraph" id="par_id3145640" xml-lang="en-US" l10n="U" oldref="23">The matrix area is automatically protected against modifications, such as deleting rows or columns. It is, however, possible to edit any formatting, such as the cell background.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp b/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp index 91f6fab522..355fa15071 100644 --- a/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp +++ b/helpcontent2/source/text/scalc/guide/move_dragdrop.xhp @@ -1,9 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -12,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: move_dragdrop.xhp,v $ - * $Revision: 1.4 $ + * $Revision: 1.4.4.2 $ * * This file is part of OpenOffice.org. * @@ -33,11 +32,10 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textscalcguidemove_dragdropxml" indexer="include" status="PUBLISH"> +<topic id="textscalcguidemove_dragdropxml" indexer="include"> <title id="tit" xml-lang="en-US">Moving Cells by Drag-and-Drop </title> <filename>/text/scalc/guide/move_dragdrop.xhp</filename> </topic> @@ -45,14 +43,15 @@ <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3155686"><bookmark_value>drag and drop; moving cells</bookmark_value> <bookmark_value>cells; moving by drag and drop </bookmark_value> +<bookmark_value>columns;moving by drag and drop</bookmark_value> <bookmark_value>moving;cells by drag and drop</bookmark_value> <bookmark_value>inserting;cells, by drag and drop</bookmark_value> -</bookmark> +</bookmark><comment>mw added "columns;"</comment> <paragraph role="heading" id="hd_id986358" xml-lang="en-US" level="1" l10n="NEW"><variable id="move_dragdrop"><link href="text/scalc/guide/move_dragdrop.xhp">Moving Cells by Drag-and-Drop</link> </variable></paragraph> <paragraph role="paragraph" id="par_id2760093" xml-lang="en-US" l10n="NEW">When you drag-and-drop a selection of cells on a Calc sheet, the cells normally overwrite the existing cells in the area where you drop. This is the normal <emph>overwrite mode</emph>.</paragraph> -<paragraph role="paragraph" id="par_id9527268" xml-lang="en-US" l10n="NEW">When you hold down the <item type="keycode">Alt</item> key while releasing the mouse button, you enter the <emph>insert mode</emph>.</paragraph> -<list type="unordered"> +<paragraph role="paragraph" id="par_id9527268" xml-lang="en-US" l10n="NEW">When you hold down the <switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> key while releasing the mouse button, you enter the <emph>insert mode</emph>.</paragraph> +<list type="ordered"> <listitem> <paragraph role="paragraph" id="par_id79653" xml-lang="en-US" l10n="NEW">In insert mode, the existing cells where you drop will be shifted to the right or to the bottom, and the dropped cells are inserted into the now empty positions without overwriting. </paragraph> </listitem> @@ -65,66 +64,67 @@ <paragraph role="paragraph" id="par_id8040406" xml-lang="en-US" l10n="NEW">If you move cells in insert mode within the same row (only horizontally), then after insertion of the cells, all cells will be shifted to the left to fill the source area.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id2586748" xml-lang="en-US" l10n="NEW">In both modes, you can hold down the Ctrl key, or Ctrl+Shift keys while you release the mouse button to insert a copy or a link, respectively. </paragraph> +<paragraph role="paragraph" id="par_id2586748" xml-lang="en-US" l10n="NEW">In both modes, you can hold down the <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>key, or <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift keys while you release the mouse button to insert a copy or a link, respectively.</paragraph> <table id="tbl_id1674855"> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id5814081" xml-lang="en-US" l10n="NEW">Keys pressed while releasing the mouse button</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id6581316" xml-lang="en-US" l10n="NEW">Result</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id9906613" xml-lang="en-US" l10n="NEW">No key</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id2815637" xml-lang="en-US" l10n="NEW">Cells are moved and overwrite the cells in the target area. Source cells are emptied.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> -<paragraph role="tablecontent" id="par_id6161687" xml-lang="en-US" l10n="NEW">Ctrl key</paragraph> +<tablecell> +<paragraph role="tablecontent" id="par_id6161687" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>key</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id4278389" xml-lang="en-US" l10n="NEW">Cells are copied and overwrite the cells in the target area. Source cells stay as they are.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> -<paragraph role="tablecontent" id="par_id2805566" xml-lang="en-US" l10n="NEW">Ctrl+Shift keys</paragraph> +<tablecell> +<paragraph role="tablecontent" id="par_id2805566" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift keys</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id5369121" xml-lang="en-US" l10n="NEW">Links to the source cells are inserted and overwrite the cells in the target area. Source cells stay as they are.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> -<paragraph role="tablecontent" id="par_id9518723" xml-lang="en-US" l10n="NEW">Alt key</paragraph> +<tablecell> +<paragraph role="tablecontent" id="par_id9518723" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> key</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id2926419" xml-lang="en-US" l10n="NEW">Cells are moved and shift the cells in the target area to the right or to the bottom. Source cells are emptied, except if you move within the same rows on the same sheet. </paragraph> <paragraph role="tablecontent" id="par_id4021423" xml-lang="en-US" l10n="NEW">If you move within the same rows on the same sheet, the cells in the target area shift to the right, and then the whole row shifts to fill the source area.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> -<paragraph role="tablecontent" id="par_id2783898" xml-lang="en-US" l10n="NEW">Alt+Ctrl keys</paragraph> +<tablecell> +<paragraph role="tablecontent" id="par_id2783898" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Option+Command </caseinline><defaultinline>Alt+Ctrl </defaultinline></switchinline>keys</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id2785119" xml-lang="en-US" l10n="NEW">Cells are copied and shift the cells in the target area to the right or to the bottom. Source cells stay as they are.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> -<paragraph role="tablecontent" id="par_id584124" xml-lang="en-US" l10n="NEW">Alt+Ctrl+Shift keys</paragraph> +<tablecell> +<paragraph role="tablecontent" id="par_id584124" xml-lang="en-US" l10n="NEW"><switchinline select="sys"><caseinline select="MAC">Option+Command</caseinline><defaultinline>Alt+Ctrl</defaultinline></switchinline>+Shift keys</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id5590990" xml-lang="en-US" l10n="NEW">Links to the source cells are inserted and shift the cells in the target area to the right or to the bottom. Source cells stay as they are.</paragraph> </tablecell> </tablerow> </table> + <section id="relatedtopics"> <embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> <embed href="text/shared/guide/dragdrop.xhp#dragdrop"/> diff --git a/helpcontent2/source/text/scalc/guide/multitables.xhp b/helpcontent2/source/text/scalc/guide/multitables.xhp index 94bd137e17..7dc1f87a3d 100644 --- a/helpcontent2/source/text/scalc/guide/multitables.xhp +++ b/helpcontent2/source/text/scalc/guide/multitables.xhp @@ -12,7 +12,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: multitables.xhp,v $ - * $Revision: 1.6 $ + * $Revision: 1.6.4.1 $ * * This file is part of OpenOffice.org. * @@ -64,10 +64,10 @@ </listitem> </list> <paragraph xml-lang="en-US" id="hd_id3154491" role="heading" level="2" l10n="U" oldref="11">Selecting Multiple Sheets</paragraph> - <paragraph xml-lang="en-US" id="par_id3145251" role="paragraph" l10n="CHG" oldref="6">The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing <item type="keycode">Ctrl</item> you can select multiple sheets.</paragraph> - <paragraph xml-lang="en-US" id="par_idN106B7" role="paragraph" l10n="CHG">You can use <item type="keycode">Shift</item>+<item type="keycode">Ctrl</item>+<item type="keycode">Page Up</item> or <item type="keycode">Page Down</item> to select multiple sheets using the keyboard.</paragraph> + <paragraph xml-lang="en-US" id="par_id3145251" role="paragraph" l10n="CHG" oldref="6">The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>you can select multiple sheets.</paragraph> + <paragraph xml-lang="en-US" id="par_idN106B7" role="paragraph" l10n="CHG">You can use <item type="keycode">Shift</item>+<item type="keycode"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline></item>+<item type="keycode">Page Up</item> or <item type="keycode">Page Down</item> to select multiple sheets using the keyboard.</paragraph> <paragraph xml-lang="en-US" id="hd_id3155600" role="heading" level="2" l10n="U" oldref="12">Undoing a Selection</paragraph> - <paragraph xml-lang="en-US" id="par_id3146969" role="paragraph" l10n="CHG" oldref="13">To undo the selection of a sheet, click its sheet tab again while pressing the <item type="keycode">Ctrl</item> key. The sheet that is currently visible cannot be removed from the selection.</paragraph> + <paragraph xml-lang="en-US" id="par_id3146969" role="paragraph" l10n="CHG" oldref="13">To undo the selection of a sheet, click its sheet tab again while pressing the <item type="keycode"><switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline></item>key. The sheet that is currently visible cannot be removed from the selection.</paragraph> <paragraph xml-lang="en-US" id="hd_id3156382" role="heading" level="2" l10n="CHG" oldref="15">Calculating Across Multiple Sheets</paragraph> <paragraph xml-lang="en-US" id="par_id3155333" role="paragraph" l10n="CHG" oldref="16">You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, <item type="literal">=SUM(Sheet1.A1:Sheet3.A1) </item>sums up all A1 cells on Sheet1 through Sheet3.</paragraph> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/print_landscape.xhp b/helpcontent2/source/text/scalc/guide/print_landscape.xhp index 44a9eb88be..a629382075 100755 --- a/helpcontent2/source/text/scalc/guide/print_landscape.xhp +++ b/helpcontent2/source/text/scalc/guide/print_landscape.xhp @@ -12,7 +12,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: print_landscape.xhp,v $ - * $Revision: 1.12 $ + * $Revision: 1.12.4.1 $ * * This file is part of OpenOffice.org. * @@ -71,8 +71,7 @@ <paragraph role="listitem" id="par_id3153305" xml-lang="en-US" l10n="CHG" oldref="10"> <emph>All sheets</emph> - All sheets will be printed.</paragraph> <paragraph role="listitem" id="par_id3148871" xml-lang="en-US" l10n="CHG" oldref="12"> -<emph>Selected sheets</emph> - Only the selected sheets will be printed. All sheets whose names (at the bottom on the sheet tabs) are selected will be printed. By pressing <switchinline select="sys"><caseinline select="MAC">Command -</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while clicking a sheet name you can change this selection.</paragraph> +<emph>Selected sheets</emph> - Only the selected sheets will be printed. All sheets whose names (at the bottom on the sheet tabs) are selected will be printed. By pressing <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> while clicking a sheet name you can change this selection.</paragraph> <paragraph role="listitem" id="par_id3764763" xml-lang="en-US" l10n="NEW"> <emph>Selected cells</emph> - All selected cells are printed.</paragraph> </listitem> diff --git a/helpcontent2/source/text/scalc/guide/rename_table.xhp b/helpcontent2/source/text/scalc/guide/rename_table.xhp index 2f660c3cf1..c1182391de 100644 --- a/helpcontent2/source/text/scalc/guide/rename_table.xhp +++ b/helpcontent2/source/text/scalc/guide/rename_table.xhp @@ -1,8 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: rename_table.xhp,v $ - * $Revision: 1.8 $ + * $Revision: 1.8.4.2 $ * * This file is part of OpenOffice.org. * @@ -32,17 +32,13 @@ * ************************************************************************ --> + -<helpdocument version="1.0"> <meta> -<topic id="textscalcguiderename_tablexml" indexer="include" status="PUBLISH"> +<topic id="textscalcguiderename_tablexml" indexer="include"> <title id="tit" xml-lang="en-US">Renaming Sheets</title> <filename>/text/scalc/guide/rename_table.xhp</filename> </topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-05-23T10:30:33">converted from old format - fpe</lastedited> -</history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150398"><bookmark_value>renaming sheets</bookmark_value> @@ -63,12 +59,42 @@ <paragraph role="listitem" id="par_id3149260" xml-lang="en-US" l10n="U" oldref="15">Enter a new name for the sheet and click <emph>OK</emph>.</paragraph> </listitem> <listitem> -<paragraph role="listitem" id="par_id3149667" xml-lang="en-US" l10n="U" oldref="27">Alternatively, hold down the <switchinline select="sys"><caseinline select="MAC">Option key -</caseinline><defaultinline>Alt key</defaultinline></switchinline> and click on any sheet name and enter the new name directly.</paragraph> +<paragraph role="listitem" id="par_id3149667" xml-lang="en-US" l10n="U" oldref="27">Alternatively, hold down the <switchinline select="sys"><caseinline select="MAC">Option key</caseinline><defaultinline>Alt key</defaultinline></switchinline> and click on any sheet name and enter the new name directly.</paragraph> <embed href="text/shared/00/00000099.xhp#winmanager"/> </listitem> </list> -<paragraph role="note" id="par_id3154754" xml-lang="en-US" l10n="C">Allowed characters are letters, numbers, spaces, and the underline character.</paragraph> +<paragraph role="paragraph" id="par_id0909200810502833" xml-lang="en-US" l10n="NEW">Sheet names can contain almost any character. Some naming restrictions apply when you want to save the spreadsheet to Microsoft Excel format.</paragraph> +<paragraph role="paragraph" id="par_id090920081050283" xml-lang="en-US" l10n="NEW">When saving to Microsoft Excel format, the following characters are not allowed in sheet names:</paragraph> +<list type="unordered"> +<listitem> +<paragraph role="paragraph" id="par_id090920081050281" xml-lang="en-US" l10n="NEW">colon :</paragraph> +</listitem> +<listitem> +<paragraph role="paragraph" id="par_id0909200810502897" xml-lang="en-US" l10n="NEW">back slash \</paragraph> +</listitem> +<listitem> +<paragraph role="paragraph" id="par_id090920081050299" xml-lang="en-US" l10n="NEW">forward slash /</paragraph> +</listitem> +<listitem> +<paragraph role="paragraph" id="par_id0909200810502913" xml-lang="en-US" l10n="NEW">question mark ?</paragraph> +</listitem> +<listitem> +<paragraph role="paragraph" id="par_id090920081050298" xml-lang="en-US" l10n="NEW">asterisk *</paragraph> +</listitem> +<listitem> +<paragraph role="paragraph" id="par_id0909200810502969" xml-lang="en-US" l10n="NEW">left square bracket [</paragraph> +</listitem> +<listitem> +<paragraph role="paragraph" id="par_id0909200810502910" xml-lang="en-US" l10n="NEW">right square bracket ]</paragraph> +</listitem> +<listitem> +<paragraph role="paragraph" id="par_id0909200810502971" xml-lang="en-US" l10n="NEW">single quote ' as the first or last character of the name</paragraph> +</listitem> +</list> +<paragraph role="paragraph" id="par_id090920081050307" xml-lang="en-US" l10n="NEW">In cell references, a sheet name has to be enclosed in single quotes ' if the name contains other characters than alphanumeric or underscore. A single quote contained within a name has to be escaped by doubling it (two single quotes). For example, you want to reference the cell A1 on a sheet with the following name:</paragraph> +<paragraph role="paragraph" id="par_id0909200810503071" xml-lang="en-US" l10n="NEW">This year's sheet</paragraph> +<paragraph role="paragraph" id="par_id0909200810503054" xml-lang="en-US" l10n="NEW">The reference must be enclosed in single quotes, and the one single quote inside the name must be doubled:</paragraph> +<paragraph role="paragraph" id="par_id0909200810503069" xml-lang="en-US" l10n="NEW">'This year''s sheet'.A1</paragraph> <paragraph role="paragraph" id="par_id3155444" xml-lang="en-US" l10n="U" oldref="16">The name of a sheet is independent of the name of the spreadsheet. You enter the spreadsheet name when you save it for the first time as a file. The document can contain up to 256 individual sheets, which can have different names.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/multitables.xhp#multitables"/> diff --git a/helpcontent2/source/text/scalc/guide/scenario.xhp b/helpcontent2/source/text/scalc/guide/scenario.xhp index 5fba5632cd..dfde2e64f2 100755 --- a/helpcontent2/source/text/scalc/guide/scenario.xhp +++ b/helpcontent2/source/text/scalc/guide/scenario.xhp @@ -12,7 +12,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: scenario.xhp,v $ - * $Revision: 1.8 $ + * $Revision: 1.8.4.1 $ * * This file is part of OpenOffice.org. * @@ -53,7 +53,7 @@ <paragraph role="paragraph" id="par_id3154704" xml-lang="en-US" l10n="U" oldref="16">To create a scenario, select all the cells that provide the data for the scenario. </paragraph> <list type="ordered"> <listitem> -<paragraph role="listitem" id="par_id3154020" xml-lang="en-US" l10n="CHG" oldref="17">Select the cells that contain the values that will change between scenarios. To select multiple cells, hold down the <item type="keycode">Ctrl</item> key as you click each cell.</paragraph> +<paragraph role="listitem" id="par_id3154020" xml-lang="en-US" l10n="CHG" oldref="17">Select the cells that contain the values that will change between scenarios. To select multiple cells, hold down the <item type="keycode"><switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline></item>key as you click each cell.</paragraph> </listitem> <listitem> <paragraph role="listitem" id="par_id3150364" xml-lang="en-US" l10n="U" oldref="18">Choose <emph>Tools - Scenarios</emph>. The <emph>Create Scenario</emph> dialog appears.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/sorted_list.xhp b/helpcontent2/source/text/scalc/guide/sorted_list.xhp index 7a480845a9..19d91825f1 100755 --- a/helpcontent2/source/text/scalc/guide/sorted_list.xhp +++ b/helpcontent2/source/text/scalc/guide/sorted_list.xhp @@ -12,7 +12,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: sorted_list.xhp,v $ - * $Revision: 1.10 $ + * $Revision: 1.10.4.1 $ * * This file is part of OpenOffice.org. * @@ -60,7 +60,7 @@ </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3159154" role="paragraph" l10n="U" oldref="7">Sort lists allow you to type one piece of information in a cell, then drag it to fill in a consecutive list of items.</paragraph> <paragraph xml-lang="en-US" id="par_id3148645" role="paragraph" l10n="U" oldref="4">For example, enter the text "Jan" or "January" in an empty cell. Select the cell and click the mouse on the lower right corner of the cell border. Then drag the selected cell a few cells to the right or downwards. When you release the mouse button, the highlighted cells will be filled with the names of the months.</paragraph> - <paragraph xml-lang="en-US" id="par_id2367931" role="paragraph" l10n="NEW">Hold down Ctrl if you do not want to fill the cells with different values.</paragraph> + <paragraph xml-lang="en-US" id="par_id2367931" role="paragraph" l10n="NEW">Hold down <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>if you do not want to fill the cells with different values.</paragraph> <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph" l10n="U" oldref="5">The predefined series can be found under <emph>Tools - Options - %PRODUCTNAME Calc - Sort Lists</emph>. You can also create your own lists of text strings tailored to your needs, such as a list of your company's branch offices. When you use the information in these lists later (for example, as headings), just enter the first name in the list and expand the entry by dragging it with your mouse.</paragraph> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/text_wrap.xhp b/helpcontent2/source/text/scalc/guide/text_wrap.xhp index 80b075b5c9..9e5e8b7e05 100755 --- a/helpcontent2/source/text/scalc/guide/text_wrap.xhp +++ b/helpcontent2/source/text/scalc/guide/text_wrap.xhp @@ -13,7 +13,7 @@ * * $RCSfile: text_wrap.xhp,v $ * - * $Revision: 1.12 $ + * $Revision: 1.12.4.1 $ * * This file is part of OpenOffice.org. * @@ -53,8 +53,7 @@ <section id="wraptext"> <list type="ordered"> <listitem> -<paragraph role="listitem" id="par_id3156280" xml-lang="en-US" l10n="U" oldref="41">Pressing the <switchinline select="sys"><caseinline select="MAC">Command -</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter keys inserts a manual line break. This shortcut only works directly in the cell, not in the input line.</paragraph> +<paragraph role="listitem" id="par_id3156280" xml-lang="en-US" l10n="U" oldref="41">Pressing the <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter keys inserts a manual line break. This shortcut only works directly in the cell, not in the input line.</paragraph> </listitem> </list> <paragraph role="paragraph" id="par_id3153142" xml-lang="en-US" l10n="U" oldref="43">If you want the text to automatically break at the right border of the cell, proceed as follows:</paragraph> |