+ + + + +Table (Options) +/text/shared/optionen/01040500.xhp + + +Sun Microsystems, Inc. + + + +

+inserting; new text tables defaults +tables in text; default settings +aligning;tables in text +number formats; recognition in text tables + + + +

Table

+Defines the attributes of tables in text documents. +

+Specifies the default settings for columns and rows and the table mode. Also specifies the standard values for moving and inserting columns and rows. For further information see Editing Tables Using the Keyboard + in the $[officename] Writer Help. +

Default

+Defines the defaults for all newly created text tables in text documents. +

+ +

Heading

+Specifies that the first row of the table is formatted with the "Table heading" Paragraph Style. +

+ +

Repeat on each page

+Specifies whether the table heading is carried over onto the new page after a page break. +

+ +

Do not split (not in HTML)

+Specifies that tables are not split by any type of text flow break. You can also find this option in menu Table - Properties - Text Flow. +

+ +

Border

+Specifies that table cells have a border by default. +

Input in tables

+ + +

Number recognition

+Specifies that numbers entered into a text table cell are recognized and formatted as numbers. Table cells in %PRODUCTNAME Writer can recognize a number when it is represented in one of the number formats available in categories of Numbers, Percent, Currency, Date, Time, Scientific, Fraction and Boolean. +

+ +The recognized number is displayed with default number format for table cells, and sets the cell format to the recognized category. For example, if a number is recognized as Date, the cell format category is set to Date. You can set a specific number format for the cell, for example, a date entered as 8/3/2018 displays as Thursday March 8, 2018 when the cell number format is set to "Friday, December 31, 1999" in the Number Format dialog. + +Recognized Date and Time numbers are converted to internal date and time serial values. Percent numbers are converted internally to their numeric values. Boolean values are converted internally to 0 or 1. +

+When an input cannot be recognized as a number, the number category changes to Text and the input is not changed. + +If Number recognition is not marked, numbers are saved in text format and are automatically left-aligned. +

+ +

Number format recognition

+If Number format recognition is not marked, only input in the format that has been set at the cell is accepted. Any other input resets the format to Text. + +For example, if a cell contains a date value and has its cell format as date, a new input of a percent value in the cell set the cell format to Text and the percent input number is not recognized. + +When Number format recognition is marked, input numbers sets the cell format to the recognized number category. +

+ +

Alignment

+Specifies that numbers are always bottom right aligned in the cell. If this field is not marked numbers are always top left aligned in the cell. +Direct formatting is not influenced by the Alignment field. If you center align the cell contents directly, they remain centered irrespective of whether text or numbers are involved. +

Keyboard handling

+Move cells +Defines the default settings for moving rows and columns with the keyboard. + +Row +Specifies the value to be used for moving a row. + +Column +Specifies the value to be used for moving a column. +

Insert cell

+Specifies the default settings for inserting rows and columns with the keyboard. + +Row +Specifies the default value for inserting rows. + +Column +Specifies the default value for inserting columns. +Behavior of rows/columns +Determines the relative effect of rows and columns on adjacent rows or columns, as well as on the entire table. + +Fixed +Specifies that changes to a row or column only affect the corresponding adjacent area. + +Fixed, proportional +Specifies that changes to a row or column have an effect on the entire table. + +Variable +Specifies that changes to a row or column affect the table size. + +