Lines Matching refs:cells
18355 …\<bookmark_value\>tables; backgrounds\</bookmark_value\>\<bookmark_value\>cells; backgrounds\</boo…
18413 …_value\>borders;for text tables\</bookmark_value\> \<bookmark_value\>cells;borders in text ta…
18485 …okmark_value\> \<bookmark_value\>cells;calculating sums\</bookmark_value\> \<bookmark_va…
19630 …cells\</bookmark_value\> \<bookmark_value\>sections;protecting/unprotecting\</bookmark_value\…
19642 …ot intended to be a secure protection. It is just a switch to protect the cells against accidental…
19646 …0 help par_id3155178 40 0 gl 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…
19940 …ine\>\<defaultinline\>Ctrl\</defaultinline\>\</switchinline\>+A until all cells are selected, and …
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 …
19995 …>\<defaultinline\>Ctrl\</defaultinline\>\</switchinline\>+A until all the cells are selected. 2…
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 gl When you insert or delete cells, rows or columns i…
21081 …at you can use to adjust page margins, tab stops, indents, borders, table cells, and to arrange ob…
22260 …id=\"SW:CHECKBOX:DLG_INSERT_TABLE:CB_BORDER\"\>Adds a border to the table cells.\</ahelp\> 2013…
22981 …he cells.\</ahelp\> You can also use a combination of the following %PRODUCTNAME formatting option…
22987 …BLE_TEXTFLOW:LB_VERTORIENT\"\>Specify the vertical text alignment for the cells in the table.\</ah…
22993 … 0 gl \<ahelp hid=\".uno:Protect\"\>Prevents the contents of the selected cells from being modifie…
22998 …\".uno:UnsetCellsReadOnly\"\>Removes the cell protection for all selected cells in the current tab…
23013 …IGHT\"\>Automatically adjusts the row height to match the contents of the cells.\</ahelp\> 2013…
23017 …visible\"\>Automatically adjusts row heights to match the contents of the cells.\</ahelp\> This is…
23042 …Width\"\>Automatically adjusts column widths to match the contents of the cells.\</ahelp\> Changin…
23043 … gl The change affects only selected cells. You can adjust multiple cells next to each other if yo…
23524 …DLG_CONV_TEXT_TABLE:CB_BORDER\"\>Adds a border to the table and the table cells.\</ahelp\> 2013…
24672 helpcontent2 source\text\swriter\04\01020000.xhp 0 help par_id5891903 0 gl If one or more cells …
24999 …60000.xhp 0 help hd_id0305200910524937 0 gl Include values from hidden cells 20130618 17:22:…
25000 … 0 gl \<ahelp hid=\".\"\>Check to also show values of currently hidden cells within the source …
34497 …r_id4231086 0 gl You can apply different methods to insert spreadsheet cells into your Impress …
34498 …par_id9209875 0 gl Insert a native table - you enter the data into the cells and apply fancy fo…
34502 …e the vertical alignment of selected or all cell contents. Split or merge cells.\</ahelp\> 2013…
34503 …00803551553 0 gl \<ahelp hid=\".\" visibility=\"hidden\"\>All selected cells are merged into on…
34504 … hid=\".\" visibility=\"hidden\"\>The selected cell is split into several cells. You see the Split…
34505 …".\" visibility=\"hidden\"\>The cell contents are align at the top of the cells.\</ahelp\> 2013…
34506 …lity=\"hidden\"\>The cell contents are aligned vertically centered in the cells.\</ahelp\> 2013…
34507 …visibility=\"hidden\"\>The cell contents are aligned at the bottom of the cells.\</ahelp\> 2013…
34511 …ected, all rows will be selected. If currently cells are selected, all rows containing the selecte…
34512 …cted, a new row will be inserted at the bottom of the table. If currently cells are selected, as m…
34516 …d, all columns will be selected. If currently cells are selected, all columns containing the selec…
34517 …ew column will be inserted at the right border of the table. If currently cells are selected, as m…
34523 …48496 0 gl Double-click the table and enter or paste the data into the cells. 20130618 17:2…
34526 …\guide\table_insert.xhp 0 help par_id0916200803551725 0 gl Select some cells and right-click to…
34527 ….xhp 0 help par_id091620080355171 0 gl To select a rectangular area of cells, point to a cell i…
36838 …xhp 0 help par_id8266853 0 gl 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…
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…
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…
37033 …e\>Ctrl \</defaultinline\>\</switchinline\>if you do not want to fill the cells with different val…
37034 … 0 gl If you select two or more adjacent cells that contain different numbers, and drag, the rem…
37066 …help bm_id3150868 0 gl \<bookmark_value\>values; inserting in multiple cells\</bookmark_value\>…
37068 …d7147129 0 gl Calc can simplify entering data and values into multiple cells. You can change so…
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…
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 gl \<bookmark_value\>drag and drop; referencing cells\</bookmark_value\> \<bookmark_value\>…
37136 … \<bookmark_value\>references; to cells in other sheets/documents\</bookmark_value\> \<boo…
37171 … help par_id3151385 15 0 gl If you would like to apply a formula to all cells in a selected area…
37182 … 0 gl \<bookmark_value\>conditional formatting; cells\</bookmark_value\> \<bookmark_value\>…
37317 …gl If, under \<item type=\"menuitem\"\>Language\</item\>, you convert the cells to "English (US)",…
37357 …hp 0 help par_id121020081121549 0 gl If you select a range of cells, only these cells will get …
37359 …guide\database_sort.xhp 0 help par_id121020081121547 0 gl The range of cells that will get sort…
37415 …apilot_grouping.xhp 0 help par_idN10667 0 gl Select a cell or range of cells in the pivot table…
37417 …g.xhp 0 help par_idN1066E 0 gl Depending on the format of the selected cells, either a new grou…
37487 ….xhp 0 help par_id9384746 0 gl To remove a filter, so that you see all cells again, click insid…
37517 …cells; formatting\</bookmark_value\>\<bookmark_value\>spreadsheets;formatting\</bookmark_value\>\<…
37526 …d3154733 20 0 gl You can assign a format to any group of cells by first selecting the cells (for…
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 gl Pressing the mouse button, drag a range across two cells, do not release th…
37739 …ne\>Ctrl\</defaultinline\>\</switchinline\>, click each of the additional cells. 20130618 17:22…
37740 … STD / EXT / ADD area in the status bar until it shows ADD. Now click all cells that you want to s…
37750 …cells. A mouse click in a marked cell unmarks it. Alternatively, \<switchinline select=\"sys\"\>\<…
37766 …cells\</bookmark_value\>\<bookmark_value\>cells; moving by drag and drop \</bookmark_value\>\<book…
37768 …gl When you drag-and-drop a selection of cells on a Calc sheet, the cells normally overwrite the e…
37770 …gl In insert mode, the existing cells where you drop will be shifted to the right or to the bottom…
37771 …ragdrop.xhp 0 help par_id8676717 0 gl The surrounding box of the moved cells looks different in…
37772 …e only the left border when target cells will be shifted to the right. You see only the upper bord…
37773 … between source and target cells, if you move within the same sheet. It depends on the number of h…
37774 …06 0 gl If you move cells in insert mode within the same row (only horizontally), then after in…
37779 … par_id2815637 0 gl Cells are moved and overwrite the cells in the target area. Source cells ar…
37781 …par_id4278389 0 gl Cells are copied and overwrite the cells in the target area. Source cells st…
37783 …_id5369121 0 gl Links to the source cells are inserted and overwrite the cells in the target ar…
37785 …419 0 gl Cells are moved and shift the cells in the target area to the right or to the bottom. …
37786 …id4021423 0 gl If you move within the same rows on the same sheet, the cells in the target area…
37788 …19 0 gl Cells are copied and shift the cells in the target area to the right or to the bottom. …
37790 … 0 gl Links to the source cells are inserted and shift the cells in the target area to the right o…
37803 …nter a formula to calculate a result from values that are stored in other cells. Then, you set up …
37811 …gl Select the range D2:E11, and thus the values in column D and the empty cells alongside in colum…
37825 …cell\</emph\> fields are used to enter the reference to the corresponding cells of the formula. …
37853 …cells\</bookmark_value\> \<bookmark_value\>cells;comments\</bookmark_value\> \<bookmark_…
37867 …_text.xhp 0 help par_id0908200901265127 0 gl 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 gl \<emph\>Selected cells\</emph\> - All selected cells are…
37955 …cells\</bookmark_value\>\<bookmark_value\>printing; cells\</bookmark_value\>\<bookmark_value\>rang…
38052 …veral scenarios on the same sheet, each with some different values in the cells. Then you can easi…
38055 …id3154020 17 0 gl Select the cells that contain the values that will change between scenarios. T…
38066 …rder of a set of cells that are part of a scenario, open the \<emph\>Properties\</emph\> dialog fo…
38067 …mph\>Tools - Detective - Trace Dependents\</emph\>. You see arrows to the cells that are directly …
38074 …e\>Ctrl \</defaultinline\>\</switchinline\>if you do not want to fill the cells with different val…
38140 …cells; merging/unmerging\</bookmark_value\> \<bookmark_value\>tables; merging cells\</bookmar…
38143 …cells into a target range containing merged cells, the target range gets unmerged first, then the …
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\<…
38244 …cells; defining names\</bookmark_value\> \<bookmark_value\>names; defining for cells\</bookma…
38254 …anges must not include blanks. Blanks are allowed within names for single cells, sheets and docume…
38255 helpcontent2 source\text\scalc\guide\value_with_name.xhp 0 help hd_id1226233 0 gl Naming cells a…
38603 …ists\</bookmark_value\> \<bookmark_value\>selection lists;filling cells\</bookmark_value\>…
38605 ….xhp 0 help par_id3156285 2 0 gl \<ahelp hid=\".\"\>Automatically fills cells with content.\</ah…
38606 …xhp\" name=\"other options\"\>additional options\</link\> for filling the cells. 20130618 17:22…
38609 helpcontent2 source\text\scalc\01\02140000.xhp 0 help par_id3152994 3 0 gl \<emph\>Filling cells …
38620 …ed to all the other selected cells. If you have selected several rows, each of the far left cells …
38624 …most cell is copied into the selected cells. If several columns are selected, the contents of the …
38628 …ell is copied into all other cells of the range. If several rows are selected, the far right cells…
38682 …okmark_value\>deleting; cell contents\</bookmark_value\>\<bookmark_value\>cells; deleting contents…
38701 …\"SC_CHECKBOX_RID_SCDLG_DELCONT_BTN_DELNOTES\"\>Deletes comments added to cells. All other element…
38703 …OX_RID_SCDLG_DELCONT_BTN_DELATTRS\"\>Deletes format attributes applied to cells. All cell content …
38707 …cells; deleting cells\</bookmark_value\>\<bookmark_value\>columns; deleting\</bookmark_value\>\<bo…
38709 …teCell\"\>Completely deletes selected cells, columns or rows. The cells below or to the right of t…
38711 …a contains options for specifying how sheets are displayed after deleting cells. 20130618 17:22…
38712 helpcontent2 source\text\scalc\01\02160000.xhp 0 help hd_id3155767 5 0 gl Shift cells up 20130…
38713 …LG_DELCELL:BTN_CELLSUP\"\>Fills the space produced by the deleted cells with the cells underneath …
38714 helpcontent2 source\text\scalc\01\02160000.xhp 0 help hd_id3156382 7 0 gl Shift cells left 201…
38715 …ELCELL:BTN_CELLSLEFT\"\>Fills the resulting space by the cells to the right of the deleted cells.\…
38734 …calc\01\02180000.xhp 0 help par_id2282479 0 gl When you copy and paste cells containing \<link …
38777 …80000.xhp 0 help par_id3145785 0 gl Text cells are formatted in black, formulas in green, and n…
38784 …he Formula Bar is hidden, you can still edit cells by activating the edit mode with F2. After edit…
38792 …xt\scalc\01\03100000.xhp 0 help par_id3155764 19 0 gl Adds the selected cells to print ranges. …
38809 …eadsheets; inserting cells\</bookmark_value\>\<bookmark_value\>cells; inserting\</bookmark_value\>…
38811 …, in which you can insert new cells according to the options that you specify.\</ahelp\>\</variabl…
38813 …id3149262 4 0 gl This area contains the options available for inserting cells into a sheet. The …
38814 helpcontent2 source\text\scalc\01\04020000.xhp 0 help hd_id3146120 5 0 gl Shift cells down 201…
38815 …L:BTN_CELLSDOWN\"\>Moves the contents of the selected range downward when cells are inserted.\</ah…
38816 helpcontent2 source\text\scalc\01\04020000.xhp 0 help hd_id3147434 7 0 gl Shift cells right 20…
38817 …_CELLSRIGHT\"\>Moves the contents of the selected range to the right when cells are inserted.\</ah…
38864 …p\>\</variable\> Before you start the Wizard, select a cell or a range of cells from the current s…
38874 …erate on multiple cells. Each cell in the array contains the formula, not as a copy but as a commo…
38876 … par_id3152993 40 0 gl The maximum size of an array range is 128 by 128 cells. 20130618 17:22…
38899 …emph\>Function Wizard\</emph\>, and transfers the formula to the selected cells. 20130618 17:22…
39017 … you write the criteria in different rows they are connected by OR. Empty cells in the search crit…
39069 …ID_FUNC_DBMITTELWERT\"\>DAVERAGE returns the average of the values of all cells (fields) in all ro…
39078 …79 140 0 gl \<ahelp hid=\"HID_FUNC_DBPRODUKT\"\>DPRODUCT multiplies all cells of a data range wh…
39094 …"\>DSTDEVP calculates the standard deviation of a population based on all cells of a data range wh…
39101 …;sums in Calc databases\</bookmark_value\> \<bookmark_value\>sums;cells in Calc databases\…
39103 …62 0 gl \<ahelp hid=\"HID_FUNC_DBSUMME\"\>DSUM returns the total of all cells in a database fiel…
39112 …0 gl \<ahelp hid=\"HID_FUNC_DBVARIANZ\"\>DVAR returns the variance of all cells of a database fiel…
39145 …calc\01\04060102.xhp 0 help par_id1953489 0 gl When you copy and paste cells containing date va…
39484 …LA function\</bookmark_value\>\<bookmark_value\>formula cells;displaying formulas in other cells\<…
39524 …ark_value\>\<bookmark_value\>recognizing formula cells\</bookmark_value\>\<bookmark_value\>formula…
39551 …mark_value\>blank cell contents\</bookmark_value\>\<bookmark_value\>empty cells; recognizing\</boo…
39634 …alue\>cell information\</bookmark_value\>\<bookmark_value\>information on cells\</bookmark_value\>…
39720 …the current column or row. The result is TRUE if the logical value in all cells within the cell ra…
39789 …/bookmark_value\>\<bookmark_value\>counting;empty cells\</bookmark_value\>\<bookmark_value\>empty …
39791 …l \<ahelp hid=\"HID_FUNC_ANZAHLLEEREZELLEN\"\>Returns the number of empty cells.\</ahelp\> 2013…
39794 …\04060106.xhp 0 help par_id3149512 46 0 gl Returns the number of empty cells in the cell range …
39796 …48 0 gl \<item type=\"input\"\>=COUNTBLANK(A1:B2)\</item\> returns 4 if cells A1, A2, B1, and B2…
39981 …p par_id1604663 0 gl \<item type=\"input\"\>=GCD(B1:B3)\</item\> where cells B1, B2, B3 contain…
40242 … 0 gl \<ahelp hid=\"HID_FUNC_SUMME\"\>Adds all the numbers in a range of cells.\</ahelp\> 2013…
40248 …> calculates the sum of the three cells. \<item type=\"input\"\>=SUM (A1:E10)\</item\> calculates …
40258 …elp par_id3151986 437 0 gl \<ahelp hid=\"HID_FUNC_SUMMEWENN\"\>Adds the cells specified by a giv…
40317 …0 help par_id3143606 498 0 gl \<emph\>Range\</emph\> is the range whose cells are included. 2…
40411 …d2091433 0 gl To generate random numbers which never recalculate, copy cells containing this fu…
40420 …d9312417 0 gl To generate random numbers which never recalculate, copy cells each containing =R…
40423 …\>COUNTIF function\</bookmark_value\>\<bookmark_value\>counting;specified cells\</bookmark_value\>…
40425 …26 548 0 gl \<ahelp hid=\"HID_FUNC_ZAEHLENWENN\"\>Returns the number of cells that meet with cer…
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…
40443 …298 258 0 gl \<variable id=\"wasmatrix\"\>An array is a linked range of cells on a spreadsheet c…
40459 …l The smallest possible array is a 1 x 2 or 2 x 1 array with two adjacent cells. 20130618 17:22…
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…
40475 helpcontent2 source\text\scalc\01\04060107.xhp 0 help par_id3154342 5 0 gl The cells in a results…
40483 …help par_id6757103 0 gl To enter this array constant, you select three cells in a row, then you…
40499 …t\scalc\01\04060107.xhp 0 help par_id3146787 324 0 gl Select a range of cells where you want to …
40900 …t belong to a multiple range.\</ahelp\> A range can consist of contiguous cells or a single cell. …
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 …
40964 … type=\"input\"\>=SUM(INDIRECT("a1:" & ADDRESS(1;3)))\</item\> totals the cells in the area of A1 …
40991 …elp hid=\"HID_FUNC_SVERWEIS\"\>Vertical search with reference to adjacent cells to the right.\</ah…
41087 …help hid=\"HID_FUNC_WVERWEIS\"\>Searches for a value and reference to the cells below the selected…
41123 … 0 help par_id0907200912224576 0 gl The number 0 is returned for empty cells and matrix element…
41155 …alc\01\04060110.xhp 0 help bm_id3145389 0 gl \<bookmark_value\>text in cells; functions\</bookm…
41638 …p 0 help par_id3145202 103 0 gl Number of the following elements. Empty cells are not counted or…
41682 …p 0 help par_id3148621 147 0 gl Number of the following elements. Empty cells are not counted or…
41729 …p 0 help par_id3150647 194 0 gl Number of the following elements. Empty cells are not counted or…
42118 …n quotation marks or as a reference. If you enter the units of measure in cells, they must corresp…
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 gl To calculate the intercept, use cells D3:D9 as the y val…
42793 … empty string of length 0. If an argument is an array or reference, empty cells within the array o…
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 gl These operators return a cell range of zero, one or more cells. 20130618 17:22…
43633 … 71 0 gl 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…
43733 …y a variety of formatting options and to apply attributes to the selected cells.\</ahelp\>\</varia…
43738 …lp hid=\"HID_SCPAGE_PROTECTION\"\>Defines protection options for selected cells.\</ahelp\> 2013…
43741 …GE_PROTECTION:BTN_HIDE_ALL\"\>Hides formulas and contents of the selected cells.\</ahelp\> 2013…
43743 …:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_PROTECTED\"\>Prevents the selected cells from being modifie…
43746 …RID_SCPAGE_PROTECTION:BTN_HIDE_FORMULAR\"\>Hides formulas in the selected cells.\</ahelp\> 2013…
43750 …SC:TRISTATEBOX:RID_SCPAGE_PROTECTION:BTN_HIDE_PRINT\"\>Keeps the selected cells from being printed…
43779 …3145748 4 0 gl To show all hidden cells, first click in the field in the upper left corner. This…
43818 …46 2 0 gl \<ahelp hid=\".\"\>Combines the selected cells into a single cell or splits merged cel…
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 gl 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…
43843 …BOX:RID_SCPAGE_TABLE:BTN_FORMULAS\"\>Prints the formulas contained in the cells, instead of the re…
43845 …\<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_TABLE:BTN_NULLVALS\"\>Specifies that cells with a zero value …
43878 …help par_id3155855 2 0 gl \<ahelp hid=\".\"\>Manages print ranges. Only cells within the print r…
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…
43965 …d, specifies that you want to retain the width and height of the selected cells of the selected fo…
43981 …OND3_2\"\>Choose a condition for the format to be applied to the selected cells.\</ahelp\> 2013…
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 gl Hyphenation for selected cells. 20130618 17:22…
43999 helpcontent2 source\text\scalc\01\06020000.xhp 0 help par_id3150868 5 0 gl 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…
44013 …bm_id3155628 0 gl \<bookmark_value\>cells; tracing precedents\</bookmark_value\>\<bookmark_valu…
44015 …ws the relationship between the current cell containing a formula and the cells used in the formul…
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 gl \<bookmark_value\>cells; removing precedents\</bookmark_value\>\<bookmark_valu…
44023 helpcontent2 source\text\scalc\01\06030300.xhp 0 help bm_id3153252 0 gl \<bookmark_value\>cells;…
44026 helpcontent2 source\text\scalc\01\06030300.xhp 0 help par_id3148948 4 0 gl The area of all cells …
44029 helpcontent2 source\text\scalc\01\06030400.xhp 0 help bm_id3147335 0 gl \<bookmark_value\>cells;…
44033 helpcontent2 source\text\scalc\01\06030500.xhp 0 help bm_id3153088 0 gl \<bookmark_value\>cells;…
44037 helpcontent2 source\text\scalc\01\06030600.xhp 0 help bm_id3153561 0 gl \<bookmark_value\>cells;…
44039 …ShowErrors\" visibility=\"visible\"\>Draws tracer arrows to all precedent cells which cause an err…
44041 …9 0 gl \<bookmark_value\>cells; trace fill mode\</bookmark_value\>\<bookmark_value\>traces; pre…
44046 helpcontent2 source\text\scalc\01\06030800.xhp 0 help bm_id3153821 0 gl \<bookmark_value\>cells;…
44048 … 0 gl \<ahelp hid=\".uno:ShowInvalid\" visibility=\"visible\"\>Marks all cells in the sheet that …
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 gl \<bookmark_value\>cells;…
44058 helpcontent2 source\text\scalc\01\06031000.xhp 0 help bm_id3154515 0 gl \<bookmark_value\>cells;…
44085 …hid=\"SC:CHECKBOX:RID_SCDLG_NEWSCENARIO:CB_TWOWAY\"\>Copies the values of cells that you change in…
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…
44101 …\<variable id=\"tabelletext\"\>\<ahelp hid=\".uno:Protect\"\>Protects the cells in the current she…
44102 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3149664 5 0 gl To protect cells from …
44103 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3154490 8 0 gl Unprotected cells or c…
44104 helpcontent2 source\text\scalc\01\06060100.xhp 0 help par_id3149123 16 0 gl Select the cells that…
44127 helpcontent2 source\text\scalc\01\06070000.xhp 0 help par_id3145173 3 0 gl All cells are recalcul…
44138 … the same column.\</ahelp\> The column is scanned up to a maximum of 2000 cells or 200 different s…
44159 …hid=\".uno:DefineDBName\"\>Defines a database range based on the selected cells in your sheet.\</a…
44173 helpcontent2 source\text\scalc\01\12010100.xhp 0 help hd_id3153970 5 0 gl Insert or delete cells …
44178 …le\"\>Only saves a reference to the database, and not the contents of the cells.\</ahelp\> 2013…
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…
44378 …alue\>showing; sheet details\</bookmark_value\>\<bookmark_value\>grouping;cells\</bookmark_value\>…
44431 … 0 help par_id3147363 27 0 gl The cells for the 1st and 2nd quarters each contain a sum formula …
44451 …00.xhp 0 help par_id3125865 8 0 gl \<ahelp hid=\".\"\>Uses the selected cells as the data source…
44507 helpcontent2 source\text\scalc\01\12090102.xhp 0 help par_idN108E6 0 gl Select a range of cells …
44704 …e, or as a named range. The range may consist of one column or one row of cells. If you specify a …
44709 helpcontent2 source\text\scalc\01\12120100.xhp 0 help hd_id3154704 7 0 gl Allow blank cells 20…
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 gl To expand cell contents to multiple cells 20130618 17:22:…
45076 … help par_id2021546 0 gl You can expand cells that contain comma separated values (CSV) into mu…
45078 …scalc\01\text2columns.xhp 0 help par_id7242042 0 gl Select the cell or cells that you want to e…
45081 …iew shows how the current cell contents will be transformed into multiple cells. 20130618 17:22…
45212 …00.xhp 0 help par_id3153967 84 0 gl To create a matrix in which all the cells contain the same i…
45213 …xt\scalc\04\01020000.xhp 0 help par_id3166426 4 0 gl To select multiple cells in different areas…
45259 helpcontent2 source\text\scalc\04\01020000.xhp 0 help par_id9901425 0 gl Insert cells (as in men…
45261 helpcontent2 source\text\scalc\04\01020000.xhp 0 help par_id5104220 0 gl Delete cells (as in men…
45265 …07055 0 gl Displays or hides the formulas instead of the values in all cells. 20130618 17:22…
46824 …0 gl In spreadsheets this background appears only in the print behind the cells not formatted else…
46863 …cells\</bookmark_value\> \<bookmark_value\>cells; line breaks\</bookmark_value\> \<bookm…
47034 … gl If you drag cells to the normal view of a presentation document, the cells will be inserted th…
48409 …s between Calc and Excel is the handling of boolean values. Enter TRUE to cells A1 and A2. 201…
48536 …\shared\guide\paintbrush.xhp 0 help par_idN106EC 0 gl Text within Calc cells is selected 201…
49798 helpcontent2 source\text\shared\00\00000207.xhp 0 help hd_id783149793 0 gl 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 gl \<ahelp hid=\".\"\>When this option is enabled, fields or cells whose values are q…
51261 …e\>\<bookmark_value\>number of sheets\</bookmark_value\>\<bookmark_value\>cells;number of\</bookma…
51270 …l \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Number of cells with content in th…
51631 …>\<bookmark_value\>clipboard; pasting\</bookmark_value\>\<bookmark_value\>cells;pasting\</bookmark…
51634 …\<caseinline select=\"CALC\"\>In a spreadsheet, when you paste a range of cells from the clipboard…
51644 …CALC\"\>This dialog appears in Calc if the clipboard contains spreadsheet cells. \</caseinline\>\<…
51650 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing text. \…
51652 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing numbers…
51654 …\"\>\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserts cells containing date an…
51656 …"\>\<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_INSCONT:BTN_INSFORMULAS\"\>Inserts cells containing formula…
51658 …pl\"\>\<caseinline select=\"CALC\"\>Inserts comments that are attached to cells. If you want to ad…
51664 …<caseinline select=\"CALC\"\>Select the operation to apply when you paste cells into your sheet. \…
51668 …the clipboard cells to the values in the target cells. Also, if the clipboard only contains commen…
51670 … select=\"CALC\"\>Subtracts the values in the clipboard cells from the values in the target cells.…
51672 …select=\"CALC\"\>Multiplies the values in the clipboard cells with the values in the target cells.…
51674 …line select=\"CALC\"\>Divides the values in the target cells by the values in the clipboard cells.…
51677 … \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Skip empty cells \</caseinline\>\</…
51678 …HECKBOX:RID_SCDLG_INSCONT:BTN_SKIP_EMPTY\"\>Empty cells from the clipboard do not replace target c…
51679 …cells \</emph\>box, empty cells in the clipboard are treated as zeroes. For example, if you apply …
51683 …o that changes made to the cells in the source file are updated in the target file. To ensure that…
51686 …ppl\"\>\<caseinline select=\"CALC\"\>Set the shift options for the target cells when the clipboard…
51688 …line select=\"appl\"\>\<caseinline select=\"CALC\"\>Inserted cells replace the target cells. \</ca…
51690 …lect=\"appl\"\>\<caseinline select=\"CALC\"\>Target cells are shifted downward when you insert cel…
51692 …ct=\"appl\"\>\<caseinline select=\"CALC\"\>Target cells are shifted to the right when you insert c…
51696 …line select=\"appl\"\> \<caseinline select=\"CALC\"\>To select all of the cells on a sheet, click …
51712 …\"SVX:CHECKBOX:RID_SVXDLG_SEARCH:BTN_CELLS\"\>Searches for whole words or cells that are identical…
51723 …id3150866 48 0 gl \<ahelp hid=\".\"\>Searches only the selected text or cells.\</ahelp\> 2013…
51761 … the characters that you specify in the comments that are attached to the cells.\</caseinline\>\</…
51762 … the characters that you specify in the comments that are attached to the cells.\</ahelp\> 2013…
51764 …l\"\>\<caseinline select=\"CALC\"\>Determines the order for searching the cells.\</caseinline\>\</…
51859 …001.xhp 0 help par_id952368773 0 gl ^([:digit:])$ -- finds lines or cells with exactly one d…
52277 …l \<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Lists the cells with contents that…
52321 …ters the list of changes according to the range of cells that you specify. To select a range of ce…
52322 …1663 0 gl \<ahelp hid=\".\" visibility=\"hidden\"\>Select the range of cells that you want to u…
52325 … 0 gl \<ahelp hid=\"HID_REDLINING_FILTER_BTN_REF\"\>Select the range of cells that you want to u…
52328 …hid=\"SC:IMAGEBUTTON:RID_SCDLG_SIMPLEREF:RB_ASSIGN\"\>Select the range of cells that you want to u…
52601 …<bookmark_value\>deleting; hyperlinks\</bookmark_value\>\<bookmark_value\>cells;resetting formats\…
52631 …help par_id3153770 59 0 gl You can only change the language setting for cells (choose \<emph\>Fo…
52700 …cells \</caseinline\>\<defaultinline\>fields\</defaultinline\>\</switchinline\>. With the language…
52703 …VXPAGE_NUMBERFORMAT_CB_SOURCEFORMAT\"\>Uses the same number format as the cells containing the dat…
52916 …e select=\"CALC\"\>If you perform a calculation that involves one or more cells using a date forma…
53093 …par_id3153124 2 0 gl \<ahelp hid=\".\"\>Set the typographic options for cells or paragraphs in A…
53228 …\<ahelp hid=\"700793922\"\>Merges two different border styles of adjacent cells in a Writer table …
53234 … footers, text frames, tables, table cells, sections, and indexes.\</caseinline\>\<caseinline sele…
53381 …pl\"\>\<caseinline select=\"CALC\"\>Specify the alignment options for the cells on a printed page.…
53382 …200809473845 0 gl \<ahelp hid=\".\" visibility=\"hidden\"\>Centers the cells horizontally on th…
53384 …\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Centers the cells horizontally on th…
53385 …200809473811 0 gl \<ahelp hid=\".\" visibility=\"hidden\"\>Centers the cells vertically on the …
53387 …\<switchinline select=\"appl\"\>\<caseinline select=\"CALC\"\>Centers the cells vertically on the …
53573 …dentext\"\>\<ahelp hid=\".\"\>Combines the contents of the selected table cells into a single cell…
53581 …\".uno:SplitCell\"\>Splits the cell or group of cells horizontally or vertically into the number o…
53592 …id3154638 12 0 gl \<ahelp hid=\"SW_CHECKBOX_DLG_SPLIT_CB_PROP\"\>Splits cells into rows of equal…
54338 …elp bm_id3154545 0 gl \<bookmark_value\>aligning; cells\</bookmark_value\>\<bookmark_value\>cel…
54340 …e alignment options for the contents of the current cell, or the selected cells.\</ahelp\> 2013…
54399 ….\" visibility=\"hidden\"\>Select database records. Drag-and-drop rows or cells to the document to…
56850 … hid=\".\"\>Check boxes and radio buttons in spreadsheets can be bound to cells in the current doc…
59468 …cells will be formatted as in Writer versions prior to StarOffice 8 or OpenOffice.org 2.0. If the …
59558 …cells; showing grid lines (Calc)\</bookmark_value\> \<bookmark_value\>borders; cells on sc…
59586 …n different colors, depending on type. Text cells are formatted in black, formulas in green, and n…
59669 …lue\> \<bookmark_value\>search criteria for database functions in cells\</bookmark_value\>…
59731 … of decimal places that are shown by default for cells with General number format. If not enabled,…