Lines Matching refs:cells
9145 …xhp\" name=\"other options\"\>additional options\</link\> for filling the cells. 2002-02-02 02:…
9147 helpcontent2 source\text\scalc\01\02140000.xhp 0 help par_id3152994 3 0 rw \<emph\>Filling cells …
9148 ….xhp 0 help par_id3156285 2 0 rw \<ahelp hid=\".\"\>Automatically fills cells with content.\</ah…
9157 …ed to all the other selected cells. If you have selected several rows, each of the far left cells …
9160 …most cell is copied into the selected cells. If several columns are selected, the contents of the …
9165 …ell is copied into all other cells of the range. If several rows are selected, the far right cells…
9219 …okmark_value\>deleting; cell contents\</bookmark_value\>\<bookmark_value\>cells; deleting contents…
9231 …OX_RID_SCDLG_DELCONT_BTN_DELATTRS\"\>Deletes format attributes applied to cells. All cell content …
9234 …range.\</ahelp\>\</variable\> Contents are only deleted from the selected cells or active cell. Si…
9240 …id=\"SC_CHECKBOX_RID_SCDLG_DELCONT_BTN_DELNOTES\"\>Deletes notes added to cells. All other element…
9244 …cells; deleting cells\</bookmark_value\>\<bookmark_value\>columns; deleting\</bookmark_value\>\<bo…
9253 …a contains options for specifying how sheets are displayed after deleting cells. 2002-02-02 02:…
9254 …LG_DELCELL:BTN_CELLSUP\"\>Fills the space produced by the deleted cells with the cells underneath …
9255 …teCell\"\>Completely deletes selected cells, columns or rows. The cells below or to the right of t…
9256 …ELCELL:BTN_CELLSLEFT\"\>Fills the resulting space by the cells to the right of the deleted cells.\…
9311 … 0 help par_id3145785 4 0 rw Text cells are formatted in black, number cells in blue, and all ot…
9317 …he Formula Bar is hidden, you can still edit cells by activating the edit mode with F2. After edit…
9327 …xt\scalc\01\03100000.xhp 0 help par_id3155764 19 0 rw Adds the selected cells to print ranges. …
9344 …eadsheets; inserting cells\</bookmark_value\>\<bookmark_value\>cells; inserting\</bookmark_value\>…
9351 …_CELLSRIGHT\"\>Moves the contents of the selected range to the right when cells are inserted.\</ah…
9352 …id3149262 4 0 rw This area contains the options available for inserting cells into a sheet. The …
9353 …, in which you can insert new cells according to the options that you specify.\</ahelp\>\</variabl…
9354 …L:BTN_CELLSDOWN\"\>Moves the contents of the selected range downward when cells are inserted.\</ah…
9414 …p\>\</variable\> Before you start the Wizard, select a cell or a range of cells from the current s…
9423 …erate on multiple cells. Each cell in the array contains the formula, not as a copy but as a commo…
9428 … par_id3152993 40 0 rw The maximum size of an array range is 128 by 128 cells. 2002-02-02 02:…
9429 …nction Wizard\</emph\> and transfer the formula into the selected cell or cells. 2002-02-02 02:…
9519 …"\>DSTDEVP calculates the standard deviation of a population based on all cells of a data range wh…
9529 … you write the criteria in different rows they are connected by OR. Empty cells in the search crit…
9560 …62 0 rw \<ahelp hid=\"HID_FUNC_DBSUMME\"\>DSUM returns the total of all cells in a database fiel…
9599 …79 140 0 rw \<ahelp hid=\"HID_FUNC_DBPRODUKT\"\>DPRODUCT multiplies all cells of a data range wh…
9624 …0 rw \<ahelp hid=\"HID_FUNC_DBVARIANZ\"\>DVAR returns the variance of all cells of a database fiel…
9657 …ID_FUNC_DBMITTELWERT\"\>DAVERAGE returns the average of the values of all cells (fields) in all ro…
10025 …ction is used in order to check for both TRUE and FALSE values in certain cells. 2002-02-02 02:…
10033 …. \</ahelp\> You can use this function to control error values in certain cells. 2002-02-02 02:…
10094 …the content of one or several cells is a reference.\</ahelp\> Verifies the type of references in a…
10141 …16 54 0 rw \<ahelp hid=\"HID_FUNC_ISTFEHLER\"\>The ISERROR tests if the cells contain general er…
10200 …the current column or row. The result is TRUE if the logical value in all cells within the cell ra…
10484 …0 help par_id3143606 498 0 rw \<emph\>Range\</emph\> is the range whose cells are included. 2…
10559 …512 46 0 rw \<emph\>range\</emph\> is the cell range in which the empty cells are counted. 20…
10586 …0 rw SUM(A1;A3;B5) calculates the sum of the three cells. SUM (A1:E10) calculates the sum of all c…
10594 …elp par_id3151986 437 0 rw \<ahelp hid=\"HID_FUNC_SUMMEWENN\"\>Adds the cells specified by a giv…
10649 …w \<ahelp hid=\"HID_FUNC_ANZAHLLEEREZELLEN\"\>Returns the number of empty cells.\</ahelp\> Enter t…
10721 … 0 rw \<ahelp hid=\"HID_FUNC_SUMME\"\>Adds all the numbers in a range of cells.\</ahelp\> 2002…
10754 …mber, an expression or a character string. These criteria determine which cells are counted. You m…
10878 …t\scalc\01\04060107.xhp 0 help par_id3146787 324 0 rw Select a range of cells where you want to …
10956 …w The smallest possible array is a 1 x 2 or 2 x 1 array with two adjacent cells. 2002-02-02 02:…
10966 …298 258 0 rw \<variable id=\"wasmatrix\"\>An array is a linked range of cells on a spreadsheet c…
10967 helpcontent2 source\text\scalc\01\04060107.xhp 0 help par_id3154342 5 0 rw The cells in a results…
11022 …cells by 10 in the above array, you do not need to apply a formula to each individual cell or valu…
11066 …cells follow the same rules as single comparisons; that is, it could be represented either by 0 or…
11269 … par_id3083286 181 0 rw =SUM(INDIRECT("a1:" & ADDRESS(1;3))) totals the cells in the area of A1 …
11297 …help hid=\"HID_FUNC_WVERWEIS\"\>Searches for a value and reference to the cells below the selected…
11320 …46 25 0 rw =AREAS(A1:B3;F2;G1) returns 3, as it is a reference to three cells and/or areas. 2…
11321 …elp hid=\"HID_FUNC_SVERWEIS\"\>Vertical search with reference to adjacent cells to the right.\</ah…
11322 …t belong to a multiple range.\</ahelp\> A range can consist of contiguous cells or a single cell. …
11353 …is updated in all \<item type=\"productname\"\>%PRODUCTNAME\</item\> Calc cells in which this DDE …
11398 …hp 0 help par_id3156032 116 0 rw \<emph\>Rows\</emph\> is the number of cells by which the refer…
11429 …alc\01\04060110.xhp 0 help bm_id3145389 0 rw \<bookmark_value\>text in cells; functions\</bookm…
11780 …p 0 help par_id3145202 103 0 rw Number of the following elements. Empty cells are not counted or…
11817 …p 0 help par_id3148621 147 0 rw Number of the following elements. Empty cells are not counted or…
11872 …p 0 help par_id3150647 194 0 rw Number of the following elements. Empty cells are not counted or…
12308 …n quotation marks or as a reference. If you enter the units of measure in cells, they must corresp…
12883 …5896 325 0 rw Values:corresponds to the array or the cell reference for cells whose content corr…
12991 …060181.xhp 0 help par_id3148728 10 0 rw To calculate the intercept, use cells D3:D9 as the y val…
13020 … empty string of length 0. If an argument is an array or reference, empty cells within the array o…
13712 … 71 0 rw Calculates the sum of all cells in the intersection; in this example, the result yields…
13846 …butes\</bookmark_value\>\<bookmark_value\>formatting;cells\</bookmark_value\>\<bookmark_value\>cel…
13850 …y a variety of formatting options and to apply attributes to the selected cells.\</ahelp\>\</varia…
13859 …lp hid=\"HID_SCPAGE_PROTECTION\"\>Defines protection options for selected cells.\</ahelp\> 2002…
13860 …:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_PROTECTED\"\>Prevents the selected cells from being modifie…
13861 …GE_PROTECTION:BTN_HIDE_ALL\"\>Hides formulas and contents of the selected cells.\</ahelp\> 2002…
13863 …RID_SCPAGE_PROTECTION:BTN_HIDE_FORMULAR\"\>Hides formulas in the selected cells.\</ahelp\> 2002…
13864 …SC:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_HIDE_PRINT\"\>Keeps the selected cells from being printed…
13892 …3145748 4 0 rw To show all hidden cells, first click in the field in the upper left corner. This…
13933 …the first cell of the original cell range. Merged cells cannot be merged a second time with other …
13934 helpcontent2 source\text\scalc\01\05060000.xhp 0 help par_id3149665 3 0 rw If the cells to be mer…
13935 …46 2 0 rw \<ahelp hid=\".\"\>Combines the selected cells into a single cell or splits merged cel…
13940 …id3150542 0 rw \<bookmark_value\>cells; printing grids\</bookmark_value\>\<bookmark_value\>bord…
13963 …BOX:RID_SCPAGE_TABLE:BTN_GRID\"\>Prints out the borders of the individual cells as a grid.\</ahelp…
13966 …\<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_NULLVALS\"\>Specifies that cells with a zero value …
13973 …BOX:RID_SCPAGE_TABLE:BTN_FORMULAS\"\>Prints the formulas contained in the cells, instead of the re…
13994 … range manually, Calc assigns an automatic print range to include all the cells that are not empty…
13995 …help par_id3155855 2 0 rw \<ahelp hid=\".\"\>Manages print ranges. Only cells within the print r…
14039 …r a certain range to format the whole range. Repeat this action for other cells and ranges. 200…
14075 …d, specifies that you want to retain the width and height of the selected cells of the selected fo…
14082 …\"\>Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of pre…
14097 …: Cell style Result (The corresponding value limits must already exist in cells B20 and B21) 20…
14099 …)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the …
14100 …OND3_2\"\>Choose a condition for the format to be applied to the selected cells.\</ahelp\> 2002…
14108 …alc\01\06020000.xhp 0 help hd_id3153192 4 0 rw Hyphenation for selected cells. 2002-02-02 02:…
14115 helpcontent2 source\text\scalc\01\06020000.xhp 0 help par_id3150868 5 0 rw Select the cells for w…
14120 …l links search\</bookmark_value\>\<bookmark_value\>searching for links in cells\</bookmark_value\>…
14123 …tive, you can trace the dependencies from the current formula cell to the cells in the spreadsheet…
14125 …bm_id3155628 0 rw \<bookmark_value\>cells; tracing precedents\</bookmark_value\>\<bookmark_valu…
14127 … in the sheet with marking arrows. At the same time, the range of all the cells contained in the f…
14128 …ws the relationship between the current cell containing a formula and the cells used in the formul…
14129 …hen you repeat this command, the tracer arrows are drawn to the precedent cells of this cell. 2…
14131 …m_id3155628 0 rw \<bookmark_value\>cells; removing precedents\</bookmark_value\>\<bookmark_valu…
14135 helpcontent2 source\text\scalc\01\06030300.xhp 0 help bm_id3153252 0 rw \<bookmark_value\>cells;…
14137 helpcontent2 source\text\scalc\01\06030300.xhp 0 help par_id3148948 4 0 rw The area of all cells …
14141 helpcontent2 source\text\scalc\01\06030400.xhp 0 help bm_id3147335 0 rw \<bookmark_value\>cells;…
14145 helpcontent2 source\text\scalc\01\06030500.xhp 0 help bm_id3153088 0 rw \<bookmark_value\>cells;…
14149 helpcontent2 source\text\scalc\01\06030600.xhp 0 help bm_id3153561 0 rw \<bookmark_value\>cells;…
14151 …ShowErrors\" visibility=\"visible\"\>Draws tracer arrows to all precedent cells which cause an err…
14153 …9 0 rw \<bookmark_value\>cells; trace fill mode\</bookmark_value\>\<bookmark_value\>traces; pre…
14158 helpcontent2 source\text\scalc\01\06030800.xhp 0 help bm_id3153821 0 rw \<bookmark_value\>cells;…
14160 … 0 rw \<ahelp hid=\".uno:ShowInvalid\" visibility=\"visible\"\>Marks all cells in the sheet that …
14161 …r, it is possible to enter invalid values or copy invalid values into the cells if the \<emph\>Sto…
14163 helpcontent2 source\text\scalc\01\06030900.xhp 0 help bm_id3152349 0 rw \<bookmark_value\>cells;…
14170 helpcontent2 source\text\scalc\01\06031000.xhp 0 help bm_id3154515 0 rw \<bookmark_value\>cells;…
14197 …hid=\"SC:CHECKBOX:RID_SCDLG_NEWSCENARIO:CB_TWOWAY\"\>Copies the values of cells that you change in…
14203 …, if the \<emph\>Copy back\</emph\> is option is not selected, and if the cells are not protected.…
14204 …elected, if the \<emph\>Copy back\</emph\> option is selected, and if the cells are not protected.…
14209 …h\> Protect Document \</emph\>command prevents changes from being made to cells in the sheets or t…
14213 …\<variable id=\"tabelletext\"\>\<ahelp hid=\".uno:Protect\"\>Protects the cells in the current she…
14215 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3149123 16 0 rw Select the cells that…
14217 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3149664 5 0 rw To protect cells from …
14223 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3154490 8 0 rw Unprotected cells or c…
14237 helpcontent2 source\text\scalc\01\06070000.xhp 0 help par_id3145173 3 0 rw All cells are recalcul…
14247 … the same column.\</ahelp\> The column is scanned up to a maximum of 2000 cells or 200 different s…
14276 …hid=\".uno:DefineDBName\"\>Defines a database range based on the selected cells in your sheet.\</a…
14282 helpcontent2 source\text\scalc\01\12010100.xhp 0 help hd_id3153970 5 0 rw Insert or delete cells …
14289 …le\"\>Only saves a reference to the database, and not the contents of the cells.\</ahelp\> 2002…
14453 …_FORMULARANGE\" visibility=\"visible\"\>Enter the cell references for the cells containing the for…
14455 …et containing multiple operations to Microsoft Excel, the location of the cells containing the for…
14456 …ionDialog\" visibility=\"visible\"\>Applies the same formula to different cells, but with differen…
14486 …alue\>showing; sheet details\</bookmark_value\>\<bookmark_value\>grouping;cells\</bookmark_value\>…
14527 … 0 help par_id3147363 27 0 rw The cells for the 1st and 2nd quarters each contain a sum formula …
14554 …id=\"SC:RADIOBUTTON:RID_SCDLG_DAPITYPE:BTN_SELECTION\"\>Uses the selected cells as the data source…
14608 helpcontent2 source\text\scalc\01\12090102.xhp 0 help par_idN108E6 0 rw Select a range of cells …
14789 helpcontent2 source\text\scalc\01\12120100.xhp 0 help hd_id3154704 7 0 rw Allow blank cells 20…
14806 …id=\"SC:TRISTATEBOX:TP_VALIDATION_VALUES:TSB_ALLOW_BLANKS\"\>Allows blank cells in the selected va…
14815 …e, or as a named range. The range may consist of one column or one row of cells. If you specify a …
14864 …l containing the DATE function is the date format, but you can format the cells with the \<emph\>0…
15075 …alc/01/func_weeknum.xhp\"\>WEEKNUM\</link\> function, or format your date cells using the WW forma…
15126 …sibility=\"visible\"\>Applies the default currency format to the selected cells.\</ahelp\> 2002…
15138 ….uno:NumberFormatPercent\"\>Applies the percentage format to the selected cells.\</ahelp\> 2002…
15145 …visibility=\"visible\"\>Applies the default number format to the selected cells.\</ahelp\> 2002…
15150 …bility=\"visible\"\>Adds one decimal place to the numbers in the selected cells.\</ahelp\> 2002…
15154 …y=\"visible\"\>Removes one decimal place from the numbers in the selected cells.\</ahelp\> 2002…
15159 …rent cell, the range of the selected cells, or the name of the area.\</ahelp\> You can also select…
15197 …elp hid=\".uno:ChooseDesign\"\>Applies a formatting style to the selected cells.\</ahelp\>\</varia…
15205 …the current document. By default, the SUM of the contents of the selected cells is displayed.\</ah…
15233 …\02\18020000.xhp 0 help bm_id3150275 0 rw \<bookmark_value\>inserting; cells, toolbar icon\</bo…
15241 …n to open the \<emph\>Insert Cells \</emph\>toolbar, where you can insert cells, rows, and columns…
15325 …cells, press Delete. This opens the \<link href=\"text/scalc/01/02150000.xhp\" name=\"Delete Conte…
15350 helpcontent2 source\text\scalc\04\01020000.xhp 0 help par_id3150385 38 0 rw Highlights cells cont…
15373 …00.xhp 0 help par_id3153967 84 0 rw To create a matrix in which all the cells contain the same i…
15399 …159258 185 0 rw Selects all cells containing data from the current cell to the end of the contin…
15401 …xt\scalc\04\01020000.xhp 0 help par_id3166426 4 0 rw To select multiple cells in different areas…
15492 …p par_id3152597 21 0 rw You can use cells with text to refer to the rows or to the columns that …
15497 …cells;AutoInput function\</bookmark_value\>\<bookmark_value\>cells; AutoInput function of text\</b…
15518 …xhp 0 help par_id3147340 19 0 rw To stop using AutoFilter, reselect all cells selected in step 1…
15527 …cells that are not visible due to an applied filter. For example, a sum of an entire column will a…
15540 helpcontent2 source\text\scalc\guide\autoformat.xhp 0 help par_idN106CE 0 rw Select the cells, i…
15544 … help par_idN1075D 0 rw The format is applied to the selected range of cells. 2002-02-02 02:…
15549 …<bookmark_value\>dates; in cells\</bookmark_value\>\<bookmark_value\>times; in cells\</bookmark_va…
15561 …rk_value\>cells; filling automatically\</bookmark_value\>\<bookmark_value\>auto filling cells\</bo…
15563 …rw Drag the fill handle in the bottom right corner of the cell across the cells that you want to f…
15564 helpcontent2 source\text\scalc\guide\calc_series.xhp 0 help par_id3145801 17 0 rw The cells are f…
15567 … 0 rw If you select two or more adjacent cells that contain different numbers, and drag, the rem…
15570 …de\calc_series.xhp 0 help par_idN106A8 0 rw You can automatically fill cells with data with the…
15578 … the first column. Now enter some values into B1 and C1. Select those two cells, and double-click …
15603 …cells and sheets\</bookmark_value\>\<bookmark_value\>cells; protecting\</bookmark_value\>\<bookmar…
15611 helpcontent2 source\text\scalc\guide\cell_protect.xhp 0 help par_idN1066B 0 rw Select the cells …
15613 …t \<emph\>Hide when printing\</emph\> to hide protected cells in the printed document. The cells a…
15617 …ssword, you cannot deactivate the protection. If you only want to protect cells from changes, do n…
15619 …e\>\<bookmark_value\>protecting; unprotecting cells\</bookmark_value\>\<bookmark_value\>unprotecti…
15624 …ect.xhp 0 help par_id3153771 18 0 rw The cells can now be edited, the formulas can be viewed, an…
15626 …cells; copying\</bookmark_value\>\<bookmark_value\>copying; cells\</bookmark_value\>\<bookmark_val…
15628 …t\scalc\guide\cellcopy.xhp 0 help par_id3146918 8 0 rw Only the visible cells of the selection a…
15631 …4 7 0 rw Copy, delete, move, or format a selection of currently visible cells. 2002-02-02 02:…
15633 … 13 0 rw Copy, delete, move, or format a selection of currently visible cells. 2002-02-02 02:…
15634 …de\cellcopy.xhp 0 help par_id3154371 14 0 rw All cells of the selection, including the hidden ce…
15635 …p 0 help par_id3154729 3 0 rw $[officename] behavior depends on how the cells were made invisibl…
15639 … 0 rw \<bookmark_value\>drag and drop; referencing cells\</bookmark_value\>\<bookmark_value\>cel…
15644 …0 help par_id3152576 25 0 rw Open the document that contains the source cells. 2002-02-02 02:…
15645 … par_id3154011 26 0 rw To set the source range as the range, select the cells and choose \<emph\…
15649 …igator you can reference cells from one spreadsheet to another sheet in the same document or in a …
15651 …rk_value\>\<bookmark_value\>references; to cells in another document\</bookmark_value\>\<bookmark_…
15654 …value\>HTML; in sheet cells\</bookmark_value\>\<bookmark_value\>references; URL in cells\</bookmar…
15656 …. When you open it again later, $[officename] Calc will update the linked cells following an inqui…
15667 …t\scalc\guide\cellstyle_by_formula.xhp 0 help par_id3144767 24 0 rw All cells with contents that…
15672 …tyle_by_formula.xhp 0 help par_id3149456 16 0 rw Select all the desired cells. 2002-02-02 02:…
15673 …..+STYLE(IF(CURRENT()>3, "Red", "Green")) applies the cell style "Red" to cells if the value is gr…
15675 … help par_id3151385 15 0 rw If you would like to apply a formula to all cells in a selected area…
15679 …63 0 rw \<bookmark_value\>conditional formatting; cells\</bookmark_value\>\<bookmark_value\>cel…
15687 …help par_id3145320 62 0 rw To apply the conditional formatting to other cells later: 2002-02-…
15694 …de\cellstyle_conditional.xhp 0 help par_id3149565 41 0 rw In one of the cells enter the formula …
15696 …guide\cellstyle_conditional.xhp 0 help par_id3150049 56 0 rw Select all cells with the random nu…
15697 …guide\cellstyle_conditional.xhp 0 help par_id3150436 65 0 rw Select the cells that are to receiv…
15701 …cellstyle_conditional.xhp 0 help par_id3153074 63 0 rw Click one of the cells that has been assi…
15705 …guide\cellstyle_conditional.xhp 0 help par_id3154490 27 0 rw Select the cells to which you want …
15713 …to three conditions per cell, which must be met in order for the selected cells to have a particul…
15721 …de\cellstyle_minusvalue.xhp 0 help par_id3153878 33 0 rw You can format cells with a number form…
15722 …\guide\cellstyle_minusvalue.xhp 0 help par_id3155600 34 0 rw Select the cells and choose \<emph\…
15731 …ther \<emph\>Row labels\</emph\> or \<emph\>Column labels\</emph\> if the cells of the source data…
15737 … 0 help par_id3153191 34 0 rw During consolidation, the contents of the cells from several sheet…
15784 …lons, or other characters can be used as the field delimiters between the cells. Text strings are …
15801 …cells; currency formats\</bookmark_value\>\<bookmark_value\>international currency formats\</bookm…
15803 …_id3145640 51 0 rw If, under \<emph\>Language\</emph\>, you convert the cells to "English (US)",…
15815 …abase_define.xhp 0 help par_id3153768 81 0 rw You can define a range of cells in a spreadsheet t…
15817 …de\database_define.xhp 0 help par_id3155064 41 0 rw Select the range of cells that you want to d…
15864 …e.xhp 0 help par_id3156023 8 0 rw Position the cursor within a range of cells containing values,…
15889 …apilot_grouping.xhp 0 help par_idN10667 0 rw Select a cell or range of cells in the DataPilot t…
15891 …g.xhp 0 help par_idN1066E 0 rw Depending on the format of the selected cells, either a new grou…
15937 …and the Styles and Formatting window lists the custom styles for specific cells. 2002-02-02 02:…
15942 …eet with a theme, you have to apply at least one custom cell style to the cells on the sheet. You …
15944 …from the Styles and Formatting window to apply this style to the selected cells. 2002-02-02 02:…
15961 …\>AutoFormat function; sheets\</bookmark_value\>\<bookmark_value\>text in cells; formatting\</book…
15968 …"\>Insert - Picture - From File\</item\> and arrange the image behind the cells by choosing \<item…
15970 …d3154733 20 0 rw You can assign a format to any group of cells by first selecting the cells (for…
15972 …xt\scalc\guide\format_table.xhp 0 help par_id3159226 17 0 rw Select the cells containing the num…
15974 … numbers in tables\</bookmark_value\>\<bookmark_value\>number formats; in cells\</bookmark_value\>…
16000 …c\guide\format_value_userdef.xhp 0 help par_id3150868 3 0 rw Select the cells to which you want …
16014 … help par_id3149961 34 0 rw If you want to copy a formula into multiple cells, there is a quick …
16016 … With the mouse button pressed, drag it down or to the right over all the cells into which you wan…
16017 …rw When you release the mouse button, the formula will be copied into the cells and automatically …
16028 …8 0 rw You can also enter the values and the formulas directly into the cells, even if you canno…
16034 … are editing a formula with references, the references and the associated cells will be highlighte…
16037 …xhp 0 help bm_id3153195 0 rw \<bookmark_value\>formulas; displaying in cells\</bookmark_value\>…
16041 … 0 help par_id3150010 2 0 rw If you want to display the formulas in the cells, for example in th…
16045 …ulas.xhp 0 help bm_id3155411 0 rw \<bookmark_value\>formulas; in table cells\</bookmark_value\>…
16065 …las.xhp 0 help par_id3154486 34 0 rw Calculates B8 minus the sum of the cells B10 to B14. 200…
16069 …c\guide\formulas.xhp 0 help par_id3159171 36 0 rw Calculates the sum of cells B10 to B14 and add…
16073 …action view. Open the context menu of the cell, and choose \<emph\>Format cells. \</emph\>Select "…
16108 …>cells; changing text/number formats\</bookmark_value\>\<bookmark_value\>formats; changing text/nu…
16127 …the cell selection mode, you can use the common navigation keys to select cells. 2002-02-02 02:…
16136 …ode\"\>F2\</item\> to enter the cell selection mode. Select any number of cells, then press \<item…
16169 …cells; selecting\</bookmark_value\>\<bookmark_value\>marking cells\</bookmark_value\>\<bookmark_va…
16174 …uide\mark_cells.xhp 0 help hd_id3154942 6 0 rw Select various dispersed cells 2002-02-02 02:0…
16177 …rw A mouse click selects the cell you have clicked on. Unmarks all marked cells. 2002-02-02 02:…
16180 …par_id3149959 5 0 rw Pressing the mouse button, drag a range across two cells, do not release th…
16183 …ell adds it to the already marked cells. A mouse click in a marked cell unmarks it. Alternatively,…
16187 …ne\>Ctrl\</defaultinline\>\</switchinline\>, click each of the additional cells. 2002-02-02 02:…
16200 …0 help par_id3154018 21 0 rw Select the numbers in the second column in cells B1:B10. 2002-02…
16238 …46 54 0 rw With the cursor in the \<emph\>Formulas\</emph\> field, mark cells B5 thru C5. 200…
16243 …0 rw Mark the range D2:E11, and thus the values in column D and the empty cells alongside in colum…
16254 …<item type=\"literal\"\>=SUM(Sheet1.A1:Sheet3.A1) \</item\>sums up all A1 cells on Sheet1 through …
16257 …cells\</bookmark_value\>\<bookmark_value\>cells;notes\</bookmark_value\>\<bookmark_value\>comments…
16300 …\</emph\> - Only the selection will be printed. If cells are selected, these are printed. If no ce…
16301 …Preview\</emph\>. Drag the delimiter lines to define the range of printed cells on each page. 2…
16331 …cells;print ranges\</bookmark_value\>\<bookmark_value\>printing; cells\</bookmark_value\>\<bookmar…
16339 …printranges.xhp 0 help par_idN108F5 0 rw You can define which range of cells on a spreadsheet t…
16340 helpcontent2 source\text\scalc\guide\printranges.xhp 0 help par_idN108FB 0 rw The cells on the s…
16342 helpcontent2 source\text\scalc\guide\printranges.xhp 0 help par_idN10905 0 rw Select the cells t…
16345 helpcontent2 source\text\scalc\guide\printranges.xhp 0 help par_idN10917 0 rw Select the cells t…
16357 …s\</bookmark_value\>\<bookmark_value\>references; to cells\</bookmark_value\>\<bookmark_value\>cel…
16363 …cells by first entering the coordinates of the upper left cell of the area, then a colon followed …
16364 …ferences can also change when an existing formula referring to particular cells is copied to anoth…
16366 …elative reference? Assume you want to calculate in cell E1 the sum of the cells in range A1:B2. Th…
16381 …ding_numbers.xhp 0 help hd_id3152596 4 0 rw To change this for selected cells 2002-02-02 02:0…
16394 …alc\guide\rounding_numbers.xhp 0 help par_id3154321 5 0 rw Mark all the cells you want to modify…
16396 …cells\</bookmark_value\>\<bookmark_value\>cell heights\</bookmark_value\>\<bookmark_value\>cells; …
16418 …list of values to select from for a given cell or group of cells. The contents of these cells chan…
16420 …cells that are already highlighted by the frame of the existing scenario. You can also select mult…
16422 …Tools - Detective - Trace Dependents\</emph\>. You will see arrows to the cells that are directly …
16424 …o.xhp 0 help par_id3154704 16 0 rw To create a scenario, select all the cells that provide the d…
16428 …\<bookmark_value\>sort lists;applying\</bookmark_value\>\<bookmark_value\>cells; AutoFill function…
16431 …en drag the selected cell a few cells to the right or downwards. When you release the mouse button…
16471 … "January" in the \<emph\>Month\</emph\> cells OR a value of under 160000 in the \<emph\>Standard\…
16488 …e\>superscript text in cells\</bookmark_value\>\<bookmark_value\>subscript text in cells\</bookmar…
16518 …w If you have already entered normal numbers in cells and have afterwards changed the format of th…
16520 …s text in $[officename] Calc. Open the context menu of a cell or range of cells and choose \<emph\…
16523 …ark_value\>cells; rotating text\</bookmark_value\>\<bookmark_value\>rotating; text in cells\</book…
16525 helpcontent2 source\text\scalc\guide\text_rotate.xhp 0 help par_id3145171 2 0 rw Select the cells…
16533 …cells; multi-line\</bookmark_value\>\<bookmark_value\>cells; text breaks\</bookmark_value\>\<bookm…
16538 …t\scalc\guide\text_wrap.xhp 0 help par_id3153951 44 0 rw Select all the cells where you want the…
16551 … type=\"literal\"\>b\</item\>, and \<item type=\"literal\"\>c\</item\> in cells A1, B1, and C1. …
16569 …cells; validity\</bookmark_value\>\<bookmark_value\>error messages; defining for incorrect input\<…
16572 …alid Data\"\>\<emph\>Mark Invalid Data\</emph\>\</link\> to display which cells contain invalid va…
16581 …ues such as "12:00" or serial time numbers. "Text Length" stipulates that cells are allowed to con…
16583 … 0 rw Select the cells for which you want to define a new validity rule. You can select multiple…
16584 …teria\</emph\> tab page, enter the conditions for new values entered into cells. Values you have a…
16585 …ou to guide users through data entry in $[officename] Calc by restricting cells to receive specifi…
16590 …bm_id3147434 0 rw \<bookmark_value\>cells; defining names\</bookmark_value\>\<bookmark_value\>n…
16594 …lue_with_name.xhp 0 help par_id3153954 3 0 rw Select a cell or range of cells, then choose \<emp…
16675 … rw The Insert menu contains commands for inserting new elements, such as cells, rows, sheets and …
16686 …he \<emph\>Format\</emph\> menu contains commands for formatting selected cells, \<link href=\"tex…
17039 …LABEL:CB_AXIS_LABEL_TEXTOVERLAP\"\>Specifies that the text in cells may overlap other cells.\</ahe…
17986 …79 0 rw You can create a DDE link using the following procedure: Select cells from a Calc spread…
19732 …ark_value\>documents;number of sheets\</bookmark_value\>\<bookmark_value\>cells;number of\</bookma…
19752 …w \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Number of cells with content in th…
20018 …\<bookmark_value\>cell ranges;pasting\</bookmark_value\>\<bookmark_value\>cells;pasting\</bookmark…
20020 …\<caseinline select=\"CALC\"\>In a spreadsheet, when you paste a range of cells from the clipboard…
20035 … \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Skip empty cells \</caseinline\>\</…
20051 …ppl\"\>\<caseinline select=\"CALC\"\>Set the shift options for the target cells when the clipboard…
20053 …"\>\<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSFORMULAS\"\>Inserts cells containing formula…
20055 …o that changes made to the cells in the source file are updated in the target file. To ensure that…
20060 …HECKBOX:RID_SCDLG_INSCONT:BTN_SKIP_EMPTY\"\>Empty cells from the clipboard do not replace target c…
20061 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing text st…
20065 …CALC\"\>This dialog appears in Calc if the clipboard contains spreadsheet cells. \</caseinline\>\<…
20066 …<caseinline select=\"CALC\"\>Select the operation to apply when you paste cells into your sheet. \…
20067 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing numbers…
20069 …lect=\"appl\"\>\<caseinline select=\"CALC\"\>Target cells are shifted downward when you insert cel…
20070 … select=\"CALC\"\>Subtracts the values in the clipboard cells from the values in the target cells.…
20071 …line select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserted cells replace the target cells. \</ca…
20072 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing date an…
20073 …cells \</emph\>box, empty cells in the clipboard are treated as zeroes. For example, if you apply …
20074 …select=\"CALC\"\>Multiplies the values in the clipboard cells with the values in the target cells.…
20075 …line select=\"CALC\"\>Divides the values in the target cells by the values in the clipboard cells.…
20077 …"appl\"\>\<caseinline select=\"CALC\"\>Inserts notes that are attached to cells. If you want to ad…
20078 …in the clipboard cells to the values in the target cells. Also, if the clipboard only contains not…
20079 …ct=\"appl\"\>\<caseinline select=\"CALC\"\>Target cells are shifted to the right when you insert c…
20084 …line select=\"appl\"\> \<caseinline select=\"CALC\"\>To select all of the cells on a sheet, click …
20126 …<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Searches for cells with contents that…
20133 …select=\"appl\"\>\<caseinline select=\"CALC\"\>Searches only the selected cells. \</caseinline\>\<…
20137 …for the characters that you specify in the notes that are attached to the cells. \</caseinline\>\<…
20142 …l\"\>\<caseinline select=\"CALC\"\>Determines the order for searching the cells. \</caseinline\>\<…
20572 …changes command is active, you cannot delete, move, merge, split, or copy cells or delete sheets. …
20628 …w \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Lists the cells with contents that…
20672 …hid=\"SC:IMAGEBUTTON:RID_SCDLG_SIMPLEREF:RB_ASSIGN\"\>Select the range of cells that you want to u…
20679 … 0 rw \<ahelp hid=\"HID_REDLINING_FILTER_BTN_REF\"\>Select the range of cells that you want to u…
20680 …ters the list of changes according to the range of cells that you specify. To select a range of ce…
20738 …ine select=\"CALC\"\>Resizes the display to fit the width of the selected cells. \</caseinline\>\<…
20911 …<bookmark_value\>deleting; hyperlinks\</bookmark_value\>\<bookmark_value\>cells;resetting formats\…
20937 …help par_id3153770 59 0 rw You can only change the language setting for cells (choose \<emph\>Fo…
20992 …e\>\<bookmark_value\>numbers; formats\</bookmark_value\>\<bookmark_value\>cells; number formats\</…
21010 …VXPAGE_NUMBERFORMAT_CB_SOURCEFORMAT\"\>Uses the same number format as the cells containing the dat…
21023 …cells\</caseinline\>\<defaultinline\>fields\</defaultinline\>\</switchinline\>. With the language …
21083 …01.xhp 0 help par_id3147318 99 0 rw The default currency format for the cells in your spreadshee…
21155 …e select=\"CALC\"\>If you perform a calculation that involves one or more cells using a date forma…
21354 …options for \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>cells \</caseinline\>\<d…
21462 …he selected \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>cells \</caseinline\>\<c…
21478 …\<ahelp hid=\"700793922\"\>Merges two different border styles of adjacent cells in a Writer table …
21479 … a blue border of 3 point width, then the common border between these two cells will be blue with …
21505 …footers, text frames, tables, table cells, sections, and indexes. \</caseinline\>\<caseinline sele…
21635 …\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Centers the cells vertically on the …
21638 …pl\"\>\<caseinline select=\"CALC\"\>Specify the alignment options for the cells on a printed page.…
21650 …\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Centers the cells horizontally on th…
22513 …elp bm_id3154545 0 rw \<bookmark_value\>aligning; cells\</bookmark_value\>\<bookmark_value\>cel…
22556 …e alignment options for the contents of the current cell, or the selected cells.\</ahelp\> 2002…
24657 …alue\>cells linked to controls\</bookmark_value\>\<bookmark_value\>linked cells;controls\</bookmar…
24751 … hid=\".\"\>Check boxes and radio buttons in Spreadsheets can be bound to cells in the current doc…
25277 …mph\>icon to increase the indentation of the cell content of the selected cells.\</caseinline\>\</…
27626 helpcontent2 source\text\shared\autopi\01150000.xhp 0 help hd_id3152974 39 0 rw Currency cells in…
27638 helpcontent2 source\text\shared\autopi\01150000.xhp 0 help hd_id3156276 41 0 rw Currency cells in…
27641 …par_id3145162 38 0 rw \<ahelp hid=\"HID_DLGCONVERT_OPTIONBUTTON1\"\>All cells with the selected …
27643 …6912 42 0 rw \<ahelp hid=\"HID_DLGCONVERT_OPTIONBUTTON3\"\>All currency cells in the active docu…
27657 helpcontent2 source\text\shared\autopi\01150000.xhp 0 help par_id3152999 36 0 rw Select the cells…
27660 …IONBUTTON4\"\>All currency cells in the range selected before the converter was called will be con…
27664 …4479 40 0 rw \<ahelp hid=\"HID_DLGCONVERT_OPTIONBUTTON2\"\>All currency cells in the active spre…
28320 …p hid=\"SID_TABLEDESIGN_INSERTROWS\"\>Inserts rows in front of the marked cells.\</ahelp\> 2002…
29539 …\<bookmark_value\>tables; backgrounds\</bookmark_value\>\<bookmark_value\>cells; backgrounds\</boo…
29543 …_id3154097 27 0 rw This background appears only in the print behind the cells not formatted else…
29569 …red\guide\border_table.xhp 0 help par_id3146957 2 0 rw Select the table cells that you want to m…
29572 …red\guide\border_table.xhp 0 help par_id3152472 8 0 rw Select the table cells that you want to m…
29574 …adds\</emph\> the selected style to the current border style of the table cells. Select the blank …
29579 …cells\</bookmark_value\>\<bookmark_value\>cells; line breaks\</bookmark_value\>\<bookmark_value\>t…
29581 …_idN106D9 0 rw Inserting line breaks in $[officename] Calc spreadsheet cells 2002-02-02 02:0…
29584 …aking_lines.xhp 0 help par_idN106E6 0 rw Formatting $[officename] Calc cells for automatic line…
29585 …xt\shared\guide\breaking_lines.xhp 0 help par_idN106ED 0 rw Select the cells for which you want…
29623 …xt\shared\guide\chart_insert.xhp 0 help par_id3150275 4 0 rw Select the cells that contain the d…
29624 …nge the values of a chart obtained from selected cells, you have to change the values in the table…
29674 …help bm_id3154186 0 rw \<bookmark_value\>tables; inserting spreadsheet cells\</bookmark_value\>…
29676 …he sheet and then use either the clipboard or drag-and-drop to insert the cells into the text docu…
29677 …cells to the normal view of a presentation document, the cells will be inserted there as an OLE ob…
30782 …ment that contains VBA macro code. Change only the normal contents (text, cells, graphics), and do…
30859 …xhp 0 help par_idN106EC 0 rw Text within drawing object or within Calc cells is selected 200…
30861 …t\shared\guide\paintbrush.xhp 0 help par_idN106F9 0 rw Writer table or cells are selected 20…
30863 …ext\shared\guide\paintbrush.xhp 0 help par_idN10706 0 rw Calc table or cells are selected 20…
30878 …preadsheet cells, then a different \<emph\>Paste Special\</emph\> dialog appears. Use the \<emph\>…
30880 …: pastes the cell range as a link. If the source file changes, the pasted cells change also. 20…
31003 … Changes in a spreadsheet document are highlighted by a border around the cells; when you point to…
32420 …help hid=\"SW_CHECKBOX_TP_OPTTABLE_PAGE_CB_BORDER\"\>Specifies that table cells have a border by d…
32568 …ble cells will be formatted as in %PRODUCTNAME prior to version %PRODUCTVERSION. If the option is …
32644 …cells; showing grid lines\</bookmark_value\>\<bookmark_value\>borders; cells on screen\</bookmark_…
32682 …B_FORMULA\"\>Specifies whether to show formulas instead of results in the cells.\</ahelp\> 2002…
32686 …GE_CONTENT_CB_GRID\"\>Specifies whether to display grid lines between the cells.\</ahelp\>\<switch…
32688 … than the width of the cell, the text is displayed over empty neighboring cells in the same row. I…
32696 …o highlight all values in the sheet. Text cells are highlighted in black, cells with numbers in bl…
32701 …k_value\>tab stops; setting in sheets\</bookmark_value\>\<bookmark_value\>cells; cursor positions …
32719 …cells.\</ahelp\> I f, for example, the contents of the selected cell have the bold attribute, this…
32722 …_CHECKBOX_RID_SCPAGE_LAYOUT_CB_REPLWARN\"\>Specifies that, when you paste cells from the clipboard…
32724 …nge, where the column or row is inserted, originally spanned at least two cells in the desired dir…
32735 …:EDIT:RID_SCPAGE_USERLISTS:ED_COPYFROM\"\>Defines the spreadsheet and the cells to copy, in order …
32740 …SC:PUSHBUTTON:RID_SCPAGE_USERLISTS:BTN_COPY\"\>Copies the contents of the cells in the \<emph\>Cop…
32749 …OG_RID_SCDLG_COLORROW\" visibility=\"visible\"\>Allows you to copy marked cells to a sort list.\</…
32752 …okmark_value\>\<bookmark_value\>search criteria for database functions in cells\</bookmark_value\>…
32778 …3148814 44 0 rw If \<emph\>Search criteria = and <> must apply to whole cells \</emph\>is not en…
32780 … and <> must apply to whole cells\</emph\> box is marked, $[officename] Calc behaves exactly as MS…
33090 … 0 rw Defines the default settings for character spacing in Asian texts, cells, and drawing objec…
35890 …spreadsheet without resizing the cells, double-click the spreadsheet, and then drag a corner handl…
38133 …at you can use to adjust page margins, tab stops, indents, borders, table cells, and to arrange ob…
39242 …id=\"SW:CHECKBOX:DLG_INSERT_TABLE:CB_BORDER\"\>Adds a border to the table cells.\</ahelp\> 2002…
39961 …BLE_TEXTFLOW:LB_VERTORIENT\"\>Specify the vertical text alignment for the cells in the table.\</ah…
39974 …he cells.\</ahelp\> You can also use a combination of the following %PRODUCTNAME formatting option…
39984 … 0 rw \<ahelp hid=\".uno:Protect\"\>Prevents the contents of the selected cells from being modifie…
39989 …d=\".uno:UnsetCellsReadOnly\"\>Removes the cell protection for all of the cells in the current tab…
40002 …IGHT\"\>Automatically adjusts the row height to match the contents of the cells.\</ahelp\> 2002…
40008 …visible\"\>Automatically adjusts row heights to match the contents of the cells.\</ahelp\> This is…
40033 …sible\"\>Automatically adjusts column widths to match the contents of the cells.\</ahelp\> Changin…
40205 …01.xhp 0 help par_id3145828 4 0 rw Click in a table cell, or select the cells that you want to f…
40505 …BORDER\" visibility=\"visible\"\>Adds a border to the table and the table cells.\</ahelp\> 2002…
40989 …s the cell range in which you want to use the sum function as long as the cells are filled with da…
41166 …rmula appears in the input line. To specify a range of cells in a table, select the desired cells …
41256 …3154411 165 0 rw Example: SUM <A2:C2> displays the sum of the values in cells A2 to C2 2002-0…
41268 … 0 rw \<ahelp hid=\"HID_MN_CALC_SUM\"\>Calculates the sum of the selected cells.\</ahelp\> 2002…
41542 … rw If nothing is selected, the contents of the next cell are deleted. If cells are selected, the …
41777 …ulating Cell Totals in Tables\"\>Calculating the sum of a series of table cells\</link\>\</variabl…
41800 …intext2.xhp 0 help par_id3150528 50 0 rw Enter numbers into some of the cells of the large table…
41801 …ntext2.xhp 0 help par_id3154250 6 0 rw You can perform a calculation on cells in one table and d…
41813 … 0 rw Open a text document, insert two tables, and type numbers in a few cells in both tables. …
42762 …k_value\>page margins on rulers\</bookmark_value\>\<bookmark_value\>table cells;adjusting the widt…
42924 …an add or delete rows or columns in table as well as split or merge table cells using the keyboard…
42933 …ine\>\<defaultinline\>Ctrl\</defaultinline\>\</switchinline\>+A until all cells are selected, and …
42948 …r\guide\table_insert.xhp 0 help par_id3147527 41 0 rw Drag the selected cells into the text docu…
42960 …xhp 0 help par_id3150515 69 0 rw In the spreadsheet, drag to select the cells. 2002-02-02 02:…
42961 …p par_id3150534 40 0 rw Click and hold the mouse button in the selected cells. 2002-02-02 02:…
42966 …>. The cell range is pasted as an OLE object. To edit the contents of the cells, double-click the …
42977 …xhp 0 help par_id3156250 45 0 rw In the spreadsheet, drag to select the cells. 2002-02-02 02:…
42990 …>\<defaultinline\>Ctrl\</defaultinline\>\</switchinline\>+A until all the cells are selected. 2…
42994 …cells; enlarging and reducing in text tables\</bookmark_value\>\<bookmark_value\>text tables; enla…
43007 …zing.xhp 0 help par_id3153140 13 0 rw You can resize the width of table cells and columns, as we…
43012 …ution of table cells\</bookmark_value\>\<bookmark_value\>tables; adapting the width by keyboard\</…
43014 …ect the entire table, and wide cells shrink more than narrow cells. For example, when you widen a …
43016 …de\tablemode.xhp 0 help par_id3149835 12 0 rw When you insert or delete cells, rows or columns i…
43443 …hp 0 help par_idN107CA 0 rw Shows or hides the boundaries around table cells. The boundaries ar…