Lines Matching refs:cells
17197 …cells as the data source for your chart, click inside the cell range, and then choose this command…
18355 …\<bookmark_value\>tables; backgrounds\</bookmark_value\>\<bookmark_value\>cells; backgrounds\</boo…
18441 …uide\borders.xhp 0 help par_id5528427 0 nb Select a block of about 8x8 cells, then choose \<emp…
19646 …0 help par_id3155178 40 0 nb Place the cursor in the cell or select the cells. First, if necessa…
19740 …k_value\>page margins on rulers\</bookmark_value\>\<bookmark_value\>table cells;adjusting the widt…
19915 …cells; merging/splitting\</bookmark_value\> \<bookmark_value\>tables; merging cells\</bookmar…
19926 …alue\> \<bookmark_value\>splitting cells;by keyboard\</bookmark_value\> \<bookmark_value…
19928 …n add or delete rows or columns in tables as well as split or merge table cells using the keyboard…
19942 …LE objects; inserting tables in\</bookmark_value\> \<bookmark_value\>cells;inserting from spr…
19960 …>. The cell range is pasted as an OLE object. To edit the contents of the cells, double-click the …
19999 …cells; enlarging and reducing in text tables\</bookmark_value\>\<bookmark_value\>table cells; enla…
20009 …aultinline\>\</switchinline\> and then click and drag a line to scale all cells right or above the…
20024 …ution of table cells\</bookmark_value\>\<bookmark_value\>tables; adapting the width by keyboard\</…
20026 …de\tablemode.xhp 0 help par_id3149835 12 0 nb When you insert or delete cells, rows or columns i…
20030 …ect the entire table, and wide cells shrink more than narrow cells. For example, when you widen a …
21081 …at you can use to adjust page margins, tab stops, indents, borders, table cells, and to arrange ob…
22998 …\".uno:UnsetCellsReadOnly\"\>Removes the cell protection for all selected cells in the current tab…
36838 …xhp 0 help par_id8266853 0 nb In older versions of the software, empty cells were forced to num…
36875 …using row/column labels\</bookmark_value\> \<bookmark_value\>text in cells; as addressing\</b…
36883 …cells;AutoInput function\</bookmark_value\> \<bookmark_value\>cells; AutoInput function of te…
36911 …xhp 0 help par_id3147340 19 0 nb To stop using AutoFilter, reselect all cells selected in step 1…
36937 …e\>cells; backgrounds\</bookmark_value\> \<bookmark_value\>rows, see also cells\</bookmark_va…
36952 …alue\>cells;borders\</bookmark_value\> \<bookmark_value\>line arrangements with cells\</bookm…
36979 …guide\borders.xhp 0 help par_id622577 0 nb Select a block of about 8x8 cells, then choose \<emp…
37011 …ark_value\>dates; in cells\</bookmark_value\> \<bookmark_value\>times; in cells\</bookmark_va…
37023 …cells; filling automatically\</bookmark_value\> \<bookmark_value\>automatic cell filling\</bo…
37034 … 0 nb If you select two or more adjacent cells that contain different numbers, and drag, the rem…
37035 … the first column. Now enter some values into B1 and C1. Select those two cells, and double-click …
37082 …cells and sheets\</bookmark_value\> \<bookmark_value\>cells; protecting\</bookmark_value\> …
37086 …cells with the \<emph\>Protected\</emph\> attribute is only effective when you protect the whole s…
37091 …ph\>Protected\</emph\> to allow the user to change the currently selected cells. 20130618 17:22…
37094 …t \<emph\>Hide when printing\</emph\> to hide protected cells in the printed document. The cells a…
37097 …t\scalc\guide\cell_protect.xhp 0 help par_idN106C0 0 nb To protect the cells from being changed…
37104 …\<bookmark_value\>protecting; unprotecting cells\</bookmark_value\> \<bookmark_value\>unprote…
37111 …cells; copying/deleting/formatting/moving\</bookmark_value\> \<bookmark_value\>rows;visible a…
37124 …0 nb \<bookmark_value\>drag and drop; referencing cells\</bookmark_value\> \<bookmark_value\>…
37126 …Navigator you can reference cells from one sheet to another sheet in the same document or in a dif…
37128 … par_id3154011 26 0 nb To set the source range as the range, select the cells and choose \<emph\…
37136 … \<bookmark_value\>references; to cells in other sheets/documents\</bookmark_value\> \<boo…
37156 …value\>HTML; in sheet cells\</bookmark_value\>\<bookmark_value\>references; URL in cells\</bookmar…
37171 … help par_id3151385 15 0 nb If you would like to apply a formula to all cells in a selected area…
37182 … 0 nb \<bookmark_value\>conditional formatting; cells\</bookmark_value\> \<bookmark_value\>…
37184 …to three conditions per cell, which must be met in order for the selected cells to have a particul…
37195 …de\cellstyle_conditional.xhp 0 help par_id3149565 41 0 nb In one of the cells enter the formula …
37226 …\guide\cellstyle_minusvalue.xhp 0 help par_id3155600 34 0 nb Select the cells and choose \<emph\…
37248 …ther \<emph\>Row labels\</emph\> or \<emph\>Column labels\</emph\> if the cells of the source data…
37317 …nb If, under \<item type=\"menuitem\"\>Language\</item\>, you convert the cells to "English (US)",…
37415 …apilot_grouping.xhp 0 help par_idN10667 0 nb Select a cell or range of cells in the pivot table…
37417 …g.xhp 0 help par_idN1066E 0 nb Depending on the format of the selected cells, either a new grou…
37532 … \<bookmark_value\>number formats; adding/deleting decimal places in cells\</bookmark_value\>…
37594 … are editing a formula with references, the references and the associated cells will be highlighte…
37668 …cells; changing text/number formats\</bookmark_value\> \<bookmark_value\>formats; changing te…
37729 …cells; selecting\</bookmark_value\> \<bookmark_value\>marking cells\</bookmark_value\> \…
37736 …par_id3149959 5 0 nb Pressing the mouse button, drag a range across two cells, do not release th…
37740 … STD / EXT / ADD area in the status bar until it shows ADD. Now click all cells that you want to s…
37803 …nter a formula to calculate a result from values that are stored in other cells. Then, you set up …
37853 …cells\</bookmark_value\> \<bookmark_value\>cells;comments\</bookmark_value\> \<bookmark_…
37867 …_text.xhp 0 help par_id0908200901265127 0 nb Calc converts text inside cells to the respective …
37882 …not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a converti…
37889 …</bookmark_value\>\<bookmark_value\>cells; printing grids\</bookmark_value\>\<bookmark_value\>bord…
37929 …help par_id3764763 0 nb \<emph\>Selected cells\</emph\> - All selected cells are…
38140 …cells; merging/unmerging\</bookmark_value\> \<bookmark_value\>tables; merging cells\</bookmar…
38176 …lue\>cells; rotating text\</bookmark_value\> \<bookmark_value\>rotating; text in cells\</book…
38221 …cells; validity\</bookmark_value\>\<bookmark_value\>error messages; defining for incorrect input\<…
38777 …80000.xhp 0 help par_id3145785 0 nb Text cells are formatted in black, formulas in green, and n…
39017 … you write the criteria in different rows they are connected by OR. Empty cells in the search crit…
39101 …;sums in Calc databases\</bookmark_value\> \<bookmark_value\>sums;cells in Calc databases\…
39789 …/bookmark_value\>\<bookmark_value\>counting;empty cells\</bookmark_value\>\<bookmark_value\>empty …
39794 …\04060106.xhp 0 help par_id3149512 46 0 nb Returns the number of empty cells in the cell range …
39796 …48 0 nb \<item type=\"input\"\>=COUNTBLANK(A1:B2)\</item\> returns 4 if cells A1, A2, B1, and B2…
39981 …p par_id1604663 0 nb \<item type=\"input\"\>=GCD(B1:B3)\</item\> where cells B1, B2, B3 contain…
40248 …> calculates the sum of the three cells. \<item type=\"input\"\>=SUM (A1:E10)\</item\> calculates …
40317 …0 help par_id3143606 498 0 nb \<emph\>Range\</emph\> is the range whose cells are included. 2…
40423 …\>COUNTIF function\</bookmark_value\>\<bookmark_value\>counting;specified cells\</bookmark_value\>…
40429 …mber, an expression or a character string. These criteria determine which cells are counted. You m…
40436 …tains the text \<item type=\"input\"\>>2006\</item\> counts the number of cells in the range A1:A1…
40463 …cells by 10 in the above array, you do not need to apply a formula to each individual cell or valu…
40465 …cells in the same way as in a normal formula, that is, either as zero or as an empty string. For e…
40906 …\>=AREAS((A1:B3;F2;G1))\</item\> returns 3, as it is a reference to three cells and/or areas. Afte…
40927 …is updated in all \<item type=\"productname\"\>%PRODUCTNAME\</item\> Calc cells in which this DDE …
40991 …elp hid=\"HID_FUNC_SVERWEIS\"\>Vertical search with reference to adjacent cells to the right.\</ah…
41123 … 0 help par_id0907200912224576 0 nb The number 0 is returned for empty cells and matrix element…
41638 …p 0 help par_id3145202 103 0 nb Number of the following elements. Empty cells are not counted or…
41682 …p 0 help par_id3148621 147 0 nb Number of the following elements. Empty cells are not counted or…
41729 …p 0 help par_id3150647 194 0 nb Number of the following elements. Empty cells are not counted or…
42673 …<emph\>Values\</emph\> corresponds to the array or the cell reference for cells whose content corr…
42780 …060181.xhp 0 help par_id3148728 10 0 nb To calculate the intercept, use cells D3:D9 as the y val…
43168 …or was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN…
43197 …or was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN…
43621 …149024 61 0 nb These operators return a cell range of zero, one or more cells. 20130618 17:22…
43633 … 71 0 nb Calculates the sum of all cells in the intersection; in this example, the result yields…
43731 …ookmark_value\>attributes;cells\</bookmark_value\>\<bookmark_value\>formatting;cells\</bookmark_va…
43779 …3145748 4 0 nb To show all hidden cells, first click in the field in the upper left corner. This…
43819 …the first cell of the original cell range. Merged cells cannot be merged a second time with other …
43820 helpcontent2 source\text\scalc\01\05060000.xhp 0 help par_id3149665 3 0 nb If the cells to be mer…
43833 …BOX:RID_SCPAGE_TABLE:BTN_GRID\"\>Prints out the borders of the individual cells as a grid.\</ahelp…
43879 … range manually, Calc assigns an automatic print range to include all the cells that are not empty…
43927 …r a certain range to format the whole range. Repeat this action for other cells and ranges. 201…
43948 …\"\>Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of pre…
43990 …: Cell style Result (The corresponding value limits must already exist in cells B20 and B21). 2…
43991 …)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the …
43998 …alc\01\06020000.xhp 0 help hd_id3153192 4 0 nb Hyphenation for selected cells. 20130618 17:22…
43999 helpcontent2 source\text\scalc\01\06020000.xhp 0 help par_id3150868 5 0 nb Select the cells for w…
44008 …s search\</bookmark_value\> \<bookmark_value\>searching; links in cells\</bookmark_value\>…
44010 …tive, you can trace the dependencies from the current formula cell to the cells in the spreadsheet…
44016 … in the sheet with marking arrows. At the same time, the range of all the cells contained in the f…
44017 …hen you repeat this command, the tracer arrows are drawn to the precedent cells of this cell. 2…
44019 …m_id3155628 0 nb \<bookmark_value\>cells; removing precedents\</bookmark_value\>\<bookmark_valu…
44026 helpcontent2 source\text\scalc\01\06030300.xhp 0 help par_id3148948 4 0 nb The area of all cells …
44049 …r, it is possible to enter invalid values or copy invalid values into the cells if the \<emph\>Sto…
44051 helpcontent2 source\text\scalc\01\06030900.xhp 0 help bm_id3152349 0 nb \<bookmark_value\>cells;…
44091 …, if the \<emph\>Copy back\</emph\> is option is not selected, and if the cells are not protected.…
44092 …elected, if the \<emph\>Copy back\</emph\> option is selected, and if the cells are not protected.…
44095 …h\> Protect Document \</emph\>command prevents changes from being made to cells in the sheets or t…
44102 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3149664 5 0 nb To protect cells from …
44103 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3154490 8 0 nb Unprotected cells or c…
44104 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3149123 16 0 nb Select the cells that…
44127 helpcontent2 source\text\scalc\01\06070000.xhp 0 help par_id3145173 3 0 nb All cells are recalcul…
44275 … is set to '=' EQUAL or '<>' UNEQUAL. This also applies to the respective cells that you reference…
44339 … hid=\".uno:TableOperationDialog\"\>Applies the same formula to different cells, but with differen…
44341 …et containing multiple operations to Microsoft Excel, the location of the cells containing the for…
44344 …EDIT:RID_SCDLG_TABOP:ED_FORMULARANGE\"\>Enter the cell references for the cells containing the for…
44431 … 0 help par_id3147363 27 0 nb The cells for the 1st and 2nd quarters each contain a sum formula …
44451 …00.xhp 0 help par_id3125865 8 0 nb \<ahelp hid=\".\"\>Uses the selected cells as the data source…
44704 …e, or as a named range. The range may consist of one column or one row of cells. If you specify a …
44710 …\>Tools - Detective - Mark invalid Data\</emph\>, this defines that blank cells are shown as inval…
44765 …l containing the DATE function is the date format, but you can format the cells with any other num…
44983 …alc/01/func_weeknum.xhp\"\>WEEKNUM\</link\> function, or format your date cells using the WW forma…
45050 …"hidden\"\>Click to shrink or restore the dialog. You can click or select cells in the sheet. You …
45056 …ted in a rectangular cell range that you enter in the \<emph\>By changing cells\</emph\> box. …
45057 …tions that set constraints for some cells. For example, you can set the constraint that one of the…
45074 …log, where you enter settings to expand the contents of selected cells to multiple cells. \</varia…
45075 …lumns.xhp 0 help hd_id9599597 0 nb To expand cell contents to multiple cells 20130618 17:22:…
45076 … help par_id2021546 0 nb You can expand cells that contain comma separated values (CSV) into mu…
45081 …iew shows how the current cell contents will be transformed into multiple cells. 20130618 17:22…
45213 …xt\scalc\04\01020000.xhp 0 help par_id3166426 4 0 nb To select multiple cells in different areas…
46863 …cells\</bookmark_value\> \<bookmark_value\>cells; line breaks\</bookmark_value\> \<bookm…
49798 helpcontent2 source\text\shared\00\00000207.xhp 0 help hd_id783149793 0 nb Quote all text cells …
49799 …xports all text cells with leading and trailing quote characters as set in the Text delimiter box.…
49845 …4995711 0 nb \<ahelp hid=\".\"\>When this option is enabled, fields or cells whose values are q…
51657 …pl\"\>\<caseinline select=\"CALC\"\>Inserts comments that are attached to cells. If you want to ad…
51667 …the clipboard cells to the values in the target cells. Also, if the clipboard only contains commen…
51760 … the characters that you specify in the comments that are attached to the cells.\</caseinline\>\</…
51761 … the characters that you specify in the comments that are attached to the cells.\</ahelp\> 2013…
51763 …l\"\>\<caseinline select=\"CALC\"\>Determines the order for searching the cells.\</caseinline\>\</…
51858 …001.xhp 0 help par_id952368773 0 nb ^([:digit:])$ -- finds lines or cells with exactly one d…
53092 …par_id3153124 2 0 nb \<ahelp hid=\".\"\>Set the typographic options for cells or paragraphs in A…
53233 … footers, text frames, tables, table cells, sections, and indexes.\</caseinline\>\<caseinline sele…
53380 …pl\"\>\<caseinline select=\"CALC\"\>Specify the alignment options for the cells on a printed page.…
53383 …\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Centers the cells horizontally on th…
53386 …\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Centers the cells vertically on the …
54398 ….\" visibility=\"hidden\"\>Select database records. Drag-and-drop rows or cells to the document to…
59467 …cells will be formatted as in Writer versions prior to StarOffice 8 or OpenOffice.org 2.0. If the …
59557 …cells; showing grid lines (Calc)\</bookmark_value\> \<bookmark_value\>borders; cells on sc…
59563 …GE_CONTENT_CB_GRID\"\>Specifies whether to display grid lines between the cells.\</ahelp\>\<switch…
59585 …n different colors, depending on type. Text cells are formatted in black, formulas in green, and n…
59668 …lue\> \<bookmark_value\>search criteria for database functions in cells\</bookmark_value\>…
59730 … of decimal places that are shown by default for cells with General number format. If not enabled,…