Collabora Office 24.04 Help

Collabora Office

English (USA)Arabic Bulgarian Catalan Czech Danish German Greek English (UK)Esperanto Spanish Basque Finnish French Galician Hebrew Croatian Hungarian Indonesian Icelandic Italian Japanese Korean Lao Norwegian Bokmål Dutch Polish Portuguese Portuguese (Brazil)Albanian Russian Slovak Slovenian Swedish Turkish Ukrainian Vietnamese Chinese (Simplified)Chinese (Traditional)

Contents

Text Documents (Writer)
- General Information and User Interface Usage
- Command and Menu Reference
  - Menus
    - Menus
    - File
    - Edit
    - View
    - Insert
    - Format
    - Table
    - Form Menu
    - Main Tools Menu
    - Window
    - Help
  - Toolbars
- Navigating Text Documents
- Formatting Text Documents
- Templates and Styles
- Graphics in Text Documents
- Tables in Text Documents
- Objects in Text Documents
  - Positioning Objects
  - Wrapping Text Around Objects
- Sections and Frames in Text Documents
- Tables of Contents and Indexes
- Fields in Text Documents
- Calculating in Text Documents
- Special Text Elements
- Automatic Functions
- Numbering and Lists
- Spell Checking, Thesaurus and Languages
- Troubleshooting Tips
  - Inserting Text Before a Table at the Top of Page
  - Going to Specific Bookmark
- Loading, Saving, Importing, Exporting and Redacting
- Master Documents
  - Master Documents and Sub-documents
- Links and References
  - Inserting Cross-References
  - Inserting Hyperlinks With the Navigator
- Printing
- Searching and Replacing
  - Using Regular Expressions in Text Searches
  - List of Regular Expressions

HTML Documents (Writer Web)

Spreadsheets (Calc)
- General Information and User Interface Usage
- Command and Menu Reference
  - Menus
    - Menus
    - File
    - Edit
    - View
    - Insert
    - Format
    - Sheet
    - Data
    - Main Tools Menu
    - Window
    - Help
  - Toolbars
- Functions Types and Operators
- Loading, Saving, Importing, Exporting and Redacting
- Formatting
- Filtering and Sorting
- Printing
- Data Ranges
- Pivot Table
- Pivot Chart
- Data Analysis
- Scenarios
  - Using Scenarios
- Subtotals
  - Using Subtotals Tool
- References
- Viewing, Selecting, Copying
- Formulae and Calculations
- Protection
  - Protecting Cells from Changes
  - Unprotecting Cells
- Writing Calc Macros
  - Reading and Writing values to Ranges
  - Formatting Borders in Calc with Macros
- Miscellaneous

Presentations (Impress)
- General Information and User Interface Usage
- Command and Menu Reference
  - Menus
    - Menus
    - File
    - Edit
    - View
    - Insert
    - Format
    - Slide
    - Slide Show
    - Main Tools Menu
    - Window
    - Help
  - Toolbars
- Loading, Saving, Importing, Exporting and Redacting
- Formatting
- Printing
  - Printing Presentations
  - Printing a Slide to Fit a Paper Size
- Effects
- Objects, Graphics and Bitmaps
- Text in Presentations
  - Adding Text
  - Converting Text Characters into Drawing Objects
- Viewing
  - Changing the Slide Order
  - Zooming With the Keypad
- Slide Shows

Drawings (Draw)
- General Information and User Interface Usage
- Command and Menu Reference
  - Menus
    - Menus
    - File
    - Edit
    - View (menu in Draw)
    - Insert
    - Format
    - Page
    - Shape
    - Main Tools Menu
    - Window
    - Help
  - Toolbars
- Loading, Saving, Importing and Exporting
  - Loading Colour, Gradient, and Hatching Palettes
  - Inserting Graphics
- Formatting
- Printing
  - Printing Presentations
  - Printing a Slide to Fit a Paper Size
- Effects
- Objects, Graphics and Bitmaps
- Groups and Layers
- Text in Drawings
  - Adding Text
  - Converting Text Characters into Drawing Objects
- Viewing
  - Zooming With the Keypad

Database Functionality (Base)
- General Information

Formulae (Math)
- General Information and User Interface Usage
  - Welcome to the Collabora Office Math Help
  - Collabora Office Math Features
  - Collabora Office Formula Elements
  - Instructions for Using Collabora Office Math
  - Shortcuts (Collabora Office Math Accessibility)
- Command and Menu Reference
  - Menus
  - Toolbars
- Working with Formulae

Charts and Diagrams
- General Information

Macros and Scripting

Collabora Office Installation
- Changing the Association of Microsoft Office Document Types
- Safe Mode

Common Help Topics
- General Information
- Collabora Office and Microsoft Office
- Collabora Office Options
- Wizards
  - Wizard
  - Letter Wizard
    - Letter Wizard
  - Fax Wizard
    - Fax Wizard
  - Agenda Wizard
    - Agenda Wizard
  - Document Converter Wizard
    - Document Converter
  - Euro Converter Wizard
- Configuring Collabora Office
- Working with the User Interface
- Digital Signatures
- Printing, Faxing, Sending
- Drag & Drop
- Copy and Paste
- Charts and Diagrams
  - Inserting Charts
  - Charts in Collabora Office
- Load, Save, Import, Export, PDF
- Links and References
- Document Version Tracking
- Labels and Business Cards
  - Creating and Printing Labels and Business Cards
- Inserting External Data
- Automatic Functions
  - Turning off Automatic URL Recognition
- Searching and Replacing
- Guides

⇤
←
1
2
3
4
5
6
→
⇥

### error message#N/A error -- assigning to a cell #N/A error -- recognising #N/A error -- testing #N/A error message #NAME error message #REF error message ABS function ACCRINT function ACCRINTM function ACOS function ACOSH function ACOT function ACOTH function ADDRESS function AGGREGATE function AMORDEGRC function AMORLINC function AND function ANOVA -- Analysis toolpack ARABIC function AREAS function ASC function ASIN function ASINH function ATAN function ATAN2 function ATANH function AVEDEV function AVERAGE function AVERAGEA function AVERAGEIF function AVERAGEIFS function Analysis toolpack -- ANOVA Analysis toolpack -- Chi-square test Analysis toolpack -- F-test Analysis toolpack -- Fourier analysis Analysis toolpack -- Z-test Analysis toolpack -- analysis of variance Analysis toolpack -- correlation Analysis toolpack -- covariance Analysis toolpack -- descriptive statistics Analysis toolpack -- exponential smoothing Analysis toolpack -- moving average Analysis toolpack -- paired t-test Analysis toolpack -- regression analysis Analysis toolpack -- sampling Analysis toolpack -- t-test Asian languages -- sorting AutoCalculate function in sheets AutoCorrect function -- cell contents AutoFill function AutoFilter function -- subtotals AutoFilter function -- applying AutoFormat cell ranges AutoInput function on/off AutoSum button, see sum icon B function BAHTTEXT function BASE function BESSELI function BESSELJ function BESSELK function BESSELY function BETA.DIST function BETA.INV function BETADIST function BETAINV function BIN2DEC function BIN2HEX function BIN2OCT function BINOM.DIST function BINOM.INV function BINOMDIST function BITAND function BITLSHIFT function BITOR function BITRSHIFT function BITXOR function Basic IDE for user-defined functions Bessel functions CEILING function CEILING.MATH function CEILING.PRECISE function CEILING.XCL function CELL function CHAR function CHIDIST function CHIINV function CHISQ.DIST function CHISQ.DIST.RT function CHISQ.INV function CHISQ.INV.RT function CHISQ.TEST function CHISQDIST function CHISQINV function CHITEST function CHOOSE function CLEAN function CODE function COLOR function COLUMN function COLUMNS function COMBIN function COMBINA function COMPLEX function CONCAT function CONCATENATE function CONFIDENCE function CONFIDENCE.NORM function CONFIDENCE.T function CONVERT function CONVERT_OOO function CORREL function COS function COSH function COT function COTH function COUNT function COUNTA function COUNTBLANK function COUNTIF function COUNTIFS function COUPDAYBS function COUPDAYS function COUPDAYSNC function COUPNCD function COUPNUM function COUPPCD function COVAR function COVARIANCE.P function COVARIANCE.S function CRITBINOM function CSC function CSCH function CSV files -- formulae CSV files -- importing and exporting CTL -- right-to-left sheets CUMIPMT function CUMIPMT_ADD function CUMPRINC function CUMPRINC_ADD function CURRENT function Chi-square test -- Analysis toolpack Confidence level -- regression analysis DATE function DATEDIF function DATEVALUE function DAVERAGE function DAY function DAYS function DAYS360 function DAYSINMONTH function DAYSINYEAR function DB function DCOUNT function DCOUNTA function DDB function DDE function DEC2BIN function DEC2HEX function DEC2OCT function DECIMAL function DEGREES function DELTA function DEVSQ function DGET function DISC function DMAX function DMIN function DOLLAR function DOLLARDE function DOLLARFR function DPRODUCT function DSTDEV function DSTDEVP function DSUM function DURATION function DVAR function DVARP function Data Stream -- Live data stream Data Stream -- Streams Data statistics -- ANOVA Data statistics -- Chi-square test Data statistics -- F-test Data statistics -- Fourier analysis Data statistics -- Z-test Data statistics -- analysis of variance Data statistics -- correlation Data statistics -- covariance Data statistics -- descriptive statistics Data statistics -- exponential smoothing Data statistics -- moving average Data statistics -- paired t-test Data statistics -- regression analysis Data statistics -- sampling DataPilot, see pivot table function Detective EASTERSUNDAY function EDATE function EFFECT function EFFECT_ADD function ENCODEURL function EOMONTH function ERF function ERF.PRECISE function ERFC function ERFC.PRECISE function ERROR.TYPE function ERRORTYPE function EUROCONVERT function EVEN function EXACT function EXP function EXPON.DIST function EXPON.DIST function Euro -- converting F-test -- Analysis toolpack F.DIST function F.DIST.RT function F.INV function F.INV.RT function F.TEST function F2 -- cell edit mode FACT function FACTDOUBLE function FALSE function FDIST function FILTERXML function FIND function FINDB Function FINV function FISHER function FISHERINV function FIXED function FLOOR function FLOOR.MATH function FLOOR.PRECISE function FLOOR.XCL function FORECAST function FORECAST function FORECAST.ETS.ADD function FORECAST.ETS.MULT function FORECAST.ETS.PI.ADD function FORECAST.ETS.PI.MULT function FORECAST.ETS.SEASONALITY function FORECAST.ETS.STAT.ADD function FORECAST.ETS.STAT.MULT function FORMULA function FOURIER function FREQUENCY function FTEST function FV function FVSCHEDULE function Formula Auditing,see Detective Fourier analysis -- Analysis toolpack Function Wizard -- add-ins Function Wizard -- arrays Function Wizard -- databases Function Wizard -- date & time Function Wizard -- financial Function Wizard -- information Function Wizard -- logical Function Wizard -- mathematical Function Wizard -- spreadsheets Function Wizard -- statistics Function Wizard -- text GAMMA function GAMMA.DIST function GAMMA.INV function GAMMADIST function GAMMAINV function GAMMALN function GAMMALN.PRECISE function GAUSS function GCD function GCD_EXCEL2003 function GEOMEAN function GESTEP function GETPIVOTDATA function GROWTH function Gaussian error integral Gaussian error integral Go to sheet HARMEAN function HEX2BIN function HEX2DEC function HEX2OCT function HLOOKUP function HOUR function HTML -- in sheet cells HTML -- sheets HTML WebQuery HYPERLINK function HYPGEOM.DIST function HYPGEOMDIST function Help tips -- defining text for cell input HowTos for Calc IDE -- Basic IDE IF function IFERROR function IFNA function IFS function IMABS function IMAGINARY function IMARGUMENT function IMCONJUGATE function IMCOS function IMCOSH function IMCOT function IMCSC function IMCSCH function IMDIV function IMEXP function IMLN function IMLOG10 function IMLOG2 function IMPOWER function IMPRODUCT function IMREAL function IMSEC function IMSECH function IMSIN function IMSINH function IMSQRT function IMSUB function IMSUM function IMTAN function INDEX function INDIRECT function INFO function INT function INTERCEPT function INTRATE function IPMT function IRR function ISBLANK function ISERR function ISERROR function ISEVEN function ISEVEN_ADD function ISFORMULA function ISLEAPYEAR function ISLOGICAL function ISNA function ISNONTEXT function ISNUMBER function ISO.CEILING function ISODD function ISODD_ADD function ISOWEEKNUM function ISPMT function ISREF function ISTEXT function JIS function KURT function LARGE function LCM function LCM_EXCEL2003 function LEFT function LEFTB function LEN function LENB function LINEST function LN function LOG function LOG10 function LOGEST function LOGINV function LOGNORM.DIST function LOGNORM.INV function LOGNORMDIST function LOOKUP function LOWER function MATCH function MAX function MAXA function MAXIFS function MDETERM function MDURATION function MEDIAN function MID function MIDB function MIN function MINA function MINIFS function MINUTE function MINVERSE function MIRR function MMULT function MOD function MODE function MODE.MULT function MODE.SNGL function MONTH function MONTHS function MROUND function MULTINOMIAL function MUNIT function Macauley duration N function NA function NEGBINOM.DIST function NEGBINOMDIST function NETWORKDAYS function NETWORKDAYS.INTL function NETWORKDAYS_EXCEL2003 function NOMINAL function NOMINAL_ADD function NORM.DIST function NORM.INV function NORM.S.DIST function NORM.S.INV function NORMDIST function NORMINV function NORMSDIST function NORMSINV function NOT function NOW function NPER function NPV function NUMBERVALUE function Navigator -- for sheets OCT2BIN function OCT2DEC function OCT2HEX function ODD function ODDFPRICE function ODDFYIELD function ODDLPRICE function ODDLYIELD function OFFSET function OPT_BARRIER function OPT_PROB_HIT function OPT_PROB_INMONEY function OPT_TOUCH function OR function PDF export of print ranges PDURATION function PEARSON function PERCENTILE function PERCENTILE.EXC function PERCENTILE.INC function PERCENTRANK function PERCENTRANK.EXC function PERCENTRANK.INC function PERMUT function PERMUTATIONA function PHI function PI function PMT function POISSON function POISSON.DIST function POWER function PPMT function PRICE function PRICEDISC function PRICEMAT function PROB function PRODUCT function PROPER function PV function QUARTILE function QUARTILE.EXC function QUARTILE.INC function QUOTIENT function RADIANS function RAND function RAND.NV function RANDBETWEEN function RANDBETWEEN.NV function RANK function RANK.AVG function RANK.EQ function RATE function RAWSUBTRACT function RECEIVED function REGEX function REPLACE function REPLACEB Function REPT function RIGHT function RIGHTB function ROMAN function ROT13 function ROUND function ROUNDDOWN function ROUNDSIG Function ROUNDUP function ROW function ROWS function RRI function RSQ calculations RSQ function SEARCH function SEARCHB Function SEC function SECH function SECOND function SERIESSUM function SHEET function SHEETS function SIGN function SIN function SINH function SKEW function SKEWP function SLN function SLOPE function SMALL function SQRT function SQRTPI function STANDARDISE function STDEV function STDEV.P function STDEV.S function STDEVA function STDEVP function STDEVPA function STEYX function STYLE function example STYLE function SUBSTITUTE function SUBTOTAL function SUM function SUMIF function SUMIFS function SUMPRODUCT function SUMSQ function SUMX2MY2 function SUMX2PY2 function SUMXMY2 function SWITCH function SYD function Solver for Nonlinear Problems -- Options Styles window Stylist, see Styles window T function T.DIST function T.DIST.2T function T.DIST.RT function T.INV function T.INV.2T function T.TEST function TAN function TANH function TBILLEQ function TBILLPRICE function TBILLYIELD function TDIST function TEXT function TEXTJOIN function TIME function TIMEVALUE function TINV function TODAY function TRANSPOSE function TREND function TRIM function TRIMMEAN function TRUE function TRUNC function TTEST function TYPE function UNICHAR function UNICODE function UPPER function URL -- in Calc VALUE function VAR function VAR.P function VAR.S function VARA function VARP function VARPA function VDB function VLOOKUP function Values of the inverse left tail of the F distribution Values of the inverse right tail of the F distribution WEBSERVICE function WEEKDAY function WEEKNUM function WEEKNUM_EXCEL2003 function WEEKNUM_OOO function WEEKS function WEEKSINYEAR function WEIBULL function WEIBULL.DIST function WORKDAY function WORKDAY.INTL function WebQuery filter XIRR function XML Source -- load XML data in spreadsheets XNPV function XOR function YEAR function YEARFRAC function YEARS function YIELD function YIELDDISC function YIELDMAT function Z-test -- Analysis toolpack Z.TEST function ZTEST function Zoom -- spreadsheet Zoom in -- spreadsheet Zoom out -- spreadsheet absolute addresses in spreadsheets absolute references in spreadsheets absolute values accessibility -- Collabora Office Calc shortcuts accrued interests -- one-off payments accrued interests -- periodic payments accumulated interest actions in case of incorrect input add-ins -- analysis functions add-ins -- for programming add-ins -- functions adding -- numbers in cell ranges adding -- specified numbers address -- of cell addresses -- to cells in other sheets/documents addressing -- automatic addressing -- by defined names addressing -- relative and absolute adjacent cells -- remove border adjusting array ranges advanced filters algebraic signs allowances allowed cell names amortisation instalment amortisations, see also depreciations amount received for fixed-interest securities analysis functions analysis of variance -- Analysis toolpack anchor -- image annual net interest rates annual return on treasury bills annuities appending sheets areas, see also cell ranges arithmetic declining depreciations arithmetic lists arithmetic mean -- satisfying condition arithmetic mean -- satisfying conditions arithmetic-degressive depreciations arithmetical operators array formulas attributes -- cells automatic addressing in tables automatic cell filling automatic date updates automatic hyphenation in spreadsheets averages -- in Calc databases averages -- statistical functions back-solving backgrounds -- cell ranges backgrounds -- cells and pages base-10 logarithm binary system -- converting to blank cell content borders -- printing cells borders -- cells and pages borders -- cells breaks in cells calculate -- force recalculation calculate -- recalculate hard calculating -- accumulated interest calculating -- annual net interest rates calculating -- arithmetic-degressive depreciations calculating -- auto calculating sheets calculating -- conditional calculations calculating -- depreciations calculating -- durations calculating -- geometric-degressive depreciations calculating -- interests for unchanged amortisation instalments calculating -- present values calculating -- series calculating -- spreadsheets calculating -- total amortisation rates calculating -- with formulae calculating -- annuities calculating -- averages in Calc databases calculating -- constant interest rates calculating -- future values calculating -- internal rates of return, irregular payments calculating -- internal rates of return, regular payments calculating -- linear depreciations calculating -- modified internal rates of return calculating -- multiple sheets calculating -- net present values calculating -- nominal interest rates calculating -- number of payment periods calculating -- pivot table calculating -- rates of return calculating -- rounded off values calculating -- sums in Calc databases calculating -- time differences calculating -- variable declining depreciations calculating -- variables in equations calculation -- accuracy capital letters -- AutoInput function (in cells)capital letters -- AutoInput function categories of functions cell -- address cell -- insert date cell -- insert time cell attributes cell content -- deleting cell content -- no text cell content -- numbers cell content -- text cell contents -- recalculating cell contents -- AutoCalculate function cell contents -- force recalculation cell contents -- searching in Calc databases cell contents -- testing for references cell edit mode cell formats -- assigning by formulae cell formats -- conditional cell formats -- text/numbers cell heights cell information cell input -- AutoInput function cell links search cell names -- defining/addressing cell protection -- enabling cell protection -- unprotecting cell ranges -- defining names cell ranges -- inserting named ranges cell ranges -- printing cell ranges -- applying/removing filters cell ranges -- creating names automatically cell ranges -- selecting for data entries cell references -- showing cell references -- ranges concatenation cell references -- ranges intersection cell references -- ranges union cell styles -- copying cell styles -- selecting cell styles -- assigning by formulae cell widths cells -- AutoInput function of text cells -- Internet references cells -- auto-refreshing traces cells -- backgrounds cells -- changing text/number formats cells -- conditional formatting cells -- copying/deleting/formatting/moving cells -- currency formats cells -- defining input help cells -- defining names cells -- deleting cells cells -- deleting contents cells -- filling automatically cells -- heights and widths cells -- hiding for printing cells -- inserting cells -- invalid data cells -- moving by drag-and-drop cells -- number formats cells -- operating in another document cells -- print ranges cells -- printing grids cells -- protecting cells -- references cells -- referencing by drag-and-drop cells -- refreshing traces cells -- removing dependents cells -- removing precedents cells -- removing traces cells -- rotating text cells -- selecting cells -- text breaks cells -- text super/sub cells -- trace fill mode cells -- tracing dependents cells -- tracing errors cells -- tracing precedents cells -- validity cells -- borders cells -- comments cells -- date and time formats cells -- formatting dialogue box changing -- input in cells changing -- sheet names changing -- sheet protection changing -- currency formats changing -- dates, automatically changing -- number of decimal places changing -- row heights/column widths changing -- table views characters -- superscript/subscript chart -- pivot chart charts -- printing chi-square distribution clearing, see also deleting/removing coefficient of correlation colors -- values colours -- calculating in spreadsheets colours -- negative numbers colours -- numeric values column breaks -- inserting column breaks -- deleting column headers -- hiding column headers -- using in formulae column widths columns -- AutoFilter function columns -- deleting columns -- finding labels automatically columns -- freezing columns -- inserting columns -- repeating when printing columns -- swap with rows columns -- widths columns -- hiding columns -- moving by drag-and-drop columns, see also cells combining -- cell ranges comma separated files and values comments -- on cells comments -- printing comments -- help text for cells comparisons -- operators in Calc complex numbers in analysis functions conditional calculations with arrays conditional formatting -- cells conditional formatting -- conditions conditional formatting -- data bar options consolidating data constant interest rates constants definition convert -- formula to values converting -- binary numbers, into decimal numbers converting -- binary numbers, into hexadecimal numbers converting -- binary numbers, into octal numbers converting -- decimal fractions, into decimal numbers converting -- decimal fractions, into mixed decimal fractions converting -- decimal numbers, into binary numbers converting -- decimal numbers, into hexadecimal numbers converting -- decimal numbers, into octal numbers converting -- degrees, into radians converting -- hexadecimal numbers, into binary numbers converting -- hexadecimal numbers, into decimal numbers converting -- hexadecimal numbers, into octal numbers converting -- octal numbers, into binary numbers converting -- octal numbers, into decimal numbers converting -- octal numbers, into hexadecimal numbers converting -- radians, into degrees converting -- random variables, into normalised values converting -- text with leading zeros, into numbers converting -- text, into numbers copying -- array formulas copying -- cell styles copying -- formulae copying -- spreadsheets copying -- visible cells only copying -- values, to multiple sheets correcting sheets automatically correlation -- Analysis toolpack cosecant -- complex number cosine -- complex number cotangent -- complex number counting -- empty cells counting -- specified cells counting column -- satisfying criteria counting row -- satisfying criteria counting rows -- with numeric or alphanumeric values counting rows -- with numeric values covariance -- Analysis toolpack cross-classified tables cumulative probability density function -- calculating cumulative probability density function -- calculating cumulative probability density function -- inverse of cumulative probability density function -- inverse of currencies -- default currencies currencies -- formats currency formats -- spreadsheets current date and time values customised lists dBASE import/export data -- merging cell ranges data -- showing invalid data data -- validity check data -- inserting in multiple sheets data -- sorting in databases data bar formatting -- data bar options data bar options -- conditional formatting data entry forms -- for spreadsheets data entry forms -- insert data in spreadsheets data field options for pivot table data provider -- for spreadsheets data series import data sources -- external data data tables -- multiple operations in data validity database ranges -- AutoFilter function database ranges -- advanced filters database ranges -- defining database ranges -- hiding AutoFilter database ranges -- refreshing database ranges -- sorting database ranges -- applying/removing filters databases -- functions in Collabora Office Calc databases -- selecting (Calc)date and time functions date formats -- avoiding conversion to date formats -- conversion date series dates -- 19xx/20xx dates -- in cells dates -- interest date prior to settlement date dates -- updating automatically deactivating -- automatic changes decimal places -- adding/deleting decimal places -- showing decimal places -- cutting off decimal places -- formatting numbers decimal system -- converting to defaults -- number formats in spreadsheets defaults -- currency formats defining -- advanced filters defining -- AutoFormat styles defining -- database ranges defining -- names for cell ranges defining -- print ranges defining -- sort lists deleting -- array formulas deleting -- cell content deleting -- decimal places deleting -- spreadsheets deleting -- cells/rows/columns deleting -- manual column breaks deleting -- manual row breaks deleting -- pivot tables deleting -- print ranges deleting -- visible cells only delimited values and files density function density function depreciations -- arithmetic declining depreciations -- arithmetic-degressive depreciations -- degressive amortisations depreciations -- geometric-degressive depreciations -- linear amortisations depreciations -- linear depreciations -- variable declining descriptive statistics -- Analysis toolpack determinants determination coefficients discounts display options in pivot table displaying -- comments displaying -- formulae instead of results displaying -- headers of columns/rows displaying -- scenario names displaying -- sheets displaying -- formulae at any position divide window -- split division sign, see also operators divisions documents -- protecting documents -- references dot products drag-and-drop -- moving cells drag-and-drop -- referencing cells draw objects -- printing drop-down menus in sheet columns duplicate -- sheet durations -- calculating durations -- first interest payment until settlement date durations -- fixed interest securities editing -- array formulas editing -- pivot tables editing -- print ranges effective interest rates empty cells -- recognising empty cells -- counting empty cells -- handling of encrypting text entering entries with AutoInput function equations in goal seek error codes -- controlling error codes -- list of error messages -- defining for incorrect input error messages -- invalid references error tracing even integers events -- sheet only exact numbers in Collabora Office Calc examples -- formula calculation examples -- goal seek exponential distributions exponential distributions exponential smoothing -- Analysis toolpack exponential trends in arrays exporting -- tables as text exporting -- cells exporting -- formulae as CSV files exporting -- spreadsheets to dBASE extending print ranges external DLL functions external data -- inserting extrapolations extrapolations factorials -- numbers with increments of two factorials -- numbers file names in headers/footers fill range -- random numbers filling -- cells, automatically filling -- customised lists filling -- selection lists filtered data -- sums filtering -- cell ranges/database ranges filtering -- pivot tables filters -- applying/removing filters -- finding unique values filters -- removing duplicates filters -- copying visible cells only filters -- defining advanced filters filters, see also AutoFilter function financial functions find text -- FINDB Function finding -- formulae/values/text/objects footers -- defining footers -- printing on sheets forced array handling format -- page format codes -- user-defined number formats formats -- Styles window formats -- assigning by formulae formats -- automatically formatting spreadsheets formats -- changing text/number formats -- currency formats in cells formats -- numbers as text formats -- numbers in tables formats -- text as numbers formats -- themes for sheets formatting -- Styles window formatting -- conditional formatting formatting -- user-defined numbers formatting -- adding/deleting decimal places formatting -- cells formatting -- comments on cells formatting -- multiple cell texts formatting -- numbers as text formatting -- numbers with decimals formatting -- page formatting -- pivot tables formatting -- spreadsheets formatting -- themes for sheets formatting -- visible cells only formula bar -- accepting inputs formula bar -- cancelling inputs formula bar -- functions formula bar -- input line formula bar -- sheet area names formula bar -- spreadsheets formula bar -- sum function formula cells -- displaying formulae in other cells formula cells -- recognising formula cells -- removing precedents formula cells -- tracing precedents formula list window formula to values -- convert formula to values -- recalculate formulae -- calculating formulae -- copying and pasting formulae -- defining names formulae -- displaying in cells formulae -- importing/exporting as CSV files formulae -- inputting formulae -- matrix formulae formulae -- printing, instead of results formulae -- recalculating manually formulae -- using row/column labels formulae -- assigning cell formats formulae -- calculating with formulae -- hiding formulae -- status bar formulas -- arrays formulas -- operators formulas -- using double quotation marks formulas -- AutoCalculate function formulas -- force recalculation formulas -- recalculate hard fractions -- converting fractions -- entering freeze rows and columns freezing -- cells freezing -- first column freezing -- first row freezing rows or columns function list window functions -- Collabora Office Calc add-in DLL functions -- accepting input icon functions -- add-in functions functions -- array functions functions -- cancelling input icon functions -- database functions functions -- date & time functions -- financial functions functions -- formula bar icon functions -- information functions functions -- logical functions functions -- mathematical functions functions -- spreadsheets functions -- statistics functions functions -- text functions functions -- user-defined functions -- Function Wizard functions -- listed by category functions -- sum function icon future values -- constant interest rates future values -- varying interest rates geometric lists geometric-degressive depreciations goal seeking -- example goal seeking -- solver greatest common divisor grid lines -- sheets grids -- printing sheet grids grids -- hiding lines in sheets grouping -- pivot tables grouping -- cells growth series headers -- defining headers -- freezing during table split headers -- printing on sheets headings -- repeating rows/columns as heights of cells hexadecimal system -- converting to hidden -- sheet hidden cells hiding -- columns hiding -- rows hiding -- sheet details hiding -- data fields, from calculations in pivot table hiding -- formulae hiding -- headers/grid lines highlighting -- values in sheets highlighting -- negative numbers hyperbolic cosecant -- complex number hyperbolic cosine -- complex number hyperbolic secant -- complex number hyperbolic sine -- complex number hyphenation -- in spreadsheets image anchor -- in Calc image anchor in Calc -- changing imaginary numbers in analysis functions implicit array handling importing -- tables as text importing -- CSV files with formulae importing -- dBASE files increasing scales in page view index of the Error type information functions information on cells inline array constants inner products input line in formula bar input support in spreadsheets insert data -- data entry forms for spreadsheets insert date -- in cells insert time -- in cell inserting -- breaks inserting -- cell ranges inserting -- cells inserting -- cells, toolbar icon inserting -- columns inserting -- external data inserting -- manual column breaks inserting -- manual row breaks inserting -- objects, toolbar icon inserting -- rows inserting -- sheets inserting -- cells, by drag-and-drop inserting -- formulae inserting -- fractions inserting -- matrix formulae inserting -- references, by drag-and-drop inserting -- values inserting functions -- Function Wizard inserting functions -- function list window instructions -- Collabora Office Calc integers with leading zeros interests for unchanged amortisation instalments internal rates of return -- irregular payments internal rates of return -- modified internal rates of return -- regular payments international currency formats intersection reference operator intersections invalid data -- marking invalid names -- error messages invalid references -- error messages inverse F probability distribution inverse arrays inverse of Fisher transformation inverse of log-normal distribution inverse of lognormal distribution inverse of t-distribution inverse of two-tailed t-distribution inverting tables invisible cells jump -- to given sheet jump -- to previous sheet jump -- to the next sheet label ranges in sheets landscape printing layout -- spreadsheets leading zeros leap year determination least common multiples limits -- specifying value limits on input line arrangements with cells linear depreciations linear series list of functions lists -- user-defined logarithms logical functions logical number formats lognormal distribution lognormal distribution lowercase letters -- AutoInput function (in cells)lowest common multiples macros -- running when incorrect input manual column breaks manual row breaks marking cells mathematical functions mathematical optimization -- solver for Calc mathematical programming -- solver for Calc matrices -- calculations matrices -- entering matrix formulae matrices -- functions maximum -- satisfying conditions maximum values in Calc databases means -- geometric means -- harmonic means -- of data set without margin data merge/merging cells merging -- data ranges minimum -- satisfying conditions minimum values in Calc databases minus sign, see also operators modified internal rates of return most common value most common value most common value moving -- spreadsheets moving -- cells, rows and columns by drag-and-drop moving -- visible cells only moving average -- Analysis toolpack multi-line text in cells multiple cells selection multiple operations multiple sheets multiplication sign, see also operators multiplying -- cell contents in Calc databases multiplying -- numbers name recognition on/off names -- defining for cells names -- for cell ranges names -- sheets natural language addressing natural logarithm of Gamma function natural logarithm of Gamma function natural logarithm natural sort algorithm navigating -- in spreadsheets nearest multiple negative binomial distribution negative binomial distribution negative numbers net annual interest rates net present values nominal interest rates non volatile functions -- force recalculation normal distribution -- standard normal distribution -- inverse of standard normal distribution -- inverse of standard normal distribution -- inverse of normal distribution -- inverse of normal distribution -- statistics normal distribution -- statistics null values -- printing number completion on/off number formats -- adding/deleting decimal places in cells number formats -- millions number formats -- colours for negative numbers number formats -- logical number of combinations with repetitions number of combinations number of coupons number of days -- in a specific year number of days -- in a specific month of a year number of entries number of months between two dates number of payment periods number of permutations number of sheets -- function number of weeks -- between two dates number of weeks -- in a specific year number of years between two dates number series import numbers -- decimal places numbers -- entering fractions numbers -- filter sheets numbers -- formatting decimals numbers -- formatting options for selected cells numbers -- highlighting negative numbers numbers -- rounded off numbers -- with leading zeros numbers -- counting numbers -- determining ranks numbers -- determining ranks numbers -- determining ranks numbers -- entering as text numbers -- greater than or equal to numbers -- multiplying numbers -- rounding down to next integer numbers -- rounding down numbers -- rounding up/down to even integers numbers -- truncate numbers -- user-defined formatting odd integers one tailed inverse of t-distribution opening -- sheets in HTML opening -- scenarios opening -- text CSV files operations research -- solver for Calc operators -- formula functions operators -- in spreadsheet formulas operators -- comparison operators -- precedence of outlines -- sheets output ranges of pivot tables page -- style page breaks -- inserting in spreadsheets page breaks -- spreadsheet preview page styles -- footers page styles -- headers page views -- increasing scales page views -- reducing scales pages -- order when printing paint can for applying styles paired t-test -- Analysis toolpack pasting -- cell ranges pasting -- formulae pasting -- values in multiple sheets payment periods -- number of periodic amortisement rates permitted cell content phonebook sorting rules pivot chart -- creating pivot chart -- deleting pivot chart -- editing pivot chart -- update pivot table -- pivot chart pivot table function -- calling up and applying pivot table function -- deleting tables pivot table function -- editing tables pivot table function -- filtering tables pivot table function -- introduction pivot table function -- preventing data overwriting pivot table function -- refreshing tables pivot table function -- drill down pivot table function -- grouping table entries pivot table function -- show details pivot table import pivot tables plus sign, see also operators points of intersection powers of 2 calculations precision -- calculation precision as shown present values previews -- page breaks for printing prices -- fixed interest securities prices -- interest-bearing securities prices -- non-interest-bearing securities prices -- securities with irregular first interest date prices -- treasury bills print ranges printing -- cells printing -- landscape printing -- page order printing -- rows/columns as table headings printing -- sheet counts printing -- sheet selections printing -- sheets on multiple pages printing -- sheet details probabilities of samples with binomial distribution programming -- add-ins programming -- functions protecting -- unprotecting cells protecting -- cells and sheets random numbers -- between limits random numbers -- between 0 and 1 random numbers -- distribution random numbers -- examples random numbers -- fill range random numbers non-volatile -- between limits random numbers non-volatile -- between 0 and 1 range of cells -- defining range operator ranges -- combining ranges -- defining database ranges ranges -- inserting in tables ranges -- print ranges rates of return -- non-interest-bearing securities rates of return -- securities with interest paid on maturity rates of return -- securities rates of return of treasury bills rawsubtract -- subtraction recalculate -- all formulae in sheets recalculate -- auto calculating sheets recalculate -- formula to values recalculating -- all formulae in sheets recalculating -- auto calculating sheets recalculating -- pivot tables recognising -- column and row labels recognising -- equal numbers recognising -- general errors recognising formula cells records -- counting in Calc databases reference operators references -- URL in cells references -- absolute/relative references -- by defined names references -- to cells in other sheets/documents references -- to cells references -- inserting by drag-and-drop references -- testing cell contents regression analysis -- Analysis toolpack regression analysis -- linear regression analysis -- logarithmic regression analysis -- power regression analysis regression lines -- LINEST function regression lines -- FORECAST function regression lines -- FORECAST function regular expressions -- REGEX function regular expressions -- extracting in spreadsheets relative addresses relative references remainders of divisions remarks on cells removing -- cell range filters removing -- filters renaming -- cells renaming -- sheets repayment instalment repeating -- columns/rows on printed pages replace formula with values replace text -- REPLACEB Function replacing -- cell content results display vs. formulae display right-tailed t-distribution right-to-left text -- spreadsheets rotating -- tables rotating -- text in cells rounded off numbers rounding -- down to nearest multiple of significance rounding -- down to nearest multiple of significance rounding -- down to next integer rounding -- up to multiples of significance rounding -- up to multiples of significance rounding -- up to multiples of significance rounding -- up/down to even integers rounding -- up/down to nearest odd integer rounding precision row breaks -- deleting row breaks -- inserting row headers -- hiding row headers -- using in formulae rows -- deleting rows -- finding labels automatically rows -- freezing rows -- heights rows -- inserting rows -- repeating when printing rows -- swapping with columns rows -- hiding rows -- moving by drag-and-drop rows -- removing/redisplaying with filters rows -- visible and invisible rows, see also cells sales values -- fixed interest securities sales values -- non-interest-bearing securities sampling -- Analysis toolpack sampling without replacement sampling without replacement saving -- sheets in HTML saving -- as text csv scalar products scenarios -- creating/editing/deleting scenarios -- displaying names scrolling prevention in tables search text -- SEARCHB Function searching -- links in cells searching -- cell contents in Calc databases searching -- maximum values in columns searching -- minimum values in columns searching, see also finding secant -- complex number securities -- first interest payment until settlement date select -- all cells in sheet select -- block of data select -- data area select -- to the next sheet select -- to the previous sheet select -- unprotected cells select -- visible columns selecting -- cells selecting -- formatting themes selecting -- multiple sheets selecting -- scenarios in Navigator selection lists -- filling cells selection lists -- validity selection modes in spreadsheets series -- calculating series -- sort lists share spreadsheet shared libraries -- programming sheet -- go to directly sheet -- search and go to sheet -- duplicate sheet -- events sheet -- grid lines sheet -- hiding sheet area names sheet grids -- printing sheet navigation bar sheet numbers -- looking up sheet ranges -- filling sheet references sheet tab submenu sheet tabs -- renaming sheet tabs -- using sheets -- HTML sheets -- defining label ranges sheets -- deleting sheets -- displaying sheets -- filter values sheets -- hiding details sheets -- inserting row breaks sheets -- inserting sheets -- jump to sheets -- outlines sheets -- printing details sheets -- printing in landscape sheets -- printing on multiple pages sheets -- printing sheet counts sheets -- protecting sheets -- renaming sheets -- selecting multiple sheets -- showing multiple sheets -- simultaneous multiple filling sheets -- AutoFormat sheets -- creating sheets -- formatting themes sheets -- right-to-left shortcut keys -- spreadsheets shortcut keys -- Collabora Office Calc accessibility show -- hidden sheets showing -- cell references showing -- columns showing -- rows showing -- sheet details sine -- complex number skewness -- population slopes, see also regression lines solver for Calc -- CoinMP linear solver solver for Calc -- DEPS evolutionary algorithm solver for Calc -- SCO evolutionary algorithm solver for Calc -- linear solver solver for Calc -- swarm non-linear solver solver for Calc -- options solver sort lists -- applying sorting -- database ranges sorting -- options for database ranges sorting -- sort criteria for database ranges sorting -- Asian languages sorting -- options in pivot table sparklines split -- divide window split/splitting cells spreadsheet -- collaboration spreadsheet -- form for inserting data spreadsheet -- share spreadsheets -- backgrounds spreadsheets -- calculating spreadsheets -- copying spreadsheets -- deleting cell content spreadsheets -- deleting cells spreadsheets -- deleting row breaks spreadsheets -- deleting spreadsheets -- displaying headers of columns/rows spreadsheets -- duplicate spreadsheets -- formula bar spreadsheets -- functions spreadsheets -- hiding functions spreadsheets -- importing from/exporting to dBASE files spreadsheets -- inserting breaks in spreadsheets -- inserting cells spreadsheets -- inserting column breaks spreadsheets -- inserting columns spreadsheets -- inserting rows spreadsheets -- moving spreadsheets -- quick rename spreadsheets -- shortcut keys in spreadsheets -- showing columns spreadsheets -- showing rows spreadsheets -- value highlighting spreadsheets -- values as shown spreadsheets -- deleting column breaks spreadsheets -- formatting square number additions square roots -- positive numbers square roots -- products of Pi standard deviations in databases -- based on a sample standard deviations in databases -- based on populations standard deviations in statistics -- based on a population standard deviations in statistics -- based on a population standard deviations in statistics -- based on a sample standard deviations in statistics -- based on a sample standard errors -- array functions standard errors -- statistical functions statistics functions straight-line depreciations style -- page styles -- in Calc styles -- conditional styles styles in spreadsheets subscript text in cells subtotals -- sorting options subtotals -- using subtotals tool sum -- satisfying conditions sum icon sums -- cells in Calc databases sums -- of filtered data sums -- of square numbers sums -- of squares of deviations superscript text in cells swapping tables syllables in spreadsheets t-distribution t-distribution t-test -- Analysis toolpack tables -- AutoFormat tables -- backgrounds tables -- combining tables -- copying cell styles tables -- database ranges tables -- deactivating automatic changes in tables -- displaying formulae/values tables -- freezing tables -- importing/exporting as text tables -- inserting external data tables -- multiple operations in tables -- number formats tables -- rotating tables -- selecting ranges tables -- showing details tables -- splitting windows tables -- transposing tables -- views tables -- renaming tables in databases -- importing dBASE files tangent -- complex number testing -- general errors text completion on/off text concatenation text documents -- importing to spreadsheets text file import and export text formats -- for numbers text functions -- convert roman numbers text functions -- convert text to numeric value text functions -- convert to roman numbers text functions -- katakana characters text in cells -- as addressing text in cells -- changing to numbers text in cells -- formatting text in cells -- functions text in cells -- multi-line text in cells -- writing vertically text in cells -- AutoInput function text operators text to columns theme selection for sheets time differences time format conversion times -- in cells title rows -- freezing during table split title rows -- printing on all sheets toggle merge and centre cells total amortisation rates traces -- auto-refreshing traces -- precedents for multiple cells traces -- refreshing traces -- precedents and dependents tracing errors transposing tables treasury bills -- annual return treasury bills -- prices treasury bills -- rates of return trigonometric functions two tailed t-distribution ungrouping entries in pivot tables union reference operator unmerge/unmerging cells unprotecting cells updating -- pivot tables updating -- traces user-defined functions using double quotation marks in formulas validity values -- defining names values -- displaying in tables values -- inserting in multiple cells values -- limiting on input values -- absolute values -- highlighting values -- rounded in calculations variables -- defining names variables -- calculating equations variances -- based on populations variances -- based on samples variances variances vertical search function viewing -- comments on cells viewing -- print ranges views -- tables views -- multiple sheets web pages -- importing data what if operations -- solver what if operations -- two variables widths of cells wildcards -- examples wildcards in formulas windows -- splitting wizards -- functions word completion on/off worksheet names years -- 2-digits yields, see also rates of return zero values -- entering leading zeros zero values -- printing zooming -- enlarging page views zooming -- reducing page views3-D text creation3D Effects API -- XConfirmDeleteListener API -- XDatabaseParameterListener API -- XLoadListener API -- XResetListener API -- XRowSetApproveListener API -- XRowSetListener API -- XSQLErrorListener API -- XSubmissionVetoListener API -- XSubmitListener API -- XUpdateListener ASCII -- definition ActiveX control Agenda Wizard Arabic -- entering text Arabic -- languages and locales Asian Phonetic Guide Asian languages -- enabling Asian typography AutoAbstract function for sending text to presentations AutoCaption function in Collabora Office Writer AutoComplete function in text and list boxes AutoComplete, see also AutoCorrect/AutoInput AutoCorrect function -- URL recognition AutoCorrect function -- context menu AutoCorrect function -- options AutoCorrect function -- pictures and frames AutoCorrect function -- quotes AutoCorrect function -- replacement table AutoCorrect function -- switching on and off AutoFormat function for tables AutoPilots, see wizards AutoValue (Base)Basic -- fonts for source display Basic -- recording macros Basic IDE -- Autoclose parenthesis Basic IDE -- Autoclose quotes Basic IDE -- Autocompletion Basic IDE -- Autocorrection Basic IDE -- Basic UNO extended types Basic IDE -- options Basic dialogues -- organise in libraries Basic macros -- organise in libraries Basic modules -- organise in libraries Built-in help -- installation Bézier curves -- control points in presentations CSV -- command line filter options CSV -- export options CSV -- filter options CSV -- import options CSV -- separator specification line CTL -- options CTL -- (not) wrapping words CTL -- complex text layout languages CTL -- definition Calc A1 -- cell reference syntax in strings Chinese writing systems Client Side ImageMap Collabora Office Basic scripts in HTML documents Collabora Office Help Collabora Office Math start Collabora Office colours Collabora Office documents -- viewing and editing in Internet Explorer Crash Report Tool DDE -- definition DDE links -- modifying Data Navigator -- adding/editing items Data Navigator -- display options Diff -- command line filter options Document Converter Wizard Document Map, see Navigator Drawing bar EPUB -- export Edit Mode icon Edit Points bar Euro -- currency formats Excel -- saving as Excel -- search criteria Excel A1 -- cell reference syntax in strings Excel R1C1 -- cell reference syntax in strings Export as -- EPUB Export as -- PDF FTP -- saving documents FTP -- remote file service setup Find & Replace -- attributes Find & Replace dialogue box Find tab in Help Find toolbar Fontwork icons Form Navigator Format Paintbrush Gallery -- adding pictures Gallery -- hiding/showing Gallery -- inserting pictures from Gallery -- dragging pictures to draw objects Google Drive -- remote file service setup Google Drive -- remote file service HTML -- definition HTML -- export character set HTML -- importing META tags HTML -- compatibility settings HTML -- fonts for source display HTML documents -- META tags in HTML documents -- importing/exporting HTML documents -- new HTML documents -- source text Hangul/Hanja Hebrew -- entering text Hebrew -- languages and locales Help -- Help tips Help -- bookmarks Help -- extended tips on/off Help -- full-text search Help -- keywords Help -- navigation pane showing/hiding Help -- topics Help pages -- Index Help pages -- contents Help pages -- search in index Help tips -- hiding Hindi -- entering text Hindi -- languages and locales IME -- definition ImageMap -- definition ImageMap -- editor ImageMap -- hotspot properties Index tab in Help Internet -- Internet Explorer for displaying Collabora Office documents Internet -- checking for updates Internet glossary JDBC -- definition Java -- definition Java -- setting options LCID, extended LanguageTool -- settings Letter Wizard Lotus -- command line filter options META tags Material Design colours Math baseline alignment (Writer)Math formula editor Media Player window Microsoft Office -- as default file format Microsoft Office -- importing/exporting VBA code Microsoft Office -- document import restrictions Microsoft Office -- feature comparisons Microsoft Office -- importing Word documents Microsoft Office -- importing password-protected files Microsoft Office -- new users information Microsoft Office -- opening Microsoft documents Microsoft Office -- reassigning document types Microsoft lock files My Documents folder -- opening My Documents folder -- changing working directory Navigation bar -- forms Navigator -- contents as lists Navigator -- docking Navigator -- comments Navigator -- working with ODBC -- definition ODF file formats OLE -- definition OLE objects -- arranging within stacks OLE objects -- inserting OLE objects -- Microsoft Office OLE objects -- PDF OLE objects -- import and export OLE objects -- number of OLE objects -- protecting Office -- Microsoft Office and Collabora Office OpenCL -- setting options OpenDocument file formats OpenGL -- definition OpenPGP -- document encryption OpenType -- font features PDF -- command line parameters PDF -- export PDF export -- Universal Accessibility PDF export -- digital signature PDF export -- general options PDF export -- initial document view PDF export -- links PDF export -- security PDF export -- sign PDF document PDF export -- time stamp PDF export -- user interface PDF forms Paintbrush PostScript -- creating files PowerPoint -- saving as QR code -- barcode Query Wizard (Base)SGML -- definition SQL -- DISTINCT parameter SQL -- LIMIT clause SQL -- executing SQL commands SQL -- definition SSH -- remote file service setup Server Side ImageMap Skia -- graphics output Skia -- settings Styles window -- docking TSA TextArt, see Fontwork Thai -- entering text Thai -- languages and locales Track Changes, see review function UNO components -- Extension Manager UNO components -- integrating new URL -- definition URL -- saving absolute/relative paths URL -- changing hyperlink URLs URL -- in pictures URL -- turning off URL recognition UTF-8/UCS2 support Unicode -- input with keyboard Unicode -- shortcut keys VBA code -- loading/saving documents with VBA code Visual Basic for Applications -- loading/saving documents with VBA code WYSIWYG in fonts lists Web support WebDAV -- remote file service setup WebDAV over HTTPS Windows share -- remote file service setup Windows share -- remote file service Word documents -- saving as Word documents -- compatibility WordArt, see Fontwork XForms -- adding/editing/deleting/organising namespaces XForms -- conditions XForms -- opening/editing XML Forms, see XForms XML converters XML file formats XML filters -- creating/testing XML filters -- settings XML filters -- saving as package/installing/deleting XSLT filters, see also XML filters abbreviation replacement absolute hyperlinks absolute saving of URLs accents accessibility -- Collabora Office assistive technology accessibility -- Collabora Office features accessibility -- options accessibility -- general shortcuts activating -- Crash Report Tool activating -- context menus activating -- extended help tips add-ons, see UNO components adding selection mode address books -- registering address labels from databases ageing filter aligning -- cells aligning -- objects aligning -- paragraphs aligning -- text aligning -- tables in text alternative fonts ampersand symbol, see also operators anchoring -- as character anchoring -- to cell anchoring -- to character anchoring -- to frame anchoring -- to page anchoring -- to paragraph anchors -- changing anchors -- displaying (Calc)anchors -- types/positions for draw objects animations -- accessibility options appearance options applying document themes areas -- hatched/dotted areas -- image areas -- shadows areas -- slanting areas -- styles areas -- transparency arguments in command line arranging -- objects arrows -- defining arrow heads arrows -- defining arrow lines arrows -- drawing in text as character -- anchoring assigning scripts assistive technology in Collabora Office attaching toolbars attachments in emails attributes -- finding audio automatic captions (Writer)automatic hyperlink formatting automatic line breaks automatic lines/borders in text automatic redaction automatic saving axes in charts background -- area background -- pattern backgrounds -- defining colours/pictures backgrounds -- frames/sections/indexes backgrounds -- printing backgrounds -- inserting from Gallery backing window backups -- documents backups -- automatic basic fonts beanshell scripts -- run bi-directional writing binding space bitmaps -- inserting and editing bitmaps -- off for faster printing black and white printing black printing in Calc block selection mode bold -- AutoFormat function bold -- text bold -- using * when typing bookmark -- definition bookmarks -- Help borders -- arranging borders -- cells on screen (Calc)borders -- for paragraphs borders -- for tables borders -- shadows borders -- table boundaries (Writer)borders, see also frames bound fields -- controls boundaries of tables (Writer)break display (Writer)brochures -- printing several build numbers of Collabora Office bullet lists -- formatting options bullets -- replacing bullets -- turning off bullets -- paragraphs business cards -- creating and synchronising business cards -- using templates button bars, see toolbars buttons -- big/small buttons -- form functions buttons -- adding push buttons buttons -- editing hyperlink buttons buttons -- toolbars calculating -- iterative references (Calc)callouts -- drawings capital letters -- AutoCorrect function capital letters -- font effects captions -- automatic captions (Writer)captions, see also labels/callouts case-sensitivity -- comparing cell content (Calc)case-sensitivity -- searching categories -- in templates cell reference syntax in strings -- Calc A1 cell reference syntax in strings -- Excel A1 cell reference syntax in strings -- Excel R1C1 cell widths -- using mouse cell widths -- using ruler cells -- aligning cells -- coloring (Calc)cells -- cursor positions after input (Calc)cells -- formatting without effect (Calc)cells -- line breaks cells -- pasting cells -- showing grid lines (Calc)cells -- formula hint cells -- formula indicator in cell cells -- linked to controls cells -- number of cells -- resetting formats centimetres centred text certificate path certificates changes -- accepting or rejecting changes -- navigating changes -- protecting changes -- recording changes -- review function changes -- showing changes -- comparing with original changing -- DDE links changing -- document titles changing -- file associations in Setup program changing -- icon sizes changing -- page margins changing -- page size changing -- working directory changing, see also editing and replacing chapter -- definition character highlighting -- Microsoft Office export character shading -- Microsoft Office export character styles -- language selection characters -- Asian layout characters -- alternative fonts characters -- bold characters -- colouring characters -- displaying only on screen (Writer)characters -- enabling CTL and Asian characters characters -- font effects characters -- hiding characters -- hyperlinks characters -- italics characters -- language selection characters -- shadowed characters -- spacing characters -- special characters -- fonts and formats characters -- underlining charcoal sketches filter charts -- arranging within stacks charts -- bars with textures charts -- colours charts -- displaying (Calc)charts -- editing axes charts -- editing data charts -- editing legends charts -- editing titles charts -- inserting charts -- copying with link to source cell range check -- graphic size check box creation choosing printers circle drawings classification -- BAF category classification -- BAILS levels classification -- categories classification -- classification bar classification -- contents classification -- displayed in user interface classification -- document classification -- headers and footers classification -- licenses classification -- markings classification -- paragraph classification -- part numbers classification -- security levels classification -- watermark classification levels -- Confidential classification levels -- General Business classification levels -- Internal use only classification levels -- Non-Business classification levels -- customizing classification toolbar -- display clipboard -- Unix clipboard -- cutting clipboard -- pasting clipboard -- selection clipboard clipboard -- pasting formatted/unformatted text clone formatting closing -- documents closing -- toolbars collaboration colors -- grid lines and cells (Calc)colors -- ignored text color colors -- in document themes colors -- restriction (Calc)colour bar colour selector colours -- Collabora Office colours colours -- HLC colours colours -- appearance colours -- applications colours -- backgrounds colours -- default colours colours -- fonts colours -- freieFarbe colours -- not printing colours -- printing in greyscale colours -- web colours -- adding colours -- charts colours -- delete colours -- loading lists colours -- palette column -- inserting after column -- inserting before column headers -- displaying (Calc)column headers -- highlighting (Calc)column width -- distribute evenly columns -- optimal widths columns -- setting with the mouse combo box creation command button creation command buttons, see push buttons command line document conversion -- filters for BASE command line document conversion -- filters for CALC command line document conversion -- filters for DRAW command line document conversion -- filters for GRAPHICFILTER command line document conversion -- filters for IMPRESS command line document conversion -- filters for MATH command line document conversion -- filters for PDFIMPORT command line document conversion -- filters for WRITER command line document conversion -- filters for XSLTFILTER command line document conversion -- filters command line parameters commands -- repeating commands -- SQL comments -- on changes comments -- printing in text comments -- hide resolved comments -- inserting/editing/deleting/printing/resolving comments -- resolve in text documents comments -- show common terms -- Chinese dictionary common terms -- Internet glossary common terms -- glossaries comparison -- automatic comparison -- by character comparison -- by word comparisons -- document versions comparisons -- operators in default filter dialogue box compatibility settings -- key bindings (Calc)compatibility settings for MS Word import complete screen view complex text layout -- enabling complex text layout -- definition complex text layout, see CTL compose key to insert special characters concatenation, see ampersand symbol conditional separators conditions -- in number formats conditions -- items in Data Navigator configuring -- Collabora Office configuring -- toolbars configuring -- fax icon connections to data sources (Base)contents protection context menus -- customising context menus control point display in presentations controls -- activating in forms controls -- arranging within stacks controls -- bound fields/list contents/linked cells controls -- events controls -- formatted fields controls -- grouping controls -- hidden controls -- inserting controls -- multi-line titles controls -- positions and sizes controls -- printing controls -- properties of form controls controls -- properties of table controls controls -- reference by SQL controls -- rich text control controls -- select mode controls -- showing (Writer)controls -- adding to documents controls -- arranging in forms controls -- assigning data sources controls -- assigning macros (Basic)convert to PDF -- command line parameters convert-to -- filters converters -- Euro Converter converters -- XML converters -- document converter converting -- Collabora Office documents converting -- Hangul/Hanja converting -- Microsoft documents converting -- metrics copies -- printing copying -- datasource records in spreadsheets copying -- draw objects between documents copying -- draw objects copying -- in Unix copying -- sheet areas, to text documents copying -- by drag-and-drop copying -- data from text documents copying -- formatting copying -- from Gallery copying -- from data source view copying -- pictures, between documents copying -- to Gallery copyright for Collabora Office corner roundings crash reports cropping pictures cube drawing currencies -- converters currencies -- format codes currency formats cursor -- allowing in protected areas (Writer)cursor -- in read-only text cursor -- quickly moving to an object cursor position -- on opening text documents curves -- editing points custom -- classification levels custom dictionaries -- editing custom hyphens (Writer)custom quotes custom templates customising -- Collabora Office customising -- events customising -- toolbars customising -- context menus customising -- keyboard customising -- menus customising -- round corners cutting dBase -- command line filter options dashes data -- forms and sub-forms data -- read-only data -- sorting in forms data -- user data data -- filtering in forms data binding change in XForms data source browser data source explorer data source view -- drag-and-drop data source view -- overview data source view -- showing data sources -- as tables data sources -- connection settings (Base)data sources -- displaying current data sources -- registering address books data sources -- copying records to spreadsheets data sources -- reports data sources -- viewing data structure of XForms data, see also values database contents -- inserting as fields database contents -- inserting as tables database contents -- inserting as text database field -- add to form database field -- add to report database reports databases -- editing tables databases -- overview databases -- searching records databases -- shortcut keys databases -- sorting databases -- standard filters databases -- text formats databases -- creating labels databases -- creating queries databases -- creating reports databases -- creating tables databases -- creating databases -- deleting (Base)databases -- form filters databases -- importing/exporting databases -- registering (Base)databases -- viewing date acceptance patterns date fields -- properties date formats dates -- default (Calc)dates -- printing in presentations dates -- start 1900-01-01 (Calc)dates -- start 1904-01-01 (Calc)decimal places displayed (Calc)decimal separator key decimal tab stops decrease indent of paragraph default filters -- see standard filters default printer -- UNIX default printer -- setting up default templates -- changing default templates -- creating defaults -- grids (Writer/Calc)defaults -- number formats defaults -- program configuration defaults -- views defaults -- document formats in file dialogue boxes defaults -- documents defaults -- file formats in Collabora Office defaults -- fonts defaults -- languages defaults -- number of worksheets in new documents defaults -- of saving defaults -- prefix name for new worksheet defaults -- tab stops in text defining -- arrowheads and other line ends defining -- line styles defining -- paragraph borders defining -- queries (Base)defining -- table borders delete columns -- protected sheet delete rows -- protected sheet deleting -- hyperlinks deleting -- lines in text deleting -- XML filters deleting -- all direct formatting deleting -- comments deleting -- databases (Base)deleting -- models/instances deleting -- namespaces in XForms deleting -- tab stops depth stagger descriptions for objects design mode after saving design view -- creating forms designing -- database tables designing -- fonts detaching toolbars development tools dictionaries -- editing user-defined dictionaries -- spellcheck dictionaries -- spelling dictionaries -- common terms in simplified and traditional Chinese dictionaries -- creating dictionaries, see also languages digital signature -- add signature line digital signature -- sign signature line digital signature -- signing existing PDF digital signature -- time stamp digital signatures -- WebDAV over HTTPS digital signatures -- certificate path digital signatures -- getting/managing/applying digital signatures -- overview direct formatting -- clear direct formatting -- undoing all directories -- creating new directories -- directory structure disabled persons displaying -- comments in text documents displaying -- formatting marks (Writer)displaying -- non-printing characters (Writer)displaying -- pictures and objects (Writer)displaying -- tables (Writer)displaying -- zero values (Calc)distances distinct values in SQL queries distorting in drawings distribute objects -- horizontally evenly distribute objects -- vertically evenly distribute objects horizontally distribute objects in drawings distribute objects vertically distributing XML filters docking -- definition docking -- windows docking -- toolbars document -- classification document -- properties document classification -- pasting contents document colours -- palette document comparison -- options document comparison -- random ID document conversion -- filters document themes -- choosing document themes -- colors document themes -- using document types in Collabora Office documents -- apply user data to documents -- changing titles documents -- closing documents -- comparing documents -- contents as lists documents -- editing time documents -- embedding fonts documents -- exporting documents -- importing documents -- languages documents -- last printed documents -- location documents -- merging documents -- number of modifications documents -- opening in design mode documents -- opening with templates documents -- opening documents -- preferred image resolution documents -- preview image documents -- printing documents -- read-only documents -- reloading documents -- reset properties documents -- saving automatically documents -- saving in other formats documents -- saving documents -- sending as email documents -- size documents -- styles changed documents -- template applied documents -- version management documents -- version numbers documents -- measurement units in documents -- number of pages/tables/sheets dotted areas double line spacing in paragraphs double-line writing in Asian layout drag-and-drop -- copying and pasting text drag-and-drop -- data source view drag-and-drop -- pictures drag-and-drop -- from Gallery to draw objects drag-and-drop -- overview drag-and-drop -- to Gallery draw objects -- adding/editing/copying draw objects -- anchoring draw objects -- arranging within stacks draw objects -- control points draw objects -- copying between documents draw objects -- displaying (Calc)draw objects -- flipping draw objects -- legends draw objects -- slanting draw objects -- text in draw objects -- dropping Gallery pictures draw objects -- positioning and resizing draw objects -- protecting drawing -- object styles drawing lines in text drawing objects -- distribute evenly drawing objects -- distribute drawings -- creating/opening drawings -- languages drawings -- printing defaults drawings -- printing in text documents drawings -- printing drawings -- saving automatically drawings -- saving in other formats drawings -- saving drawings -- sending as email drawings -- showing (Writer)drawings, see also draw objects drop-down lists in form functions edit image -- external tool edit mode -- after opening edit mode -- through Enter key (Calc)editing -- chart axes editing -- chart data editing -- chart legends editing -- chart titles editing -- comments editing -- database tables and queries editing -- hyperlinks editing -- objects editing -- pictures editing -- tab stops editing -- toolbars editing -- Collabora Office documents in Internet Explorer editing -- Fontwork objects editing -- XForms editing -- context menus editing -- data binding of XForms editing -- draw objects editing -- grouped objects editing -- menus editing -- reports editing -- shortcut keys editing -- templates editing -- undoing editing time of documents editors -- ImageMap editor editors -- formula editor effects -- Fontwork icons effects -- fonts effects -- font positions electronic publication ellipse drawing email attachments embedded objects -- import and export embedding -- fonts embedding fonts in document file embedding licensed fonts empty documents empty paragraph removal encryption of contents engineering notation, formats entering groups entering text from right to left equal sign, see also operators equations in formula editor euro -- Euro Converter Wizard even/odd pages -- printing events -- controls events -- customising events -- assigning scripts events -- in database forms exceptions -- user-defined dictionaries exchanging, see also replacing executing SQL commands exiting -- Collabora Office exiting -- grouped objects exiting -- groups expanding formatting (Calc)experimental features expert configuration -- setting options expert configuration -- setting options explorer of data sources export filters exporting -- Microsoft Office documents with VBA code exporting -- XML files exporting -- bitmaps exporting -- spreadsheets to text format exporting -- to HTML exporting -- to Microsoft Office formats exporting -- HTML and text documents exporting -- to EPUB exporting -- to PDF exporting -- to PostScript format exporting -- to XML exporting -- to foreign formats extended tips in Help extending selection mode extensions -- file formats extensions -- Extension Manager external tool -- edit image faster printing faxes -- fax programs/fax printers under UNIX faxes -- sending faxes -- configuring Collabora Office faxes -- selecting a fax machine faxes -- wizards fields -- formatted fields fields -- database tables file -- properties file associations for Microsoft Office file encryption -- OpenPGP file encryption -- symmetric keys file extensions -- in templates file filters -- XML file formats -- changing Collabora Office defaults file formats -- saving always in other formats file formats -- OpenDocument/XML file locking with collaboration file sharing options for current document files -- filters and formats files -- opening files -- saving automatically files -- saving in other formats files -- saving files -- sending as email files -- version numbers files -- importing files -- properties files and folders in Collabora Office files, see also documents fill characters with tabulators fill colours for areas fill patterns for areas filter conditions -- connecting filtering -- data in forms filtering -- data in databases filters -- Navigator filters -- XML filter settings filters -- comparison operators filters -- for import and export filters -- document conversion filters -- pictures finding -- attributes finding -- in all sheets finding -- selections finding -- similarity search finding -- formatted display finding -- formatted numbers finding -- records in form documents fitting to pages -- print settings in presentations fitting to pages -- print settings in Math fixed text -- form functions fixing toolbars flip -- horizontally flip -- vertically flipping draw objects floating frames in HTML documents floating toolbars folder creation font attributes -- finding font effects -- hiding characters font embedding -- in documents font features -- OpenType font features font lists font name box font sizes -- relative changes font sizes -- text font sizes -- bullets fonts -- color ignored fonts -- effects fonts -- embedding fonts -- formats fonts -- hiding characters fonts -- licensing for embedding fonts -- outlines fonts -- positions in text fonts -- shadows fonts -- specifying several fonts -- strikethrough fonts -- styles fonts -- text objects fonts -- changing in templates fonts -- colours fonts -- default settings fonts -- finding fonts -- for HTML and Basic footers -- backgrounds form controls -- protecting form controls -- assigning macros form controls -- toolbars form fields form filters format -- clear direct formatting format codes -- numbers format filling printing in Collabora Office Math formats -- Asian layout formats -- fonts formats -- maximising page formats formats -- number and currency formats formats -- on opening and saving formats -- positions formats -- tabulators formats -- of currencies/date/time formats -- pasting in special formats formatted fields -- properties formatting -- Asian typography formatting -- axes in charts formatting -- chart legends formatting -- definition formatting -- expanding (Calc)formatting -- font effects formatting -- hyperlinks formatting -- undoing when writing formatting -- copying formatting -- pages formatting -- undoing formatting marks (Writer)formatting marks -- insert formatting marks -- narrow no-break space formatting marks -- no-break space formatting marks -- non-breaking hyphen formatting marks -- soft hyphen formatting marks -- word joiner formatting marks -- zero-width space forms -- Combo Box/List Box Wizard forms -- HTML filters forms -- browsing forms -- data forms -- events forms -- filtering data forms -- grouping controls forms -- opening in design mode forms -- properties forms -- sub-forms forms -- Navigator forms -- XForms forms -- add database field forms -- creating forms -- database events forms -- finding records forms -- sorting data forms -- wizards formula options -- formula syntax formula options -- large spreadsheet files formula options -- loading spreadsheet files formula options -- recalculating spreadsheets formula options -- reference syntax in string parameters formula options -- separators formula texts -- printing in Collabora Office Math formulae -- starting formula editor formulas -- new forums and support fraction, formats frames -- AutoCorrect function frames -- around paragraphs frames -- around tables frames -- backgrounds frames -- printing in Collabora Office Math frames -- selection frames frames -- text fitting to frames frames -- protecting free-form lines -- draw functions full screen view full-text search in Help full-width -- definition fullwidth -- definition get method for form transmissions getting support glossaries -- Internet terms glossaries -- common terms gradients -- loading lists gradients off for faster printing grammar -- LanguageTool graphic objects, see draw objects graphic size -- check graphical text art graphics -- protecting graphics, see also pictures greyscale printing grids -- defaults (Writer/Calc)grids -- displaying lines (Calc)group -- objects group menu groups -- of controls groups -- entering groups -- entering/exiting/ungrouping groups -- exiting groups -- naming guides -- displaying when moving objects (Impress)guides -- showing (Calc)guides -- display options (Impress/Draw)gutter half-width -- definition halfwidth -- definition handles -- scaling hatching -- loading lists hatching head-up display (hud)headers -- backgrounds heading -- definition headings -- entering as text box hidden controls in Form Navigator hidden fields display (Writer)hidden pages -- printing in presentations hidden text -- showing (Writer)hiding -- characters hiding -- changes hiding -- docked windows hiding -- navigation pane in Help window high-contrast mode highlighting changes horizontal scrollbars (Writer)hotspots -- properties hotspots -- adding to images hybrid PDF hyperlinks -- character formats hyperlinks -- definition hyperlinks -- deleting hyperlinks -- editing hyperlinks -- inserting hyperlinks -- relative and absolute hyperlinks -- assigning macros hyperlinks -- to files hyperlinks -- to folders hyperlinks -- turning off automatic recognition hyperlinks, see also links hyphenation -- activating for a language hyphenation -- minimal number of characters hyphens -- displaying custom (Writer)hyphens -- inserting custom icon bars, see toolbars icon sizes icons -- sizes icons -- styles ignore list for spellcheck ignore list for spelling ignored font colors illustrations, see pictures image -- change resolution image -- compression image -- reduce image size image -- replace image -- resize image -- size reduction images -- ImageMap images -- areas images -- inserting and editing bitmaps images, see also pictures import filters import restrictions for Microsoft Office importing -- HTML and text documents importing -- HTML with META tags importing -- Microsoft Office documents with VBA code importing -- bitmaps importing -- documents in other formats importing -- tables in text format importing -- compatibility settings for text import importing -- databases importing -- from XML inches increase indent of paragraph indexes -- backgrounds indexes -- showing/hiding Help index tab indicator lines in text insert -- column after insert -- column before insert -- row above insert -- row below insert columns -- protected sheet insert mode for entering text insert rows -- protected sheet inserting -- OLE objects inserting -- cell ranges from spreadsheets inserting -- charts inserting -- comments inserting -- datasource records in spreadsheets inserting -- drawings inserting -- floating frames inserting -- form fields inserting -- hyperlinks inserting -- movies/sounds inserting -- new text tables defaults inserting -- paragraph bullets inserting -- special characters inserting -- Fontwork objects inserting -- buttons in toolbars inserting -- clipboard options inserting -- data from text documents inserting -- line breaks in cells inserting -- objects from Gallery inserting -- paragraph borders inserting -- pictures in Gallery inserting -- push buttons inserting -- tab stops inserting -- textures on chart bars installing -- ActiveX control installing -- UNO components installing -- XML filters instructions -- general invert filter invisible areas italic -- AutoFormat function italic -- using / when typing italic text iterative references in spreadsheets java scripts -- run javascript scripts -- run joining -- paragraphs justifying text kerning -- definition kerning -- in characters kerning -- Asian texts keyboard -- general commands keyboard -- assigning/editing shortcut keys keyboard -- removing numbering keys -- adding push buttons labels -- creating and synchronising labels -- form functions labels -- from databases labels -- for draw objects labels, see also names/callouts languages -- Asian support languages -- activating modules languages -- locale settings languages -- selecting for text languages -- spellcheck languages -- spellchecking and formatting languages -- spelling languages -- spelling languages -- complex text layout languages -- setting options large icons layer arrangement layout -- importing Word documents layout -- pages leading between paragraphs left alignment of paragraphs legends -- charts legends -- draw objects legends -- rounding corners levels -- depth stagger levels -- macro security limits of tables (Writer)line breaks -- in cells line spacing -- context menu in paragraphs line spacing -- paragraph line styles -- applying line styles -- defining lines -- draw functions lines -- drawing in text lines -- editing points lines -- removing automatic lines lines -- defining ends lines of text -- alignment links -- character formats links -- definition links -- editing hyperlinks links -- inserting links -- opening files with links -- updating options (Writer)links -- updating specific links links -- between cells and controls links -- by drag-and-drop links -- turning off automatic recognition list box creation lists -- regular expressions lists -- data assigned to controls lists -- registered databases (Base)loading -- Microsoft Office documents with VBA code loading -- documents from other formats loading -- documents loading -- reloading loading -- XML files loading -- colours/gradients/hatchings loading -- large spreadsheet files locale settings lock files -- Collabora Office lock files -- Microsoft Office locked documents lowercase letters -- font effects macro -- select macro to run macro recording -- limitations macros -- assigning to events in forms macros -- in Microsoft Office documents macros -- interrupting macros -- recording macros -- organising macros -- security levels macros -- security warning dialogue box macros -- security macros -- selecting security warnings magnifiers margins -- setting with the mouse margins -- shadows margins -- defining margins -- pages marking changes marking, see selecting measurement units -- changing on rulers measurement units -- converting measurement units -- selecting menus -- activating context menus menus -- assigning macros menus -- customising merge/merging cells merging -- documents metrics -- converting metrics -- in sheets models in XForms modifying, see changing module file filters mosaic filter mouse -- middle button mouse -- pointers when using drag-and-drop movies moving -- using guide lines in presentations moving -- tab stops on ruler moving -- toolbars multi-line titles in forms multiple documents -- opening multiple selection music names -- multi-line titles names -- objects names, see also labels/callouts namespace organisation in XForms native numeral navigating -- in documents navigator -- rename new databases new documents new lines in cells new windows non-breaking hyphens non-breaking spaces (Writer)non-breaking spaces -- inserting non-printing characters (Writer)notebook bar -- contextual groups notebook bar -- contextual single toolbar notebook bar -- default layout notebook bar -- icon size notebook bar -- layouts notebook bar -- sidebar notebook bar -- single toolbar notebook bar -- tabbed mode notebook bar -- toolbar number formats -- codes number formats -- formats number of pages number of sheets number of tables number of worksheets in new documents numbering -- turning off numbering -- using automatically numbering -- options numbers -- date, time and currency formats object inspector objects -- always moveable (Impress/Draw)objects -- arranging within stacks objects -- copying when moving in presentations objects -- definition objects -- displaying in spreadsheets objects -- displaying in text documents objects -- editing objects -- inserting OLE objects objects -- inserting from Gallery objects -- naming objects -- opening objects -- grouping objects -- moving and resizing with mouse objects -- quickly moving to objects -- text and alt text objects -- ungrouping one and a half line spacing in text online update options online updates -- checking automatically online updates -- checking manually open -- remote file opening -- context menus opening -- dialogue box settings opening -- documents from other formats opening -- documents opening -- files, with placeholders opening -- objects opening -- several files opening -- CMIS remote file opening -- Microsoft Office files opening -- XForms opening -- database files opening -- documents on WebDAV server opening -- documents with links opening -- forms opening -- remote file opening -- reports opening remote file operators -- standard filters optimal column widths -- text table optimal column widths optimal row heights -- text table optimal row heights -- text table;optimal row heights optimal row heights optional hyphens (Writer)options -- accessibility options -- appearance options -- tools options -- Basic IDE options -- compatibility (Writer)options -- online update options -- security ordering -- objects ordinal numbers -- replacing organising -- macros and scripts organising -- namespaces in XForms organizing -- styles original size -- printing in Collabora Office Math original size -- restoring after cropping outline folding buttons -- settings outlines -- font effects outlines -- sending to presentations outlines -- outline symbols overwrite mode packages, see extensions page -- save background image page -- set background image page background image -- save page background image -- set page breaks -- displaying (Calc)page formats -- maximising page formats -- restriction page line-spacing -- definition page margins page size -- defining page styles -- editing/applying with statusbar pages -- backgrounds in all applications pages -- scaling pages -- selecting one to print pages -- formatting and numbering pages -- printing page names in presentations paint box paint can symbol pair kerning palette -- document colours paper formats paper size warning paper trays paragraph -- classification paragraph -- clear direct formatting paragraph marks -- displaying (Writer)paragraph styles -- languages paragraph styles -- modifying basic fonts paragraphs -- Asian typography paragraphs -- alignment paragraphs -- defining borders paragraphs -- hidden paragraphs (Writer)paragraphs -- increasing indents of paragraphs -- indents, margins and columns paragraphs -- inserting bullets paragraphs -- joining paragraphs -- numbering automatically paragraphs -- removing blank ones paragraphs -- tab stops paragraphs -- decreasing indents of paragraphs -- spacing parameters -- command line password as document property passwords for protecting contents paste -- nested table paste -- unformatted text paste nested table paste special -- nested table paste special -- only formula (spreadsheet)paste special -- only numbers (spreadsheet)paste special -- only text (spreadsheet)paste special -- unformatted text pasting -- Ctrl+V shortcut pasting -- Enter key pasting -- cell ranges pasting -- cell ranges from spreadsheets pasting -- data from text documents pasting -- draw objects from other documents pasting -- draw objects pasting -- formatted/unformatted text pasting -- from data source view pasting -- from data sources to Collabora Office Calc pasting -- pictures from other documents pasting -- sheet areas in text documents pasting -- to Gallery paths -- changing working directory paths -- defaults paths -- template files pattern -- area pattern -- background patterns for objects percentages, formats personal data -- cursor position personal data input phonetic guide pick colour picklist creation pictures -- ImageMap pictures -- arranging within stacks pictures -- backgrounds pictures -- changing paths pictures -- cropping and zooming pictures -- displaying in Calc pictures -- displaying in Writer (Writer)pictures -- drag-and-drop between documents pictures -- drawing pictures -- editing pictures -- inserting automatically pictures -- inserting from Gallery pictures -- printing pictures -- adding to Gallery pictures -- assigning macros pictures -- filters pictures -- number of pictures -- scaling/resizing pixel graphics -- inserting and editing placeholders -- on opening files placing toolbars playing movies and sound files plotting data as charts points -- reducing editing points when snapping (Impress/Draw)polygon drawing pop-art filter portable document format positioning -- fonts positioning -- objects positioning -- draw objects and controls positioning -- toolbars post method for form transmissions posterising filter precision as shown (Calc)predefining fonts predictive text, see also AutoCorrect function/AutoFill function/AutoInput function/word completion/text completion prefix name for new worksheet presentations -- auto-redact presentations -- print menu presentations -- redacting contents presentations -- saving automatically presentations -- saving in other formats presentations -- saving presentations -- sending as email presentations -- starting with wizard presentations -- creating/opening presentations -- inserting spreadsheet cells press buttons, see push buttons previews -- fonts lists primary keys -- design view print area selection printers -- adding, UNIX printers -- choosing printers -- default printer printers -- faxes under UNIX printers -- maximum page formats printers -- properties printers -- paper trays printing -- black and white printing -- brochures printing -- colours in greyscale printing -- copies printing -- creating individual jobs printing -- dates in presentations printing -- directly printing -- documents printing -- drawings defaults printing -- elements in text documents printing -- fitting to pages in Collabora Office Math printing -- fitting to pages in presentations printing -- hidden pages of presentations printing -- in original size in Collabora Office Math printing -- left/right pages printing -- scaling in Collabora Office Math printing -- selections printing -- text always in black printing -- text in reverse order printing -- tiling pages in presentations printing -- warnings printing -- without scaling in presentations printing -- comments printing -- faster printing -- formulae in Collabora Office Math printing -- manual breaks printing -- transparencies printing speed private key -- file encryption profile -- safe mode programming -- scripting properties -- form controls properties -- forms properties -- hotspots properties -- printers properties -- fields in databases properties -- files protect -- sheet protected contents protected database tables protected documents protected hyphens protected sheet -- delete columns protected sheet -- delete rows protected sheet -- insert columns protected sheet -- insert rows protected spaces -- showing (Writer)protected spaces -- inserting protecting -- contents protecting -- recorded changes proxy settings public key -- file encryption push buttons -- adding to documents push buttons -- creating python scripts -- run queries -- editing in data source view queries -- set properties queries -- creating in SQL view queries -- defining (Base)quotes -- custom radio button creation read-only documents -- database tables on/off read-only documents -- editing read-only documents -- cursor read-only documents -- opening documents as read-only items in Data Navigator recalculate -- formula options recalculating -- formula options recalculating -- large spreadsheet files recognising URLs automatically recording -- changes recording -- macros records -- inserting comments records -- protecting records -- saving records -- searching in databases rectangle drawing rectangles with round corners recursion in spreadsheets redaction redo command reduced printing reference lines references -- displaying in color (Calc)references -- expanding (Calc)references -- iterative (Calc)register-true -- definition registering -- address books registering -- databases (Base)regular expressions -- begin of paragraph regular expressions -- begin of word regular expressions -- empty paragraph regular expressions -- end of paragraph regular expressions -- list of regular expressions -- new line relative hyperlinks relative saving of URLs reloading -- documents remarks, see also comments remote file -- open remote file -- save remote file service -- CMIS properties remote file service -- Google Drive remote file service -- Windows share remote file service -- checkin remote file service -- checkout remote file service -- file lock remote file service -- file properties remote file service -- opening file remote file service -- saving to remote server remote file service -- saving remote file service -- setup remote file service -- version control remote file service -- working copy remote file service setup -- Alfresco remote file service setup -- CMIS server remote file service setup -- FTP remote file service setup -- Google Drive remote file service setup -- IBM remote file service setup -- Lotus remote file service setup -- Nuxeo remote file service setup -- SSH remote file service setup -- SharePoint remote file service setup -- WebDAV remote file service setup -- Windows share remote file service setup -- other file services remove noise filter removing -- bullets and numbering removing -- form filters removing, see also deleting rename -- objects repeating -- commands replace -- image replacement options replacement table replacing -- AutoCorrect function replacing -- tab stops (regular expressions)replacing -- dashes replacing -- ordinal numbers report -- add database field reports -- crash reports reports -- creating reports -- opening and editing reports -- templates resetting -- Find & Replace mode resetting -- templates resizing -- objects, by mouse resizing, see also scaling/zooming resolution when printing bitmaps resolving -- comments restoring -- default formatting restoring -- editing reversing printing order review function -- comparing documents review function -- navigating changes review function -- recording changes example review function -- accepting or rejecting changes review function -- protecting records review function -- tracking changes rich text control right alignment of paragraphs right-to-left text rotating -- 3-D text round corners rounding precision (Calc)row -- insert above row -- inserting below row headers -- displaying (Calc)row headers -- highlighting (Calc)row height -- distribute equally rows -- optimal heights rulers -- default settings rulers -- measurement units rulers -- visible in presentations run macro -- select run scripts -- beanshell run scripts -- java run scripts -- javascript run scripts -- python samples and templates save -- remote file save -- save a copy save a copy saving -- VBA code in Microsoft Office documents saving -- default file formats saving -- dialogue box settings saving -- documents in other formats saving -- documents saving -- options saving -- documents, automatically saving -- in Microsoft Office file format saving -- templates saving -- to XML saving -- with password by default saving as command -- precautions scaling -- objects scaling -- printing in Collabora Office Math scaling -- when printing presentations scaling -- pictures scaling, see also zooming scientific notation, formats screen -- full screen views screen -- scaling screen magnifiers screen readers script organisation scrollbars -- displaying (Calc)scrollbars -- horizontal and vertical (Writer)search -- Help index search commands search criteria for database functions in cells search engines -- definition searching -- all sheets searching -- databases searching -- form filters searching -- formatted display searching -- formatted numbers searching -- tables and forms sections -- backgrounds security -- digital signatures security -- options for documents with macros security -- protecting contents security -- security levels for macros security -- warning dialogue boxes with macros selecting -- print areas selecting -- several files selecting -- controls selecting -- measurement units selecting -- objects selecting -- security options selecting -- security warnings selection -- in protected cells selection clipboard selection frames selection modes in text sending -- AutoAbstract function in presentations sending -- documents as email sending -- documents as faxes separator lines -- defining separators -- conditional separators -- array column separators -- array row separators -- function setting options -- OpenCL settings -- printers settings -- program configuration settings -- proxies settings -- views shadows -- areas shadows -- borders shadows -- characters shadows -- characters, using context menu shapes -- control points shapes sharing documents sharpening filter sheet table -- AutoFormat function sheet tabs -- displaying sheets -- optimal row heights sheets -- searching all shortcut keys -- Collabora Office accessibility shortcut keys -- Unicode shortcut keys -- general shortcut keys -- in databases shortcut keys -- assigning macros show -- sidebar showing -- changes showing -- drawings and controls (Writer)showing -- docked windows showing -- toolbars sidebar -- notebook bar sidebar -- view signature line -- adding signature line -- signing signing documents with digital signatures similarity search simplified Chinese -- conversion to traditional Chinese single line spacing in text sizes -- pictures sizes -- draw objects slanting draw objects slide -- save background image slide -- set background image slide background image -- save slide background image -- set small capitals small icons smart tag configuration smooth scrolling (Writer)smoothing filter snap grid defaults (Writer/Calc)snap lines -- showing when moving frames (Writer)snapping in presentations and drawings soft hyphens (Writer)soft hyphens -- inserting solarisation filter sort lists -- copying to in Calc sorting -- data in forms sorting -- databases sound files spaces -- displaying (Writer)spaces -- ignoring double spaces -- inserting protected spaces spaces -- showing protected spaces (Writer)spacing -- between paragraphs in footnotes spacing -- font effects spacing -- lines and paragraphs spacing -- tab stops in text documents spacing -- tabs in presentations special characters speech bubbles speed of printing spellcheck -- activating for a language spellcheck -- context menus spellcheck -- default languages spellcheck -- dialog spellcheck -- dictionary of exceptions spellcheck -- ignore list spelling -- activating for a language spelling -- context menus spelling -- default languages spelling -- dialog spelling -- dictionary of exceptions spelling -- ignore list spelling -- LanguageTool split/splitting cells spoolfiles with Xprinter spreadsheet -- auto-redact spreadsheet -- redacting contents spreadsheets -- copying areas to text documents spreadsheets -- inserting charts spreadsheets -- optimal column widths spreadsheets -- printing spreadsheets -- saving automatically spreadsheets -- saving in other formats spreadsheets -- saving spreadsheets -- sending as email spreadsheets -- creating/opening spreadsheets -- inserting database records square drawings standard bar on/off standard filters -- comparison operators standard filters in databases standard printer under UNIX start centre start parameters status bar on/off stickers strikeout -- AutoFormat function strikeout -- using - when typing strikethrough -- font effects strikethrough -- characters string -- conversion to date settings string -- conversion to number settings string -- conversion to reference settings string -- setting in spreadsheet formulas string conversion to date options string conversion to number options string conversion to reference options styles -- changed message styles -- organizing styles -- replacing automatically styles -- drawing objects styles -- keyboard shortcuts styles -- table styles sub-forms -- creating sub-forms -- description submitting forms suffixes in file formats support on the Web synchronising -- labels and business cards system address book registration tab stops -- displaying (Writer)tab stops -- inserting and editing tab stops -- regular expressions tab stops -- setting in sheets tab stops -- spacing in presentations tab stops -- spacing in text documents tab stops -- settings table columns -- distribute columns evenly table controls -- properties table controls -- keyboard-only edit mode table rows -- distribute height equally table views of databases tables -- AutoFormat function tables -- inserting line breaks tables in databases -- adding to queries tables in databases -- creating in design view (manually)tables in databases -- searching tables in databases -- browsing and editing tables in databases -- creating tables in spreadsheets -- value highlighting tables in spreadsheets -- copying data to other applications tables in spreadsheets -- defining borders tables in text -- creating automatically tables in text -- default settings tables in text -- defining borders tables in text -- displaying tables in text -- printing tabs -- displaying sheet tabs tags -- META tags tags -- definition template manager -- category template manager -- export template manager -- filter template manager -- import template manager -- set as default template manager -- settings templates -- new documents from templates templates -- opening documents with templates -- agendas templates -- changing basic fonts templates -- database reports templates -- editing and saving templates -- faxes templates -- letters templates -- template manager terminology -- Internet glossary terminology -- general glossary testing XML filters text -- Asian layout text -- Fontwork icons text -- alignment text -- animating text -- bold text -- colouring text -- copying by drag-and-drop text -- drawing pictures text -- font effects text -- font sizes text -- font styles text -- fonts and formats text -- inserting special characters text -- italics text -- kerning text -- language selection text -- line spacing text -- overwriting or inserting text -- printing in black text -- replacing with format text -- selection modes text -- shadowed text -- text/draw objects text -- CTL languages text -- hyperlinks text alternative -- objects text attributes -- hyperlinks text attributes -- finding text attributes -- undoing text boxes -- positioning text boxes -- form functions text breaks in cells text colours for better accessibility text documents -- auto-redact contents text documents -- importing/exporting text documents -- print settings text documents -- printing text documents -- redacting contents text documents -- saving automatically text documents -- saving text documents -- creating/opening text documents -- inserting spreadsheet cells text documents -- saving in other formats text documents -- sending as email text effects text flow -- in cells text formats -- databases text formats -- pasting text input fields text layout for special languages text objects -- draw functions text objects -- fonts text objects -- in presentations and drawings text overflow in spreadsheet cells text table -- optimal column widths text, see also text documents, paragraphs and characters textures -- inserting from Gallery textures -- on chart bars themes -- colors thesaurus -- activating for a language ticker text time stamp -- digital signature time stamp authority time stamp for PDF digital signature times -- inserting when printing presentations times, formats tip of the day tip of the day tips -- extended tips in Help title rows -- printing in Collabora Office Math titles -- changing titles -- editing in charts titles -- font effects titles -- formatting automatically to cell -- anchoring to character -- anchoring to frame -- anchoring to page -- anchoring to paragraph -- anchoring toolbar -- notebook bar toolbars -- Form Navigation bar toolbars -- adding buttons toolbars -- docking/undocking toolbars -- locking/unlocking toolbars -- viewing/closing tools bar tooltips -- help tooltips -- extended tips tooltips -- in scroll bars traditional Chinese -- conversion to simplified Chinese translation -- automatic translation -- server settings transparency -- areas transparency -- off for faster printing tree view of Help triangle drawing typefaces -- formats typography -- Asian underlining -- AutoFormat function underlining -- text underlining -- using _ when typing underlining -- characters undocking windows undoing -- direct formatting undoing -- editing unformatted text -- paste special ungroup -- objects ungrouping groups units -- converting units -- measurement units unmerge/unmerging cells unordered list unstable options update options updates -- checking automatically updates -- checking manually updating -- fields and charts, automatically (Writer)updating -- links in text documents updating -- links, on opening updating -- templates user data -- cursor position user data -- input user data -- removing when saving user-defined dictionaries -- dictionary of exceptions user-defined dictionaries -- editing user-defined dictionaries -- creating user-defined styles -- automatically replacing using -- document themes values -- rounded as shown (Calc)variables -- for paths version management version numbers of documents versions -- Collabora Office versions -- comparing documents versions -- of a document versions -- file saving as, restriction versions -- merging document versions vertical callouts vertical scrollbars (Writer)vertical text boxes videos view -- comments view -- sidebar viewing -- databases viewing -- Collabora Office documents in Internet Explorer viewing -- file properties viewing -- toolbars views -- defaults views -- icons views -- scaling views -- full screen warnings -- security watermarks web documents -- XForms windows -- docking definition windows -- hiding/showing/docking windows -- docking windows -- new wizards -- Euro Converter wizards -- document converter wizards -- letters wizards -- overview wizards -- agendas wizards -- database queries wizards -- faxes wizards -- forms wizards -- reports word counts -- separators words -- automatically replacing words -- wrapping in cells words -- formatting marks words -- wrapping in CTL working directory change wrapping text -- in cells write protection on/off writing aids -- LanguageTool writing aids -- translation writing aids options years -- 2-digit options zero values -- displaying (Calc)zooming -- pictures zooming -- status bar zooming -- page views

Form Control

This sub-menu contains form controls like a text box, check box, option button, and list box that can be inserted into the document.

Please support us!

About Us | Privacy Policy | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Mozilla Public License v2.0. “LibreOffice” and “The Document Foundation” are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in TDF's trademark policy. Collabora Office is derived from LibreOffice which was based on OpenOffice.org.

Help content debug info:

This page is: /text/shared/menu/insert_form_control.xhp

Title is: Form Control Menu