Lines Matching refs:cells
9129 …okmark_value\>deleting; cell contents\</bookmark_value\>\<bookmark_value\>cells; deleting contents…
9154 …cells; deleting cells\</bookmark_value\>\<bookmark_value\>columns; deleting\</bookmark_value\>\<bo…
9183 …calc\01\02180000.xhp 0 help par_id2282479 0 tg When you copy and paste cells containing \<link …
9255 …eadsheets; inserting cells\</bookmark_value\>\<bookmark_value\>cells; inserting\</bookmark_value\>…
9376 …lculating;sums in Calc databases\</bookmark_value\>\<bookmark_value\>sums;cells in Calc databases\…
9577 …calc\01\04060102.xhp 0 help par_id1953489 0 tg When you copy and paste cells containing date va…
9865 …LA function\</bookmark_value\>\<bookmark_value\>formula cells;displaying formulas in other cells\<…
9867 …ark_value\>\<bookmark_value\>recognizing formula cells\</bookmark_value\>\<bookmark_value\>formula…
9875 …alue\>cell information\</bookmark_value\>\<bookmark_value\>information on cells\</bookmark_value\>…
9878 …mark_value\>blank cell contents\</bookmark_value\>\<bookmark_value\>empty cells; recognizing\</boo…
10215 …/bookmark_value\>\<bookmark_value\>counting;empty cells\</bookmark_value\>\<bookmark_value\>empty …
10256 …\>COUNTIF function\</bookmark_value\>\<bookmark_value\>counting;specified cells\</bookmark_value\>…
10440 helpcontent2 source\text\scalc\01\04060106.xhp 0 help par_id1604663 0 tg GCD(B1:B3) where cells …
10726 …26 548 0 tg \<ahelp hid=\"HID_FUNC_ZAEHLENWENN\"\>Returns the number of cells that meet with cer…
11048 …cells in the same way as in a normal formula, that is, either as zero or as an empty string. For e…
11304 …elp hid=\"HID_FUNC_SVERWEIS\"\>Vertical search with reference to adjacent cells to the right.\</ah…
11413 …alc\01\04060110.xhp 0 help bm_id3145389 0 tg \<bookmark_value\>text in cells; functions\</bookm…
11774 …p 0 help par_id3145202 103 0 tg Number of the following elements. Empty cells are not counted or…
11811 …p 0 help par_id3148621 147 0 tg Number of the following elements. Empty cells are not counted or…
11866 …p 0 help par_id3150647 194 0 tg Number of the following elements. Empty cells are not counted or…
12304 …n quotation marks or as a reference. If you enter the units of measure in cells, they must corresp…
13846 …ookmark_value\>attributes;cells\</bookmark_value\>\<bookmark_value\>formatting;cells\</bookmark_va…
14121 …cell links search\</bookmark_value\>\<bookmark_value\>searching; links in cells\</bookmark_value\>…
14126 …bm_id3155628 0 tg \<bookmark_value\>cells; tracing precedents\</bookmark_value\>\<bookmark_valu…
14132 …m_id3155628 0 tg \<bookmark_value\>cells; removing precedents\</bookmark_value\>\<bookmark_valu…
14136 helpcontent2 source\text\scalc\01\06030300.xhp 0 help bm_id3153252 0 tg \<bookmark_value\>cells;…
14142 helpcontent2 source\text\scalc\01\06030400.xhp 0 help bm_id3147335 0 tg \<bookmark_value\>cells;…
14146 helpcontent2 source\text\scalc\01\06030500.xhp 0 help bm_id3153088 0 tg \<bookmark_value\>cells;…
14150 helpcontent2 source\text\scalc\01\06030600.xhp 0 help bm_id3153561 0 tg \<bookmark_value\>cells;…
14154 …9 0 tg \<bookmark_value\>cells; trace fill mode\</bookmark_value\>\<bookmark_value\>traces; pre…
14159 helpcontent2 source\text\scalc\01\06030800.xhp 0 help bm_id3153821 0 tg \<bookmark_value\>cells;…
14164 helpcontent2 source\text\scalc\01\06030900.xhp 0 help bm_id3152349 0 tg \<bookmark_value\>cells;…
14171 helpcontent2 source\text\scalc\01\06031000.xhp 0 help bm_id3154515 0 tg \<bookmark_value\>cells;…
14489 …alue\>showing; sheet details\</bookmark_value\>\<bookmark_value\>grouping;cells\</bookmark_value\>…
15161 …ormatIncDecimals\"\>Adds one decimal place to the numbers in the selected cells.\</ahelp\> 2002…
15165 …DecDecimals\"\>Removes one decimal place from the numbers in the selected cells.\</ahelp\> 2002…
15500 …ulas; using row/column labels\</bookmark_value\>\<bookmark_value\>text in cells; as addressing\</b…
15508 …cells;AutoInput function\</bookmark_value\>\<bookmark_value\>cells; AutoInput function of text\</b…
15568 …ookmark_value\>cells;borders\</bookmark_value\>\<bookmark_value\>line arrangement;cells\</bookmark…
15627 …<bookmark_value\>dates; in cells\</bookmark_value\>\<bookmark_value\>times; in cells\</bookmark_va…
15639 …cells; filling automatically\</bookmark_value\>\<bookmark_value\>auto filling cells\</bookmark_val…
15682 …cells and sheets\</bookmark_value\>\<bookmark_value\>cells; protecting\</bookmark_value\>\<bookmar…
15686 …cells with the \<emph\>Protected\</emph\> attribute is only effective when you protect the whole t…
15691 …ther the cells are protected against accidental changes, whether the formulas can be viewed, wheth…
15700 …ssword, you cannot deactivate the protection. If you only want to protect cells from changes, do n…
15702 …e\>\<bookmark_value\>protecting; unprotecting cells\</bookmark_value\>\<bookmark_value\>unprotecti…
15709 …cells; copying, deleting, formatting\</bookmark_value\>\<bookmark_value\>rows;visible and invisibl…
15722 … 0 tg \<bookmark_value\>drag and drop; referencing cells\</bookmark_value\>\<bookmark_value\>cel…
15734 …rk_value\>\<bookmark_value\>references; to cells in another document\</bookmark_value\>\<bookmark_…
15752 …value\>HTML; in sheet cells\</bookmark_value\>\<bookmark_value\>references; URL in cells\</bookmar…
15778 …63 0 tg \<bookmark_value\>conditional formatting; cells\</bookmark_value\>\<bookmark_value\>cel…
15903 …cells; currency formats\</bookmark_value\>\<bookmark_value\>international currency formats\</bookm…
16093 …cells; formatting\</bookmark_value\>\<bookmark_value\>spreadsheets;formatting\</bookmark_value\>\<…
16106 …alue\>\<bookmark_value\>number formats; adding/deleting decimal places in cells\</bookmark_value\>…
16169 …xhp 0 help bm_id3153195 0 tg \<bookmark_value\>formulas; displaying in cells\</bookmark_value\>…
16240 …>cells; changing text/number formats\</bookmark_value\>\<bookmark_value\>formats; changing text/nu…
16301 …cells; selecting\</bookmark_value\>\<bookmark_value\>marking cells\</bookmark_value\>\<bookmark_va…
16389 …cells\</bookmark_value\>\<bookmark_value\>cells;notes\</bookmark_value\>\<bookmark_value\>comments…
16401 …</bookmark_value\>\<bookmark_value\>cells; printing grids\</bookmark_value\>\<bookmark_value\>bord…
16463 …cells\</bookmark_value\>\<bookmark_value\>printing; cells\</bookmark_value\>\<bookmark_value\>rang…
16489 …s\</bookmark_value\>\<bookmark_value\>references; to cells\</bookmark_value\>\<bookmark_value\>cel…
16528 …cells\</bookmark_value\>\<bookmark_value\>cell heights\</bookmark_value\>\<bookmark_value\>cell wi…
16621 …e\>superscript text in cells\</bookmark_value\>\<bookmark_value\>subscript text in cells\</bookmar…
16630 …cells; merging/unmerging\</bookmark_value\>\<bookmark_value\>tables; merging cells\</bookmark_valu…
16666 …ark_value\>cells; rotating text\</bookmark_value\>\<bookmark_value\>rotating; text in cells\</book…
16676 …cells; multi-line\</bookmark_value\>\<bookmark_value\>cells; text breaks\</bookmark_value\>\<bookm…
16712 …cells; validity\</bookmark_value\>\<bookmark_value\>error messages; defining for incorrect input\<…
16724 …ues such as "12:00" or serial time numbers. "Text Length" stipulates that cells are allowed to con…
16727 …teria\</emph\> tab page, enter the conditions for new values entered into cells. Values you have a…
16735 …d3147434 0 tg \<bookmark_value\>cells; defining names\</bookmark_value\>\<bookmark_value\>names…
19948 …e\>\<bookmark_value\>number of sheets\</bookmark_value\>\<bookmark_value\>cells;number of\</bookma…
19968 …g \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Number of cells with content in th…
20248 …\<bookmark_value\>cell ranges;pasting\</bookmark_value\>\<bookmark_value\>cells;pasting\</bookmark…
20250 …\<caseinline select=\"CALC\"\>In a spreadsheet, when you paste a range of cells from the clipboard…
20265 … \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Skip empty cells \</caseinline\>\</…
20281 …ppl\"\>\<caseinline select=\"CALC\"\>Set the shift options for the target cells when the clipboard…
20283 …"\>\<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSFORMULAS\"\>Inserts cells containing formula…
20285 …o that changes made to the cells in the source file are updated in the target file. To ensure that…
20290 …HECKBOX:RID_SCDLG_INSCONT:BTN_SKIP_EMPTY\"\>Empty cells from the clipboard do not replace target c…
20291 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing text st…
20295 …CALC\"\>This dialog appears in Calc if the clipboard contains spreadsheet cells. \</caseinline\>\<…
20296 …<caseinline select=\"CALC\"\>Select the operation to apply when you paste cells into your sheet. \…
20297 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing numbers…
20299 …lect=\"appl\"\>\<caseinline select=\"CALC\"\>Target cells are shifted downward when you insert cel…
20300 … select=\"CALC\"\>Subtracts the values in the clipboard cells from the values in the target cells.…
20301 …line select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserted cells replace the target cells. \</ca…
20302 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing date an…
20303 …cells \</emph\>box, empty cells in the clipboard are treated as zeroes. For example, if you apply …
20304 …select=\"CALC\"\>Multiplies the values in the clipboard cells with the values in the target cells.…
20305 …line select=\"CALC\"\>Divides the values in the target cells by the values in the clipboard cells.…
20307 …"appl\"\>\<caseinline select=\"CALC\"\>Inserts notes that are attached to cells. If you want to ad…
20308 …in the clipboard cells to the values in the target cells. Also, if the clipboard only contains not…
20309 …ct=\"appl\"\>\<caseinline select=\"CALC\"\>Target cells are shifted to the right when you insert c…
20314 …line select=\"appl\"\> \<caseinline select=\"CALC\"\>To select all of the cells on a sheet, click …
20356 …\"SVX:CHECKBOX:RID_SVXDLG_SEARCH:BTN_CELLS\"\>Searches for whole words or cells that are identical…
20363 …select=\"appl\"\>\<caseinline select=\"CALC\"\>Searches only the selected cells. \</caseinline\>\<…
20367 …for the characters that you specify in the notes that are attached to the cells. \</caseinline\>\<…
20372 …l\"\>\<caseinline select=\"CALC\"\>Determines the order for searching the cells. \</caseinline\>\<…
20803 …changes command is active, you cannot delete, move, merge, split, or copy cells or delete sheets. …
20859 …g \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Lists the cells with contents that…
20903 …hid=\"SC:IMAGEBUTTON:RID_SCDLG_SIMPLEREF:RB_ASSIGN\"\>Select the range of cells that you want to u…
20910 … 0 tg \<ahelp hid=\"HID_REDLINING_FILTER_BTN_REF\"\>Select the range of cells that you want to u…
20911 …ters the list of changes according to the range of cells that you specify. To select a range of ce…
20969 …ine select=\"CALC\"\>Resizes the display to fit the width of the selected cells. \</caseinline\>\<…
21144 …<bookmark_value\>deleting; hyperlinks\</bookmark_value\>\<bookmark_value\>cells;resetting formats\…
21170 …help par_id3153770 59 0 tg You can only change the language setting for cells (choose \<emph\>Fo…
21225 …mark_value\>numbers; formatting options for selected cells\</bookmark_value\>\<bookmark_value\>cel…
21243 …VXPAGE_NUMBERFORMAT_CB_SOURCEFORMAT\"\>Uses the same number format as the cells containing the dat…
21256 …cells\</caseinline\>\<defaultinline\>fields\</defaultinline\>\</switchinline\>. With the language …
21316 …01.xhp 0 help par_id3147318 99 0 tg The default currency format for the cells in your spreadshee…
21388 …e select=\"CALC\"\>If you perform a calculation that involves one or more cells using a date forma…
21587 …par_id3153124 2 0 tg \<ahelp hid=\".\"\>Set the typographic options for cells or paragraphs in A…
21711 …\<ahelp hid=\"700793922\"\>Merges two different border styles of adjacent cells in a Writer table …
21712 … a blue border of 3 point width, then the common border between these two cells will be blue with …
21738 …footers, text frames, tables, table cells, sections, and indexes. \</caseinline\>\<caseinline sele…
21868 …\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Centers the cells vertically on the …
21871 …pl\"\>\<caseinline select=\"CALC\"\>Specify the alignment options for the cells on a printed page.…
21883 …\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Centers the cells horizontally on th…
22045 helpcontent2 source\text\shared\01\05100100.xhp 0 help par_id3153718 3 0 tg Merging cells can lea…
22054 …\".uno:SplitCell\"\>Splits the cell or group of cells horizontally or vertically into the number o…
22061 …id3154638 12 0 tg \<ahelp hid=\"SW_CHECKBOX_DLG_SPLIT_CB_PROP\"\>Splits cells into rows of equal…
22787 …elp bm_id3154545 0 tg \<bookmark_value\>aligning; cells\</bookmark_value\>\<bookmark_value\>cel…
22830 …e alignment options for the contents of the current cell, or the selected cells.\</ahelp\> 2002…
25150 …cells\</bookmark_value\>\<bookmark_value\>list contents;controls\</bookmark_value\>\<bookmark_valu…
25244 … hid=\".\"\>Check boxes and radio buttons in Spreadsheets can be bound to cells in the current doc…
25772 …mph\>icon to increase the indentation of the cell content of the selected cells.\</caseinline\>\</…
28850 …p hid=\"SID_TABLEDESIGN_INSERTROWS\"\>Inserts rows in front of the marked cells.\</ahelp\> 2002…
30166 …\<bookmark_value\>tables; backgrounds\</bookmark_value\>\<bookmark_value\>cells; backgrounds\</boo…
30206 …cells\</bookmark_value\>\<bookmark_value\>cells; line breaks\</bookmark_value\>\<bookmark_value\>t…
30301 …cells\</bookmark_value\>\<bookmark_value\>inserting; cell ranges from spreadsheets\</bookmark_valu…
31542 …ment that contains VBA macro code. Change only the normal contents (text, cells, graphics), and do…
31620 …xhp 0 help par_idN106EC 0 tg Text within drawing object or within Calc cells is selected 200…
31622 …t\shared\guide\paintbrush.xhp 0 help par_idN106F9 0 tg Writer table or cells are selected 20…
31624 …ext\shared\guide\paintbrush.xhp 0 help par_idN10706 0 tg Calc table or cells are selected 20…
31639 …preadsheet cells, then a different \<emph\>Paste Special\</emph\> dialog appears. Use the \<emph\>…
31641 …: pastes the cell range as a link. If the source file changes, the pasted cells change also. 20…
31688 …nprotecting\</bookmark_value\>\<bookmark_value\>tables in text;protecting cells\</bookmark_value\>…
31769 … Changes in a spreadsheet document are highlighted by a border around the cells; when you point to…
33510 …cells; showing grid lines (Calc)\</bookmark_value\>\<bookmark_value\>borders; cells on screen (Cal…
33567 …k_value\>tab stops; setting in sheets\</bookmark_value\>\<bookmark_value\>cells; cursor positions …
33618 …okmark_value\>\<bookmark_value\>search criteria for database functions in cells\</bookmark_value\>…
39528 …at you can use to adjust page margins, tab stops, indents, borders, table cells, and to arrange ob…
40640 …id=\"SW:CHECKBOX:DLG_INSERT_TABLE:CB_BORDER\"\>Adds a border to the table cells.\</ahelp\> 2002…
41362 …BLE_TEXTFLOW:LB_VERTORIENT\"\>Specify the vertical text alignment for the cells in the table.\</ah…
41375 …he cells.\</ahelp\> You can also use a combination of the following %PRODUCTNAME formatting option…
41385 … 0 tg \<ahelp hid=\".uno:Protect\"\>Prevents the contents of the selected cells from being modifie…
41390 …d=\".uno:UnsetCellsReadOnly\"\>Removes the cell protection for all of the cells in the current tab…
41403 …IGHT\"\>Automatically adjusts the row height to match the contents of the cells.\</ahelp\> 2002…
41409 …visible\"\>Automatically adjusts row heights to match the contents of the cells.\</ahelp\> This is…
41434 …sible\"\>Automatically adjusts column widths to match the contents of the cells.\</ahelp\> Changin…
41606 …01.xhp 0 help par_id3145828 4 0 tg Click in a table cell, or select the cells that you want to f…
41907 …DLG_CONV_TEXT_TABLE:CB_BORDER\"\>Adds a border to the table and the table cells.\</ahelp\> 2002…
42400 …ME\</item\> recognizes the cell range for the sum function as long as the cells are filled with nu…
42577 …rmula appears in the input line. To specify a range of cells in a table, select the desired cells …
42667 …3154411 165 0 tg Example: SUM <A2:C2> displays the sum of the values in cells A2 to C2 2002-0…
42679 … 0 tg \<ahelp hid=\"HID_MN_CALC_SUM\"\>Calculates the sum of the selected cells.\</ahelp\> 2002…
42953 … tg If nothing is selected, the contents of the next cell are deleted. If cells are selected, the …
43203 …er\guide\border_object.xhp 0 help par_id3153896 8 0 tg Select the table cells that you want to m…
43227 … bm_id6737876 0 tg \<bookmark_value\>borders;cells in Writer\</bookmark_value\>\<bookmark_value…
43228 helpcontent2 source\text\swriter\guide\borders.xhp 0 help hd_id3547166 0 tg Selection of cells …
43235 …368 0 tg You can apply a variety of different cell borders to selected cells in a Writer table …
43237 …de\borders.xhp 0 help par_id1108432 0 tg Depending on the selection of cells, the area looks di…
43240 …d1454512 0 tg A black line sets the corresponding line of the selected cells. The line is shown…
43247 … 0 help par_id2210760 0 tg All cells in a Writer table have at least a left and a lower line by…
43248 … 0 tg A white line is shown when the corresponding line of the selected cells will be removed. …
43265 …uide\borders.xhp 0 help par_id5528427 0 tg Select a block of about 8x8 cells, then choose \<emp…
43267 …ide\borders.xhp 0 help par_id5741752 0 tg A whole table of 2x2 or more cells selected 2002-0…
43272 …de\borders.xhp 0 help par_id6527298 0 tg Select the cell or a block of cells in a Writer table.…
43281 … 0 tg A gray line is shown when the corresponding line of the selected cells will not be change…
43290 …ext\swriter\guide\calculate.xhp 0 help par_id8316904 0 tg To reference cells in a Writer text t…
43300 …sums\</bookmark_value\>\<bookmark_value\>cells;calculating sums\</bookmark_value\>\<bookmark_value…
43301 …ulating Cell Totals in Tables\"\>Calculating the sum of a series of table cells\</link\>\</variabl…
43324 …intext2.xhp 0 help par_id3150528 50 0 tg Enter numbers into some of the cells of the large table…
43325 …ntext2.xhp 0 help par_id3154250 6 0 tg You can perform a calculation on cells in one table and d…
43337 … 0 tg Open a text document, insert two tables, and type numbers in a few cells in both tables. …
44372 …n.xhp 0 help par_id3145643 38 0 tg Place the cursor in a cell or select cells. Choose \<emph\>Fo…
44387 …0 help par_id3154480 36 0 tg You can protect the contents of individual cells of a \<item type=\…
44388 …0 help par_id3155178 40 0 tg Place the cursor in the cell or select the cells. First, if necessa…
44391 …ot intended to be a secure protection. It is just a switch to protect the cells against accidentia…
44469 …k_value\>page margins on rulers\</bookmark_value\>\<bookmark_value\>table cells;adjusting the widt…
44629 …cells; merging/splitting\</bookmark_value\>\<bookmark_value\>tables; merging cells\</bookmark_valu…
44633 …n select adjacent cells, then merge them into a single cell. Conversely, you can take a large cell…
44636 …uide\table_cellmerge.xhp 0 help par_id5708792 0 tg Select the adjacent cells. 2002-02-02 02:…
44638 …r_id634174 0 tg A dialog allows you to split the cell into two or more cells, horizontally or v…
44640 …ookmark_value\>\<bookmark_value\>splitting cells by keyboard\</bookmark_value\>\<bookmark_value\>m…
44643 …an add or delete rows or columns in table as well as split or merge table cells using the keyboard…
44652 …ine\>\<defaultinline\>Ctrl\</defaultinline\>\</switchinline\>+A until all cells are selected, and …
44667 …r\guide\table_insert.xhp 0 help par_id3147527 41 0 tg Drag the selected cells into the text docu…
44679 …xhp 0 help par_id3150515 69 0 tg In the spreadsheet, drag to select the cells. 2002-02-02 02:…
44680 …p par_id3150534 40 0 tg Click and hold the mouse button in the selected cells. 2002-02-02 02:…
44685 …>. The cell range is pasted as an OLE object. To edit the contents of the cells, double-click the …
44696 …xhp 0 help par_id3156250 45 0 tg In the spreadsheet, drag to select the cells. 2002-02-02 02:…
44709 …>\<defaultinline\>Ctrl\</defaultinline\>\</switchinline\>+A until all the cells are selected. 2…
44713 …cells; enlarging and reducing in text tables\</bookmark_value\>\<bookmark_value\>text tables; enla…
44728 …zing.xhp 0 help par_id3153140 13 0 tg You can resize the width of table cells and columns, as we…
44737 …ution of table cells\</bookmark_value\>\<bookmark_value\>tables; adapting the width by keyboard\</…
44739 …ect the entire table, and wide cells shrink more than narrow cells. For example, when you widen a …
44741 …de\tablemode.xhp 0 help par_id3149835 12 0 tg When you insert or delete cells, rows or columns i…
51277 …ng RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_COUNT_IF 3 0 tg The range of cells on which the crite…