Lines Matching refs:from
1698 …html</a> you will find a first overview where you can start with, ranging from Localization, QA, u…
4777 …_AREA_MTR_TRGR_CENTER_X 0 nb - Specify the horizontal offset percentage from the center for the …
4779 …EL_AREA_MTR_TRGR_CENTER_Y 0 nb - Specify the vertical offset percentage from the center for the …
13832 …rInterface.Commands..uno:ImportMathMLClipboard Label 0 nb Import MathML from Clipboard 202004…
14150 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-bottom Label 0 nb…
14151 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-left Label 0 nb F…
14152 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-right Label 0 nb …
14153 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-top Label 0 nb Ov…
14154 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-bottom-left Label …
14155 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-bottom-right Label …
14156 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-top-left Label 0 …
14157 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-top-right Label 0…
14163 …fice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.out-from-screen-center Label…
14164 …ffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.in-from-screen-center Label…
14182 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-bottom-right-horizo…
14183 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-bottom-right-vertic…
14184 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-center-clockwise La…
14185 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-center-counter-cloc…
14186 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-top-left-clockwise …
14187 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-top-left-horizontal…
14188 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-top-left-vertical L…
14189 …enoffice\Office\UI\Effects.xcu 0 value ..Effects.UserInterface.Properties.from-top-right-counter-c…
23277 …mouse so that a point lies on the straight line, it is removed. The angle from which the point red…
23456 …help par_id0810200902300479 0 nb \<ahelp hid=\".\"\>Select the element from the chart that you …
23497 …lower border of the document. The Drawing Bar shows a subset of the icons from the \<link href=\"t…
23833 …h/01/06020000.xhp#importclipboard\" name=\"Import MathML\"\>Import MathML from Clipboard\</link\> …
24019 …0301.xhp 0 help par_id3147288 14 0 nb iVar = Int((10 * Rnd) ) REM Range from 0 to 9 20200411 …
24047 …ey word is specified, a variable is defined as Single, unless a statement from DefBool to DefVar i…
24053 …p par_id3153950 23 0 nb DIM text(20) As String REM 21 elements numbered from 0 to 20 20200411…
24054 …_id3146912 24 0 nb DIM text(5 to 25) As String REM 21 elements numbered from 5 to 25 20200411…
24056 …xt\sbasic\shared\03102101.xhp 0 help par_id3150321 26 0 nb rem numbered from -15 to 5 2020041…
24089 …sbasic\shared\03120315.xhp 0 help par_id3149670 2 0 nb Returns a string from a number of substri…
24137 …t\sbasic\shared\03090404.xhp 0 help par_id3152887 19 0 nb Print "Number from 1 to 5" 20200411…
24139 …t\sbasic\shared\03090404.xhp 0 help par_id3148618 21 0 nb Print "Number from 6 to 8" 20200411…
24246 …ion that indicates the month of the specified year. The accepted range is from 1-12. 20200411 1…
24247 …sion that indicates the day of the specified month. The accepted range is from 1-31. No error is r…
24389 … an event occurs, the corresponding Listener calls the appropriate method from the com.sun.star.co…
24390 ….xhp 0 help par_id3148922 38 0 nb The prefix calls registered Listeners from Basic-subroutines. …
24542 …hp 0 help par_idN10656 0 nb \<emph\>Add\</emph\> - A string expression from the following table…
24587 …expressions returns the value True only if both expressions are different from each other. 2020…
24733 …document the library will be attached to this document and only available from there. 20200411 …
24738 …document the library will be appended to this document and only available from there. 20200411 …
24747 …30400.xhp 0 help par_id3158212 58 0 nb Select the library to be deleted from the list. 202004…
24766 … 0 help par_id3149870 30 0 nb Select the module or dialog to be deleted from the list. Double-cl…
24943 …r2:\</emph\> Name of the user-defined type variable that you want to copy from. 20200411 15:09:…
24972 helpcontent2 source\text\sbasic\shared\03020202.xhp 0 help par_id3156424 2 0 nb Reads data from a…
24977 …ar:\</emph\> A numeric or string variable that you assign the values read from the opened file to.…
24978 … nb The \<emph\>Input#\</emph\> statement reads numeric values or strings from an open file and as…
24980 …in the file are disregarded as well. If you want to read these characters from the file, use the \…
25290 …ressions, values to the left of the decimal represent the date, beginning from December 31, 1899. …
25319 …t\sbasic\shared\03020410.xhp 0 help par_id3151211 2 0 nb Deletes a file from a disk. 20200411…
25446 …ic\shared\03080101.xhp 0 help par_id3145750 17 0 nb REM the angle Alpha from the tangent of the …
25726 …ed\03080801.xhp 0 help par_id3149262 20 0 nb REM Returns a Long-Integer from a hexadecimal value…
25778 …he dialog libraries. To display a dialog, a "live" dialog must be created from the library. 202…
25783 …hared\03131800.xhp 0 help par_id3159157 8 0 nb ' Get dialog description from the dialog library …
25866 …9 0 nb If you use the Imp operator in bit expressions, a bit is deleted from the result if the c…
25902 …d\03090000.xhp 0 help par_id3156152 3 0 nb A program generally executes from the first line of c…
25925 … Declares and defines a subroutine in a DLL file that you want to execute from $[officename] Basic…
25930 …</emph\> A different name than defined in the DLL, to call the subroutine from $[officename] Basic…
25989 …03030206.xhp 0 help par_id3153361 2 0 nb Calculates a serial time value from the specified hour,…
26024 …>Number:\</emph\> A numeric expression that contains a serial date number from which you can deter…
26025 …y the opposite of the DateSerial function, returning the day of the month from a serial date numbe…
26058 …can use these functions to declare or define variables, convert variables from one type to another…
26109 …sbasic\shared\05060700.xhp 0 help par_id3155266 67 0 nb Text is entered from the keyboard. 20…
26112 …700.xhp 0 help par_id3151131 70 0 nb Nonprinting characters are entered from the keyboard, for e…
26171 …Mid function\</emph\> is omitted, all characters in the string expression from the start position …
26220 …r_id3153190 10 0 nb \<emph\>FileNumber:\</emph\> Any integer expression from 0 to 511 to indicat…
26249 …sbasic\shared\03030106.xhp 0 help par_id3149655 2 0 nb Returns the year from a serial date numbe…
26290 …t past the end of a file. When you use the Input or Get statement to read from a file, the file po…
26390 …xhp 0 help par_id3149177 2 0 nb Removes all leading and trailing spaces from a string expression…
26436 …ic\shared\03030102.xhp 0 help par_id3150542 2 0 nb Returns a date value from a date string. The …
26659 …ared\keys.xhp 0 help par_id3159254 5 0 nb Run code starting from the first line, or from the cur…
26673 …einline\>\<defaultinline\>Ctrl\</defaultinline\>\</switchinline\>+Q, also from outside of the Basi…
26744 …the newly written record and the next record is padded with existing data from the file that you a…
26795 …ry.Module.Macro()\</item\>\<br/\> For example, to call the Autotext macro from the Gimmicks librar…
26859 …03030107.xhp 0 help par_id3151097 2 0 nb Returns the date in ISO format from a serial date numbe…
26920 …4 6 0 nb The \<emph\>Switch\</emph\> function evaluates the expressions from left to right, and …
26990 …03120314.xhp 0 help par_id3155805 2 0 nb Returns an array of substrings from a string expression…
27078 …ariables with the same name and local variables with the same name coming from superordinate subs …
27081 …578 13 0 nb You can copy or move subs, functions, modules and libraries from one file to another…
27229 …sbasic\shared\03030201.xhp 0 help par_id3149346 2 0 nb Returns the hour from a time value that i…
27236 …l\</emph\> function. It returns an integer value that represents the hour from a time value that i…
27290 …hared\03090402.xhp 0 help par_id3149234 2 0 nb Returns a selected value from a list of arguments…
27296 …r_id3151043 8 0 nb The \<emph\>Choose\</emph\> function returns a value from the list of express…
27298 …wing example uses the \<emph\>Choose\</emph\> function to select a string from several strings tha…
27347 …re called automatically. If you want to call the global LibraryContainers from within a document, …
27386 …ed\03030104.xhp 0 help par_id3148550 2 0 nb Returns the month of a year from a serial date that …
27861 …ph\>deactivate\</emph\> a breakpoint by selecting \<emph\>Active\</emph\> from its context menu. W…
27862 … Select \<emph\>Properties\</emph\> from the context menu of a breakpoint or select \<emph\>Breakp…
27865 …d3153968 13 0 nb Click \<emph\>Delete\</emph\> to remove the breakpoint from the program. 202…
27877 …\03020413.xhp 0 help par_id3149457 2 0 nb Deletes an existing directory from a data medium. 2…
28016 …r_id3155930 43 0 nb \<ahelp hid=\".\"\>Select "Yes" to prevent the user from editing the value o…
28110 …mponent so that its properties can be read and set. ThisComponent is used from document Basic, whe…
28133 …8 14 0 nb The \<emph\>Rnd\</emph\> function only returns values ranging from 0 to 1. To generate…
28140 …t\sbasic\shared\03080302.xhp 0 help par_id3147124 21 0 nb Print "Number from 1 to 5" 20200411…
28142 …t\sbasic\shared\03080302.xhp 0 help par_id3154943 23 0 nb Print "Number from 6 to 8" 20200411…
28174 …uently uses the Any type. It is the counterpart of the Variant type known from other environments.…
28178 …PropertyValue( Name, Value ) or X???Container::insertBy???( ???, Value ), from $[officename] Basic…
28283 …030108.xhp 0 help par_id3148550 2 0 nb Returns the internal date number from a string that conta…
28366 …hp 0 help par_idN105F6 0 nb \<emph\>Add\</emph\> - A string expression from the following table…
28367 …03030130.xhp 0 help par_idN10604 0 nb \<emph\>Date\</emph\> - The date from which the result is…
28469 …shared\03030110.xhp 0 help par_idN10629 0 nb Add - A string expression from the following table…
28508 …xhp 0 help par_id3154760 2 0 nb The following functions convert numbers from one number format t…
28782 …basic\shared\01040000.xhp 0 help par_id3150431 32 0 nb Select the event from the \<emph\>Event\<…
28789 …129 59 0 nb Select the event that contains the assignment to be removed from the \<emph\>Event\<…
28843 …hared\01020100.xhp 0 help par_id3146966 41 0 nb Integer variables range from -32768 to 32767. If…
28847 …\01020100.xhp 0 help par_id3151193 46 0 nb Long integer variables range from -2147483648 to 2147…
28855 …0 51 0 nb Single variables can take positive or negative values ranging from 3.402823 x 10E38 to…
28859 …3 55 0 nb Double variables can take positive or negative values ranging from 1.79769313486232 x …
28863 …decimal number with 15 non-decimal and 4 decimal places. The values range from -922337203685477.58…
28885 …\shared\01020100.xhp 0 help par_id3154567 136 0 nb 21 elements numbered from 0 to 20 20200411…
28889 …\shared\01020100.xhp 0 help par_id3149690 138 0 nb 21 elements numbered from 5 to 25 20200411…
28891 …00.xhp 0 help par_id3153113 89 0 nb 21 elements (including 0), numbered from -15 to 5 2020041…
28983 …h\> Any string expression that you want to return the leftmost characters from. 20200411 15:09:…
29003 …elp par_id3159201 2 0 nb The following functions convert strings to and from ASCII or ANSI code.…
29030 …, variables are automatically defined as Variant Type, unless a statement from DefBool to DefVar i…
29034 …p par_id3154662 29 0 nb DIM text(20) as String REM 21 elements numbered from 0 to 20 20200411…
29035 …_id3155604 30 0 nb DIM text(5 to 25) as String REM 21 elements numbered from 5 to 25 20200411…
29037 …xt\sbasic\shared\03102100.xhp 0 help par_id3152774 32 0 nb REM numbered from -15 to 5 2020041…
29039 …M text(20,2) as String REM 63 elements; form 0 to 20 level 1, from 0 to 20 level 2 and from 0 to 2…
29065 …lp par_id3145316 2 0 nb Calls a subroutine that is indicated by a label from a subroutine or a f…
29079 …h\>GoSub\</emph\> statement calls a local subroutine indicated by a label from within a subroutine…
29183 …01.xhp 0 help par_id3145069 2 0 nb Reads a record from a relative file, or a sequence of bytes f…
29311 …Any integer expression that specifies the color value of the color passed from an older MS-DOS bas…
29329 ….xhp 0 help par_id3146914 26 0 nb This function is used only to convert from older MS-DOS based …
29340 …d Boolean operators are described in a separate section. Functions differ from operators in that f…
29422 …t\sbasic\shared\03090102.xhp 0 help par_id3152597 14 0 nb Print "Number from 1 to 5" 20200411…
29424 …t\sbasic\shared\03090102.xhp 0 help par_id3147349 16 0 nb Print "Number from 6 to 8" 20200411…
29457 …e Shift key, as well as cursor positioning functions (for example, moving from word to word with \…
29463 …sbasic\shared\01030200.xhp 0 help par_id3146120 7 0 nb Select a library from the \<emph\>Library…
29469 …par_id3150327 18 0 nb Select the module that you want to export as text from the object catalog.…
29473 …7343 22 0 nb Select the module where you want to import the source code from the object catalog.…
29481 …xt\sbasic\shared\03020203.xhp 0 help par_id3156280 2 0 nb Reads strings from a sequential file i…
29487 … nb With the \<emph\>Line Input#\</emph\> statement, you can read strings from an open file into a…
29609 …ample_code.xhp 0 help par_id3153247 131 0 nb REM remove the first entry from the ListBox 2020…
29639 … localizable strings in your dialogs, you can select the current language from the Current Languag…
29702 …b Add: The additional languages from the imported dialog will be added to the already existing dia…
30108 …A_HYPERLINK_SEARCH\"\>Click and choose one of the Internet search engines from the submenu. The se…
30463 … visibility=\"hidden\"\>Opens a dialog to add/edit/remove a database file from the list of registe…
30957 … 1 0 nb \<link href=\"text/shared/02/02050000.xhp\" name=\"Text running from top to bottom\"\>Te…
31031 …ied by an entered URL. You can type a new URL, edit an URL, or select one from the list. Displays …
31817 … 1 0 nb \<link href=\"text/shared/02/02040000.xhp\" name=\"Text running from left to right\"\>Te…
33039 …ahelp hid=\".\"\>Enter the image resolution. Select the measurement units from the list box.\</ahe…
33042 …2 0 nb \<ahelp hid=\".\" visibility=\"hidden\"\>Select the color depth from 8 bit grayscale or …
33043 …ility=\"hidden\"\>Sets the compression and quality for the export. Choose from a low quality with …
33056 … with the PostScript file. This format only contains printable characters from the 7-bit ASCII cod…
33433 …00005.xhp 0 help par_id3147287 35 0 nb You can remove direct formatting from your document by se…
34293 …b The wizard converts binary documents and templates from older versions, as well as documents fro…
34361 … nb \<ahelp hid=\"HID_LTRWIZ_OPTSENDERPLACEHOLDER\"\>Use the address data from %PRODUCTNAME - User…
35525 …data from text documents\</bookmark_value\>\<bookmark_value\>copying;data from text documents\</bo…
35538 …okmark_value\>opening; documents from other formats\</bookmark_value\> \<bookmark_value\>l…
35647 …ph\>Grayscale\</emph\> converts all colors to a maximum of 256 gradations from black to white. All…
35691 …nline\> - %PRODUCTNAME - Paths\</emph\> to be able to access the template from within the \<emph\>…
35829 …50439 30 0 nb For a detailed overview about converting documents to and from Microsoft Office fo…
35846 …ide\ms_import_export_limitations.xhp 0 help par_idN10B0D 0 nb Starting from OpenOffice.org 3.2 …
36089 …"picture.gif": "images\\picture.gif". This is the relative path, starting from the location of the…
36256 …_id3148473 4 0 nb If you want to open up draw objects from the center instead of dragging from o…
36274 …hapes. Using the 3D Settings toolbar, you can switch the view at any time from 2D to 3D and back. …
36326 …At present there are three ways of entering letters with accents directly from the keyboard.\</cas…
36502 …from all printable fonts. In an HTML document or in Web layout, only fonts that are visible on scr…
36561 …ustomize - Toolbars\</emph\>, click \<emph\>Add Commands\</emph\> and add from "Documents" the \<e…
36607 …xt\shared\guide\scripting.xhp 0 help par_idN10ABD 0 nb Select an event from the list and click …
36615 …xt\shared\guide\scripting.xhp 0 help par_idN10AF7 0 nb Select an event from the list and click …
37759 …igitalsign_send.xhp 0 help par_idN10640 0 nb You can get a certificate from a certification aut…
37811 … 0 nb You can download documentation as PDF files, how-tos, and guides from the %PRODUCTNAME we…
37972 …y a comment permanently, select the \<emph\>Show comment\</emph\> command from the cell's context …
38296 …when a document contains one or more macros. You can also call the dialog from the \<emph\>\<switc…
38299 … formula documents. These options apply when you print a formula directly from \<item type=\"produ…
38563 … with double-sided printing capability, you can create an entire brochure from your document witho…
38574 …GE:CB_PAPERFROMSETUP\"\>For printers with multiple trays, the "Paper tray from printer settings" o…
38669 …ents created with %PRODUCTNAME %PRODUCTVERSION and for documents imported from Microsoft Word form…
39138 …0667 0 nb \<ahelp hid=\"703988743\"\>Select to always remove user data from the file properties…
39532 …_RID_SFXPAGE_SAVE_BTN_ODFENCRYPTION\"\>Change the default file encryption from blowfish to AES-256…
39646 …MENU_ICONS\"\>Displays icons next to the corresponding menu items. Select from "Automatic", "Hide"…
39662 …r transparent selections. The default value is 75%. You can select values from 10% to 90%.\</ahelp…
39759 …\>In the right half of the preview field, you will see the original color from the parent tab, \<e…
39833 …SVXPAGE_PARA_ASIAN_CB_AS_FORBIDDEN\"\>Prevents the characters in the list from starting or ending …
40261 …ar_idN10557 0 nb \<ahelp hid=\".\"\>Converts the selected Chinese text from one Chinese writing…
40606 …select=\"appl\"\>\<caseinline select=\"WRITER\"\>Removes empty paragraphs from the current documen…
40840 …566 0 nb You can use this dialog to edit, to add, or to delete entries from the conversion dict…
41120 …no:HangulHanjaConversion\"\>Converts the selected Korean text from Hangul to Hanja or from Hanja t…
41465 …3156193 98 0 nb When closing a document, remove the words collected from it from the list 202…
41475 …session, disable "When closing a document, remove the words collected from it from the list".\</ah…
41893 …ODUCTNAME\</item\> recognizes templates that are located in any directory from the following list:…
42022 …e thesaurus.\</ahelp\> You can install languages with a thesaurus library from the \<link href=\"h…
42085 …me that you want the linked file to open in, or select a predefined frame from the list.\</ahelp\>…
42165 …nb \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Searches from top to bottom throu…
42423 …id=\".\"\>Choose a command to delete the current comment, or all comments from the same author as …
42427 helpcontent2 source\text\shared\01\04050000.xhp 0 help hd_id3445539 0 nb Navigating from comment…
42429 …also use the small Navigation window below the vertical scrollbar to jump from one comment anchor …
42504 …_id317748820 0 nb The dialog box has reduced functionality when called from the Edit-Sheet menu…
43181 …02180000.xhp 0 help par_idN1099856 0 nb When you open a file by an URL from the Windows file di…
43873 … enter a value here. If this value is zero, the paper width is calculated from the width of the la…
43876 …e. If this value is zero for sheet format, the paper height is calculated from the height of the l…
44353 …es the Java Media Framework API (JMF). Download and install the JMF files from http://java.sun.com…
44425 …> Some PDF tools or %PRODUCTNAME extensions may allow to extract the file from the PDF and save it…
44997 …e to show the license text again. You can choose to exclude the extension from checking for update…
45124 … hid=\".\" visibility=\"hidden\"\>\<emph\>Overlines or removes overlining from the selected text. …
45271 … Base file itself. This means that macros in Base files can be called now from any of its sub-comp…
45717 …\database\02010100.xhp 0 help par_id3150661 269 0 nb Eksempel: select * from Element where Eleme…
45720 …se\02010100.xhp 0 help par_id3156052 272 0 nb Example: select Article.* from {oj item LEFT OUTER…
45741 …100.xhp 0 help par_id3149539 267 0 nb Eksempel: select {d '1999-12-31'} from verden.år 202004…
45742 …t\shared\explorer\database\02010100.xhp 0 help 0 nb Example: select * from mytable where years…
45768 …d\explorer\database\02010100.xhp 0 help par_id3156731 275 0 nb select * from 'adresser' where 'n…
46075 …re details. The Adabas database must be installed in a separate directory from $[officename]. 2…
46450 …found on your system, open your web browser and download the JRE software from \<link href=\"http:…
47095 …03 0 nb \<variable id=\"etsmim\"\>Choose \<emph\>Tools - Import MathML from Clipboard\</emph\>\…
47157 helpcontent2 source\text\smath\guide\limits.xhp 0 help par_id9004486 0 nb int from{a} to{b} f(x)…
47768 …06020000.xhp 0 help bm_id3154660 0 nb \<bookmark_value\>MathML; import from file\</bookmark_val…
47769 helpcontent2 source\text\smath\01\06020000.xhp 0 help hd_id3154659 0 nb Import Formula from File…
47775 helpcontent2 source\text\smath\01\06020000.xhp 0 help hd_id3154661 0 nb Import MathML from Clipb…
48249 …egral og sum med en plassholder.\</ahelp\> Du kan også skrive inn \<emph\>from{<?>} to{<?>} <?>\</…
48261 …ntegral og sum med plassholdere.\</ahelp\> Du kan også skrive inn \<emph\>from {<?>}<?>\</emph\> d…
48277 …emph\> brukes i kombinasjon med grenser, for eksempel \<emph\>oper %union from {i=1} to n x_{i}\</…
48665 …id3145802 2 0 nb \<ahelp hid=\"HID_SMA_ATTRIBUTES_CAT\"\>You can choose from various attributes …
49666 …d opens dialogs that you can also open by choosing the following commands from the \<emph\>Format\…
49883 …ger object that you have not closed yet, the smaller object is subtracted from the larger one, thu…
51062 …0 nb The Status bar displays "3D scene selected". The 3D scenes are built from objects which have …
51063 …om Shapes. Custom Shapes in 2D or 3D mode can be exported to and imported from Microsoft Office fo…
51124 …ab page of the \<emph\>Print\</emph\> dialog, select the "Handouts" entry from the Document listbo…
51190 …uide\show.xhp 0 help par_id4199957 0 nb If you want all shows to start from the current slide i…
51501 …hid=\"sdext:Minimizer:Wizard:Step3:CBCrop\"\>Delete cropped graphic areas from the graphics.\</ahe…
51550 …choose \<emph\>Edit - Paste Special \</emph\>and select the bitmap format from the list. 202004…
53313 …laces. If you now select the subordinate currency format "$ English (US)" from the \<item type=\"m…
53353 … 0 help par_id3153192 0 nb You can use filters to remove unwanted data from a pivot table. 2…
53356 …ld member name. When a field has an alternative display name that differs from its original name, …
53455 …/export\</bookmark_value\> \<bookmark_value\>spreadsheets; importing from/exporting to dBASE …
53537 …help par_id5775322 0 nb Click the second \<emph\>Default\</emph\> icon from the left to set all…
53610 …xt/scalc/guide/cell_protect.xhp\" name=\"Protecting Cells from Changes\"\>Protecting Cells from Ch…
53617 …at you want. All options will be applied only after you protect the sheet from the Tools menu - se…
53620 …0 nb Select \<emph\>Hide formula\</emph\> to hide and to protect formulas from changes. 2020041…
53624 …c\guide\cell_protect.xhp 0 help par_idN106C0 0 nb To protect the cells from being changed / vie…
53688 …b You can select a named range in which the pivot table is to be created, from the \<emph\>Results…
53698 …og, you can see the name of all the sheets or named ranges you can choose from. 20200411 15:09:…
53717 …/emph\> from the context menu of the cell. Doing so keeps the comment visible until you deactivate…
53720 …olor, transparency, border style, and text alignment. Choose the commands from the context menu of…
53752 …/switchinline\>key. The sheet that is currently visible cannot be removed from the selection. 2…
53814 …hp 0 help par_id3150305 15 0 nb A mouse click marks a rectangular range from the current cell to…
53844 …or ="1E2"+1. Cell range arguments are not affected, so SUM(A1:A2) differs from A1+A2 if at least o…
53881 …questions. In your spreadsheet, you enter a formula to calculate a result from values that are sto…
53917 …ated Values (CSV) is a text file format that you can use to exchange data from a database or a spr…
54011 …datapilot_edittable.xhp 0 help par_id3147434 29 0 nb To remove a button from the table, just dra…
54026 … Specify where you want to display the result by selecting a target range from the \<emph\>Copy re…
54028 …lc\guide\consolidate.xhp 0 help par_id3153813 14 0 nb Select a function from the \<emph\>Functio…
54087 …d3156444 17 0 nb With the help of the Navigator you can reference cells from one sheet to anothe…
54134 …ape.xhp 0 help par_id5538804 0 nb From all the paper pages that result from the above selection…
54136 …</emph\> - Enter the pages to be printed. The pages will also be numbered from the first sheet onw…
54161 …8 0 nb In the Styles and Formatting window, click the \<emph\>New Style from Selection\</emph\> …
54419 … Choose \<emph\>Format - Cells\</emph\> (or \<emph\>Format Cells\</emph\> from the context menu). …
54836 helpcontent2 source\text\scalc\01\04050100.xhp 0 help tit 0 nb Sheet from file 20200411 15:09…
54837 …lp par_idN105C1 0 nb \<link href=\"text/scalc/01/04050100.xhp\"\>Sheet from file\</link\> 20…
54838 …00.xhp 0 help par_idN105D1 0 nb \<ahelp hid=\"26275\"\>Inserts a sheet from a different spreads…
54901 …lp par_id8751792 0 nb The example returns 6. The formula is calculated from left to right as: 1…
55176 …inks\</emph\> to see the updated links. Cross-platform links, for example from a \<item type=\"pro…
55186 helpcontent2 source\text\scalc\01\04060109.xhp 0 help par_id3145596 188 0 nb Number format from t…
55213 … \<item type=\"input\"\>=INDEX(Prices;4;1)\</item\> returns the value from row 4 and column 1 …
55214 … \<item type=\"input\"\>=INDEX(SumX;4;1)\</item\> returns the value from the range \<emph\>S…
55299 …eturns the value of a cell offset by a certain number of rows and columns from a given reference p…
55302 …152360 115 0 nb \<emph\>Reference\</emph\> is the reference from which the function …
55344 …143 0 nb \<ahelp hid=\"HID_FUNC_WAHL\"\>Uses an index to return a value from a list of up to 30 …
55347 …eference or number between 1 and 30 indicating which value is to be taken from the list. 202004…
55400 … 0 nb \<ahelp hid=\".\"\>The GETPIVOTDATA function returns a result value from a pivot table. The …
55409 …Field n\</emph\> is the name of a field from the pivot table. \<emph\>Item n\</emph\> is the name …
55413 helpcontent2 source\text\scalc\01\04060109.xhp 0 help par_id3864253 0 nb Subtotal values from th…
55575 …variable\> Before you start the Wizard, select a cell or a range of cells from the current sheet, …
55576 …an download the complete ODFF (OpenDocument Format Formula) specification from the \<link href=\"h…
55603 …1\04060000.xhp 0 help par_id3146966 56 0 nb To select a single function from a complex formula c…
55643 …lp hid=\"SC:RADIOBUTTON:RID_SCPAGE_TABLE:BTN_TOPDOWN\"\>Prints vertically from the left column to …
55645 …id=\"SC:RADIOBUTTON:RID_SCPAGE_TABLE:BTN_LEFTRIGHT\"\>Prints horizontally from the top row of the …
55652 …p hid=\"sc:ListBox:RID_SCPAGE_TABLE:LB_SCALEMODE\"\>Select a scaling mode from the list box. Appro…
55716 helpcontent2 source\text\scalc\01\12090105.xhp 0 help par_idN1073E 0 nb Difference from 20200…
55723 …lue. The reference value is determined in the same way as for "Difference from". Totals outside of…
55724 helpcontent2 source\text\scalc\01\12090105.xhp 0 help par_idN1076A 0 nb % Difference from 202…
55739 … 0 help par_idN107BE 0 nb \<ahelp hid=\"1495371267\"\>Select the field from which the respectiv…
55741 …7C5 0 nb \<ahelp hid=\"1495371268\"\>Select the item of the base field from which the respectiv…
55815 …hid=\"HID_FUNC_BW\"\>Returns the present value of an investment resulting from a series of regular…
55958 …duced with every depreciation period by the depreciation already deducted from the initial cost. …
56016 …emph\> button to enter another name for an already existing name selected from the list.\</ahelp\>…
56130 …b \<ahelp hid=\"HID_FUNC_CHITEST\"\>Returns the probability of a deviance from a random distributi…
56160 …from the indicated Chi square that a hypothesis is confirmed.\</ahelp\> CHIDIST compares the Chi s…
56316 …0949 18 0 nb Select a square range within the spreadsheet, for example, from A1 to E5. 202004…
56495 helpcontent2 source\text\scalc\01\04060107.xhp 0 help par_id3145894 145 0 nb E5: The F value from…
56496 …1\04060107.xhp 0 help par_id3145915 146 0 nb F5: The degrees of freedom from the variance analys…
56497 …147 0 nb E6: The sum of the squared deviation of the estimated Y values from their linear mean. …
56498 … 148 0 nb F6: The sum of the squared deviation of the estimated Y value from the given Y values.…
56581 …rray\</emph\> field. click \<emph\>OK\</emph\>. The trend data calculated from the output data is …
56609 helpcontent2 source\text\scalc\01\04070300.xhp 0 help hd_id3151116 3 0 nb Create names from 20…
56612 …d=\"SC:CHECKBOX:RID_SCDLG_NAMES_CREATE:BTN_TOP\"\>Creates the range names from the header row of t…
56614 …=\"SC:CHECKBOX:RID_SCDLG_NAMES_CREATE:BTN_LEFT\"\>Creates the range names from the entries in the …
56616 …"SC:CHECKBOX:RID_SCDLG_NAMES_CREATE:BTN_BOTTOM\"\>Creates the range names from the entries in the …
56618 …\"SC:CHECKBOX:RID_SCDLG_NAMES_CREATE:BTN_RIGHT\"\>Creates the range names from the entries in the …
56638 …or the database range that you want to define, or select an existing name from the list.\</ahelp\>…
56651 …hp 0 help par_id3153885 244 0 nb \<emph\>StartDate\</emph\> is the date from when the calculatio…
56664 …frac.xhp 0 help par_id3149954 201 0 nb \<emph\>Basis\</emph\> is chosen from a list of options a…
56702 … you can generate a sales summary for a certain postal code based on data from a client database. …
56708 …49262 4 0 nb \<ahelp hid=\".uno:InsertExternalDataSourc\"\>Inserts data from an HTML, Calc, or E…
56733 …. In a nested group, the last rows or columns that were added are removed from the group.\</ahelp\…
56736 …scalc\01\12080400.xhp 0 help par_id3125864 6 0 nb Removes selected rows from a group. 2020041…
56738 …lc\01\12080400.xhp 0 help par_id3154685 8 0 nb Removes selected columns from a group. 2020041…
56766 …o:DeleteRows\"\>After selecting at least one cell, deletes the entire row from the sheet.\</ahelp\…
56768 …teColumns\"\>After selecting at least one cell, deletes the entire column from the sheet.\</ahelp\…
56772 …id=\"konsolidieren\"\>\<ahelp hid=\".uno:DataConsolidate\"\>Combines data from one or more indepen…
56778 …\<emph\>Add\</emph\>. You can also select a the name of a predefined cell from the \<emph\>Source …
57140 …id=\".uno:ClearArrows\" visibility=\"visible\"\>Removes all tracer arrows from the spreadsheet.\</…
57293 …s area, if several have been defined. You can choose any of the scenarios from this list without r…
57326 … 2 0 nb \<ahelp hid=\".uno:DataFilterRemoveFilter\"\>Removes the filter from the selected cell r…
57421 …ITTELABW\"\>Returns the average of the absolute deviations of data points from their mean.\</ahelp…
57583 …elp hid=\"HID_FUNC_ZEITWERT\"\>TIMEVALUE returns the internal time number from a text enclosed by …
57615 …TTON_RID_SCDLG_PIVOT_LAYOUT_BTN_REMOVE\"\>Removes the selected data field from the table layout.\<…
57652 …\scalc\01\12040300.xhp 0 help hd_id3153771 25 0 nb Read filter criteria from 20200411 15:09:53
57657 …elp hid=\".uno:ClearOutline\" visibility=\"visible\"\>Removes the outline from the selected cell r…
57697 …FUNC_BASIS\"\>Converts a positive integer to a specified base into a text from the \<link href=\"t…
57721 …<ahelp hid=\"HID_FUNC_SAEUBERN\"\>All non-printing characters are removed from the string.\</ahelp…
57880 …al. The value range must be between 0 and 3999, the modes can be integers from 0 to 4.\</ahelp\> …
57935 …par_id3157888 55 0 nb \<ahelp hid=\"HID_FUNC_GLAETTEN\"\>Removes spaces from a string, leaving o…
58027 … 0 nb \<ahelp hid=\"HID_TEMPLATE_FMT\"\>Displays the list of the styles from the selected style …
58034 … 0 nb \<ahelp hid=\"HID_FUNC_ZEIT\"\>TIME returns the current time value from values for hours, m…
58093 … the source type to be shown in the data source.\</ahelp\> You can choose from four source types: …
58104 … sheet.\</ahelp\> You can create a new sheet, or insert an existing sheet from a file.\</variable\…
58120 …id=\"SC_RADIOBUTTON_RID_SCDLG_INSERT_TABLE_RB_FROMFILE\"\>Inserts a sheet from an existing file in…
58124 …he file path is displayed below this box. Select the sheet to be inserted from the list box.\</ahe…
58145 …_idN10815 0 nb \<ahelp hid=\".\"\>Select a predefined header or footer from the list.\</ahelp\>…
58151 …the title. Long-click to select either title, file name or path/file name from the submenu. If a t…
58231 …\"\>\<ahelp hid=\".uno:Protect\"\>Protects the cells in the current sheet from being modified.\</a…
58243 …hid=\".uno:Protect\"\>Allows you to enter a password to protect the sheet from unauthorized change…
58626 …0 nb \<ahelp hid=\"HID_FUNC_ZGZ\"\>Calculates the interest rate resulting from the profit (return)…
58687 … 0 nb \<ahelp hid=\"HID_AAI_FUNC_COUPDAYSNC\"\>Returns the number of days from the settlement date…
58698 … 0 nb \<ahelp hid=\"HID_AAI_FUNC_COUPDAYBS\"\>Returns the number of days from the first day of in…
58870 … range where you want to display the sorted list, or select a named range from the list.\</ahelp\>…
58926 …You decide which action is performed when dragging and dropping an object from the Navigator into …
58930 …D_SC_DROPMODE_URL\"\>Inserts a hyperlink when you drag-and-drop an object from the Navigator into …
58933 …\"HID_SC_DROPMODE_LINK\"\>Creates a link when you drag-and-drop an object from the Navigator into …
58935 …HID_SC_DROPMODE_COPY\"\>Generates a copy when you drag-and-drop an object from the Navigator into …
58947 …reference of each label range.\</ahelp\> In order to remove a label range from the list box, selec…
58972 …04060102.xhp 0 help par_id9988402 0 nb Dates are calculated as offsets from a starting day zero…
58985 …s recognized as dates and result in erroneous calculations. To keep dates from being interpreted a…
59094 …elp hid=\".uno:Delete\"\>Specifies the contents to be deleted from the active cell or from a selec…
59101 …elp hid=\"SC_CHECKBOX_RID_SCDLG_DELCONT_BTN_DELALL\"\>Deletes all content from the selected cell r…
59132 …SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_RIGHT\"\>Creates a series running from left to right withi…
59136 …"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_LEFT\"\>Creates a series running from right to left in th…
59155 …se the \<emph\>Date\</emph\> series type and this option to form a series from the names or abbrev…
59358 …"HID_AAI_FUNC_COMPLEX\"\>The result is a complex number which is returned from a real coefficient …
59394 …3154902 176 0 nb \<ahelp hid=\"HID_AAI_FUNC_CONVERT\"\>Converts a value from one unit of measure…
59470 …ery the contents of cell values or formulas. The conditions are evaluated from 1 to 3. If the cond…
59518 …aRefresh\" visibility=\"visible\"\>Updates a data range that was inserted from an external databas…
59530 …tion expects a single value, but you entered a cell range, then the value from the cell range is t…
59534 … FALSE. If a range is entered as a parameter, the function uses the value from the range that is i…
59580 …tion expects a single value, but you entered a cell range, then the value from the cell range is t…
59584 … FALSE. If a range is entered as a parameter, the function uses the value from the range that is i…
59698 …ic tangent, that is, the angle (in radians) between the x-axis and a line from point NumberX, Numb…
59791 …Returns \<emph\>Number\</emph\> rounded to the next even integer up, away from zero. 20200411 …
60036 …7 141 0 nb \<ahelp hid=\"HID_FUNC_AUFRUNDEN\"\>Rounds a number up, away from zero, to a certain …
60039 …par_id3163342 144 0 nb Returns \<emph\>Number\</emph\> rounded up (away from zero) to \<emph\>Co…
60040 …lc\01\04060106.xhp 0 help par_id9573961 0 nb This function rounds away from zero. See ROUNDDOWN…
60159 …C_UMRECHNEN\"\>Converts between old European national currency and to and from Euros.\</ahelp\> …
60183 … Returns \<emph\>Number\</emph\> rounded to the next odd integer up, away from zero. 20200411 1…
60310 …hp 0 help par_id3147469 190 0 nb \<emph\>StartDate\</emph\> is the date from when the calculatio…
60371 …5C1 0 nb \<ahelp hid=\"59010\"\>Select the items that you want to hide from the calculations.\<…
60750 …aturity date, that must fall within the same year. A discount is deducted from the purchase price.…
60904 …ered in cell A14. The formula is entered in cell B16 and differs slightly from the earlier example…
60946 …on of all children. Note that a representative result can not be obtained from a sample of less th…
60955 …ls of a data range which match the search criteria.\</ahelp\> The records from the example are tre…
60973 …eria.\</ahelp\> The records from the example are treated as a sample of data. A representative res…
60982 …cords that match the specified search criteria.\</ahelp\> The records are from the example are tre…
61147 …ATEBOX:RID_SCPAGE_PROTECTION:BTN_PROTECTED\"\>Prevents the selected cells from being modified.\</a…
61154 …STATEBOX:RID_SCPAGE_PROTECTION:BTN_HIDE_PRINT\"\>Keeps the selected cells from being printed.\</ah…
61158 …pendents\" visibility=\"visible\"\>Draws tracer arrows to the active cell from formulas that depen…
61262 …ection list in ascending order and filters duplicates from the list. If not checked, the order fro…
61301 …o:ToolProtectionDocument\"\>Protects the sheet structure of your document from modifications. It i…
62902 …from spreadsheets\</bookmark_value\> \<bookmark_value\>tables in spreadsheets;inserting in te…
62921 …154248 48 0 nb Choose \<emph\>Edit - Paste Special\</emph\>, and choose from the following optio…
62960 …oring options of an item, right-click the item, and then choose an option from the \<item type=\"m…
63017 …ck the \<item type=\"menuitem\"\>Formula\</item\> icon, and choose "Mean" from the Statistical Fun…
63175 …\"menuitem\"\>New Style from Selection\</item\> icon and choose \<item type=\"menuitem\"\>New Styl…
63255 …e available actions that are defined for this Smart Tag. Choose an option from the menu. The \<ite…
63491 …rt - Footer\</item\>, and then select the page style for the current page from the submenu. 202…
63834 …l installed languages. You can install languages with a thesaurus library from the \<link href=\"h…
63835 …ontext menu of the word shows a Synonyms submenu. Select any of the terms from the submenu to repl…
63921 …ck the First Page entry. Choose \<item type=\"menuitem\"\>Modify\</item\> from the context menu. O…
63981 …de\table_sizing.xhp 0 help par_id3153364 0 nb To increase the distance from the left edge of th…
64285 …aptions_numbers.xhp 0 help par_id3150527 19 0 nb Select a caption title from the \<item type=\"m…
64288 … 0 nb Type the character that you want to separate the chapter number(s) from the caption number …
64303 …itional Styles\</item\> check box in the \<item type=\"menuitem\"\>Create from\</item\> area, and …
64352 …from frame to frame\</bookmark_value\> \<bookmark_value\>frames; linking\</bookmark_value\> …
64441 …orientation.xhp 0 help par_id6670125 0 nb A one page long style starts from the lower border of…
64463 …t \<item type=\"menuitem\"\>Page break\</item\> and then select “Default” from the \<item type=\"m…
64661 …he option \<emph\>When closing a document, remove the words collected from it from the list\</emph…
64778 …tomatically numbers the next paragraph. To remove the numbering or bullet from the new paragraph, …
65003 …d=\"SW:RADIOBUTTON:TP_TOX_SELECT:RB_FROMCAPTIONS\"\>Creates index entries from object captions.\</…
65519 …iter\01\06030000.xhp 0 help par_id3147562 19 0 nb To exclude paragraphs from the automatic hyphe…
65534 …SVXDLG_HYPHENATE:BTN_HYPH_DELETE\"\>Removes the current hyphenation point from the displayed word.…
65626 …ext\"\>\<ahelp hid=\".uno:DeleteColumns\"\>Deletes the selected column(s) from the table.\</ahelp\…
65924 … 0 nb \<ahelp hid=\"HID_AUTH_MARK_DLG_FROM_DOC_RB\"\>Inserts a reference from the bibliography re…
66296 …:CHECKBOX:TP_TOX_SELECT:CB_READONLY\"\>Prevents the contents of the index from being changed.\</ah…
66321 …from several tables at once, select the tables, and then press \<switchinline select=\"sys\"\>\<ca…
66453 …TON:RID_SFX_SMALLTP_MACROASSIGN:PB_DELETE\"\>Removes the macro assignment from the selected entry.…
67318 …schentext\"\>\<ahelp hid=\".uno:DeleteRows\"\>Deletes the selected row(s) from the table.\</ahelp\…
67637 … contents. By default, the index title is one-column wide and extends out from left page margin. …
67689 …ed Style\</emph\> linked to it, then the \<emph\>Paragraph Style\</emph\> from that condition is u…
67821 …ment from a template that contains such a field. For example, a date field with fixed content inse…
67909 …sgrelin.xhp 0 help par_idN10571 0 nb \<ahelp hid=\".\"\>Select a value from the list for the sa…