PC World 1999 June

home *** CD-ROM | disk | FTP | other *** search

/ PC World 1999 June / PCWorld_1999-06_cd.bin / Novinky / StarOff / english / prod_w95 / f_37314 / scalc.dat

Wrap

Text File | 1999-02-02 | 266KB | 4,775 lines

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_NAVIGATOR"></A><A name="Navigator"></A><A href="02110000.htm">Navigator</A></FONT></FONT></H1> <HR> <P><HLPTEXT>This command switches the Navigator display on or off.</HLPTEXT> The Navigator is especially useful for working with large documents, as it enables you to jump directly to specific cells or cell areas. The Navigator is a dockable window<A name="ende"></A></P> <P><A href="Slot:10336" rel=ExecuteURL></A><A href="../../common/00/00000402.htm#Navigator" rel=popup_END><A href="../../common/00/00000004.htm#Wie" rel=embedded></A></A></P> <P>To display the Navigator, open a document and choose <B>Edit - Navigator</B>. Alternatively, click the Navigator icon in the Function bar or press (F5). If the Navigator overlaps areas of text in your document, you can drag the window to a different position. Just click anywhere on the title bar and drag the window where you want it. If you don't want to dock the Navigator at the new position, keep the (Ctrl) key pressed while dragging. </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_COL"></A>Column</FONT></FONT></H2> <P><HLPTEXT>Enter the letter of the column header in this spin box.</HLPTEXT> To move the cursor to the specified column, press Enter.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_ROW"></A>Row</FONT></FONT></H2> <P><HLPTEXT>Enter the letter of the row header in this spin box. To move the cursor to the specified row, press Enter.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_DATA"></A>Data Area</FONT></FONT></H2> <P><HLPTEXT>Use this command to select the current data area (dependent on the cursor position).</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/DATENB.GIF" NAME="Datenbereich" ALIGN=LEFT WIDTH=25 HEIGHT=24 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Data Area </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_ZOOM"></A>Contents</FONT></FONT></H2> <P><HLPTEXT>Click here to hide or show the contents of the Navigator if it is displayed as a floating window.</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/INHALTE.GIF" NAME="Grafik6" ALIGN=LEFT WIDTH=25 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Contents </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_UP"></A>Start</FONT></FONT></H2> <P><HLPTEXT>Click here to jump to the beginning of the current data area (dependent on the cursor position).</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/SWH00259.GIF" NAME="Grafik1" ALIGN=LEFT WIDTH=23 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Start </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_DOWN"></A>End</FONT></FONT></H2> <P><HLPTEXT>Click here to jump to the end of the current data area (dependent on the cursor position).</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/SWH00260.GIF" NAME="Grafik3" ALIGN=LEFT WIDTH=23 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>End </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_ROOT"></A>Toggle</FONT></FONT></H2> <P><HLPTEXT>Click here to toggle the content view.</HLPTEXT> The selected element in the Navigator becomes the root, and only this element and its subelements will be displayed. Clicking on the button again restores the view of all elements.</P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/UMSCHALT.GIF" NAME="Grafik5" ALIGN=LEFT WIDTH=23 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Toggle </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_SCEN"></A><A name="HID_SC_SCENWIN_TOP"></A><A name="HID_SC_SCENWIN_BOTTOM"></A>Scenarios</FONT></FONT></H2> <P><HLPTEXT>All existing scenario names are displayed here; double-click an entry to apply that scenario.</HLPTEXT> The result of the selected scenario is displayed in a table. For more information, refer to the menu command Tools - Scenarios.</P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/SZENARIO.GIF" NAME="Grafik4" ALIGN=LEFT WIDTH=24 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Scenarios </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_DROP"></A>Drag Mode</FONT></FONT></H2> <P><HLPTEXT>Click here to activate the Drag mode. After clicking this icon, you will see a submenu with the following modes:</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/DRAGMODU.GIF" NAME="Grafik7" ALIGN=LEFT WIDTH=24 HEIGHT=23 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Drag mode </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="HID_SC_DROPMODE_URL"></A>Insert As Hyperlink</FONT></FONT></H3> <P><HLPTEXT>In the <B>Hyperlink</B> mode you can drag and drop a hyperlink from the Navigator into a document. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="HID_SC_DROPMODE_LINK"></A>Insert As Link</FONT></FONT></H3> <P><HLPTEXT>In the <B>Link</B> mode you can drag and drop a link from the Navigator into a document. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="HID_SC_DROPMODE_COPY"></A>Insert as Copy</FONT></FONT></H3> <P><HLPTEXT>In the <B>Copy</B> mode you can drag and drop a copy from the Navigator into a document. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_ENTRIES"></A>Existing objects</FONT></FONT></H2> <P><HLPTEXT>In this area you can see a list of all existing objects in your document.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_NAVIPI_DOC"></A>Document list</FONT></FONT></H2> <P><HLPTEXT>This list displays the names of all open documents. To switch the Navigator display to another open document, click on the document name.</HLPTEXT> After each document name, you will see an indication in brackets whether the document is active or inactive. Select the active document in the <B>Window</B> menu. </P> <P>In the <B>Navigator context menu</B> you will find the <B>Display</B> command, which opens a submenu with the same entries as in the <B>Open Documents</B> list box. Select which document information you want to display in the Navigator. If you select <B>Active Window</B>, the display in the Navigator is automatically updated when you switch the active document. In addition, with the <B>Drag Mode</B> command you can specify whether to insert a hyperlink, a shortcut link, or a copy with the drag & drop function. Under <B>Outline Level</B>, you can define how many levels of the hierarchy to display in the Navigator. </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_HFEDIT"></A>Headers & Footers</FONT></FONT></H1> <HR> <P><A NAME="END12"></A><A name="KopfundFusszeilenText"></A>Use this command to define and format the headers and footers in your document.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SCPAGE_HFED_HR"></A><A name="HID_SCPAGE_HFED_FR"></A><A name="HID_SCPAGE_HFED_HL"></A><A name="HID_SCPAGE_HFED_FL"></A><A name="Kopfzeile"></A><A href="02120100.htm">Header/Footer</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Define or format a header or footer for a page style here.<A name="ende"></A></HLPTEXT> The application allows you to use various <A href="../../common/00/00000003.htm" rel=popup>measurement units</A>.</P> <P><A href="../00/00000402.htm#Bkopfzeile" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_HF_HRL"></A><A name="HID_SC_HF_HLL"></A><A name="HID_SC_HF_FRL"></A><A name="HID_SC_HF_FLL"></A>Left Area</FONT></FONT></H2> <P><HLPTEXT>Here you can insert strings or a format code to display or print the contents of the document.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_HF_HRC"></A><A name="HID_SC_HF_HLC"></A><A name="HID_SC_HF_FRC"></A><A name="HID_SC_HF_FLC"></A>Center Area</FONT></FONT></H2> <P><HLPTEXT>Here you can insert strings or a format code to display or print the contents of the document.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_HF_HRR"></A><A name="HID_SC_HF_HLR"></A><A name="HID_SC_HF_FRR"></A><A name="HID_SC_HF_FLR"></A>Right Area</FONT></FONT></H2> <P><HLPTEXT>Here you can insert strings or a format code to display or print the contents of the document.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_HF_TEXT"></A>Text Attributes</FONT></FONT></H2> <P><HLPTEXT>Use this dialog to assign formats to selected cells, or before you enter new text.</HLPTEXT> This dialog is similar to the <A href="../../common/01/05020100.htm">Format - Cells - Character</A> <SWITCH "System"><CASE "OS2">page </CASE>respectively <DEFAULT>tab</DEFAULT>(Depends on platform) </SWITCH> . Only the <B>Language</B> list box is not available here.</P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=29*> <COL WIDTH=227*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=11%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/KOFUTEAT.GIF" NAME="Grafik1" ALIGN=LEFT WIDTH=26 HEIGHT=24 BORDER=0> <BR> </TD> <TD WIDTH=89%> <P>Text attributes </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_HF_FILE"></A>Filename</FONT></FONT></H2> <P><HLPTEXT>Insert a placeholder for the filename in the selected header/footer area, which will be replaced by the name of the file in the header/footer of the actual document.</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=29*> <COL WIDTH=227*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=11%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/KOFUDANA.GIF" NAME="Grafik2" ALIGN=LEFT WIDTH=26 HEIGHT=24 BORDER=0> <BR> </TD> <TD WIDTH=89%> <P>Filename </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_HF_TABLE"></A>Sheet Name</FONT></FONT></H2> <P><HLPTEXT>Insert a placeholder for the name of the sheet in the selected header/footer area, which will be replaced by the name of the sheet in the header/footer of the actual document.</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=29*> <COL WIDTH=227*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=11%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/KOFUTANA.GIF" NAME="Grafik3" ALIGN=LEFT WIDTH=26 HEIGHT=24 BORDER=0> <BR> </TD> <TD WIDTH=89%> <P>Sheet Name </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_HF_PAGE"></A>Page</FONT></FONT></H2> <P><HLPTEXT>Insert a placeholder for the current page number in the selected header/footer area to activate continuous page numbering for a document.</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=29*> <COL WIDTH=227*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=11%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/KOFUSTE.GIF" NAME="Grafik4" ALIGN=LEFT WIDTH=26 HEIGHT=24 BORDER=0> <BR> </TD> <TD WIDTH=89%> <P>Page </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_HF_PAGES"></A>Total Pages</FONT></FONT></H2> <P><HLPTEXT>Insert a placeholder for the total pages in the selected header/footer area to display the total number of pages in the document.</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=29*> <COL WIDTH=227*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=11%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/KOFUSTN.GIF" NAME="Grafik5" ALIGN=LEFT WIDTH=26 HEIGHT=24 BORDER=0> <BR> </TD> <TD WIDTH=89%> <P>Total Pages </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_HF_DATE"></A>Date</FONT></FONT></H2> <P><HLPTEXT>Insert a placeholder for the current date in the selected header/footer area. The date will be repeated in the header/footer on each page of the document.</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=28*> <COL WIDTH=228*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=11%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/KOFUDATE.GIF" NAME="Grafik6" ALIGN=LEFT WIDTH=26 HEIGHT=24 BORDER=0> <BR> </TD> <TD WIDTH=89%> <P>Date </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_HF_TIME"></A>Time</FONT></FONT></H2> <P><HLPTEXT>Insert a placeholder for the current time in the selected header/footer area. The time will be repeated in the header/footer on each page of the document.</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=28*> <COL WIDTH=228*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=11%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/KOFUTIME.GIF" NAME="Grafik7" ALIGN=LEFT WIDTH=26 HEIGHT=24 BORDER=0> <BR> </TD> <TD WIDTH=89%> <P>Time </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Help</FONT></FONT></H2> <P>Click here for additional help regarding this dialog.</P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="Ausfuellen"></A><A href="02140000.htm">Fill</A></FONT></FONT></H1> <HR> <P><BR> </P> <UL> <LI><P><A name="SID_DATA_SELECT"></A><HLPTEXT>Here you can view all text within the current column.</HLPTEXT></P> </UL> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_FILL_TO_BOTTOM"></A><A name="Unten"></A><A href="02140100.htm">Down</A></FONT></FONT></H1> <HR> <P>Fills the cells below the selected cell or cells with the contents of the selected area.</P> <P><A href="../00/00000402.htm#Bausunten" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_FILL_TO_RIGHT"></A><A name="Rechts"></A><A href="02140200.htm">Right</A></FONT></FONT></H1> <HR> <P>Fills the cells to the right of the selected cells with the contents of the selected area.</P> <P><A href="../00/00000402.htm#Bausrechts" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_FILL_TO_TOP"></A><A name="Oben"></A><A href="02140300.htm">Up</A></FONT></FONT></H1> <HR> <P>Fills the cells above the selected cells with the contents of the selected area.</P> <P><A href="../00/00000402.htm#Bausoben" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_FILL_TO_LEFT"></A><A name="Links"></A><A href="02140400.htm">Left</A></FONT></FONT></H1> <HR> <P>Fills the cells to the left of the selected cells with the contents of the selected area.</P> <P><A href="../00/00000402.htm#Bauslinks" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_FILL_TAB"></A>Fill Sheet</FONT></FONT></H1> <HR> <P><A NAME="END8"></A><A name="TabellenfuellenText"></A>Here you can select the options for copying sheets or areas of sheets.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_FILL_SERIES"></A>Fill Series</FONT></FONT></H1> <HR> <P><A name="ReihenfuellenText"></A><HLPTEXT>Use the options in this dialog to create a data series.</HLPTEXT></P> <P><A href="../00/00000402.htm#Bausreihe" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_BOTTOM"></A>Down</FONT></FONT></H3> <P><HLPTEXT>Generate a series from the active cell towards the top of the column, with the specified increment and stop value.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_RIGHT"></A>Right</FONT></FONT></H3> <P><HLPTEXT>Generate a series of data based on the specified increment and stop value, to be inserted into the cells to the right of the active cell.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_TOP"></A>Up</FONT></FONT></H3> <P><HLPTEXT>Generate a series of data based on the specified increment and stop value, to be inserted into the cells in the column above the active cell.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_LEFT"></A>Left</FONT></FONT></H3> <P><HLPTEXT>Generate a series of data based on the specified increment and stop value, to be inserted into the cells to the left of the active cell.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Type</FONT></FONT></H2> <P>Here you can specify the type: <B>Linear, Growth, Date </B>and <B>AutoFill </B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_ARITHMETIC"></A>Linear</FONT></FONT></H3> <P><HLPTEXT>Choose this option to generate a linear series with the specified increment and stop value.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_GEOMETRIC"></A>Growth</FONT></FONT></H3> <P>Click here to generate a growth (geometric) series with the specified increment and stop value.<HLPTEXT></HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DATE"></A>Date</FONT></FONT></H3> <P><HLPTEXT>Choose this option to generate a series of dates with the specified increment and stop value.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_AUTOFILL"></A>AutoFill</FONT></FONT></H3> <P><HLPTEXT>You can generate a series of data directly from the values of the selected cells using the AutoFill function. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DAY"></A>Day</FONT></FONT></H3> <P><HLPTEXT>With <B>Date</B> series, you can generate a series increasing by days (seven days including weekends). </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DAY_OF_WEEK"></A>Weekday</FONT></FONT></H3> <P><HLPTEXT>With <B>Date</B> series, you can generate a series increasing by weekdays (five days excluding weekends). </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_MONTH"></A>Month</FONT></FONT></H3> <P><HLPTEXT>With <B>Date</B> series, you can generate a series from the names of the months or abbreviations. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_YEAR"></A>Year</FONT></FONT></H3> <P><HLPTEXT>With <B>Date</B> series, you can generate a series increasing by years. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:EDIT:RID_SCDLG_FILLSERIES:ED_START_VALUES"></A>Start Value</FONT></FONT></H2> <P><HLPTEXT>Specify a start value for the series of data here.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:EDIT:RID_SCDLG_FILLSERIES:ED_END_VALUES"></A>Stop Value</FONT></FONT></H2> <P><HLPTEXT>Specify a stop value for the series of data here</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:EDIT:RID_SCDLG_FILLSERIES:ED_INCREMENT"></A>Increment</FONT></FONT></H2> <P><HLPTEXT>Enter a step value (increment) for the series of data that you want to generate.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DELETE"></A>Delete Contents</FONT></FONT></H1> <HR> <P><A name="InhalteloeschenText"></A><HLPTEXT>Specify the contents of a cell or an area of cells to be deleted.</HLPTEXT> </P> <P><A href="Slot:5713" rel=ExecuteURL></A><A href="../00/00000402.htm#Binhalt" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DELCONT:BTN_DELALL"></A>Delete All</FONT></FONT></H3> <P><HLPTEXT>If you check this box, all contents of the selected cell area will be deleted.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DELCONT:BTN_DELSTRINGS"></A>Character Strings</FONT></FONT></H3> <P><HLPTEXT>If you check this box, only strings (no numbers, dates, etc.) will be deleted.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DELCONT:BTN_DELNUMBERS"></A>Numbers</FONT></FONT></H3> <P><HLPTEXT>Check this box to delete only numbers.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DELCONT:BTN_DELDATETIME"></A>Date & Time</FONT></FONT></H3> <P><HLPTEXT>Check this box to delete only date and time values.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DELCONT:BTN_DELFORMULAS"></A>Formulas</FONT></FONT></H3> <P><HLPTEXT>Check this box to delete only formulas.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DELCONT:BTN_DELNOTES"></A>Notes</FONT></FONT></H3> <P><HLPTEXT>Check this box to delete only notes.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DELCONT:BTN_DELATTRS"></A>Formats</FONT></FONT></H3> <P><HLPTEXT>Check this box to delete only applied format attributes of cells.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DELCONT:BTN_DELOBJECTS"></A>Objects</FONT></FONT></H3> <P><HLPTEXT>Check this box to delete only objects in cells.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_DELETE_CELL"></A>Delete Cells</FONT></FONT></H1> <HR> <P><A name="ZellenloeschenText"></A><HLPTEXT>Here you can delete the selected cells, or entire columns or rows.</HLPTEXT></P> <P><A href="Slot:26222" rel=ExecuteURL></A><A href="../00/00000402.htm#Bzelo" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Selection</FONT></FONT></H2> <P>Specify here how to shift the remaining cells not deleted.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_CELLSUP"></A>Shift cells up</FONT></FONT></H3> <P><HLPTEXT>Click here if you want the remaining cells to be shifted up.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_CELLSLEFT"></A>Shift cells left</FONT></FONT></H3> <P><HLPTEXT>Click here if you want the remaining cells (to the right) to be shifted left.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_DELROWS"></A><A name="SID_DEL_ROWS"></A>Delete entire row</FONT></FONT></H3> <P><HLPTEXT>Click here to delete the entire row (at least one cell must be selected).</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_DELCOLS"></A><A name="SID_DEL_COLS"></A>Delete entire column</FONT></FONT></H3> <P><HLPTEXT>Click here to delete the entire column (at least one cell must be selected).</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_DELETE_TABLE"></A>Delete Sheet</FONT></FONT></H1> <HR> <P><A NAME="END6"></A><A name="TabelleloeschenText"></A>Deletes the entire sheet (after a confirmation dialog).<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_TAB_MOVE"></A>Copy/Move Sheet...</FONT></FONT></H1> <HR> <P><A name="TabelleverschiebenkopierenText"></A><HLPTEXT>In this dialog you can specify whether to move or copy the sheet. You can move or copy your spreadsheet within the document or to another document.</HLPTEXT><A name="ende"></A></P> <P><A href="Slot:26348" rel=ExecuteURL></A><A href="../00/00000402.htm#Btaverko" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_MOVETAB:LB_DEST"></A>To document</FONT></FONT></H2> <P><HLPTEXT>Select the document where you want to copy or move the selected sheet. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_MOVETAB:LB_INSERT"></A>Insert before</FONT></FONT></H2> <P><HLPTEXT>Here you will see a list of all sheets in the document. The current sheet will be moved or copied before the selected sheet. To position the sheet after all other sheets, choose the option</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:CHECKBOX:RID_SCDLG_MOVETAB:BTN_COPY"></A>Copy</FONT></FONT></H2> <P><HLPTEXT>This option specifies if a sheet should be moved or copied.</HLPTEXT> If you select this option the current sheet will be copied; if not the sheet will be moved. By default, sheets are moved.</P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_DEL_ROWBRK"></A><A name="Zeilenumbruch"></A><A href="02190100.htm">Row break</A></FONT></FONT></H1> <HR> <P>Removes the manual row break above the active cell.</P> <P><A href="../00/00000402.htm#Bzeilum" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_DEL_COLBRK"></A><A name="Spaltenumbruch"></A><A href="02190200.htm">Column Break</A></FONT></FONT></H1> <HR> <P>Removes a manual column break to the left of the active cell.</P> <P><A href="../00/00000402.htm#Bspaum" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_TOGGLEHEADERS"></A><A name="SpaltenZeilenkoepfe"></A><A href="03070000.htm">Column & Row Headers</A></FONT></FONT></H1> <HR> <P>Select this command to show or hide the column and row headers.</P> <P><A href="../00/00000403.htm#Aspze" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_TOGGLESYNTAX"></A><A name="Wertehervorheben"></A><A href="03080000.htm">Value Highlighting</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Select this command to highlight certain values in your sheet. To clear the highlighting, simply deactivate this menu point.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <P><BR> </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_TOGGLEINPUTLINE"></A><A name="Rechenleiste"></A><A href="03090000.htm">Formula Bar</A></FONT></FONT></H1> <HR> <P>Check this menu item to show or hide the Formula bar.</P> <P><A href="../00/00000403.htm#Rechenleiste" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_PAGEBREAKMODE"></A><A name="Seitenumbruchvorschau"></A><A href="03100000.htm">Page Break Preview</A></FONT></FONT></H1> <HR> <P><HLPTEXT>If this menu item is selected, the sheet will be displayed in a special preview mode.</HLPTEXT><A name="Ende"></A></P> <P><A href="../00/00000403.htm#Seumvo" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <P>In the page break preview, the following settings apply:</P> <UL> <LI><P>The view scale is reduced to 60%.</P> <LI><P>The portion of the sheet that is not printed will be highlighted in gray.</P> <LI><P>In the middle of each page to be printed you will see a page number. The pages within the sheet are counted, starting with Page 1.</P> <LI><P>Print areas and page breaks are indicated by blue lines. Dark blue lines show "automatic" print areas and page breaks. They therefore mark the relevant portion of the sheet if no print area has been defined, and they show the automatically defined page breaks. Manually defined print areas and page breaks are indicated by light blue lines.</P> </UL> <P>You can use your mouse to shift the indicated print areas and page breaks.</P> <UL> <LI><P>If you reduce a print area so far that nothing remains, the print area will be canceled. If no print areas are defined on any of the sheets in the spreadsheet, all sheet areas which contain data will be printed.</P> <LI><P>If you shift an automatic page break, a manual page break is inserted at the new position. A manual page break cannot be moved; instead it must be deleted completely.</P> <LI><P>If you shift an automatic page break down or to the right, the scale will be reduced, if necessary, in order to display the area between the previous break and the new break on an entire page. The page break is converted to a manual page break.</P> <LI><P>If you shift a manual page break outside of the print area, the page break will be deleted.</P> </UL> <P>In the page break preview, the context menu provides the most important functions for editing the page breaks, including the following options:</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="FID_DEL_MANUALBREAKS"></A>Remove All Manual Breaks</FONT></FONT></H2> <P><HLPTEXT>Deletes all manual breaks in the current sheet.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="FID_RESET_PRINTZOOM"></A>Reset Scale</FONT></FONT></H2> <P><HLPTEXT>Sets the scale in the page break preview to 100%.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Add Print Area</FONT></FONT></H2> <P>Adds the selected cells to the existing print areas of the current sheet.</P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_INS_ROWBRK"></A><A name="Zeilenumbruch"></A><A href="04010100.htm">Row Break</A></FONT></FONT></H1> <HR> <P>Use this command to insert a manual row break above the active cell.</P> <P><A href="../00/00000404.htm#Eimaumze" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_INS_COLBRK"></A><A name="Spaltenumbruch"></A><A href="04010200.htm">Column Break</A></FONT></FONT></H1> <HR> <P>Choose this command to insert a manual column break to the left of the active cell.</P> <P><A href="../00/00000404.htm#Eimaumsp" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_INS_CELL"></A>Insert Cells</FONT></FONT></H1> <HR> <P><A name="ZelleneinfuegenText"></A>With this dialog you can insert cells or a selected area of cells at the position of the active cell.</P> <P><A href="Slot:26266" rel=ExecuteURL></A><A href="../00/00000404.htm#Eize" rel=popup_end><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Selection</FONT></FONT></H2> <P>Under Selection you can specify how the cells are inserted.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="FID_INS_CELLSDOWN"></A><A name="SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_CELLSDOWN"></A><A name="Zellenunten"></A>Shift cells down</FONT></FONT></H3> <P><A name="ZellenuntenText"></A>Click here if you want the cells to be shifted down.</P> <P><A href="../00/00000404.htm#SyZellenunten" rel=Embedded></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="FID_INS_CELLSRIGHT"></A><A name="SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_CELLSRIGHT"></A><A name="Zellenrechts"></A>Shift cells right</FONT></FONT></H3> <P><A name="ZellenrechtsText"></A>Click here if you want the cells to be shifted to the right.</P> <P><A href="../00/00000404.htm#SyZellenrechts" rel=Embedded></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_INSROWS"></A><A name="Zeilenganze"></A>Entire row</FONT></FONT></H3> <P><A name="ZeilenganzeText"></A>Choose this option to insert an entire row.</P> <P><A href="../00/00000404.htm#SyZeilenganze" rel=Embedded></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_INSCOLS"></A><A name="Spaltenganze"></A>Entire column</FONT></FONT></H3> <P><A name="SpaltenganzeText"></A>Choose this option to insert an entire column.</P> <P><A href="../00/00000404.htm#SySpaltenganze" rel=Embedded></A></P> <P><BR> </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_INS_ROW"></A><A name="Zeilen"></A><A href="04030000.htm">Rows</A></FONT></FONT></H1> <HR> <P>Choose this command to insert a new row above the active cell.</P> <P><A href="../00/00000404.htm#Eizei" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_INS_COLUMN"></A><A name="Spalten"></A><A href="04040000.htm">Columns</A></FONT></FONT></H1> <HR> <P>Use this command to insert a new column to the left of the active cell.</P> <P><A href="../00/00000404.htm#Eispa" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SC:MODALDIALOG:RID_SCDLG_INSERT_TABLE"></A><A name="FID_INS_TABLE"></A>Insert Sheet</FONT></FONT></H1> <HR> <P><A name="TabelleeinfuegenText"></A><HLPTEXT>Enter a name for the new sheet here. You can create a new sheet, or insert an existing sheet from a file.</HLPTEXT><A name="Ende"></A></P> <P><A href="../00/00000404.htm#Eitab" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Position</FONT></FONT></H2> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_INSERT_TABLE:RB_BEFORE"></A>Before selected sheet</FONT></FONT></H3> <P><HLPTEXT>Click here to insert a new sheet before the selected sheet.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_INSERT_TABLE:RB_BEHIND"></A>After selected sheet</FONT></FONT></H3> <P><HLPTEXT>Click here to insert a new sheet after the selected sheet.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="Slot:26269" rel=ExecuteURL></A><A name="SC:RADIOBUTTON:RID_SCDLG_INSERT_TABLE:BTN_NEW"></A>Create new</FONT></FONT></H2> <P><HLPTEXT>Select this option to create a new sheet, and assign a <B>name</B> for it. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:NUMERICFIELD:RID_SCDLG_INSERT_TABLE:NF_COUNT"></A>No. of sheets</FONT></FONT></H3> <P><HLPTEXT>In this spin box you can specify the number of sheets to be inserted.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:RID_SCDLG_INSERT_TABLE:ED_TABNAME"></A>Name</FONT></FONT></H3> <P><HLPTEXT>Enter a sheet name, which may contain both letters and numbers.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:RADIOBUTTON:RID_SCDLG_INSERT_TABLE:BTN_FROMFILE"></A>Create from file</FONT></FONT></H2> <P><HLPTEXT>Select this option to insert a new sheet from an existing file into the active sheet.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:PUSHBUTTON:RID_SCDLG_INSERT_TABLE:BTN_BROWSE"></A>Browse</FONT></FONT></H3> <P><HLPTEXT>Click this button to open the <B>Insert File</B> dialog. This dialog is similar to the <B>Open File dialog in the File menu.</HLPTEXT> The box next to the button displays the sheet(s) to be inserted, and the path of the selected sheet appears below. </B> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_INSERT_TABLE:BTN_LINK"></A>Link</FONT></FONT></H3> <P><HLPTEXT>Check this box to link your document to the file selected in the list box.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_INSWIN_CALC"></A><A name="SID_OPENDLG_FUNCTION"></A><A name="Funktionsautopilot"></A><A href="04060000.htm">Function AutoPilot</A></FONT></FONT></H1> <HR> <P><A name="FunktionsautopilotText"></A><HLPTEXT>Use the Function AutoPilot to insert functions into your document.</HLPTEXT><A name="Ende"></A>The Function AutoPilot allows you to search for a function, enter the required arguments and calculate the result of the formula. Before you open the <B>Function AutoPilot</B>, select a cell or area of cells in which you want the result to appear. </P> <P><A href="Slot:26152" rel=ExecuteURL></A><A href="../00/00000404.htm#Eifu" rel=popup_end><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Functions <SWITCH "System"><CASE "OS2">page</CASE>respectively <DEFAULT>tab</DEFAULT>(Depends on platform) </SWITCH></FONT></FONT></H2> <P>When you activate the Function Autopilot, the <B>Functions</B> <SWITCH "System"><CASE "OS2">page</CASE>respectively <DEFAULT>tab</DEFAULT>(Depends on platform) </SWITCH> of the dialog is selected. After you choose a category (e.g., Mathematical) and a corresponding function (e.g., Round), you can enter the formula in the input field at the right. </P> <P><A href="04060100.htm">List of Categories and Functions</A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCTAB_FUNCTION:LB_CATEGORY"></A>Category</FONT></FONT></H3> <P><A name="Kategorienliste"></A><HLPTEXT>A list of all categories is displayed in this field. Select a category (e.g. Mathematical) to view a list of corresponding functions.</HLPTEXT> Select <B>All</B> to view all functions in alphabetical order. In addition, you can select <B>Last used</B> to view all categories already used in the document. <A name="end"></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCTAB_FUNCTION:LB_FUNCTION"></A>Function</FONT></FONT></H3> <P><HLPTEXT>In this list you can see the names of the different functions and additional information about the selected function.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_FORMULA:BTN_MATRIX"></A>Matrix</FONT></FONT></H3> <P><HLPTEXT>If you check this box, a matrix is inserted in the sheet along with the selected function.</HLPTEXT> Each cell in the matrix contains the formula, not as a copy, but as a shared formula for all matrix cells.</P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/HINWEIS.GIF" NAME="Grafik1" ALIGN=LEFT WIDTH=32 HEIGHT=32 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>The maximum size of a matrix area is 128 x 128 cells; in the 16-bit Windows versions the area is 64 x 64 cells. </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Arguments input field</FONT></FONT></H3> <P>In Step 2 of 2 of the Function AutoPilot, you can enter the arguments for the selected function. To select a cell reference as an argument, click on the cell or, keeping the mouse button pressed down, select a range of cells in the spreadsheet. Numerical and other values and references can also be entered directly in the relevant fields of this dialog. Once you've defined the function by entering all its arguments, click <B>End</B> to insert the result in the spreadsheet. </P> <P>This field displays additional information about the selected function and the text fields for the argument input. An important information is whether the input is <B>required</B> or <B>optional</B> for the calculation. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_FORMULA:RB_ARG1"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_FORMULA:RB_ARG2"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_FORMULA:RB_ARG3"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_FORMULA:RB_ARG4"></A><A name="HID_SC_FAP_BTN_REF1"></A><A name="HID_SC_FAP_BTN_REF2"></A><A name="HID_SC_FAP_BTN_REF3"></A><A name="HID_SC_FAP_BTN_REF4"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Function result</FONT></FONT></H3> <P>As soon as you've entered the function arguments, the calculation will be executed. This preview shows you if the function can be calculated with the arguments you've entered. If the arguments result in an error, an <A href="../05/02140000.htm">error code</A> will be displayed.</P> <P>The description and the number of buttons depend on the selected function for the calculation. The required entries are displayed in bold before each button.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_FORMULA:BTN_FX4"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_FORMULA:BTN_FX3"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_FORMULA:BTN_FX2"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_FORMULA:BTN_FX1"></A><A name="HID_SC_FAP_BTN_FX1"></A><A name="HID_SC_FAP_BTN_FX2"></A><A name="HID_SC_FAP_BTN_FX3"></A><A name="HID_SC_FAP_BTN_FX4"></A>f(x) (depending on selected function)</FONT></FONT></H3> <P><HLPTEXT>Clicking on one of these buttons will bring you a level deeper in the Function AutoPilot.</HLPTEXT> You can then enter a function rather than a value or reference in the field next to the button.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:RID_SCDLG_FORMULA:ED_ARG3"></A><A name="SC:EDIT:RID_SCDLG_FORMULA:ED_ARG4"></A><A name="SC:EDIT:RID_SCDLG_FORMULA:ED_ARG2"></A><A name="SC:EDIT:RID_SCDLG_FORMULA:ED_ARG1"></A>Argument/Parameter/Cell Reference Reference (depending on selected function)</FONT></FONT></H3> <P><HLPTEXT>The number of text fields visible depends on the selected function for the calculation.</HLPTEXT> You can enter arguments directly in the relevant fields, or you may click on a cell to insert the content as a cell reference in the function. The cell coordinates appear in the first list box and the cell value in the other.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Result</FONT></FONT></H3> <P>The result of the calculation appears in this field before you confirm with OK.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="HID_SC_FAP_FORMULA"></A>Formula</FONT></FONT></H3> <P><HLPTEXT>This preview window at the bottom right of the dialog displays the selected function and any nested functions.</HLPTEXT> You can also enter formulas and other information directly in the window.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:PUSHBUTTON:RID_SCDLG_FORMULA:BTN_BACKWARD"></A><<Back</FONT></FONT></H3> <P><HLPTEXT>Click this button to view the elements of the formula.</HLPTEXT> If the formula consists of two functions, you can go back two steps. This is especially useful if you want to replace the last inserted function in a formula with another. This button is used in combination with the <B>Next</B> button. </P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8% HEIGHT=32> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/TIP.GIF" NAME="Grafik2" ALIGN=LEFT WIDTH=32 HEIGHT=32 BORDER=0> <BR><BR CLEAR=LEFT> </TD> <TD WIDTH=92%> <P>To select a single function from a complex formula consisting of several functions, simply double-click the function in the formula window. The desired function will be highlighted. </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:PUSHBUTTON:RID_SCDLG_FORMULA:BTN_FORWARD"></A>Next>></FONT></FONT></H3> <P><HLPTEXT>Click this button to view the compound functions.</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8% HEIGHT=32> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/TIP.GIF" NAME="Grafik3" ALIGN=LEFT WIDTH=32 HEIGHT=32 BORDER=0> <BR><BR CLEAR=LEFT> </TD> <TD WIDTH=92%> <P>You can also double-click a function in the selection window to transfer it to your formula in the formula window. </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Cancel</FONT></FONT></H3> <P>Click this button to exit the Function Autopilot, without calculating any entered functions.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>End</FONT></FONT></H3> <P>Click here to close the Function AutoPilot and calculate the selected function. The result of the function will be entered in the selected cell of the active sheet.</P> <P><A href="04060100.htm">List of Categories and Functions</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Structure <SWITCH "System"><CASE "OS2">page</CASE>respectively <DEFAULT>tab</DEFAULT>(Depends on platform) </SWITCH></FONT></FONT></H2> <P>On this <SWITCH "System"><CASE "OS2">page</CASE>respectively <DEFAULT>tab</DEFAULT>(Depends on platform) </SWITCH> you can view the hierarchical structure of the function. <SWITCH "System"><CASE "OS2">This page</CASE>respectively <DEFAULT>This tab</DEFAULT>(Depends on platform) </SWITCH> appears if you activate the Function Autopilot when the cursor is positioned in a cell that already contains a function.</P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/HINWEIS.GIF" NAME="HIND_1" ALIGN=LEFT WIDTH=32 HEIGHT=32 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>If you start the Function AutoPilot and the active cell already contains a function, the <B>Structure</B> tab page appears with the input range of the function. You can use this feature as a "Function Inspector," to check the function for accuracy. </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="HID_SC_FAP_STRUCT"></A>Structure</FONT></FONT></H3> <P><HLPTEXT>The function is displayed hierarchically with all nested functions, similar to the Explorer display.</HLPTEXT></P> <P><BR> </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SC:LISTBOX:RID_SCDLG_FORMULA:LB_CATEGORY"></A>Categories and functions</FONT></FONT></H1> <HR> <P><A name="KategorieText"></A><HLPTEXT>Here you will find a description of the calculation functions in StarOffice.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Category: Database</FONT></FONT></H1> <HR> <P><A href="../00/00000404.htm#Eikada" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBANZAHL"></A><A name="DBANZAHL"></A>DCOUNT</FONT></FONT></H2> <P><HLPTEXT>DCOUNT counts the number of rows (records) that match the specified search conditions.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBANZAHL2"></A><A name="DBANZAHL2"></A>DCOUNT2</FONT></FONT></H2> <P><HLPTEXT>DCOUNT2 counts the number of rows (records) that match the specified search conditions, and contain numeric or alphanumeric values.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBAUSZUG"></A><A name="DBAUSZUG"></A>DGET</FONT></FONT></H2> <P><HLPTEXT>DGET returns the contents of a cell which matches the specified search criteria in a database field. In case of an error, the function returns #VALUE!</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBMAX"></A><A name="DBMAX"></A>DMAX</FONT></FONT></H2> <P><HLPTEXT>DMAX returns the maximum content of a cell (field) in a database (all records) that matches the specified search conditions.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBMIN"></A><A name="DBMIN"></A>DMIN</FONT></FONT></H2> <P><HLPTEXT>DMIN returns the minimum content of a cell (field) in a database (all records) that matches the specified search criteria.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBMITTELWERT"></A><A name="DBMITTELWERT"></A>DAVERAGE</FONT></FONT></H2> <P><HLPTEXT>DAVERAGE returns the average of the values of all cells (fields) in all rows (database records) that match the specified search criteria.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBPRODUKT"></A><A name="DBPRODUKT"></A>DPRODUCT</FONT></FONT></H2> <P><HLPTEXT>DPRODUCT multiplies the values of all cells in a database field in all rows (records), that match the specified search criteria.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBSTDABW"></A><A name="DBSTDABW"></A>DSTDEV</FONT></FONT></H2> <P><HLPTEXT>DSTDEV estimates the standard deviation of a population based on a sample, using the numbers in a column in a database that match conditions you specify.</HLPTEXT> The records are treated as a sample of data.</P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBSTDABWN"></A><A name="DBSTDABWN"></A>DSTDEV</FONT></FONT></H2> <P><HLPTEXT>DSTDEVP calculates the standard deviation of a population based on all cells of a data range which match the search criteria. </HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBSUMME"></A><A name="DBSUMME"></A>DSUM</FONT></FONT></H2> <P><HLPTEXT>DSUM adds the sum of all cells in a database field in all rows (records) that match the specified search criteria.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBVARIANZ"></A><A name="DBVARIANZ"></A>DVAR</FONT></FONT></H2> <P><HLPTEXT>DVAR estimates the variance of all values in the cells of a database field in all records which match the specified search criteria. </HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DBVARIANZEN"></A><A name="DBVARIANZEN"></A>DVARP</FONT></FONT></H2> <P><HLPTEXT>DVARP calculates the variance of all values in the cells of a database field in all records which match the specified search criteria.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Category: Date & Time</FONT></FONT></H1> <HR> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DATUM"></A><A name="DATUM"></A>DATE</FONT></FONT></H2> <P><HLPTEXT>This function converts a date as year, month, or day to an internal number and displays it in the cell.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DATWERT"></A><A name="DATWERT"></A>DATEVALUE</FONT></FONT></H2> <P><HLPTEXT>DATEVALUE returns the serial number of the date represented by date_text (in quotes); you can use this function to convert a date represented by text to a serial date number.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_HEUTE"></A><A name="HEUTE"></A>TODAY</FONT></FONT></H2> <P><HLPTEXT>Returns the serial number of the current date.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_JAHR"></A><A name="JAHR"></A>YEAR</FONT></FONT></H2> <P><HLPTEXT>Returns the year corresponding to the internal serial number of the year.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_JETZT"></A><A name="JETZT"></A>NOW</FONT></FONT></H2> <P><HLPTEXT>Returns the serial number of the current date and time (the current system setting).</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KALENDERWOCHE"></A><A name="KALENDERWOCHE"></A>WEEKNUM</FONT></FONT></H2> <P><HLPTEXT>WEEKNUM calculates the number of the week in the year corresponding to a given internal date.</HLPTEXT></P> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MINUTE"></A><A name="MINUTE"></A>MINUTE</FONT></FONT></H2> <P><HLPTEXT>For a given internal time, this function returns the MINUTE as a number between 0 and 59.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MONAT"></A><A name="MONAT"></A>MONTH</FONT></FONT></H2> <P><HLPTEXT>Returns the month corresponding to a given serial date.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SEKUNDE"></A><A name="SEKUNDE"></A>SECOND</FONT></FONT></H2> <P><HLPTEXT>Returns the second corresponding to a given serial time.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_STUNDE"></A><A name="STUNDE"></A>HOUR</FONT></FONT></H2> <P><HLPTEXT>Returns the hour corresponding to a given serial time.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TAG"></A><A name="TAG"></A>DAY</FONT></FONT></H2> <P><HLPTEXT>Returns the day of the month corresponding to a serial date.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TAGE"></A><A name="TAGE"></A>DAYS</FONT></FONT></H2> <P><HLPTEXT>Calculates the difference between two date values.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TAGE360"></A><A name="TAGE360"></A>DAYS360</FONT></FONT></H2> <P><HLPTEXT>Returns the number of days between two dates based on a standard 360-day year.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WOCHENTAG"></A><A name="WOCHENTAG"></A>WEEKDAY</FONT></FONT></H2> <P><HLPTEXT>Returns the day of the week corresponding to a serial date.</HLPTEXT></P> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZEIT"></A><A name="ZEIT"></A>TIME</FONT></FONT></H2> <P><HLPTEXT>Returns the serial number of a particular time value in hours, minutes and seconds.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZEITWERT"></A><A name="ZEITWERT"></A>TIMEVALUE</FONT></FONT></H2> <P><HLPTEXT>Returns the serial number of the time represented by a text string enclosed by quotes.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Category: Financial</FONT></FONT></H1> <HR> <P><A href="../00/00000404.htm#Eikafi" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_BW"></A><A name="BW"></A>PV</FONT></FONT></H2> <P><HLPTEXT>Returns the present value of an investment, which is the total amount that a series of future payments is worth now.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DIA"></A><A name="DIA"></A>SYD</FONT></FONT></H2> <P><HLPTEXT>Returns the sum-of-years' digits depreciation of an asset for a specified period.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_EFFEKTIV"></A><A name="EFFEKTIV"></A>EFFECTIVE</FONT></FONT></H2> <P><HLPTEXT>Returns the effective annual interest rate, based on the nominal annual interest rate.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GDA"></A><A name="GDA"></A>DDB</FONT></FONT></H2> <P><HLPTEXT>Returns the depreciation of an asset for a specified period using the double-declining balance method.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GDA2"></A><A name="GDA2"></A>DB</FONT></FONT></H2> <P><HLPTEXT>Returns the depreciation of an asset for a specified period using the double-declining balance method.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_IKV"></A><A name="IKV"></A>IRR</FONT></FONT></H2> <P><HLPTEXT>Returns the internal rate of return for a series of cash flows. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KAPZ"></A><A name="KAPZ"></A>NPER</FONT></FONT></H2> <P><HLPTEXT>Returns the interest payment on the principal for a given period of an investment, based on regular payments and a constant interest rate.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KUMKAPITAL"></A><A name="KUMKAPITAL"></A>CUMIPMT</FONT></FONT></H2> <P><HLPTEXT>Returns the cumulative interest paid for an investment period with a constant interest rate.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KUMZINSZ"></A><A name="KUMZINSZ"></A>CUMPPMT</FONT></FONT></H2> <P><HLPTEXT>Calculates the cumulative interest payments for an investment based on a constant interest rate.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_LAUFZEIT"></A><A name="LAUFZEIT"></A>DURATION</FONT></FONT></H2> <P><HLPTEXT>Returns the annual duration of an investment with periodic interest payments.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_LIA"></A><A name="LIA"></A>SLN</FONT></FONT></H2> <P><HLPTEXT>Returns the straight-line depreciation of an asset for one period. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_NBW"></A><A name="NBW"></A>NPV</FONT></FONT></H2> <P><HLPTEXT>Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_NOMINAL"></A><A name="NOMINAL"></A>NOMINAL</FONT></FONT></H2> <P>Calculates the yearly nominal interest rate, given the effective rate and the number of compounding periods per year.<HLPTEXT></HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_RMZ"></A><A name="RMZ"></A>PMT</FONT></FONT></H2> <P><HLPTEXT>Returns the periodic payment for an annuity.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VDB"></A><A name="VDB"></A>VDB</FONT></FONT></H2> <P><HLPTEXT>Returns the depreciation of an asset for a specified or partial period using a variable declining balance method.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZINS"></A><A name="ZINS"></A>RATE</FONT></FONT></H2> <P><HLPTEXT>Returns the constant interest rate per period of an annuity.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZINSZ"></A><A name="ZINSZ"></A>PPMT</FONT></FONT></H2> <P><HLPTEXT>Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZW"></A><A name="ZW"></A>FV</FONT></FONT></H2> <P><HLPTEXT>Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZZR"></A><A name="ZZR"></A>NPER</FONT></FONT></H2> <P><HLPTEXT>Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Category: Information</FONT></FONT></H1> <HR> <P><A href="../00/00000404.htm#Eikain" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_AKTUELL"></A><A name="AKTUELL"></A>CURRENT</FONT></FONT></H2> <P><HLPTEXT>Calculates the current value of a formula at the actual position.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTBEZUG"></A><A name="ISTBEZUG"></A>ISREF</FONT></FONT></H2> <P><HLPTEXT>This functions tests if the content of one or several cells is a reference. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTFEHL"></A><A name="ISTFEHL"></A>ISERR</FONT></FONT></H2> <P><HLPTEXT>Returns TRUE if the value refers to any error value except #N/A. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTFEHLER"></A><A name="ISTFEHLER"></A>ISERROR</FONT></FONT></H2> <P><HLPTEXT>Returns TRUE if a value refers to any error value (#N/A, #VALUE!, #REF! or #NAME?).</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Wahr" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTFORMEL"></A><A name="ISTFORMEL"></A>ISFORMULA</FONT></FONT></H2> <P><HLPTEXT>Returns TRUE if a cell is a formula cell.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Wahr" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTKTEXT"></A><A name="ISTKTEXT"></A>ISNONTEXT</FONT></FONT></H2> <P><HLPTEXT>Proofs if the cell contents are text or numbers, and returns FALSE if the contents refer to text.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Wahr" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTLEER"></A><A name="ISTLEER"></A>ISBLANK</FONT></FONT></H2> <P><HLPTEXT>Returns TRUE if the reference to a cell is blank. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTLOG"></A><A name="ISTLOG"></A>ISLOG</FONT></FONT></H2> <P><HLPTEXT>This function returns TRUE, if the number format is a logarithm.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTNV"></A><A name="ISTNV"></A>ISNV</FONT></FONT></H2> <P><HLPTEXT>Returns TRUE if a cell contains the #N/A (value not available) error value.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Wahr" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTTEXT"></A><A name="ISTTEXT"></A>ISTEXT</FONT></FONT></H2> <P><HLPTEXT>Returns TRUE if the cell contents refer to text.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Wahr" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTZAHL"></A><A name="ISTZAHL"></A>ISNUMBER</FONT></FONT></H2> <P><HLPTEXT>Returns TRUE if the value refers to a number.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Wahr" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_N"></A><A name="N"></A>N</FONT></FONT></H2> <P><HLPTEXT>Returns a value converted to a number.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_NV"></A><A name="NV"></A>NA</FONT></FONT></H2> <P><HLPTEXT>Returns the error value #N/A.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TYP"></A><A name="TYP"></A>TYPE</FONT></FONT></H2> <P><HLPTEXT>Returns the type of value.</HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Wahr" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Category: Logical</FONT></FONT></H1> <HR> <P><A href="../00/00000404.htm#Eikalo" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_FALSCH"></A><A name="FALSCH"></A>FALSE</FONT></FONT></H2> <P><HLPTEXT>Returns the logical value FALSE. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_NICHT"></A><A name="NICHT"></A>NOT</FONT></FONT></H2> <P><HLPTEXT>Reverses the logical value.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WAHR"></A><A name="WAHR"></A>TRUE</FONT></FONT></H2> <P><HLPTEXT>The logical value is set to TRUE. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WENN"></A><A name="WENN"></A>IF</FONT></FONT></H2> <P><HLPTEXT>Returns one value if a specified condition is TRUE and another value if it is FALSE.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Category: Mathematics</FONT></FONT></H1> <HR> <P><A href="../00/00000404.htm#Eikama" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ABRUNDEN"></A><A name="ABRUNDEN"></A>ROUNDDOWN</FONT></FONT></H2> <P><HLPTEXT>Rounds a number down, toward zero.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ABS"></A><A name="ABS"></A>ABS</FONT></FONT></H2> <P><HLPTEXT>Returns the absolute value of a number.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ANZAHLLEEREZELLEN"></A><A name="ANZAHLLEEREZELLEN"></A>COUNTBLANK</FONT></FONT></H2> <P><HLPTEXT>Counts empty cells in a specified range of cells.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ARCCOS"></A><A name="ARCCOS"></A>ARCCOS</FONT></FONT></H2> <P><HLPTEXT>Returns the arc cosine of a <B>number</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ARCOSHYP"></A><A name="ARCCOSHYP"></A>ARCCOSH</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse arc cosine of a <B>number</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ARCCOT"></A><A name="ARCCOT"></A>ACOT</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse cotangent of the given <B>number</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ARCOTHYP"></A><A name="ARCCOTHYP"></A>ARCCOTH</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse hyperbolic cotangent of the given <B>number</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ARCSIN"></A><A name="ARCSIN"></A>ASIN</FONT></FONT></H2> <P><HLPTEXT>Returns the arcsine of a <B>number</B>.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ARSINHYP"></A><A name="ARCSINHYP"></A>ARCSINH</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse arcsine of a <B>number</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ARCTAN"></A><A name="ARCTAN"></A>ATAN</FONT></FONT></H2> <P><HLPTEXT>Returns the arctangent of a <B>number </B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ARCTAN2"></A><A name="ARCTAN2"></A>ATAN2</FONT></FONT></H2> <P><HLPTEXT>Returns the arctangent of the specified x and y coordinates.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ARTANHYP"></A><A name="ARCTANHYP"></A>ATANH</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse hyperbolic tangent of a <B>number</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_AUFRUNDEN"></A><A name="AUFRUNDEN"></A>ROUNDUP</FONT></FONT></H2> <P><HLPTEXT>Rounds a number up, according to the specified decimal place.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_COS"></A><A name="COS"></A>COS</FONT></FONT></H2> <P><HLPTEXT>Returns the cosine of the given <B>number</B> (angle). </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_COSHYP"></A><A name="COSHYP"></A>COSH</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse hyperbolic cosine of a <B>number</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_COT"></A><A name="COT"></A>COT</FONT></FONT></H2> <P><HLPTEXT>Returns the cotangent of the given angle.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_COTHYP"></A><A name="COTHYP"></A>COTH</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse hyperbolic cotangent of a given <B>number</B> (angle). </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DEG"></A><A name="DEG"></A>DEGREES</FONT></FONT></H2> <P><HLPTEXT>Converts <B>radians</B> into degrees. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_EXP"></A><A name="EXP"></A>EXP</FONT></FONT></H2> <P><HLPTEXT>Returns e raised to the power of a number.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_FAKULTAET"></A><A name="FAKULTAET"></A>FACT</FONT></FONT></H2> <P><HLPTEXT>Returns the factorial of a <B>number</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GANZZAHL"></A><A name="GANZZAHL"></A>INTEGER</FONT></FONT></H2> <P><HLPTEXT>Rounds a number down to the nearest integer.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GERADE"></A><A name="GERADE"></A>EVEN</FONT></FONT></H2> <P><HLPTEXT>Returns a <B>number</B> rounded up to the nearest even integer. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GGT"></A><A name="GGT"></A>GCD</FONT></FONT></H2> <P><HLPTEXT>Returns the greatest common divisor of two or more <B>integers</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTGERADE"></A><A name="ISTGERADE"></A>ISEVEN</FONT></FONT></H2> <P><HLPTEXT>Returns TRUE if the <B>value</B> is an even integer, or FALSE if the value is odd. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ISTUNGERADE"></A><A name="ISTUNGERADE"></A>ISODD</FONT></FONT></H2> <P><HLPTEXT>Returns TRUE if the <B>value</B> is odd, or FALSE if the number is even.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KGV"></A><A name="KGV"></A>LCM</FONT></FONT></H2> <P><HLPTEXT>Returns the least common multiple of one or more <B>integers</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KOMBINATIONEN"></A><A name="KOMBINATIONEN"></A>COMBIN</FONT></FONT></H2> <P><HLPTEXT>Returns the number of combinations for a given number of objects.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KOMBINATIONEN2"></A><A name="KOMBINATIONEN2"></A>COMBIN2</FONT></FONT></H2> <P><HLPTEXT>Returns the number of combinations for a given number of objects (repetetition included).</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KUERZEN"></A><A name="KUERZEN"></A>TRUNC</FONT></FONT></H2> <P><HLPTEXT>Truncates a number to an integer (<B>number</B>) by removing the fractional part of the number according to the precision specified in <B>num_digits</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_LN"></A><A name="LN"></A>LN</FONT></FONT></H2> <P><HLPTEXT>Returns the natural logarithm based on the constant e (2.71828182845904) of a number.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_LOG"></A><A name="LOG"></A>LOG</FONT></FONT></H2> <P><HLPTEXT>Returns the logarithm of a <B>number</B> to the specified base. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_LOG10"></A><A name="LOG10"></A>LOG10</FONT></FONT></H2> <P><HLPTEXT>Returns the base-10 logarithm of a number.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_PI"></A><A name="PI"></A>PI</FONT></FONT></H2> <P><HLPTEXT>Returns the value of PI (3.14).</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_POTENZ"></A><A name="POTENZ"></A>POWER</FONT></FONT></H2> <P><HLPTEXT>Returns the result of a number raised to a power.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_PRODUKT"></A><A name="PRODUKT"></A>PRODUCT</FONT></FONT></H2> <P><HLPTEXT>Multiplies all the <B>numbers</B> given as arguments and returns the product. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_QUADRATESUMME"></A><A name="QUADRATSUMME"></A>SUMSQ</FONT></FONT></H2> <P><HLPTEXT>Returns the sum of the squares of the arguments.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_RAD"></A><A name="RAD"></A>RADIANS</FONT></FONT></H2> <P><HLPTEXT>Converts degrees to radians.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_REST"></A><A name="REST"></A>MOD</FONT></FONT></H2> <P><HLPTEXT>Returns the remainder after a number is divided by a divisor.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_RUNDEN"></A><A name="RUNDEN"></A>ROUND</FONT></FONT></H2> <P><HLPTEXT>Rounds a <B>number</B> to a specified number of digits. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SIN"></A><A name="SIN"></A>SIN</FONT></FONT></H2> <P><HLPTEXT>Returns the sine of the given <B>number</B> (angle). </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SINHYP"></A><A name="SINHYP"></A>SINH</FONT></FONT></H2> <P><HLPTEXT>Returns the hyperbolic sine of a <B>number</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SUMME"></A><A name="SUMME"></A>SUM</FONT></FONT></H2> <P><HLPTEXT>Adds all the <B>numbers</B> in a range of cells. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SUMMEWENN"></A><A name="SUMMEWENN"></A>SUMIF</FONT></FONT></H2> <P><HLPTEXT>Adds the cells specified by a given criteria. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TAN"></A><A name="TAN"></A>TAN</FONT></FONT></H2> <P><HLPTEXT>Returns the tangent of the given angle.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TANHYP"></A><A name="TANHYP"></A>TANH</FONT></FONT></H2> <P><HLPTEXT>Returns the hyperbolic tangent of a <B>number</B> . </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TEILERGEBNIS"></A><A name="TEILERGEBNIS"></A>SUBTOTAL</FONT></FONT></H2> <P><HLPTEXT>Caluclates subtotals in a table.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_UNGERADE"></A><A name="UNGERADE"></A>ODD</FONT></FONT></H2> <P><HLPTEXT>Returns a <B>number</B> rounded up to the nearest odd integer. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_UNTERGRENZE"></A><A name="UNTERGRENZE"></A>FLOOR</FONT></FONT></H2> <P><HLPTEXT>Rounds a <B>number</B> down to the nearest multiple of <B>significance</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VORZEICHEN"></A><A name="VORZEICHEN"></A>SIGN</FONT></FONT></H2> <P><HLPTEXT>Determines the sign of a number.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WURZEL"></A><A name="WURZEL"></A>SQRT</FONT></FONT></H2> <P><HLPTEXT>Returns a positive square root of a <B>number</B>.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZUFALLSZAHL"></A><A name="ZUFALLSZAHL"></A>RAND</FONT></FONT></H2> <P><HLPTEXT>Returns a random number between 0 and 1.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZAEHLENWENN"></A><A name="ZAEHLENWENN"></A>COUNTIF</FONT></FONT></H2> <P><HLPTEXT>Counts the number of cells within a <B>range</B> that meet the given <B>criteria</B>. </HLPTEXT></P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Category: Matrix</FONT></FONT></H1> <HR> <P><A href="../00/00000404.htm#Eikamatrix" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_EINHEITSMATRIX"></A><A name="EINHEITSMATRIX"></A>MUNIT</FONT></FONT></H2> <P><HLPTEXT>Returns the unitary square matrix of a certain size.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_HAEUFIGKEIT"></A><A name="HAEUFIGKEIT"></A>FREQUENCY</FONT></FONT></H2> <P><HLPTEXT>Calculates how often values occur within a range of values, and then returns a vertical array of numbers.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MDET"></A><A name="MDET"></A>MDETERM</FONT></FONT></H2> <P><HLPTEXT>Returns the matrix determinant of an array.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MINV"></A><A name="MINV"></A>MINVERSE</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse matrix for the matrix in an array.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MMULT"></A><A name="MMULT"></A>MMULT</FONT></FONT></H2> <P><HLPTEXT>Calculates the matrix product of two arrays. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MTRANS"></A><A name="MTRANS"></A>MINVERSE</FONT></FONT></H2> <P><HLPTEXT>Transposes the rows and columns of a matrix array.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_RGP"></A><A name="RGP"></A>LINEST</FONT></FONT></H2> <P><HLPTEXT>Returns the parameters of a linear trend.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_RKP"></A><A name="RKP"></A>LOGEST</FONT></FONT></H2> <P><HLPTEXT>In regression analysis, calculates an exponential curve that fits your data and returns an array of values that describes the curve (y=b*m^x).</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SUMMENPRODUKT"></A><A name="SUMMENPRODUKT"></A>PRODSUM</FONT></FONT></H2> <P><HLPTEXT>Multiplies corresponding components in the given arrays, and returns the sum of those products.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SUMMEX2MY2"></A><A name="SUMMEX2MY2"></A>SUMX2MY2</FONT></FONT></H2> <P><HLPTEXT>Returns the sum of the difference of squares of corresponding values in two arrays.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SUMMEX2PY2"></A><A name="SUMMEX2PY2"></A>SUM2PY2</FONT></FONT></H2> <P><HLPTEXT>Returns the sum of the sum of squares of corresponding values in two arrays.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SUMMEXMY2"></A><A name="SUMMEXMY2"></A>SUMXMY2</FONT></FONT></H2> <P><HLPTEXT>Adds the squares of the variance between corresponding values in two arrays.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TREND"></A><A name="TREND"></A>TREND</FONT></FONT></H2> <P><HLPTEXT>Returns values along a linear trend.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VARIATION"></A><A name="VARIATION"></A>VARIATION</FONT></FONT></H2> <P><HLPTEXT>Calculates the points of an exponential trend in a matrix.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Category: Spreadsheet</FONT></FONT></H1> <HR> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ADRESSE"></A><A name="ADRESSE"></A>ADDRESS</FONT></FONT></H2> <P><HLPTEXT>Returns a cell address (reference) as text, according to the specified row and column numbers.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_BEREICHE"></A><A name="BEREICHE"></A>AREAS</FONT></FONT></H2> <P><HLPTEXT>Returns the number of areas in a reference.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DDE"></A><A name="DDE"></A>DDE</FONT></FONT></H2> <P><HLPTEXT>Returns the result of a DDE-based link.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_FEHLERTYP"></A><A name="FEHLERTYP"></A>ERRORTYPE</FONT></FONT></H2> <P><HLPTEXT>Returns the number corresponding to an error value occurring in a different cell.</HLPTEXT></P> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_INDEX"></A><A name="INDEX"></A>INDEX</FONT></FONT></H2> <P><HLPTEXT>INDEX returns the content of a cell, specified by row and column number (or an optional area name).</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_INDIREKT"></A><A name="INDIREKT"></A>INDIRECT</FONT></FONT></H2> <P><HLPTEXT>Returns the <B>reference</B> specified by a text string. This function can also be used to return the area of a corresponding string. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SPALTE"></A><A name="SPALTE"></A>COLUMN</FONT></FONT></H2> <P><HLPTEXT>Returns the column number of a cell reference.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SPALTEN"></A><A name="SPALTEN"></A>COLUMNS</FONT></FONT></H2> <P><HLPTEXT>Returns the number of columns in the given reference.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SVERWEIS"></A><A name="SVERWEIS"></A>VLOOKUP</FONT></FONT></H2> <P><HLPTEXT>Vertical search with reference to adjacent cells to the right.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VERGLEICH"></A><A name="VERGLEICH"></A>MATCH</FONT></FONT></H2> <P><HLPTEXT>Returns the relative position (as number) of an item in an array that matches a specified value in a ceratin order.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VERSCHIEBUNG"></A><A name="VERSCHIEBUNG"></A>OFFSET</FONT></FONT></H2> <P><HLPTEXT>Returns the value of a cell offset by a certain number of rows and columns from a given reference point.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VERWEIS"></A><A name="VERWEIS"></A>LOOKUP</FONT></FONT></H2> <P><HLPTEXT>Returns the contents of a cell either from a one-row or one-column range or from an array.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VORLAGE"></A><A name="VORLAGE"></A>STYLE</FONT></FONT></H2> <P><HLPTEXT>Applies a style to the cell containing the formula.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WAHL"></A><A name="WAHL"></A>CHOOSE</FONT></FONT></H2> <P><HLPTEXT>Uses an index to return a value from a list of up to 30 values.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WVERWEIS"></A><A name="WVERWEIS"></A>HLOOKUP</FONT></FONT></H2> <P><HLPTEXT>Search for a value and reference to the cells below the selected area.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZEILE"></A><A name="ZEILE"></A>ROW</FONT></FONT></H2> <P><HLPTEXT>Returns the row number of a cell reference.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZEILEN"></A><A name="ZEILEN"></A>ROWS</FONT></FONT></H2> <P><HLPTEXT>Returns the number of rows in a reference or array.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Category: Text</FONT></FONT></H1> <HR> <P><A name="TextText"></A>Displayed here is the list of available functions under the Text category along with an example for each of them.<A name="Ende"></A> Functions: <A href="04060110.htm#BASIS">CHAR</A>, <A href="04060110.htm#CODE">CLEAN</A>, <A href="04060110.htm#DM">CODE</A>, <A href="04060110.htm#ERSETZEN">CONCATENATE</A>, <A href="04060110.htm#FEST">DOLLAR</A>, <A href="04060110.htm#FINDEN">FIND</A>, <A href="04060110.htm#GLAETTEN">FIXED</A>, <A href="04060110.htm#GROSS">IDENTICAL</A>, <A href="04060110.htm#GROSS2">LEFT</A>, <A href="04060110.htm#IDENTISCH">LEN</A>, <A href="04060110.htm#KLEIN">LOWER</A>, <A href="04060110.htm#LINKS">MID</A>, <A href="04060110.htm#LAENGE">PROPER</A>, <A href="04060110.htm#RECHTS">REPLACE</A>, <A href="04060110.htm#SUCHEN">REPT</A>, <A href="04060110.htm#SAEUBERN">RIGHT</A>, <A href="04060110.htm#T">SEARCH</A>, <A href="04060110.htm#TEIL">SUBSTITUTE</A>, <A href="04060110.htm#TEXT">T</A>, <A href="04060110.htm#VERKETTEN">TEXT</A>, <A href="04060110.htm#WECHSELN">TRIM</A>, <A href="04060110.htm#WERT">UPPER</A> and <A href="04060110.htm#WIEDERHOLEN">VALUE</A>.<A href="04060110.htm#ZEICHEN"></A></P> <P><A href="../00/00000404.htm#Eikatext" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="BASIS"></A>BASIS</FONT></FONT></H2> <P>Converts a positive integer to text based on the specified <A href="../../common/00/00000005.htm#Zahlensystem" rel=popup>number system</A>. All numerals from 0-9 and letters from A-Z are valid.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_CODE"></A><A name="CODE"></A>CODE</FONT></FONT></H2> <P><HLPTEXT>Returns a numeric code for the first character in a text string.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>CODE(Text)</P> <P><B>Text</B> refers to the text for which to return a numeric code of the first character. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>CODE ("Hieronymus") returns 72, CODE ("hieroglyphic") returns 104.</P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/HINWEIS.GIF" NAME="HIND_1" ALIGN=LEFT WIDTH=32 HEIGHT=32 BORDER=0> <BR><BR CLEAR=LEFT> </TD> <TD WIDTH=92%> <P>The code used here does not refer to ASCII, but to the code table currently loaded. </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#ZEICHEN">CHAR</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_DM"></A><A name="DM"></A>DOLLAR</FONT></FONT></H2> <P><HLPTEXT>Converts a number to an amount in the currency format, rounded to a specified decimal place.</HLPTEXT> In the <B>value</B> field enter the number to be converted to currency. Optionally, you may enter the number of decimal places in the <B>decimals</B> field. If no value is specified, all numbers in currency format will be displayed with two decimal places. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>DOLLAR(value; decimals)</P> <P><B>Value</B> is a number, a reference to a cell containing a number, or a formula which returns a number. </P> <P><B>Decimal</B> is the number of decimal places. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Entering DOLLAR(255) in the <B>value</B> field returns $255.00. </P> <P>Entering a value of 367.456 in the value field and 2 in the decimals field returns $367.46. </P> <P>DOLLAR(A1) returns $5.00 if cell <B>A1</B> contains the number 5. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#FEST">FIXED</A>, <A href="04060110.htm#TEXT">TEXT</A>, <A href="04060110.htm#WERT">VALUE</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ERSETZEN"></A><A name="ERSETZEN"></A>REPLACE</FONT></FONT></H2> <P><HLPTEXT>Replaces part of a text string with a different text string.</HLPTEXT> This function can be used to replace both characters and numbers (which are automatically converted to text). The result of the function is always displayed as text. If you intend to perform further calculations with a number which has been replaced by text, you will need to convert it back to a number using the VALUE function.</P> <P>Any text containing numbers must be enclosed in quotation marks if you don't want it to be interpreted as a number and automatically converted to text.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>REPLACE(old_text; start_num; num_chars; new_text)</P> <P><B>Old_text</B> refers to text of which a part will be replaced. </P> <P><B>Start_num</B> refers to the position within the text where the replacement will begin. </P> <P><B>Num_chars</B> is the number of characters to be replaced. </P> <P><B>New_text</B> refers to the text which replaces old_text. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>REPLACE(12345.67;1;1;444) Enter 12345.67 in the <B>old_text</B> field, 1 in both the <B>start_num</B> and <B>num_chars</B> fields and 444 in the <B>new_text</B> field. The result will be 4442345.67, and the first character is replaced by the new text. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#GLAETTEN">MID</A>, <A href="04060110.htm#SUCHEN">SEARCH</A>, <A href="04060110.htm#TEIL">SUBSTITUTE</A>, <A href="04060110.htm#WECHSELN">TRIM</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_FEST"></A><A name="FEST"></A>FIXED</FONT></FONT></H2> <P><HLPTEXT>Here you can specify that a number be formatted with a fixed number of decimal places and a thousands separator.</HLPTEXT> This function can be used to apply a uniform format to a column of numbers.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>FIXED(Number; decimals; no_commas)</P> <P><B>Number</B> refers to the number to be formatted. </P> <P><B>Decimals</B> refers to the number of decimal places to be displayed. </P> <P>no_commas (optional) determines whether a thousands separator is displayed. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>If you enter 1234567.89 in the <B>Number</B> field, 3 in the <B>decimals</B> and nothing in the <B>no_commas</B> box, the result will be 1,234,567.890. Any entry in the <B>no_commas</B> field will result in 1234567.890. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#DM">DOLLAR</A>, <A href="04060106.htm#RUNDEN">ROUND</A>, <A href="04060110.htm#TEXT">TEXT</A>, <A href="04060110.htm#WERT">VALUE</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_FINDEN"></A><A name="FINDEN"></A>FIND</FONT></FONT></H2> <P><HLPTEXT>Finds one text string within another text string, and returns the number of the starting position of <B>find_text</B>, from the leftmost character of <B>within_text</B>.</HLPTEXT> You may also define where to begin the search. The search term can be a single letter, a number, as well as a complete word or phrase. The search is case-sensitive. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>FIND(find_text; within_text; start_num)</P> <P><B>Find_text</B> refers to the text to be found. </P> <P><B>Within_text</B> is the text where the search takes place. </P> <P><B>Start_num</B> (optional) is the position in the text at which to begin the search. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter 998877665544 in the <B>find_text</B> field, and 76 in <B>within_text</B>: the result will be 6. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#IDENTISCH">IDENTICAL</A>, <A href="04060110.htm#LAENGE">LEN</A>, <A href="04060110.htm#SUCHEN">MID</A>, <A href="04060110.htm#TEIL">SEARCH</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GLAETTEN"></A><A name="GLAETTEN"></A>TRIM</FONT></FONT></H2> <P><HLPTEXT>Removes all spaces from the string specified in <B>text</B>, except for single spaces between words. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>TRIM(Text)</P> <P><B>Text</B> refers to text in which extra spaces between words should be removed. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter <B>...Hello</B> in the <B>Text</B> field and the result will be <B>Hello</B> without the leading spaces??? </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#ERSETZEN">CLEAN</A>, <A href="04060110.htm#SAEUBERN">REPLACE</A>, <A href="04060110.htm#TEIL">MID</A>, <A href="04060110.htm#WECHSELN">SUBSTITUTE</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GROSS"></A><A name="GROSS"></A>UPPER</FONT></FONT></H2> <P><HLPTEXT>Converts the string specified in the <B>Text</B> field to uppercase. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>UPPER(Text)</P> <P>Text refers to the text in which lower case letters should be converted to capitals. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter <B>Good Morning</B> in the <B>Text</B> field and the result will be GOOD MORNING. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#GROSS2">LOWER</A>, <A href="04060110.htm#KLEIN">PROPER</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GROSS2"></A><A name="GROSS2"></A>PROPER</FONT></FONT></H2> <P><HLPTEXT>Capitalizes the first letter in a <B>text</B> string and all other letters after each space. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>PROPER(Text)</P> <P><B>Text</B> refers to the text in which the first letters of words should be replaced with a capital. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter <B>have fun with starcalc</B> in the <B>Text</B> field and the result will be <B>Have Fun With Starcalc</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#GROSS">UPPER</A>, <A href="04060110.htm#KLEIN">LOWER</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_IDENTISCH"></A><A name="IDENTISCH"></A>EXACT</FONT></FONT></H2> <P><HLPTEXT>Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. This function is case-sensitive.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>IDENTICAL(text 1;text 2)</P> <P><B>Text 1</B> refers to the first text to compare. </P> <P><B>Text 2</B> is the second text to compare. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>A comparison between <B>StarOffice</B> and <B>Staroffice</B> returns a value of FALSE. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#LAENGE">LEN</A>, <A href="04060110.htm#SUCHEN">SEARCH</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KLEIN"></A><A name="KLEIN"></A>LOWER</FONT></FONT></H2> <P><HLPTEXT>Converts all uppercase letters in a <B>text</B> string to lowercase. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>LOWER(Text)</P> <P><B>Text</B> refers to the text in which capital letters should be replaced by lower case letters. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter <B>StARcALc</B> in the <B>Text</B> field. The result will be <B>starcalc</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#GROSS">PROPER</A>, <A href="04060110.htm#GROSS2">UPPER</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_LINKS"></A><A name="LINKS"></A>LEFT</FONT></FONT></H2> <P><HLPTEXT>Returns the first (or leftmost) character or characters (specified in the <B>text</B> field) in a string.</HLPTEXT> Optionally, you can specify the amount of single characters in the <B>num_chars</B> field. This function is useful if you want to automatically delete extra characters from a string. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>LEFT(text; num_chars)</P> <P><B>Text</B> is the text for which to determine the first character or characters. </P> <P><B>Num_chars</B> (optional) specifies the number of characters to return. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter <B>output</B> in the <B>Text</B> field and <B>3</B> in the <B>num_chars</B> field. The result will be "out." </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#RECHTS">MID</A>, <A href="04060110.htm#TEIL">RIGHT</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_LAENGE"></A><A name="LAENGE"></A>LEN</FONT></FONT></H2> <P><HLPTEXT>Returns the length of a string specified in the <B>Text</B> field. Any blank spaces in the string will be counted as well. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>LEN(Text)</P> <P><B>Text</B> is the text whose length is to be determined. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Entering <B>Hello</B> returns a result of <B>5</B>. </P> <P>Entering <B>12345.67</B> returns a value of <B>8</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#IDENTISCH">IDENTICAL</A>, <A href="04060110.htm#SUCHEN">SEARCH</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_RECHTS"></A><A name="RECHTS"></A>RIGHT</FONT></FONT></H2> <P>Returns the last (or rightmost) character or characters (specified in <B>num_chars</B>) in a text string. <HLPTEXT></HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>RIGHT(text; num_chars)</P> <P><B>Text</B> is the text string containing the characters to extract. </P> <P><B>Num_chars</B> (optional) is the number of character to be extracted from the end of the string. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter the string <B>Roast Turkey</B> and <B>3</B> in the <B>num_chars</B> field. The result is <B>key</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#LINKS">LEFT</A>, <A href="04060110.htm#TEIL">MID</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SUCHEN"></A><A name="SUCHEN"></A>SEARCH</FONT></FONT></H2> <P><HLPTEXT>Returns the number of the character at which a specific character or text string (<B>find_text</B>) is first found (in <B>within_text</B>), reading from left to right.</HLPTEXT> Optionally, you can also define the point at which to begin the search. The search text may consist of a single letter, a number, or any word or phrase. The search is not case-sensitive. </P> <P><A href="../../common/00/00000001.htm#Regulaer" rel=embedded></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>SEARCH(find_text; within_text; start_num)</P> <P><B>Find_text</B> is the text to be searched for. </P> <P><B>Within_text</B> is the text where the search will take place. </P> <P><B>Num_chars</B> (optional) is the position in the text where the search will start. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter <B>998877665544</B> in the <B>within_text</B> field and <B>54</B> in the <B>find_text</B> field. The result is <B>10</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#ERSETZEN">FIND</A>, <A href="04060110.htm#FINDEN">MID</A>, <A href="04060110.htm#TEIL">REPLACE</A>, <A href="04060110.htm#WECHSELN">SUBSTITUTE</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SAEUBERN"></A><A name="SAEUBERN"></A>CLEAN</FONT></FONT></H2> <P><HLPTEXT>Removes all nonprintable characters from a string entered in the <B>Text</B> field. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>CLEAN(Text)</P> <P><B>Text</B> refers to the text from which to remove all non-printable characters. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Entering (non-printable character)<B>Hello</B> produces <B>Hello</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#GLAETTEN">CHAR</A>, <A href="04060110.htm#ZEICHEN">TRIM</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_T"></A><A name="T"></A>T</FONT></FONT></H2> <P><HLPTEXT>This function converts a number to a blank text string.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>T(Value)</P> <P><B>Value</B> is the value to be converted. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>The number <B>12345</B> becomes text "". The text "12345" remains unchanged. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060104.htm#N">N</A>, <A href="04060110.htm#WERT">VALUE</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TEIL"></A><A name="TEIL"></A>MID</FONT></FONT></H2> <P><HLPTEXT>Returns a specific number of characters from a string entered in the <B>Text</B> field, starting at the position you specify. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>MID(text; start_num; num_chars)</P> <P><B>Text</B> is the text containing the characters to extract. </P> <P><B>Start_num</B> is the position of the first character in the text to extract. </P> <P><B>Num_chars</B> specifies how many characters to return. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>If you enter <B>Autopilot</B> in the <B>Text</B> field, <B>3</B> in the <B>start_num</B> field and <B>3</B> again in the <B>num_chars</B> field, the result will be <B>top</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#CODE">CODE</A>, <A href="04060110.htm#FINDEN">FIND</A>, <A href="04060110.htm#LINKS">LEFT</A>, <A href="04060110.htm#RECHTS">RIGHT</A>, <A href="04060110.htm#SUCHEN">SEARCH</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TEXT"></A><A name="TEXT"></A>TEXT</FONT></FONT></H2> <P><HLPTEXT>Converts a value (specified in the <B>number</B> field) to text in a specific number format. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>TEXT(Number; Format)</P> <P><B>Number</B> is the numerical value to be converted. </P> <P><B>Format</B> is the text which defines the format. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter <B>54321</B> in the <B>Number</B> field and <B>"00.00"</B> (with quotation marks) in the <B>Format</B> field and the result will be <B>54321.00</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#DM">DOLLAR</A>, <A href="04060110.htm#FEST">FIXED</A>, <A href="04060110.htm#T">T</A>, <A href="04060110.htm#WERT">VALUE</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VERKETTEN"></A><A name="VERKETTEN"></A>CONCATENATE</FONT></FONT></H2> <P><HLPTEXT>Combines several text passages into one string.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>CONCATENATE(text 1; text 2; ...)</P> <P><B>Text 1; text 2; ...</B> represent up to 30 text passages which are to be combined into one string. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter <B>"Hello" "Ms" "Smith"</B> as separate text elements. The result after concatenating is <B>Hello Ms Smith</B>. </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WECHSELN"></A><A name="WECHSELN"></A>SUBSTITUTE</FONT></FONT></H2> <P><HLPTEXT>Substitutes <B>new_text</B> for <B>search_text</B> in a <B>text</B> string. In the <B>occurence</B> field you can define how many times to copy the text. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>SUBSTITUTE(text; search_text; new_text; occurence)</P> <P><B>Text</B> is the text containing text to be substituted. </P> <P><B>Search_text </B> is the text to be replaced (multiple times, if desired). </P> <P><B>New_text</B> is the text used as the replacement. </P> <P><B>Occurrence</B> (optional) refers to the number of occurrences in which the text is to be replaced. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter <B>1234567890</B> in the <B>text</B> field, <B>3456789</B> in the <B>search_text</B> field, <B>9876543</B> in <B>new_text</B> and <B>1</B> as the occurrence. The result will be <B>1298765430</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#ERSETZEN">REPLACE</A>, <A href="04060110.htm#GLAETTEN">TRIM</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WERT"></A><A name="WERT"></A>VALUE</FONT></FONT></H2> <P><HLPTEXT>Converts text entered in the <B>Text</B> field to a number. For example, if you concatenate the text elements 123 and 456, VALUE returns the number 123456 as the result. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>VALUE(text)</P> <P><B>Text</B> is the text to be converted to a number. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>The entry <B>"4321"</B> produces <B>4321</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#DM">DOLLAR</A>, <A href="04060110.htm#FEST">FIXED</A>, <A href="04060110.htm#TEXT">TEXT</A>.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WIEDERHOLEN"></A><A name="WIEDERHOLEN"></A>REPEAT</FONT></FONT></H2> <P><HLPTEXT>Repeats a string specified in the <B>Text</B> field a given number of times (<B>num_times</B>). </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>REPT(text; num_times)</P> <P><B>Text</B> is the text to be repeated. </P> <P><B>Num_times</B> is the number of repeats. </P> <P>The result can be a maximum of 255 characters.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>Enter <B>Have a nice day</B> as the text and <B>2</B> in the num_times field. The result is <B>Have a nice dayHave a nice day</B>. </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ZEICHEN"></A><A name="ZEICHEN"></A>CHAR</FONT></FONT></H2> <P><HLPTEXT>Returns a character corresponding to the code specified in the <B>Number</B> field.</HLPTEXT> Code numbers may be two or three digit natural numbers. This function allows you to display characters which cannot be entered directly via the keyboard, as long as you know the code number. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>CHAR(Number)</P> <P><B>Number</B> is a number between 1 and 255 representing the code value for the character. </P> <P><SWITCH "System"><CASE "WIN">Letters and other characters can also be entered via the keyboard by pressing (ALT) while you enter the character code on the number block.</SWITCH></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>The entry <B>100</B> returns <B>d</B>. </P> <P>The entry <B>75</B> returns <B>K</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060110.htm#CODE">CODE</A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="AE"></A><A href="04060181.htm">Statistics A-E</A></FONT></FONT></H1> <HR> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ACHSENABSCHNITT"></A><A name="ACHSENABSCHNITT"></A>INTERCEPT</FONT></FONT></H2> <P><HLPTEXT>Calculates the point at which a line will intersect the y-values by using existing x-values (known_x's) and y-values (known_y's).</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>INTERCEPT(known_y's;known_x's)</P> <P><B>Known_y's</B> is the dependent set of observations or data. </P> <P><B>Known_x's</B> is the independent set of observations or data. </P> <P>Names, matrices or references containing numbers must be used here. Numbers can, of course, also be entered directly.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>To calculate the intercept, use cells D3:D9 as the y value and C3:C9 as the x value from the example spreadsheet. Input will be as follows:</P> <P>INTERCEPT(D3:D9;C3:C9) = 2.15. The result is 2.15.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#BESTIMMTHEITSMASS">FORECAST</A>,<A href="04060184.htm#PEARSON">GROWTH</A>, <A href="04060107.htm#RGP">LINEST</A>, <A href="04060107.htm#RKP">LOGEST</A>, <A href="04060185.htm#SCHAETZER">PEARSON</A>, <A href="04060185.htm#STEIGUNG">RSQ</A>, <A href="04060185.htm#STFEHLERYX">SLOPE</A>, <A href="04060107.htm#TREND">STEYX</A>, <A href="04060107.htm#VARIATION">TREND</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ANZAHL"></A><A name="ANZAHL"></A>COUNT</FONT></FONT></H2> <P><HLPTEXT>Counts how many values are in the list of arguments. Text entries are ignored, and the individual values are added together.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>COUNT(value1; value2; ... value30)</P> <P><B>Value1; value2, ...</B> are 1 to 30 values arguments representing the values to be counted. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>The entries <B>2,4,6</B> and <B>eight</B> in the <B>value 1-4</B> fields are to be counted. </P> <P>COUNT(2;4;6;eight) = 3. The number of entries is therefore <B>3</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#ANZAHL2">AVERAGE</A>, <A href="04060101.htm#DBANZAHL">COUNTA</A>, <A href="04060101.htm#DBANZAHL2">DCOUNT</A>, <A href="04060184.htm#MITTELWERT">DCOUNTA</A>, <A href="04060106.htm#SUMME">SUM</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_ANZAHL2"></A><A name="ANZAHL2"></A>COUNT2</FONT></FONT></H2> <P><HLPTEXT>Counts how many values are in the list of arguments. Text entries are also counted. The individual values will be added together, and empty arguments are ignored.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>COUNTA(value1; value2; ... value30)</P> <P><B>value1; value2, ...</B> are 1 to 30 arguments representing the values to be counted. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>The entries <B>2,4,6</B> and <B>eight</B> in the <B>value1-4</B> fields are to be counted. </P> <P><I>COUNTA(2;4;6;eight) = 4. The number of entries is therefore </I><B>4</B>.<I> </I> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#ANZAHL">AVERAGE</A>, <A href="04060101.htm#DBANZAHL">COUNT</A>, <A href="04060101.htm#DBANZAHL2">DCOUNT</A>, <A href="04060184.htm#MITTELWERT">DCOUNTA</A>, <A href="04060106.htm#PRODUKT">PRODUCT</A>, <A href="04060106.htm#SUMME">SUM</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_B"></A><A name="B"></A>B</FONT></FONT></H2> <P><HLPTEXT>Returns the probability of a sample with binomial distribution.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>B(trials;probability_s;T1;T2)</P> <P><B>Trials</B> is the number of independent trials. </P> <P><B>Probability_s</B> is the probability of success on each trial. </P> <P><B>T1</B> defines the lower limit for the number of trials. </P> <P><B>T2</B> (optional) defines the upper limit for the number of trials. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>What is the probability with ten throws of the dice, that a six will come up exactly twice? The probability of a six (or any other number) is 1/6. The following formula combines these factors:</P> <P>=B(10; 1/6; 2) returns a probability of 29%.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#BINOMVERT">BINOMDIST</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_BESTIMMTHEITSMASS"></A><A name="BESTIMMTHEITSMASS"></A>RSQ</FONT></FONT></H2> <P><HLPTEXT>Returns the square of the Pearson correlation coefficient based on the given values.</HLPTEXT> RSQ (also called determination coefficient) is a measure for the accuracy of an adjustment and can be used to produce a regression analysis.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>RSQ(<B>known_y's; known_x's</B>) </P> <P><B>Known_y's</B> is an array or range of data points. </P> <P>Known_x's is an array or range of data points. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>=RSQ(A1:A20; B1:B20) calculates the correlation coefficient for both data sets in columns A and B.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#ACHSENABSCHNITT">CORREL</A>, <A href="04060183.htm#KORREL">COVAR</A>, <A href="04060183.htm#KOVAR">INTERCEPT</A>, <A href="04060184.htm#PEARSON">LINEST</A>, <A href="04060107.htm#RGP">LOGEST</A>, <A href="04060107.htm#RKP">PEARSON</A>, <A href="04060185.htm#STEIGUNG">SLOPE</A>, <A href="04060185.htm#STFEHLERYX">STEYX</A>, <A href="04060107.htm#TREND">TREND</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_BETAINV"></A><A name="BETAINV"></A>BETAINV</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse of the cumulative beta probability density function.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>BETAINV(number;alpha;beta;A;B)</P> <P><B>Number</B> is the value between <B>A</B> and <B>B</B> at which to evaluate the function. </P> <P><B>Alpha</B> is a parameter to the distribution. </P> <P><B>Beta</B> is a parameter to the distribution. </P> <P><B>A</B> (optional) is the lower bound for <B>number</B>. </P> <P><B>B</B> (optional) is the upper bound for <B>number</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>=BETAINV(0.5; 5; 10) returns the value <B>0.33</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#BETAVERT">BETADIST</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_BETAVERT"></A><A name="BETAVERT"></A>BETADIST</FONT></FONT></H2> <P><HLPTEXT>Returns the cumulative beta probability density function.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>BETADIST(number;alpha;beta;A;B)</P> <P><B>Number</B> is the value between <B>A</B> and <B>B</B> at which to evaluate the function. </P> <P><B>Alpha</B> is a parameter to the distribution. </P> <P><B>Beta</B> is a parameter to the distribution. </P> <P><B>A</B> (optional) is the lower bound for <B>number</B>. </P> <P><B>B</B> (optional) is the upper bound for <B>number</B>. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P><I>=BETADIST(0.75; 3; 4) returns the value </I><B>0.96</B><I> </I> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#BETAINV">BETAINV</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_BINOMVERT"></A><A name="BINOMVERT"></A>BINOMDIST</FONT></FONT></H2> <P><HLPTEXT>Returns the individual term binomial distribution probability.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>BINOMDIST(number_s;trials;probability_s;cumulative)</P> <P><B>Number_s</B> is the number of successes in a set of trials. </P> <P><B>Trials</B> is the number of independent trials. </P> <P><B>Probability_s</B> is the probability of success on each trial. </P> <P><B>Cumulative</B> = 0 calculates the single probability and <B>cumulative</B> = 1 calculates the cumulative probability. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>=BINOMDIST(A1; 12; 0,5; 0) shows (if the values 0 to 12 are entered in A1) the probabilities for 12 flips of a coin that <B>Heads</B> will come up exactly the number of times entered in A1. </P> <P>=BINOMDIST(A1; 12; 0,5; 1) shows the cumulative probabilities for the same series, i.e. if A1 = 4, the probability of 0, 1, 2, 3 or 4 times <B>Heads</B> (non-exclusive OR). </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#B">B</A>, <A href="04060106.htm#FAKULTAET">COMBIN</A>, <A href="04060182.htm#HYPGEOMVERT">CRITBINOM</A>, <A href="04060106.htm#KOMBINATIONEN">FACT</A>, <A href="04060183.htm#KRITBINOM">HYPGEOMDIST</A>, <A href="04060184.htm#NEGBINOMVERT">NEGBINOMDIST</A>, <A href="04060185.htm#VARIATIONEN">PERMUT</A>, <A href="04060185.htm#WAHRSCHBEREICH">PROB</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_CHIINV"></A><A name="CHIINV"></A>CHIINV</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse of the one-tailed probability of the chi-squared distribution.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>CHIINV(number; degrees_freedom)</P> <P><B>Number</B> is a probability associated with the chi-squared distribution. </P> <P><B>Degrees_freedom</B> of the chi-squared distribution. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>=CHIINV(0.1; 5) returns 9.23. If the chi-squared distribution of a sample with these parameters returns a higher value, it deviates from a coincidental distribution.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#CHITEST">CHIDIST</A>, <A href="04060181.htm#CHIVERT">CHITEST</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_CHITEST"></A><A name="CHITEST"></A>CHITEST</FONT></FONT></H2> <P><HLPTEXT>Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence.</HLPTEXT> CHIDIST returns the chi-squared distribution of the data.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>CHITEST(actual_range; expected_range)</P> <P><B>Actual_range</B> is the range of data that contains observations to test against expected data. </P> <P><B>Expected_range</B> is the range of data that contains the ratio of the product of row totals and column totals to the grand total. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>=CHITEST(A1:A30; B1:B30) compares both ranges of data and calculates chi^2 as equal to the sum of "(actual_range-expected_range)^2 / expected_range" for all data values.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#CHIINV">CHIDIST</A>, <A href="04060181.htm#CHIVERT">CHIINV</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_CHIVERT"></A><A name="CHIVERT"></A>CHIDIST</FONT></FONT></H2> <P><HLPTEXT>Returns the one-tailed probability of the chi-squared distribution.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>CHIDIST (x; degrees_freedom)</P> <P><B>X</B> is the value of the distribution (quartile) whose probability is to be calculated. </P> <P><B>Degrees_freedom</B> of the chi-squared distribution. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>=CHIDIST10; 6) returns 0.12.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060181.htm#CHIINV">CHIINV</A>, <A href="04060181.htm#CHITEST">CHITEST</A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_EXPONVERT"></A><A name="EXPONVERT"></A>EXPONDIST</FONT></FONT></H2> <P><HLPTEXT>Returns the exponential distribution.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Syntax</FONT></FONT></H3> <P>EXPONDIST(x; lambda; cumulative)</P> <P><B>X</B> is the value of the function. </P> <P><B>Lambda</B> is the parameter value. </P> <P><B>Cumulative</B> is a logical value that determines the form of the function. <B>Cumulative = 0</B> calculates the density function, and <B>Cumulative = 1</B> calculates the distribution. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Example</FONT></FONT></H3> <P>=EXPONDIST(3; 0.5; 1) returns 0.78.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Siehe" rel=embedded></A></FONT></FONT></H3> <P><A href="04060182.htm#GAMMAVERT">GAMMADIST</A>, <A href="04060184.htm#POISSON">POISSON</A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FH"></A><A href="04060182.htm">Statistics F-H</A></FONT></FONT></H1> <HR> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_FINV"></A><A name="FINV"></A>FINV</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse of the F probability distribution. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_FISHER"></A><A name="FISHER"></A>FISHER</FONT></FONT></H2> <P><HLPTEXT>Returns the Fisher transformation for x and creates a function close to a normal distribution. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_FISHERINV"></A><A name="FISHERINV"></A>FISHERINV</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse of the Fisher transformation for x. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_FTEST"></A><A name="FTEST"></A>FTEST</FONT></FONT></H2> <P><HLPTEXT>Returns the result of an F test.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_FVERT"></A><A name="FVERT"></A>FDIST</FONT></FONT></H2> <P><HLPTEXT>Calculates the values of an F distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GAMMAINV"></A><A name="GAMMAINV"></A>GAMMAINV</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse of the gamma cumulative distribution. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GAMMALN"></A><A name="GAMMALN"></A>GAMMALN</FONT></FONT></H2> <P><HLPTEXT>Returns the natural logarithm of the gamma function G(x).</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GAMMAVERT"></A><A name="GAMMAVERT"></A>GAMMADIST</FONT></FONT></H2> <P><HLPTEXT>Returns the probabilities of a gamma distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GAUSS"></A><A name="GAUSS"></A>GAUSS</FONT></FONT></H2> <P><HLPTEXT>Returns the standard normal cumulative distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GEOMITTEL"></A><A name="GEOMITTEL"></A>GEOMEAN</FONT></FONT></H2> <P><HLPTEXT>Returns the geometric mean of a sample.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GESTUTZTMITTEL"></A><A name="GESTUTZTMITTEL"></A>TRIMMEAN</FONT></FONT></H2> <P><HLPTEXT>Returns the mean of an interior of a data set.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_GTEST"></A><A name="GTEST"></A>ZTEST</FONT></FONT></H2> <P><HLPTEXT>Returns the two-tailed P value of a z test.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_HARMITTEL"></A><A name="HARMITTEL"></A>HARMEAN</FONT></FONT></H2> <P><HLPTEXT>Returns the harmonic mean of a data set.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_HYPGEOMVERT"></A><A name="HYPGEOMVERT"></A>HYPGEOMDIST</FONT></FONT></H2> <P><HLPTEXT>Returns the hypergeometric distribution.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="KL"></A><A href="04060183.htm">Statistics K-L</A></FONT></FONT></H1> <HR> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KGROESSTE"></A><A name="KGROESSTE"></A>LARGE</FONT></FONT></H2> <P><HLPTEXT>Returns the k-th largest value in a data set.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KKLEINSTE"></A><A name="KKLEINSTE"></A>SMALL</FONT></FONT></H2> <P><HLPTEXT>Returns the k-th smallest value in a data set.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KONFIDENZ"></A><A name="KONFIDENZ"></A>CONFIDENCE</FONT></FONT></H2> <P><HLPTEXT>Returns the confidence interval for a population mean.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KORREL"></A><A name="KORREL"></A>CORREL</FONT></FONT></H2> <P><HLPTEXT>Returns the correlation coefficient between two data sets.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KOVAR"></A><A name="KOVAR"></A>COVAR</FONT></FONT></H2> <P><HLPTEXT>Returns the covariance the average of the product of paired deviations.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KRITBINOM"></A><A name="KRITBINOM"></A>CRITBINOM</FONT></FONT></H2> <P>Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.<HLPTEXT></HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_KURT"></A><A name="KURT"></A>KURT</FONT></FONT></H2> <P><HLPTEXT>Returns the kurtosis of a data set (at least 4 values required).</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_LOGINV"></A><A name="LOGINV"></A>LOGINV</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse of the lognormal distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_LOGNORMVERT"></A><A name="LOGNORMVERT"></A>LOGNORMDIST</FONT></FONT></H2> <P><HLPTEXT>Returns the cumulative lognormal distribution.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="MQ"></A><A href="04060184.htm">Statistics M-Q</A></FONT></FONT></H1> <HR> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MAX"></A><A name="MAX"></A>MAX</FONT></FONT></H2> <P><HLPTEXT>Returns the maximum value in a list of arguments.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MEDIAN"></A><A name="MEDIAN"></A>MEDIAN</FONT></FONT></H2> <P><HLPTEXT>Returns the median, or the number in the middle of a set of given numbers.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MIN"></A><A name="MIN"></A>MIN</FONT></FONT></H2> <P><HLPTEXT>Returns the minimum value in a list of arguments.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MITTELABW"></A><A name="MITTELABW"></A>AVEDEV</FONT></FONT></H2> <P><HLPTEXT>Returns the average of the absolute deviations of data points from their mean.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MITTELWERT"></A><A name="MITTELWERT"></A>MEAN</FONT></FONT></H2> <P><HLPTEXT>Returns the averge of the arguments.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_MODALWERT"></A><A name="MODALWERT"></A>MODE</FONT></FONT></H2> <P><HLPTEXT>Returns the most common value in a data set. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_NEGBINOMVERT"></A><A name="NEGBINOMVERT"></A>NEGBINOMDIST</FONT></FONT></H2> <P><HLPTEXT>Returns the negative binomial distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_NORMINV"></A><A name="NORMINV"></A>NORMINV</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse of the normal cumulative distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_NORMVERT"></A><A name="NORMVERT"></A>NORMDIST</FONT></FONT></H2> <P>Returns the standard normal cumulative distribution.<HLPTEXT></HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_PEARSON"></A><A name="PEARSON"></A>PEARSON</FONT></FONT></H2> <P><HLPTEXT>Returns the Pearson correlation coefficient r.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_PHI"></A><A name="PHI"></A>PHI</FONT></FONT></H2> <P><HLPTEXT>Returns the values of the distribution function for a standard normal distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_POISSON"></A><A name="POISSON"></A>POISSON</FONT></FONT></H2> <P><HLPTEXT>Returns the Poisson distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_QUANTIL"></A><A name="QUANTIL"></A>PERCENTILE</FONT></FONT></H2> <P><HLPTEXT>Returns the k-th percentile of values in a range. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_QUANTILSRANG"></A><A name="QUANTILSRANG"></A>PERCENTRANK</FONT></FONT></H2> <P><HLPTEXT>Returns the percentage rank of a value in a sample.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_QUARTILE"></A><A name="QUARTILE"></A>QUARTILE</FONT></FONT></H2> <P><HLPTEXT>Returns the quartile of a data set.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="RZ"></A><A href="04060185.htm">Statistics R-Z</A></FONT></FONT></H1> <HR> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_RANG"></A><A name="RANG"></A>RANK</FONT></FONT></H2> <P><HLPTEXT>Returns the rank of a number in a sample.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SCHIEFE"></A><A name="SCHIEFE"></A>SKEW</FONT></FONT></H2> <P><HLPTEXT>Returns the skewness of a distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SCHAETZER"></A><A name="SCHAETZER"></A>FORECAST</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse of the normal cumulative distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_STABW"></A><A name="STABW"></A>STDEV</FONT></FONT></H2> <P><HLPTEXT>Estimates the standard deviation based on a sample.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_STABWN"></A><A name="STABWN"></A>STDEVP</FONT></FONT></H2> <P><HLPTEXT>Calculates the standard deviation based on the entire population.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_STANDARDISIERUNG"></A><A name="STANDARDISIERUNG"></A>STANDARDIZE</FONT></FONT></H2> <P><HLPTEXT>Converts a random variable to a normalized value.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_STANDNORMINV"></A><A name="STANDNORMINV"></A>NORMSINV</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse of the standard normal cumulative distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_STANDNORMVERT"></A><A name="STANDNORMVERT"></A>NORMSDIST</FONT></FONT></H2> <P><HLPTEXT>Returns the normal cumulative distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_STEIGUNG"></A><A name="STEIGUNG"></A>SLOPE</FONT></FONT></H2> <P><HLPTEXT>Returns the slope of the linear regression line.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_STFEHLERYX"></A><A name="STFEHLERYX"></A>STEYX</FONT></FONT></H2> <P><HLPTEXT>Returns the standard error of the predicted y value for each x in the regression.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_SUMQUADABW"></A><A name="SUMQUADABW"></A>DEVSQ</FONT></FONT></H2> <P><HLPTEXT>Returns the sum of squares of deviations based on a sample mean.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TINV"></A><A name="TINV"></A>TINV</FONT></FONT></H2> <P><HLPTEXT>Returns the inverse of the t-distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TTEST"></A><A name="TTEST"></A>TTEST</FONT></FONT></H2> <P><HLPTEXT>Returns the probability associated with a Student's t-Test.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_TVERT"></A><A name="TVERT"></A>TDIST</FONT></FONT></H2> <P><HLPTEXT>Returns the t-distribution.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VARIANZ"></A><A name="VARIANZ"></A>VAR</FONT></FONT></H2> <P><HLPTEXT>Estimates the variance based on a sample.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VARIANZEN"></A><A name="VARIANZEN"></A>VARP</FONT></FONT></H2> <P><HLPTEXT>Calculates a variance based on the entire population.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VARIATIONEN"></A><A name="VARIATIONEN"></A>PERMUT</FONT></FONT></H2> <P><HLPTEXT>Returns the number of pemutations for a given number of objects.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_VARIATIONEN2"></A><A name="VARIATIONEN2"></A>PERMUT2</FONT></FONT></H2> <P><HLPTEXT>Returns the number of permutations for a given number of objects (repetition allowed).</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WAHRSCHBEREICH"></A><A name="WAHRSCHBEREICH"></A>PROB</FONT></FONT></H2> <P><HLPTEXT>Returns the probability that values in a range are between two limits.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_FUNC_WEIBULL"></A><A name="WEIBULL"></A>WEIBULL</FONT></FONT></H2> <P><HLPTEXT>Returns the values of the Weibull distribution.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_DEFINE_NAME"></A>Define Names</FONT></FONT></H1> <HR> <P><A name="NamenfestlegenText"></A><HLPTEXT>Specify a name for a selected area here.</HLPTEXT> StarOffice organizes area names according to cell references, which are taken directly from your spreadsheet.<A name="Ende"></A> Area names can also contain formulas. You can define references by clicking the respective cells, or manually entering a reference in the Define Names dialog.</P> <P><A href="../00/00000404.htm#Einafe" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <P>In the <B>Sheet Area</B> drop-down box in the Formula bar, you will find a list of defined names. Just click a name to select a reference, and the corresponding area in the sheet will be highlighted. </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:COMBOBOX:RID_SCDLG_NAMES:ED_NAME"></A>Name</FONT></FONT></H2> <P><HLPTEXT>Enter the name of the area for which you want to define a reference. The list box lists all area names defined in the spreadsheet.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:EDIT:RID_SCDLG_NAMES:ED_ASSIGN"></A>Refers to</FONT></FONT></H2> <P><HLPTEXT>The reference of the selected area name is shown here as an absolute value.</HLPTEXT></P> <P>To insert a new area reference, place the cursor in this field and use your mouse to select the desired area in any sheet of your spreadsheet document.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_NAMES:RB_ASSIGN"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><BR> </H3> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MOREBUTTON:RID_SCDLG_NAMES:BTN_MORE"></A>>>More</FONT></FONT></H2> <P><HLPTEXT>Click this button to specify the <B>type of area</B> for the reference. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Type of area</FONT></FONT></H3> <P>Here you can define additional options related to the type of reference area.</P> <H4><FONT FACE="Times New Roman"><FONT SIZE=2><A name="SC:CHECKBOX:RID_SCDLG_NAMES:BTN_PRINTAREA"></A>Print area</FONT></FONT></H4> <P><HLPTEXT>Check this box to define the area as a print area.</HLPTEXT></P> <H4><FONT FACE="Times New Roman"><FONT SIZE=2><A name="SC:CHECKBOX:RID_SCDLG_NAMES:BTN_CRITERIA"></A>Filter</FONT></FONT></H4> <P><HLPTEXT>Check this box if you want to define the selected area as a filter.</HLPTEXT></P> <H4><FONT FACE="Times New Roman"><FONT SIZE=2><A name="SC:CHECKBOX:RID_SCDLG_NAMES:BTN_COLHEADER"></A>Repeat column</FONT></FONT></H4> <P><HLPTEXT>Check this box to define the area as a repeating column.</HLPTEXT></P> <H4><FONT FACE="Times New Roman"><FONT SIZE=2><A name="SC:CHECKBOX:RID_SCDLG_NAMES:BTN_ROWHEADER"></A>Repeat row</FONT></FONT></H4> <P><HLPTEXT>Check this box to define the area as a repeating row.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><<More</FONT></FONT></H2> <P><HLPTEXT>Click here to close the options box.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_NAMES:BTN_ADD"></A>Add</FONT></FONT></H2> <P><HLPTEXT>Click this button to add the defined name to the list.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_NAMES:BTN_REMOVE"></A><A href="../../common/00/00000001.htm#Loeschen" rel=Embedded></A></FONT></FONT></H2> <H2><BR> </H2> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_INSERT_NAME"></A>Paste Name</FONT></FONT></H1> <HR> <P><A name="NameneinfuegenText"></A><HLPTEXT>In this dialog, you can insert an area of cells into your spreadsheet.</HLPTEXT> Simply select the name of the area, and the referenced cell will be inserted.<A name="Ende"></A></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8% HEIGHT=32> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/HINWEIS.GIF" NAME="HIND_1" ALIGN=LEFT WIDTH=32 HEIGHT=32 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>You can only insert a cell area after having defined a name for the area. </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <P><A href="../00/00000404.htm#Einaei" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_NAMES_PASTE:LB_ENTRYLIST"></A>Paste Name</FONT></FONT></H2> <P><HLPTEXT>A list of all the defined cell areas is displayed here. Double-click any entry to insert the named area into the active sheet at the current cursor position.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_NAMES_PASTE:BTN_ADD"></A>Paste List</FONT></FONT></H2> <P><HLPTEXT>Click here to insert a list of all named areas and the corresponding cell references at the current cursor position.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_USE_NAME"></A>Create Names</FONT></FONT></H1> <HR> <P><A name="NamenuebernehmenText"></A>You can automatically generate the area names from the cell contents of the selection.</P> <P><A href="../00/00000404.htm#Einaueb" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Create name from</FONT></FONT></H2> <P>Specify the area from which you want to create a name here.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_NAMES_CREATE:BTN_TOP"></A>Header</FONT></FONT></H3> <P>Creates the area names from the header row of the selected area. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_NAMES_CREATE:BTN_LEFT"></A>Left Column</FONT></FONT></H3> <P>Creates the area names from the entries in the first column of the selected sheet area. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_NAMES_CREATE:BTN_BOTTOM"></A>Footer</FONT></FONT></H3> <P>Creates the area names from the entries in the last row of the selected sheet area. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_NAMES_CREATE:BTN_RIGHT"></A>Right Column</FONT></FONT></H3> <P>Creates the area names from the entries in the last column of the selected sheet area. </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SC:MODELESSDIALOG:RID_SCDLG_COLROWNAMERANGES"></A><A name="SID_DEFINE_COLROWNAMERANGES"></A>Define Label Range</FONT></FONT></H1> <HR> <P><A name="BeschText"></A><HLPTEXT>In this dialog you can define a label range.<A name="Ende"></A></HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_COLROWNAMERANGES:LB_RANGE"></A><A name="SC:EDIT:RID_SCDLG_COLROWNAMERANGES:ED_AREA"></A>Label range</FONT></FONT></H2> <P><HLPTEXT>Here you will see the respective area reference of the existing label ranges.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_COLROWNAMERANGES:RB_AREA"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><BR> </H3> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_COLROWNAMERANGES:BTN_COLHEAD"></A>Contains column headers</FONT></FONT></H3> <P><HLPTEXT>Choose this option if you want to include column headers in the current defined label area.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_COLROWNAMERANGES:BTN_ROWHEAD"></A>Contains row headers</FONT></FONT></H3> <P><HLPTEXT>Choose this option if you want to include row headers in the current defined label area.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:RID_SCDLG_COLROWNAMERANGES:ED_DATA"></A>For data range</FONT></FONT></H3> <P><HLPTEXT>This field displays the defined sheet area.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_COLROWNAMERANGES:RB_DATA"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><BR> </H3> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_COLROWNAMERANGES:BTN_ADD"></A>Add</FONT></FONT></H2> <P><HLPTEXT>Click here to add the current defined label area to the list.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_COLROWNAMERANGES:BTN_REMOVE"></A><A href="../../common/00/00000001.htm#Loeschen" rel=Embedded></A></FONT></FONT></H2> <H2><BR> </H2> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_CELL_FORMAT"></A>Cell Attributes</FONT></FONT></H1> <HR> <P><A NAME="END21"></A><A name="ZellattributeText"></A>Use this command to choose from a variety of formatting options and apply attributes to the selected cells.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SCPAGE_PROTECTION"></A><A name="Zellschutz"></A><A href="05020600.htm">Cell Protection</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Choose various protection options to apply to sheets and cell areas.</HLPTEXT><A name="Ende"></A></P> <P><A href="../00/00000405.htm#Fozelstz" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_PROTECTED"></A>Protected</FONT></FONT></H3> <P><HLPTEXT>To prevent certain cells from being modified, click here.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_HIDE_FORMULAR"></A>Hide Formulas</FONT></FONT></H3> <P><HLPTEXT>Check this box to temporarily hide formulas in the sheet.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_HIDE_ALL"></A>Hide All</FONT></FONT></H3> <P><HLPTEXT>Choose this option to temporarily hide all elements of a sheet.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Print</FONT></FONT></H2> <P>Define print options for the sheet.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_HIDE_PRINT"></A>Hide for Printing</FONT></FONT></H3> <P><HLPTEXT>If you choose this option, all selected cell areas in the sheet will be omitted in printing.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_ROW_OPT_HEIGHT"></A>Optimal Row Height</FONT></FONT></H1> <HR> <P><A name="OptiText"></A>Define the optimal row height for the selected rows.</P> <P><A href="../00/00000405.htm#Fozeiophoe" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Add</FONT></FONT></H2> <P>In this <A href="../../common/00/00000001.htm#Drehfeld" rel=popup>spin box</A> you can specify additional spacing between the largest character in a row and the cell boundaries.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Default Value</FONT></FONT></H2> <P>Restores the default value for the optimal row height.</P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_ROW_HIDE"></A><A name="FID_COL_HIDE"></A><A name="FID_TABLE_HIDE"></A><A name="Ausblenden"></A><A href="05030300.htm">Hide</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Use this command to hide rows, columns or individual sheets.</HLPTEXT><A name="Ende"></A></P> <P><A href="../00/00000405.htm#Fozeiaus" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <P><BR> </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_ROW_SHOW"></A><A name="FID_COL_SHOW"></A><A name="Einblenden"></A><A href="05030400.htm">Show</A></FONT></FONT></H1> <HR> <P>Choose this command to show previously hidden rows or columns.</P> <P><A href="../00/00000405.htm#Fozeiebl" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A> </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_COL_OPT_WIDTH"></A><A name="FID_COL_OPT_DIRECT"></A>Optimal Column Width</FONT></FONT></H1> <HR> <P><A name="OptiText"></A><HLPTEXT>Specify the optimal column width for selected columns.</HLPTEXT> The optimal column width depends on the largest entry in the spreadsheet. StarCalc offers the use of various measurement units.<A name="Ende"></A></P> <P><A href="../00/00000405.htm#Fospob" rel=popup_end><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_MTRIN_VAL"></A>Add</FONT></FONT></H2> <P><HLPTEXT>Use the spin buttons to define additional spacing between the longest entry in a column and the vertical column borders.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_MTRIN_DEF"></A>Default value</FONT></FONT></H2> <P><HLPTEXT>Define the optimal column width in order to display the entire contents of the column.</HLPTEXT> The additional spacing for the optimal column width is preset to 0.1 in.</P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SC:MODALDIALOG:RID_SCDLG_STRINPUT"></A><A name="FID_TAB_RENAME"></A><A name="FID_TAB_MENU_RENAME"></A>Rename</FONT></FONT></H1> <HR> <P><A NAME="END9"></A><A name="UmbenennenText"></A><HLPTEXT>This command opens a dialog where you can assign a different name to the current sheet.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_RENAME_NAME"></A><A name="SC:EDIT:RID_SCDLG_STRINPUT:ED_INPUT"></A><A name="HID_SC_APPEND_NAME"></A>Name</FONT></FONT></H2> <P>Enter a new name for the sheet here.</P> <P><A name="FID_TAB_APPEND"></A>Choose <B>Append</B> in the context menu of the sheet tab to insert an additional sheet after all existing sheets. In the <B>Append Sheet</B> dialog, assign a name to the new sheet. </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_TABLE_SHOW"></A>Show Sheet</FONT></FONT></H1> <HR> <P><A NAME="END3"></A><A name="TabeinText"></A>Use this command to display previously <B>hidden</B> sheets.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <P><A href="../00/00000405.htm#Fotenb" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MULTILISTBOX:RID_SCDLG_SHOW_TAB:LB_ENTRYLIST"></A>Hidden sheets</FONT></FONT></H2> <P>Here you will see a list of all hidden sheets in your spreadsheet document. </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_MERGE_ON"></A><A name="Festlegen"></A><A href="05060100.htm">Define</A></FONT></FONT></H1> <HR> <P>Merges the selected cell area and treats it as one cell.</P> <P><A href="../00/00000405.htm#Fozelzfe" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_MERGE_OFF"></A><A name="Aufheben"></A><A href="05060200.htm">Split</A></FONT></FONT></H1> <HR> <P>Choose this command to separate the merged area of cells.</P> <P><A href="../00/00000405.htm#Fozelzaf" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_FORMATPAGE"></A>Page Style</FONT></FONT></H1> <HR> <P><A NAME="END21"></A><A name="SeiteText"></A>Opens a dialog where you can determine the appearance of all pages in your document.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SCPAGE_TABLE"></A><A name="Tabelle"></A><A href="05070500.htm">Sheet</A></FONT></FONT></H1> <HR> <P><HLPTEXT>In <SWITCH "System"><CASE "OS2">this page</CASE>respectively <DEFAULT>this tab </DEFAULT>(Depends on platform) </SWITCH> you can specify the elements to be included in the printed document. Additionally, you can set the print order, the first page number and the page scale.</HLPTEXT><A name="ende"></A></P> <P><A href="../00/00000405.htm#Fostel" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Print</FONT></FONT></H2> <P>Define which elements of the spreadsheet are to be printed.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_HEADER"></A>Column and row headers</FONT></FONT></H3> <P><HLPTEXT>Check this box if you want the column headers A, B,... and the row headers 1, 2,... to be printed.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_GRID"></A>Grid</FONT></FONT></H3> <P><HLPTEXT>Check this box to print the gridlines between individual cells.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_NOTES"></A>Notes</FONT></FONT></H3> <P><HLPTEXT>Check this box to print the notes defined in your spreadsheet.</HLPTEXT> They will be printed on a separate page, along with the corresponding cell reference.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_OBJECTS"></A>Objects/pictures</FONT></FONT></H3> <P><HLPTEXT>Choose this option to include all inserted objects (if printable) and graphics with the printed document.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_CHARTS"></A>Charts</FONT></FONT></H3> <P><HLPTEXT>Click here to print the charts inserted in your spreadsheet.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_DRAWINGS"></A>Drawing Objects</FONT></FONT></H3> <P><HLPTEXT>If you choose this option, all draw objects will be included in printing.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_FORMULAS"></A>Formulas</FONT></FONT></H3> <P><HLPTEXT>Check this box if you want to print the formulas contained in the cells instead of the results.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_NULLVALS"></A>Zero Values</FONT></FONT></H3> <P><HLPTEXT>Click here to specify that the number 0 be included in printing. Otherwise, all cells containing the number 0 will not be printed.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Page Order</FONT></FONT></H2> <P>Define the order in which data in a sheet is numbered and printed when it does not fit on one printed page.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_TABLE:BTN_TOPDOWN"></A>Top to Bottom</FONT></FONT></H3> <P><HLPTEXT>Choose this option to print vertically from the left column to the bottom of the sheet.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_TABLE:BTN_LEFTRIGHT"></A>Left to Right</FONT></FONT></H3> <P>Choose this option to print horizontally from the top row of the sheet to the right column.<HLPTEXT></HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_PAGENO"></A>Number of first page</FONT></FONT></H3> <P><HLPTEXT>Select this option if you want the first page to start with a number other than 1.</HLPTEXT> Specify the number for the first printed page in the spin box.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Scale</FONT></FONT></H2> <P>Here you can define a page scale for the printed spreadsheet.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_TABLE:BTN_SCALEALL"></A><A name="SC:NUMERICFIELD:RID_SCPAGE_TABLE:ED_SCALEALL"></A>All pages to (%)</FONT></FONT></H3> <P><HLPTEXT>Choose this option to specify an enlargement or reduction factor to scale all printed pages.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_TABLE:BTN_SCALEPAGENUM"></A><A name="SC:NUMERICFIELD:RID_SCPAGE_TABLE:ED_SCALEPAGENUM"></A>Maximum pages</FONT></FONT></H3> <P><HLPTEXT>Choose this option to specify the maximum number of pages on which to print the entire document.</HLPTEXT> The document will be scaled to fit to the defined number of printed pages.</P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DEFINE_PRINTAREA"></A><A name="Festlegen"></A><A href="05080100.htm">Set</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Use this command to define an active cell or selected cell area as the print range.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DELETE_PRINTAREA"></A><A name="Aufheben"></A><A href="05080200.htm">Clear</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Use this command to clear the defined print area.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_OPENDLG_EDIT_PRINTAREA"></A>Edit Print Area</FONT></FONT></H1> <HR> <P><A name="DruckbereicheText"></A>Opens a dialog to edit the print area.</P> <P><A href="../00/00000405.htm#Fodbbe" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_AREAS:LB_PRINTAREA"></A><A name="SC:EDIT:RID_SCDLG_AREAS:ED_PRINTAREA"></A>Print Area</FONT></FONT></H2> <P>In this field you can modify a defined print area.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_AREAS:RB_PRINTAREA"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_AREAS:RB_REPEATROW"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_AREAS:RB_REPEATCOL"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><BR> </H3> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_AREAS:LB_REPEATROW"></A><A name="SC:EDIT:RID_SCDLG_AREAS:ED_REPEATROW"></A>Row title</FONT></FONT></H2> <P>Choose on or more rows to print as a horizontal title on every page. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><BR> </H3> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_AREAS:LB_REPEATCOL"></A><A name="SC:EDIT:RID_SCDLG_AREAS:ED_REPEATCOL"></A>Column title</FONT></FONT></H2> <P>Choose on or more columns to print as a vertical title on every page. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><BR> </H3> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_ADD_PRINTAREA"></A><A name="Hinzu"></A><A href="05080400.htm">Add</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Use this command to add the current selection to the defined print areas.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_STYLE_CATALOG"></A>Style Catalog</FONT></FONT></H1> <HR> <P><A name="VorlagenkatalogText"></A><HLPTEXT>Opens the dialog <B>Style Catalog</B> where you can create, edit and organize styles. </HLPTEXT></P> <P><A href="Slot:5573" rel=ExecuteURL></A><A href="../00/00000405.htm#Fovorka" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SFX2:LISTBOX:RID_STYLECATALOG:BT_TOOL"></A>Style Type</FONT></FONT></H2> <P><HLPTEXT>In the drop-down list, choose whether to show cell or page styles. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_TEMPLATE_FMT"></A><A name="Vorlagenliste"></A>List of Styles</FONT></FONT></H2> <P><HLPTEXT>Lists all existing styles of the selected style type; the current style in use is selected. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SFX2:LISTBOX:RID_STYLECATALOG:BT_FLIST"></A><A name="Vorlagenbereich"></A>Style Category</FONT></FONT></H2> <P><HLPTEXT>To keep an overview, the styles are divided into various style categories. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SFX2:PUSHBUTTON:RID_STYLECATALOG:BT_NEW"></A><A name="HID_STYLIST_NEW"></A>New...</FONT></FONT></H2> <P><HLPTEXT>Click here to open the dialog <B>Cell Style</B> (similar to the Cell Attributes dialog) or Page Style, depending on the selected style type.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SFX2:PUSHBUTTON:RID_STYLECATALOG:BT_EDIT"></A><A name="HID_STYLIST_EDIT"></A>Modify...</FONT></FONT></H2> <P><HLPTEXT>Click here to open the respective dialog <B>Cell Style</B> (similar to Cell Attributes) or Page Style.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SFX2:PUSHBUTTON:RID_STYLECATALOG:BT_DEL"></A><A name="HID_STYLIST_DELETE"></A>Delete...</FONT></FONT></H2> <P><HLPTEXT>Click here to delete the selected style (after confirming a delete warning). Only custom styles can be deleted.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SFX2:PUSHBUTTON:RID_STYLECATALOG:BT_ORG"></A>Organize...</FONT></FONT></H2> <P><HLPTEXT>Click this button to activate the Document Templates dialog.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="Gestalter"></A><A href="05100000.htm">Stylist</A></FONT></FONT></H1> <HR> <P>Click here to turn the Stylist on or off. The Stylist aids you in applying styles to objects and text. You can either update a style based on the current selection, modify an existing style or create a new style.<A name="Ende"></A> The Stylist <A href="../../common/00/00000005.htm#Andocken" rel=popup>dockable window</A> can remain open while editing the document.</P> <P><A href="Slot:5539" rel=ExecuteURL></A><A href="../../common/00/00040500.htm#Gestalter" rel=popup_End><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <P>By using styles in your documents, you can make comprehensive format changes in a snap, since when you modify a style, all text and objects to which the style has been applied are automatically updated.</P> <P>In the Stylist you will find various icons used to format documents:</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SID_STYLE_FAMILY2"></A>Cell Styles</FONT></FONT></H2> <P><HLPTEXT>Click this icon to display a list of existing cell styles for soft formatting.</HLPTEXT></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/ZELLSYM.GIF" NAME="Zellsym" ALIGN=LEFT WIDTH=22 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Cell Styles </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SID_STYLE_FAMILY4"></A>Page Styles</FONT></FONT></H2> <P><HLPTEXT>Click here to display the existing <B>Page Styles</B>. Page styles allow you to use soft formatting to define the structure of a page.</HLPTEXT> If you specify a "next style," StarCalc automatically applies a style to each new page after an automatic page break.</P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/SWH00271.GIF" NAME="Grafik4" ALIGN=LEFT WIDTH=23 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Page Styles </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_TEMPLDLG_WATERCAN"></A>Fill Format Mode</FONT></FONT></H2> <P><HLPTEXT>Use this mode to apply identical styles to areas or objects in the work area.</HLPTEXT> When the Fill Format mode is active, the mouse pointer appears as a watercan symbol. To exit this mode, click the icon in the Stylist again.</P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/SWH00293.GIF" NAME="Grafik2" ALIGN=LEFT WIDTH=23 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Fill Format Mode </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>How to apply a new style with the watercan:</FONT></FONT></H3> <UL> <LI><P>Select the desired style in the Stylist.</P> <LI><P>Click on the <B>Fill Format Mode</B> icon. </P> <LI><P>Position the watercan pointer above the object or area to which you want to apply a selected style.</P> <LI><P>Click a single cell to select it, or drag your mouse over an entire area to select adjacent cells.</P> <LI><P>To exit the <B>Fill Format Mode</B> click the icon in the Stylist again. </P> </UL> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_TEMPLDLG_NEWBYEXAMPLE"></A>New Style by Example</FONT></FONT></H2> <P><HLPTEXT>Click here to create a new style based on the formatting of a selected object.</HLPTEXT> Assign a name for the style in the Create Style dialog.</P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/SWH00294.GIF" NAME="Grafik5" ALIGN=LEFT WIDTH=22 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>New Style By Example </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_TEMPLDLG_UPDATEBYEXAMPLE"></A>Update Style</FONT></FONT></H2> <P><HLPTEXT>Click this icon to update a style in the Stylist with the formatting of a selected object.</HLPTEXT> The update applies to all draw objects to which this style has been assigned.</P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/SWH00295.GIF" NAME="Grafik6" ALIGN=LEFT WIDTH=23 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Update Style </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="05090000.htm#Vorlagenliste" rel=embedded_end></A></FONT></FONT></H2> <H2><BR> </H2> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>List of Styles / Style Category / Context menu New... / Modify... / Delete...</FONT></FONT></H3> <P><HLPTEXT>Here you have access to the same functions in the Format - Style Catalog dialog.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_TEMPLATE_FILTER"></A>Style Category</FONT></FONT></H2> <P><HLPTEXT>Select the desired style category in this list box.</HLPTEXT></P> <P><A href="../../common/02/02010000.htm#SyListenfeld" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_AUTOFORMAT"></A><A name="AutoFormat"></A><A href="05110000.htm">AutoFormat</A></FONT></FONT></H1> <HR> <P><A name="AutoformatText"></A><HLPTEXT>Use this command to apply an AutoFormat to a selected sheet area or define your own AutoFormats.</HLPTEXT><A name="Ende"></A></P> <P><A href="Slot:10242" rel=ExecuteURL></A><A href="../00/00000405.htm#Foatfo" rel=popup_end><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_AUTOFORMAT:LB_FORMAT"></A>Format</FONT></FONT></H2> <P><HLPTEXT>Choose a predefined AutoFormat to apply to a selected area in your sheet.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../../common/00/00000001.htm#Vorschau" rel=Embedded></A></FONT></FONT></H2> <H2><BR> </H2> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_AUTOFORMAT:BTN_ADD"></A>Insert</FONT></FONT></H2> <P><HLPTEXT>Add the formatting of a selected area (at least 4 x 4 cells) to the list of predefined AutoFormats.</HLPTEXT> Click <B>Insert...</B> to open the Add AutoFormat dialog. Enter a name and press OK.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_AUTOFORMAT:BTN_REMOVE"></A><A href="../../common/00/00000001.htm#Loeschen" rel=Embedded></A></FONT></FONT></H2> <H2><BR> </H2> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MOREBUTTON:RID_SCDLG_AUTOFORMAT:BTN_MORE"></A>More >></FONT></FONT></H2> <P><HLPTEXT>Click this button to view the <B>Formatting</B> section where you can exclude certain AutoFormat options. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Formatting</FONT></FONT></H3> <P>In this section you can turn the following elements of the <B>AutoFormat</B> on or off: <B>Number format, Borders, Font, Pattern, Orientation</B> and <B>Adjust width and height to fit</B>. </P> <H4><FONT FACE="Times New Roman"><FONT SIZE=2><A name="SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_NUMFORMAT"></A>Number Format</FONT></FONT></H4> <P><HLPTEXT>Clear this check box if the number format should not be changed.</HLPTEXT></P> <H4><FONT FACE="Times New Roman"><FONT SIZE=2><A name="SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_BORDER"></A>Borders</FONT></FONT></H4> <P><HLPTEXT>Clear this check box if you want do not want to change the borders.</HLPTEXT></P> <H4><FONT FACE="Times New Roman"><FONT SIZE=2><A name="SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_FONT"></A>Font</FONT></FONT></H4> <P><HLPTEXT>Clear this check box if you want to retain the font.</HLPTEXT></P> <H4><FONT FACE="Times New Roman"><FONT SIZE=2><A name="SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_PATTERN"></A>Pattern</FONT></FONT></H4> <P><HLPTEXT>Clear this check box if you want to retain the pattern (colors, etc.)</HLPTEXT></P> <H4><FONT FACE="Times New Roman"><FONT SIZE=2><A name="SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_ALIGNMENT"></A>Orientation</FONT></FONT></H4> <P><HLPTEXT>Clear this check box if the orientation should stay as it is.</HLPTEXT></P> <H4><FONT FACE="Times New Roman"><FONT SIZE=2><A name="SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_ADJUST"></A>Adjust width and height to fit</FONT></FONT></H4> <P><HLPTEXT>Clear this check box if the width and height of the selected cells should not be changed.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>More <<</FONT></FONT></H2> <P>Use this button as well to close the <B>Formatting</B> options section. </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_OPENDLG_CONDFRMT"></A><A name="SC:MODELESSDIALOG:RID_SCDLG_CONDFORMAT"></A>Conditional Formatting</FONT></FONT></H1> <HR> <P><A name="BedingteText"></A><HLPTEXT>Choose <B>Conditional Formatting</B> to define format styles dependent on certain conditions.</HLPTEXT></P> <P><A href="Slot:26159" rel=ExecuteURL></A><A href="../00/00000405.htm#Bedingte" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:CHECKBOX:RID_SCDLG_CONDFORMAT:CBX_COND1"></A><A name="SC:CHECKBOX:RID_SCDLG_CONDFORMAT:CBX_COND2"></A><A name="SC:CHECKBOX:RID_SCDLG_CONDFORMAT:CBX_COND3"></A>Condition 1/2/3</FONT></FONT></H2> <P><HLPTEXT>Check this box to define a condition.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND1_1"></A><A name="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND2_1"></A><A name="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_1"></A>Cell value/Formula</FONT></FONT></H2> <P><HLPTEXT>Specify if the conditional formatting should be dependent on a cell value or a formula. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND1_2"></A><A name="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND2_2"></A><A name="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_2"></A>Cell Value Condition</FONT></FONT></H2> <P><HLPTEXT>Choose a condition for the format to be applied to the selected cells. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND1_TEMPLATE"></A><A name="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND2_TEMPLATE"></A><A name="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_TEMPLATE"></A>Cell style</FONT></FONT></H2> <P><HLPTEXT>Choose the style to be applied if the specified condition is met.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND2_2"></A><A name="SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND1_1"></A><A name="SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND1_2"></A><A name="SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND2_1"></A><A name="SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND3_1"></A><A name="SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND3_2"></A>Parameter field</FONT></FONT></H2> <P><HLPTEXT HIDE>In the parameter field (or in both parameter fields if you have selected a condition that requires two parameters) enter a reference, value or formula.</HLPTEXT></P> <P>Once the parameters have been defined, the condition is complete. It may appear, for example, as:</P> <P>Cell value is equal 0: Cell style Null value (You must have already defined a cell style with this name before assigning it to a condition).</P> <P>Cell value is between $B$20 and $B$21: Cell style Result (The corresponding value limits must already exist in cells B20 and B21)</P> <P>Formula is SUM($A$1:$A$5)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the contents in cells A1 to A5 is equal to 10.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:IMAGEBUTTON:RID_SCDLG_CONDFORMAT:RB_COND1_1"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_CONDFORMAT:RB_COND2_1"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_CONDFORMAT:RB_COND3_1"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_CONDFORMAT:RB_COND1_2"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_CONDFORMAT:RB_COND2_2"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_CONDFORMAT:RB_COND3_2"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DETECTIVE_ADD_PRED"></A><A name="SpurzumVorgaenger"></A><A href="06030100.htm">Trace Precedents</A></FONT></FONT></H1> <HR> <P><HLPTEXT>This function shows the relationship between the active cell containing a formula, and the corresponding cells used in the formula.</HLPTEXT> StarCalc draws tracer arrows in the spreadsheet and marks the area containing all cells used in the formula with a blue border.<A name="Ende"></A></P> <P><A href="../00/00000406.htm#Exdszv" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8% HEIGHT=32> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/HINWEIS.GIF" NAME="HIND_1" ALIGN=LEFT WIDTH=32 HEIGHT=32 BORDER=0> <BR> </P> <P><BR> </TD> <TD WIDTH=92%> <P>This function is based on a principle of layers. For example, if the precedent cell to a formula is already indicated with a tracer arrow, when you repeat this command, the tracer arrows are drawn to the precedent cells of this cell. </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DETECTIVE_DEL_PRED"></A><A name="SpurzumVorgaengerentfernen"></A><A href="06030200.htm">Remove Precedents</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Deletes one level of tracer arrows inserted with <B>Trace Precendents</B>.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DETECTIVE_ADD_SUCC"></A><A name="SpurzumNachfolger"></A><A href="06030300.htm">Trace Dependents</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Draws tracer arrows to the active cell from formulas that depend on values in the active cell.. Additionally, the area of all cells that are used together with the active cell in an equation is surrounded by a blue frame.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <P><BR> </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DETECTIVE_DEL_SUCC"></A><A name="SpurzumNachfolgerentfernen"></A><A href="06030400.htm">Remove Dependents</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Deletes one level of tracer arrows created with <B>Trace Dependents</B>.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DETECTIVE_DEL_ALL"></A><A name="AlleSpurenentfernen"></A><A href="06030500.htm">Remove All Traces</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Removes all tracer arrows from the spreadsheet.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DETECTIVE_ADD_ERR"></A><A name="SpurzumFehler"></A><A href="06030600.htm">Trace Error</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>This function draws tracer arrows to all cells which cause an error value in a selected cell.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DETECTIVE_FILLMODE"></A><A name="FuellModus"></A><A href="06030700.htm">Fill Mode</A></FONT></FONT></H1> <HR> <P><A NAME="END8"></A>This command activates the Fill mode in the Detective. The mouse pointer changes to a special symbol, and you can click any cell to see a trace to the precedent cell. To exit this mode, press Escape or click the <B>End Fill Mode</B> command in the context menu. <HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DETECTIVE_INVALID"></A><A name="Dateneinkreisen"></A><A href="06030800.htm">Mark invalid data</A></FONT></FONT></H1> <HR> <P><A NAME="END8"></A>This command marks all cells in the sheet that contain values outside the validation rules.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DETECTIVE_REFRESH"></A><A name="Spurenaktualisieren"></A><A href="06030900.htm">Refresh Traces</A></FONT></FONT></H1> <HR> <P>Use this command to redraw all traces in the sheet.</P> <P><A href="../00/00000406.htm#Spurenaktualisieren" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DETECTIVE_AUTO"></A><A name="Autoaktu"></A><A href="06031000.htm">Refresh Traces</A></FONT></FONT></H1> <HR> <P>Use this command to redraw all traces in the sheet.</P> <P><A href="../00/00000406.htm#Automatisch" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <P><A href="06030900.htm#Pfeile" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_OPENDLG_SOLVE"></A>Goal Seek</FONT></FONT></H1> <HR> <P><A name="ZielwertsucheText"></A><HLPTEXT>Opens a dialog where you can specify a target value for a selected cell.</HLPTEXT></P> <P><A href="Slot:26153" rel=ExecuteURL></A><A href="../00/00000406.htm#Exzws" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:RID_SCDLG_SOLVER:ED_FORMULACELL"></A>Formula cell</FONT></FONT></H3> <P><HLPTEXT>In the formula cell, enter the reference of the cell which contains the formula. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:RID_SCDLG_SOLVER:ED_TARGETVAL"></A>Target value</FONT></FONT></H3> <P><HLPTEXT>Enter the value you want to acheive as a new result.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:RID_SCDLG_SOLVER:ED_VARCELL"></A>Variable cell</FONT></FONT></H3> <P><HLPTEXT>Enter the reference for the cell that contains the value you want to adjust in order to reach the target.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_SOLVER:RB_FORMULACELL"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_SOLVER:RB_VARCELL"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_SCENARIOS"></A>Create Scenario</FONT></FONT></H1> <HR> <P><A name="SzenarioText"></A><HLPTEXT>In the <B>Create Scenario</B> dialog, you can assign a name and comments to a scenario.</HLPTEXT><A name="Ende"></A></P> <P><A href="Slot:26312" rel=ExecuteURL></A><A href="../00/00000406.htm#Exsze" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <P><A href="../../common/00/00000099.htm#extraszenarien" rel=popup><A href="../../common/00/00000099.htm#Siehe" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:EDIT:RID_SCDLG_NEWSCENARIO:ED_NAME"></A>Scenario name</FONT></FONT></H2> <P><HLPTEXT>In this field, enter a descriptive name for the scenario.</HLPTEXT> Later, you will select (and edit) the scenario view based on the name displayed on the sheet tabs or in the Navigator.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MULTILINEEDIT:RID_SCDLG_NEWSCENARIO:ED_COMMENT"></A>Comments</FONT></FONT></H2> <P><HLPTEXT>Under <B>Comments</B>, you can enter additional information about the scenario.</HLPTEXT> This information will be displayed in the Navigator when you click the <B>Scenarios</B> icon and select the desired scenario. </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_PROTECT_TABLE"></A>Protect Sheet</FONT></FONT></H1> <HR> <P><A name="TabelleText"></A><HLPTEXT>Click here to protect the sheet from being modified.</HLPTEXT> </P> <P><A href="../00/00000406.htm#Exdst" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SFX2:EDIT:DLG_PASSWD:ED_PASSWD"></A>Password (optional)</FONT></FONT></H2> <P><HLPTEXT>To protect your sheet from unauthorized changes, enter a password here.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_PROTECT_DOC"></A><A name="HID_PASSWD"></A>Protect Document</FONT></FONT></H1> <HR> <P><A name="DokumentText"></A>Protects your entire document from modifications. </P> <P><A href="../00/00000406.htm#Exdsd" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Password (optional)</FONT></FONT></H2> <P>To protect your entire document from unauthorized changes, enter a password here.</P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_AUTO_CALC"></A><A name="Automatisch"></A><A href="06070000.htm">Auto Calculate</A></FONT></FONT></H1> <HR> <P>If you choose this option, formulas will be automatically recalculated, and if necessary, the results will be corrected.</P> <P><A href="../00/00000406.htm#Exatmb" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_RECALC"></A><A name="Neu"></A><A href="06080000.htm">Recalculate</A></FONT></FONT></H1> <HR> <P>Recalculates the current sheet immediately.</P> <P><A href="../00/00000406.htm#Exnb" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <P><A href="../02/06050000.htm#Tip" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_AUTOCOMPLETE"></A><A name="AutoEingabe"></A><A href="06130000.htm">Auto Input</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Activate the Auto Complete function to automatically complete the contents of a vertical list. The Auto Complete automatically fills in the remaining text if the first few characters you type match an existing entry in the column. The automatically generated text is displayed inverted.<HLPTEXT><A name="Ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_WINDOW_SPLIT"></A><A name="Teilen"></A><A href="07080000.htm">Split</A></FONT></FONT></H1> <HR> <P><A NAME="END8"></A>Activate this command to split the window area into four sections. A horizontal and vertical line are displayed extending from the active cell. These lines divide the screen into left, right, upper and lower sections. All four sections contain a scroll bar which you can use to view the entries in the individual sections.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_WINDOW_FIX"></A><A name="Fixieren"></A><A href="07090000.htm">Freeze</A></FONT></FONT></H1> <HR> <P><A NAME="END8"></A>Choose this command to freeze the active window. Freezing a worksheet can be especially useful when working with large sheets, because it keeps the column or row titles in view even when your cursor is in a different area of the worksheet.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_DEFINE_DBNAME"></A>Define Database Area</FONT></FONT></H1> <HR> <P><A name="BereichText"></A><HLPTEXT>Define a database area in your sheet.</HLPTEXT><A name="ende"></A></P> <P><A href="Slot:26320" rel=ExecuteURL></A><A href="../00/00000412.htm#Dbrbf" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:COMBOBOX:RID_SCDLG_DBNAMES:ED_NAME"></A>Name</FONT></FONT></H2> <P><HLPTEXT>In this field you can define a new database area or select an existing one.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:EDIT:RID_SCDLG_DBNAMES:ED_DBAREA"></A>Area</FONT></FONT></H2> <P><HLPTEXT>This field displays the area reference of the selected database area.</HLPTEXT> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_DBNAMES:RB_DBAREA"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><BR> </H3> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_DBNAMES:BTN_ADD"></A>Add/Modify</FONT></FONT></H2> <P><HLPTEXT>Click here to add the new defined database area to the list, or modify an existing one.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_DBNAMES:BTN_REMOVE"></A><A href="../../common/00/00000001.htm#Loeschen" rel=Embedded></A></FONT></FONT></H2> <H2><BR> </H2> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MOREBUTTON:RID_SCDLG_DBNAMES:BTN_MORE"></A>More >></FONT></FONT></H2> <P><HLPTEXT>Click this button to expand the dialog to view additional options.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Options</FONT></FONT></H1> <HR> <P>Define additional options for a database import.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_HEADER"></A>Contains column headers</FONT></FONT></H3> <P><HLPTEXT>Check this box if the defined database area contains column headers.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_SIZE"></A>Insert or delete cells</FONT></FONT></H3> <P><HLPTEXT>If you choose this option, any rows or columns subsequently created in the database are automatically inserted into your document as well.</HLPTEXT> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_FORMAT"></A>Keep formatting as is</FONT></FONT></H3> <P><HLPTEXT>Check here to apply the existing cell formatting to new cells inserted from a database.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_STRIPDATA"></A>Don't save external data</FONT></FONT></H3> <P><HLPTEXT>Choose this option to save only a reference to the database rather than the file itself.</HLPTEXT> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3>Source:</FONT></FONT></H3> <P>Displays information about the source of the database and any existing operators.</P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_SELECT_DB"></A>Select Database Area</FONT></FONT></H1> <HR> <P><A name="Bereichwaehlen"></A>Select a previously defined database here. </P> <P><A href="Slot:26321" rel=ExecuteURL></A><A href="../00/00000412.htm#Dbrba" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_SELENTRY_LIST"></A>Areas</FONT></FONT></H2> <P>Here you will find a list of all existing database areas defined in the current document. </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_SORT"></A>Sort</FONT></FONT></H1> <HR> <P><A name="SortText"></A>In this dialog you can define the conditions for the sort function.</P> <P><A href="../00/00000412.htm#Dnsrt" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="Slot:26322#1" rel=ExecuteURL></A><A href="12030100.htm#Sortierkriterien" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="Slot:26322#2" rel=ExecuteURL></A><A href="12030200.htm#Optionen" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../../common/00/00000001.htm#Zurueck" rel=Embedded></A></FONT></FONT></H2> <H2><BR> </H2> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SCPAGE_SORT_FIELDS"></A><A name="Sortierkriterien"></A><A href="12030100.htm">Sort Criteria</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Define the sort criteria, such as sort order, direction and whether to sort columns or rows.</HLPTEXT><A name="ende"></A></P> <P><A href="../00/00000412.htm#Dnsosk" rel=popup_end><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCPAGE_SORT_FIELDS:LB_SORT1"></A>Sort by</FONT></FONT></H2> <P><HLPTEXT>Select the criteria you want to be used as the primary sort key.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_SORT_FIELDS:BTN_UP1"></A>Ascending</FONT></FONT></H3> <P><HLPTEXT>Choose this option to sort beginning with the lowest value, i.e. from A to Z or 0 to 9.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_SORT_FIELDS:BTN_DOWN1"></A>Descending</FONT></FONT></H3> <P><HLPTEXT>Choose this option to sort beginning with the highest value, i.e. from Z to A or 9 to 0.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCPAGE_SORT_FIELDS:LB_SORT2"></A>Then by</FONT></FONT></H2> <P><HLPTEXT>Choose the criteria to use as the secondary sort key.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_SORT_FIELDS:BTN_UP2"></A>Ascending</FONT></FONT></H3> <P><HLPTEXT>Choose this option to sort beginning with the lowest value, i.e. from A to Z or 0 to 9.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_SORT_FIELDS:BTN_DOWN2"></A>Descending</FONT></FONT></H3> <P><HLPTEXT>Choose this option to sort beginning with the highest value, i.e. from Z to A or 9 to 0.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCPAGE_SORT_FIELDS:LB_SORT3"></A>Then by</FONT></FONT></H2> <P><HLPTEXT>Choose the criteria to use as the third sort key.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_SORT_FIELDS:BTN_UP3"></A>Ascending</FONT></FONT></H3> <P><HLPTEXT>Choose this option to sort beginning with the lowest value, i.e. from A to Z or 0 to 9.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_SORT_FIELDS:BTN_DOWN3"></A>Descending</FONT></FONT></H3> <P><HLPTEXT>Choose this option to sort beginning with the highest value, i.e. from Z to A or 9 to 0.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SID_SORT_ASCENDING"></A><A name="SID_SORT_DESCENDING"></A>Sort Ascending/Descending</FONT></FONT></H2> <P><HLPTEXT>Use the icons to switch between ascending and descending sort order.</HLPTEXT></P> <P><A href="../00/00000412.htm#SySortieren" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SCPAGE_SORT_OPTIONS"></A><A name="Optionen"></A><A href="12030200.htm">Options</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Choose additional options for the sort function defined in <B>Sort criteria</B>.</HLPTEXT><A name="ende"></A></P> <P><A href="../00/00000412.htm#Dnstot" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:CHECKBOX:RID_SCPAGE_SORT_OPTIONS:BTN_CASESENSITIVE"></A>Case Sensitive</FONT></FONT></H2> <P><HLPTEXT>Check this box to sort text first by upper case and then by lower case letters.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:CHECKBOX:RID_SCPAGE_SORT_OPTIONS:BTN_LABEL"></A>Area contains column headers</FONT></FONT></H2> <P><HLPTEXT>If you check this box, the first selected row in the sheet is omitted in the sort function.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:CHECKBOX:RID_SCPAGE_SORT_OPTIONS:BTN_FORMATS"></A>Include formats</FONT></FONT></H2> <P><HLPTEXT>If this check box is not selected, all formatting in the individual cells remains unchanged after being sorted, even if the cell contents change.</HLPTEXT> Usually formatting is applied to an entire cell, not the cell contents.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:CHECKBOX:RID_SCPAGE_SORT_OPTIONS:BTN_COPYRESULT"></A>Copy sort results to:</FONT></FONT></H2> <P><HLPTEXT>If you choose this option, the sort results will be saved in a predefined sheet area.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCPAGE_SORT_OPTIONS:LB_OUTAREA"></A>Sort results</FONT></FONT></H3> <P><HLPTEXT>If you have defined a sheet area, you can select it here.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:RID_SCPAGE_SORT_OPTIONS:ED_OUTAREA"></A>Sort results</FONT></FONT></H3> <P><HLPTEXT>Enter the cell area where you want the results to appear.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:CHECKBOX:RID_SCPAGE_SORT_OPTIONS:BTN_SORT_USER"></A>User-defined sort order</FONT></FONT></H2> <P><HLPTEXT>Check here to use a custom sort order.</HLPTEXT> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCPAGE_SORT_OPTIONS:LB_SORT_USER"></A>Custom sort order</FONT></FONT></H3> <P><HLPTEXT>Choose a custom sort order defined in Tools - Options - Spreadsheet - Custom Lists.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_SORT_OPTIONS:BTN_TOP_DOWN"></A>Top to Bottom (Sort Rows)</FONT></FONT></H3> <P><HLPTEXT>Sorts all rows of the active columns within the selected area.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_SORT_OPTIONS:BTN_LEFT_RIGHT"></A>Left to Right (Sort Columns)</FONT></FONT></H3> <P><HLPTEXT>Sorts all columns of the active rows within the selected area.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_AUTO_FILTER"></A><A name="AutoFilter"></A><A href="12040100.htm">AutoFilter</A></FONT></FONT></H1> <HR> <P>Use the AutoFilter to select certain values from a list or a databank to be displayed on the worksheet.</P> <P><A href="../00/00000412.htm#Dnfiafi" rel=popup_end><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <P><A href="../../staruser/03020500.htm#Autofiltertext" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_FILTER"></A>Standard Filter / Filter</FONT></FONT></H1> <HR> <P><A name="Standardfilter"></A><HLPTEXT>In this dialog you can specify conditions for filtering data in a sheet.</HLPTEXT></P> <P><A href="../00/00000412.htm#Dnfitdf" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCDLG_FILTER:LB_OP1"></A><A name="SC:LISTBOX:RID_SCDLG_FILTER:LB_OP2"></A><A name="SBA:LISTBOX:DLG_FILTERCRIT:LB_WHERECOND2"></A><A name="SBA:LISTBOX:DLG_FILTERCRIT:LB_WHERECOND3"></A>Operator</FONT></FONT></H3> <P><HLPTEXT>Choose between the logical operators AND / OR.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCDLG_FILTER:LB_FIELD1"></A><A name="SC:LISTBOX:RID_SCDLG_FILTER:LB_FIELD2"></A><A name="SC:LISTBOX:RID_SCDLG_FILTER:LB_FIELD3"></A><A name="SBA:LISTBOX:DLG_FILTERCRIT:LB_WHEREFIELD1"></A><A name="SBA:LISTBOX:DLG_FILTERCRIT:LB_WHEREFIELD2"></A><A name="SBA:LISTBOX:DLG_FILTERCRIT:LB_WHEREFIELD3"></A>Field name</FONT></FONT></H3> <P><HLPTEXT>Choose a field name from the current sheet to be used in the filter.</HLPTEXT> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCDLG_FILTER:LB_COND1"></A><A name="SC:LISTBOX:RID_SCDLG_FILTER:LB_COND2"></A><A name="SC:LISTBOX:RID_SCDLG_FILTER:LB_COND3"></A><A name="SBA:LISTBOX:DLG_FILTERCRIT:LB_WHERECOMP1"></A><A name="SBA:LISTBOX:DLG_FILTERCRIT:LB_WHERECOMP2"></A><A name="SBA:LISTBOX:DLG_FILTERCRIT:LB_WHERECOMP3"></A>Condition</FONT></FONT></H3> <P><HLPTEXT>From this list box choose a comparitive operator to use between the entries <B>Field name</B> and <B>Value</B>. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:COMBOBOX:RID_SCDLG_FILTER:ED_VAL1"></A><A name="SC:COMBOBOX:RID_SCDLG_FILTER:ED_VAL2"></A><A name="SC:COMBOBOX:RID_SCDLG_FILTER:ED_VAL3"></A><A name="SBA:EDIT:DLG_FILTERCRIT:ET_WHEREVALUE1"></A><A name="SBA:EDIT:DLG_FILTERCRIT:ET_WHEREVALUE2"></A><A name="SBA:EDIT:DLG_FILTERCRIT:ET_WHEREVALUE3"></A>Value</FONT></FONT></H3> <P><HLPTEXT>This list box contains all possible values for the specified <B>field name</B>.</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MOREBUTTON:RID_SCDLG_FILTER:BTN_MORE"></A><A href="12040201.htm">More>></A></FONT></FONT></H2> <P><A href="12040201.htm#ZusaetzeText" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="Zusaetze"></A><A href="12040201.htm">Options</A></FONT></FONT></H1> <HR> <P><A href="../00/00000412.htm#Filterzus" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_FILTER:BTN_CASE"></A><A name="SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_CASE"></A>Case Sensitive</FONT></FONT></H3> <P><HLPTEXT>Choose this option to differentiate between upper and lower case text in a filtered list of values.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_FILTER:BTN_HEADER"></A><A name="SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_HEADER"></A>Include Column Headers</FONT></FONT></H3> <P><HLPTEXT>If you choose this option, the column headers in the first row of a sheet are included in the filter.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_FILTER:BTN_COPY_RESULT"></A><A name="SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_COPY_RESULT"></A><A name="SC:LISTBOX:RID_SCDLG_FILTER:LB_COPY_AREA"></A><A name="SC:LISTBOX:RID_SCDLG_SPEC_FILTER:LB_COPY_AREA"></A><A name="SC:EDIT:RID_SCDLG_FILTER:ED_COPY_AREA"></A><A name="SC:EDIT:RID_SCDLG_SPEC_FILTER:ED_COPY_AREA"></A>Copy results to</FONT></FONT></H3> <P><HLPTEXT>Click here to select an area where you want the filter results to appear. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_FILTER:RB_COPY_AREA"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_SPEC_FILTER:RB_COPY_AREA"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><BR> </H3> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_FILTER:BTN_REGEXP"></A><A name="SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_REGEXP"></A>Regular expression</FONT></FONT></H3> <P><HLPTEXT>Check this box if you want to use wildcards in the filter. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_FILTER:BTN_UNIQUE"></A><A name="SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_UNIQUE"></A>Unique records only</FONT></FONT></H3> <P><HLPTEXT>Check here to exclude duplicate rows in the list of filtered data.</HLPTEXT> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_DEST_PERS"></A><A name="SC:CHECKBOX:RID_SCDLG_FILTER:BTN_DEST_PERS"></A>Keep filter criteria</FONT></FONT></H3> <P><HLPTEXT>If a target area is specified in the field <B>Copy results to</B>, you can define the filter to be <SWITCH "System"><CASE "MAC">saved</CASE>respectively <CASE "OS2">saved</CASE>respectively <DEFAULT>saved</DEFAULT>(Depends on platform) </SWITCH> as filter criteria in a different area in the source area.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Data area</FONT></FONT></H2> <P>Displays a reference to the data area in the sheet which is to be filtered.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MOREBUTTON:RID_SCDLG_SPEC_FILTER:BTN_MORE"></A>More<<</FONT></FONT></H2> <P><HLPTEXT>Click this button again to close the options dialog.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_SPECIAL_FILTER"></A>Special Filter</FONT></FONT></H1> <HR> <P><A name="Spezialfilter"></A><HLPTEXT>In this dialog you can define an advanced filter with more than three filter criteria.</HLPTEXT><A name="ende"></A></P> <P><A href="../00/00000412.htm#Dnfspz" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../../staruser/03020500.htm#Filtertext" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_SPEC_FILTER:LB_CRITERIA_AREA"></A><A name="SC:EDIT:RID_SCDLG_SPEC_FILTER:ED_CRITERIA_AREA"></A>Read filter criteria from</FONT></FONT></H2> <P><HLPTEXT>Choose the area name in the sheet which contains the necessary filter criteria, or enter the area reference directly.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_SPEC_FILTER:RB_CRITERIA_AREA"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H2><BR> </H2> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_UNFILTER"></A><A name="Filterentfernen"></A><A href="12040400.htm">Remove Filter</A></FONT></FONT></H1> <HR> <P>Clears a filter set in the selected sheet area.</P> <P><A href="../00/00000412.htm#Dnfief" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_AUTOFILTER_HIDE"></A><A name="AutoFilterausblenden"></A><A href="12040500.htm">Hide AutoFilter</A></FONT></FONT></H1> <HR> <P>Click here to hide the buttons repesenting the AutoFilter defined in the sheet area.</P> <P><A href="../00/00000412.htm#Dnaftas" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_SUBTOTALS"></A>Subtotals</FONT></FONT></H1> <HR> <P><A name="Teilergebnisse"></A>In this dialog you can define the settings for automatic calculation of subtotals. </P> <P><A href="../00/00000412.htm#Dntegs" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="12050100.htm#Gruppe" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="12050200.htm#Optionen" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../../common/00/00000001.htm#Zurueck" rel=Embedded></A></FONT></FONT></H2> <H2><BR> </H2> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SCPAGE_SUBT_GROUP2"></A><A name="HID_SCPAGE_SUBT_GROUP3"></A><A name="HID_SCPAGE_SUBT_GROUP1"></A><A name="Gruppe"></A><A href="12050100.htm">1st, 2nd, 3rd Group</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Define the settings for one of the three subtotal groups.</HLPTEXT> </P> <P><A href="../00/00000412.htm#Dntezd" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_SUBT_GROUP"></A>Group by</FONT></FONT></H2> <P><HLPTEXT>Select the column which contains the items by which to subtotal values in other columns. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SCPAGE_SUBT_GROUP"></A><A name="HID_SC_SUBT_COLS"></A>Calculate subtotals for</FONT></FONT></H2> <P><HLPTEXT>Choose the selected columns in the sheet which contain the values to be subtotaled.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="HID_SC_SUBT_FUNC"></A>Use function</FONT></FONT></H2> <P><HLPTEXT>Choose the mathematical function to use for calculating subtotals.</HLPTEXT></P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SCPAGE_SUBT_OPTIONS"></A><A name="Optionen"></A><A href="12050200.htm">Options</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Define various settings for calculating and presenting subtotals.</HLPTEXT><A name="ende"></A></P> <P><A href="../00/00000412.htm#Dntopi" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_PAGEBREAK"></A>Page break between groups</FONT></FONT></H2> <P><HLPTEXT>Click here to insert a new page after each group of subtotaled data.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_CASE"></A>Case sensitive</FONT></FONT></H2> <P><HLPTEXT>If this option is selected, any changes in capitalization results in recalculation of subtotals.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_SORT"></A>Pre-sort area according to groups</FONT></FONT></H2> <P><HLPTEXT>Sorts the area defined in the <SWITCH "System"><CASE "OS2">Group pages</CASE>respectively <DEFAULT>Group tabs</DEFAULT>(Depends on platform) </SWITCH> under <B>Group by</B> according to the specified columns.</HLPTEXT> <A name="end"></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_FORMATS"></A>Include formats</FONT></FONT></H3> <P><HLPTEXT>Check this box to include all formatting attributes when sorting.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_USERDEF"></A><A name="SC:LISTBOX:RID_SCPAGE_SUBT_OPTIONS:LB_USERDEF"></A>Custom sort order</FONT></FONT></H3> <P><HLPTEXT>Check here to use a selected custom sort order defined <SWITCH "System"><CASE "OS2">on the page</CASE>respectively <DEFAULT>in the tab</DEFAULT>(Depends on platform) </SWITCH> <B>Tools - Options - Custom Lists</B> . </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_SUBT_OPTIONS:BTN_ASCENDING"></A>Ascending</FONT></FONT></H3> <P><HLPTEXT>Sorts beginning with the lowest value, i.e. from A to Z or 0 to 9.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCPAGE_SUBT_OPTIONS:BTN_DESCENDING"></A>Descending</FONT></FONT></H3> <P><HLPTEXT>Sorts beginning with the highest value, i.e. from Z to A or 9 to 0.</HLPTEXT></P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_OPENDLG_TABOP"></A>Table</FONT></FONT></H1> <HR> <P><A name="Mehrfachoperationen"></A><HLPTEXT>In this dialog you can specify references to a previously defined sheet area.</HLPTEXT> With a multiple operation you can calculate different values for a cohesive data area defined by only one formula referenced to the area. This formula is located in a cell unconnected to the data area.<A name="ende"></A></P> <P><A href="Slot:26154" rel=ExecuteURL></A><A href="../00/00000412.htm#Dnmfo" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <P>:</P> <P>If the data of the area is arranged in a column or a row, select the data area. Under <B>Column/Row</B> enter the cell reference to the first cell in the data area. In the <B>Formula</B> field enter the reference to the cell containing the formula which refers to the data area. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_TABOP:RB_FORMULARANGE"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_TABOP:RB_ROWCELL"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_TABOP:RB_COLCELL"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><BR> </H3> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:RID_SCDLG_TABOP:ED_FORMULARANGE"></A>Formulas</FONT></FONT></H3> <P><HLPTEXT>Enter the cell reference containing the formula on which the data table is based.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:RID_SCDLG_TABOP:ED_ROWCELL"></A>Row input cell</FONT></FONT></H3> <P><HLPTEXT>Enter the input cell reference to be used as a variable for the rows in the data table.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:RID_SCDLG_TABOP:ED_COLCELL"></A>Column input cell</FONT></FONT></H3> <P><HLPTEXT>Enter the input cell reference to be used as a variable for the columns in the data table.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_OPENDLG_CONSOLIDATE"></A>Consolidate</FONT></FONT></H1> <HR> <P><A name="Konsolidieren"></A><HLPTEXT>With this function you can combine data from several independent table areas.</HLPTEXT> From these areas, a new area can be calculated with a chosen mathematical function.<A name="ende"></A></P> <P><A href="Slot:26150" rel=ExecuteURL></A><A href="../00/00000412.htm#Dnksd" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_CONSOLIDATE:LB_FUNC"></A>Function</FONT></FONT></H2> <P><HLPTEXT>In this list, select the mathematical function you want to use for the consolidation.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MULTILISTBOX:RID_SCDLG_CONSOLIDATE:LB_CONSAREAS"></A>Consolidation areas</FONT></FONT></H2> <P><HLPTEXT>In this list, the selected range of cells for the consolidation are displayed.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_CONSOLIDATE:LB_DATA_AREA"></A><A name="SC:EDIT:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA"></A>Source data area</FONT></FONT></H2> <P><HLPTEXT>Select any previously defined areas with names, and add them to the list of <B>Consolidation areas</B> . </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_CONSOLIDATE:RB_DATA_AREA"></A><A name="SC:IMAGEBUTTON:RID_SCDLG_CONSOLIDATE:RB_DEST_AREA"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <H3><BR> </H3> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:LISTBOX:RID_SCDLG_CONSOLIDATE:LB_DEST_AREA"></A><A name="SC:EDIT:RID_SCDLG_CONSOLIDATE:ED_DEST_AREA"></A>Copy results to</FONT></FONT></H2> <P><HLPTEXT>Here you can select the cell which will serve as the starting point of the data table.</HLPTEXT> The consolidation table will be inserted at this point. In the list field, you can select a predefined area, enter a cell reference directly, or select a cell with the mouse, if the cursor is positioned in the text field at the right.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_CONSOLIDATE:BTN_REMOVE"></A><A href="../../common/00/00000001.htm#Loeschen1" rel=Embedded></A></FONT></FONT></H2> <H2><BR> </H2> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:PUSHBUTTON:RID_SCDLG_CONSOLIDATE:BTN_ADD"></A>Add</FONT></FONT></H2> <P><HLPTEXT>Click here to add the reference specified in <B>Source data area</B> to the <B>Consolidation areas</B>. </HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MOREBUTTON:RID_SCDLG_CONSOLIDATE:BTN_MORE"></A>More >></FONT></FONT></H2> <P><HLPTEXT>Click here to expand the consolidation dialog to show the options Consolidate by.</HLPTEXT></P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Consolidate by</FONT></FONT></H1> <HR> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_BYROW"></A>Row labels</FONT></FONT></H3> <P><HLPTEXT>Check here to include row labels in the consolidation area.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_BYCOL"></A>Column headers</FONT></FONT></H3> <P><HLPTEXT>Check here to include column labels in the consolidation area.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_REFS"></A>Link to source data</FONT></FONT></H3> <P><HLPTEXT>Links the data in the consolidation area to the source data, and automatically updates the results of the consolidation if any changes are made to the original data.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>More <<</FONT></FONT></H2> <P>Click here to close the expanded options dialog.</P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_OUTLINE_HIDE"></A><A name="Detailausblenden"></A><A href="12080100.htm">Hide Detail</A></FONT></FONT></H1> <HR> <P>Click here to hide an outline level in a grouped sheet. </P> <P><A href="../00/00000412.htm#Dngda" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_OUTLINE_SHOW"></A><A name="Detaileinblenden"></A><A href="12080200.htm">Show Detail</A></FONT></FONT></H1> <HR> <P>Click here to display hidden sheet area.</P> <P><A href="../00/00000412.htm#Dngde" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SC:MODALDIALOG:RID_SCDLG_GROUP"></A><A name="SID_OUTLINE_MAKE"></A><A name="Gruppieren"></A><A href="12080300.htm">Group</A></FONT></FONT></H1> <HR> <P><A name="Gruppierung"></A><HLPTEXT>Click here to group a selected sheet area. </HLPTEXT></P> <P><A href="../00/00000412.htm#Dnglgr" rel=popup_end><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="HID_SC_GROUP_ROWS"></A>Rows</FONT></FONT></H3> <P><HLPTEXT>Combines selected rows to a group in an outline.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="HID_SC_GROUP_COLS"></A>Columns</FONT></FONT></H3> <P><HLPTEXT>Combines selected columns to a group in an outline.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_OUTLINE_REMOVE"></A><A name="GruppierungAufheben"></A><A href="12080400.htm">Ungroup</A></FONT></FONT></H1> <HR> <P><A NAME="END8"></A><A name="Gruppierungauf"></A>Clears the first level of the existing group inserted with the command <B>Group</B>.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_AUTO_OUTLINE"></A><A name="AutoGliederung"></A><A href="12080500.htm">Auto Outline</A></FONT></FONT></H1> <HR> <P>Click here to automatically group a selected range of cells in a sheet.</P> <P><A href="../00/00000412.htm#Dnglagl" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_OUTLINE_DELETEALL"></A><A name="Entfernen"></A><A href="12080600.htm">Clear Outline</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Click here to remove a grouping defined manually or with the <B>Auto Outline</B> function.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_OPENDLG_PIVOTTABLE"></A>DataPilot</FONT></FONT></H1> <HR> <P><A name="Datenpilot"></A><HLPTEXT>Use the DataPilot to help summarize and organize large amounts of data in three or more dimensions.</HLPTEXT><A name="ende"></A></P> <P><A href="../00/00000412.htm#Dndpa" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <P>Refer to the Advanced Tips section of the User's Guide for details on how to create a <A href="../../staruser/03020800.htm">DataPilot table</A> and analyze the resulting information.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Layout</FONT></FONT></H2> <P>Here you can define the structure of the table.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MOREBUTTON:RID_SCDLG_PIVOT_LAYOUT:BTN_MORE"></A><A href="12090102.htm">More>></A></FONT></FONT></H2> <P><HLPTEXT>Click this button to expand the dialog to display additional <B>Result</B> options. </HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Result</FONT></FONT></H1> <HR> <P>Customize how the results of the DataPilot are summarized.</P> <P><A href="../00/00000412.htm#Dndpaz" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Result</FONT></FONT></H2> <P>Define the settings for the result of the DataPilot table here.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCDLG_PIVOT_LAYOUT:LB_OUTAREA"></A><A name="SC:EDIT:RID_SCDLG_PIVOT_LAYOUT:ED_OUTAREA"></A>Results to</FONT></FONT></H3> <P><HLPTEXT>To prevent the results table from being positioned directly below the original data, select a defined area from the list box.</HLPTEXT> Then, select a sheet area with the mouse or enter a cell range directly.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:IMAGEBUTTON:RID_SCDLG_PIVOT_LAYOUT:RB_OUTAREA"></A><A href="../../common/00/00000001.htm#Eingabesymbol" rel=embedded></A></FONT></FONT></H3> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8% HEIGHT=32> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/HINWEIS.GIF" NAME="HIND_1" ALIGN=LEFT WIDTH=32 HEIGHT=32 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>If no results area is specified, the DataPilot table will appear directly below the source area, regardless if there is existing data there. </TD> </TR> </THEAD> </TABLE> <P><BR> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_IGNEMPTYROWS"></A>Ignore empty rows</FONT></FONT></H3> <P><HLPTEXT>If this option is selected, all empty cells in the original table will be ignored.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_DETECTCAT"></A>Identify categories</FONT></FONT></H3> <P><HLPTEXT>If you choose this option, StarOffice automatically orders rows without labels to the next higher category specified by a row label.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALCOL"></A>Total columns</FONT></FONT></H3> <P><HLPTEXT>Select this check box if you want the grand total of the columns to be displayed.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALROW"></A>Total rows</FONT></FONT></H3> <P><HLPTEXT>Select this check box if you want the grand total of the rows to be displayed.</HLPTEXT></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>More<<</FONT></FONT></H2> <P>Click here to close the expanded options dialog.</P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6>Filter</FONT></FONT></H1> <HR> <P>In this dialog you can define conditions for filtering data in a sheet or table.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Criteria</FONT></FONT></H2> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_OP1"></A><A name="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_OP2"></A>Operator</FONT></FONT></H3> <P><HLPTEXT>Choose between the logical operators AND/OR.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_FIELD1"></A><A name="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_FIELD2"></A><A name="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_FIELD3"></A>Field name</FONT></FONT></H3> <P><HLPTEXT>From the list box, select the field name from the current sheet to be used in the filter.</HLPTEXT> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_COND1"></A><A name="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_COND2"></A><A name="SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_COND3"></A>Condition</FONT></FONT></H3> <P><HLPTEXT>Choose a comparative operator to link the entries in <B>Field name</B> and <B>Value</B>. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:COMBOBOX:RID_SCDLG_PIVOTFILTER:ED_VAL1"></A><A name="SC:COMBOBOX:RID_SCDLG_PIVOTFILTER:ED_VAL2"></A><A name="SC:COMBOBOX:RID_SCDLG_PIVOTFILTER:ED_VAL3"></A>Value</FONT></FONT></H3> <P><HLPTEXT>This list box contains all possible values for the specified <B>field name</B> .</HLPTEXT> </P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:MOREBUTTON:RID_SCDLG_PIVOTFILTER:BTN_MORE"></A><A href="12090104.htm">More>></A></FONT></FONT></H2> <P><A href="12090104.htm#ZusaetzeText" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="Zusaetze"></A><A href="12090104.htm">Options</A></FONT></FONT></H1> <HR> <P><BR> </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_PIVOTFILTER:BTN_CASE"></A>Case sensitive</FONT></FONT></H3> <P>Choose this option to differentiate between upper and lower case text in a filtered list of values.</P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_PIVOTFILTER:BTN_REGEXP"></A>Regular Expression</FONT></FONT></H3> <P>Check this box if you want to use wildcards in the filter. </P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:CHECKBOX:RID_SCDLG_PIVOTFILTER:BTN_UNIQUE"></A>Unique records only</FONT></FONT></H3> <P>Check here to exclude duplicate rows in the list of filtered data. </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SC_PIVOTSUBT"></A>Data field</FONT></FONT></H1> <HR> <H2><FONT FACE="Times New Roman"><FONT SIZE=4>Subtotals</FONT></FONT></H2> <P><HLPTEXT>Define the type of subtotals to calculate.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_NONE"></A>None</FONT></FONT></H3> <P><HLPTEXT>The default setting does not calculate any subtotals.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_AUTO"></A>Automatic</FONT></FONT></H3> <P><HLPTEXT>Choose this option to automatically calculate subtotals.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_USER"></A>User-defined</FONT></FONT></H3> <P><HLPTEXT>Select this option if you want to define the type of subtotals to be calculated. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:MULTILISTBOX:RID_SCDLG_PIVOTSUBT:LB_FUNC"></A>Function</FONT></FONT></H3> <P><HLPTEXT>Click a function in this box to specify the type of subtotals to be calculated. </HLPTEXT></P> <P>Here you will find the name of the button in the DataPilot area <B>Column</B>, <B>Row</B> or <B>Data</B> for which the subtotals are defined. </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_PIVOT_RECALC"></A><A name="Aktualisieren"></A><A href="12090200.htm">Refresh</A></FONT></FONT></H1> <HR> <P>Click here to update a table created with the DataPilot.</P> <P><A href="../00/00000412.htm#Dndpak" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_PIVOT_KILL"></A><A name="Loeschen"></A><A href="12090300.htm">Delete</A></FONT></FONT></H1> <HR> <P>Click here to delete the DataPilot table.</P> <P><A href="../00/00000412.htm#Dndploe" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_REIMPORT_DATA"></A><A name="SID_REFRESH_DBAREA"></A><A name="Datenaktualisieren"></A><A href="12100000.htm">Refresh Area</A></FONT></FONT></H1> <HR> <P><A name="Aktualisieren"></A>Updates data inserted from an external database.</P> <P><A href="../00/00000412.htm#Dndakt" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="FID_VALIDATION"></A>Validity</FONT></FONT></H1> <HR> <P><A NAME="END13"></A><A name="Gueltigkeit"></A>In this dialog you can define various validity criteria for a selected sheet area.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SC:TABPAGE:TP_VALIDATION_VALUES"></A><A name="Werte"></A><A href="12120100.htm">Values</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Define which values to accept for the validity criteria.</HLPTEXT><A name="ende"></A></P> <P><A href="../00/00000412.htm#DatenGueltigWerte" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:TP_VALIDATION_VALUES:LB_ALLOW"></A>Allow</FONT></FONT></H3> <P><HLPTEXT>Define the validity condition for cell data. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:TRISTATEBOX:TP_VALIDATION_VALUES:TSB_ALLOW_BLANKS"></A>Ignore blanks</FONT></FONT></H3> <P><HLPTEXT>Click here to allow blank cells in the selected cell area; otherwise each cell must contain a value.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:TP_VALIDATION_VALUES:LB_VALUE"></A>Data</FONT></FONT></H3> <P><HLPTEXT>In this list, choose a comparitive operator to use as a condition. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:TP_VALIDATION_VALUES:EDT_MIN"></A>Minimum</FONT></FONT></H3> <P><HLPTEXT>Enter a minimum value here.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:TP_VALIDATION_VALUES:EDT_MAX"></A>Maximum</FONT></FONT></H3> <P><HLPTEXT>Enter a maximum value here.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SC:TABPAGE:TP_VALIDATION_INPUTHELP"></A><A name="Eingabehilfe"></A><A href="12120200.htm">Input help</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Define an input message to appear when a cell is selected.</HLPTEXT></P> <P><A href="../00/00000412.htm#DatenGueltigEingabe" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:TRISTATEBOX:TP_VALIDATION_INPUTHELP:TSB_HELP"></A>Show input help when cell is selected</FONT></FONT></H2> <P><HLPTEXT>Select this option to display a message defined under <B>Contents</B> as soon as a cell in the worksheet is selected. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:TP_VALIDATION_INPUTHELP:EDT_TITLE"></A>Title</FONT></FONT></H3> <P><HLPTEXT>Enter a title for the input message.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:MULTILINEEDIT:TP_VALIDATION_INPUTHELP:EDT_INPUTHELP"></A>Input help</FONT></FONT></H3> <P><HLPTEXT>Enter the text of the input message to be displayed under the title.</HLPTEXT> </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SC:TABPAGE:TP_VALIDATION_ERROR"></A><A name="Fehlermeldung"></A><A href="12120300.htm">Error Alert</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Define an error message to be displayed when invalid values are entered.</HLPTEXT></P> <P><A href="../00/00000412.htm#DatenGueltigFehler" rel=popup><A href="../00/00000004.htm#Wie" rel=embedded></A></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A name="SC:TRISTATEBOX:TP_VALIDATION_ERROR:TSB_SHOW"></A>Show error message when invalid values are entered.</FONT></FONT></H2> <P><HLPTEXT>Select this check box if you want an error message to be displayed when invalid values are entered. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:LISTBOX:TP_VALIDATION_ERROR:LB_ACTION"></A>Action</FONT></FONT></H3> <P><HLPTEXT>Choose the type of error dialog to display, or a predefined macro to be executed. </HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:PUSHBUTTON:TP_VALIDATION_ERROR:BTN_SEARCH"></A>Browse...</FONT></FONT></H3> <P><HLPTEXT>Click here to open the Macro dialog, where you can choose the macro to be executed after an error message.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:EDIT:TP_VALIDATION_ERROR:EDT_TITLE"></A>Title</FONT></FONT></H3> <P><HLPTEXT>Enter the name of the macro to be executed or the title of the dialog you want to display.</HLPTEXT></P> <H3><FONT FACE="Times New Roman"><FONT SIZE=3><A name="SC:MULTILINEEDIT:TP_VALIDATION_ERROR:EDT_ERROR"></A>Error message</FONT></FONT></H3> <P><HLPTEXT>Enter the text to display in case of an error.</HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_NUMBER_CURRENCY"></A><A name="Waehrung"></A><A href="02130000.htm">Currency</A></FONT></FONT></H1> <HR> <P><A NAME="END8"></A>Click here to display cell contents in currency format.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_NUMBER_PERCENT"></A><A name="Prozent"></A><A href="02140000.htm">Percentage</A></FONT></FONT></H1> <HR> <P><A NAME="END8"></A>Click here to display cell contents in percentage format.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_NUMBER_STANDARD"></A><A name="Standard"></A><A href="02150000.htm">Default Number Format</A></FONT></FONT></H1> <HR> <P><A NAME="END8"></A>Click here to display cell contents in the default number format.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_NUMBER_INCDEC"></A><A name="Dezimalhin"></A><A href="02160000.htm">Increase Decimal</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Click here to add a decimal place to a number in the selected cell(s).<HLPTEXT><A name="ende"></A></HLPTEXT></P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_NUMBER_DECDEC"></A><A name="Dezimalweg"></A><A href="02170000.htm">Decrease Decimal</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>Click here to delete the final decimal place of a number in the selected cell(s). The display will be updated to reflect the rounded number.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_INSWIN_POS"></A><A name="Tabellenbereich"></A><A href="06010000.htm">Sheet Area</A></FONT></FONT></H1> <HR> <P><A NAME="END7"></A>The reference of the active cell or selected cell area is displayed in the sheet area. If you select an area for which a name has been defined, the area name is displayed here.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <P><A name="ende"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_INSWIN_SUMME"></A><A name="Summe"></A><A href="06030000.htm">Sum</A></FONT></FONT></H1> <HR> <P><HLPTEXT>Click here to activate the sum function. First, place the cursor in the cell where you want the result of the formula to be inserted.<A name="ende"></A></HLPTEXT></P> <P><BR> </P> <P><BR> </P> <P><A name="ende"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_INSWIN_FUNC"></A><A name="Funktion"></A><A href="06040000.htm">Function</A></FONT></FONT></H1> <HR> <P>Click here to insert a formula.</P> <P><A name="SyFunktion"></A></P> <TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0> <COL WIDTH=21*> <COL WIDTH=235*> <THEAD> <TR VALIGN=TOP> <TD WIDTH=8%> <P> <IMG SRC="../../../PICTURE/WIN/COMMON/SYMBOLS/FUNCTION.GIF" NAME="Grafik2" ALIGN=LEFT WIDTH=23 HEIGHT=22 BORDER=0> <BR> </TD> <TD WIDTH=92%> <P>Function </TD> </TR> </THEAD> </TABLE> <P><A name="ende"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_INSWIN_INPUT"></A><A name="Eingabezeile"></A><A href="06050000.htm">Input Line</A></FONT></FONT></H1> <HR> <P><A NAME="END12"></A><A NAME="END13"></A>Enter a formula directly in this section of the Formula bar. You can enter a formula consisting of numbers or text, or create a formula with the aid of the Function AutoPilot. (Of course, you can also enter values and formulas directly into a cell, even if no cursor is visible.)<HLPTEXT><A name="ende"></A></HLPTEXT></P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_INSWIN_CANCEL"></A><A name="Verwerfen"></A><A href="06060000.htm">Cancel</A></FONT></FONT></H1> <HR> <P>Click here to cancel the changes to the cell contents.</P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_INSWIN_OK"></A><A name="Uebernehmen"></A><A href="06070000.htm">Accept</A></FONT></FONT></H1> <HR> <P>Click here to accept the contents of the formula bar and insert it into the work area.</P> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_STATUS_DOCPOS"></A><A name="PositionimDokument"></A><A href="08010000.htm">Document Position</A></FONT></FONT></H1> <HR> <P><A NAME="END5"></A>The number of the active sheet and the total number of worksheets in the document is displayed here.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <P><BR> </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_TABLE_CELL"></A><A name="DatumZeit"></A><A href="08080000.htm">Standard Formula, Date/Time, Error Warning</A></FONT></FONT></H1> <HR> <P><A NAME="END6"></A><A NAME="END7"></A>The field at the right of the status bar displays information about the current document. Normally, the standard formula SUM appears. The standard formula SUM allows you to always see the sum of the selected cells. If an error occurred in the current cell, the error code appears here, as soon as the cell is selected.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_PREVIEW_ZOOMIN"></A><A name="MassstabVergroessern"></A><A href="10050000.htm">Increase Scale</A></FONT></FONT></H1> <HR> <P>Click here to increase the scale of the page view.</P> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_PREVIEW_ZOOMOUT"></A><A name="MassstabVerkleinern"></A><A href="10060000.htm">Reduce Scale</A></FONT></FONT></H1> <HR> <P>Click here to reduce the scale of the page view. </P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_TBXCTL_INSERT"></A><A name="Einfuegen"></A><A href="18010000.htm">Insert</A></FONT></FONT></H1> <HR> <P><A NAME="END13"></A>Click here to open a floating toolbar to insert pictures and special characters.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <P><A name="end"></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="SID_TBXCTL_INSCELLS"></A><A name="ZellenEinfuegen"></A><A href="18020000.htm">Insert Cell</A></FONT></FONT></H1> <HR> <P><A NAME="END18"></A>Click here to open a floating toolbar to insert cells, rows and columns.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SC_TOOLBOX_TABLE"></A><A name="ImNormalmodus"></A><A href="main0202.htm">Spreadsheet Object Bar</A></FONT></FONT></H1> <HR> <P><A NAME="END61"></A><A NAME="END62"></A>The Spreadsheet object bar provides most of the functions for hard formatting, without the use of styles. Use the <B>Format - Standard command to remove hard formatting from the selected cells.<HLPTEXT><A name="ende"></A></HLPTEXT></B></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SC_TOOLBOX_DRAW"></A><A name="BeiSelektiertemObjekt"></A><A href="main0203.htm">Object bar when an object is selected</A></FONT></FONT></H1> <HR> <P>The object bar includes the most important functions for formatting and aligning selected objects.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/01/05270000.htm#Punktebearbeiten" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/00/00040502.htm#SyPunkteBearbeiten" rel=Embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/01/05200000.htm#Linie" rel=embedded></A></FONT></FONT></H2> <P><A href="../common/01/05200000.htm#LinieText" rel=embedded></A></P> <P><A href="../common/00/00040502.htm#SyLinie" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/02/05020000.htm#Linienendenstil" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/02/05020000.htm#SyLinienendenstil" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/01/05210000.htm#Flaeche" rel=embedded></A></FONT></FONT></H2> <P><A href="../common/01/05210000.htm#FlaecheText" rel=embedded></A></P> <P><A href="../common/00/00040502.htm#SyFlaeche" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/02/05090000.htm#Drehen" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/02/05090000.htm#SyDrehen" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/02/03200000.htm#Verankerung" rel=Embedded></A></FONT></FONT></H2> <P><A href="../common/02/03200000.htm#VerankerungText" rel=Embedded></A></P> <P><A href="../common/00/00040501.htm#Ankcalc" rel=Embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/01/05250100.htm#Ganznachvorn" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/00/00040501.htm#SyGanznachvorn" rel=Embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/01/05250400.htm#Ganznachhinten" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/00/00040501.htm#SyGanznachhinten" rel=Embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/01/05250500.htm#IndenVordergrund" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/00/00040501.htm#SyVordergrund" rel=Embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/01/05250600.htm#IndenHintergrund" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/00/00040501.htm#SyHintergrund" rel=Embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/02/05110000.htm#Ausrichten" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/02/05110000.htm#SyAusrichten" rel=embedded></A></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SC_TOOLBOX_DRTEXT"></A><A name="BeiTextcursorinObjekt"></A><A href="main0205.htm">Object bar with text cursor in an object</A></FONT></FONT></H1> <HR> <P>This object bar displays the icons for formatting text, if the cursor is positioned in an inserted text frame.</P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/02/02020000.htm#Schriftart" rel=embedded></A></FONT></FONT></H2> <P><A href="../common/02/02020000.htm#SchriftartText" rel=embedded></A></P> <P><A href="../common/02/02020000.htm#SySchriftart" rel=Embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/02/02030000.htm#Schriftgroesse" rel=embedded></A></FONT></FONT></H2> <P><A href="../common/02/02030000.htm#SchriftgroesseText" rel=embedded></A></P> <P><A href="../common/02/02030000.htm#SySchriftgroesse" rel=Embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/01/05110100.htm#Fett" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/00/00040502.htm#SyFett" rel=Embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/01/05110200.htm#Kursiv" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/00/00040502.htm#SyKursiv" rel=embedded></A></P> <H2><FONT FACE="Times New Roman"><FONT SIZE=4><A href="../common/01/05110300.htm#Unter" rel=embedded></A></FONT></FONT></H2> <H2><BR> </H2> <P><A href="../common/00/00040502.htm#SyUnterstreichen" rel=embedded></A></P> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SC_INPUTWIN"></A><A name="Rechenleiste"></A><A href="main0206.htm">Formula Bar</A></FONT></FONT></H1> <HR> <P><A NAME="END20"></A>Enter calculation formulas in this toolbar.<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <BODY BGCOLOR="#ffffff"> <H1><FONT FACE="Times New Roman"><FONT SIZE=6><A name="HID_SC_TOOLBOX_PREVIEW"></A><A name="Seitenansichtleiste"></A><A href="main0210.htm">Page View Object Bar</A></FONT></FONT></H1> <HR> <P><A NAME="END26"></A>The Page View bar contains icons relevant for the page view functions (accessible via the <B>Page View</B> command in the <SWITCH "System"><CASE "MAC"><B>File</B></CASE><DEFAULT><B>File</DEFAULT></SWITCH></B> menu).<HLPTEXT><A name="ende"></A></HLPTEXT></P> <HR> </BODY> </HTML>