diff options
| author | Uwe Fischer <ufi@openoffice.org> | 2010-01-06 14:05:10 +0100 |
|---|---|---|
| committer | Uwe Fischer <ufi@openoffice.org> | 2010-01-06 14:05:10 +0100 |
| commit | 9e894c1652e86f508667c403b8160f5a9a22bbd9 (patch) | |
| tree | 4e873246e7df9b462e49d6e0dd1c6b361003089f /helpcontent2/source/text/scalc | |
| parent | bc5cb3872b1f6e3f58acd45b60242b035d0551d1 (diff) | |
hcshared25: commit before help id changes
Diffstat (limited to 'helpcontent2/source/text/scalc')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04090000.xhp | 74 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/01/06030000.xhp | 76 | ||||
| -rw-r--r-- | helpcontent2/source/text/scalc/02/06030000.xhp | 89 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/database_filter.xhp | 6 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/dbase_files.xhp | 177 | ||||
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/note_insert.xhp | 105 |
6 files changed, 254 insertions, 273 deletions
diff --git a/helpcontent2/source/text/scalc/01/04090000.xhp b/helpcontent2/source/text/scalc/01/04090000.xhp index 666c5a20fa..33d32d1017 100644 --- a/helpcontent2/source/text/scalc/01/04090000.xhp +++ b/helpcontent2/source/text/scalc/01/04090000.xhp @@ -1,7 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - -<!--*********************************************************************** +<helpdocument version="1.0"> + +<!-- +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -9,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 04090000.xhp,v $ - * $Revision: 1.8 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -29,44 +30,41 @@ * <http://www.openoffice.org/license.html> * for a copy of the LGPLv3 License. * - ************************************************************************--> + ************************************************************************ + --> + -<helpdocument version="1.0"> <meta> -<topic id="textscalc0104090000xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Link to External Data</title> -<filename>/text/scalc/01/04090000.xhp</filename> -</topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-12-17T13:51:02">UFI: changed name of menu (sc-features Calc: New menu entry "Sheet from File" in Insert menu) -dedr: reviewed</lastedited> -</history> -</meta> -<body> -<section id="extdata"> -<paragraph role="paragraph" id="par_id3153361" xml-lang="en-US" l10n="E" oldref="1" localize="false"/> + <topic id="textscalc0104090000xml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Link to External Data</title> + <filename>/text/scalc/01/04090000.xhp</filename> + </topic> + </meta> + <body> + <section id="extdata"> + <paragraph xml-lang="en-US" id="par_id3153361" role="paragraph" l10n="E" oldref="1" + localize="false"/> <bookmark xml-lang="en-US" branch="hid/SC_PUSHBUTTON_RID_SCDLG_LINKAREA_BTN_BROWSE" id="bm_id3151041" localize="false"/> -<paragraph role="paragraph" id="par_id3153192" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="SC_PUSHBUTTON_RID_SCDLG_LINKAREA_BTN_BROWSE" visibility="hidden">Locate the file containing the data you want to insert.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/SID_EXTERNAL_SOURCE" id="bm_id3748965" localize="false"/><!-- HID added by script --> +<paragraph xml-lang="en-US" id="par_id3153192" role="paragraph" l10n="U" oldref="2"><ahelp hid="SC_PUSHBUTTON_RID_SCDLG_LINKAREA_BTN_BROWSE" visibility="hidden">Locate the file containing the data you want to insert.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/SID_EXTERNAL_SOURCE" id="bm_id3748965" localize="false"/> <bookmark xml-lang="en-US" branch="hid/.uno:InsertExternalDataSource" id="bm_id3150441" localize="false"/> -<paragraph role="heading" id="hd_id3145785" xml-lang="en-US" level="1" l10n="CHG" oldref="3"><link href="text/scalc/01/04090000.xhp" name="External Data">Link to External Data</link></paragraph> -<paragraph role="paragraph" id="par_id3149262" xml-lang="en-US" l10n="U" oldref="4"><ahelp hid=".uno:InsertExternalDataSourc">Inserts data from an HTML, Calc, or Excel file into the current sheet as a link. The data must be located within a named range.</ahelp></paragraph> -</section> -<paragraph role="paragraph" id="par_id3146120" xml-lang="en-US" l10n="U" oldref="11">To import data from a <link href="text/scalc/guide/csv_formula.xhp" name="*.csv or *.txt">*.csv or *.txt</link> file, choose <emph>File - Open</emph> and then select the <emph>Files of type </emph>"Text CSV".</paragraph> -<section id="howtoget"> - <embed href="text/scalc/00/00000404.xhp#eiextdata"/> -</section> -<embed href="text/scalc/guide/webquery.xhp#webquery"/> +<paragraph xml-lang="en-US" id="hd_id3145785" role="heading" level="1" l10n="CHG" + oldref="3"><link href="text/scalc/01/04090000.xhp" name="External Data">Link to External Data</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3149262" role="paragraph" l10n="U" oldref="4"><ahelp hid=".uno:InsertExternalDataSourc">Inserts data from an HTML, Calc, or Excel file into the current sheet as a link. The data must be located within a named range.</ahelp></paragraph> + </section> + <section id="howtoget"> + <embed href="text/scalc/00/00000404.xhp#eiextdata"/> + </section> + <embed href="text/scalc/guide/webquery.xhp#webquery"/> <bookmark xml-lang="en-US" branch="hid/HID_SCDLG_LINKAREAURL" id="bm_id3148577" localize="false"/> -<paragraph role="heading" id="hd_id3146984" xml-lang="en-US" level="2" l10n="U" oldref="5">URL of external data source.</paragraph> -<paragraph role="paragraph" id="par_id3145366" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="HID_SCDLG_LINKAREAURL">Enter the URL or the file name that contains the data that you want to insert, and then press <item type="keycode">Enter</item>.</ahelp><comment>only after Enter the URL will be requested from the net.</comment></paragraph> +<paragraph xml-lang="en-US" id="hd_id3146984" role="heading" level="2" l10n="U" oldref="5">URL of external data source.</paragraph> + <paragraph xml-lang="en-US" id="par_id3145366" role="paragraph" l10n="U" oldref="6"><ahelp hid="HID_SCDLG_LINKAREAURL">Enter the URL or the file name that contains the data that you want to insert, and then press Enter.</ahelp><comment>only after Enter the URL will be requested from the net.</comment></paragraph> <bookmark xml-lang="en-US" branch="hid/SC_MULTILISTBOX_RID_SCDLG_LINKAREA_LB_RANGES" id="bm_id3153876" localize="false"/> -<paragraph role="heading" id="hd_id3145251" xml-lang="en-US" level="2" l10n="U" oldref="7">Available tables/ranges</paragraph> -<paragraph role="paragraph" id="par_id3147397" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid="SC_MULTILISTBOX_RID_SCDLG_LINKAREA_LB_RANGES">Select the table or the data range that you want to insert.</ahelp></paragraph> +<paragraph xml-lang="en-US" id="hd_id3145251" role="heading" level="2" l10n="U" oldref="7">Available tables/ranges</paragraph> + <paragraph xml-lang="en-US" id="par_id3147397" role="paragraph" l10n="U" oldref="8"><ahelp hid="SC_MULTILISTBOX_RID_SCDLG_LINKAREA_LB_RANGES">Select the table or the data range that you want to insert.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/SC_CHECKBOX_RID_SCDLG_LINKAREA_BTN_RELOAD" id="bm_id3153418" localize="false"/> <bookmark xml-lang="en-US" branch="hid/SC_NUMERICFIELD_RID_SCDLG_LINKAREA_NF_DELAY" id="bm_id3150718" localize="false"/> -<paragraph role="heading" id="hd_id3154492" xml-lang="en-US" level="2" l10n="U" oldref="9">Update every</paragraph> -<paragraph role="paragraph" id="par_id3154017" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="SC_NUMERICFIELD_RID_SCDLG_LINKAREA_NF_DELAY">Enter the number of seconds to wait before the external data are reloaded into the current document.</ahelp></paragraph> -</body> -</helpdocument> +<paragraph xml-lang="en-US" id="hd_id3154492" role="heading" level="2" l10n="U" oldref="9">Update every</paragraph> + <paragraph xml-lang="en-US" id="par_id3154017" role="paragraph" l10n="U" oldref="10"><ahelp hid="SC_NUMERICFIELD_RID_SCDLG_LINKAREA_NF_DELAY">Enter the number of seconds to wait before the external data are reloaded into the current document.</ahelp></paragraph> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/01/06030000.xhp b/helpcontent2/source/text/scalc/01/06030000.xhp index 625d7d8159..da46cee8a8 100755 --- a/helpcontent2/source/text/scalc/01/06030000.xhp +++ b/helpcontent2/source/text/scalc/01/06030000.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. * @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 06030000.xhp,v $ - * $Revision: 1.7 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -32,40 +32,38 @@ * ************************************************************************ --> + -<helpdocument version="1.0"> <meta> -<topic id="textscalc0106030000xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Detective</title> -<filename>/text/scalc/01/06030000.xhp</filename> -</topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-03-21T12:43:49">converted from old format - fpe</lastedited> -</history> -</meta> -<body> -<section id="detektiv"> + <topic id="textscalc0106030000xml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Detective</title> + <filename>/text/scalc/01/06030000.xhp</filename> + </topic> + </meta> + <body> + <section id="detektiv"> <bookmark xml-lang="en-US" branch="index" id="bm_id3151245"><bookmark_value>cell links search</bookmark_value> -<bookmark_value>searching; links in cells</bookmark_value> -<bookmark_value>traces;precedents and dependents</bookmark_value> -</bookmark><comment>mw made "searching..." a two level entry</comment> -<paragraph role="heading" id="hd_id3151245" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/01/06030000.xhp" name="Detective">Detective</link></paragraph> -<paragraph role="paragraph" id="par_id3151211" xml-lang="en-US" l10n="U" oldref="2">This command activates the Spreadsheet Detective. With the Detective, you can trace the dependencies from the current formula cell to the cells in the spreadsheet.</paragraph> -</section> -<section id="howtoget"> - <embed href="text/scalc/00/00000406.xhp#exdektv"/> -</section> -<paragraph role="paragraph" id="par_id3150447" xml-lang="en-US" l10n="U" oldref="3">Once you have defined a trace, you can point with the mouse cursor to the trace. The mouse cursor will change its shape. Double-click the trace with this cursor to select the referenced cell at the end of the trace. <comment>If you define an icon in the spreadsheet, you can put your cursor on it. It will change into a magnifying glass with reference arrows. Double-click the visible icon to select the cell at the furthest end of the icon.</comment></paragraph> -<embed href="text/scalc/01/06030100.xhp#spurzumvorgaenger"/> -<embed href="text/scalc/01/06030200.xhp#spurzumvorgaengerentfernen"/> -<embed href="text/scalc/01/06030300.xhp#spurzumnachfolger"/> -<embed href="text/scalc/01/06030400.xhp#spurzumnachfolgerentfernen"/> -<embed href="text/scalc/01/06030500.xhp#allespurenentfernen"/> -<embed href="text/scalc/01/06030600.xhp#spurzumfehler"/> -<embed href="text/scalc/01/06030800.xhp#dateneinkreisen"/> -<embed href="text/scalc/01/06030900.xhp#spurenaktualisieren"/> -<embed href="text/scalc/01/06031000.xhp#autoaktu"/> -<embed href="text/scalc/01/06030700.xhp#fuellmodus"/> -</body> -</helpdocument> + <bookmark_value>searching; links in cells</bookmark_value> + <bookmark_value>traces;precedents and dependents</bookmark_value> + <bookmark_value>Formula Auditing,see Detective</bookmark_value> + <bookmark_value>Detective</bookmark_value> +</bookmark><comment>MW added "Detective" and a cross-reference</comment> +<paragraph xml-lang="en-US" id="hd_id3151245" role="heading" level="1" l10n="U" oldref="1"><link href="text/scalc/01/06030000.xhp" name="Detective">Detective</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3151211" role="paragraph" l10n="U" oldref="2">This command activates the Spreadsheet Detective. With the Detective, you can trace the dependencies from the current formula cell to the cells in the spreadsheet.</paragraph> + </section> + <section id="howtoget"> + <embed href="text/scalc/00/00000406.xhp#exdektv"/> + </section> + <paragraph xml-lang="en-US" id="par_id3150447" role="paragraph" l10n="U" oldref="3">Once you have defined a trace, you can point with the mouse cursor to the trace. The mouse cursor will change its shape. Double-click the trace with this cursor to select the referenced cell at the end of the trace. <comment>If you define an icon in the spreadsheet, you can put your cursor on it. It will change into a magnifying glass with reference arrows. Double-click the visible icon to select the cell at the furthest end of the icon.</comment></paragraph> + <embed href="text/scalc/01/06030100.xhp#spurzumvorgaenger"/> + <embed href="text/scalc/01/06030200.xhp#spurzumvorgaengerentfernen"/> + <embed href="text/scalc/01/06030300.xhp#spurzumnachfolger"/> + <embed href="text/scalc/01/06030400.xhp#spurzumnachfolgerentfernen"/> + <embed href="text/scalc/01/06030500.xhp#allespurenentfernen"/> + <embed href="text/scalc/01/06030600.xhp#spurzumfehler"/> + <embed href="text/scalc/01/06030800.xhp#dateneinkreisen"/> + <embed href="text/scalc/01/06030900.xhp#spurenaktualisieren"/> + <embed href="text/scalc/01/06031000.xhp#autoaktu"/> + <embed href="text/scalc/01/06030700.xhp#fuellmodus"/> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/02/06030000.xhp b/helpcontent2/source/text/scalc/02/06030000.xhp index 169b590001..7170c23c2c 100644 --- a/helpcontent2/source/text/scalc/02/06030000.xhp +++ b/helpcontent2/source/text/scalc/02/06030000.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. * @@ -11,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 06030000.xhp,v $ - * $Revision: 1.7 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -33,51 +32,41 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textscalc0206030000xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Sum</title> -<filename>/text/scalc/02/06030000.xhp</filename> -</topic> -</meta> -<body> - - - <section id="summe"> - - + <topic id="textscalc0206030000xml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Sum</title> + <filename>/text/scalc/02/06030000.xhp</filename> + </topic> + </meta> + <body> + <section id="summe"> <bookmark xml-lang="en-US" branch="index" id="bm_id3157909"><bookmark_value>functions;sum function icon</bookmark_value> -<bookmark_value>formula bar;sum function</bookmark_value> -<bookmark_value>sum icon</bookmark_value> + <bookmark_value>formula bar;sum function</bookmark_value> + <bookmark_value>sum icon</bookmark_value> + <bookmark_value>AutoSum button, see sum icon</bookmark_value> </bookmark> - -<bookmark xml-lang="en-US" branch="hid/HID_INSWIN_SUMME" id="bm_id3151384" localize="false"/> - <comment>mw deleted "sum function..."</comment> - <paragraph xml-lang="en-US" id="hd_id3157909" role="heading" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06030000.xhp" name="Sum">Sum</link></paragraph> - <paragraph xml-lang="en-US" id="par_id3150543" role="paragraph" l10n="CHG" oldref="2"><ahelp hid="HID_INSWIN_SUMME">Inserts the sum of a cell range into the current cell, or inserts sum values into selected cells. Click in a cell, click this icon, and optionally adjust the cell range. Or select some cells into which the sum values will be inserted, then click the icon.</ahelp></paragraph> - - </section> - <section id="sysumme"> - - <table id="tbl_id3150868"> - - - <tablerow> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3153770" role="paragraph" l10n="E"> -<image id="img_id3147434" src="res/commandimagelist/sc_autosum.png" width="0.222inch" height="0.222inch"><alt xml-lang="en-US" id="alt_id3147434">Icon</alt> +<bookmark xml-lang="en-US" branch="hid/HID_INSWIN_SUMME" id="bm_id3151384" localize="false"/><comment>MW inserted a cross-reference</comment> +<paragraph xml-lang="en-US" id="hd_id3157909" role="heading" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06030000.xhp" name="Sum">Sum</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3150543" role="paragraph" l10n="CHG" oldref="2"><ahelp hid="HID_INSWIN_SUMME">Inserts the sum of a cell range into the current cell, or inserts sum values into selected cells. Click in a cell, click this icon, and optionally adjust the cell range. Or select some cells into which the sum values will be inserted, then click the icon.</ahelp></paragraph> + </section> + <section id="sysumme"> + <table id="tbl_id3150868"> + <tablerow> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3153770" role="paragraph" l10n="E"> +<image id="img_id3147434" src="res/commandimagelist/sc_autosum.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3147434">Icon</alt> </image></paragraph> - </tablecell> - <tablecell> - <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph" l10n="U" oldref="15">Sum</paragraph> - </tablecell> - </tablerow> - </table> - - </section> - <paragraph xml-lang="en-US" id="par_id3156444" role="paragraph" l10n="U" oldref="16">$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a sum function, you can combine it with the new one to yield the total sum of the range. If the range contains filters, the Subtotal function is inserted instead of the Sum function.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153189" role="paragraph" l10n="U" oldref="3">Click the <emph>Accept</emph> icon (green check mark) to use the formula displayed in the input line.</paragraph> - </body> -</helpdocument> + </tablecell> + <tablecell> + <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph" l10n="U" oldref="15">Sum</paragraph> + </tablecell> + </tablerow> + </table> + + </section> + <paragraph xml-lang="en-US" id="par_id3156444" role="paragraph" l10n="U" oldref="16">$[officename] automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a sum function, you can combine it with the new one to yield the total sum of the range. If the range contains filters, the Subtotal function is inserted instead of the Sum function.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153189" role="paragraph" l10n="U" oldref="3">Click the <emph>Accept</emph> icon (green check mark) to use the formula displayed in the input line.</paragraph> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/database_filter.xhp b/helpcontent2/source/text/scalc/guide/database_filter.xhp index 2a008bbcb8..5ca87ae1ee 100755 --- a/helpcontent2/source/text/scalc/guide/database_filter.xhp +++ b/helpcontent2/source/text/scalc/guide/database_filter.xhp @@ -50,7 +50,7 @@ oldref="47"><variable id="database_filter"><link href="text/scalc/guide/database_filter.xhp" name="Filtering Cell Ranges">Filtering Cell Ranges</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3145069" role="paragraph" l10n="CHG" oldref="48">You can use several filters to filter cell ranges in spreadsheets. A standard filter uses the options that you specify to filter the data. An AutoFilter filters data according to a specific value or string. An advanced filter uses filter criteria from specified cells.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10682" role="heading" level="1" l10n="CHG">To Apply a Standard Filter to a Cell Range</paragraph> + <paragraph xml-lang="en-US" id="par_idN10682" role="heading" level="2" l10n="CHG">To Apply a Standard Filter to a Cell Range</paragraph> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3150398" role="listitem" l10n="CHG" oldref="50">Click in a cell range.</paragraph> @@ -66,7 +66,7 @@ <paragraph xml-lang="en-US" id="par_id3153143" role="paragraph" l10n="U" oldref="52">The records that match the filter options that you specified are shown.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id3153728" role="heading" level="1" l10n="CHG" + <paragraph xml-lang="en-US" id="par_id3153728" role="heading" level="2" l10n="CHG" oldref="53">To Apply an AutoFilter to a Cell Range</paragraph> <list type="ordered"> <listitem> @@ -85,7 +85,7 @@ <paragraph xml-lang="en-US" id="par_idN1074C" role="listitem" l10n="NEW">The records that match the filter criteria that you selected are shown.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_idN106E8" role="heading" level="1" l10n="CHG">To Remove a Filter From a Cell Range</paragraph> + <paragraph xml-lang="en-US" id="par_idN106E8" role="heading" level="2" l10n="CHG">To Remove a Filter From a Cell Range</paragraph> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_idN1075C" role="paragraph" l10n="CHG">Click in a filtered cell range.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/dbase_files.xhp b/helpcontent2/source/text/scalc/guide/dbase_files.xhp index ec3ee09e85..afa716e021 100755 --- a/helpcontent2/source/text/scalc/guide/dbase_files.xhp +++ b/helpcontent2/source/text/scalc/guide/dbase_files.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. * @@ -11,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: dbase_files.xhp,v $ - * $Revision: 1.13 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -33,89 +32,89 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textscalcguidedbase_filesxhp" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Importing and Exporting dBASE Files </title> -<filename>/text/scalc/guide/dbase_files.xhp</filename> -</topic> -</meta> -<body> + <topic id="textscalcguidedbase_filesxhp" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Importing and Exporting dBASE Files </title> + <filename>/text/scalc/guide/dbase_files.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id1226844"><bookmark_value>exporting;spreadsheets to dBASE</bookmark_value> -<bookmark_value>importing;dBASE files</bookmark_value> -<bookmark_value>dBASE import/export</bookmark_value> -<bookmark_value>spreadsheets; importing from/exporting to dBASE files</bookmark_value> -<bookmark_value>tables in databases;importing dBASE files</bookmark_value> -</bookmark><comment>mw changed "database tables;" to "tables in databases;" and reduced "spreadsheets;" from two to one entry</comment><paragraph role="heading" id="par_idN10738" xml-lang="en-US" level="1" l10n="NEW"><variable id="dbase_files"><link href="text/scalc/guide/dbase_files.xhp">Importing and Exporting dBASE Files</link> + <bookmark_value>importing;dBASE files</bookmark_value> + <bookmark_value>dBASE import/export</bookmark_value> + <bookmark_value>spreadsheets; importing from/exporting to dBASE files</bookmark_value> + <bookmark_value>tables in databases;importing dBASE files</bookmark_value> +</bookmark><comment>mw changed "database tables;" to "tables in databases;" and reduced "spreadsheets;" from two to one entry</comment> +<paragraph xml-lang="en-US" id="par_idN10738" role="heading" level="1" l10n="NEW"><variable id="dbase_files"><link href="text/scalc/guide/dbase_files.xhp">Importing and Exporting dBASE Files</link> </variable></paragraph> -<paragraph role="paragraph" id="par_idN10756" xml-lang="en-US" l10n="CHG">You can open and save data in the dBASE file format (*.dbf file extension) in $[officename] Base or a spreadsheet. In %PRODUCTNAME Base, a dBASE database is a folder that contains files with the .dbf file extension. Each file corresponds to a table in the database. Formulas and formatting are lost when you open and save a dBASE file from %PRODUCTNAME.</paragraph> -<paragraph role="heading" id="par_idN10759" xml-lang="en-US" level="2" l10n="NEW">To Import a dBASE File Into a Spreadsheet</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_idN10760" xml-lang="en-US" l10n="NEW">Choose <emph>File - Open</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN1071F" xml-lang="en-US" l10n="NEW">Locate the *.dbf file that you want to import. </paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN10768" xml-lang="en-US" l10n="NEW">Click <emph>Open</emph>.</paragraph> -<paragraph role="paragraph" id="par_idN10730" xml-lang="en-US" l10n="NEW">The <emph>Import dBASE files</emph> dialog opens.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN10774" xml-lang="en-US" l10n="NEW">Click <emph>OK</emph>.</paragraph> -<paragraph role="paragraph" id="par_idN10777" xml-lang="en-US" l10n="NEW">The dBASE file opens as a new Calc spreadsheet.</paragraph> -<paragraph role="warning" id="par_idN1074E" xml-lang="en-US" l10n="NEW">If you want to save the spreadsheet as a dBASE file, do not alter or delete the first row in the imported file. This row contains information that is required by a dBASE database.</paragraph> -</listitem> -</list> -<paragraph role="heading" id="par_idN1077A" xml-lang="en-US" level="2" l10n="NEW">To Import a dBASE File Into a Database Table</paragraph> -<paragraph role="paragraph" id="par_idN1076C" xml-lang="en-US" l10n="NEW">A %PRODUCTNAME Base database table is actually a link to an existing database.</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_idN10796" xml-lang="en-US" l10n="NEW">Choose <item type="menuitem">File - New - Database</item>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN10786" xml-lang="en-US" l10n="NEW">In the <emph>File name</emph> box of the <emph>Save As</emph> dialog, enter a name for the database.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN10792" xml-lang="en-US" l10n="NEW">Click <emph>Save</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN1079A" xml-lang="en-US" l10n="NEW">In the <emph>Database type </emph>box of the <emph>Database Properties</emph> dialog, select "dBASE".</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN107A6" xml-lang="en-US" l10n="NEW">Click <emph>Next</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN107AE" xml-lang="en-US" l10n="NEW">Click <emph>Browse</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN107B6" xml-lang="en-US" l10n="NEW">Locate the directory that contains the dBASE file, and click <emph>OK</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN107BE" xml-lang="en-US" l10n="NEW">Click <emph>Create</emph>.</paragraph> -</listitem> -</list> -<paragraph role="heading" id="par_idN107F1" xml-lang="en-US" level="2" l10n="NEW">To Export a Spreadsheet to a dBASE File</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_idN107F8" xml-lang="en-US" l10n="NEW">Choose <emph>File - Export</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN10800" xml-lang="en-US" l10n="NEW">In the <emph>File format</emph> box, select "dBASE file".</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN107F9" xml-lang="en-US" l10n="NEW">In the <emph>File name</emph> box, type a name for the dBASE file.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_idN10801" xml-lang="en-US" l10n="NEW">Click <emph>Export</emph>.</paragraph> -</listitem> -</list> -<paragraph role="note" id="par_idN10808" xml-lang="en-US" l10n="NEW">Only the data on the current sheet is exported.</paragraph> -<section id="relatedtopics"> -<embed href="text/shared/guide/data_im_export.xhp#data_im_export"/> -<embed href="text/shared/guide/data_dbase2office.xhp#data_dbase2office"/> -</section> -</body> -</helpdocument> + <paragraph xml-lang="en-US" id="par_idN10756" role="paragraph" l10n="CHG">You can open and save data in the dBASE file format (*.dbf file extension) in $[officename] Base or a spreadsheet. In %PRODUCTNAME Base, a dBASE database is a folder that contains files with the .dbf file extension. Each file corresponds to a table in the database. Formulas and formatting are lost when you open and save a dBASE file from %PRODUCTNAME.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10759" role="heading" level="2" l10n="NEW">To Import a dBASE File Into a Spreadsheet</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_idN10760" role="paragraph" l10n="NEW">Choose <emph>File - Open</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN1071F" role="paragraph" l10n="NEW">Locate the *.dbf file that you want to import. </paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN10768" role="paragraph" l10n="NEW">Click <emph>Open</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10730" role="paragraph" l10n="NEW">The <emph>Import dBASE files</emph> dialog opens.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN10774" role="paragraph" l10n="NEW">Click <emph>OK</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10777" role="paragraph" l10n="NEW">The dBASE file opens as a new Calc spreadsheet.</paragraph> + <paragraph xml-lang="en-US" id="par_idN1074E" role="warning" l10n="NEW">If you want to save the spreadsheet as a dBASE file, do not alter or delete the first row in the imported file. This row contains information that is required by a dBASE database.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_idN1077A" role="heading" level="2" l10n="NEW">To Import a dBASE File Into a Database Table</paragraph> + <paragraph xml-lang="en-US" id="par_idN1076C" role="paragraph" l10n="NEW">A %PRODUCTNAME Base database table is actually a link to an existing database.</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_idN10796" role="paragraph" l10n="NEW">Choose <item type="menuitem">File - New - Database</item>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN10786" role="paragraph" l10n="NEW">In the <emph>File name</emph> box of the <emph>Save As</emph> dialog, enter a name for the database.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN10792" role="paragraph" l10n="NEW">Click <emph>Save</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN1079A" role="paragraph" l10n="NEW">In the <emph>Database type </emph>box of the <emph>Database Properties</emph> dialog, select "dBASE".</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN107A6" role="paragraph" l10n="NEW">Click <emph>Next</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN107AE" role="paragraph" l10n="NEW">Click <emph>Browse</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN107B6" role="paragraph" l10n="NEW">Locate the directory that contains the dBASE file, and click <emph>OK</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN107BE" role="paragraph" l10n="NEW">Click <emph>Create</emph>.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_idN107F1" role="heading" level="2" l10n="NEW">To Save a Spreadsheet as a dBASE File</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_idN107F8" role="paragraph" l10n="NEW">Choose <emph>File - Save As</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN10800" role="paragraph" l10n="NEW">In the <emph>File format</emph> box, select "dBASE file".</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN107F9" role="paragraph" l10n="NEW">In the <emph>File name</emph> box, type a name for the dBASE file.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN10801" role="paragraph" l10n="NEW">Click <emph>Save</emph>.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_idN10808" role="note" l10n="NEW">Only the data on the current sheet is exported.</paragraph> + <section id="relatedtopics"> + <embed href="text/shared/guide/data_im_export.xhp#data_im_export"/> + <embed href="text/shared/guide/data_dbase2office.xhp#data_dbase2office"/> + </section> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/note_insert.xhp b/helpcontent2/source/text/scalc/guide/note_insert.xhp index a06b85a258..5cbbdd3a8f 100755 --- a/helpcontent2/source/text/scalc/guide/note_insert.xhp +++ b/helpcontent2/source/text/scalc/guide/note_insert.xhp @@ -1,7 +1,8 @@ <?xml version="1.0" encoding="UTF-8"?> - - -<!--*********************************************************************** +<helpdocument version="1.0"> + +<!-- +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * @@ -9,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: note_insert.xhp,v $ - * $Revision: 1.9 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -29,56 +30,52 @@ * <http://www.openoffice.org/license.html> * for a copy of the LGPLv3 License. * - ************************************************************************--> - - + ************************************************************************ + --> + -<helpdocument version="1.0"> <meta> -<topic id="textscalcguidenote_insertxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Inserting and Editing Comments</title> -<filename>/text/scalc/guide/note_insert.xhp</filename> -</topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-01-17T12:10:26">converted from old format - fpe</lastedited> -</history> -</meta> -<body> + <topic id="textscalcguidenote_insertxml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Inserting and Editing Comments</title> + <filename>/text/scalc/guide/note_insert.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3153968"><bookmark_value>comments; on cells</bookmark_value> -<bookmark_value>cells;comments</bookmark_value> -<bookmark_value>comments; on cells</bookmark_value> -<bookmark_value>remarks on cells</bookmark_value> -<bookmark_value>formatting;comments on cells</bookmark_value> -<bookmark_value>viewing;comments on cells</bookmark_value> -</bookmark> -<paragraph role="heading" id="hd_id3153968" xml-lang="en-US" level="1" l10n="U" oldref="31"><variable id="note_insert"><link href="text/scalc/guide/note_insert.xhp" name="Inserting and Editing Comments">Inserting and Editing Comments</link> + <bookmark_value>cells;comments</bookmark_value> + <bookmark_value>remarks on cells</bookmark_value> + <bookmark_value>formatting;comments on cells</bookmark_value> + <bookmark_value>viewing;comments on cells</bookmark_value> + <bookmark_value>displaying; comments</bookmark_value> +</bookmark><comment>MW deleted double index "comments;on cells" and copied "displaying;comments" from shared/optionen/01060100.xhp</comment> +<paragraph xml-lang="en-US" id="hd_id3153968" role="heading" level="1" l10n="U" + oldref="31"><variable id="note_insert"><link href="text/scalc/guide/note_insert.xhp" name="Inserting and Editing Comments">Inserting and Editing Comments</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3150440" xml-lang="en-US" l10n="U" oldref="32">You can assign a comment to each cell by choosing <link href="text/shared/01/04050000.xhp" name="Insert - Comment"><emph>Insert - Comment</emph></link>. The comment is indicated by a small red square, the comment indicator, in the cell.</paragraph> -<list type="unordered"> -<listitem> -<paragraph role="listitem" id="par_id3145750" xml-lang="en-US" l10n="U" oldref="34">The comment is visible whenever the mouse pointer is over the cell, provided you have activated <emph>Help - Tips</emph> or - <emph>Extended Tips</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3148575" xml-lang="en-US" l10n="U" oldref="33">When you select the cell, you can choose <emph>Show Comment</emph> from the context menu of the cell. Doing so keeps the comment visible until you deactivate the <emph>Show Comment</emph> command from the same context menu.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3149958" xml-lang="en-US" l10n="U" oldref="35">To edit a permanently visible comment, just click in it. If you delete the entire text of the comment, the comment itself is deleted.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_idN10699" xml-lang="en-US" l10n="NEW">Move or resize each comment as you like.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_idN1069D" xml-lang="en-US" l10n="NEW">Format each comment by specifying background color, transparency, border style, and text alignment. Choose the commands from the context menu of the comment.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3144764" xml-lang="en-US" l10n="U" oldref="38">To show or hide the comment indicator, choose <emph>Tools - Options - %PRODUCTNAME Calc - View</emph> and mark or unmark the <emph>Comment indicator</emph> check box.</paragraph> -</listitem> -</list> -<paragraph role="paragraph" id="par_id3150715" xml-lang="en-US" l10n="U" oldref="39">To display a help tip for a selected cell, use <emph>Data - Validity - Input Help</emph>.</paragraph> -<section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3153707" xml-lang="en-US" l10n="U" oldref="36"><link href="text/shared/01/04050000.xhp" name="Insert - Comment">Insert - Comment</link></paragraph> -<embed href="text/scalc/guide/validity.xhp#validity"/> -</section> -</body> -</helpdocument> + <paragraph xml-lang="en-US" id="par_id3150440" role="paragraph" l10n="U" oldref="32">You can assign a comment to each cell by choosing <link href="text/shared/01/04050000.xhp" name="Insert - Comment"><emph>Insert - Comment</emph></link>. The comment is indicated by a small red square, the comment indicator, in the cell.</paragraph> + <list type="unordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3145750" role="listitem" l10n="U" oldref="34">The comment is visible whenever the mouse pointer is over the cell, provided you have activated <emph>Help - Tips</emph> or - <emph>Extended Tips</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3148575" role="listitem" l10n="U" oldref="33">When you select the cell, you can choose <emph>Show Comment</emph> from the context menu of the cell. Doing so keeps the comment visible until you deactivate the <emph>Show Comment</emph> command from the same context menu.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3149958" role="listitem" l10n="U" oldref="35">To edit a permanently visible comment, just click in it. If you delete the entire text of the comment, the comment itself is deleted.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN10699" role="listitem" l10n="NEW">Move or resize each comment as you like.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_idN1069D" role="listitem" l10n="NEW">Format each comment by specifying background color, transparency, border style, and text alignment. Choose the commands from the context menu of the comment.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3144764" role="listitem" l10n="U" oldref="38">To show or hide the comment indicator, choose <emph>Tools - Options - %PRODUCTNAME Calc - View</emph> and mark or unmark the <emph>Comment indicator</emph> check box.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_id3150715" role="paragraph" l10n="U" oldref="39">To display a help tip for a selected cell, use <emph>Data - Validity - Input Help</emph>.</paragraph> + <section id="relatedtopics"> + <paragraph xml-lang="en-US" id="par_id3153707" role="paragraph" l10n="U" oldref="36"><link href="text/shared/01/04050000.xhp" name="Insert - Comment">Insert - Comment</link></paragraph> + <embed href="text/scalc/guide/validity.xhp#validity"/> + </section> + </body> +</helpdocument>
\ No newline at end of file |