Lines Matching refs:cells
3000 svx source\dialog\srchdlg.src 0 string RID_SVXDLG_SEARCH STR_WORDCALC 126 ps ~Entire cells 201…
4378 svx source\svdraw\svdstr.src 0 string STR_TABLE_SPLIT 0 ps Split cells 20181231 09:50:43
4379 svx source\svdraw\svdstr.src 0 string STR_TABLE_MERGE 0 ps Merge cells 20181231 09:50:43
5703 sw source\ui\table\table.src 0 infobox MSG_ERR_TABLE_MERGE 0 ps Selected table cells are too com…
5708 …FT_TEXT 285 ps If the selected cells do not contain the desired data, select the data range now.…
7071 sw source\ui\config\optdlg.src 0 fixedtext TP_OPTTABLE_PAGE FT_MOVE 100 ps Move cells 20181231…
7148 …D_TABLESPACING 60 ps Add paragraph and table spacing at bottom of table cells 20181231 09:50:…
8456 sc source\ui\docshell\tpstat.src 0 fixedtext RID_SCPAGE_STAT FT_CELLS_LBL 90 ps Number of cells: …
8575 sc source\ui\src\scstring.src 0 string STR_REPLCELLSWARN 0 ps You are pasting data into cells th…
8610 sc source\ui\src\scstring.src 0 itemlist SCSTR_PRINT_OPTIONS 6 0 ps Selected cells 20181231 09…
8625 …AGE_CALC BTN_MATCH 239 ps Search criteria = and <> must apply to ~whole cells 20181231 09:50:…
8957 …mdlg.src 0 checkbox RID_SCDLG_DBNAMES BTN_SIZE 145 ps Insert or delete ~cells 20181231 09:50:…
8975 ….src 0 fixedtext RID_SCDLG_OPTSOLVER FT_VARIABLECELLS 59 ps By changing cells 20181231 09:50:…
9129 …ng RID_GLOBSTR STR_MSSG_PASTEFROMCLIP_1 0 ps Cell merge not possible if cells already merged! …
9130 …ring RID_GLOBSTR STR_MSSG_MOVEBLOCKTO_0 0 ps Cell merge not possible if cells already merged! …
9133 …tring RID_GLOBSTR STR_MSSG_MERGECELLS_0 0 ps Cell merge not possible if cells already merged …
9134 … 0 string RID_GLOBSTR STR_SORT_ERR_MERGED 0 ps Ranges containing merged cells can only be sorted…
9220 sc source\ui\src\globstr.src 0 string RID_GLOBSTR STR_PROTECTIONERR 0 ps Protected cells can not …
9251 …g RID_GLOBSTR STR_MERGE_NOTEMPTY 0 ps Should the contents of the hidden cells be moved into the …
9265 …LID_AFAREA 0 ps To apply an AutoFormat,\na table range of at least\n3x3 cells must be selected. …
9291 …GLOBSTR STR_THESAURUS_NO_STRING 0 ps Thesaurus can only be used in text cells! 20181231 09:50…
9364 sc source\ui\src\globstr.src 0 string RID_GLOBSTR STR_INSERT_FULL 0 ps Filled cells cannot be shi…
9380 …NVALID_OVERFLOW 0 ps The maximum number of invalid cells has been exceeded.\nNot all invalid cel…
9447 …empty. Check the first row of data source to make sure there are no empty cells. 20181231 09:50…
9469 …ring RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_COUNT 1 0 ps Counts the cells of a data range wh…
9471 …ng RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_COUNT 3 0 ps The range of cells containing data. …
9476 …FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_COUNT_2 1 0 ps Counts all non-blank cells of a data range wh…
9478 … RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_COUNT_2 3 0 ps The range of cells containing data. …
9483 …TIONS1.SC_OPCODE_DB_AVERAGE 1 0 ps Returns the average value of all the cells of a data range wh…
9485 … RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_AVERAGE 3 0 ps The range of cells containing data. …
9492 …ring RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_GET 3 0 ps The range of cells containing data. …
9497 …IONS1.SC_OPCODE_DB_MAX 1 0 ps Returns the maximum value from all of the cells of a data range wh…
9499 …ring RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_MAX 3 0 ps The range of cells containing data. …
9504 …NCTION_DESCRIPTIONS1.SC_OPCODE_DB_MIN 1 0 ps Returns the minimum of all cells of a data range wh…
9506 …ring RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_MIN 3 0 ps The range of cells containing data. …
9511 …ID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_PRODUCT 1 0 ps Multiplies all cells of a data range wh…
9513 … RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_PRODUCT 3 0 ps The range of cells containing data. …
9518 …S1.SC_OPCODE_DB_STD_DEV 1 0 ps Calculates the standard deviation of all cells in a data range wh…
9520 … RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_STD_DEV 3 0 ps The range of cells containing data. …
9525 …0 ps Returns the standard deviation with regards to the population of all cells of a data range ma…
9527 …ID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_STD_DEV_P 3 0 ps The range of cells containing data. …
9532 …ring RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_SUM 1 0 ps Adds all the cells of a data range wh…
9534 …ring RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_SUM 3 0 ps The range of cells containing data. …
9539 …ESCRIPTIONS1.SC_OPCODE_DB_VAR 1 0 ps Determines the variance of all the cells in a data range wh…
9541 …ring RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_VAR 3 0 ps The range of cells containing data. …
9546 …OPCODE_DB_VAR_P 1 0 ps Determines variance of a population based on all cells in a data range wh…
9548 …ng RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_DB_VAR_P 3 0 ps The range of cells containing data. …
9797 …SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_IKV 3 0 ps An array or reference to cells whose contents cor…
9802 …C_FUNCTION_DESCRIPTIONS1.SC_OPCODE_MIRR 3 0 ps An array or reference to cells whose contents cor…
9905 …CTION_DESCRIPTIONS1.SC_OPCODE_COUNT_EMPTY_CELLS 1 0 ps Counts the blank cells in a specified ran…
9907 …SCRIPTIONS1.SC_OPCODE_COUNT_EMPTY_CELLS 3 0 ps The range in which empty cells are to be counted.…
9932 …SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_SUM_IFS 1 0 ps Totals the values of cells in a range that me…
9939 …ON_DESCRIPTIONS1.SC_OPCODE_AVERAGE_IFS 1 0 ps Averages the value of the cells that meet multiple…
9946 …ing RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_COUNT_IFS 1 0 ps Counts the cells that meet multiple…
9953 …ng RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_COUNT_IF 3 0 ps The range of cells on which the crite…
10076 …c 0 string RID_SC_FUNCTION_DESCRIPTIONS1.SC_OPCODE_SUB_TOTAL 5 0 ps The cells of the range which…
10657 …TIONS2.SC_OPCODE_H_LOOKUP 1 0 ps Horizontal search and reference to the cells located below. …
10666 …S2.SC_OPCODE_V_LOOKUP 1 0 ps Vertical search and reference to indicated cells. 20181231 09:50…
11089 sc source\ui\src\attrdlg.src 0 fixedtext RID_SCPAGE_PROTECTION FT_HINT2 137 ps The cells selected…
11163 sc source\ui\src\sortdlg.src 0 fixedtext RID_SCDLG_SORT_WARNING FT_TEXT 170 ps The cells next to …
11164 … inside a list and execute sort. The whole range of neighboring non-empty cells will then be sorte…
11172 sc source\ui\src\miscdlgs.src 0 radiobutton RID_SCDLG_DELCELL BTN_CELLSLEFT 114 ps Shift cells ~l…
11173 sc source\ui\src\miscdlgs.src 0 radiobutton RID_SCDLG_DELCELL BTN_CELLSUP 114 ps Shift cells ~up …
11178 sc source\ui\src\miscdlgs.src 0 radiobutton RID_SCDLG_INSCELL BTN_CELLSRIGHT 114 ps Shift cells ~…
11179 sc source\ui\src\miscdlgs.src 0 radiobutton RID_SCDLG_INSCELL BTN_CELLSDOWN 114 ps Shift cells ~d…
11207 sc source\ui\src\miscdlgs.src 0 checkbox RID_SCDLG_INSCONT BTN_SKIP_EMPTY 84 ps S~kip empty cells…
11214 sc source\ui\src\miscdlgs.src 0 fixedline RID_SCDLG_INSCONT FL_MOVE 93 ps Shift cells 20181231…
11370 …rc 0 checkbox TP_VALIDATION_VALUES TSB_ALLOW_BLANKS 174 ps Allow ~empty cells 20181231 09:50:…
11543 …g.src 0 checkbox RID_SCDLG_IMPORTOPT CB_QUOTEALL 164 ps ~Quote all text cells 20181231 09:50:…
11615 …NT CBX_MERGE HID_PROPERTY_PANEL_ALIGN_CBX_MERGE 0 ps ~Merge cells Joins the selected cells into …
11624 …APPEAR STR_QH_BK_COLOR 0 ps Select the background color of the selected cells. 20181231 09:50…
11628 …YPANEL_SC_APPEAR STR_QH_BORDER 0 ps Specify the borders of the selected cells. 20181231 09:50…
11635 …SC_CBOX_SHOWGRID 90 ps Show cell ~grid lines Show the grid lines of the cells in the entire spre…
11838 …CTION BTN_PROTECT 150 ps P~rotect this sheet and the contents of locked cells 20181231 09:50:…
11843 …ing RID_SCDLG_TABPROTECTION ST_SELECT_LOCKED_CELLS 140 ps Select locked cells 20181231 09:50:…
11844 …RID_SCDLG_TABPROTECTION ST_SELECT_UNLOCKED_CELLS 140 ps Select unlocked cells 20181231 09:50:…
12004 …ned cells that span rows as tables with nested tables. In contrast, the wiki model of table is to …
12233 …PTIONS CB_INCLUDE_HIDDEN_CELLS_POLAR 200 ps Include ~values from hidden cells 20181231 09:50:…
12326 …x TP_OPTIONS CB_INCLUDE_HIDDEN_CELLS 200 ps Include ~values from hidden cells 20181231 09:50:…
14156 …nds.UserInterface.Commands..uno:UnsetCellsReadOnly Label 0 ps Unprotect cells 20181231 09:50:…
17307 wizards source\euro\euro.src 0 string STEP_CONVERTER + 3 0 ps Currency cells in the current ~she…
17308 wizards source\euro\euro.src 0 string STEP_CONVERTER + 4 0 ps Currency cells in the entire ~docu…
17311 wizards source\euro\euro.src 0 string STEP_CONVERTER + 7 0 ps Select currency cells 20181231 …
22566 …he \<emph\>Format\</emph\> menu contains commands for formatting selected cells, \<link href=\"tex…
22635 …\"\>The Insert menu contains commands for inserting new elements, such as cells, rows, sheets and …
22679 …N10847 0 ps \<ahelp hid=\".\"\>Applies the date format to the selected cells.\</ahelp\> 2018…
22681 … 0 ps \<ahelp hid=\".\"\>Applies the exponential format to the selected cells.\</ahelp\> 2018…
23353 ….\"\>Inserts a spreadsheet as an OLE object. Enter or paste data into the cells, then click outsid…
23426 …cells as the data source for your chart, click inside the cell range, and then choose this command…
23585 …hp 0 help par_idN107CA 0 ps Shows or hides the boundaries around table cells. The boundaries ar…
31774 …cells\</bookmark_value\>\<bookmark_value\>lists;data assigned to controls\</bookmark_value\>\<book…
31780 … hid=\".\"\>Check boxes and radio buttons in spreadsheets can be bound to cells in the current doc…
33116 …79 0 ps You can create a DDE link using the following procedure: Select cells from a Calc spread…
33231 …4995711 0 ps \<ahelp hid=\".\"\>When this option is enabled, fields or cells whose values are q…
33518 helpcontent2 source\text\shared\00\00000207.xhp 0 help hd_id783149793 0 ps Quote all text cells …
33519 …xports all text cells with leading and trailing quote characters as set in the Text delimiter box.…
34814 helpcontent2 source\text\shared\autopi\01150000.xhp 0 help par_id3152999 36 0 ps Select the cells…
34816 …par_id3145162 38 0 ps \<ahelp hid=\"HID_DLGCONVERT_OPTIONBUTTON1\"\>All cells with the selected …
34817 helpcontent2 source\text\shared\autopi\01150000.xhp 0 help hd_id3152974 39 0 ps Currency cells in…
34818 …4479 40 0 ps \<ahelp hid=\"HID_DLGCONVERT_OPTIONBUTTON2\"\>All currency cells in the active spre…
34819 helpcontent2 source\text\shared\autopi\01150000.xhp 0 help hd_id3156276 41 0 ps Currency cells in…
34820 …6912 42 0 ps \<ahelp hid=\"HID_DLGCONVERT_OPTIONBUTTON3\"\>All currency cells in the active docu…
34822 …IONBUTTON4\"\>All currency cells in the range selected before the converter was called will be con…
35296 …esentations;inserting spreadsheet cells\</bookmark_value\>\<bookmark_value\>text documents;inserti…
35299 …he sheet and then use either the clipboard or drag-and-drop to insert the cells into the text docu…
35300 … ps If you drag cells to the normal view of a presentation document, the cells will be inserted th…
35553 …0 ps In spreadsheets this background appears only in the print behind the cells not formatted else…
35587 …preadsheet cells, then a different \<emph\>Paste Special\</emph\> dialog appears. Use the \<emph\>…
35589 …: pastes the cell range as a link. If the source file changes, the pasted cells change also. 20…
36070 …\shared\guide\paintbrush.xhp 0 help par_idN106EC 0 ps Text within Calc cells is selected 201…
36072 …t\shared\guide\paintbrush.xhp 0 help par_idN106F9 0 ps Writer table or cells are selected 20…
36074 …ext\shared\guide\paintbrush.xhp 0 help par_idN10706 0 ps Calc table or cells are selected 20…
36196 …ment that contains VBA macro code. Change only the normal contents (text, cells, graphics), and do…
36816 …cells\</bookmark_value\> \<bookmark_value\>cells; line breaks\</bookmark_value\> \<bookm…
36818 …_idN106D9 0 ps Inserting line breaks in $[officename] Calc spreadsheet cells 20181231 09:50:…
36822 …aking_lines.xhp 0 help par_idN106E6 0 ps Formatting $[officename] Calc cells for automatic line…
36823 …xt\shared\guide\breaking_lines.xhp 0 help par_idN106ED 0 ps Select the cells for which you want…
37499 …s between Calc and Excel is the handling of boolean values. Enter TRUE to cells A1 and A2. 201…
37589 …red\guide\border_table.xhp 0 help par_id3146957 2 0 ps Select the table cells that you want to m…
37592 …adds\</emph\> the selected style to the current border style of the table cells. Select the blank …
37594 …red\guide\border_table.xhp 0 help par_id3152472 8 0 ps Select the table cells that you want to m…
37606 …insert.xhp 0 help par_id6772972 0 ps Insert a chart based on data from cells in Calc or Writer.…
37625 ….xhp 0 help par_id6944792 0 ps In Writer, if you have not selected any cells, choose \<emph\>In…
37736 … Changes in a spreadsheet document are highlighted by a border around the cells; when you point to…
37900 …cells; showing grid lines (Calc)\</bookmark_value\> \<bookmark_value\>borders; cells on sc…
37906 …GE_CONTENT_CB_GRID\"\>Specifies whether to display grid lines between the cells.\</ahelp\>\<switch…
37920 …B_FORMULA\"\>Specifies whether to show formulas instead of results in the cells.\</ahelp\> 2018…
37928 …n different colors, depending on type. Text cells are formatted in black, formulas in green, and n…
37933 … than the width of the cell, the text is displayed over empty neighboring cells in the same row. I…
38194 …help hid=\"SC_MODALDIALOG_RID_SCDLG_COLORROW\"\>Allows you to copy marked cells to a sort list.\</…
38474 …help hid=\"SW_CHECKBOX_TP_OPTTABLE_PAGE_CB_BORDER\"\>Specifies that table cells have a border by d…
38485 helpcontent2 source\text\shared\optionen\01040500.xhp 0 help hd_id3149018 3 0 ps Move cells 20…
38715 …:EDIT:RID_SCPAGE_USERLISTS:ED_COPYFROM\"\>Defines the spreadsheet and the cells to copy, in order …
38717 …SC:PUSHBUTTON:RID_SCPAGE_USERLISTS:BTN_COPY\"\>Copies the contents of the cells in the \<emph\>Cop…
38847 … 0 ps Defines the default settings for character spacing in Asian texts, cells, and drawing objec…
39425 …k_value\>tab stops; setting in sheets\</bookmark_value\>\<bookmark_value\>cells; cursor positions …
39439 …cells.\</ahelp\> If, for example, the contents of the selected cell have the bold attribute, this …
39441 …nge, where the column or row is inserted, originally spanned at least two cells in the desired dir…
39449 …_CHECKBOX_RID_SCPAGE_LAYOUT_CB_REPLWARN\"\>Specifies that, when you paste cells from the clipboard…
39665 …p par_idN1081B 0 ps Add paragraph and table spacing at bottom of table cells 20181231 09:50:…
39667 …cells will be formatted as in Writer versions prior to StarOffice 8 or OpenOffice.org 2.0. If the …
39688 …p par_idN10985 0 ps Add paragraph and table spacing at bottom of table cells 20181231 09:50:…
39691 …lue\> \<bookmark_value\>search criteria for database functions in cells\</bookmark_value\>…
39734 … help hd_id3152581 32 0 ps Search criteria = and <> must apply to whole cells 20181231 09:50:…
39735 … and <> must apply to whole cells\</emph\> box is marked, $[officename] Calc behaves exactly as MS…
39746 …3148814 44 0 ps If \<emph\>Search criteria = and <> must apply to whole cells \</emph\>is not en…
39753 … of decimal places that are shown by default for cells with General number format. If not enabled,…
40127 …changes command is active, you cannot delete, move, merge, split, or copy cells or delete sheets. …
40198 …CALC\"\>This dialog appears in Calc if the clipboard contains spreadsheet cells. \</caseinline\>\<…
40204 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing text. \…
40206 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing numbers…
40208 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing date an…
40210 …"\>\<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSFORMULAS\"\>Inserts cells containing formula…
40212 …pl\"\>\<caseinline select=\"CALC\"\>Inserts comments that are attached to cells. If you want to ad…
40218 …<caseinline select=\"CALC\"\>Select the operation to apply when you paste cells into your sheet. \…
40222 …the clipboard cells to the values in the target cells. Also, if the clipboard only contains commen…
40224 … select=\"CALC\"\>Subtracts the values in the clipboard cells from the values in the target cells.…
40226 …select=\"CALC\"\>Multiplies the values in the clipboard cells with the values in the target cells.…
40228 …line select=\"CALC\"\>Divides the values in the target cells by the values in the clipboard cells.…
40231 … \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Skip empty cells \</caseinline\>\</…
40232 …HECKBOX:RID_SCDLG_INSCONT:BTN_SKIP_EMPTY\"\>Empty cells from the clipboard do not replace target c…
40233 …cells \</emph\>box, empty cells in the clipboard are treated as zeroes. For example, if you apply …
40237 …o that changes made to the cells in the source file are updated in the target file. To ensure that…
40240 …ppl\"\>\<caseinline select=\"CALC\"\>Set the shift options for the target cells when the clipboard…
40242 …line select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserted cells replace the target cells. \</ca…
40244 …lect=\"appl\"\>\<caseinline select=\"CALC\"\>Target cells are shifted downward when you insert cel…
40246 …ct=\"appl\"\>\<caseinline select=\"CALC\"\>Target cells are shifted to the right when you insert c…
41114 …\"SVX:CHECKBOX:RID_SVXDLG_SEARCH:BTN_CELLS\"\>Searches for whole words or cells that are identical…
41125 …id3150866 48 0 ps \<ahelp hid=\".\"\>Searches only the selected text or cells.\</ahelp\> 2018…
41163 … the characters that you specify in the comments that are attached to the cells.\</caseinline\>\</…
41164 … the characters that you specify in the comments that are attached to the cells.\</ahelp\> 2018…
41166 …l\"\>\<caseinline select=\"CALC\"\>Determines the order for searching the cells.\</caseinline\>\</…
41310 …cells \</caseinline\>\<defaultinline\>fields\</defaultinline\>\</switchinline\>. With the language…
41313 …VXPAGE_NUMBERFORMAT_CB_SOURCEFORMAT\"\>Uses the same number format as the cells containing the dat…
41636 …001.xhp 0 help par_id952368773 0 ps ^([:digit:])$ -- finds lines or cells with exactly one d…
42151 …help par_id3153770 59 0 ps You can only change the language setting for cells (choose \<emph\>Fo…
42312 …\<ahelp hid=\"700793922\"\>Merges two different border styles of adjacent cells in a Writer table …
42313 … a blue border of 3 point width, then the common border between these two cells will be blue with …
42451 …elp bm_id3154545 0 ps \<bookmark_value\>aligning; cells\</bookmark_value\>\<bookmark_value\>cel…
42453 …e alignment options for the contents of the current cell, or the selected cells.\</ahelp\> 2018…
42509 …par_id3153124 2 0 ps \<ahelp hid=\".\"\>Set the typographic options for cells or paragraphs in A…
42736 …\".uno:SplitCell\"\>Splits the cell or group of cells horizontally or vertically into the number o…
42747 …id3154638 12 0 ps \<ahelp hid=\"SW_CHECKBOX_DLG_SPLIT_CB_PROP\"\>Splits cells into rows of equal…
43008 …<bookmark_value\>deleting; hyperlinks\</bookmark_value\>\<bookmark_value\>cells;resetting formats\…
43223 …pl\"\>\<caseinline select=\"CALC\"\>Specify the alignment options for the cells on a printed page.…
43224 …200809473845 0 ps \<ahelp hid=\".\" visibility=\"hidden\"\>Centers the cells horizontally on th…
43226 …\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Centers the cells horizontally on th…
43227 …200809473811 0 ps \<ahelp hid=\".\" visibility=\"hidden\"\>Centers the cells vertically on the …
43229 …\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Centers the cells vertically on the …
43314 … footers, text frames, tables, table cells, sections, and indexes.\</caseinline\>\<caseinline sele…
43368 …>\<bookmark_value\>clipboard; pasting\</bookmark_value\>\<bookmark_value\>cells;pasting\</bookmark…
43371 …\<caseinline select=\"CALC\"\>In a spreadsheet, when you paste a range of cells from the clipboard…
43383 …ters the list of changes according to the range of cells that you specify. To select a range of ce…
43384 …1663 0 ps \<ahelp hid=\".\" visibility=\"hidden\"\>Select the range of cells that you want to u…
43387 … 0 ps \<ahelp hid=\"HID_REDLINING_FILTER_BTN_REF\"\>Select the range of cells that you want to u…
43390 …hid=\"SC:IMAGEBUTTON:RID_SCDLG_SIMPLEREF:RB_ASSIGN\"\>Select the range of cells that you want to u…
43509 ….\" visibility=\"hidden\"\>Select database records. Drag-and-drop rows or cells to the document to…
43915 …dentext\"\>\<ahelp hid=\".\"\>Combines the contents of the selected table cells into a single cell…
43920 helpcontent2 source\text\shared\01\05100100.xhp 0 help par_id3153718 3 0 ps Merging cells can lea…
44275 …01.xhp 0 help par_id3147318 99 0 ps The default currency format for the cells in your spreadshee…
44394 …e select=\"CALC\"\>If you perform a calculation that involves one or more cells using a date forma…
44716 …line select=\"appl\"\> \<caseinline select=\"CALC\"\>To select all of the cells on a sheet, click …
44980 …s \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Lists the cells with contents that…
45126 …e\>\<bookmark_value\>number of sheets\</bookmark_value\>\<bookmark_value\>cells;number of\</bookma…
45135 …s \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Number of cells with content in th…
48866 … data range. This range may consist of more than one rectangular range of cells. 20181231 09:50…
48893 …age and then remove unnecessary data series or add data series from other cells here. 20181231 …
49200 …LABEL:CB_AXIS_LABEL_TEXTOVERLAP\"\>Specifies that the text in cells may overlap other cells.\</ahe…
49297 …60000.xhp 0 help hd_id0305200910524937 0 ps Include values from hidden cells 20181231 09:50:…
49298 … 0 ps \<ahelp hid=\".\"\>Check to also show values of currently hidden cells within the source …
51058 …r_id4231086 0 ps You can apply different methods to insert spreadsheet cells into your Impress …
51059 …par_id9209875 0 ps Insert a native table - you enter the data into the cells and apply fancy fo…
51063 …e the vertical alignment of selected or all cell contents. Split or merge cells.\</ahelp\> 2018…
51064 …00803551553 0 ps \<ahelp hid=\".\" visibility=\"hidden\"\>All selected cells are merged into on…
51065 … hid=\".\" visibility=\"hidden\"\>The selected cell is split into several cells. You see the Split…
51066 …".\" visibility=\"hidden\"\>The cell contents are align at the top of the cells.\</ahelp\> 2018…
51067 …lity=\"hidden\"\>The cell contents are aligned vertically centered in the cells.\</ahelp\> 2018…
51068 …visibility=\"hidden\"\>The cell contents are aligned at the bottom of the cells.\</ahelp\> 2018…
51072 …ected, all rows will be selected. If currently cells are selected, all rows containing the selecte…
51073 …cted, a new row will be inserted at the bottom of the table. If currently cells are selected, as m…
51077 …d, all columns will be selected. If currently cells are selected, all columns containing the selec…
51078 …ew column will be inserted at the right border of the table. If currently cells are selected, as m…
51084 …48496 0 ps Double-click the table and enter or paste the data into the cells. 20181231 09:5…
51087 …\guide\table_insert.xhp 0 help par_id0916200803551725 0 ps Select some cells and right-click to…
51088 ….xhp 0 help par_id091620080355171 0 ps To select a rectangular area of cells, point to a cell i…
51095 …spreadsheet without resizing the cells, double-click the spreadsheet, and then drag a corner handl…
52582 …visibility=\"visible\"\>Applies the default number format to the selected cells.\</ahelp\> 2018…
52588 …elp hid=\".uno:ChooseDesign\"\>Applies a formatting style to the selected cells.\</ahelp\>\</varia…
52593 …\02\18020000.xhp 0 help bm_id3150275 0 ps \<bookmark_value\>inserting; cells, toolbar icon\</bo…
52595 …n to open the \<emph\>Insert Cells \</emph\>toolbar, where you can insert cells, rows, and columns…
52611 ….uno:NumberFormatPercent\"\>Applies the percentage format to the selected cells.\</ahelp\> 2018…
52622 …sibility=\"visible\"\>Applies the default currency format to the selected cells.\</ahelp\> 2018…
52645 …the current document. By default, the SUM of the contents of the selected cells is displayed.\</ah…
52651 …s sum values into selected cells. Click in a cell, click this icon, and optionally adjust the cell…
52665 …DecDecimals\"\>Removes one decimal place from the numbers in the selected cells.\</ahelp\> 2018…
52688 …e current cell, the range of the selected cells, or the name of the area. You can also select a ra…
52700 …ormatIncDecimals\"\>Adds one decimal place to the numbers in the selected cells.\</ahelp\> 2018…
52907 …00.xhp 0 help par_id3153967 84 0 ps To create a matrix in which all the cells contain the same i…
52908 …xt\scalc\04\01020000.xhp 0 help par_id3166426 4 0 ps To select multiple cells in different areas…
52911 …cells, press Delete. This opens the \<link href=\"text/scalc/01/02150000.xhp\" name=\"Delete Conte…
52932 …159258 185 0 ps Selects all cells containing data from the current cell to the end of the contin…
52954 helpcontent2 source\text\scalc\04\01020000.xhp 0 help par_id9901425 0 ps Insert cells (as in men…
52956 helpcontent2 source\text\scalc\04\01020000.xhp 0 help par_id5104220 0 ps Delete cells (as in men…
52960 …07055 0 ps Displays or hides the formulas instead of the values in all cells. 20181231 09:50…
52995 helpcontent2 source\text\scalc\04\01020000.xhp 0 help par_id3150385 38 0 ps Highlights cells cont…
53085 … 0 help par_id3153191 34 0 ps During consolidation, the contents of the cells from several sheet…
53101 …ther \<emph\>Row labels\</emph\> or \<emph\>Column labels\</emph\> if the cells of the source data…
53107 …cells; copying/deleting/formatting/moving\</bookmark_value\> \<bookmark_value\>rows;visible a…
53110 …p 0 help par_id3154729 3 0 ps $[officename] behavior depends on how the cells were made invisibl…
53114 …4 7 0 ps Copy, delete, move, or format a selection of currently visible cells. 20181231 09:50…
53115 …t\scalc\guide\cellcopy.xhp 0 help par_id3146918 8 0 ps Only the visible cells of the selection a…
53117 … 13 0 ps Copy, delete, move, or format a selection of currently visible cells. 20181231 09:50…
53118 …de\cellcopy.xhp 0 help par_id3154371 14 0 ps All cells of the selection, including the hidden ce…
53127 …8 0 ps You can also enter the values and the formulas directly into the cells, even if you canno…
53131 … are editing a formula with references, the references and the associated cells will be highlighte…
53136 …cells; selecting\</bookmark_value\> \<bookmark_value\>marking cells\</bookmark_value\> \…
53143 …par_id3149959 5 0 ps Pressing the mouse button, drag a range across two cells, do not release th…
53144 …uide\mark_cells.xhp 0 help hd_id3154942 6 0 ps Select various dispersed cells 20181231 09:50:…
53146 …ne\>Ctrl\</defaultinline\>\</switchinline\>, click each of the additional cells. 20181231 09:50…
53147 … STD / EXT / ADD area in the status bar until it shows ADD. Now click all cells that you want to s…
53153 …ps A mouse click selects the cell you have clicked on. Unmarks all marked cells. 20181231 09:50…
53157 …cells. A mouse click in a marked cell unmarks it. Alternatively, \<switchinline select=\"sys\"\>\<…
53162 …abase_define.xhp 0 help par_id3153768 81 0 ps You can define a range of cells in a spreadsheet t…
53165 …de\database_define.xhp 0 help par_id3155064 41 0 ps Select the range of cells that you want to d…
53186 …<item type=\"literal\"\>=SUM(Sheet1.A1:Sheet3.A1) \</item\>sums up all A1 cells on Sheet1 through …
53190 …e.xhp 0 help par_id3156023 8 0 ps Position the cursor within a range of cells containing values,…
53202 … \<bookmark_value\>number formats; adding/deleting decimal places in cells\</bookmark_value\>…
53211 …cells;AutoInput function\</bookmark_value\> \<bookmark_value\>cells; AutoInput function of te…
53235 …action view. Open the context menu of the cell, and choose \<emph\>Format cells. \</emph\>Select "…
53244 … help par_id3149961 34 0 ps If you want to copy a formula into multiple cells, there is a quick …
53247 … With the mouse button pressed, drag it down or to the right over all the cells into which you wan…
53248 …ps When you release the mouse button, the formula will be copied into the cells and automatically …
53271 …xhp 0 help par_id3147340 19 0 ps To stop using AutoFilter, reselect all cells selected in step 1…
53273 …cells that are not visible due to an applied filter. For example, a sum of an entire column will a…
53277 …cells and sheets\</bookmark_value\> \<bookmark_value\>cells; protecting\</bookmark_value\> …
53279 … cells are protected against accidental changes, whether the formulas can be viewed from within Ca…
53281 …cells with the \<emph\>Protected\</emph\> attribute is only effective when you protect the whole s…
53283 helpcontent2 source\text\scalc\guide\cell_protect.xhp 0 help par_idN1066B 0 ps Select the cells …
53286 …ph\>Protected\</emph\> to allow the user to change the currently selected cells. 20181231 09:50…
53289 …t \<emph\>Hide when printing\</emph\> to hide protected cells in the printed document. The cells a…
53292 …t\scalc\guide\cell_protect.xhp 0 help par_idN106C0 0 ps To protect the cells from being changed…
53295 …ssword, you cannot deactivate the protection. If you only want to protect cells from accidental ch…
53299 …cells; multi-line\</bookmark_value\>\<bookmark_value\>cells; text breaks\</bookmark_value\>\<bookm…
53303 …t\scalc\guide\text_wrap.xhp 0 help par_id3153951 44 0 ps Select all the cells where you want the…
53329 …e\>cells; backgrounds\</bookmark_value\> \<bookmark_value\>rows, see also cells\</bookmark_va…
53333 helpcontent2 source\text\scalc\guide\background.xhp 0 help par_id3155429 17 0 ps Select the cells…
53344 …cells; formatting\</bookmark_value\>\<bookmark_value\>spreadsheets;formatting\</bookmark_value\>\<…
53350 …xt\scalc\guide\format_table.xhp 0 help par_id3159226 17 0 ps Select the cells containing the num…
53353 …d3154733 20 0 ps You can assign a format to any group of cells by first selecting the cells (for…
53355 …"\>Insert - Picture - From File\</item\> and arrange the image behind the cells by choosing \<item…
53393 …apilot_grouping.xhp 0 help par_idN10667 0 ps Select a cell or range of cells in the pivot table…
53395 …g.xhp 0 help par_idN1066E 0 ps Depending on the format of the selected cells, either a new grou…
53412 …cells; currency formats\</bookmark_value\>\<bookmark_value\>international currency formats\</bookm…
53419 …ps If, under \<item type=\"menuitem\"\>Language\</item\>, you convert the cells to "English (US)",…
53431 …0 help par_id3154018 21 0 ps Select the numbers in the second column in cells B1:B10. 2018123…
53437 …s text in $[officename] Calc. Open the context menu of a cell or range of cells and choose \<emph\…
53438 …s If you have already entered normal numbers in cells and have afterwards changed the format of th…
53460 …hp 0 help par_id121020081121549 0 ps If you select a range of cells, only these cells will get …
53462 …guide\database_sort.xhp 0 help par_id121020081121547 0 ps The range of cells that will get sort…
53467 … \<bookmark_value\>references; to cells in other sheets/documents\</bookmark_value\> \<boo…
53484 …ive cell to select a range of cells, $[officename] automatically inserts the corresponding referen…
53487 …s\</bookmark_value\>\<bookmark_value\>references; to cells\</bookmark_value\>\<bookmark_value\>cel…
53490 …cells by first entering the coordinates of the upper left cell of the area, then a colon followed …
53497 …elative reference? Assume you want to calculate in cell E1 the sum of the cells in range A1:B2. Th…
53500 …ferences can also change when an existing formula referring to particular cells is copied to anoth…
53504 …n navigate from one result to the next, or you can highlight all matching cells at once, then appl…
53506 …ain text or numbers that were entered directly as in a text document. But cells can also contain t…
53522 …h\>Find All\</emph\>, Calc selects all cells that contain your entry. Now you can for example set …
53542 …xhp 0 help bm_id3153195 0 ps \<bookmark_value\>formulas; displaying in cells\</bookmark_value\>…
53544 … 0 help par_id3150010 2 0 ps If you want to display the formulas in the cells, for example in th…
53559 …cells; changing text/number formats\</bookmark_value\> \<bookmark_value\>formats; changing te…
53577 …\<bookmark_value\>protecting; unprotecting cells\</bookmark_value\> \<bookmark_value\>unprote…
53582 …ect.xhp 0 help par_id3153771 18 0 ps The cells can now be edited, the formulas can be viewed, an…
53634 …y\</item\> in the \<emph\>Month\</emph\> cells OR a value of under 160000 in the \<emph\>Standard\…
53637 …cells\</bookmark_value\>\<bookmark_value\>cell heights\</bookmark_value\>\<bookmark_value\>cell wi…
53686 …using row/column labels\</bookmark_value\> \<bookmark_value\>text in cells; as addressing\</b…
53688 …p par_id3152597 21 0 ps You can use cells with text to refer to the rows or to the columns that …
53713 …c\guide\format_value_userdef.xhp 0 help par_id3150868 3 0 ps Select the cells to which you want …
53742 …ode\"\>F2\</item\> to enter the cell selection mode. Select any number of cells, then press \<item…
53743 …the cell selection mode, you can use the common navigation keys to select cells. 20181231 09:50…
53760 …value\>HTML; in sheet cells\</bookmark_value\>\<bookmark_value\>references; URL in cells\</bookmar…
53762 …nternet page containing current stock exchange information in spreadsheet cells, you can load this…
53769 …. When you open it again later, $[officename] Calc will update the linked cells following an inqui…
53774 …de\cellstyle_minusvalue.xhp 0 help par_id3153878 33 0 ps You can format cells with a number form…
53775 …\guide\cellstyle_minusvalue.xhp 0 help par_id3155600 34 0 ps Select the cells and choose \<emph\…
53783 …eet with a theme, you have to apply at least one custom cell style to the cells on the sheet. You …
53784 …from the Styles and Formatting window to apply this style to the selected cells. 20181231 09:50…
53787 …and the Styles and Formatting window lists the custom styles for specific cells. 20181231 09:50…
53795 …_text.xhp 0 help par_id0908200901265127 0 ps Calc converts text inside cells to the respective …
53810 …not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a converti…
53817 …ark_value\>dates; in cells\</bookmark_value\> \<bookmark_value\>times; in cells\</bookmark_va…
53839 …en drag the selected cell a few cells to the right or downwards. When you release the mouse button…
53840 …e\>Ctrl \</defaultinline\>\</switchinline\>if you do not want to fill the cells with different val…
53844 …alue\>cells;borders\</bookmark_value\> \<bookmark_value\>line arrangements with cells\</bookm…
53846 …_id2320017 0 ps You can apply a variety of different lines to selected cells. 20181231 09:50…
53847 …de\borders.xhp 0 help par_id8055665 0 ps Select the cell or a block of cells. 20181231 09:50…
53852 helpcontent2 source\text\scalc\guide\borders.xhp 0 help hd_id4454481 0 ps Selection of cells …
53853 …de\borders.xhp 0 help par_id7251503 0 ps Depending on the selection of cells, the area looks di…
53871 …guide\borders.xhp 0 help par_id622577 0 ps Select a block of about 8x8 cells, then choose \<emp…
53885 …d6987823 0 ps A black line sets the corresponding line of the selected cells. The line is shown…
53888 … 0 ps A gray line is shown when the corresponding line of the selected cells will not be change…
53891 … 0 ps A white line is shown when the corresponding line of the selected cells will be removed. …
53903 …lue\>cells; rotating text\</bookmark_value\> \<bookmark_value\>rotating; text in cells\</book…
53905 helpcontent2 source\text\scalc\guide\text_rotate.xhp 0 help par_id3145171 2 0 ps Select the cells…
53912 …cells\</bookmark_value\>\<bookmark_value\>printing; cells\</bookmark_value\>\<bookmark_value\>rang…
53914 …printranges.xhp 0 help par_idN108F5 0 ps You can define which range of cells on a spreadsheet t…
53915 helpcontent2 source\text\scalc\guide\printranges.xhp 0 help par_idN108FB 0 ps The cells on the s…
53918 helpcontent2 source\text\scalc\guide\printranges.xhp 0 help par_idN10905 0 ps Select the cells t…
53921 helpcontent2 source\text\scalc\guide\printranges.xhp 0 help par_idN10917 0 ps Select the cells t…
53938 …e\>superscript text in cells\</bookmark_value\>\<bookmark_value\>subscript text in cells\</bookmar…
53982 …nter a formula to calculate a result from values that are stored in other cells. Then, you set up …
53990 …ps Select the range D2:E11, and thus the values in column D and the empty cells alongside in colum…
54000 … 54 0 ps With the cursor in the \<emph\>Formulas\</emph\> field, select cells B5 through C5. …
54004 …cell\</emph\> fields are used to enter the reference to the corresponding cells of the formula. …
54022 ….xhp 0 help par_id9384746 0 ps To remove a filter, so that you see all cells again, click insid…
54046 …veral scenarios on the same sheet, each with some different values in the cells. Then you can easi…
54048 …o.xhp 0 help par_id3154704 16 0 ps To create a scenario, select all the cells that provide the d…
54049 …id3154020 17 0 ps Select the cells that contain the values that will change between scenarios. T…
54060 …rder of a set of cells that are part of a scenario, open the \<emph\>Properties\</emph\> dialog fo…
54061 …mph\>Tools - Detective - Trace Dependents\</emph\>. You see arrows to the cells that are directly …
54087 … type=\"literal\"\>b\</item\>, and \<item type=\"literal\"\>c\</item\> in cells A1, B1, and C1. …
54094 …..+STYLE(IF(CURRENT()>3; "Red"; "Green")) applies the cell style "Red" to cells if the value is gr…
54095 … help par_id3151385 15 0 ps If you would like to apply a formula to all cells in a selected area…
54096 …tyle_by_formula.xhp 0 help par_id3149456 16 0 ps Select all the desired cells. 20181231 09:50…
54103 …t\scalc\guide\cellstyle_by_formula.xhp 0 help par_id3144767 24 0 ps All cells with contents that…
54106 …cells; validity\</bookmark_value\>\<bookmark_value\>error messages; defining for incorrect input\<…
54110 …alid Data\"\>\<emph\>Mark Invalid Data\</emph\>\</link\> to display which cells contain invalid va…
54112 helpcontent2 source\text\scalc\guide\validity.xhp 0 help par_id3155959 6 0 ps Select the cells fo…
54114 …teria\</emph\> tab page, enter the conditions for new values entered into cells. 20181231 09:5…
54116 …ues such as "12:00" or serial time numbers. "Text Length" stipulates that cells are allowed to con…
54129 …cells; merging/unmerging\</bookmark_value\> \<bookmark_value\>tables; merging cells\</bookmar…
54131 …cells, then merge them into a single cell. Conversely, you can take a large cell that has been cre…
54132 …cells into a target range containing merged cells, the target range gets unmerged first, then the …
54134 …uide\table_cellmerge.xhp 0 help par_id1272927 0 ps Select the adjacent cells. 20181231 09:50…
54136 …e\table_cellmerge.xhp 0 help hd_id451368 0 ps Canceling the merging of cells 20181231 09:50:…
54140 … 0 ps \<bookmark_value\>conditional formatting; cells\</bookmark_value\> \<bookmark_value\>…
54142 …to three conditions per cell, which must be met in order for the selected cells to have a particul…
54146 …guide\cellstyle_conditional.xhp 0 help par_id3154490 27 0 ps Select the cells to which you want …
54153 …de\cellstyle_conditional.xhp 0 help par_id3149565 41 0 ps In one of the cells enter the formula …
54169 …guide\cellstyle_conditional.xhp 0 help par_id3150049 56 0 ps Select all cells with the random nu…
54173 …help par_id3145320 62 0 ps To apply the conditional formatting to other cells later: 20181231…
54174 …cellstyle_conditional.xhp 0 help par_id3153074 63 0 ps Click one of the cells that has been assi…
54176 …guide\cellstyle_conditional.xhp 0 help par_id3150436 65 0 ps Select the cells that are to receiv…
54181 …</bookmark_value\>\<bookmark_value\>cells; printing grids\</bookmark_value\>\<bookmark_value\>bord…
54201 …c value or string. An advanced filter uses filter criteria from specified cells. 20181231 09:50…
54224 …ding_numbers.xhp 0 help hd_id3152596 4 0 ps To change this for selected cells 20181231 09:50:…
54225 …alc\guide\rounding_numbers.xhp 0 help par_id3154321 5 0 ps Mark all the cells you want to modify…
54252 …cells; filling automatically\</bookmark_value\> \<bookmark_value\>automatic cell filling\</bo…
54254 …de\calc_series.xhp 0 help par_idN106A8 0 ps You can automatically fill cells with data with the…
54259 …ps Drag the fill handle in the bottom right corner of the cell across the cells that you want to f…
54260 helpcontent2 source\text\scalc\guide\calc_series.xhp 0 help par_id3145801 17 0 ps The cells are f…
54262 …e\>Ctrl \</defaultinline\>\</switchinline\>if you do not want to fill the cells with different val…
54263 … 0 ps If you select two or more adjacent cells that contain different numbers, and drag, the rem…
54264 … the first column. Now enter some values into B1 and C1. Select those two cells, and double-click …
54278 helpcontent2 source\text\scalc\guide\autoformat.xhp 0 help par_idN106CE 0 ps Select the cells, i…
54282 … help par_idN1075D 0 ps The format is applied to the selected range of cells. 20181231 09:50…
54296 …lons, or other characters can be used as the field delimiters between the cells. Text strings are …
54318 …cells\</bookmark_value\> \<bookmark_value\>cells;comments\</bookmark_value\> \<bookmark_…
54330 …cells; defining names\</bookmark_value\> \<bookmark_value\>names; defining for cells\</bookma…
54340 …anges must not include blanks. Blanks are allowed within names for single cells, sheets and docume…
54341 helpcontent2 source\text\scalc\guide\value_with_name.xhp 0 help hd_id1226233 0 ps Naming cells a…
54342 …e.xhp 0 help par_id5489364 0 ps A good way of making the references to cells and cell ranges in…
54345 …lue_with_name.xhp 0 help par_id3153954 3 0 ps Select a cell or range of cells, then choose \<emp…
54347 …ialog by entering the name in the field and then selecting the respective cells. 20181231 09:50…
54370 …las.xhp 0 help par_id3154486 34 0 ps Calculates B8 minus the sum of the cells B10 to B14. 201…
54372 …c\guide\formulas.xhp 0 help par_id3159171 36 0 ps Calculates the sum of cells B10 to B14 and add…
54392 …help bm_id3150868 0 ps \<bookmark_value\>values; inserting in multiple cells\</bookmark_value\>…
54394 …d7147129 0 ps Calc can simplify entering data and values into multiple cells. You can change so…
54421 …Preview\</emph\>. Drag the delimiter lines to define the range of printed cells on each page. 2…
54432 …help par_id3764763 0 ps \<emph\>Selected cells\</emph\> - All selected cells are…
54440 …cells\</bookmark_value\>\<bookmark_value\>cells; moving by drag and drop \</bookmark_value\>\<book…
54442 …ps When you drag-and-drop a selection of cells on a Calc sheet, the cells normally overwrite the e…
54444 …ps In insert mode, the existing cells where you drop will be shifted to the right or to the bottom…
54445 …ragdrop.xhp 0 help par_id8676717 0 ps The surrounding box of the moved cells looks different in…
54446 …e only the left border when target cells will be shifted to the right. You see only the upper bord…
54447 … between source and target cells, if you move within the same sheet. It depends on the number of h…
54448 …06 0 ps If you move cells in insert mode within the same row (only horizontally), then after in…
54453 … par_id2815637 0 ps Cells are moved and overwrite the cells in the target area. Source cells ar…
54455 …par_id4278389 0 ps Cells are copied and overwrite the cells in the target area. Source cells st…
54457 …_id5369121 0 ps Links to the source cells are inserted and overwrite the cells in the target ar…
54459 …419 0 ps Cells are moved and shift the cells in the target area to the right or to the bottom. …
54460 …id4021423 0 ps If you move within the same rows on the same sheet, the cells in the target area…
54462 …19 0 ps Cells are copied and shift the cells in the target area to the right or to the bottom. …
54464 … 0 ps Links to the source cells are inserted and shift the cells in the target area to the right o…
54494 …0 ps \<bookmark_value\>drag and drop; referencing cells\</bookmark_value\> \<bookmark_value\>…
54496 …Navigator you can reference cells from one sheet to another sheet in the same document or in a dif…
54497 …0 help par_id3152576 25 0 ps Open the document that contains the source cells. 20181231 09:50…
54498 … par_id3154011 26 0 ps To set the source range as the range, select the cells and choose \<emph\…
54506 …lc\05\empty_cells.xhp 0 help bm_id3146799 0 ps \<bookmark_value\>empty cells;handling of\</book…
54508 …xhp 0 help par_id8266853 0 ps In older versions of the software, empty cells were forced to num…
54635 helpcontent2 source\text\scalc\01\06030800.xhp 0 help bm_id3153821 0 ps \<bookmark_value\>cells;…
54637 … 0 ps \<ahelp hid=\".uno:ShowInvalid\" visibility=\"visible\"\>Marks all cells in the sheet that …
54638 …r, it is possible to enter invalid values or copy invalid values into the cells if the \<emph\>Sto…
54826 …BOX:RID_SCPAGE_TABLE:BTN_GRID\"\>Prints out the borders of the individual cells as a grid.\</ahelp…
54836 …BOX:RID_SCPAGE_TABLE:BTN_FORMULAS\"\>Prints the formulas contained in the cells, instead of the re…
54838 …\<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_NULLVALS\"\>Specifies that cells with a zero value …
54889 … 0 help par_id3147363 27 0 ps The cells for the 1st and 2nd quarters each contain a sum formula …
54907 …46 2 0 ps \<ahelp hid=\".\"\>Combines the selected cells into a single cell or splits merged cel…
54908 …the first cell of the original cell range. Merged cells cannot be merged a second time with other …
54909 helpcontent2 source\text\scalc\01\05060000.xhp 0 help par_id3149665 3 0 ps If the cells to be mer…
54916 …ell is copied into all other cells of the range. If several rows are selected, the far right cells…
54958 …okmark_value\>deleting; cell contents\</bookmark_value\>\<bookmark_value\>cells; deleting contents…
54977 …\"SC_CHECKBOX_RID_SCDLG_DELCONT_BTN_DELNOTES\"\>Deletes comments added to cells. All other element…
54979 …OX_RID_SCDLG_DELCONT_BTN_DELATTRS\"\>Deletes format attributes applied to cells. All cell content …
54988 helpcontent2 source\text\scalc\01\06030300.xhp 0 help bm_id3153252 0 ps \<bookmark_value\>cells;…
54991 helpcontent2 source\text\scalc\01\06030300.xhp 0 help par_id3148948 4 0 ps The area of all cells …
55053 …80000.xhp 0 help par_id3145785 0 ps Text cells are formatted in black, formulas in green, and n…
55106 …"hidden\"\>Click to shrink or restore the dialog. You can click or select cells in the sheet. You …
55112 …ted in a rectangular cell range that you enter in the \<emph\>By changing cells\</emph\> box. …
55113 …tions that set constraints for some cells. For example, you can set the constraint that one of the…
55118 …l containing the DATE function is the date format, but you can format the cells with any other num…
55151 …r a certain range to format the whole range. Repeat this action for other cells and ranges. 201…
55218 …alue\>showing; sheet details\</bookmark_value\>\<bookmark_value\>grouping;cells\</bookmark_value\>…
55302 …060181.xhp 0 help par_id3148728 10 0 ps To calculate the intercept, use cells D3:D9 as the y val…
55315 … empty string of length 0. If an argument is an array or reference, empty cells within the array o…
55481 …calc\01\04060102.xhp 0 help par_id1953489 0 ps When you copy and paste cells containing date va…
55552 …p\>\</variable\> Before you start the Wizard, select a cell or a range of cells from the current s…
55562 …erate on multiple cells. Each cell in the array contains the formula, not as a copy but as a commo…
55564 … par_id3152993 40 0 ps The maximum size of an array range is 128 by 128 cells. 20181231 09:50…
55587 …emph\>Function Wizard\</emph\>, and transfers the formula to the selected cells. 20181231 09:50…
55600 …or was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN…
55629 …or was encountered in the cell range(s) passed as cell reference(s). Text cells are ignored by MIN…
55671 …138K1 0 ps \<ahelp hid=\"HID_FUNC_MITTELWERTB\"\>Average the values of cells in a range that me…
55674 …erages the values of cells in the reference range R that meet the Criterion C. If reference A is g…
55680 …138K2 0 ps \<ahelp hid=\"HID_FUNC_MITTELWERTC\"\>Average the values of cells that meet multiple…
55683 …alc\01\04060184.xhp 0 help par_id3155260K2 0 ps Averages the values of cells in the reference r…
55686 …IFS(A1:A50;B1:B25;">"0)\</item\>+will return the average of A1:A50 if all cells in the range B1 to…
55844 …help par_id3155855 2 0 ps \<ahelp hid=\".\"\>Manages print ranges. Only cells within the print r…
55845 … range manually, Calc assigns an automatic print range to include all the cells that are not empty…
56071 …<emph\>Values\</emph\> corresponds to the array or the cell reference for cells whose content corr…
56271 …ists\</bookmark_value\> \<bookmark_value\>selection lists;filling cells\</bookmark_value\>…
56273 ….xhp 0 help par_id3156285 2 0 ps \<ahelp hid=\".\"\>Automatically fills cells with content.\</ah…
56274 …xhp\" name=\"other options\"\>additional options\</link\> for filling the cells. 20181231 09:50…
56277 helpcontent2 source\text\scalc\01\02140000.xhp 0 help par_id3152994 3 0 ps \<emph\>Filling cells …
56307 …3145748 4 0 ps To show all hidden cells, first click in the field in the upper left corner. This…
56458 …m_id3155628 0 ps \<bookmark_value\>cells; removing precedents\</bookmark_value\>\<bookmark_valu…
56485 …h\> Protect Document \</emph\>command prevents changes from being made to cells in the sheets or t…
56491 …\<variable id=\"tabelletext\"\>\<ahelp hid=\".uno:Protect\"\>Protects the cells in the current she…
56492 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3149664 5 0 ps To protect cells from …
56493 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3154490 8 0 ps Unprotected cells or c…
56494 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3149123 16 0 ps Select the cells that…
56507 …lp hid=\"HID_SCPAGE_PROTECTION\"\>Defines protection options for selected cells.\</ahelp\> 2018…
56510 …GE_PROTECTION:BTN_HIDE_ALL\"\>Hides formulas and contents of the selected cells.\</ahelp\> 2018…
56512 …:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_PROTECTED\"\>Prevents the selected cells from being modifie…
56515 …RID_SCPAGE_PROTECTION:BTN_HIDE_FORMULAR\"\>Hides formulas in the selected cells.\</ahelp\> 2018…
56519 …SC:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_HIDE_PRINT\"\>Keeps the selected cells from being printed…
56545 …calc\01\02180000.xhp 0 help par_id2282479 0 ps When you copy and paste cells containing \<link …
56636 … is set to '=' EQUAL or '<>' UNEQUAL. This also applies to the respective cells that you reference…
56649 …\"\>Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of pre…
56666 …d, specifies that you want to retain the width and height of the selected cells of the selected fo…
56673 helpcontent2 source\text\scalc\01\06030600.xhp 0 help bm_id3153561 0 ps \<bookmark_value\>cells;…
56675 …ShowErrors\" visibility=\"visible\"\>Draws tracer arrows to all precedent cells which cause an err…
56849 … you write the criteria in different rows they are connected by OR. Empty cells in the search crit…
56901 …ID_FUNC_DBMITTELWERT\"\>DAVERAGE returns the average of the values of all cells (fields) in all ro…
56910 …79 140 0 ps \<ahelp hid=\"HID_FUNC_DBPRODUKT\"\>DPRODUCT multiplies all cells of a data range wh…
56926 …"\>DSTDEVP calculates the standard deviation of a population based on all cells of a data range wh…
56933 …;sums in Calc databases\</bookmark_value\> \<bookmark_value\>sums;cells in Calc databases\…
56935 …62 0 ps \<ahelp hid=\"HID_FUNC_DBSUMME\"\>DSUM returns the total of all cells in a database fiel…
56944 …0 ps \<ahelp hid=\"HID_FUNC_DBVARIANZ\"\>DVAR returns the variance of all cells of a database fiel…
57054 helpcontent2 source\text\scalc\01\12090102.xhp 0 help par_idN108E6 0 ps Select a range of cells …
57062 …hid=\".uno:DefineDBName\"\>Defines a database range based on the selected cells in your sheet.\</a…
57143 …LA function\</bookmark_value\>\<bookmark_value\>formula cells;displaying formulas in other cells\<…
57183 …ark_value\>\<bookmark_value\>recognizing formula cells\</bookmark_value\>\<bookmark_value\>formula…
57210 …mark_value\>blank cell contents\</bookmark_value\>\<bookmark_value\>empty cells; recognizing\</boo…
57293 …alue\>cell information\</bookmark_value\>\<bookmark_value\>information on cells\</bookmark_value\>…
57377 …alc\01\06020000.xhp 0 help hd_id3153192 4 0 ps Hyphenation for selected cells. 20181231 09:50…
57378 helpcontent2 source\text\scalc\01\06020000.xhp 0 help par_id3150868 5 0 ps Select the cells for w…
57387 …ookmark_value\>attributes;cells\</bookmark_value\>\<bookmark_value\>formatting;cells\</bookmark_va…
57389 …y a variety of formatting options and to apply attributes to the selected cells.\</ahelp\>\</varia…
57405 …hid=\"SC:CHECKBOX:RID_SCDLG_NEWSCENARIO:CB_TWOWAY\"\>Copies the values of cells that you change in…
57411 …, if the \<emph\>Copy back\</emph\> is option is not selected, and if the cells are not protected.…
57412 …elected, if the \<emph\>Copy back\</emph\> option is selected, and if the cells are not protected.…
57419 helpcontent2 source\text\scalc\01\06030900.xhp 0 help bm_id3152349 0 ps \<bookmark_value\>cells;…
57467 … hid=\".uno:TableOperationDialog\"\>Applies the same formula to different cells, but with differen…
57469 …et containing multiple operations to Microsoft Excel, the location of the cells containing the for…
57472 …EDIT:RID_SCDLG_TABOP:ED_FORMULARANGE\"\>Enter the cell references for the cells containing the for…
57512 …298 258 0 ps \<variable id=\"wasmatrix\"\>An array is a linked range of cells on a spreadsheet c…
57528 …s The smallest possible array is a 1 x 2 or 2 x 1 array with two adjacent cells. 20181231 09:50…
57532 …cells by 10 in the above array, you do not need to apply a formula to each individual cell or valu…
57534 …cells in the same way as in a normal formula, that is, either as zero or as an empty string. For e…
57544 helpcontent2 source\text\scalc\01\04060107.xhp 0 help par_id3154342 5 0 ps The cells in a results…
57552 …help par_id6757103 0 ps To enter this array constant, you select three cells in a row, then you…
57568 …t\scalc\01\04060107.xhp 0 help par_id3146787 324 0 ps Select a range of cells where you want to …
57905 …eadsheets; inserting cells\</bookmark_value\>\<bookmark_value\>cells; inserting\</bookmark_value\>…
57907 …, in which you can insert new cells according to the options that you specify.\</ahelp\>\</variabl…
57909 …id3149262 4 0 ps This area contains the options available for inserting cells into a sheet. The …
57910 helpcontent2 source\text\scalc\01\04020000.xhp 0 help hd_id3146120 5 0 ps Shift cells down 201…
57911 …L:BTN_CELLSDOWN\"\>Moves the contents of the selected range downward when cells are inserted.\</ah…
57912 helpcontent2 source\text\scalc\01\04020000.xhp 0 help hd_id3147434 7 0 ps Shift cells right 20…
57913 …_CELLSRIGHT\"\>Moves the contents of the selected range to the right when cells are inserted.\</ah…
57950 …t belong to a multiple range.\</ahelp\> A range can consist of contiguous cells or a single cell. …
57956 …\>=AREAS((A1:B3;F2;G1))\</item\> returns 3, as it is a reference to three cells and/or areas. Afte…
57977 …is updated in all \<item type=\"productname\"\>%PRODUCTNAME\</item\> Calc cells in which this DDE …
58014 … type=\"input\"\>=SUM(INDIRECT("a1:" & ADDRESS(1;3)))\</item\> totals the cells in the area of A1 …
58041 …elp hid=\"HID_FUNC_SVERWEIS\"\>Vertical search with reference to adjacent cells to the right.\</ah…
58137 …help hid=\"HID_FUNC_WVERWEIS\"\>Searches for a value and reference to the cells below the selected…
58173 … 0 help par_id0907200912224576 0 ps The number 0 is returned for empty cells and matrix element…
58426 …n quotation marks or as a reference. If you enter the units of measure in cells, they must corresp…
58599 … the same column.\</ahelp\> The column is scanned up to a maximum of 2000 cells or 200 different s…
58608 …9 0 ps \<bookmark_value\>cells; trace fill mode\</bookmark_value\>\<bookmark_value\>traces; pre…
58613 helpcontent2 source\text\scalc\01\06031000.xhp 0 help bm_id3154515 0 ps \<bookmark_value\>cells;…
58630 …/bookmark_value\>\<bookmark_value\>counting;empty cells\</bookmark_value\>\<bookmark_value\>empty …
58632 …s \<ahelp hid=\"HID_FUNC_ANZAHLLEEREZELLEN\"\>Returns the number of empty cells.\</ahelp\> 2018…
58635 …\04060106.xhp 0 help par_id3149512 46 0 ps Returns the number of empty cells in the cell range …
58637 …48 0 ps \<item type=\"input\"\>=COUNTBLANK(A1:B2)\</item\> returns 4 if cells A1, A2, B1, and B2…
58822 …p par_id1604663 0 ps \<item type=\"input\"\>=GCD(B1:B3)\</item\> where cells B1, B2, B3 contain…
59083 … 0 ps \<ahelp hid=\"HID_FUNC_SUMME\"\>Adds all the numbers in a range of cells.\</ahelp\> 2018…
59089 …> calculates the sum of the three cells. \<item type=\"input\"\>=SUM (A1:E10)\</item\> calculates …
59099 …elp par_id3151986 437 0 ps \<ahelp hid=\"HID_FUNC_SUMMEWENN\"\>Adds the cells specified by a giv…
59112 …id3151986K 0 ps \<ahelp hid=\"HID_FUNC_SUMMEWNRNG\"\>Sum the values of cells in a range that me…
59115 …ext\scalc\01\04060106.xhp 0 help par_id3152043K 0 ps Sums the value of cells in range R that me…
59119 helpcontent2 source\text\scalc\01\04060106.xhp 0 help par_id3152148K 0 ps Sum up cells in range …
59169 …0 help par_id3143606 498 0 ps \<emph\>Range\</emph\> is the range whose cells are included. 2…
59263 …d2091433 0 ps To generate random numbers which never recalculate, copy cells containing this fu…
59272 …d9312417 0 ps To generate random numbers which never recalculate, copy cells each containing =R…
59275 …\>COUNTIF function\</bookmark_value\>\<bookmark_value\>counting;specified cells\</bookmark_value\>…
59277 …26 548 0 ps \<ahelp hid=\"HID_FUNC_ZAEHLENWENN\"\>Returns the number of cells that meet with cer…
59281 …mber, an expression or a character string. These criteria determine which cells are counted. You m…
59288 …tains the text \<item type=\"input\"\>>2006\</item\> counts the number of cells in the range A1:A1…
59290 …>COUNTIFS function\</bookmark_value\>\<bookmark_value\>counting;specified cells\</bookmark_value\>…
59292 …64926K 0 ps \<ahelp hid=\"HID_FUNC_ZAEHLENWNRNG\"\>Count the number of cells that meet multiple…
59296 …mber, an expression or a character string. These criteria determine which cells are counted. You m…
59339 helpcontent2 source\text\scalc\01\06030500.xhp 0 help bm_id3153088 0 ps \<bookmark_value\>cells;…
59613 …log, where you enter settings to expand the contents of selected cells to multiple cells. \</varia…
59614 …lumns.xhp 0 help hd_id9599597 0 ps To expand cell contents to multiple cells 20181231 09:50:…
59615 … help par_id2021546 0 ps You can expand cells that contain comma separated values (CSV) into mu…
59617 …scalc\01\text2columns.xhp 0 help par_id7242042 0 ps Select the cell or cells that you want to e…
59620 …iew shows how the current cell contents will be transformed into multiple cells. 20181231 09:50…
59645 …e, or as a named range. The range may consist of one column or one row of cells. If you specify a …
59650 helpcontent2 source\text\scalc\01\12120100.xhp 0 help hd_id3154704 7 0 ps Allow empty cells 20…
59651 …\>Tools - Detective - Mark invalid Data\</emph\>, this defines that empty cells are shown as inval…
59698 …alc\01\04060110.xhp 0 help bm_id3145389 0 ps \<bookmark_value\>text in cells; functions\</bookm…
60116 helpcontent2 source\text\scalc\01\12010100.xhp 0 help hd_id3153970 5 0 ps Insert or delete cells …
60121 …le\"\>Only saves a reference to the database, and not the contents of the cells.\</ahelp\> 2018…
60132 …bm_id3155628 0 ps \<bookmark_value\>cells; tracing precedents\</bookmark_value\>\<bookmark_valu…
60134 …ws the relationship between the current cell containing a formula and the cells used in the formul…
60135 … in the sheet with marking arrows. At the same time, the range of all the cells contained in the f…
60136 …hen you repeat this command, the tracer arrows are drawn to the precedent cells of this cell. 2…
60160 …alc/01/func_weeknum.xhp\"\>WEEKNUM\</link\> function, or format your date cells using the WW forma…
60209 …OND3_2\"\>Choose a condition for the format to be applied to the selected cells.\</ahelp\> 2018…
60218 …: Cell style Result (The corresponding value limits must already exist in cells B20 and B21). 2…
60219 …)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the …
60224 …ed to all the other selected cells. If you have selected several rows, each of the far left cells …
60226 helpcontent2 source\text\scalc\01\06030400.xhp 0 help bm_id3147335 0 ps \<bookmark_value\>cells;…
60230 …s search\</bookmark_value\> \<bookmark_value\>searching; links in cells\</bookmark_value\>…
60232 …tive, you can trace the dependencies from the current formula cell to the cells in the spreadsheet…
60237 …most cell is copied into the selected cells. If several columns are selected, the contents of the …
60607 …149024 61 0 ps These operators return a cell range of zero, one or more cells. 20181231 09:50…
60619 … 71 0 ps Calculates the sum of all cells in the intersection; in this example, the result yields…
60727 …p 0 help par_id3145202 103 0 ps Number of the following elements. Empty cells are not counted or…
60771 …p 0 help par_id3148621 147 0 ps Number of the following elements. Empty cells are not counted or…
60818 …p 0 help par_id3150647 194 0 ps Number of the following elements. Empty cells are not counted or…
61086 …he Formula Bar is hidden, you can still edit cells by activating the edit mode with F2. After edit…
61114 …xt\scalc\01\03100000.xhp 0 help par_id3155764 19 0 ps Adds the selected cells to print ranges. …
61121 …00.xhp 0 help par_id3125865 8 0 ps \<ahelp hid=\".\"\>Uses the selected cells as the data source…
61140 …the current column or row. The result is TRUE if the logical value in all cells within the cell ra…
61244 helpcontent2 source\text\scalc\01\06070000.xhp 0 help par_id3145173 3 0 ps All cells are recalcul…
61249 …cells; deleting cells\</bookmark_value\>\<bookmark_value\>columns; deleting\</bookmark_value\>\<bo…
61251 …teCell\"\>Completely deletes selected cells, columns or rows. The cells below or to the right of t…
61253 …a contains options for specifying how sheets are displayed after deleting cells. 20181231 09:50…
61254 helpcontent2 source\text\scalc\01\02160000.xhp 0 help hd_id3155767 5 0 ps Shift cells up 20181…
61255 …LG_DELCELL:BTN_CELLSUP\"\>Fills the space produced by the deleted cells with the cells underneath …
61256 helpcontent2 source\text\scalc\01\02160000.xhp 0 help hd_id3156382 7 0 ps Shift cells left 201…
61257 …ELCELL:BTN_CELLSLEFT\"\>Fills the resulting space by the cells to the right of the deleted cells.\…
61694 …ME\</item\> recognizes the cell range for the sum function as long as the cells are filled with nu…
61817 …rmula appears in the input line. To specify a range of cells in a table, select the desired cells …
61841 … 0 ps \<ahelp hid=\"HID_MN_CALC_SUM\"\>Calculates the sum of the selected cells.\</ahelp\> 2018…
61842 …3154411 165 0 ps Example: SUM <A2:C2> displays the sum of the values in cells A2 to C2 201812…
62663 helpcontent2 source\text\swriter\04\01020000.xhp 0 help par_id5891903 0 ps If one or more cells …
62938 …ine\>\<defaultinline\>Ctrl\</defaultinline\>\</switchinline\>+A until all cells are selected, and …
62983 …\<bookmark_value\>tables; backgrounds\</bookmark_value\>\<bookmark_value\>cells; backgrounds\</boo…
62999 …e current cell, the current row or the whole table. If you select several cells or rows before ope…
63001 …hp 0 help par_id3150767 32 0 ps To apply a background color to cells, select the cells and click…
63150 …cells\</bookmark_value\> \<bookmark_value\>sections;protecting/unprotecting\</bookmark_value\…
63161 …0 help par_id3154480 36 0 ps You can protect the contents of individual cells of a \<item type=\…
63162 …ot intended to be a secure protection. It is just a switch to protect the cells against accidental…
63164 …n.xhp 0 help par_id3145643 38 0 ps Place the cursor in a cell or select cells. Right-click to op…
63166 …0 help par_id3155178 40 0 ps Place the cursor in the cell or select the cells. First, if necessa…
63228 …cells; enlarging and reducing in text tables\</bookmark_value\>\<bookmark_value\>table cells; enla…
63230 …sizing.xhp 0 help par_id3153140 0 ps You can resize the width of table cells and columns, as we…
63238 …aultinline\>\</switchinline\> and then click and drag a line to scale all cells right or above the…
63481 …ext\swriter\guide\calculate.xhp 0 help par_id8316904 0 ps To reference cells in a Writer text t…
63499 …okmark_value\> \<bookmark_value\>cells;calculating sums\</bookmark_value\> \<bookmark_va…
63534 …>\<defaultinline\>Ctrl\</defaultinline\>\</switchinline\>+A until all the cells are selected. 2…
63654 …LE objects; inserting tables in\</bookmark_value\> \<bookmark_value\>cells;inserting from spr…
63669 …xhp 0 help par_id3156250 45 0 ps In the spreadsheet, drag to select the cells. 20181231 09:50…
63672 …>. The cell range is pasted as an OLE object. To edit the contents of the cells, double-click the …
63692 …xhp 0 help par_id3150515 69 0 ps In the spreadsheet, drag to select the cells. 20181231 09:50…
63693 …p par_id3150534 40 0 ps Click and hold the mouse button in the selected cells. 20181231 09:50…
63694 …r\guide\table_insert.xhp 0 help par_id3147527 41 0 ps Drag the selected cells into the text docu…
63870 …k_value\>page margins on rulers\</bookmark_value\>\<bookmark_value\>table cells;adjusting the widt…
63902 …ution of table cells\</bookmark_value\>\<bookmark_value\>tables; adapting the width by keyboard\</…
63904 …de\tablemode.xhp 0 help par_id3149835 12 0 ps When you insert or delete cells, rows or columns i…
63908 …ect the entire table, and wide cells shrink more than narrow cells. For example, when you widen a …
64037 …_value\>borders;for text tables\</bookmark_value\> \<bookmark_value\>cells;borders in text ta…
64039 …368 0 ps You can apply a variety of different cell borders to selected cells in a Writer table …
64040 …de\borders.xhp 0 help par_id6527298 0 ps Select the cell or a block of cells in a Writer table.…
64045 helpcontent2 source\text\swriter\guide\borders.xhp 0 help hd_id3547166 0 ps Selection of cells …
64046 …de\borders.xhp 0 help par_id1108432 0 ps Depending on the selection of cells, the area looks di…
64057 …ide\borders.xhp 0 help par_id5741752 0 ps A whole table of 2x2 or more cells selected 201812…
64065 …uide\borders.xhp 0 help par_id5528427 0 ps Select a block of about 8x8 cells, then choose \<emp…
64079 …d1454512 0 ps A black line sets the corresponding line of the selected cells. The line is shown…
64082 … 0 ps A gray line is shown when the corresponding line of the selected cells will not be change…
64085 … 0 ps A white line is shown when the corresponding line of the selected cells will be removed. …
64091 … 0 help par_id2210760 0 ps All cells in a Writer table have at least a left and a lower line by…
64289 …cells; merging/splitting\</bookmark_value\> \<bookmark_value\>tables; merging cells\</bookmar…
64291 …n select adjacent cells, then merge them into a single cell. Conversely, you can take a large cell…
64293 …uide\table_cellmerge.xhp 0 help par_id5708792 0 ps Select the adjacent cells. 20181231 09:50…
64298 …r_id634174 0 ps A dialog allows you to split the cell into two or more cells, horizontally or v…
64317 …er\guide\border_object.xhp 0 help par_id3153896 8 0 ps Select the table cells that you want to m…
64438 …alue\> \<bookmark_value\>splitting cells;by keyboard\</bookmark_value\> \<bookmark_value…
64440 …n add or delete rows or columns in tables as well as split or merge table cells using the keyboard…
64693 … 0 ps Open a text document, insert two tables, and type numbers in a few cells in both tables. …
64711 …ntext2.xhp 0 help par_id3154250 6 0 ps You can perform a calculation on cells in one table and d…
64713 …intext2.xhp 0 help par_id3150528 50 0 ps Enter numbers into some of the cells of the large table…
64876 …01.xhp 0 help par_id3145828 4 0 ps Click in a table cell, or select the cells that you want to f…
65501 …he cells.\</ahelp\> You can also use a combination of the following %PRODUCTNAME formatting option…
65507 …BLE_TEXTFLOW:LB_VERTORIENT\"\>Specify the vertical text alignment for the cells in the table.\</ah…
65668 …\".uno:UnsetCellsReadOnly\"\>Removes the cell protection for all selected cells in the current tab…
65702 …DLG_CONV_TEXT_TABLE:CB_BORDER\"\>Adds a border to the table and the table cells.\</ahelp\> 2018…
66040 …visible\"\>Automatically adjusts row heights to match the contents of the cells.\</ahelp\> This is…
67017 …Width\"\>Automatically adjusts column widths to match the contents of the cells.\</ahelp\> Changin…
67018 … ps The change affects only selected cells. You can adjust multiple cells next to each other if yo…
67254 …IGHT\"\>Automatically adjusts the row height to match the contents of the cells.\</ahelp\> 2018…
67757 … 0 ps \<ahelp hid=\".uno:Protect\"\>Prevents the contents of the selected cells from being modifie…
67773 …at you can use to adjust page margins, tab stops, indents, borders, table cells, and to arrange ob…
67854 …id=\"SW:CHECKBOX:DLG_INSERT_TABLE:CB_BORDER\"\>Adds a border to the table cells.\</ahelp\> 2018…