Collabora Office 24.04 Help

Collabora Office

Enska (BNA)Arabíska Búlgarska Katalónska Tékkneska Danska Þýska Gríska Enska (Bretland)Esperantó Spænska Baskneska Finnska Franska Galisíska Hebreska Króatíska Ungverska Indónesíska Íslenska Ítalska Japanska Kóreska Laó Norskt bókmál Hollenska Pólska Portúgalska Portuguese (Brazil)Albanska Rússneska Slóvakíska Slóvenska Sænska Tyrkneska Úkraínska Víetnamska Chinese (Simplified)Chinese (Traditional)

Efnisyfirlit

Textaskjöl (Writer)
- Almennar upplýsingar og notkun notandaviðmóts
- Tilvísanir í skipanir og valmyndir
  - Valmyndir
    - Valmyndir
    - Skrá
    - Breyta
    - Skoða
    - Setja inn
    - Sníða
    - Tafla
    - Eyðublaðavalmynd
    - Main Tools Menu
    - Gluggi
    - Hjálp
  - Tækjaslár
- Flakk í textaskjölum
- Snið í textaskjölum
- Sniðmát og stílar
- Myndefni í textaskjölum
- Töflur í textaskjölum
- Hlutir í textaskjölum
  - Positioning Objects
  - Wrapping Text Around Objects
- Hlutar og rammar í textaskjölum
- Efnisyfirlit og atriðaskrár
- Gagnasvið í textaskjölum
- Útreikningar í textaskjölum
- Sérstakar textaeiningar
- Sjálfvirkar aðgerðir
- Tölusetning og listar
- Stafsetningarleiðrétting, samheiti og tungumál
- Vandamálalausnir
  - Inserting Text Before a Table at the Top of Page
  - Going to Specific Bookmark
- Hleðsla, vistun, innflutningur, útflutningur og ritskoðun
- Stýriskjöl
  - Stýriskjöl og undirskjöl
- Tenglar og tilvísanir
  - Inserting Cross-References
  - Inserting Hyperlinks With the Navigator
- Prentun
- Leit og útskipting
  - Using Regular Expressions in Text Searches
  - List of Regular Expressions

HTML-skjöl (Writer Web)

Töflureiknar (Calc)
- Almennar upplýsingar og notkun notandaviðmóts
- Tilvísanir í skipanir og valmyndir
  - Valmyndir
    - Valmyndir
    - Skrá
    - Breyta
    - Skoða
    - Setja inn
    - Sníða
    - Blað
    - Gögn
    - Main Tools Menu
    - Gluggi
    - Hjálp
  - Tækjaslár
- Gerðir falla og virkjar
- Hleðsla, vistun, innflutningur, útflutningur og ritskoðun
- Forsníðing
- Síun og röðun
- Prentun
- Gagnasvið
- Veltitafla
- Veltiröflulínurit
- Data Analysis
- Atburðarásir
  - Using Scenarios
- Subtotals
  - Using Subtotals Tool
- Tilvísanir
- Skoða, velja, afrita
- Formúlur og útreikningar
- Verndun
  - Protecting Cells from Changes
  - Unprotecting Cells
- Writing Calc Macros
  - Reading and Writing values to Ranges
  - Formatting Borders in Calc with Macros
- Ýmislegt

Kynningar (Impress)
- Almennar upplýsingar og notkun notandaviðmóts
- Tilvísanir í skipanir og valmyndir
  - Valmyndir
    - Valmyndir
    - Skrá
    - Breyta
    - Skoða
    - Setja inn
    - Sníða
    - Skyggna
    - Skyggnusýning
    - Main Tools Menu
    - Gluggi
    - Hjálp
  - Tækjaslár
- Hleðsla, vistun, innflutningur, útflutningur og ritskoðun
- Forsníðing
- Prentun
  - Printing Presentations
  - Printing a Slide to Fit a Paper Size
- Brellur
- Hlutir, myndefni og bitamyndir
- Texti í kynningum
  - Bæta við texta
  - Converting Text Characters into Drawing Objects
- Skoðun
  - Changing the Slide Order
  - Zooming With the Keypad
- Skyggnukynningar

Teikningar (Draw)
- Almennar upplýsingar og notkun notandaviðmóts
- Tilvísanir í skipanir og valmyndir
  - Valmyndir
    - Valmyndir
    - Skrá
    - Breyta
    - View (menu in Draw)
    - Setja inn
    - Sníða
    - Síða
    - Lögun
    - Main Tools Menu
    - Gluggi
    - Hjálp
  - Verkfærastikur
- Hleðsla, vistun, innflutningur og útflutningur
  - Loading Color, Gradient, and Hatching Palettes
  - Setja inn myndefni
- Sníðing
- Prentun
  - Printing Presentations
  - Printing a Slide to Fit a Paper Size
- Brellur
- Hlutir, myndefni og bitamyndir
- Hópar og lög
- Texti í teikningum
  - Bæta við texta
  - Converting Text Characters into Drawing Objects
- Skoðun
  - Zooming With the Keypad

Database Functionality (Base)
- General Information

Formúlur (Math)
- Almennar upplýsingar og notkun notandaviðmóts
  - Velkomin í hjálpina fyrir Collabora Office Math
  - Eiginleikar Collabora Office Math
  - Collabora Office formúlueiningar
  - Leiðbeiningar fyrir notkun Collabora Office Math
  - Shortcuts (Collabora Office Math Accessibility)
- Tilvísanir í skipanir og valmyndir
  - Valmyndir
  - Tækjaslár
- Unnið með formúlur

Línurit og skýringamyndir
- Almennar upplýsingar

Fjölvar og skriftur

Uppsetning Collabora Office
- Breyta skráavenslum við Microsoft Office skjalagerðir
- Safe Mode

Algeng efnisatriði til hjálpar
- Almennar upplýsingar
- Collabora Office og Microsoft Office
- Collabora Office stillingar
- Leiðarvísar
  - Leiðarvísir
  - Leiðarvísir fyrir bréf
    - Leiðarvísir fyrir bréf
  - Leiðarvísir fyrir fax
    - Leiðarvísir fyrir fax
  - Leiðarvísir fyrir dagskrá
    - Leiðarvísir fyrir dagskrá
  - Leiðarvísir fyrir umbreytingu skjala
    - Skjalaumbreytir
  - Euro Converter Wizard
- Uppsetning Collabora Office
- Vinna með notandaviðmót
- Stafrænar undirritanir
- Prentun, útsending, fax
- Draga & Sleppa
- Afrita og líma
- Línurit og skýringamyndir
  - Inserting Charts
  - Gröf í Collabora Office
- Hlaða, vista, flytja inn, flytja út, PDF
- Tenglar og tilvísanir
- Yfirlit yfir útgáfur skjala
- Nafnspjöld og merkimiðar
  - Creating and Printing Labels and Business Cards
- Setja inn utanaðkomandi gögn
- Sjálfvirkar aðgerðir
  - Turning off Automatic URL Recognition
- Leit og útskipting
- Leiðbeiningasíður

⇤
←
1
2
3
4
5
6
→
⇥

### error message#N/A error -- assigning to a cell #N/A error -- recognizing #N/A error -- testing #N/A error message #NAME error message #REF error message ABS function ACCRINT fall ACCRINTM function ACOS fall ACOSH fall ACOT fall ACOTH fall ADDRESS fall AMORDEGRC function AMORLINC function AND fall AND fall ANOVA -- Analysis toolpack ARABIC function AREAS fall AREAS fall ASC fall ASC fall ASC function ASIN fall ASINH fall ATAN fall ATAN2 fall ATANH fall AVEDEV function AVERAGE fall AVERAGEA fall 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 Asísk tungumál -- raða 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 fall BASE fall BESSELI function BESSELJ function BESSELK function BESSELY function BETA.DIST function BETA.INV function BETADIST function BETAINV function BIN2DEC function BIN2HEX function BIN2OCT function BINOMDIST fall BINOMDIST fall BINOMDIST fall BINOMDIST fall BINOMDIST fall Basic IDE for user-defined functions Bessel functions CEILING function CEILING.MATH function CEILING.PRECISE function CEILING.XCL function CELL function CHAR fall CHIDIST fall CHIDIST fall CHIDIST fall CHIINV fall CHISQDIST function CHISQINV fall CHISQINV fall CHISQINV fall CHITEST fall CHITEST fall CHOOSE fall CLEAN fall CODE fall COLOR function COLUMN fall COLUMNS fall COMBIN function COMBINA function COMPLEX fall CONCAT function CONCATENATE fall CONCATENATE fall CONCATENATE fall CONCATENATE fall CONCATENATE fall CONFIDENCE fall CONFIDENCE fall CONFIDENCE fall CONVERT function CONVERT_OOO function CORREL function COS fall COSH fall COT fall COTH fall COUNT function COUNTA function COUNTBLANK function COUNTIF function COUNTIFS function COUPDAYBS function COUPDAYS fall COUPDAYSNC fall COUPNCD fall COUPNUM function COUPPCD function COVAR fall COVAR fall COVAR fall CRITBINOM fall CTL -- right-to-left sheets CUMIPMT function CUMIPMT_ADD fall CUMPRINC function CUMPRINC_ADD fall CURRENT fall Chi-square test -- Analysis toolpack Confidence level -- regression analysis DATE fall DATE fall DATEVALUE fall DAVERAGE function DAY fall DAYS fall DAYS360 fall DAYSINMONTH function DAYSINYEAR function DB function DCOUNT function DCOUNTA function DDB function DDE fall DEC2BIN function DEC2HEX function DEC2OCT function DECIMAL fall DEGREES function DELTA function DEVSQ function DGET function DISC function DMAX function DMIN function DOLLAR fall 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 fall EASTERSUNDAY fall EASTERSUNDAY fall EASTERSUNDAY fall EDATE fall EFFECT function EFFECT_ADD function ENCODEURL function EOMONTH fall ERF function ERF.PRECISE function ERFC fall ERFC fall ERROR.TYPE function ERRORTYPE fall EUROCONVERT function EVEN function EXACT fall EXP fall EXPON.DIST function EXPONDIST function Euro -- converting F-test -- Analysis toolpack F.INV function F.INV.RT function F2 -- cell edit mode FACT function FACTDOUBLE function FALSE fall FDIST fall FDIST fall FDIST fall FIND fall FINDB Function FINV function FISHER fall FISHER fall FISHERINV function FIXED fall FLOOR function FLOOR.MATH function FLOOR.PRECISE function FLOOR.XCL function FORECAST function FORECAST.LINEAR function FORMULA function FOURIER function FREQUENCY fall FTEST fall FTEST fall 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 fall GAMMADIST fall GAMMADIST fall GAMMAINV fall GAMMAINV fall GAMMALN function GAMMALN.PRECISE function GAUSS function GCD function GCD_EXCEL2003 function GEOMEAN function GESTEP function GETPIVOTDATA fall GROWTH function Gaussian error integral Gaussian error integral Go to sheet HARMEAN function HEX2BIN function HEX2DEC function HEX2OCT function HLOOKUP fall HOUR fall HTML -- in sheet cells HTML -- sheets HTML WebQuery HYPERLINK fall HYPGEOM.DIST function HYPGEOMDIST function Help tips -- defining text for cell input HowTos for Calc IDE -- Basic IDE IF fall IFERROR function IFNA function IFS function IMABS fall IMAGINARY fall IMARGUMENT fall IMCONJUGATE fall IMCOS function IMCOSH function IMCOT function IMCSC function IMCSCH function IMDIV fall IMEXP fall IMLN fall IMLOG10 fall IMLOG2 fall IMPOWER fall IMPRODUCT fall IMREAL fall IMSEC function IMSECH function IMSIN function IMSINH function IMSQRT fall IMSUB fall IMSUM fall IMTAN function INDEX fall INDIRECT fall INFO fall INT function INTERCEPT function INTRATE fall IPMT function IRR function ISBLANK function ISERR function ISERROR function ISEVEN function ISEVEN_ADD fall ISFORMULA function ISLEAPYEAR function ISLOGICAL function ISNA function ISNONTEXT function ISNUMBER function ISO.CEILING function ISODD function ISODD_ADD fall ISPMT function ISREF function ISTEXT function JIS function KURT fall LARGE fall LCM function LCM_EXCEL2003 function LEFT fall LEFT fall LEN fall LEN fall LINEST fall LN function LOG function LOG10 function LOGEST fall LOGINV function LOGNORM.DIST function LOGNORM.INV function LOGNORMDIST function LOOKUP fall LOWER fall MATCH fall MAX fall MAXA fall MAXIFS function MDETERM function MDURATION function MEDIAN fall MID fall MID fall MIN fall MINA fall MINIFS function MINUTE fall MINVERSE function MIRR function MMULT fall MOD function MODE function MODE.MULT function MODE.SNGL function MONTH fall MONTHS function MROUND function MULTINOMIAL fall MUNIT fall Macauley duration N fall N fall N fall N fall N fall N fall N fall N fall NA function NEGBINOM.DIST function NEGBINOMDIST function NETWORKDAYS function NETWORKDAYS.INTL function NETWORKDAYS_EXCEL2003 function NOMINAL function NOMINAL_ADD fall NORM.DIST function NORM.INV function NORM.S.DIST function NORM.S.INV function NORMDIST function NORMINV function NORMSDIST function NORMSINV function NOT fall NOW fall NPER function NPV function Navigator -- for sheets OCT2BIN function OCT2DEC function OCT2HEX function ODD function ODDFPRICE function ODDFYIELD fall ODDLPRICE fall ODDLPRICE fall ODDLYIELD fall OFFSET fall OPT_BARRIER function OPT_PROB_HIT function OPT_PROB_INMONEY function OPT_TOUCH function OR fall OR fall OR fall OR fall PDF export of print ranges PDURATION function PEARSON fall PERCENTILE fall PERCENTILE fall PERCENTILE fall PERCENTRANK fall PERCENTRANK fall PERCENTRANK fall PERMUT function PERMUTATIONA fall PHI fall PI fall PMT function POISSON fall POISSON fall POWER fall PPMT fall PRICE function PRICEDISC function PRICEMAT function PROB fall PRODUCT function PROPER fall PV function QUARTILE fall QUARTILE fall QUARTILE fall 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 fall REPLACEB Function REPT fall RIGHT fall RIGHT fall ROMAN function ROT13 function ROUND fall ROUNDDOWN function ROUNDSIG Function ROUNDUP fall ROW fall ROW fall ROWS fall RRI function RSQ function SEARCH fall SEARCH fall SEARCHB Function SECOND fall SERIESSUM fall SHEET function SHEETS function SIGN function SIN fall SINH fall SKEW fall SKEW fall SKEWP function SLN function SLOPE fall SMALL fall SQRT function SQRTPI function STANDARDIZE function STDEV function STDEV.P function STDEV.S function STDEVA fall STDEVP function STDEVPA fall STEYX function STYLE function example STYLE function SUBSTITUTE fall SUBTOTAL function SUM function SUMIF function SUMIFS function SUMPRODUCT function SUMSQ function SUMX2MY2 fall SUMX2PY2 fall SUMXMY2 fall SWITCH function SYD function Solver for Nonlinear Problems -- Options Styles window Stylist, see Styles window T fall T.DIST function T.DIST.2T function T.DIST.RT function T.INV function T.INV.2T function TAN fall TANH fall TBILLEQ function TBILLPRICE function TBILLYIELD function TDIST function TEXT fall TEXTJOIN function TIME fall TIMEVALUE fall TIMEVALUE fall TINV function TODAY fall TRANSPOSE fall TREND fall TRIM fall TRIMMEAN function TRUE fall TRUNC function TTEST fall TTEST fall TYPE fall UNICHAR fall UNICODE fall UPPER fall URL -- in Calc VALUE function VAR function VAR.S function VARA fall VARP fall VARP fall VARPA fall VDB function VLOOKUP function Values of the inverse left tail of the F distribution Values of the inverse right tail of the F distribution WEEKDAY fall WEEKNUM fall WEEKNUM fall WEEKNUM_ADD fall WEEKNUM_ADD fall WEEKS function WEEKSINYEAR function WEIBULL fall WEIBULL fall WORKDAY fall WORKDAY.INTL function WebQuery filter XIRR function XML Source -- load XML data in spreadsheets XNPV fall YEAR fall YEARFRAC fall YEARS function YIELD function YIELDDISC function YIELDMAT function Z-test -- Analysis toolpack ZTEST fall ZTEST fall 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 interests 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 amortization installment amortizations, 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 contents borders -- printing cells borders -- cells and pages borders -- cells breaks in cells calculate -- force recalculation calculate -- recalculate hard calculating -- accumulated interests 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 amortization installments calculating -- present values calculating -- series calculating -- spreadsheets calculating -- total amortizement rates calculating -- with formulas 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 contents -- deleting cell contents -- recalculating cell contents -- AutoCalculate function cell contents -- force recalculation cell contents -- no text cell contents -- numbers cell contents -- searching in Calc databases cell contents -- testing for references cell contents -- text cell edit mode cell formats -- assigning by formulas 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 formulas cell widths cells -- AutoInput function of text cells -- Internet references cells -- autorefreshing 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 precedents cells -- rotating text cells -- selecting cells -- text breaks cells -- text super/sub cells -- trace fill mode cells -- tracing errors cells -- tracing precedents cells -- validity cells -- borders cells -- comments cells -- date and time formats cells -- formatting dialog 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 -- calculating in spreadsheets colors -- negative numbers colors -- numerical values colors -- values column breaks -- inserting column breaks -- deleting column headers -- hiding column headers -- using in formulas 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 normalized values converting -- text with leading zeros, into numbers converting -- text, into numbers copying -- array formulas copying -- cell styles copying -- formulas 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 csv files -- formulas csv files -- importing and exporting 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 customized 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 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 contents 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 amortizations depreciations -- geometric-degressive depreciations -- linear amortizations depreciations -- linear depreciations -- variable declining descriptive statistics -- Analysis toolpack determinants determination coefficients discounts display options in pivot table displaying -- comments displaying -- formulas instead of results displaying -- headers of columns/rows displaying -- scenario names displaying -- sheets displaying -- formulas 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 -- recognizing 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 -- formulas as csv files exporting -- spreadsheets to dBASE extending print ranges external DLL functions external data -- inserting extrapolations extrapolations eðlileg röðun factorials -- numbers with increments of two factorials -- numbers file names in headers/footers fill range -- random numbers filling -- cells, automatically filling -- customized 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 -- formulas/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 formulas 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 -- canceling inputs formula bar -- functions formula bar -- input line formula bar -- sheet area names formula bar -- spreadsheets formula bar -- sum function formula cells -- displaying formulas in other cells formula cells -- recognizing formula cells -- removing precedents formula cells -- tracing precedents formula list window formula to values -- convert formula to values -- recalculate formulas -- arrays formulas -- calculating formulas -- copying and pasting formulas -- defining names formulas -- displaying in cells formulas -- importing/exporting as csv files formulas -- inputting formulas -- matrix formulas formulas -- operators formulas -- printing, instead of results formulas -- recalculating manually formulas -- using double quotation marks formulas -- using row/column labels formulas -- AutoCalculate function formulas -- assigning cell formats formulas -- calculating with formulas -- force recalculation formulas -- hiding formulas -- recalculate hard formulas -- status bar 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 -- canceling 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 -- formulas 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 formulas 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 -- formulas inserting -- fractions inserting -- matrix formulas 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 amortization installments 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 lognormal 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 formulas 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 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 -- colors 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 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 -- formatting decimals 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 -- formulas pasting -- values in multiple sheets payment periods -- number of periodic amortizement rates permitted cell contents 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 -- examples random numbers non-volatile -- between limits random numbers non-volatile -- between 0 and 1 random rumbers -- distribution random rumbers -- fill range 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 formulas in sheets recalculate -- auto calculating sheets recalculate -- formula to values recalculating -- all formulas in sheets recalculating -- auto calculating sheets recalculating -- pivot tables recognizing -- column and row labels recognizing -- equal numbers recognizing -- general errors recognizing 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 reglur við röðun í nafnaskrá 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.LINEAR 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 installment repeating -- columns/rows on printed pages replace formula with values replace text -- REPLACEB Function replacing -- cell contents results display vs. formulas 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 formulas 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 röðun -- möguleikar í gagnagrunnareitum röðun -- Asísk tungumál 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 -- 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 -- sort criteria for database ranges 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 contents 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 formulas/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 -- 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 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 center cells total amortizement rates traces -- autorefreshing 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 views3D Effects3D text creation API -- XConfirmDeleteListener API -- XDatabaseParameterListener API -- XLoadListener API -- XResetListener API -- XRowSetApproveListener API -- XRowSetListener API -- XSQLErrorListener API -- XSubmissionVetoListener API -- XSubmitListener API -- XUpdateListener ASCII -- skilgreining ActiveX control Agenda Wizard Arabic -- entering text Arabic -- languages and locales Asian languages -- enabling Asian typography Atriðisorðaskrár flipi í Hjálp 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 dialogs -- organize in libraries Basic macros -- organize in libraries Basic modules -- organize 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 colors Collabora Office documents -- viewing and editing in Internet Explorer Crash Report Tool DDE -- skilgreining 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 Euro -- Euro Converter Wizard 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 dialog Find toolbar Finna flipa í Hjálp Fontwork 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 -- export character set HTML -- importing META tags HTML -- skilgreining 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 -- navigation pane showing/hiding Help pages -- Index Help pages -- contents Help pages -- search in index Help tips -- hiding Hindi -- entering text Hindi -- languages and locales Hjálp -- Leit í öllum textanum Hjálp -- Stikkorð Hjálp -- bókamerki Hjálp -- efni Hjálp -- ítarlegar hjálparábendingar af/á IME -- skilgreining ImageMap -- editor ImageMap -- hotspot properties ImageMap -- skilgreining Internet -- Internet Explorer for displaying Collabora Office documents Internet -- checking for updates Internet glossary JDBC -- skilgreining Java -- skilgreining Java -- setting options LCID, extended LanguageTool -- settings Leit í öllum textanum í Hjálp Leiðsagnarstika -- eyðublöð Letter Wizard Lotus -- command line filter options META tags Material Design colors 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 -- importing Word documents Microsoft Office -- importing password protected files Microsoft Office -- opening Microsoft documents Microsoft Office -- reassigning document types Microsoft Office -- samanburður eiginleika Microsoft Office -- upplýsingar fyrir nýja notendur;nýir notendur Microsoft lock files My Documents folder -- opening My Documents folder -- changing work directory Navigator -- contents as lists Navigator -- docking Navigator -- comments Navigator -- working with ODBC -- skilgreining ODF file formats OLE -- skilgreining 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 og Collabora Office OpenCL -- setting options OpenDocument file formats OpenGL -- skilgreining 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 export Punktastika QR code -- barcode Query Wizard (Base)SGML -- skilgreining SQL -- DISTINCT parameter SQL -- LIMIT clause SQL -- executing SQL commands SQL -- skilgreining 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 -- 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/organizing 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 -- options activating -- Crash Report Tool activating -- context menus add-ons, see UNO components adding selection mode address books -- registering address labels from databases aging filter algeng hugtök -- orðasöfn 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 -- 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 auðveldað -- aðgengi;eiginleikar Collabora Office auðveldað aðgengi -- almennir flýtilyklar axes in charts background -- area background -- pattern backgrounds -- defining colors/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 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)breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta breyta -- endurheimta brochures -- printing several bullet lists -- formatting options bullets -- replacing bullets -- turning off bullets -- paragraphs business cards -- creating and synchronizing business cards -- using templates button bars, see toolbars buttons -- big/small buttons -- form functions buttons -- adding push buttons buttons -- editing hyperlink buttons buttons -- toolbars bygginganúmer Collabora Office bókamerki -- Hjálp 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 contents (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 -- 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 centered text centimeters certificate path certificates changes -- accepting or rejecting changes -- navigating changes -- protecting changes -- recording changes -- review function changes -- showing changes -- comparing to original changing -- DDE links changing -- document titles changing -- file associations in Setup program changing -- icon sizes changing -- page margins changing -- page size changing -- work 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 -- coloring 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 charcoal sketches filter charts -- arranging within stacks charts -- bars with textures charts -- colors 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 -- pasting clipboard -- selection clipboard clipboard -- pasting formatted/unformatted text clone formatting closing -- toolbars collaboration color selector colors -- Collabora Office colors colors -- HLC colors colors -- appearance colors -- applications colors -- backgrounds colors -- default colors colors -- fonts colors -- freieFarbe colors -- grid lines and cells (Calc)colors -- ignored text color colors -- not printing colors -- printing in grayscale colors -- web colors -- adding colors -- charts colors -- delete colors -- in document themes colors -- loading lists colors -- palette colors -- restriction (Calc)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 -- 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 comparison -- automatic comparison -- by character comparison -- by word comparisons -- document versions comparisons -- operators in standard filter dialog 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 -- customizing 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 -- 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 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 custom -- classification levels custom dictionaries -- editing custom hyphens (Writer)custom quotes custom templates customizing -- Collabora Office customizing -- events customizing -- toolbars customizing -- context menus customizing -- keyboard customizing -- menus customizing -- round corners dBase -- command line filter options dashes data -- forms and subforms data -- read-only 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 dialogs 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 -- 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 colors -- 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 -- 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 -- 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 -- 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 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 endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyta endurheimta -- breyting endurtaka skipun engineering notation, formats entering groups entering text from right to left equal sign, see also operators equations in formula editor even/odd pages -- printing events -- controls events -- customizing 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 extending selection mode extensions -- file formats extensions -- Extension Manager external tool -- edit image eyðublöð -- HTML síur eyðublöð -- röðun gagna faster printing faxes -- fax programs/fax printers under UNIX faxes -- sending faxes -- configuring Collabora Office faxes -- selecting a fax machine faxes -- wizards ferlar -- breyta punktum 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 colors 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 fjölvar -- í MS Office skjölum flip -- horizontally flip -- vertically floating frames in HTML documents floating toolbars flýtilyklar -- Collabora Office accessibility 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 -- 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 -- changing in templates fonts -- colors 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 -- maximizing 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 -- 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 -- browsing forms -- data forms -- events forms -- filtering data forms -- grouping controls forms -- opening in design mode forms -- properties forms -- subforms forms -- Navigator forms -- XForms forms -- add database field forms -- creating forms -- database events forms -- finding records 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 formulas -- new formulas -- starting formula editor 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 freeform lines -- draw functions full screen view full-width -- definition fullwidth -- definition get method for form transmissions getting support glossaries -- Internet 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 grayscale printing greinasýn hjálpar 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 gögn -- röðun í eyðublöðum 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 hjálparábendingar -- ítarlegar hjálparábendingar í Hjálp hlutir -- skilgreining horizontal scrollbars (Writer)hotspots -- properties hotspots -- adding to images hybrid PDF hyperlinks -- character formats 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 höfundarréttur Collabora Office 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 -- in characters kerning -- Asian texts keyboard -- general commands keyboard -- assigning/editing shortcut keys keyboard -- removing numbering keys -- adding push buttons klippa klippa klippispjald -- klippa klippispjald -- klippa labels -- creating and synchronizing 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 leitarvélar -- skilgreining 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 lines -- draw functions lines -- drawing in text lines -- removing automatic lines lines -- defining ends lines of text -- alignment links -- character formats 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 -- colors/gradients/hatchings loading -- large spreadsheet files locale settings lock files -- Collabora Office lock files -- Microsoft Office locked documents lowercase letters -- font effects línur -- breyta punktum línustílar -- skilgreining macro -- select macro to run macro recording -- limitations macros -- assigning to events in forms macros -- interrupting macros -- recording macros -- organizing macros -- security levels macros -- security warning dialog 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 -- customizing 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 organization in XForms native numeral navigating -- in documents navigator -- rename new databases new documents new lines in cells 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 -- displaying in spreadsheets objects -- displaying in text documents objects -- inserting OLE objects objects -- inserting from Gallery objects -- naming 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 -- dialog settings opening -- documents from other formats opening -- documents opening -- files, with placeholders opening -- several files opening -- CMIS remote file 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 opna -- Microsoft Office skrár 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 organizing -- styles organizing -- macros and scripts organizing -- namespaces in XForms original size -- printing in Collabora Office Math original size -- restoring after cropping orðaskilgreiningar -- almenn atriði orðasöfn -- algeng hugtök 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 -- maximizing 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 can symbol pair kerning palette -- document colors 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 work directory paths -- defaults paths -- template files pattern -- area pattern -- background patterns for objects percentages, formats personal data -- cursor position personal data input pick color 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 posterizing 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 -- colors in grayscale 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 -- formulas 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 recognizing URLs automatically recording -- changes recording -- macros records -- inserting comments records -- protecting records -- saving records -- searching in databases rectangle drawing rectangles with round corners recursions in spreadsheets redaction 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 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 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 -- 3D 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 röðun -- gögn í eyðublöðum 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 -- dialog settings saving -- documents in other formats saving -- documents saving -- options saving -- documents, automatically 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 organization scrollbars -- displaying (Calc)scrollbars -- horizontal and vertical (Writer)search -- Help index search commands search criteria for database functions in cells 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 dialogs 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 -- 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 -- 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 skilgreina -- línustíl slanting draw objects slide -- save background image slide -- set background image slide background image -- save slide background image -- set slóð (URL) -- skilgreining 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 snið -- skilgreining soft hyphens (Writer)soft hyphens -- inserting solarization filter sort lists -- copying to in Calc 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 stafþjöppun -- skilgreining standard filters -- comparison operators standard filters -- databases standard printer under UNIX start center start parameters 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 stöðluð stika af/á stöðustika af/á subforms -- creating subforms -- description submitting forms suffixes in file formats support on the Web synchronizing -- 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 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 tenglar -- skilgreining tenglar -- skilgreining terminology -- Internet glossary testing XML filters text -- Asian layout text -- Fontwork icons text -- alignment text -- animating text -- bold text -- coloring text -- copying by drag and drop text -- drawing pictures text -- font effects 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 colors 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 -- 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 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 -- adding buttons toolbars -- docking/undocking toolbars -- locking/unlocking toolbars -- viewing/closing tooltips -- help tooltips -- in scroll bars traditional Chinese -- conversion to simplified Chinese translation -- automatic translation -- server settings transparency -- areas transparency -- off for faster printing triangle drawing typefaces -- formats typography -- Asian tög -- skilgreining underlining -- AutoFormat function underlining -- text underlining -- using _ when typing undocking windows undoing -- direct formatting 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 verkfærastika verkfærastikur -- Eyðublaðaleiðsagnarstika version management version numbers of documents 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 virkja -- ítarlegar hjálparábendingar vista -- Microsoft Office skráasnið vísbendingar -- ítarlegar hjálparábendingar warnings -- security watermarks web documents -- XForms windows -- docking definition windows -- hiding/showing/docking windows -- docking 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 ítarlegar hjálparábendingar í Hjálp útgáfur -- Collabora Office

Turning off Bullets and Numbering for Individual Paragraphs

Bullets and Numbering of paragraphs is supported only in Writer, Impress and Draw.

For the current paragraph or selected paragraphs you can switch off the automatic numbering or listing. Click the No List icon in the Formatting bar. The list indenting is also removed.

No List icon

If the cursor is located within a numbered or bulleted list, you can turn off automatic numbers or bullets for the current paragraph or selected paragraphs by clicking the Toggle Unordered List icon on the Text Formatting bar.

Toggle Unordered List icon

To remove a number or bullet from a paragraph while preserving the list indenting:

Place the cursor at the beginning of a paragraph in a list and press the Backspace key.
The numbering of the paragraph disappears and is removed from the numbering sequence. Numbering resumes in the following paragraph.

Press Shift+Backspace at the beginning of a list paragraph to return the number or bullet.

Press the Enter key in an empty numbered paragraph to stop the numbering.

Tengt efni

Format - Bullets and Numbering

Numbering and Paragraph Styles

Adding Numbering

Combining Ordered Lists

Notkun skýringatexta

Defining Number Ranges

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/guide/numbering_stop.xhp

Title is: Turning off Bullets and Numbering for Individual Paragraphs