diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/guide')
38 files changed, 586 insertions, 496 deletions
diff --git a/helpcontent2/source/text/scalc/guide/address_auto.xhp b/helpcontent2/source/text/scalc/guide/address_auto.xhp index f6089588b9..776c22c5ca 100644 --- a/helpcontent2/source/text/scalc/guide/address_auto.xhp +++ b/helpcontent2/source/text/scalc/guide/address_auto.xhp @@ -68,9 +68,9 @@ </table> <paragraph xml-lang="en-US" id="par_id3154512" role="paragraph" l10n="CHG" oldref="22">In the example spreadsheet, you can use the string <item type="literal">'Column One'</item> in a formula to refer to the cell range <item type="literal">B3</item> to <item type="literal">B5</item>, or <item type="literal">'Column Two'</item> for the cell range <item type="literal">C2</item> to <item type="literal">C5</item>. You can also use <item type="literal">'Row One'</item> for the cell range <item type="literal">B3</item> to <item type="literal">D3</item>, or <item type="literal">'Row Two'</item> for the cell range <item type="literal">B4</item> to <item type="literal">D4</item>. The result of a formula that uses a cell name, for example, <item type="literal">SUM('Column One')</item>, is 600.</paragraph> - <paragraph xml-lang="en-US" id="par_id3155443" role="paragraph" l10n="CHG" oldref="24">This function is active by default. To turn this function off, choose <item type="menuitem">Tools - Options - %PRODUCTNAME Calc - Calculate</item> and clear the <item type="menuitem">Automatically find column and row labels</item> check box.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155443" role="paragraph" l10n="CHG" oldref="24">This function is active by default. To turn this function off, choose <emph>Tools - Options - %PRODUCTNAME Calc - Calculate</emph> and clear the <emph>Automatically find column and row labels</emph> check box.</paragraph> <paragraph xml-lang="en-US" id="par_id3149210" role="tip" l10n="CHG" oldref="37">If you want a name to be automatically recognized by Calc, the name must start with a letter and be composed of alphanumeric characters. If you enter the name in the formula yourself, enclose the name in single quotation marks ('). If a single quotation mark appears in a name, you must enter a backslash in front of the quotation mark, for example, <item type="literal">'Harry\'s Bar'.</item> - </paragraph> +</paragraph> <section id="relatedtopics"><comment>mw changed reference to deleted Calc guide address_byname.xhp to refer to Calc guide value_with_name.xhp</comment><comment>UFI: changed embedvar links to embed links</comment><embed href="text/scalc/guide/value_with_name.xhp#value_with_name"/> <embed href="text/scalc/01/04070400.xhp#define_label_range"/> <embed href="text/scalc/guide/relativ_absolut_ref.xhp#relativ_absolut_ref"/> diff --git a/helpcontent2/source/text/scalc/guide/auto_off.xhp b/helpcontent2/source/text/scalc/guide/auto_off.xhp index 433a6ddfb3..18752f198a 100755 --- a/helpcontent2/source/text/scalc/guide/auto_off.xhp +++ b/helpcontent2/source/text/scalc/guide/auto_off.xhp @@ -64,13 +64,13 @@ <paragraph xml-lang="en-US" id="par_id3145273" role="paragraph" l10n="U" oldref="3">The following shows you how to deactivate and reactivate the automatic changes in $[officename] Calc:</paragraph> <paragraph xml-lang="en-US" id="hd_id3145748" role="heading" level="2" l10n="U" oldref="4">Automatic Text or Number Completion</paragraph> <paragraph xml-lang="en-US" id="par_id3154730" role="paragraph" 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> - <paragraph xml-lang="en-US" id="par_id3153878" role="paragraph" 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"><item type="menuitem">Tools - Cell Contents - AutoInput</item></link>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153878" role="paragraph" 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> <paragraph xml-lang="en-US" id="hd_id3146972" role="heading" level="2" l10n="U" oldref="21">Automatic Conversion to Date Format</paragraph> - <paragraph xml-lang="en-US" id="par_id3153707" role="paragraph" l10n="U" oldref="22">$[officename] Calc automatically converts certain entries to dates. For example, the entry <item type="literal">1.1</item> may be interpreted as January 1 of the current year, according to the locale settings of your operating system, and then displayed according to the date format applied to the cell.<comment>for sure 1.1 will not be interpreted as a date in the USofA !!</comment></paragraph> + <paragraph xml-lang="en-US" id="par_id3153707" role="paragraph" l10n="U" oldref="22">$[officename] Calc automatically converts certain entries to dates. For example, the entry <emph>1.1</emph> may be interpreted as January 1 of the current year, according to the locale settings of your operating system, and then displayed according to the date format applied to the cell.<comment>for sure 1.1 will not be interpreted as a date in the USofA !!</comment></paragraph> <paragraph xml-lang="en-US" id="par_id3159267" role="paragraph" l10n="U" oldref="23">To ensure that an entry is interpreted as text, add an apostrophe at the beginning of the entry. The apostrophe is not displayed in the cell.</paragraph> <paragraph xml-lang="en-US" id="hd_id3150043" role="heading" level="2" l10n="U" oldref="7">Quotation Marks Replaced by Custom Quotes</paragraph> - <paragraph xml-lang="en-US" id="par_id3155333" role="paragraph" l10n="U" oldref="9">Choose <item type="menuitem">Tools - AutoCorrect Options</item>. Go to the <item type="menuitem">Custom Quotes</item> tab and unmark <item type="menuitem">Replace</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155333" role="paragraph" l10n="U" oldref="9">Choose <emph>Tools - AutoCorrect Options</emph>. Go to the <emph>Custom Quotes</emph> tab and unmark <emph>Replace</emph>.</paragraph> <paragraph xml-lang="en-US" id="hd_id3149565" role="heading" level="2" l10n="U" oldref="11">Cell Content Always Begins With Uppercase</paragraph> <paragraph xml-lang="en-US" id="par_id3147001" role="paragraph" l10n="U" oldref="13">Choose <item type="menuitem">Tools - AutoCorrect Options</item>. Go to the <item type="menuitem">Options</item> tab. Unmark <item type="menuitem">Capitalize first letter of every sentence</item>.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/autofilter.xhp b/helpcontent2/source/text/scalc/guide/autofilter.xhp index 44f5c29145..d18ef5a2fc 100755 --- a/helpcontent2/source/text/scalc/guide/autofilter.xhp +++ b/helpcontent2/source/text/scalc/guide/autofilter.xhp @@ -58,7 +58,7 @@ <paragraph xml-lang="en-US" id="par_id3152576" role="listitem" l10n="U" oldref="9">Select the columns you want to use AutoFilter on.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3153157" role="listitem" l10n="CHG" oldref="10">Choose <item type="menuitem">Data - Filter - AutoFilter</item>. The combo box arrows are visible in the first row of the range selected.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153157" role="listitem" l10n="CHG" oldref="10">Choose <emph>Data - Filter - AutoFilter</emph>. The combo box arrows are visible in the first row of the range selected.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3154510" role="listitem" l10n="U" oldref="11">Run the filter by clicking the drop-down arrow in the column heading and choosing an item.</paragraph> @@ -67,7 +67,7 @@ </list> <paragraph xml-lang="en-US" id="par_id9216589" role="paragraph" l10n="NEW">When you apply an additional AutoFilter on another column of a filtered data range, then the other combo boxes list only the filtered data.</paragraph> <paragraph xml-lang="en-US" id="par_id3153714" role="paragraph" l10n="U" oldref="12">To display all records again, select the "all<emph>"</emph> entry in the AutoFilter combo box. If you choose "Standard<emph>"</emph>, the <item type="menuitem">Standard Filter</item> dialog appears, allowing you to set up a standard filter. Choose "Top 10" to display the highest 10 values only. </paragraph> - <paragraph xml-lang="en-US" id="par_id3147340" role="paragraph" l10n="CHG" oldref="19">To stop using AutoFilter, reselect all cells selected in step 1 and once again choose <item type="menuitem">Data - Filter - AutoFilter</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147340" role="paragraph" l10n="CHG" oldref="19">To stop using AutoFilter, reselect all cells selected in step 1 and once again choose <emph>Data - Filter - AutoFilter</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_id4303415" role="tip" l10n="NEW">To assign different AutoFilters to different sheets, you must first define a database range on each sheet.</paragraph> <paragraph xml-lang="en-US" id="par_id3159236" role="warning" l10n="CHG" oldref="14">The arithmetic functions also take account of the cells that are not visible due to an applied filter. For example, a sum of an entire column will also total the values in the filtered cells. Apply the <link href="text/scalc/01/04060106.xhp" name="SUBTOTAL">SUBTOTAL</link> function if only the cells visible after the application of a filter are to be taken into account.</paragraph> </section> diff --git a/helpcontent2/source/text/scalc/guide/autoformat.xhp b/helpcontent2/source/text/scalc/guide/autoformat.xhp index fafbb4dfc0..921e114cdd 100755 --- a/helpcontent2/source/text/scalc/guide/autoformat.xhp +++ b/helpcontent2/source/text/scalc/guide/autoformat.xhp @@ -49,7 +49,7 @@ <bookmark_value>sheets;AutoFormat function</bookmark_value> </bookmark><comment>MW deleted "applying;"</comment> <paragraph xml-lang="en-US" id="hd_id3155132" role="heading" level="1" l10n="U" - oldref="11"><variable id="autoformat"><link href="text/scalc/guide/autoformat.xhp" name="Using AutoFormat for Tables">Applying Automatic Formatting to a Selected Cell Range</link> + oldref="11"><variable id="autoformat"><link href="text/scalc/guide/autoformat.xhp" name="Using AutoFormat for Tables">Applying Automatic Formatting to a Selected Cell Range</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3149401" role="paragraph" l10n="CHG" oldref="12">You can use the AutoFormat feature to quickly apply a format to a sheet or a selected cell range.</paragraph> <paragraph xml-lang="en-US" id="par_idN10702" role="heading" level="2" l10n="NEW">To Apply an AutoFormat to a Sheet or Selected Cell Range</paragraph> @@ -61,10 +61,10 @@ <paragraph xml-lang="en-US" id="par_idN106D5" role="listitem" l10n="NEW">Choose <item type="menuitem">Format - AutoFormat</item>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3151242" role="listitem" l10n="CHG" oldref="27">To select which properties to include in an AutoFormat, click <item type="menuitem">More</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3151242" role="listitem" l10n="CHG" oldref="27">To select which properties to include in an AutoFormat, click <emph>More</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN10715" role="listitem" l10n="NEW">Click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10715" role="listitem" l10n="NEW">Click <emph>OK</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_idN1075D" role="listitem" l10n="NEW">The format is applied to the selected range of cells.</paragraph> </listitem> </list> @@ -83,13 +83,13 @@ <paragraph xml-lang="en-US" id="par_id3153815" role="listitem" l10n="U" oldref="25">Choose <item type="menuitem">Format - AutoFormat</item>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN107A9" role="listitem" l10n="NEW">Click <item type="menuitem">Add</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN107A9" role="listitem" l10n="NEW">Click <emph>Add</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN10760" role="listitem" l10n="NEW">In the <item type="menuitem">Name</item> box of the <item type="menuitem">Add AutoFormat</item> dialog, enter a name for the format.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10760" role="listitem" l10n="NEW">In the <emph>Name</emph> box of the <emph>Add AutoFormat</emph> dialog, enter a name for the format.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN107C3" role="listitem" l10n="NEW">Click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN107C3" role="listitem" l10n="NEW">Click <emph>OK</emph>.</paragraph> </listitem> </list> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/background.xhp b/helpcontent2/source/text/scalc/guide/background.xhp index ed7837de5b..b0dd08eda9 100644 --- a/helpcontent2/source/text/scalc/guide/background.xhp +++ b/helpcontent2/source/text/scalc/guide/background.xhp @@ -58,21 +58,21 @@ <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 <item type="menuitem">Format - Cells</item> (or <item type="menuitem">Format Cells</item> from the context menu).</paragraph> + <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 <item type="menuitem">Background</item> tab page, select the background color.</paragraph> + <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 <item type="menuitem">Insert - Picture - From File</item>.</paragraph> + <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 <item type="menuitem">Open</item>.</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 <item type="menuitem">Arrange - To Background</item> 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> + <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> </caseinline><defaultinline>Navigator</defaultinline></switchinline>.</paragraph> </listitem> </list> diff --git a/helpcontent2/source/text/scalc/guide/borders.xhp b/helpcontent2/source/text/scalc/guide/borders.xhp index e69deb7cb4..755d431395 100755 --- a/helpcontent2/source/text/scalc/guide/borders.xhp +++ b/helpcontent2/source/text/scalc/guide/borders.xhp @@ -56,13 +56,13 @@ <paragraph xml-lang="en-US" id="par_id9181188" role="paragraph" l10n="NEW">Choose <item type="menuitem">Format - Cells</item>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id9947508" role="paragraph" l10n="NEW">In the dialog, click the <item type="menuitem">Borders</item> tab.</paragraph> + <paragraph xml-lang="en-US" id="par_id9947508" role="paragraph" l10n="NEW">In the dialog, click the <emph>Borders</emph> tab.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id7907956" role="paragraph" l10n="NEW">Choose the border options you want to apply and click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id7907956" role="paragraph" l10n="NEW">Choose the border options you want to apply and click OK.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id1342204" role="paragraph" l10n="NEW">The options in the <item type="menuitem">Line arrangement</item> area can be used to apply multiple border styles.</paragraph> + <paragraph xml-lang="en-US" id="par_id1342204" role="paragraph" l10n="NEW">The options in the <emph>Line arrangement</emph> area can be used to apply multiple border styles.</paragraph> <paragraph xml-lang="en-US" id="hd_id4454481" role="heading" level="2" l10n="NEW">Selection of cells</paragraph> <paragraph xml-lang="en-US" id="par_id7251503" role="paragraph" l10n="NEW">Depending on the selection of cells, the area looks different.</paragraph> <table id="tbl_id4423352"> @@ -118,7 +118,7 @@ <paragraph xml-lang="en-US" id="par_id5383465" role="note" l10n="NEW">You cannot apply borders to multiple selections.</paragraph> <paragraph xml-lang="en-US" id="hd_id7790154" role="heading" level="2" l10n="NEW">Default Settings</paragraph> - <paragraph xml-lang="en-US" id="par_id2918485" role="paragraph" l10n="NEW">Click one of the <item type="menuitem">Default</item> icons to set or reset multiple borders.</paragraph> + <paragraph xml-lang="en-US" id="par_id2918485" role="paragraph" l10n="NEW">Click one of the <emph>Default</emph> icons to set or reset multiple borders.</paragraph> <list type="unordered"> <listitem> <paragraph xml-lang="en-US" id="par_id1836909" role="listitem" l10n="NEW">The thin gray lines inside an icon show the borders that will be reset or cleared.</paragraph> @@ -131,7 +131,7 @@ </listitem> </list> <paragraph xml-lang="en-US" id="hd_id8989226" role="heading" level="3" l10n="NEW">Examples</paragraph> - <paragraph xml-lang="en-US" id="par_id622577" role="paragraph" l10n="NEW">Select a block of about 8x8 cells, then choose <item type="menuitem">Format - Cells - Borders</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id622577" role="paragraph" l10n="NEW">Select a block of about 8x8 cells, then choose <emph>Format - Cells - Borders</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_id8119754" role="paragraph" l10n="NEW"> <image id="img_id7261268" src="res/helpimg/border_ca_5.png" width="1.0937in" height="0.2189in"><alt xml-lang="en-US" id="alt_id7261268">default icon row of Borders tab page</alt> </image></paragraph> @@ -148,7 +148,7 @@ </list> <paragraph xml-lang="en-US" id="par_id9269386" role="paragraph" l10n="NEW">Now you can continue to see which lines the other icons will set or remove.</paragraph> <paragraph xml-lang="en-US" id="hd_id3593554" role="heading" level="2" l10n="NEW">User Defined Settings</paragraph> - <paragraph xml-lang="en-US" id="par_id4018066" role="paragraph" l10n="NEW">In the <item type="menuitem">User defined</item> area, you can click to set or remove individual lines. The preview shows lines in three different states. </paragraph> + <paragraph xml-lang="en-US" id="par_id4018066" role="paragraph" l10n="NEW">In the <emph>User defined</emph> area, you can click to set or remove individual lines. The preview shows lines in three different states. </paragraph> <paragraph xml-lang="en-US" id="par_id8004699" role="paragraph" l10n="NEW">Repeatedly click an edge or a corner to switch through the three different states.</paragraph> <table id="tbl_id5196996"> <tablerow> @@ -204,7 +204,7 @@ </table> <paragraph xml-lang="en-US" id="hd_id7282937" role="heading" level="3" l10n="NEW">Examples</paragraph> - <paragraph xml-lang="en-US" id="par_id4230780" role="paragraph" l10n="NEW">Select a single cell, then choose <item type="menuitem">Format - Cells - Borders</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id4230780" role="paragraph" l10n="NEW">Select a single cell, then choose <emph>Format - Cells - Borders</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_id1712393" role="paragraph" l10n="NEW">Click the lower edge to set a very thin line as a lower border. All other lines will be removed from the cell.</paragraph> <paragraph xml-lang="en-US" id="par_id5149693" role="paragraph" l10n="NEW"> <image id="img_id9467452" src="res/helpimg/border_ca_6.png" width="1.2602in" height="1.1252in"><alt xml-lang="en-US" id="alt_id9467452">setting a thin lower border</alt> @@ -213,7 +213,7 @@ <paragraph xml-lang="en-US" id="par_id6342051" role="paragraph" l10n="NEW"> <image id="img_id7431562" src="res/helpimg/border_ca_7.png" width="1.2602in" height="1.1252in"><alt xml-lang="en-US" id="alt_id7431562">setting a thick line as a border</alt> </image></paragraph> - <paragraph xml-lang="en-US" id="par_id5775322" role="paragraph" l10n="NEW">Click the second <item type="menuitem">Default</item> icon from the left to set all four borders. Then repeatedly click the lower edge until a white line is shown. This removes the lower border.</paragraph> + <paragraph xml-lang="en-US" id="par_id5775322" role="paragraph" l10n="NEW">Click the second <emph>Default</emph> icon from the left to set all four borders. Then repeatedly click the lower edge until a white line is shown. This removes the lower border.</paragraph> <paragraph xml-lang="en-US" id="par_id2882778" role="paragraph" l10n="NEW"> <image id="img_id8155766.00000001" src="res/helpimg/border_ca_8.png" width="1.2602in" height="1.1252in"><alt xml-lang="en-US" id="alt_id8155766.00000001">removing lower border</alt> </image></paragraph> diff --git a/helpcontent2/source/text/scalc/guide/calc_date.xhp b/helpcontent2/source/text/scalc/guide/calc_date.xhp index 30fc2a99fb..ce4851ddc5 100755 --- a/helpcontent2/source/text/scalc/guide/calc_date.xhp +++ b/helpcontent2/source/text/scalc/guide/calc_date.xhp @@ -59,10 +59,10 @@ </paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3149020" role="listitem" l10n="U" oldref="52">After pressing the Enter key you will see the result in date format. Since the result should show the difference between two dates as a number of days, you must format cell A3 as a number.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149020" role="listitem" l10n="U" oldref="52">After pressing the <item type="keycode">Enter</item> key you will see the result in date format. Since the result should show the difference between two dates as a number of days, you must format cell A3 as a number.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3155335" role="listitem" l10n="U" oldref="53">Place the cursor in cell A3, right-click to open a context menu and choose <item type="menuitem">Format Cells</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155335" role="listitem" l10n="U" oldref="53">Place the cursor in cell A3, right-click to open a context menu and choose <emph>Format Cells</emph>.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3147343" role="listitem" l10n="U" oldref="54">The <item type="menuitem">Format Cells</item> dialog appears. On the <item type="menuitem">Numbers</item> tab, the "Number" category will appear already highlighted. The format is set to "General", which causes the result of a calculation containing date entries to be displayed as a date. To display the result as a number, set the number format to "-1,234" and close the dialog with the <item type="menuitem">OK</item> button.</paragraph> @@ -71,10 +71,10 @@ <paragraph xml-lang="en-US" id="par_id3147001" role="listitem" l10n="U" oldref="15">The number of days between today's date and the specified date is displayed in cell A3.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3150304" role="listitem" l10n="U" oldref="16">Experiment with some additional formulas: in A4 enter <item type="literal">=A3*24</item> to calculate the hours, in A5 enter <item type="literal">=A4*60</item> for the minutes, and in A6 enter <item type="literal">=A5*60</item> for seconds. Press the Enter key after each formula.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150304" role="listitem" l10n="U" oldref="16">Experiment with some additional formulas: in A4 enter =A3*24 to calculate the hours, in A5 enter =A4*60 for the minutes, and in A6 enter =A5*60 for seconds. Press the <item type="keycode">Enter</item> key after each formula.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id3149207" role="paragraph" l10n="U" oldref="17">The time since your date of birth will be calculated and displayed in the various units. The values are calculated as of the exact moment when you entered the last formula and pressed the Enter key. This value is not automatically updated, although "Now" continuously changes. In the <item type="menuitem">Tools</item> menu, the menu item <item type="menuitem">Cell Contents - AutoCalculate</item> is normally active; however, automatic calculation does not apply to the function NOW. This ensures that your computer is not solely occupied with updating the sheet.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149207" role="paragraph" l10n="U" oldref="17">The time since your date of birth will be calculated and displayed in the various units. The values are calculated as of the exact moment when you entered the last formula and pressed the <item type="keycode">Enter</item> key. This value is not automatically updated, although "Now" continuously changes. In the <emph>Tools</emph> menu, the menu item <emph>Cell Contents - AutoCalculate</emph> is normally active; however, automatic calculation does not apply to the function NOW. This ensures that your computer is not solely occupied with updating the sheet.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/> </section> diff --git a/helpcontent2/source/text/scalc/guide/calc_series.xhp b/helpcontent2/source/text/scalc/guide/calc_series.xhp index 5aea6cdfa0..806acd7d59 100755 --- a/helpcontent2/source/text/scalc/guide/calc_series.xhp +++ b/helpcontent2/source/text/scalc/guide/calc_series.xhp @@ -73,7 +73,7 @@ <paragraph xml-lang="en-US" id="par_id9720145" 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_id3154490" role="note" 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 xml-lang="en-US" id="par_idN10737" role="tip" l10n="NEW">You can double-click the fill handle to automatically fill all empty columns of the current data block. For example, first enter <item type="literal">Jan</item> 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 xml-lang="en-US" id="par_idN10737" role="tip" 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 xml-lang="en-US" id="par_idN10713" role="heading" level="2" l10n="NEW">Using a Defined Series</paragraph> <list type="ordered"> <listitem> @@ -84,9 +84,9 @@ </listitem> <listitem> <paragraph xml-lang="en-US" id="par_idN10716" role="listitem" l10n="NEW">Select the parameters for the series. </paragraph> - <paragraph xml-lang="en-US" id="par_idN10731" role="listitem" l10n="NEW">If you select a <item type="menuitem">linear</item> series, the increment that you enter is <emph>added</emph> to each consecutive number in the series to create the next value.</paragraph> - <paragraph xml-lang="en-US" id="par_idN1073C" role="listitem" l10n="NEW">If you select a <item type="menuitem">growth</item> series, the increment that you enter is <emph>multiplied</emph> by each consecutive number to create the next value.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10747" role="listitem" l10n="NEW">If you select a <item type="menuitem">date</item> series, the increment that you enter is added to the time unit that you specify.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10731" role="listitem" l10n="NEW">If you select a <emph>linear</emph> series, the increment that you enter is <emph>added</emph> to each consecutive number in the series to create the next value.</paragraph> + <paragraph xml-lang="en-US" id="par_idN1073C" role="listitem" l10n="NEW">If you select a <emph>growth</emph> series, the increment that you enter is <emph>multiplied</emph> by each consecutive number to create the next value.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10747" role="listitem" l10n="NEW">If you select a <emph>date</emph> series, the increment that you enter is added to the time unit that you specify.</paragraph> </listitem> </list> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/calculate.xhp b/helpcontent2/source/text/scalc/guide/calculate.xhp index 6bcba3f555..50fc1fd1e6 100644 --- a/helpcontent2/source/text/scalc/guide/calculate.xhp +++ b/helpcontent2/source/text/scalc/guide/calculate.xhp @@ -54,22 +54,22 @@ <paragraph xml-lang="en-US" id="par_id3153951" role="listitem" l10n="CHG" oldref="7">Click in a cell, and type a number</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN10656" role="listitem" l10n="NEW">Press Enter.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10656" role="listitem" l10n="NEW">Press <item type="keycode">Enter</item>.</paragraph> <paragraph xml-lang="en-US" id="par_idN1065D" role="listitem" l10n="NEW">The cursor moves down to the next cell.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3155064" role="listitem" l10n="CHG" oldref="9">Enter another number.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN1066F" role="listitem" l10n="NEW">Press the Tab key.</paragraph> + <paragraph xml-lang="en-US" id="par_idN1066F" role="listitem" l10n="NEW">Press the <item type="keycode">Tab</item> key.</paragraph> <paragraph xml-lang="en-US" id="par_idN10676" role="listitem" l10n="NEW">The cursor moves to the right into the next cell.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3154253" role="listitem" l10n="CHG" oldref="10">Type in a formula, for example, <item type="literal">=A3 * A4 / 100.</item> - </paragraph> +</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN1068B" role="listitem" l10n="NEW"> Press Enter.</paragraph> + <paragraph xml-lang="en-US" id="par_idN1068B" role="listitem" l10n="NEW"> Press <item type="keycode">Enter</item>.</paragraph> <paragraph xml-lang="en-US" id="par_id3147343" role="listitem" l10n="U" oldref="20">The result of the formula appears in the cell. If you want, you can edit the formula in the input line of the Formula bar.</paragraph> <paragraph xml-lang="en-US" id="par_id3155378" role="listitem" l10n="U" oldref="12">When you edit a formula, the new result is calculated automatically.</paragraph> </listitem> diff --git a/helpcontent2/source/text/scalc/guide/cell_protect.xhp b/helpcontent2/source/text/scalc/guide/cell_protect.xhp index a32b7bd6c1..2e67ff433e 100755 --- a/helpcontent2/source/text/scalc/guide/cell_protect.xhp +++ b/helpcontent2/source/text/scalc/guide/cell_protect.xhp @@ -51,7 +51,7 @@ <bookmark_value>hiding;formulas</bookmark_value> <bookmark_value>formulas;hiding</bookmark_value> </bookmark><comment>MW transferred "modifying;..." and "changing;..." into one index entry</comment> -<paragraph xml-lang="en-US" id="hd_id3146119" role="heading" level="1" l10n="U" oldref="5"><variable id="cell_protect"><link href="text/scalc/guide/cell_protect.xhp" name="Protecting Cells from Changes">Protecting Cells from Changes</link> +<paragraph xml-lang="en-US" id="hd_id3146119" role="heading" level="1" l10n="U" oldref="5"><variable id="cell_protect"><link href="text/scalc/guide/cell_protect.xhp" name="Protecting Cells from Changes">Protecting Cells from Changes</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3153368" role="paragraph" l10n="U" oldref="17">In <item type="productname">%PRODUCTNAME</item> Calc you can protect sheets and the document as a whole. You can choose whether the cells are protected against accidental changes, whether the formulas can be viewed from within Calc, whether the cells are visible or whether the cells can be printed.</paragraph> <paragraph xml-lang="en-US" id="par_id3145261" role="paragraph" l10n="U" oldref="18">Protection can be provided by means of a password, but it does not have to be. If you have assigned a password, protection can only be removed once the correct password has been entered.</paragraph> @@ -62,20 +62,20 @@ <paragraph xml-lang="en-US" id="par_idN1066B" role="listitem" l10n="NEW">Select the cells that you want to specify the cell protection options for.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3149019" role="listitem" l10n="U" oldref="7">Choose <item type="menuitem">Format - Cells</item> and click the <item type="menuitem">Cell Protection</item> tab.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149019" role="listitem" l10n="U" oldref="7">Choose <item type="menuitem">Format - Cells</item> and click the <emph>Cell Protection</emph> tab.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3152985" role="listitem" l10n="U" oldref="9">Select the protection options that you want.</paragraph> - <paragraph xml-lang="en-US" id="par_id3152898" role="listitem" l10n="U" oldref="10">Select <item type="menuitem">Protected</item> to prevent changes to the contents and the format of a cell. </paragraph> - <paragraph xml-lang="en-US" id="par_idN1069A" role="listitem" l10n="NEW">Select <item type="menuitem">Hide formula</item> to hide and to protect formulas from changes.</paragraph> - <paragraph xml-lang="en-US" id="par_idN106A1" role="listitem" l10n="NEW">Select <item type="menuitem">Hide when printing</item> to hide protected cells in the printed document. The cells are not hidden on screen.</paragraph> + <paragraph xml-lang="en-US" id="par_id3152898" role="listitem" l10n="U" oldref="10">Select <emph>Protected</emph> to prevent changes to the contents and the format of a cell. </paragraph> + <paragraph xml-lang="en-US" id="par_idN1069A" role="listitem" l10n="NEW">Select <emph>Hide formula</emph> to hide and to protect formulas from changes.</paragraph> + <paragraph xml-lang="en-US" id="par_idN106A1" role="listitem" l10n="NEW">Select <emph>Hide when printing</emph> to hide protected cells in the printed document. The cells are not hidden onscreen.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3152872" role="listitem" l10n="U" oldref="11">Click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3152872" role="listitem" l10n="U" oldref="11">Click <emph>OK</emph>.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3145362" role="listitem" l10n="U" oldref="12">Apply the protection options.</paragraph> - <paragraph xml-lang="en-US" id="par_idN106C0" role="listitem" l10n="NEW">To protect the cells from being changed / viewed / printed according to your settings in the <item type="menuitem">Format - Cells</item> dialog, choose <item type="menuitem">Tools - Protect Document - Sheet</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN106C0" role="listitem" l10n="NEW">To protect the cells from being changed / viewed / printed according to your settings in the <emph>Format - Cells</emph> dialog, choose <item type="menuitem">Tools - Protect Document - Sheet</item>.</paragraph> <paragraph xml-lang="en-US" id="par_idN106C7" role="listitem" l10n="CHG">To protect the structure of the document, for example the count, <link href="text/scalc/guide/rename_table.xhp">names</link>, and order of the sheets, from being changed, choose <item type="menuitem">Tools - Protect Document - Document</item>.</paragraph> </listitem> <listitem> @@ -83,7 +83,7 @@ <paragraph xml-lang="en-US" id="par_idN106D2" role="warning" l10n="NEW">If you forget your password, you cannot deactivate the protection. If you only want to protect cells from accidental changes, set the sheet protection, but do not enter a password.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3153810" role="listitem" l10n="U" oldref="13">Click <item type="menuitem">OK</item>. </paragraph> + <paragraph xml-lang="en-US" id="par_id3153810" role="listitem" l10n="U" oldref="13">Click <emph>OK</emph>. </paragraph> </listitem> </list> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/cell_unprotect.xhp b/helpcontent2/source/text/scalc/guide/cell_unprotect.xhp index e61d2b59eb..e1c1397cd4 100755 --- a/helpcontent2/source/text/scalc/guide/cell_unprotect.xhp +++ b/helpcontent2/source/text/scalc/guide/cell_unprotect.xhp @@ -46,17 +46,17 @@ <bookmark_value>unprotecting cells</bookmark_value> </bookmark> <paragraph xml-lang="en-US" id="hd_id3153252" role="heading" level="1" l10n="U" - oldref="14"><variable id="cell_unprotect"><link href="text/scalc/guide/cell_unprotect.xhp" name="Unprotecting Cells">Unprotecting Cells</link> + oldref="14"><variable id="cell_unprotect"><link href="text/scalc/guide/cell_unprotect.xhp" name="Unprotecting Cells">Unprotecting Cells</link> </variable></paragraph> <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3151112" role="listitem" l10n="U" oldref="15">Click the sheet for which you want to cancel the protection.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3149656" role="listitem" l10n="U" oldref="16">Select <item type="menuitem">Tools - Protect Document</item>, then choose <item type="menuitem">Sheet</item> or <item type="menuitem">Document</item> to remove the check mark indicating the protected status.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149656" role="listitem" l10n="U" oldref="16">Select <emph>Tools - Protect Document</emph>, then choose <emph>Sheet</emph> or <emph>Document</emph> to remove the check mark indicating the protected status.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3145171" role="listitem" l10n="U" oldref="17">If you have assigned a password, enter it in this dialog and click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3145171" role="listitem" l10n="U" oldref="17">If you have assigned a password, enter it in this dialog and click <emph>OK</emph>.</paragraph> </listitem> </list> <paragraph xml-lang="en-US" id="par_id3153771" role="paragraph" l10n="U" oldref="18">The cells can now be edited, the formulas can be viewed, and all cells can be printed until you reactivate the protection for the sheet or document.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/cellcopy.xhp b/helpcontent2/source/text/scalc/guide/cellcopy.xhp index f966aa8b07..1fb57a4747 100755 --- a/helpcontent2/source/text/scalc/guide/cellcopy.xhp +++ b/helpcontent2/source/text/scalc/guide/cellcopy.xhp @@ -75,7 +75,7 @@ </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3166427" role="tablecontent" l10n="U" oldref="12">Cells were hidden using the <item type="menuitem">Hide</item> command in the context menu of the row or column headers, or through an <link href="text/scalc/01/12080000.xhp" name="outline">outline</link>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3166427" role="tablecontent" l10n="U" oldref="12">Cells were hidden using the <emph>Hide</emph> command in the context menu of the row or column headers, or through an <link href="text/scalc/01/12080000.xhp" name="outline">outline</link>.</paragraph> <paragraph xml-lang="en-US" id="par_id3152990" role="tablecontent" l10n="CHG" oldref="13">Copy, delete, move, or format a selection of currently visible cells.</paragraph> </tablecell> <tablecell> diff --git a/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp b/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp index 2fe2452ffc..faca94621c 100755 --- a/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp +++ b/helpcontent2/source/text/scalc/guide/cellreference_dragdrop.xhp @@ -55,7 +55,7 @@ <paragraph xml-lang="en-US" id="par_id3152576" role="listitem" l10n="U" oldref="25">Open the document that contains the source cells.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3154011" role="listitem" l10n="U" oldref="26">To set the source range as the range, select the cells and choose <item type="menuitem">Insert - Names - Define</item>. Save the source document, and do not close it.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154011" role="listitem" l10n="U" oldref="26">To set the source range as the range, select the cells and choose <emph>Insert - Names - Define</emph>. Save the source document, and do not close it.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3151073" role="listitem" l10n="U" oldref="18">Open the sheet in which you want to insert something.</paragraph> @@ -67,7 +67,7 @@ <paragraph xml-lang="en-US" id="par_id3150752" role="listitem" l10n="U" oldref="22">In the Navigator, the source file object appears under "Range names".</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3154754" role="listitem" l10n="U" oldref="27">Using the <item type="menuitem">Drag Mode</item> icon in Navigator, choose whether you want the reference to be a hyperlink, link, or copy.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154754" role="listitem" l10n="U" oldref="27">Using the <emph>Drag Mode</emph> icon in Navigator, choose whether you want the reference to be a hyperlink, link, or copy.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3154256" role="listitem" l10n="U" oldref="23">Click the name under "Range names" in the Navigator, and drag into the cell of the current sheet where you want to insert the reference.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/cellreferences.xhp b/helpcontent2/source/text/scalc/guide/cellreferences.xhp index 07d3f82612..9899931b29 100755 --- a/helpcontent2/source/text/scalc/guide/cellreferences.xhp +++ b/helpcontent2/source/text/scalc/guide/cellreferences.xhp @@ -63,19 +63,19 @@ </paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id7609790" role="listitem" l10n="NEW">Click the <item type="menuitem">Sheet 2</item> tab at the bottom of the spreadsheet. Set the cursor in cell A1 there and enter text or a number.</paragraph> + <paragraph xml-lang="en-US" id="par_id7609790" role="listitem" l10n="NEW">Click the <emph>Sheet 2</emph> tab at the bottom of the spreadsheet. Set the cursor in cell A1 there and enter text or a number.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id809961" role="listitem" l10n="NEW">If you switch back to <item type="menuitem">Sheet1</item>, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change.</paragraph> + <paragraph xml-lang="en-US" id="par_id809961" role="listitem" l10n="NEW">If you switch back to Sheet1, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change.</paragraph> </listitem> </list> <paragraph xml-lang="en-US" id="hd_id9209570" role="heading" level="2" l10n="NEW">To Reference a Cell in Another Document</paragraph> <list type="ordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id5949278" role="listitem" l10n="NEW">Choose <item type="menuitem">File - Open</item>, to load an existing spreadsheet document.</paragraph> + <paragraph xml-lang="en-US" id="par_id5949278" role="listitem" l10n="NEW">Choose <emph>File - Open</emph>, to load an existing spreadsheet document.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id8001953" role="listitem" l10n="NEW">Choose <item type="menuitem">File - New</item>, to open a new spreadsheet document. Set the cursor in the cell where you want to insert the external data and enter an equals sign to indicate that you want to begin a formula.</paragraph> + <paragraph xml-lang="en-US" id="par_id8001953" role="listitem" l10n="NEW">Choose <emph>File - New</emph>, to open a new spreadsheet document. Set the cursor in the cell where you want to insert the external data and enter an equals sign to indicate that you want to begin a formula.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id8571123" role="listitem" l10n="NEW">Now switch to the document you have just loaded. Click the cell with the data that you want to insert in the new document.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp b/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp index 49db1f1b47..a11288e033 100755 --- a/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp +++ b/helpcontent2/source/text/scalc/guide/cellreferences_url.xhp @@ -3,78 +3,78 @@ <!-- *********************************************************************** - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2008 by Sun Microsystems, Inc. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU Lesser General Public License version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************ - --> - +* +* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. +* +* Copyright 2008 by Sun Microsystems, Inc. +* +* OpenOffice.org - a multi-platform office productivity suite +* +* $RCSfile: soffice2xmlhelp.xsl,v $ +* $Revision: 1.8 $ +* +* This file is part of OpenOffice.org. +* +* OpenOffice.org is free software: you can redistribute it and/or modify +* it under the terms of the GNU Lesser General Public License version 3 +* only, as published by the Free Software Foundation. +* +* OpenOffice.org is distributed in the hope that it will be useful, +* but WITHOUT ANY WARRANTY; without even the implied warranty of +* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +* GNU Lesser General Public License version 3 for more details +* (a copy is included in the LICENSE file that accompanied this code). +* +* You should have received a copy of the GNU Lesser General Public License +* version 3 along with OpenOffice.org. If not, see +* <http://www.openoffice.org/license.html> +* for a copy of the LGPLv3 License. +* +************************************************************************ +--> + <meta> - <topic id="textscalcguidecellreferences_urlxml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">References to Other Sheets and Referencing URLs</title> - <filename>/text/scalc/guide/cellreferences_url.xhp</filename> - </topic> - </meta> - <body> +<topic id="textscalcguidecellreferences_urlxml" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">References to Other Sheets and Referencing URLs</title> +<filename>/text/scalc/guide/cellreferences_url.xhp</filename> +</topic> +</meta> +<body> <bookmark xml-lang="en-US" branch="index" id="bm_id3150441"><bookmark_value>HTML; in sheet cells</bookmark_value> - <bookmark_value>references; URL in cells</bookmark_value> - <bookmark_value>cells; Internet references</bookmark_value> - <bookmark_value>URL; in Calc</bookmark_value> +<bookmark_value>references; URL in cells</bookmark_value> +<bookmark_value>cells; Internet references</bookmark_value> +<bookmark_value>URL; in Calc</bookmark_value> </bookmark><comment>mw deleted "sheet references;"</comment> <paragraph xml-lang="en-US" id="hd_id3150441" role="heading" level="1" l10n="CHG" - oldref="15"><variable id="cellreferences_url"><link href="text/scalc/guide/cellreferences_url.xhp" name="Referencing URLs">Referencing URLs</link> +oldref="15"><variable id="cellreferences_url"><link href="text/scalc/guide/cellreferences_url.xhp" name="Referencing URLs">Referencing URLs</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="par_id1955626" role="paragraph" l10n="NEW">For example, if you found an Internet page containing current stock exchange information in spreadsheet cells, you can load this page in $[officename] Calc by using the following procedure:</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id3152993" role="listitem" l10n="U" oldref="39">In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3145384" role="listitem" l10n="U" oldref="40">Choose <item type="menuitem">Insert - Link to External Data</item>. The <link href="text/scalc/01/04090000.xhp" name="External Data"><item type="menuitem">External Data</item></link> dialog appears.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3152892" role="listitem" l10n="U" oldref="41">Enter the URL of the document or Web page in the dialog. The URL must be in the format: http://www.my-bank.com/table.html. The URL for local or local area network files is the path seen in the <item type="menuitem">File - Open</item> dialog.</paragraph> - <paragraph xml-lang="en-US" id="par_id3153068" role="listitem" l10n="U" oldref="42">$[officename] loads the Web page or file in the "background", that is, without displaying it. In the large list box of the <item type="menuitem">External Data</item> dialog, you can see the name of all the sheets or named ranges you can choose from.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3153914" role="listitem" l10n="U" oldref="43">Select one or more sheets or named ranges. You can also activate the automatic update function every "n" minutes and click <item type="menuitem">OK</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_id3157979" role="listitem" l10n="U" oldref="44">The contents will be inserted as a link in the $[officename] Calc document.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3144768" role="listitem" l10n="U" oldref="30">Save your spreadsheet. When you open it again later, $[officename] Calc will update the linked cells following an inquiry.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3159204" role="listitem" l10n="U" oldref="38">Under <link href="text/shared/optionen/01040900.xhp" name="Tools - Options - Spreadsheet - General"><item type="menuitem">Tools - Options - %PRODUCTNAME Calc - General</item></link> you can choose to have the update, when opened, automatically carried out either always, upon request or never. The update can be started manually in the dialog under <item type="menuitem">Edit - Links</item>.</paragraph> - </listitem> - </list> - <section id="relatedtopics"> - <embed href="text/scalc/guide/webquery.xhp#webquery"/> - <embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> - </section> - </body> +<paragraph xml-lang="en-US" id="par_id1955626" role="paragraph" l10n="NEW">For example, if you found an Internet page containing current stock exchange information in spreadsheet cells, you can load this page in $[officename] Calc by using the following procedure:</paragraph> +<list type="ordered"> +<listitem> +<paragraph xml-lang="en-US" id="par_id3152993" role="listitem" l10n="U" oldref="39">In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_id3145384" role="listitem" l10n="U" oldref="40">Choose <item type="menuitem">Insert - Link to External Data</item>. The <link href="text/scalc/01/04090000.xhp" name="External Data"><item type="menuitem">External Data</item></link> dialog appears.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_id3152892" role="listitem" l10n="U" oldref="41">Enter the URL of the document or Web page in the dialog. The URL must be in the format: http://www.my-bank.com/table.html. The URL for local or local area network files is the path seen in the <item type="menuitem">File - Open</item> dialog.</paragraph> +<paragraph xml-lang="en-US" id="par_id3153068" role="listitem" l10n="U" oldref="42">$[officename] loads the Web page or file in the "background", that is, without displaying it. In the large list box of the <item type="menuitem">External Data</item> dialog, you can see the name of all the sheets or named ranges you can choose from.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_id3153914" role="listitem" l10n="CHG" oldref="43">Select one or more sheets or named ranges. You can also activate the automatic update function every "n" seconds and click <item type="menuitem">OK</item>.</paragraph> +<paragraph xml-lang="en-US" id="par_id3157979" role="listitem" l10n="U" oldref="44">The contents will be inserted as a link in the $[officename] Calc document.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_id3144768" role="listitem" l10n="U" oldref="30">Save your spreadsheet. When you open it again later, $[officename] Calc will update the linked cells following an inquiry.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_id3159204" role="listitem" l10n="U" oldref="38">Under <link href="text/shared/optionen/01040900.xhp" name="Tools - Options - Spreadsheet - General"><item type="menuitem">Tools - Options - %PRODUCTNAME Calc - General</item></link> you can choose to have the update, when opened, automatically carried out either always, upon request or never. The update can be started manually in the dialog under <item type="menuitem">Edit - Links</item>.</paragraph> +</listitem> +</list> +<section id="relatedtopics"> +<embed href="text/scalc/guide/webquery.xhp#webquery"/> +<embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> +</section> +</body> </helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp b/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp index f83a1dc4ef..5ed2826561 100755 --- a/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp +++ b/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp @@ -48,7 +48,7 @@ <bookmark_value>formulas;assigning cell formats</bookmark_value> </bookmark><comment>mw deleted "applying;"</comment> <paragraph xml-lang="en-US" id="hd_id3145673" role="heading" level="1" l10n="U" - oldref="13"><variable id="cellstyle_by_formula"><link href="text/scalc/guide/cellstyle_by_formula.xhp" name="Assigning Formats by Formula">Assigning Formats by Formula</link> + oldref="13"><variable id="cellstyle_by_formula"><link href="text/scalc/guide/cellstyle_by_formula.xhp" name="Assigning Formats by Formula">Assigning Formats by Formula</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3150275" role="paragraph" l10n="CHG" oldref="14">The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3; "Red"; "Green")) applies the cell style "Red" to cells if the value is greater than 3, otherwise the cell style "Green" is applied.</paragraph> <paragraph xml-lang="en-US" id="par_id3151385" role="paragraph" l10n="U" oldref="15">If you would like to apply a formula to all cells in a selected area, you can use the<emph/> @@ -58,7 +58,7 @@ <paragraph xml-lang="en-US" id="par_id3149456" role="listitem" l10n="U" oldref="16">Select all the desired cells.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3148797" role="listitem" l10n="U" oldref="17">Select the menu command <item type="menuitem">Edit - Find & Replace</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3148797" role="listitem" l10n="U" oldref="17">Select the menu command <emph>Edit - Find & Replace</emph>.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3150767" role="listitem" l10n="U" oldref="18">For the <item type="menuitem">Search for</item> term, enter: .<item type="literal">*</item> @@ -68,10 +68,10 @@ <listitem> <paragraph xml-lang="en-US" id="par_id3153143" role="listitem" l10n="U" oldref="20">Enter the following formula in the <item type="menuitem">Replace with</item> field: <item type="literal">=&+STYLE(IF(CURRENT()>3;"Red";"Green"))</item> </paragraph> - <paragraph xml-lang="en-US" id="par_id3146975" role="listitem" l10n="U" oldref="21">The "&" symbol designates the current contents of the <item type="menuitem">Search for</item> field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles "Red" and "Green" already exist.</paragraph> + <paragraph xml-lang="en-US" id="par_id3146975" role="listitem" l10n="U" oldref="21">The "&" symbol designates the current contents of the <emph>Search for</emph> field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles "Red" and "Green" already exist.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3149262" role="listitem" l10n="U" oldref="22">Mark the fields <link href="text/shared/01/02100000.xhp" name="Regular expressions"><item type="menuitem">Regular expressions</item></link> and <item type="menuitem">Current selection only</item>. Click <item type="menuitem">Find All</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149262" role="listitem" l10n="U" oldref="22">Mark the fields <link href="text/shared/01/02100000.xhp" name="Regular expressions"><emph>Regular expressions</emph></link> and <emph>Current selection only</emph>. Click <emph>Find All</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_id3144767" role="listitem" l10n="U" oldref="24">All cells with contents that were included in the selection are now highlighted.</paragraph> </listitem> <listitem> diff --git a/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp b/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp index 6bd9c55a11..fe5b0785f5 100755 --- a/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp +++ b/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp @@ -54,8 +54,8 @@ <paragraph xml-lang="en-US" id="hd_id3149263" role="heading" level="1" l10n="U" oldref="24"><variable id="cellstyle_conditional"><link href="text/scalc/guide/cellstyle_conditional.xhp" name="Applying Conditional Formatting">Applying Conditional Formatting</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph" l10n="U" oldref="25">Using the menu command <item type="menuitem">Format - Conditional formatting</item>, the dialog allows you to define up to three conditions per cell, which must be met in order for the selected cells to have a particular format.</paragraph> - <paragraph xml-lang="en-US" id="par_id8039796" role="warning" l10n="NEW">To apply conditional formatting, AutoCalculate must be enabled. Choose <item type="menuitem">Tools - Cell Contents - AutoCalculate</item> (you see a check mark next to the command when AutoCalculate is enabled).</paragraph> + <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph" l10n="U" oldref="25">Using the menu command <emph>Format - Conditional formatting</emph>, the dialog allows you to define up to three conditions per cell, which must be met in order for the selected cells to have a particular format.</paragraph> + <paragraph xml-lang="en-US" id="par_id8039796" role="warning" l10n="NEW">To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Tools - Cell Contents - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).</paragraph> <paragraph xml-lang="en-US" id="par_id3154944" role="paragraph" l10n="U" oldref="26">With conditional formatting, you can, for example, highlight the totals that exceed the average value of all totals. If the totals change, the formatting changes correspondingly, without having to apply other styles manually.</paragraph> <paragraph xml-lang="en-US" id="hd_id4480727" role="heading" level="2" l10n="NEW">To Define the Conditions</paragraph> <list type="ordered"> @@ -63,7 +63,7 @@ <paragraph xml-lang="en-US" id="par_id3154490" role="listitem" l10n="U" oldref="27">Select the cells to which you want to apply a conditional style.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3155603" role="listitem" l10n="U" oldref="28">Choose <item type="menuitem">Format - Conditional Formatting</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155603" role="listitem" l10n="U" oldref="28">Choose <emph>Format - Conditional Formatting</emph>.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3146969" role="listitem" l10n="U" oldref="29">Enter the condition(s) into the dialog box. The dialog is described in detail in <link href="text/scalc/01/05120000.xhp" name="$[officename] Help">$[officename] Help</link>, and an example is provided below:</paragraph> @@ -76,7 +76,7 @@ <list type="ordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3155337" role="listitem" l10n="U" oldref="40">First of all, write a table in which a few different values occur. For your test you can create tables with any random numbers:</paragraph> - <paragraph xml-lang="en-US" id="par_id3149565" role="listitem" l10n="U" oldref="41">In one of the cells enter the formula <item type="literal">=RAND()</item>, and you will obtain a random number between 0 and 1. If you want integers of between 0 and 50, enter the formula <item type="literal">=INT(RAND()*50)</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149565" role="listitem" l10n="U" oldref="41">In one of the cells enter the formula =RAND(), and you will obtain a random number between 0 and 1. If you want integers of between 0 and 50, enter the formula =INT(RAND()*50).</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3149258" role="listitem" l10n="U" oldref="42">Copy the formula to create a row of random numbers. Click the bottom right corner of the selected cell, and drag to the right until the desired cell range is selected.</paragraph> @@ -90,13 +90,13 @@ <paragraph xml-lang="en-US" id="par_id3154659" role="paragraph" l10n="U" oldref="45">The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles and Formatting window is visible before proceeding.</paragraph> <list type="ordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3150883" role="listitem" l10n="U" oldref="46">Click in a blank cell and select the command <item type="menuitem">Format Cells</item> in the context menu.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150883" role="listitem" l10n="U" oldref="46">Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3155529" role="listitem" l10n="U" oldref="47">In the <item type="menuitem">Format Cells</item> dialog on the <item type="menuitem">Background</item> tab, select a background color. Click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155529" role="listitem" l10n="U" oldref="47">In the <emph>Format Cells</emph> dialog on the <emph>Background</emph> tab, select a background color. Click <emph>OK</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3154484" role="listitem" l10n="U" oldref="48">In the Styles and Formatting window, click the <item type="menuitem">New Style from Selection</item> icon. Enter the name of the new style. For this example, name the style "Above".</paragraph> + <paragraph xml-lang="en-US" id="par_id3154484" role="listitem" l10n="U" oldref="48">In the Styles and Formatting window, click the <emph>New Style from Selection</emph> icon. Enter the name of the new style. For this example, name the style "Above".</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3152889" role="listitem" l10n="U" oldref="49">To define a second style, click again in a blank cell and proceed as described above. Assign a different background color for the cell and assign a name (for this example, "Below").</paragraph> @@ -107,7 +107,7 @@ <paragraph xml-lang="en-US" id="par_id3148837" role="paragraph" l10n="U" oldref="51">In our particular example, we are calculating the average of the random values. The result is placed in a cell:</paragraph> <list type="ordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3144768" role="listitem" l10n="CHG" oldref="52">Set the cursor in a blank cell, for example, J14, and choose <item type="menuitem">Insert - Function</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3144768" role="listitem" l10n="CHG" oldref="52">Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3156016" role="listitem" l10n="CHG" oldref="53">Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the <link href="text/shared/00/00000001.xhp#eingabesymbol" name="Shrink or Maximize"><item type="menuitem">Shrink / Maximize</item></link> icon.</paragraph> @@ -124,7 +124,7 @@ <paragraph xml-lang="en-US" id="par_id3150049" role="listitem" l10n="U" oldref="56">Select all cells with the random numbers.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3153801" role="listitem" l10n="U" oldref="57">Choose the <item type="menuitem">Format - Conditional Formatting</item> command to open the corresponding dialog.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153801" role="listitem" l10n="U" oldref="57">Choose the <emph>Format - Conditional Formatting</emph> command to open the corresponding dialog.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3153013" role="listitem" l10n="U" oldref="58">Define the condition as follows: If cell value is less than J14, format with cell style "Below", and if cell value is greater than or equal to J14, format with cell style "Above".</paragraph> @@ -144,10 +144,10 @@ <paragraph xml-lang="en-US" id="par_id3150436" role="listitem" l10n="U" oldref="65">Select the cells that are to receive this same formatting.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3147298" role="listitem" l10n="U" oldref="66">Choose <item type="menuitem">Edit - Paste Special</item>. The <item type="menuitem">Paste Special</item> dialog appears.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147298" role="listitem" l10n="U" oldref="66">Choose <emph>Edit - Paste Special</emph>. The <emph>Paste Special</emph> dialog appears.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3166465" role="listitem" l10n="U" oldref="67">In the <item type="menuitem">Selection</item> area, check only the <item type="menuitem">Formats</item> box. All other boxes must be unchecked. Click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3166465" role="listitem" l10n="U" oldref="67">In the <emph>Selection</emph> area, check only the <emph>Formats</emph> box. All other boxes must be unchecked. Click <emph>OK</emph>.</paragraph> </listitem> </list> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/cellstyle_minusvalue.xhp b/helpcontent2/source/text/scalc/guide/cellstyle_minusvalue.xhp index 6df51672f5..9b1f686f2b 100755 --- a/helpcontent2/source/text/scalc/guide/cellstyle_minusvalue.xhp +++ b/helpcontent2/source/text/scalc/guide/cellstyle_minusvalue.xhp @@ -53,10 +53,10 @@ <paragraph xml-lang="en-US" id="par_id3153878" role="paragraph" l10n="U" oldref="33">You can format cells with a number format that highlights negative numbers in red. Alternatively, you can define your own number format in which negative numbers are highlighted in other colors.</paragraph> <list type="ordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3155600" role="listitem" l10n="U" oldref="34">Select the cells and choose <item type="menuitem">Format - Cells</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155600" role="listitem" l10n="U" oldref="34">Select the cells and choose <emph>Format - Cells</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3146969" role="listitem" l10n="U" oldref="35">On the <item type="menuitem">Numbers</item> tab, select a number format and mark <item type="menuitem">Negative numbers red</item> check box. Click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3146969" role="listitem" l10n="U" oldref="35">On the <emph>Numbers</emph> tab, select a number format and mark <emph>Negative numbers red</emph> check box. Click <emph>OK</emph>.</paragraph> </listitem> </list> <paragraph xml-lang="en-US" id="par_id3145640" role="paragraph" l10n="U" oldref="36">The cell number format is defined in two parts. The format for positive numbers and zero is defined in front of the semicolon; after the semicolon the formula for negative numbers is defined. You can change the code (RED) under <item type="menuitem">Format code</item>. For example, instead of RED, enter <item type="literal">YELLOW</item>. If the new code appears in the list after clicking the <item type="menuitem">Add</item> icon, this is a valid entry.</paragraph> diff --git a/helpcontent2/source/text/scalc/guide/consolidate.xhp b/helpcontent2/source/text/scalc/guide/consolidate.xhp index 78cd98a38c..79f02fbbb8 100755 --- a/helpcontent2/source/text/scalc/guide/consolidate.xhp +++ b/helpcontent2/source/text/scalc/guide/consolidate.xhp @@ -57,40 +57,40 @@ <paragraph xml-lang="en-US" id="par_id3151073" role="listitem" l10n="U" oldref="6">Open the document that contains the cell ranges to be consolidated.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3154513" role="listitem" l10n="U" oldref="7">Choose <item type="menuitem">Data - Consolidate</item> to open the <item type="menuitem">Consolidate</item> dialog.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154513" role="listitem" l10n="U" oldref="7">Choose <item type="menuitem">Data - Consolidate</item> to open the <emph>Consolidate</emph> dialog.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3147345" role="listitem" l10n="U" oldref="8">From the <item type="menuitem">Source data area</item> box select a source cell range to consolidate with other areas.</paragraph> - <paragraph xml-lang="en-US" id="par_id3149209" role="listitem" l10n="U" oldref="9">If the range is not named, click in the field next to the <item type="menuitem">Source data area</item>. A blinking text cursor appears. Type a reference for the first source data range or select the range with the mouse.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147345" role="listitem" l10n="U" oldref="8">From the <emph>Source data area</emph> box select a source cell range to consolidate with other areas.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149209" role="listitem" l10n="U" oldref="9">If the range is not named, click in the field next to the <emph>Source data area</emph>. A blinking text cursor appears. Type a reference for the first source data range or select the range with the mouse.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3155529" role="listitem" l10n="U" oldref="10">Click <item type="menuitem">Add</item> to insert the selected range in the <item type="menuitem">Consolidation areas</item> field.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155529" role="listitem" l10n="U" oldref="10">Click <emph>Add</emph> to insert the selected range in the <emph>Consolidation areas</emph> field.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3153816" role="listitem" l10n="U" oldref="11">Select additional ranges and click <item type="menuitem">Add</item> after each selection.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153816" role="listitem" l10n="U" oldref="11">Select additional ranges and click <emph>Add</emph> after each selection.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3157983" role="listitem" l10n="U" oldref="12">Specify where you want to display the result by selecting a target range from the <item type="menuitem">Copy results to</item> box.</paragraph> - <paragraph xml-lang="en-US" id="par_id3150215" role="listitem" l10n="U" oldref="13">If the target range is not named, click in the field next to <item type="menuitem">Copy results to</item> and enter the reference of the target range. Alternatively, you can select the range using the mouse or position the cursor in the top left cell of the target range.</paragraph> + <paragraph xml-lang="en-US" id="par_id3157983" role="listitem" l10n="U" oldref="12">Specify where you want to display the result by selecting a target range from the <emph>Copy results to</emph> box.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150215" role="listitem" l10n="U" oldref="13">If the target range is not named, click in the field next to <emph>Copy results to</emph> and enter the reference of the target range. Alternatively, you can select the range using the mouse or position the cursor in the top left cell of the target range.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3153813" role="listitem" l10n="U" oldref="14">Select a function from the <item type="menuitem">Function</item> box. The function specifies how the values of the consolidation ranges are linked. The "Sum" function is the default setting.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153813" role="listitem" l10n="U" oldref="14">Select a function from the <emph>Function</emph> box. The function specifies how the values of the consolidation ranges are linked. The "Sum" function is the default setting.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3149315" role="listitem" l10n="U" oldref="15">Click <item type="menuitem">OK</item> to consolidate the ranges.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149315" role="listitem" l10n="U" oldref="15">Click <emph>OK</emph> to consolidate the ranges.</paragraph> </listitem> </list> <paragraph xml-lang="en-US" id="par_idN107DE" role="heading" level="2" l10n="NEW">Additional Settings</paragraph> - <paragraph xml-lang="en-US" id="par_id3147250" role="paragraph" l10n="U" oldref="16">Click <item type="menuitem">More</item> in the <item type="menuitem">Consolidate</item> dialog to display additional settings:</paragraph> + <paragraph xml-lang="en-US" id="par_id3147250" role="paragraph" l10n="U" oldref="16">Click <emph>More</emph> in the <emph>Consolidate</emph> dialog to display additional settings:</paragraph> <list type="unordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3156400" role="listitem" l10n="U" oldref="17">Select <item type="menuitem">Link to source data</item> to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range.</paragraph> + <paragraph xml-lang="en-US" id="par_id3156400" role="listitem" l10n="U" oldref="17">Select <emph>Link to source data</emph> to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range.</paragraph> <paragraph xml-lang="en-US" id="par_id3150538" role="listitem" l10n="U" oldref="18">The corresponding cell references in the target range are inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed.</paragraph> </listitem> </list> <list type="unordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3149945" role="listitem" l10n="U" oldref="19">Under <item type="menuitem">Consolidate by</item>, select either <item type="menuitem">Row labels</item> or <item type="menuitem">Column labels</item> if the cells of the source data range are not to be consolidated corresponding to the identical position of the cell in the range, but instead according to a matching row label or column label.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149945" role="listitem" l10n="U" oldref="19">Under <emph>Consolidate by</emph>, select either <emph>Row labels</emph> or <emph>Column labels</emph> if the cells of the source data range are not to be consolidated corresponding to the identical position of the cell in the range, but instead according to a matching row label or column label.</paragraph> <paragraph xml-lang="en-US" id="par_id3157871" role="listitem" l10n="U" oldref="20">To consolidate by row labels or column labels, the label must be contained in the selected source ranges.</paragraph> <paragraph xml-lang="en-US" id="par_id3150478" role="note" l10n="U" oldref="21">The text in the labels must be identical, so that rows or columns can be accurately matched. If the row or column label does not match any that exist in the target range, it will be appended as a new row or column.</paragraph> </listitem> diff --git a/helpcontent2/source/text/scalc/guide/csv_files.xhp b/helpcontent2/source/text/scalc/guide/csv_files.xhp index 58574514c8..9fc1d70b89 100755 --- a/helpcontent2/source/text/scalc/guide/csv_files.xhp +++ b/helpcontent2/source/text/scalc/guide/csv_files.xhp @@ -33,87 +33,86 @@ ************************************************************************ --> - <meta> - <topic id="textscalcguidecsv_filesxml" indexer="include"> - <title xml-lang="en-US" id="tit"> Importing and Exporting CSV Files </title> - <filename>/text/scalc/guide/csv_files.xhp</filename> - </topic> - </meta> - <body> +<topic id="textscalcguidecsv_filesxml" indexer="include"> +<title xml-lang="en-US" id="tit"> Importing and Exporting CSV Files </title> +<filename>/text/scalc/guide/csv_files.xhp</filename> +</topic> +</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>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_value>tables; importing/exporting as text</bookmark_value> - <bookmark_value>text documents; importing to spreadsheets</bookmark_value> - <bookmark_value>opening;text csv files</bookmark_value> - <bookmark_value>saving;as text csv</bookmark_value> +<bookmark_value>data series import</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_value>tables; importing/exporting as text</bookmark_value> +<bookmark_value>text documents; importing to spreadsheets</bookmark_value> +<bookmark_value>opening;text csv files</bookmark_value> +<bookmark_value>saving;as text csv</bookmark_value> </bookmark><comment>MW deleted "importing;text data bases" and copied 4 index entries from scalc/guide/csv_formula.xhp</comment><comment>mw added "saving;" and "opening;"</comment> <paragraph xml-lang="en-US" id="par_idN10862" role="heading" 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 xml-lang="en-US" id="par_idN10880" role="paragraph" 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 xml-lang="en-US" id="par_idN10886" role="paragraph" 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 xml-lang="en-US" id="par_idN10890" role="heading" level="2" l10n="CHG">To Open a Text CSV File in Calc</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_idN10897" role="listitem" l10n="NEW">Choose <item type="menuitem">File - Open</item>.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN1089F" role="listitem" l10n="NEW">Locate the CSV file that you want to open.</paragraph> - <paragraph xml-lang="en-US" id="par_idN108A2" role="listitem" l10n="NEW">If the file has a *.csv extension, select the file.</paragraph> - <paragraph xml-lang="en-US" id="par_idN108A5" role="listitem" l10n="NEW">If the CSV file has another extension, select the file, and then select "Text CSV" in the <item type="menuitem">File type</item> box</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN1082D" role="listitem" l10n="NEW">Click <item type="menuitem">Open</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10834" role="listitem" l10n="NEW">The <item type="menuitem">Text Import</item> dialog opens.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN108B1" role="listitem" l10n="NEW">Specify the options to divide the text in the file into columns.</paragraph> - <paragraph xml-lang="en-US" id="par_idN108BB" role="listitem" l10n="NEW">You can preview the layout of the imported data at the bottom of the <item type="menuitem">Text Import</item> dialog. </paragraph> - <paragraph xml-lang="en-US" id="par_id8444166" role="listitem" l10n="NEW">Right-click a column in the preview to set the format or to hide the column.</paragraph> - <paragraph xml-lang="en-US" id="par_idN108E2" role="tip" l10n="NEW">If the CSV file uses a text delimiter character that is not listed in the <item type="menuitem">Text delimiter</item> box, click in the box, and type the character.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN108C5" role="listitem" l10n="NEW">Click <item type="menuitem">OK</item>.</paragraph> - </listitem> - </list> - <paragraph xml-lang="en-US" id="par_idN108FA" role="heading" level="2" l10n="NEW">To Save a Sheet as a Text CSV File</paragraph> - <paragraph xml-lang="en-US" id="par_idN106FC" role="note" 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 xml-lang="en-US" id="par_idN10901" role="listitem" l10n="NEW">Open the Calc sheet that you want to save as a Text CSV file.</paragraph> - <paragraph xml-lang="en-US" id="par_idN107AF" role="note" l10n="NEW">Only the current sheet can be exported.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN10905" role="listitem" l10n="NEW">Choose <item type="menuitem">File - Save as</item>.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN10915" role="listitem" l10n="NEW">In the <item type="menuitem">File name</item> box, enter a name for the file.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN1090D" role="listitem" l10n="NEW">In the <item type="menuitem">File type</item> box, select "Text CSV".</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN107DD" role="listitem" l10n="NEW">(Optional) Set the field options for the Text CSV file.</paragraph> - <paragraph xml-lang="en-US" id="par_idN1091C" role="listitem" l10n="NEW">Select <item type="menuitem">Edit filter settings</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_idN107ED" role="listitem" l10n="NEW">In the <item type="menuitem">Export of text files</item> dialog, select the options that you want.</paragraph> - <paragraph xml-lang="en-US" id="par_idN107F4" role="listitem" l10n="NEW">Click <item type="menuitem">OK</item>.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_idN107FC" role="listitem" l10n="NEW">Click <item type="menuitem">Save</item>.</paragraph> - </listitem> - </list> - <section id="relatedtopics"> - <embed href="text/scalc/guide/csv_formula.xhp#csv_formula"/> - <embed href="text/shared/guide/data_im_export.xhp#data_im_export"/> - <paragraph xml-lang="en-US" id="par_id3153487" role="paragraph" l10n="U" oldref="20"><link href="text/shared/optionen/01060100.xhp" name="Tools - Options - Spreadsheet - View">Tools - Options - %PRODUCTNAME Calc - View</link></paragraph> - <paragraph xml-lang="en-US" id="par_id3153008" role="paragraph" l10n="U" oldref="21"><link href="text/shared/00/00000207.xhp" name="Export text files">Export text files</link></paragraph> - <paragraph xml-lang="en-US" id="par_id3155595" role="paragraph" l10n="U" oldref="22"><link href="text/shared/00/00000208.xhp" name="Import text files">Import text files</link></paragraph> - </section> - </body> +<paragraph xml-lang="en-US" id="par_idN10880" role="paragraph" l10n="NEW">Comma Separated Values (CSV) is a 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 xml-lang="en-US" id="par_idN10886" role="paragraph" l10n="NEW">If the field or cell contains a comma, the field or cell <emph>must</emph> be enclosed by single quotes (') or double quotes (").</paragraph> +<paragraph xml-lang="en-US" id="par_idN10890" role="heading" level="2" l10n="CHG">To Open a Text CSV File in Calc</paragraph> +<list type="ordered"> +<listitem> +<paragraph xml-lang="en-US" id="par_idN10897" role="listitem" l10n="NEW">Choose <item type="menuitem">File - Open</item>.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_idN1089F" role="listitem" l10n="NEW">Locate the CSV file that you want to open.</paragraph> +<paragraph xml-lang="en-US" id="par_idN108A2" role="listitem" l10n="NEW">If the file has a *.csv extension, select the file.</paragraph> +<paragraph xml-lang="en-US" id="par_idN108A5" role="listitem" l10n="NEW">If the CSV file has another extension, select the file, and then select "Text CSV" in the <item type="menuitem">File type</item> box</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_idN1082D" role="listitem" l10n="NEW">Click <item type="menuitem">Open</item>.</paragraph> +<paragraph xml-lang="en-US" id="par_idN10834" role="listitem" l10n="NEW">The <item type="menuitem">Text Import</item> dialog opens.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_idN108B1" role="listitem" l10n="NEW">Specify the options to divide the text in the file into columns.</paragraph> +<paragraph xml-lang="en-US" id="par_idN108BB" role="listitem" l10n="NEW">You can preview the layout of the imported data at the bottom of the <item type="menuitem">Text Import</item> dialog. </paragraph> +<paragraph xml-lang="en-US" id="par_id8444166" role="listitem" l10n="NEW">Right-click a column in the preview to set the format or to hide the column.</paragraph> +<paragraph xml-lang="en-US" id="par_idN108E2" role="tip" l10n="CHG">Check the text delimiter box that matches the character used as text delimiter in the file. In case of an unlisted delimiter, type the character into the input box.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_idN108C5" role="listitem" l10n="NEW">Click <item type="menuitem">OK</item>.</paragraph> +</listitem> +</list> +<paragraph xml-lang="en-US" id="par_idN108FA" role="heading" level="2" l10n="NEW">To Save a Sheet as a Text CSV File</paragraph> +<paragraph xml-lang="en-US" id="par_idN106FC" role="note" 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 xml-lang="en-US" id="par_idN10901" role="listitem" l10n="NEW">Open the Calc sheet that you want to save as a Text CSV file.</paragraph> +<paragraph xml-lang="en-US" id="par_idN107AF" role="note" l10n="NEW">Only the current sheet can be exported.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_idN10905" role="listitem" l10n="NEW">Choose <item type="menuitem">File - Save as</item>.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_idN10915" role="listitem" l10n="NEW">In the <item type="menuitem">File name</item> box, enter a name for the file.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_idN1090D" role="listitem" l10n="NEW">In the <item type="menuitem">File type</item> box, select "Text CSV".</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_idN107DD" role="listitem" l10n="NEW">(Optional) Set the field options for the Text CSV file.</paragraph> +<paragraph xml-lang="en-US" id="par_idN1091C" role="listitem" l10n="NEW">Select <item type="menuitem">Edit filter settings</item>.</paragraph> +<paragraph xml-lang="en-US" id="par_idN107ED" role="listitem" l10n="NEW">In the <item type="menuitem">Export of text files</item> dialog, select the options that you want.</paragraph> +<paragraph xml-lang="en-US" id="par_idN107F4" role="listitem" l10n="NEW">Click <item type="menuitem">OK</item>.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_idN107FC" role="listitem" l10n="NEW">Click <item type="menuitem">Save</item>.</paragraph> +</listitem> +</list> +<section id="relatedtopics"> +<embed href="text/scalc/guide/csv_formula.xhp#csv_formula"/> +<embed href="text/shared/guide/data_im_export.xhp#data_im_export"/> +<paragraph xml-lang="en-US" id="par_id3153487" role="paragraph" l10n="U" oldref="20"><link href="text/shared/optionen/01060100.xhp" name="Tools - Options - Spreadsheet - View">Tools - Options - %PRODUCTNAME Calc - View</link></paragraph> +<paragraph xml-lang="en-US" id="par_id3153008" role="paragraph" l10n="U" oldref="21"><link href="text/shared/00/00000207.xhp" name="Export text files">Export text files</link></paragraph> +<paragraph xml-lang="en-US" id="par_id3155595" role="paragraph" l10n="U" oldref="22"><link href="text/shared/00/00000208.xhp" name="Import text files">Import text files</link></paragraph> +</section> +</body> </helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/csv_formula.xhp b/helpcontent2/source/text/scalc/guide/csv_formula.xhp index 5e29c0ea5b..906c6e28ce 100755 --- a/helpcontent2/source/text/scalc/guide/csv_formula.xhp +++ b/helpcontent2/source/text/scalc/guide/csv_formula.xhp @@ -53,16 +53,16 @@ oldref="15">To Import a CSV File</paragraph> <list type="ordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3153709" role="listitem" l10n="U" oldref="16">Choose <item type="menuitem">File - Open</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153709" role="listitem" l10n="U" oldref="16">Choose <emph>File - Open</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3155445" role="listitem" l10n="U" oldref="17">In the <item type="menuitem">File type</item> field, select the format "Text CSV". Select the file and click <item type="menuitem">Open</item>. When a file has the .csv extension, the file type is automatically recognized.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155445" role="listitem" l10n="U" oldref="17">In the <emph>File type</emph> field, select the format "Text CSV". Select the file and click <emph>Open</emph>. When a file has the .csv extension, the file type is automatically recognized.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3149565" role="listitem" l10n="U" oldref="18">You will see the <item type="menuitem">Text Import</item> dialog. Click <item type="menuitem">OK</item>.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id3149255" role="tip" l10n="CHG" oldref="19">If the csv file contains formulas, but you want to import the results of those formulas, then choose <item type="menuitem">Tools - Options - %PRODUCTNAME Calc - View</item> and clear the <item type="menuitem">Formulas</item> check box.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149255" role="tip" l10n="CHG" oldref="19">If the csv file contains formulas, but you want to import the results of those formulas, then choose <emph>Tools - Options - %PRODUCTNAME Calc - View</emph> and clear the <emph>Formulas</emph> check box.</paragraph> <paragraph xml-lang="en-US" id="hd_id3154022" role="heading" level="2" l10n="U" oldref="3">To Export Formulas and Values as CSV Files</paragraph> <list type="ordered"> <listitem> @@ -70,26 +70,26 @@ </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3166423" role="listitem" l10n="U" oldref="5">If you want to export the formulas as formulas, for example, in the form =SUM(A1:B5), proceed as follows:</paragraph> - <paragraph xml-lang="en-US" id="par_id3155111" role="listitem" l10n="U" oldref="6">Choose <item type="menuitem">Tools - Options - %PRODUCTNAME Calc - View</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_id3150200" role="listitem" l10n="U" oldref="7">Under <item type="menuitem">Display</item>, mark the <item type="menuitem">Formulas</item> check box. Click <item type="menuitem">OK</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_id3154484" role="listitem" l10n="U" oldref="8">If you want to export the calculation results instead of the formulas, do not mark <item type="menuitem">Formulas</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155111" role="listitem" l10n="U" oldref="6">Choose <emph>Tools - Options - %PRODUCTNAME Calc - View</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150200" role="listitem" l10n="U" oldref="7">Under <emph>Display</emph>, mark the <emph>Formulas</emph> check box. Click <emph>OK</emph>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154484" role="listitem" l10n="U" oldref="8">If you want to export the calculation results instead of the formulas, do not mark <emph>Formulas</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3148702" role="listitem" l10n="U" oldref="9">Choose <item type="menuitem">File - Save as</item>. You will see the <item type="menuitem">Save as</item> dialog.</paragraph> + <paragraph xml-lang="en-US" id="par_id3148702" role="listitem" l10n="U" oldref="9">Choose <emph>File - Save as</emph>. You will see the <emph>Save as</emph> dialog.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3153912" role="listitem" l10n="U" oldref="10">In the<emph/> <item type="menuitem">File type</item> field select the format "Text CSV".</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3157978" role="listitem" l10n="U" oldref="13">Enter a name and click <item type="menuitem">Save</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3157978" role="listitem" l10n="U" oldref="13">Enter a name and click <emph>Save</emph>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3152869" role="listitem" l10n="U" oldref="23">From the <item type="menuitem">Export of text files</item> dialog that appears, select the character set and the field and text delimiters for the data to be exported, and confirm with <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3152869" role="listitem" l10n="U" oldref="23">From the <emph>Export of text files</emph> dialog that appears, select the character set and the field and text delimiters for the data to be exported, and confirm with <emph>OK</emph>.</paragraph> <paragraph xml-lang="en-US" id="par_id3146781" role="warning" l10n="U" oldref="12">If the numbers use commas as decimal separators or thousands separators, do not select the comma as the field delimiter. If the text contains double quotation marks, you must select the single quotation mark as separator.<comment>not possible to have a table here because that would break the numbering in XML.</comment></paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3150050" role="listitem" l10n="U" oldref="14">If necessary, after you have saved, clear the <item type="menuitem">Formulas</item> check box to see the calculated results in the table again.</paragraph> + <paragraph xml-lang="en-US" id="par_id3150050" role="listitem" l10n="U" oldref="14">If necessary, after you have saved, clear the <emph>Formulas</emph> check box to see the calculated results in the table again.</paragraph> </listitem> </list> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/currency_format.xhp b/helpcontent2/source/text/scalc/guide/currency_format.xhp index 7eb6a0b67e..b7d1544a9a 100644 --- a/helpcontent2/source/text/scalc/guide/currency_format.xhp +++ b/helpcontent2/source/text/scalc/guide/currency_format.xhp @@ -35,41 +35,40 @@ <meta> - <topic id="textscalcguidecurrency_formatxml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Cells in Currency Format</title> - <filename>/text/scalc/guide/currency_format.xhp</filename> - </topic> - </meta> - <body> +<topic id="textscalcguidecurrency_formatxml" indexer="include" status="PUBLISH"> +<title xml-lang="en-US" id="tit">Cells in Currency Format</title> +<filename>/text/scalc/guide/currency_format.xhp</filename> +</topic> +</meta> +<body> <bookmark xml-lang="en-US" branch="index" id="bm_id3156329"><bookmark_value>currency formats; spreadsheets</bookmark_value> - <bookmark_value>cells; currency formats</bookmark_value> - <bookmark_value>international currency formats</bookmark_value> - <bookmark_value>formats; currency formats in cells</bookmark_value> - <bookmark_value>currencies; default currencies</bookmark_value> - <bookmark_value>defaults;currency formats</bookmark_value> - <bookmark_value>changing;currency formats</bookmark_value> +<bookmark_value>cells; currency formats</bookmark_value> +<bookmark_value>international currency formats</bookmark_value> +<bookmark_value>formats; currency formats in cells</bookmark_value> +<bookmark_value>currencies; default currencies</bookmark_value> +<bookmark_value>defaults;currency formats</bookmark_value> +<bookmark_value>changing;currency formats</bookmark_value> </bookmark><comment>mw changed one index entry</comment> <paragraph xml-lang="en-US" id="hd_id3156329" role="heading" level="1" l10n="U" - oldref="46"><variable id="currency_format"><link href="text/scalc/guide/currency_format.xhp" name="Cells in Currency Format">Cells in Currency Format</link> +oldref="46"><variable id="currency_format"><link href="text/scalc/guide/currency_format.xhp" name="Cells in Currency Format">Cells in Currency Format</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3153968" role="paragraph" l10n="CHG" oldref="47">In <item type="productname">%PRODUCTNAME</item> Calc you can give numbers any currency format. When you click the <item type="menuitem">Currency</item> icon -<image id="img_id3150791" src="res/commandimagelist/sc_currencyfield.png" width="0.423cm" height="0.423cm"><alt xml-lang="en-US" id="alt_id3150791">Icon</alt> - </image> in the <item type="menuitem">Formatting</item> - <emph/>bar to format a number, the cell is given the default currency format set under <item type="menuitem">Tools - Options - Language Settings - Languages</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_id3150010" role="note" l10n="CHG" oldref="48">Exchanging of <item type="productname">%PRODUCTNAME</item> Calc documents can lead to misunderstandings, if your <item type="productname">%PRODUCTNAME</item> Calc document is loaded by a user who uses a different default currency format.</paragraph> - <paragraph xml-lang="en-US" id="par_id3156442" role="paragraph" l10n="U" oldref="52">In <item type="productname">%PRODUCTNAME</item> Calc you can define that a number that you have formatted as "1,234.50 €", still remains in euros in another country and does not become dollars.</paragraph> - <paragraph xml-lang="en-US" id="par_id3151075" role="paragraph" l10n="U" oldref="49">You can change the currency format in the <item type="menuitem">Format Cells</item> dialog (choose <item type="menuitem">Format - Cells - Numbers</item> tab) by two country settings. In the <item type="menuitem">Language</item> combo box select the basic setting for currency symbol, decimal and thousands separators. In the <item type="menuitem">Format</item> list box you can select possible variations from the default format for the language.</paragraph> - <list type="ordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id3150749" role="listitem" l10n="U" oldref="50">For example, if the language is set to "Default" and you are using a german locale setting, the currency format will be "1.234,00 €". A point is used before the thousand digits and a comma before the decimal places. If you now select the subordinate currency format "$ English (US)" from the <item type="menuitem">Format</item> list box , you will get the following format: "$ 1.234,00". As you can see, the separators have remained the same. Only the currency symbol has been changed and converted, but the underlying format of the notation remains the same as in the locale setting.</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id3145640" role="listitem" l10n="U" oldref="51">If, under <item type="menuitem">Language</item>, you convert the cells to "English (US)", the English-language locale setting is also transferred and the default currency format is now "$ 1,234.00".</paragraph> - </listitem> - </list> - <section id="relatedtopics"> - <embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> - <paragraph xml-lang="en-US" id="par_id3154255" role="paragraph" l10n="U" oldref="53"><link href="text/shared/01/05020300.xhp" name="Format - Cell - Numbers">Format - Cell - Numbers</link></paragraph> - </section> - </body> +<paragraph xml-lang="en-US" id="par_id3153968" role="paragraph" l10n="CHG" oldref="47">In <item type="productname">%PRODUCTNAME</item> Calc you can give numbers any currency format. When you click the <item type="menuitem">Currency</item> icon +<image id="img_id3150791" src="res/commandimagelist/sc_currencyfield.png" width="0.1665in" height="0.1665in"><alt xml-lang="en-US" id="alt_id3150791">Icon</alt> +</image> in the <item type="menuitem">Formatting</item> bar to format a number, the cell is given the default currency format set under <item type="menuitem">Tools - Options - Language Settings - Languages</item>.</paragraph> +<paragraph xml-lang="en-US" id="par_id3150010" role="note" l10n="CHG" oldref="48">Exchanging of <item type="productname">%PRODUCTNAME</item> Calc documents can lead to misunderstandings, if your <item type="productname">%PRODUCTNAME</item> Calc document is loaded by a user who uses a different default currency format.</paragraph> +<paragraph xml-lang="en-US" id="par_id3156442" role="paragraph" l10n="U" oldref="52">In <item type="productname">%PRODUCTNAME</item> Calc you can define that a number that you have formatted as "1,234.50 €", still remains in euros in another country and does not become dollars.</paragraph> +<paragraph xml-lang="en-US" id="par_id3151075" role="paragraph" l10n="CHG" oldref="49">You can change the currency format in the <item type="menuitem">Format Cells</item> dialog (choose <item type="menuitem">Format - Cells - Numbers</item> tab) by two country settings. In the <item type="menuitem">Language</item> combo box select the basic setting for decimal and thousands separators. In the <item type="menuitem">Format</item> list box you can select the currency symbol and its position.</paragraph> +<list type="ordered"> +<listitem> +<paragraph xml-lang="en-US" id="par_id3150749" role="listitem" l10n="U" oldref="50">For example, if the language is set to "Default" and you are using a german locale setting, the currency format will be "1.234,00 €". A point is used before the thousand digits and a comma before the decimal places. If you now select the subordinate currency format "$ English (US)" from the <item type="menuitem">Format</item> list box , you will get the following format: "$ 1.234,00". As you can see, the separators have remained the same. Only the currency symbol has been changed and converted, but the underlying format of the notation remains the same as in the locale setting.</paragraph> +</listitem> +<listitem> +<paragraph xml-lang="en-US" id="par_id3145640" role="listitem" l10n="U" oldref="51">If, under <item type="menuitem">Language</item>, you convert the cells to "English (US)", the English-language locale setting is also transferred and the default currency format is now "$ 1,234.00".</paragraph> +</listitem> +</list> +<section id="relatedtopics"> +<embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> +<paragraph xml-lang="en-US" id="par_id3154255" role="paragraph" l10n="U" oldref="53"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link></paragraph> +</section> +</body> </helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/database_define.xhp b/helpcontent2/source/text/scalc/guide/database_define.xhp index fd95524886..bbcdeda893 100755 --- a/helpcontent2/source/text/scalc/guide/database_define.xhp +++ b/helpcontent2/source/text/scalc/guide/database_define.xhp @@ -60,16 +60,16 @@ <paragraph xml-lang="en-US" id="par_idN10654" role="listitem" l10n="NEW">Choose <item type="menuitem">Data - Define Range</item>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3153715" role="listitem" l10n="U" oldref="72">In the <item type="menuitem">Name</item> box, enter a name for the database range.</paragraph> + <paragraph xml-lang="en-US" id="par_id3153715" role="listitem" l10n="U" oldref="72">In the <emph>Name</emph> box, enter a name for the database range.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN1066A" role="listitem" l10n="NEW">Click <item type="menuitem">More</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN1066A" role="listitem" l10n="NEW">Click <emph>More</emph>.</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3154253" role="listitem" l10n="U" oldref="42">Specify the options for the database range.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN10675" role="listitem" l10n="NEW">Click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10675" role="listitem" l10n="NEW">Click <emph>OK</emph>.</paragraph> </listitem> </list> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/database_filter.xhp b/helpcontent2/source/text/scalc/guide/database_filter.xhp index 077d5037c9..2a008bbcb8 100755 --- a/helpcontent2/source/text/scalc/guide/database_filter.xhp +++ b/helpcontent2/source/text/scalc/guide/database_filter.xhp @@ -59,10 +59,10 @@ <paragraph xml-lang="en-US" id="par_idN10693" role="listitem" l10n="NEW">Choose <item type="menuitem">Data - Filter - Standard Filter</item>.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3156422" role="listitem" l10n="CHG" oldref="51">In the <item type="menuitem">Standard Filter</item> dialog, specify the filter options that you want.</paragraph> + <paragraph xml-lang="en-US" id="par_id3156422" role="listitem" l10n="CHG" oldref="51">In the <emph>Standard Filter</emph> dialog, specify the filter options that you want.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN106A5" role="listitem" l10n="NEW">Click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN106A5" role="listitem" l10n="NEW">Click <emph>OK</emph>.</paragraph> <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> diff --git a/helpcontent2/source/text/scalc/guide/database_sort.xhp b/helpcontent2/source/text/scalc/guide/database_sort.xhp index 2aaf2e1177..debf70ce97 100755 --- a/helpcontent2/source/text/scalc/guide/database_sort.xhp +++ b/helpcontent2/source/text/scalc/guide/database_sort.xhp @@ -61,7 +61,7 @@ <paragraph xml-lang="en-US" id="par_idN10645" role="listitem" l10n="NEW">Select the sort options that you want.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN1063D" role="listitem" l10n="NEW">Click <item type="menuitem">OK</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN1063D" role="listitem" l10n="NEW">Click <emph>OK</emph>.</paragraph> </listitem> </list> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp index 9bc374e69f..d52bd4fb4b 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp @@ -51,17 +51,17 @@ <paragraph xml-lang="en-US" id="par_id3156023" role="listitem" l10n="U" oldref="8">Position the cursor within a range of cells containing values, row and column headings.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3147264" role="listitem" l10n="CHG" oldref="9">Choose <item type="menuitem">Data - DataPilot - Start</item>. The <item type="menuitem">Select Source</item> dialog appears. Choose <item type="menuitem">Current selection</item> and confirm with <item type="menuitem">OK</item>. The table headings are shown as buttons in the <item type="menuitem">DataPilot</item> dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields".</paragraph> + <paragraph xml-lang="en-US" id="par_id3147264" role="listitem" l10n="CHG" oldref="9">Choose <emph>Data - DataPilot - Start</emph>. The <emph>Select Source</emph> dialog appears. Choose <emph>Current selection</emph> and confirm with <emph>OK</emph>. The table headings are shown as buttons in the <emph>DataPilot</emph> dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields".</paragraph> </listitem> <listitem> <paragraph xml-lang="en-US" id="par_id3150868" role="listitem" l10n="CHG" oldref="10">Drag the desired buttons into one of the four areas.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id7599414" role="paragraph" l10n="NEW">Drag a button to the <item type="menuitem">Page Fields</item> area to create a button and a listbox on top of the generated datapilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter.</paragraph> - <paragraph xml-lang="en-US" id="par_id3154011" role="paragraph" l10n="CHG" oldref="11">If the button is dropped in the <item type="menuitem">Data Fields</item> area it will be given a caption that also shows the formula that will be used to calculate the data.</paragraph> + <paragraph xml-lang="en-US" id="par_id7599414" role="paragraph" l10n="NEW">Drag a button to the <emph>Page Fields</emph> area to create a button and a listbox on top of the generated datapilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154011" role="paragraph" l10n="CHG" oldref="11">If the button is dropped in the <emph>Data Fields</emph> area it will be given a caption that also shows the formula that will be used to calculate the data.</paragraph> <list type="unordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3146974" role="listitem" l10n="CHG" oldref="16">By double-clicking on one of the fields in the <item type="menuitem">Data Fields</item> area you can call up the <link href="text/scalc/01/12090105.xhp" name="Data Field"><item type="menuitem">Data Field</item></link> dialog.</paragraph> + <paragraph xml-lang="en-US" id="par_id3146974" role="listitem" 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> <listitem> <paragraph xml-lang="en-US" id="par_id3156286" role="listitem" l10n="U" oldref="17">Use the <item type="menuitem">Data Field</item> 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 @@ -76,10 +76,10 @@ <paragraph xml-lang="en-US" id="par_id3153714" role="listitem" l10n="U" oldref="14">Remove a button by dragging it back to the area of the other buttons at the right of the dialog.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3147338" role="listitem" l10n="U" oldref="15">To open the <link href="text/scalc/01/12090105.xhp" name="Data Field"><item type="menuitem">Data Field</item></link> dialog, double-click one of the buttons in the <item type="menuitem">Row</item> or <item type="menuitem">Column</item> area. Use the dialog to select if and to what extent <item type="productname">%PRODUCTNAME</item> calculates display subtotals.</paragraph> + <paragraph xml-lang="en-US" id="par_id3147338" role="listitem" l10n="U" oldref="15">To open the <link href="text/scalc/01/12090105.xhp" name="Data Field"><emph>Data Field</emph></link> dialog, double-click one of the buttons in the <emph>Row</emph> or <emph>Column</emph> area. Use the dialog to select if and to what extent <item type="productname">%PRODUCTNAME</item> calculates display subtotals.</paragraph> </listitem> </list> - <paragraph xml-lang="en-US" id="par_id3154020" role="paragraph" l10n="CHG" oldref="18">Exit the DataPilot dialog by pressing <item type="menuitem">OK</item>. A <item type="menuitem">Filter</item> button will now be inserted, or a page button for every data field that you dropped in the <item type="menuitem">Page Fields</item> area. The DataPilot table is inserted further down.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154020" role="paragraph" l10n="CHG" oldref="18">Exit the DataPilot dialog by pressing OK. A <emph>Filter</emph> button will now be inserted, or a page button for every data field that you dropped in the <emph>Page Fields</emph> area. The DataPilot table is inserted further down.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> <embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/> diff --git a/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp index 20b7ddf137..680fc89aa6 100755 --- a/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_deletetable.xhp @@ -47,7 +47,7 @@ <paragraph xml-lang="en-US" id="hd_id3153726" role="heading" level="1" l10n="U" oldref="31"><variable id="datapilot_deletetable"><link href="text/scalc/guide/datapilot_deletetable.xhp" name="Deleting DataPilot Tables">Deleting DataPilot Tables</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3154014" role="paragraph" l10n="U" oldref="32">In order to delete a DataPilot table, select any cell in the DataPilot table, then choose <item type="menuitem">Delete</item> in the context menu.</paragraph> + <paragraph xml-lang="en-US" id="par_id3154014" role="paragraph" l10n="U" oldref="32">In order to delete a DataPilot table, select any cell in the DataPilot table, then choose <emph>Delete</emph> in the context menu.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> diff --git a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp index b127c48274..821d21dc6f 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp @@ -49,9 +49,9 @@ </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3150868" role="paragraph" l10n="U" oldref="26">Click one of the buttons in the table that the DataPilot has created and hold the mouse button down. A special symbol will appear next to the mouse pointer.</paragraph> <paragraph xml-lang="en-US" id="par_id3145786" role="paragraph" l10n="U" oldref="27">By dragging the button to a different position in the same row you can alter the order of the columns. If you drag a button to the left edge of the table into the row headings area, you can change a column into a row.</paragraph> - <paragraph xml-lang="en-US" id="par_id1648915" role="paragraph" l10n="NEW">In the <item type="menuitem">DataPilot</item> dialog, you can drag a button to the <item type="menuitem">Page Fields</item> area to create a button and a listbox on top of the generated DataPilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter.</paragraph> + <paragraph xml-lang="en-US" id="par_id1648915" role="paragraph" l10n="NEW">In the DataPilot dialog, you can drag a button to the <emph>Page Fields</emph> area to create a button and a listbox on top of the generated DataPilot table. The listbox can be used to filter the DataPilot table by the contents of the selected item. You can use drag-and-drop within the generated DataPilot table to use another page field as a filter.</paragraph> <paragraph xml-lang="en-US" id="par_id3147434" role="paragraph" l10n="U" oldref="29">To remove a button from the table, just drag it out of the DataPilot table. Release the mouse button when the mouse pointer positioned within the sheet has become a 'not allowed' icon. The button is deleted.</paragraph> - <paragraph xml-lang="en-US" id="par_id3156442" role="paragraph" l10n="U" oldref="40">To edit the DataPilot table, click a cell inside the DataPilot table and open the context menu. In the context menu you find the command <item type="menuitem">Start</item>, which displays the <item type="menuitem">DataPilot</item> dialog for the current DataPilot table.</paragraph> + <paragraph xml-lang="en-US" id="par_id3156442" role="paragraph" l10n="U" oldref="40">To edit the DataPilot table, click a cell inside the DataPilot table and open the context menu. In the context menu you find the command <emph>Start</emph>, which displays the <emph>DataPilot</emph> dialog for the current DataPilot table.</paragraph> <paragraph xml-lang="en-US" id="par_id2666096" role="paragraph" l10n="NEW">In the DataPilot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields.</paragraph> <paragraph xml-lang="en-US" id="par_id3149401" role="tip" l10n="U" oldref="38">By double-clicking on some buttons inside the DataPilot table you can hide the subelements below it.</paragraph> <section id="relatedtopics"> diff --git a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp index 8ccc274ede..b80637dfdc 100644 --- a/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp +++ b/helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp @@ -48,7 +48,7 @@ oldref="35"><variable id="datapilot_filtertable"><link href="text/scalc/guide/datapilot_filtertable.xhp" name="Filtering DataPilot Tables">Filtering DataPilot Tables</link> </variable></paragraph> <paragraph xml-lang="en-US" id="par_id3153192" role="paragraph" l10n="U" oldref="36">You can use filters to remove unwanted data from a DataPilot table.</paragraph><comment>UFI: removed help id</comment> -<paragraph xml-lang="en-US" id="par_id3150441" role="paragraph" l10n="CHG" oldref="37">Click the <item type="menuitem">Filter</item> button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the DataPilot table and select the <item type="menuitem">Filter</item> command. The <link href="text/scalc/01/12090103.xhp" name="Filter"><item type="menuitem">Filter</item></link> dialog appears. Here you can filter the DataPilot table.</paragraph> +<paragraph xml-lang="en-US" id="par_id3150441" role="paragraph" l10n="CHG" oldref="37">Click the <emph>Filter</emph> button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the DataPilot table and select the <emph>Filter</emph> command. The <link href="text/scalc/01/12090103.xhp" name="Filter"><emph>Filter</emph></link> dialog appears. Here you can filter the DataPilot table.</paragraph> <section id="relatedtopics"> <embed href="text/scalc/guide/datapilot.xhp#datapilot"/> <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/> diff --git a/helpcontent2/source/text/scalc/guide/filters.xhp b/helpcontent2/source/text/scalc/guide/filters.xhp index d530d44b41..5439789333 100755 --- a/helpcontent2/source/text/scalc/guide/filters.xhp +++ b/helpcontent2/source/text/scalc/guide/filters.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,9 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: filters.xhp,v $ - * - * $Revision: 1.12 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -37,37 +35,38 @@ <meta> -<topic id="textscalcguidefiltersxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Applying Filters</title> -<filename>/text/scalc/guide/filters.xhp</filename> -</topic> -</meta> -<body> + <topic id="textscalcguidefiltersxml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Applying Filters</title> + <filename>/text/scalc/guide/filters.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3153896"><bookmark_value>filters; applying/removing</bookmark_value> -<bookmark_value>rows;removing/redisplaying with filters</bookmark_value> -<bookmark_value>removing;filters</bookmark_value> -</bookmark><comment>MW deleted "filters;showing..." and "clearing;", and changed "filters;introduction" and "rows;"</comment><comment>mw deleted advanced filters</comment> -<paragraph role="heading" id="hd_id3153896" xml-lang="en-US" level="1" l10n="U" oldref="70"><variable id="filters"><link href="text/scalc/guide/filters.xhp" name="Applying Filters">Applying Filters</link> + <bookmark_value>rows;removing/redisplaying with filters</bookmark_value> + <bookmark_value>removing;filters</bookmark_value> +</bookmark> +<paragraph xml-lang="en-US" id="hd_id3153896" role="heading" level="1" l10n="U" + oldref="70"><variable id="filters"><link href="text/scalc/guide/filters.xhp" name="Applying Filters">Applying Filters</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3150869" xml-lang="en-US" l10n="CHG" oldref="2">Filters and advanced filters allow you to work on certain filtered rows (records) of a data range. In the spreadsheets in $[officename] there are various possibilities for applying filters.</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3155131" xml-lang="en-US" l10n="U" oldref="3">One use for the <emph>AutoFilter</emph> function is to quickly restrict the display to records with identical entries in a data field.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3146119" xml-lang="en-US" l10n="U" oldref="4">In the <emph>Filter</emph> dialog, you can also define ranges which contain the values in particular data fields. You can use the standard filter to connect up to three conditions with either a logical AND or a logical OR operator.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3150010" xml-lang="en-US" l10n="U" oldref="5">The <emph>Advanced filter</emph> exceeds the three condition limitation and allows up to a total of eight filter conditions. With advanced filters you enter the conditions directly into the sheet.</paragraph> -</listitem> -</list> -<paragraph role="tip" id="par_id9384746" xml-lang="en-US" l10n="NEW">To remove a filter, so that you see all cells again, click inside the area where the filter was applied, then choose <item type="menuitem">Data - Filter - Remove Filter</item>.</paragraph> -<paragraph role="note" id="par_idN10663" xml-lang="en-US" l10n="NEW">When you select multiple rows from an area where a filter was applied, then this selection can include rows that are visible and rows that are hidden by the filter. If you then apply formatting, or delete the selected rows, this action then applies only to the visible rows. The hidden rows are not affected. </paragraph> -<paragraph role="note" id="par_id218817" xml-lang="en-US" l10n="NEW">This is the opposite to rows that you have hidden manually by the <emph>Format - Rows - Hide Rows</emph> command. Manually hidden rows are deleted when you delete a selection that contains them.</paragraph> -<section id="relatedtopics"> -<embed href="text/scalc/guide/autofilter.xhp#autofilter"/> -<embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> -<embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> -</section> -</body> -</helpdocument> + <paragraph xml-lang="en-US" id="par_id3150869" role="paragraph" l10n="CHG" oldref="2">Filters and advanced filters allow you to work on certain filtered rows (records) of a data range. In the spreadsheets in $[officename] there are various possibilities for applying filters.</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3155131" role="listitem" l10n="U" oldref="3">One use for the <emph>AutoFilter</emph> function is to quickly restrict the display to records with identical entries in a data field.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3146119" role="listitem" l10n="U" oldref="4">In the <emph>Standard Filter</emph> dialog, you can also define ranges which contain the values in particular data fields. You can use the standard filter to connect the conditions with either a logical AND or a logical OR operator.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3150010" role="listitem" l10n="U" oldref="5">The <emph>Advanced filter</emph> allows up to a total of eight filter conditions. With advanced filters you enter the conditions directly into the sheet.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_id9384746" role="tip" l10n="NEW">To remove a filter, so that you see all cells again, click inside the area where the filter was applied, then choose <item type="menuitem">Data - Filter - Remove Filter</item>.</paragraph> + <paragraph xml-lang="en-US" id="par_idN10663" role="note" l10n="NEW">When you select multiple rows from an area where a filter was applied, then this selection can include rows that are visible and rows that are hidden by the filter. If you then apply formatting, or delete the selected rows, this action then applies only to the visible rows. The hidden rows are not affected. </paragraph> + <paragraph xml-lang="en-US" id="par_id218817" role="note" l10n="NEW">This is the opposite to rows that you have hidden manually by the <emph>Format - Rows - Hide Rows</emph> command. Manually hidden rows are deleted when you delete a selection that contains them.</paragraph> + <section id="relatedtopics"> + <embed href="text/scalc/guide/autofilter.xhp#autofilter"/> + <embed href="text/scalc/guide/specialfilter.xhp#specialfilter"/> + <embed href="text/scalc/guide/cellcopy.xhp#cellcopy"/> + </section> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/formula_value.xhp b/helpcontent2/source/text/scalc/guide/formula_value.xhp index c59eccd843..bac87624a7 100755 --- a/helpcontent2/source/text/scalc/guide/formula_value.xhp +++ b/helpcontent2/source/text/scalc/guide/formula_value.xhp @@ -62,7 +62,7 @@ <paragraph role="listitem" id="par_id3146120" xml-lang="en-US" l10n="U" oldref="4">In the <emph>Display</emph> area mark the <emph>Formulas</emph> box. Click OK.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id3147396" xml-lang="en-US" l10n="U" oldref="5">If you want to view the calculation results instead of the formula, do not mark the Formulasbox.</paragraph> +<paragraph role="paragraph" id="par_id3147396" xml-lang="en-US" l10n="U" oldref="5">If you want to view the calculation results instead of the formula, do not mark the Formulas box.</paragraph> <section id="relatedtopics"> <paragraph role="paragraph" id="par_id3153157" xml-lang="en-US" l10n="U" oldref="6"><link href="text/shared/optionen/01060100.xhp" name="Tools - Options - Spreadsheet - View">Tools - Options - %PRODUCTNAME Calc - View</link></paragraph> </section> diff --git a/helpcontent2/source/text/scalc/guide/main.xhp b/helpcontent2/source/text/scalc/guide/main.xhp index 1251bffb36..9f64dbe557 100755 --- a/helpcontent2/source/text/scalc/guide/main.xhp +++ b/helpcontent2/source/text/scalc/guide/main.xhp @@ -65,6 +65,7 @@ <embed href="text/scalc/guide/format_value.xhp#format_value"/> <embed href="text/scalc/guide/format_value_userdef.xhp#format_value_userdef"/> <embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> +<embed href="text/scalc/guide/numbers_text.xhp#numbers_text"/> <embed href="text/scalc/guide/note_insert.xhp#note_insert"/> <embed href="text/scalc/guide/rename_table.xhp#rename_table"/> <embed href="text/scalc/guide/row_height.xhp#row_height"/> diff --git a/helpcontent2/source/text/scalc/guide/makefile.mk b/helpcontent2/source/text/scalc/guide/makefile.mk index 946110e6db..dbb61d1c4e 100644 --- a/helpcontent2/source/text/scalc/guide/makefile.mk +++ b/helpcontent2/source/text/scalc/guide/makefile.mk @@ -109,6 +109,7 @@ XHPFILES = \ multioperation.xhp \ multitables.xhp \ note_insert.xhp \ + numbers_text.xhp \ print_details.xhp \ print_exact.xhp \ print_landscape.xhp \ diff --git a/helpcontent2/source/text/scalc/guide/multitables.xhp b/helpcontent2/source/text/scalc/guide/multitables.xhp index 7dc1f87a3d..08cb4ecbeb 100644 --- a/helpcontent2/source/text/scalc/guide/multitables.xhp +++ b/helpcontent2/source/text/scalc/guide/multitables.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: multitables.xhp,v $ - * $Revision: 1.6.4.1 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -33,48 +32,52 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textscalcguidemultitablesxml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Applying Multiple Sheets</title> -<filename>/text/scalc/guide/multitables.xhp</filename> -</topic> -</meta> -<body> - - - + <topic id="textscalcguidemultitablesxml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Applying Multiple Sheets</title> + <filename>/text/scalc/guide/multitables.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3154759"><bookmark_value>sheets; inserting</bookmark_value> -<bookmark_value>inserting; sheets</bookmark_value> -<bookmark_value>sheets; selecting multiple</bookmark_value> -<bookmark_value>appending sheets</bookmark_value> -<bookmark_value>selecting;multiple sheets</bookmark_value> -<bookmark_value>multiple sheets</bookmark_value> -<bookmark_value>calculating;multiple sheets</bookmark_value> -</bookmark> - <comment>MW moved "sheets;simultaneous.." to edit_multitables.xhp, transferred 2 entries from there and added "calculating;"</comment> - <paragraph xml-lang="en-US" id="hd_id3154759" role="heading" level="1" l10n="U" oldref="9"><variable id="multitables"><link href="text/scalc/guide/multitables.xhp" name="Applying Multiple Sheets">Applying Multiple Sheets</link> + <bookmark_value>inserting; sheets</bookmark_value> + <bookmark_value>sheets; selecting multiple</bookmark_value> + <bookmark_value>appending sheets</bookmark_value> + <bookmark_value>selecting;multiple sheets</bookmark_value> + <bookmark_value>multiple sheets</bookmark_value> + <bookmark_value>calculating;multiple sheets</bookmark_value> +</bookmark><comment>MW moved "sheets;simultaneous.." to edit_multitables.xhp, transferred 2 entries from there and added "calculating;"</comment> +<paragraph xml-lang="en-US" id="hd_id3154759" role="heading" level="1" l10n="U" oldref="9"><variable id="multitables"><link href="text/scalc/guide/multitables.xhp" name="Applying Multiple Sheets">Applying Multiple Sheets</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="hd_id3148576" role="heading" level="2" l10n="U" oldref="10">Inserting a Sheet</paragraph> - <list type="unordered"> - <listitem> - <paragraph xml-lang="en-US" id="par_id3154731" role="paragraph" l10n="CHG" oldref="4">Choose <item type="menuitem">Insert - Sheet</item> to insert a new sheet or an existing sheet from another file.</paragraph> - </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 <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"><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"> - - <embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/> - <embed href="text/scalc/guide/edit_multitables.xhp#edit_multitables"/> - - </section> - </body> -</helpdocument> + <paragraph xml-lang="en-US" id="hd_id3148576" role="heading" level="2" l10n="U" + oldref="10">Inserting a Sheet</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3154731" role="paragraph" l10n="CHG" oldref="4">Choose <item type="menuitem">Insert - Sheet</item> to insert a new sheet or an existing sheet from another file.</paragraph> + </listitem> + </list> +<bookmark xml-lang="en-US" branch="hid/FID_TAB_SELECTALL" id="bm_id9065824" localize="false"/> +<paragraph xml-lang="en-US" id="par_id050920091402035" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Click to select all sheets in the document.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/FID_TAB_DESELECTALL" id="bm_id9065825" localize="false"/> +<paragraph xml-lang="en-US" id="par_id0509200914020391" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Click to deselect all sheets in the document, except the current sheet.</ahelp></paragraph> + <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 <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 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> + <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 <switchinline select="sys"><caseinline select="MAC">Command +</caseinline><defaultinline>Ctrl </defaultinline></switchinline>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"> + <embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/> + <embed href="text/scalc/guide/edit_multitables.xhp#edit_multitables"/> + </section> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/numbers_text.xhp b/helpcontent2/source/text/scalc/guide/numbers_text.xhp new file mode 100644 index 0000000000..5d8e0a1636 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/numbers_text.xhp @@ -0,0 +1,95 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + +<!-- +*********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2008 by Sun Microsystems, Inc. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************ + --> + + +<meta> + <topic id="textscalcguidenumbers_textxml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Converting Text to Numbers</title> + <filename>/text/scalc/guide/numbers_text.xhp</filename> + </topic> + </meta> + <body> +<bookmark xml-lang="en-US" branch="index" id="bm_id3145068"><bookmark_value>converting;text to numbers</bookmark_value> +<bookmark_value>formats; text as numbers</bookmark_value> +</bookmark> +<paragraph xml-lang="en-US" id="hd_id0908200901265171" role="heading" level="1" l10n="NEW"><variable id="numbers_text"><link href="text/scalc/guide/numbers_text.xhp" name="Converting Text to Numbers">Converting Text to Numbers</link> +</variable></paragraph> + <section id="text"> + <paragraph xml-lang="en-US" id="par_id0908200901265127" role="paragraph" l10n="NEW">Calc converts text inside cells to the respective numeric values if an unambiguous conversion is possible. If no conversion is possible, Calc returns a #VALUE! error.</paragraph> + <paragraph xml-lang="en-US" id="par_id0908200901265196" role="paragraph" l10n="NEW">Only integer numbers including exponent are converted, and ISO 8601 dates and times in their extended formats with separators. Anything else, like fractional numbers with decimal separators or dates other than ISO 8601, is not converted, as the text string would be locale dependent. Leading and trailing blanks are ignored.</paragraph> + <paragraph xml-lang="en-US" id="par_id0908200901265220" role="paragraph" l10n="NEW">The following ISO 8601 formats are converted:</paragraph> + <list type="unordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id0908200901265288" role="paragraph" l10n="NEW">CCYY-MM-DD</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id0908200901265267" role="paragraph" l10n="NEW">CCYY-MM-DDThh:mm</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id0908200901265248" role="paragraph" l10n="NEW">CCYY-MM-DDThh:mm:ss</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id0908200901265374" role="paragraph" l10n="NEW">CCYY-MM-DDThh:mm:ss,s</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id0908200901265327" role="paragraph" l10n="NEW">CCYY-MM-DDThh:mm:ss.s</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id0908200901265399" role="paragraph" l10n="NEW">hh:mm</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id0908200901265347" role="paragraph" l10n="NEW">hh:mm:ss</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id0908200901265349" role="paragraph" l10n="NEW">hh:mm:ss,s</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id0908200901265342" role="paragraph" l10n="NEW">hh:mm:ss.s</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_id0908200901265491" role="paragraph" l10n="NEW">The century code CC may not be omitted. Instead of the T date and time separator, exactly one space character may be used.</paragraph> + <paragraph xml-lang="en-US" id="par_id0908200901265467" role="paragraph" l10n="NEW">If a date is given, it must be a valid Gregorian calendar date. In this case the optional time must be in the range 00:00 to 23:59:59.99999...</paragraph> + <paragraph xml-lang="en-US" id="par_id0908200901265420" role="paragraph" l10n="NEW">If only a time string is given, it may have an hours value of more than 24, while minutes and seconds can have a maximum value of 59.</paragraph> + <paragraph xml-lang="en-US" id="par_id0908200901265448" role="paragraph" l10n="NEW">The conversion is done for single arguments only, as in =A1+A2, or ="1E2"+1. Cell range arguments are not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a convertible string.</paragraph> + <paragraph xml-lang="en-US" id="par_id090820090126540" role="paragraph" l10n="NEW">Strings inside formulas are also converted, such as in ="1999-11-22"+42, which returns the date 42 days after November 22nd, 1999. Calculations involving localized dates as strings inside the formula return an error. For example, the localized date string "11/22/1999" or "22.11.1999" cannot be used for the automatic conversion.</paragraph> + </section> + <section id="relatedtopics"> + <embed href="text/scalc/guide/text_numbers.xhp#text_numbers"/> + <embed href="text/scalc/guide/integer_leading_zero.xhp#integer_leading_zero"/> + <paragraph xml-lang="en-US" id="par_id0908200901265544" role="paragraph" l10n="NEW"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link></paragraph> + <embed href="text/scalc/guide/format_value.xhp#format_value"/> + </section> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/table_cellmerge.xhp b/helpcontent2/source/text/scalc/guide/table_cellmerge.xhp index 19fe8186d8..c21f78cbf6 100644 --- a/helpcontent2/source/text/scalc/guide/table_cellmerge.xhp +++ b/helpcontent2/source/text/scalc/guide/table_cellmerge.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: table_cellmerge.xhp,v $ - * $Revision: 1.5 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -32,47 +32,44 @@ * ************************************************************************ --> + -<helpdocument version="1.0"> <meta> -<topic id="textscalcguidetable_cellmergexml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Merging and Splitting Cells</title> -<filename>/text/scalc/guide/table_cellmerge.xhp</filename> -</topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-12-05T12:29:42">converted from old format - fpe</lastedited> -</history> -</meta> -<body> + <topic id="textscalcguidetable_cellmergexml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Merging and Splitting Cells</title> + <filename>/text/scalc/guide/table_cellmerge.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3147240"><bookmark_value>cells; merging/unmerging</bookmark_value> -<bookmark_value>tables; merging cells</bookmark_value> -<bookmark_value>cell merges</bookmark_value> -<bookmark_value>unmerging cells</bookmark_value> -<bookmark_value>merging;cells</bookmark_value> + <bookmark_value>tables; merging cells</bookmark_value> + <bookmark_value>cell merges</bookmark_value> + <bookmark_value>unmerging cells</bookmark_value> + <bookmark_value>merging;cells</bookmark_value> </bookmark><comment>MW made "cell merges;..." a one level entry</comment> -<paragraph role="heading" id="hd_id8005005" xml-lang="en-US" level="1" l10n="NEW"><variable id="table_cellmerge"><link href="text/scalc/guide/table_cellmerge.xhp" name="Merging and Unmerging Cells">Merging and Unmerging Cells</link> +<paragraph xml-lang="en-US" id="hd_id8005005" role="heading" level="1" l10n="NEW"><variable id="table_cellmerge"><link href="text/scalc/guide/table_cellmerge.xhp" name="Merging and Unmerging Cells">Merging and Unmerging Cells</link> </variable><comment>mw created this file out of the shared guide "table_cellmerge.xhp", see also bug #63021</comment></paragraph> -<paragraph role="paragraph" id="par_id8049867" xml-lang="en-US" l10n="NEW">You can select adjacent cells, then merge them into a single cell. Conversely, you can take a large cell that has been created by merging single cells, and divide it back into individual cells.</paragraph> -<paragraph role="heading" id="hd_id235602" xml-lang="en-US" level="2" l10n="NEW">Merging Cells</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id1272927" xml-lang="en-US" l10n="NEW">Select the adjacent cells.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id6424146" xml-lang="en-US" l10n="NEW">Choose <emph>Format - Merge Cells</emph>.</paragraph> -</listitem> -</list> -<paragraph role="heading" id="hd_id451368" xml-lang="en-US" level="2" l10n="NEW">Canceling the merging of cells</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id7116611" xml-lang="en-US" l10n="NEW">Place the cursor in the cell to be split.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id9493087" xml-lang="en-US" l10n="NEW">Choose <emph>Format - Merge Cells</emph>.</paragraph> -</listitem> -</list> -<embed href="text/shared/00/00000004.xhp#related"/> -<embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> -</body> -</helpdocument> + <paragraph xml-lang="en-US" id="par_id8049867" role="paragraph" l10n="NEW">You can select adjacent cells, then merge them into a single cell. Conversely, you can take a large cell that has been created by merging single cells, and divide it back into individual cells.</paragraph> + <paragraph xml-lang="en-US" id="par_id0509200913480176" role="note" l10n="NEW">When you copy cells into a target range containing merged cells, the target range gets unmerged first, then the copied cells are pasted in. If the copied cells are merged cells, they retain their merge state.</paragraph> + <paragraph xml-lang="en-US" id="hd_id235602" role="heading" level="2" l10n="NEW">Merging Cells</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id1272927" role="listitem" l10n="NEW">Select the adjacent cells.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id6424146" role="listitem" l10n="NEW">Choose <emph>Format - Merge Cells</emph>.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="hd_id451368" role="heading" level="2" l10n="NEW">Canceling the merging of cells</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id7116611" role="listitem" l10n="NEW">Place the cursor in the cell to be split.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id9493087" role="listitem" l10n="NEW">Choose <emph>Format - Merge Cells</emph>.</paragraph> + </listitem> + </list> + <embed href="text/shared/00/00000004.xhp#related"/> + <embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/text_numbers.xhp b/helpcontent2/source/text/scalc/guide/text_numbers.xhp index 3e583349c3..940a88fdf8 100644 --- a/helpcontent2/source/text/scalc/guide/text_numbers.xhp +++ b/helpcontent2/source/text/scalc/guide/text_numbers.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: text_numbers.xhp,v $ - * $Revision: 1.7 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.12 $ * * This file is part of OpenOffice.org. * @@ -29,39 +30,37 @@ * <http://www.openoffice.org/license.html> * for a copy of the LGPLv3 License. * - ************************************************************************--> + ************************************************************************ + --> + -<helpdocument version="1.0"> <meta> -<topic id="textscalcguidetext_numbersxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Formatting Numbers as Text</title> -<filename>/text/scalc/guide/text_numbers.xhp</filename> -</topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-08-15T13:41:51">converted from old format - fpe</lastedited> -</history> -</meta> -<body> + <topic id="textscalcguidetext_numbersxml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Formatting Numbers as Text</title> + <filename>/text/scalc/guide/text_numbers.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3145068"><bookmark_value>numbers; as text</bookmark_value> -<bookmark_value>text formats; for numbers</bookmark_value> -<bookmark_value>numbers; entering without number formats </bookmark_value> -<bookmark_value>formats; numbers as text</bookmark_value> -<bookmark_value>cell formats; text/numbers</bookmark_value> -<bookmark_value>formatting;numbers as text</bookmark_value> + <bookmark_value>text formats; for numbers</bookmark_value> + <bookmark_value>numbers; entering without number formats </bookmark_value> + <bookmark_value>formats; numbers as text</bookmark_value> + <bookmark_value>cell formats; text/numbers</bookmark_value> + <bookmark_value>formatting;numbers as text</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3145068" xml-lang="en-US" level="1" l10n="U" oldref="46"><variable id="text_numbers"><link href="text/scalc/guide/text_numbers.xhp" name="Formatting Numbers as Text">Formatting Numbers as Text</link> +<paragraph xml-lang="en-US" id="hd_id3145068" role="heading" level="1" l10n="U" + oldref="46"><variable id="text_numbers"><link href="text/scalc/guide/text_numbers.xhp" name="Formatting Numbers as Text">Formatting Numbers as Text</link> </variable></paragraph> -<section id="text"> -<paragraph role="paragraph" id="par_id3156280" xml-lang="en-US" l10n="U" oldref="43">You can format numbers as text in $[officename] Calc. Open the context menu of a cell or range of cells and choose <emph>Format Cells - Numbers</emph>, then select "Text" from the <emph>Category</emph> list. Any numbers subsequently entered into the formatted range are interpreted as text. The display of these "numbers" is left-justified, just as with other text.</paragraph> -<paragraph role="note" id="par_id3153728" xml-lang="en-US" l10n="U" oldref="48">When numbers are formatted as text, they cannot be used in calculations or formulas.</paragraph> -<paragraph role="paragraph" id="par_id3149377" xml-lang="en-US" l10n="U" oldref="44">If you have already entered normal numbers in cells and have afterwards changed the format of the cells to "Text", the numbers will remain normal numbers. They will not be converted. Only numbers entered afterwards, or numbers which are then edited, will become text numbers.</paragraph> -<paragraph role="paragraph" id="par_id3144765" xml-lang="en-US" l10n="U" oldref="45">If you decide to enter a number directly as text, enter an apostrophe (') first. For example, for years in column headings, you can enter '1999, '2000 and '2001. The apostrophe is not visible in the cell, it only indicates that the entry is to be recognized as a text. This is useful if, for example, you enter a telephone number or postal code that begins with a zero (0), because a zero (0) at the start of a sequence of digits is removed in normal number formats.</paragraph> -</section> -<section id="relatedtopics"> -<embed href="text/scalc/guide/integer_leading_zero.xhp#integer_leading_zero"/> -<paragraph role="paragraph" id="par_id3156284" xml-lang="en-US" l10n="U" oldref="47"><link href="text/shared/01/05020300.xhp" name="Format - Cell - Numbers">Format - Cell - Numbers</link></paragraph> -<embed href="text/scalc/guide/format_value.xhp#format_value"/> -</section> -</body> -</helpdocument> + <section id="text"> + <paragraph xml-lang="en-US" id="par_id3156280" role="paragraph" l10n="U" oldref="43">You can format numbers as text in $[officename] Calc. Open the context menu of a cell or range of cells and choose <emph>Format Cells - Numbers</emph>, then select "Text" from the <emph>Category</emph> list. Any numbers subsequently entered into the formatted range are interpreted as text. The display of these "numbers" is left-justified, just as with other text.</paragraph> + <paragraph xml-lang="en-US" id="par_id3149377" role="paragraph" l10n="U" oldref="44">If you have already entered normal numbers in cells and have afterwards changed the format of the cells to "Text", the numbers will remain normal numbers. They will not be converted. Only numbers entered afterwards, or numbers which are then edited, will become text numbers.</paragraph> + <paragraph xml-lang="en-US" id="par_id3144765" role="paragraph" l10n="U" oldref="45">If you decide to enter a number directly as text, enter an apostrophe (') first. For example, for years in column headings, you can enter '1999, '2000 and '2001. The apostrophe is not visible in the cell, it only indicates that the entry is to be recognized as a text. This is useful if, for example, you enter a telephone number or postal code that begins with a zero (0), because a zero (0) at the start of a sequence of digits is removed in normal number formats.</paragraph> + </section> + <section id="relatedtopics"> + <embed href="text/scalc/guide/numbers_text.xhp#numbers_text"/> + <embed href="text/scalc/guide/integer_leading_zero.xhp#integer_leading_zero"/> + <paragraph xml-lang="en-US" id="par_id3156284" role="paragraph" l10n="U" oldref="47"><link href="text/shared/01/05020300.xhp" name="Format - Cells - Numbers">Format - Cells - Numbers</link></paragraph> + <embed href="text/scalc/guide/format_value.xhp#format_value"/> + </section> + </body> +</helpdocument>
\ No newline at end of file diff --git a/helpcontent2/source/text/scalc/guide/text_rotate.xhp b/helpcontent2/source/text/scalc/guide/text_rotate.xhp index b6e7b59488..cb8fe44a77 100755 --- a/helpcontent2/source/text/scalc/guide/text_rotate.xhp +++ b/helpcontent2/source/text/scalc/guide/text_rotate.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: text_rotate.xhp,v $ - * $Revision: 1.6 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -29,44 +30,40 @@ * <http://www.openoffice.org/license.html> * for a copy of the LGPLv3 License. * - ************************************************************************--> + ************************************************************************ + --> + -<helpdocument version="1.0"> <meta> -<topic id="textscalcguidetext_rotatexml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Rotating Text</title> -<filename>/text/scalc/guide/text_rotate.xhp</filename> -</topic> -<history> -<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2004-09-27T12:49:15">converted from old format - fpe</lastedited> -</history> -</meta> -<body> + <topic id="textscalcguidetext_rotatexml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Rotating Text</title> + <filename>/text/scalc/guide/text_rotate.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3151112"><bookmark_value>cells; rotating text</bookmark_value> -<bookmark_value>rotating; text in cells</bookmark_value> -<bookmark_value>text in cells; writing vertically</bookmark_value> + <bookmark_value>rotating; text in cells</bookmark_value> + <bookmark_value>text in cells; writing vertically</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3151112" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="text_rotate"><link href="text/scalc/guide/text_rotate.xhp" name="Rotating Text">Rotating Text</link> +<paragraph xml-lang="en-US" id="hd_id3151112" role="heading" level="1" l10n="U" oldref="1"><variable id="text_rotate"><link href="text/scalc/guide/text_rotate.xhp" name="Rotating Text">Rotating Text</link> </variable></paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3145171" xml-lang="en-US" l10n="U" oldref="2">Select the cells whose text you want to rotate.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3155133" xml-lang="en-US" l10n="U" oldref="3">Choose <emph>Format - Cells</emph>. You will see the <emph>Format Cells</emph> dialog.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3155854" xml-lang="en-US" l10n="U" oldref="4">Click the <emph>Alignment</emph> tab.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3147426" xml-lang="en-US" l10n="U" oldref="5">In the <emph>Text direction</emph> area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click <emph>OK</emph>.</paragraph> -</listitem> -</list> -<paragraph role="paragraph" id="par_id3147434" xml-lang="en-US" l10n="U" oldref="6">In the <emph>Text direction </emph>area, if you press the <emph>ABCD </emph>button, the text is written vertically in the direction of the characters.</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3145171" role="listitem" l10n="U" oldref="2">Select the cells whose text you want to rotate.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3155133" role="listitem" l10n="U" oldref="3">Choose <emph>Format - Cells</emph>. You will see the <emph>Format Cells</emph> dialog.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3155854" role="listitem" l10n="U" oldref="4">Click the <emph>Alignment</emph> tab.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3147426" role="listitem" l10n="U" oldref="5">In the <emph>Text direction</emph> area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click <emph>OK</emph>.</paragraph> + </listitem> + </list><comment>removed a wrong para, i104207</comment> <section id="relatedtopics"> -<paragraph role="paragraph" id="par_id3148456" xml-lang="en-US" l10n="U" oldref="7"><link href="text/scalc/01/05020000.xhp" name="Format - Cells">Format - Cells</link></paragraph> -<paragraph role="paragraph" id="par_id3154944" xml-lang="en-US" l10n="U" oldref="8"><link href="text/shared/01/05340300.xhp" name="Format - Cells - Alignment">Format - Cells - Alignment</link></paragraph> -</section> -</body> -</helpdocument> + <paragraph xml-lang="en-US" id="par_id3148456" role="paragraph" l10n="U" oldref="7"><link href="text/scalc/01/05020000.xhp" name="Format - Cells">Format - Cells</link></paragraph> + <paragraph xml-lang="en-US" id="par_id3154944" role="paragraph" l10n="U" oldref="8"><link href="text/shared/01/05340300.xhp" name="Format - Cells - Alignment">Format - Cells - Alignment</link></paragraph> + </section> + </body> +</helpdocument>
\ No newline at end of file |