Collabora Office 6.2 Help

Module

Language

Contents

Macros and Scripting

Spreadsheets (Calc)
- General Information and User Interface Usage
- Command and Menu Reference
  - Menus
    - Menus
    - File
    - Edit
    - View
    - Insert
    - Format
    - Sheet
    - Data
    - Tools
    - Window
    - Help
  - Toolbars
- Functions Types and Operators
- Loading, Saving, Importing, and Exporting
- Formatting
- Filtering and Sorting
- Printing
- Data Ranges
- Pivot Table
- Pivot Chart
- Scenarios
  - Using Scenarios
- References
- Viewing, Selecting, Copying
- Formulas and Calculations
- Protection
  - Protecting Cells from Changes
  - Unprotecting Cells
- Miscellaneous

Charts and Diagrams
- General Information

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

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

Database Functionality (Base)
- General Information

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

Formulas (Math)
- General Information and User Interface Usage
- Command and Menu Reference
  - Menus
  - Toolbars
- Working with Formulas

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

HTML Documents (Writer Web)

Index 🔎︎

⇤
←
1
2
3
4
5
6
→
⇥

send -- outline to clipboardoutline -- outline to clipboard clipboard -- outline to clipboard searching -- repeating a search sections -- inserting sections by DDE DDE -- command for inserting sections bookmarks -- inserting inserting -- envelopes letters -- inserting envelopes envelopes user-defined fields, restriction tags -- in Collabora Office Writer Collabora Office Writer -- special HTML tags HTML -- special tags for fields fields -- HTML import and export time fields -- HTML date fields -- HTML DocInformation fields logical expressions formulating conditions conditions -- in fields and sections fields -- defining conditions sections -- defining conditions variables -- in conditions user data -- in conditions databases -- in conditions hiding -- database fields fields -- editing edit -- fields editing -- concordance files concordance files -- definition moving -- objects and frames objects -- moving and resizing with keyboard resizing -- objects and frames, by keyboard databases -- exchanging address books -- exchanging exchanging databases replacing -- databases text flow -- at breaks paragraphs -- keeping together at breaks protecting -- text flow widows orphans block protect, see also widows or orphans first letters as large capital letters capital letters -- starting paragraphs drop caps insertion text grid for Asian layout resizing -- aspect ratio aspect ratio -- resizing objects objects -- defining hyperlinks frames -- defining hyperlinks pictures -- defining hyperlinks hyperlinks -- for objects tables -- positioning tables -- inserting text before tables -- editing with the keyboard tables -- text flow around text tables text flow -- around text tables columns -- breaks in text tables row breaks in text tables tables -- allowing page breaks page breaks -- tables splitting tables -- row breaks styles -- categories character styles -- style categories paragraph styles -- style categories frames -- styles page styles -- style categories numbering -- style categories styles -- conditional conditional styles Styles window -- applying styles styles -- previews previews -- styles AutoCorrect function -- text documents tables -- AutoFormat function styles -- table styles AutoFormat function for tables automatic heading formatting AutoCorrect function -- headings headings -- automatic separator lines -- AutoCorrect function tables -- splitting splitting tables -- at cursor position dividing tables tables -- merging merging -- tables converting -- text, into tables text -- converting to tables tables -- converting to text tables -- sorting rows sorting -- paragraphs/table rows text -- sorting paragraphs lines of text -- sorting paragraphs sorting -- paragraphs in special languages Asian languages -- sorting paragraphs/table rows updating -- text documents digital signature -- add signature line signature line -- adding digital signature -- sign signature line signature line -- signing page -- title page title pages -- first page style title pages -- modifying title pages -- inserting watermark -- text documents watermark -- page background page background -- watermark frames -- unlinking unlinking frames tables -- inserting rows rows -- inserting in tables, using icon tables -- inserting columns in columns -- inserting in tables previews -- book preview book previews operators -- in formulas statistical functions trigonometric functions pages -- number of variables -- document properties arithmetical operators in formulas time fields -- inserting fields -- inserting time subject fields fields -- subject graphics -- do not show images -- do not show pictures -- do not show direct cursor -- restriction shortcut keys -- in text documents text documents -- shortcut keys in headings -- switching levels by keyboard paragraphs -- moving by keyboard tab stops -- before headings headings -- starting with tab stops removing -- cell protection in text documents objects -- anchoring options positioning -- objects (guide)anchors -- options frames -- anchoring options pictures -- anchoring options centering -- images on HTML pages headings -- rearranging rearranging headings moving -- headings demoting heading levels promoting heading levels Navigator -- heading levels and chapters arranging -- headings outlines -- arranging chapters numbering -- lists, while typing bullet lists -- creating while typing lists -- automatic numbering numbers -- lists automatic bullets/numbers -- AutoCorrect function bullets -- using automatically paragraphs -- automatic numbering turning off automatic correction text -- turning off automatic correction uppercase -- changing to lowercase capital letters -- changing to small letters after periods quotation marks -- changing automatically words -- automatic replacement on/off lines -- automatic drawing on/off underlining -- quick borders -- automatic drawing on/off automatic changes on/off changes -- automatic AutoCorrect function -- turning off spellcheck -- Automatic Spell Checking on/off automatic spellcheck checking spelling -- while typing words -- disabling spellcheck AutoCorrect function -- adding exceptions exceptions -- AutoCorrect function abbreviations capital letters -- avoiding after specific abbreviations AutoText networks and AutoText directories lists -- AutoText shortcuts printing -- AutoText shortcuts inserting -- text blocks text blocks blocks of text backgrounds -- text objects words -- backgrounds paragraphs -- backgrounds text -- backgrounds tables -- backgrounds cells -- backgrounds backgrounds -- selecting characters -- defining borders borders -- for characters frames -- around characters defining -- character borders objects -- defining borders borders -- for objects frames -- around objects charts -- borders pictures -- borders OLE objects -- borders defining -- object borders pages -- defining borders borders -- for pages frames -- around pages defining -- page borders borders -- for text tables cells -- borders in text tables defining -- table borders in Writer frames -- around text tables tables -- defining borders calculating -- in text formulas -- calculating in text references -- in Writer tables pasting -- results of formulas clipboard -- calculating in text formulas -- pasting results in text documents calculating -- sums in text tables totals in text tables tables -- calculating sums cells -- calculating sums table cells -- calculating sums sums of table cell series formulas -- complex formulas in text calculating -- formulas/mean values calculating -- in text tables tables -- performing calculations in calculating -- across multiple text tables tables -- calculating across inserting -- captions captions -- inserting and editing editing -- captions objects -- captioning tables -- labeling frames -- labeling charts -- labeling text frames -- labeling draw objects -- inserting captions legends, see also captions captions -- adding chapter numbers objects -- captioning automatically numbering -- captions automatic numbering -- of objects chapter numbers in captions inserting -- chapter numbers in captions headers -- inserting footers -- inserting page styles -- changing from selection new page styles from selection outlines -- numbering chapters -- numbering deleting -- heading numbers chapter numbering headings -- numbering/paragraph styles numbering -- headings matching conditional text in fields if-then queries as fields conditional text -- setting up text -- conditional text defining -- conditions page counts conditional text -- page counts user-defined dictionaries -- removing words from custom dictionaries -- removing words from deleting -- words in user-defined dictionaries sections -- moving and copying moving -- text sections copying -- text sections pasting -- cut/copied text sections mouse -- moving and copying text page styles -- left and right pages blank pages with alternating page styles empty page with alternating page styles pages -- left and right pages formatting -- even/odd pages title pages -- page styles First Page page style Left Page page style right pages even/odd pages -- formatting fields -- converting into text converting -- fields, into text replacing -- fields, by text changing -- fields, into text fields -- updating/viewing updating -- fields Help tips -- fields properties -- fields disabling -- field highlighting changing -- field shadings viewing -- fields inserting -- date fields dates -- inserting date fields -- fixed/variable fixed dates variable dates text -- input fields fields -- input fields in text input fields in text inserting -- input fields fields -- user data user data -- querying conditions -- user data fields hiding -- text, from specific users text -- hiding from specific users, with conditions user variables in conditions/fields finding -- text/text formats/styles/objects replacing -- text and text formats styles -- finding searching, see also finding text formats -- finding formats -- finding and replacing searching -- formats objects -- finding by Navigator Asian languages -- search options pages -- continuation pages next page number in footers continuation pages page numbers -- continuation pages footers -- with page numbers pages -- numbers and count of page numbers -- footers numbering -- pages endnotes -- inserting and editing inserting -- footnotes/endnotes deleting -- footnotes editing -- footnotes/endnotes organizing -- footnotes footnotes -- inserting and editing spacing -- endnotes/footnotes endnotes -- spacing footnotes -- spacing borders -- for footnotes/endnotes lines -- footnotes/endnotes serial letters form letters mail merge letters -- creating form letters wizards -- form letters master documents -- properties subdocuments -- properties central documents subsidiary documents documents -- master documents and subdocuments styles -- master documents Navigator -- master documents master documents -- creating/editing/exporting subdocuments -- creating/editing/removing removing -- subdocuments indexes -- master documents headers -- about footers -- about HTML documents -- headers and footers headers -- defining for left and right pages footers -- defining for left and right pages page styles -- changing defining -- headers/footers mirrored page layout running titles in headers floating titles in headers headers -- chapter information chapter names in headers names -- chapter names in headers inserting -- lines under headers/above footers lines -- under headers/above footers headers -- formatting footers -- formatting shadows -- headers/footers borders -- for headers/footers text -- hiding sections -- hiding paragraphs -- hiding hiding -- text, with conditions variables -- for hiding text hidden text -- displaying displaying -- hidden text hyperlinks -- inserting from Navigator inserting -- hyperlinks from Navigator cross-references -- inserting with Navigator Navigator -- inserting hyperlinks hyphenation -- preventing for specific words words -- wrapping/not wrapping in text switching off -- hyphenation for specific words formatting -- indenting paragraphs indents -- in text paragraphs -- indents hanging indents in paragraphs right indents in paragraphs lines of text -- indents changing -- indents indexes -- editing or deleting entries tables of contents -- editing or deleting entries deleting -- entries of indexes/tables of contents editing -- table/index entries indexes -- editing/updating/deleting tables of contents -- editing and deleting updating -- indexes/tables of contents editing -- indexes/tables of contents deleting -- indexes/tables of contents indexes -- defining entries in tables of contents -- defining entries in entries -- defining in indexes/tables of contents indexes -- formatting editing -- index format tables of contents -- formatting entries -- in tables of contents, as hyperlinks tables of contents -- hyperlinks as entries hyperlinks -- in tables of contents and indexes formatting -- indexes and tables of contents concordance files -- indexes indexes -- alphabetical indexes alphabetical indexes indexes -- creating bibliographies databases -- creating bibliographies bibliographies entries -- bibliographies storing bibliographic information indexes -- multiple documents multiple documents -- indexes merging -- indexes master documents -- indexes tables of contents -- creating and updating updating -- tables of contents indexes -- creating user-defined indexes user-defined indexes tables -- start/end of document paragraphs -- inserting before/after tables inserting -- paragraphs before/after tables text -- inserting pictures in images -- inserting in text inserting -- pictures pictures -- inserting options pictures -- inserting by dialog inserting -- pictures, by dialog charts -- copying from Calc into Writer copying -- charts from Collabora Office Calc text documents -- inserting Calc charts text -- inserting pictures from Draw pictures -- inserting from Draw inserting -- from Gallery into text pictures -- inserting from Gallery into text replacing -- objects from Gallery inserting -- scanned images pictures -- scanning scanning pictures tab stops -- inserting in lists numbering -- changing the level of lists -- changing levels levels -- changing outline levels bullet lists -- changing levels lowering outline levels rising outline levels changing -- outline levels numbering -- combining merging -- numbered lists joining -- numbered lists lists -- combining numbered lists paragraphs -- numbering non-consecutive bookmarks -- positioning cursor jumping -- to bookmarks keyboard -- accessibility Collabora Office Writer accessibility -- Collabora Office Writer formatting styles -- importing styles -- importing from other files importing -- styles from other files loading -- styles from other files Collabora Office Writer -- instructions instructions -- Collabora Office Writer Navigator -- overview in texts hyperlinks -- jumping to objects -- quickly moving to, within text frames -- jumping to tables -- jumping to headings -- jumping to pages -- jumping to jumping -- to text elements overviews -- Navigator in text documents non-printing text text -- non-printable numbers -- automatic recognition in text tables tables -- number recognition dates -- formatting automatically in tables recognition -- numbers numbering -- quotations/similar items line numbers text -- line numbers paragraphs -- line numbers lines of text -- numbering numbering -- lines numbers -- line numbering marginal numbers on text pages numbering -- removing/interrupting bullet lists -- interrupting lists -- removing/interrupting numbering deleting -- numbers in lists interrupting numbered lists changing -- starting numbers in lists page breaks -- inserting and deleting inserting -- page breaks deleting -- page breaks pages -- inserting/deleting page breaks manual page breaks tables -- deleting page breaks before page styles -- backgrounds backgrounds -- different pages changing -- page backgrounds pages -- backgrounds page numbers -- inserting/defining/formatting page styles -- page numbering starting page numbers formatting -- page numbers defining -- starting page numbers inserting -- page numbers styles -- page numbers page styles -- orientation/scope page formats -- changing individual pages formatting -- changing individual pages portrait and landscape landscape and portrait printing -- portrait/landscape format orientation of pages paper orientation pages -- orientation sideways orientation of pages scope of page styles page styles -- creating and applying defining -- page styles styles -- for pages printing -- individual brochures booklet printing brochures -- printing individual printing -- previews previews -- print layouts print layout checks book view pages -- previews multi-page view of documents pages -- printing multiple on one sheet overviews -- printing multi-page view printing -- multiple pages per sheet reduced printing of multiple pages selecting -- paper trays paper tray selection ordering -- printing in reverse order printing -- reverse order indexes -- unprotecting tables of contents -- unprotecting tables -- protecting/unprotecting cells sections -- protecting/unprotecting unprotecting tables of contents and indexes protecting -- tables and sections cells -- protecting/unprotecting document -- protection from changes references -- inserting cross-references cross-references -- inserting and updating tables -- cross-referencing pictures -- cross-referencing objects -- cross-referencing OLE objects -- cross-referencing draw objects -- cross-referencing updating -- cross-references inserting -- cross-references references -- modifying cross-references cross-references -- modifying editing -- cross-references searching -- cross-references rows -- register-true text lines of text -- register-true pages -- register-true paragraphs -- register-true register-true -- pages and paragraphs spacing -- register-true text formatting -- register-true text hard returns in pasted text line breaks -- removing deleting -- line breaks copies -- removing line breaks paragraph marks -- removing formats -- resetting font attributes -- resetting fonts -- resetting resetting -- fonts direct formatting -- exiting formatting -- exiting direct formatting exiting -- direct formatting Navigator -- docking and resizing Styles window -- docking and resizing Gallery -- docking and resizing docking -- Navigator window resizing -- windows rulers -- using rulers horizontal rulers vertical rulers indents -- setting on rulers page margins on rulers table cells -- adjusting the width on rulers showing -- rulers hiding -- rulers adjusting page margins and cell widths wildcards, see regular expressions searching -- with wildcards regular expressions -- searching examples for regular expressions characters -- finding all invisible characters -- finding paragraph marks -- searching sections -- editing sections -- deleting deleting -- sections editing -- sections read-only sections protecting -- sections converting -- sections, into normal text hiding -- sections sections -- inserting inserting -- sections HTML documents -- inserting linked sections updating -- linked sections, manually links -- inserting sections multi-column text text -- multi-column columns -- on text pages text columns sections -- columns in/use of text documents -- publishing in HTML HTML documents -- creating from text documents homepage creation saving -- in HTML format text -- formatting bold while typing formatting -- bold, while typing keyboard -- bold formatting bold -- formatting while typing shortcut keys -- bold formatting smart tags AutoCorrect function -- smart tags options -- smart tags disabling -- smart tags installing -- smart tags spellcheck -- checking text documents manually checking spelling -- manually grammar checker fill format mode copying -- styles, by fill format mode brush for copying styles styles -- transferring formats -- copying and pasting text formats -- copying and pasting styles -- creating from selections drag and drop -- creating new styles copying -- styles, from selections Stylist, see Styles window styles -- updating from selections templates -- updating from selections Styles window -- updating from selections updating -- styles, from selections text -- subscript and superscript superscript text subscript text characters -- subscript and superscript cells -- merging/splitting tables -- merging cells cell merges splitting cells -- by menu command merging -- cells rows -- inserting/deleting in tables by keyboard columns -- inserting/deleting in tables by keyboard tables -- editing by keyboard keyboard -- adding or deleting rows/columns splitting cells -- by keyboard merging -- cells, by keyboard deleting -- rows/columns, by keyboard inserting -- rows/columns, by keyboard deleting -- tables or table contents tables -- deleting tables -- inserting text tables inserting -- tables in text DDE -- inserting tables OLE objects -- inserting tables in cells -- inserting from spreadsheets tables in spreadsheets -- inserting in text spreadsheets -- inserting tables from tables -- heading repetition after page breaks repeating -- table headings after page breaks headings -- repeating in tables multi-page tables selecting -- tables tables -- selecting columns -- selecting rows -- selecting cells -- enlarging and reducing in text tables table cells -- enlarging/reducing in text keyboard -- resizing rows/columns resizing -- rows and columns in text tables enlarging columns,cells and table rows reducing rows and columns in text tables tables -- resizing/juxtaposing juxtaposing tables heights of table rows widths of table columns rows -- resizing in tables columns -- resizing in tables column widths in tables table mode selection proportional distribution of tables relative distribution of table cells tables -- adapting the width by keyboard cells -- adapting the width by keyboard keyboard -- modifying the behavior of rows/columns behavior of rows/columns document templates templates -- creating document templates default templates -- defining/resetting defaults -- templates templates -- default templates text documents -- default templates formatting styles -- styles and templates styles -- styles and templates organizing -- templates (guide)templates -- organizing (guide)text animation effects -- text animation animations -- text characters -- uppercase or lowercase text -- uppercase or lowercase lowercase letters -- text uppercase -- formatting text capital letters -- changing to small letters changing -- cases of text initial capitals in titles small capitals (guide)text frames -- centering on pages centering -- text frames on pages title pages -- centering text on text -- cursor entering text with direct cursor direct cursor -- settings writing with direct cursor cursor -- direct cursor settings -- direct cursor text -- emphasizing emphasizing text text frames -- inserting/editing/linking editing -- text frames inserting -- text frames resizing -- text frames, by mouse scaling -- text frames, by mouse links -- text frames text flow -- from frame to frame frames -- linking printing -- hiding text frames from printing text -- navigating and selecting with keyboard navigating -- in text, with keyboard selecting -- text, with keyboard keyboard -- navigating and selecting in text text -- rotating rotating -- text sections -- inserting external content text documents -- merging links -- inserting text documents as inserting -- text documents hyphenation -- manual/automatic separation, see hyphenation automatic hyphenation in text manual hyphenation in text bullet lists -- turning on and off paragraphs -- bulleted bullets -- adding and editing formatting -- bullets removing -- bullets in text documents changing -- bulleting symbols numbering -- paragraphs, on and off paragraphs -- numbering on/off formatting -- numbered lists inserting -- numbering numbering -- manually/by styles manual numbering in text paragraph styles -- numbering thesaurus -- related words related words in thesaurus spelling in thesaurus dictionaries -- thesaurus lexicon, see thesaurus synonyms in thesaurus searching -- synonyms automatic word completion completion of words AutoCorrect function -- word completion word completion -- using/disabling disabling -- word completion switching off -- word completion deactivating -- word completion refusing word completions rejecting word completions settings -- word completion word completion -- settings text documents -- word completion settings weekdays -- automatically completing months -- automatically completing words -- counting in text number of words documents -- number of words/characters text -- number of words/characters characters -- counting number of characters counting words word counts text wrap around objects contour editor contour wrap text -- formatting around objects formatting -- contour wrap objects -- contour wrap wrapping text -- editing contours editors -- contour editor LibreLogo Logo Turtle graphics classification -- BAILS levels classification -- BAF category classification -- security levels classification -- document classification -- classification bar document -- classification classification -- displayed in user interface classification -- headers and footers classification -- watermark classification -- categories classification levels -- Internal use only classification levels -- Confidential classification levels -- General Business classification levels -- Non-Business custom -- classification levels classification levels -- customizing document classification -- pasting contents Classification toolbar -- displayNavigator -- for sheetsnavigating -- in spreadsheets displaying -- scenario names scenarios -- displaying names page styles -- headers page styles -- footers headers -- defining footers -- defining file names in headers/footers changing -- dates, automatically dates -- updating automatically automatic date updates filling -- selection lists selection lists -- filling cells fill range -- random numbers random rumbers -- fill range random rumbers -- distribution deleting -- cell contents cells -- deleting contents spreadsheets -- deleting cell contents cell contents -- deleting cells -- deleting cells columns -- deleting rows -- deleting spreadsheets -- deleting cells deleting -- cells/rows/columns spreadsheets -- deleting sheets -- deleting deleting -- spreadsheets spreadsheets -- moving spreadsheets -- copying moving -- spreadsheets copying -- spreadsheets spreadsheets -- deleting row breaks deleting -- manual row breaks row breaks -- deleting spreadsheets -- deleting column breaks deleting -- manual column breaks column breaks -- deleting spreadsheets -- displaying headers of columns/rows displaying -- headers of columns/rows spreadsheets -- value highlighting values -- highlighting highlighting -- values in sheets colors -- values formula bar -- spreadsheets spreadsheets -- formula bar spreadsheets -- inserting breaks in inserting -- breaks page breaks -- inserting in spreadsheets sheets -- inserting row breaks row breaks -- inserting inserting -- manual row breaks manual row breaks spreadsheets -- inserting column breaks column breaks -- inserting inserting -- manual column breaks manual column breaks spreadsheets -- inserting cells cells -- inserting inserting -- cells spreadsheets -- inserting rows rows -- inserting inserting -- rows spreadsheets -- inserting columns inserting -- columns columns -- inserting sheets -- creating inserting functions -- Function Wizard functions -- Function Wizard wizards -- functions functions -- listed by category categories of functions list of functions Function Wizard -- databases functions -- database functions databases -- functions in Collabora Office Calc DCOUNT function counting rows -- with numeric values DCOUNTA function records -- counting in Calc databases counting rows -- with numeric or alphanumeric values DGET function cell contents -- searching in Calc databases searching -- cell contents in Calc databases DMAX function maximum values in Calc databases searching -- maximum values in columns DMIN function minimum values in Calc databases searching -- minimum values in columns DAVERAGE function averages -- in Calc databases calculating -- averages in Calc databases DPRODUCT function multiplying -- cell contents in Calc databases DSTDEV function standard deviations in databases -- based on a sample DSTDEVP function standard deviations in databases -- based on populations DSUM function calculating -- sums in Calc databases sums -- cells in Calc databases DVAR function variances -- based on samples DVARP function variances -- based on populations date and time functions functions -- date & time Function Wizard -- date & time financial functions functions -- financial functions Function Wizard -- financial amortizations, see also depreciations AMORDEGRC function depreciations -- degressive amortizations AMORLINC function depreciations -- linear amortizations ACCRINT function accrued interests -- periodic payments ACCRINTM function accrued interests -- one-off payments RECEIVED function amount received for fixed-interest securities PV function present values calculating -- present values calculating -- depreciations SYD function depreciations -- arithmetic declining arithmetic declining depreciations DISC function allowances discounts DURATION_ADD function Microsoft Excel functions durations -- fixed interest securities annual net interest rates calculating -- annual net interest rates net annual interest rates EFFECTIVE function effective interest rates EFFECT_ADD function calculating -- arithmetic-degressive depreciations arithmetic-degressive depreciations depreciations -- arithmetic-degressive DDB function calculating -- geometric-degressive depreciations geometric-degressive depreciations depreciations -- geometric-degressive DB function IRR function calculating -- internal rates of return, regular payments internal rates of return -- regular payments calculating -- interests for unchanged amortization installments interests for unchanged amortization installments ISPMT function information functions Function Wizard -- information functions -- information functions INFO function CURRENT function FORMULA function formula cells -- displaying formulas in other cells displaying -- formulas at any position ISREF function references -- testing cell contents cell contents -- testing for references ISERR function error codes -- controlling ISERROR function recognizing -- general errors IFERROR function testing -- general errors ISFORMULA function recognizing formula cells formula cells -- recognizing ISEVEN function even integers ISEVEN_ADD function ISNONTEXT function cell contents -- no text ISBLANK function blank cell contents empty cells -- recognizing ISLOGICAL function number formats -- logical logical number formats ISNA function #N/A error -- recognizing IFNA function #N/A error -- testing ISTEXT function cell contents -- text ISODD function odd integers ISODD_ADD function ISNUMBER function cell contents -- numbers N function NA function #N/A error -- assigning to a cell TYPE function CELL function cell information information on cells logical functions Function Wizard -- logical functions -- logical functions AND function FALSE function IF function NOT function OR function TRUE function XOR function mathematical functions Function Wizard -- mathematical functions -- mathematical functions trigonometric functions ABS function absolute values values -- absolute ACOS function ACOSH function ACOT function ACOTH function ASIN function ASINH function ATAN function ATAN2 function ATANH function COS function COSH function COT function COTH function CSC function CSCH function DEGREES function converting -- radians, into degrees EXP function FACT function factorials -- numbers INT function numbers -- rounding down to next integer rounding -- down to next integer EVEN function numbers -- rounding up/down to even integers rounding -- up/down to even integers GCD function greatest common divisor GCD_EXCEL2003 function LCM function least common multiples lowest common multiples LCM_EXCEL2003 function COMBIN function number of combinations COMBINA function number of combinations with repetitions TRUNC function decimal places -- cutting off LN function natural logarithm LOG function logarithms LOG10 function base-10 logarithm CEILING function rounding -- up to multiples of significance CEILING.PRECISE function rounding -- up to multiples of significance CEILING.MATH function CEILING.XCL function ISO.CEILING function rounding -- up to multiples of significance PI function MULTINOMIAL function POWER function SERIESSUM function PRODUCT function numbers -- multiplying multiplying -- numbers SUMSQ function square number additions sums -- of square numbers MOD function remainders of divisions QUOTIENT function divisions RADIANS function converting -- degrees, into radians ROUND function ROUNDDOWN function ROUNDUP function SEC function SECH function SIN function SINH function SUM function adding -- numbers in cell ranges SUMIF function adding -- specified numbers TAN function TANH function AutoFilter function -- subtotals sums -- of filtered data filtered data -- sums SUBTOTAL function Euro -- converting EUROCONVERT function CONVERT_OOO function ODD function rounding -- up/down to nearest odd integer FLOOR.PRECISE function rounding -- down to nearest multiple of significance FLOOR function rounding -- down to nearest multiple of significance SIGN function algebraic signs MROUND function nearest multiple SQRT function square roots -- positive numbers SQRTPI function square roots -- products of Pi random numbers -- between limits RANDBETWEEN function RAND function random numbers -- between 0 and 1 matrices -- functions Function Wizard -- arrays array formulas inline array constants formulas -- arrays functions -- array functions editing -- array formulas copying -- array formulas adjusting array ranges calculating -- conditional calculations matrices -- calculations conditional calculations with arrays implicit array handling forced array handling MUNIT function FREQUENCY function MDETERM function determinants MINVERSE function inverse arrays MMULT function TRANSPOSE function LINEST function slopes, see also regression lines regression lines -- LINEST function standard errors -- array functions RSQ calculations LOGEST function SUMPRODUCT function scalar products dot products inner products SUMX2MY2 function SUMX2PY2 function SUMXMY2 function TREND function GROWTH function exponential trends in arrays statistics functions Function Wizard -- statistics functions -- statistics functions spreadsheets -- functions Function Wizard -- spreadsheets functions -- spreadsheets ADDRESS function AREAS function DDE function ERRORTYPE function INDEX function INDIRECT function COLUMN function COLUMNS function vertical search function VLOOKUP function sheet numbers -- looking up SHEET function number of sheets -- function SHEETS function MATCH function OFFSET function LOOKUP function STYLE function CHOOSE function HLOOKUP function ROW function ROWS function HYPERLINK function GETPIVOTDATA function text in cells -- functions functions -- text functions Function Wizard -- text ARABIC function ASC function BAHTTEXT function BASE function decimal system -- converting to binary system -- converting to hexadecimal system -- converting to CHAR function CLEAN function CODE function CONCATENATE function DECIMAL function DOLLAR function EXACT function FIND function FIXED function JIS function LEFT function LEFTB function LEN function LENB function LOWER function MID function MIDB function PROPER function REPLACE function REPT function RIGHT function RIGHTB function ROMAN function SEARCH function SUBSTITUTE function T function TEXT function TRIM function UNICHAR function UNICODE function UPPER function VALUE function add-ins -- functions functions -- add-in functions Function Wizard -- add-ins ISLEAPYEAR function leap year determination YEARS function number of years between two dates MONTHS function number of months between two dates ROT13 function encrypting text DAYSINYEAR function number of days -- in a specific year DAYSINMONTH function number of days -- in a specific month of a year WEEKS function number of weeks -- between two dates WEEKSINYEAR function number of weeks -- in a specific year programming -- add-ins shared libraries -- programming external DLL functions functions -- Collabora Office Calc add-in DLL add-ins -- for programming add-ins -- analysis functions analysis functions Bessel functions BIN2DEC function converting -- binary numbers, into decimal numbers BIN2HEX function converting -- binary numbers, into hexadecimal numbers BIN2OCT function converting -- binary numbers, into octal numbers DELTA function recognizing -- equal numbers DEC2BIN function converting -- decimal numbers, into binary numbers DEC2HEX function converting -- decimal numbers, into hexadecimal numbers DEC2OCT function converting -- decimal numbers, into octal numbers ERF function Gaussian error integral ERF.PRECISE function Gaussian error integral ERFC function ERFC.PRECISE function GESTEP function numbers -- greater than or equal to HEX2BIN function converting -- hexadecimal numbers, into binary numbers HEX2DEC function converting -- hexadecimal numbers, into decimal numbers HEX2OCT function converting -- hexadecimal numbers, into octal numbers imaginary numbers in analysis functions complex numbers in analysis functions IMABS function IMAGINARY function IMPOWER function IMARGUMENT function IMDIV function IMEXP function IMCONJUGATE function IMLN function IMLOG10 function IMLOG2 function IMPRODUCT function IMREAL function IMSUB function IMSUM function IMSQRT function COMPLEX function OCT2BIN function converting -- octal numbers, into binary numbers OCT2DEC function converting -- octal numbers, into decimal numbers OCT2HEX function converting -- octal numbers, into hexadecimal numbers CONVERT function FACTDOUBLE function factorials -- numbers with increments of two ODDFPRICE function prices -- securities with irregular first interest date ODDFYIELD function ODDLPRICE function ODDLYIELD function calculating -- variable declining depreciations depreciations -- variable declining VDB function calculating -- internal rates of return, irregular payments internal rates of return -- irregular payments XIRR function XNPV function calculating -- rates of return RRI function calculating -- constant interest rates constant interest rates RATE function INTRATE function COUPNCD function COUPDAYS function COUPDAYSNC function COUPDAYBS function durations -- first interest payment until settlement date securities -- first interest payment until settlement date COUPPCD function dates -- interest date prior to settlement date COUPNUM function number of coupons IPMT function periodic amortizement rates calculating -- future values future values -- constant interest rates FV function FVSCHEDULE function future values -- varying interest rates calculating -- number of payment periods payment periods -- number of number of payment periods NPER function PPMT function calculating -- total amortizement rates total amortizement rates amortization installment repayment installment CUMPRINC function CUMPRINC_ADD function calculating -- accumulated interests accumulated interests CUMIPMT function CUMIPMT_ADD function PRICE function prices -- fixed interest securities sales values -- fixed interest securities PRICEDISC function prices -- non-interest-bearing securities sales values -- non-interest-bearing securities PRICEMAT function prices -- interest-bearing securities calculating -- durations durations -- calculating DURATION function calculating -- linear depreciations depreciations -- linear linear depreciations straight-line depreciations SLN function MDURATION function Macauley duration calculating -- net present values net present values NPV function calculating -- nominal interest rates nominal interest rates NOMINAL function NOMINAL_ADD function DOLLARFR function converting -- decimal fractions, into mixed decimal fractions fractions -- converting converting -- decimal fractions, into decimal numbers DOLLARDE function calculating -- modified internal rates of return modified internal rates of return MIRR function internal rates of return -- modified YIELD function rates of return -- securities yields, see also rates of return YIELDDISC function rates of return -- non-interest-bearing securities YIELDMAT function rates of return -- securities with interest paid on maturity calculating -- annuities annuities PMT function TBILLEQ function treasury bills -- annual return annual return on treasury bills TBILLPRICE function treasury bills -- prices prices -- treasury bills TBILLYIELD function treasury bills -- rates of return rates of return of treasury bills BITAND function BITOR function BITXOR function BITLSHIFT function BITRSHIFT function INTERCEPT function points of intersection intersections COUNT function numbers -- counting COUNTA function number of entries COUNTBLANK function counting -- empty cells empty cells -- counting COUNTIF function counting -- specified cells B function probabilities of samples with binomial distribution RSQ function determination coefficients regression analysis BETAINV function cumulative probability density function -- inverse of BETA.INV function cumulative probability density function -- inverse of BETADIST function cumulative probability density function -- calculating BETA.DIST function cumulative probability density function -- calculating BINOMDIST function BINOM.DIST function BINOM.INV function CHISQINV function CHISQ.INV function CHIINV function CHISQ.INV.RT function CHITEST function CHISQ.TEST function CHIDIST function CHISQ.DIST function CHISQ.DIST.RT function CHISQDIST function chi-square distribution EXPONDIST function exponential distributions EXPON.DIST function exponential distributions FINV function inverse F probability distribution F.INV function Values of the inverse left tail of the F distribution F.INV.RT function Values of the inverse right tail of the F distribution FISHER function FISHERINV function inverse of Fisher transformation FTEST function F.TEST function FDIST function F.DIST function F.DIST.RT function GAMMA function GAMMAINV function GAMMA.INV function GAMMALN function natural logarithm of Gamma function GAMMALN.PRECISE function natural logarithm of Gamma function GAMMADIST function GAMMA.DIST function GAUSS function normal distribution -- standard GEOMEAN function means -- geometric TRIMMEAN function means -- of data set without margin data ZTEST function Z.TEST function HARMEAN function means -- harmonic HYPGEOMDIST function sampling without replacement HYPGEOM.DIST function sampling without replacement LARGE function SMALL function CONFIDENCE function CONFIDENCE.T function CONFIDENCE.NORM function CORREL function coefficient of correlation COVAR function COVARIANCE.P function COVARIANCE.S function CRITBINOM function KURT function LOGINV function inverse of lognormal distribution LOGNORM.INV function inverse of lognormal distribution LOGNORMDIST function lognormal distribution LOGNORM.DIST function lognormal distribution MAX function MAXA function MEDIAN function MIN function MINA function AVEDEV function averages -- statistical functions AVERAGE function AVERAGEA function MODE function most common value MODE.SNGL function most common value MODE.MULT function most common value NEGBINOMDIST function negative binomial distribution NEGBINOM.DIST function negative binomial distribution NORMINV function normal distribution -- inverse of NORM.INV function normal distribution -- inverse of NORMDIST function density function NORM.DIST function density function PEARSON function PHI function POISSON function POISSON.DIST function PERCENTILE function PERCENTILE.EXC function PERCENTILE.INC function PERCENTRANK function PERCENTRANK.EXC function PERCENTRANK.INC function QUARTILE function QUARTILE.EXC function QUARTILE.INC function RANK function numbers -- determining ranks RANK.AVG function numbers -- determining ranks RANK.EQ function numbers -- determining ranks SKEW function regression lines -- FORECAST function extrapolations FORECAST function regression lines -- FORECAST.LINEAR function extrapolations FORECAST.LINEAR function STDEV function standard deviations in statistics -- based on a sample STDEVA function STDEVP function standard deviations in statistics -- based on a population STDEV.P function standard deviations in statistics -- based on a population STDEV.S function standard deviations in statistics -- based on a sample STDEVPA function STANDARDIZE function converting -- random variables, into normalized values NORMSINV function normal distribution -- inverse of standard NORM.S.INV function normal distribution -- inverse of standard NORMSDIST function normal distribution -- statistics NORM.S.DIST function normal distribution -- statistics SLOPE function STEYX function standard errors -- statistical functions DEVSQ function sums -- of squares of deviations TINV function inverse of t-distribution T.INV function one tailed inverse of t-distribution T.INV.2T function inverse of two tailed t-distribution TTEST function T.TEST function TDIST function t-distribution T.DIST function t-distribution T.DIST.2T function two tailed t-distribution T.DIST.RT function right tailed t-distribution VAR function variances VAR.S function variances VARA function VARP function VAR.P function VARPA function PERMUT function number of permutations PERMUTATIONA function PROB function WEIBULL function WEIBULL.DIST function formulas -- operators operators -- formula functions division sign, see also operators multiplication sign, see also operators minus sign, see also operators plus sign, see also operators text operators comparisons -- operators in Calc arithmetical operators reference operators text concatenation AND intersection operator cell ranges -- inserting named ranges inserting -- cell ranges pasting -- cell ranges cell ranges -- creating names automatically names -- for cell ranges sheets -- defining label ranges label ranges in sheets formula list window function list window inserting functions -- function list window cell attributes attributes -- cells formatting -- cells cells -- formatting dialog sheets -- optimal row heights rows -- optimal heights optimal row heights spreadsheets -- hiding functions hiding -- rows hiding -- columns hiding -- sheets sheets -- hiding columns -- hiding rows -- hiding spreadsheets -- showing columns showing -- columns showing -- rows spreadsheets -- optimal column widths columns -- optimal widths optimal column widths CTL -- right-to-left sheets sheets -- right-to-left right-to-left text -- spreadsheets worksheet names changing -- sheet names sheets -- renaming sheets -- displaying displaying -- sheets pages -- order when printing printing -- page order Stylist, see Styles window Styles window formats -- Styles window formatting -- Styles window paint can for applying styles conditional formatting -- conditions automatic hyphenation in spreadsheets hyphenation -- in spreadsheets syllables in spreadsheets cell links search searching -- links in cells traces -- precedents and dependents Formula Auditing,see Detective Detective cells -- tracing precedents formula cells -- tracing precedents cells -- removing precedents formula cells -- removing precedents cells -- tracing dependents cells -- removing dependents cells -- removing traces cells -- tracing errors tracing errors error tracing cells -- trace fill mode traces -- precedents for multiple cells cells -- invalid data data -- showing invalid data invalid data -- marking cells -- refreshing traces traces -- refreshing updating -- traces cells -- autorefreshing traces traces -- autorefreshing calculating -- auto calculating sheets recalculating -- auto calculating sheets AutoCalculate function in sheets correcting sheets automatically formulas -- AutoCalculate function cell contents -- AutoCalculate function recalculating -- all formulas in sheets formulas -- recalculating manually cell contents -- recalculating entering entries with AutoInput function capital letters -- AutoInput function databases -- selecting (Calc)sorting -- sort criteria for database ranges sorting -- options for database ranges sorting -- Asian languages Asian languages -- sorting phonebook sorting rules natural sort algorithm database ranges -- hiding AutoFilter subtotals -- sorting options sheets -- outlines outlines -- sheets hiding -- sheet details showing -- sheet details grouping -- cells sheets -- hiding details tables -- showing details pivot table function -- show details pivot table function -- drill down calculating -- pivot table hiding -- data fields, from calculations in pivot table display options in pivot table sorting -- options in pivot table data field options for pivot table database ranges -- refreshing selection lists -- validity data entry forms -- for spreadsheets data entry forms -- insert data in spreadsheets insert data -- data entry forms for spreadsheets spreadsheet -- form for inserting data data provider -- for spreadsheets AGGREGATE function AVERAGEIF function arithmetic mean -- satisfying condition AVERAGEIFS function arithmetic mean -- satisfying conditions COUNTIFS function counting row -- satisfying criteria counting column -- satisfying criteria colors -- numerical values colors -- calculating in spreadsheets COLOR function DATE function DATEDIF function DATEVALUE function DAY function DAYS function DAYS360 function EASTERSUNDAY function EDATE function EOMONTH function ERROR.TYPE function index of the Error type FORECAST.ETS.ADD function FORECAST.ETS.MULT function FORECAST.ETS.STAT.ADD function FORECAST.ETS.STAT.MULT function FORECAST.ETS.PI.ADD function FORECAST.ETS.PI.MULT function FORECAST.ETS.SEASONALITY function HOUR function IMCOT function cotangent -- complex number IMCOS function cosine -- complex number IMCOSH function hyperbolic cosine -- complex number IMCSC function cosecant -- complex number IMCSCH function hyperbolic cosecant -- complex number IMSEC function secant -- complex number IMSECH function hyperbolic secant -- complex number IMSIN function sine -- complex number IMSINH function hyperbolic sine -- complex number IMTAN function tangent -- complex number ISOWEEKNUM function MAXIFS function maximum -- satisfying conditions MINIFS function minimum -- satisfying conditions MINUTE function MONTH function NETWORKDAYS function NETWORKDAYS.INTL function WORKDAY.INTL function NUMBERVALUE function NOW function rawsubtract -- subtraction RAWSUBTRACT function REGEX function regular expressions -- extracting in spreadsheets regular expressions -- REGEX function ROUNDSIG Function SECOND function skewness -- population SKEWP function SUMIFS function sum -- satisfying conditions TIME function TIMEVALUE function TODAY function WEEKDAY function WEBSERVICE function FILTERXML function ENCODEURL function WEEKNUM function WEEKNUM_OOO function WEEKNUM_EXCEL2003 function WORKDAY function YEAR function YEARFRAC function Data Stream -- Live data stream goal seeking -- solver what if operations -- solver back-solving solver Analysis toolpack -- sampling sampling -- Analysis toolpack Data statistics -- sampling Analysis toolpack -- descriptive statistics descriptive statistics -- Analysis toolpack Data statistics -- descriptive statistics Analysis toolpack -- analysis of variance Analysis toolpack -- ANOVA analysis of variance -- Analysis toolpack ANOVA -- Analysis toolpack Data statistics -- analysis of variance Data statistics -- ANOVA Analysis toolpack -- correlation correlation -- Analysis toolpack Data statistics -- correlation Analysis toolpack -- covariance covariance -- Analysis toolpack Data statistics -- covariance Analysis toolpack -- exponential smoothing exponential smoothing -- Analysis toolpack Data statistics -- exponential smoothing Analysis toolpack -- moving average moving average -- Analysis toolpack Data statistics -- moving average Analysis toolpack -- t-test Analysis toolpack -- paired t-test t-test -- Analysis toolpack paired t-test -- Analysis toolpack Data statistics -- paired t-test Analysis toolpack -- F-test F-test -- Analysis toolpack Data statistics -- F-test Analysis toolpack -- Z-test Z-test -- Analysis toolpack Data statistics -- Z-test Analysis toolpack -- Chi-square test Chi-square test -- Analysis toolpack Data statistics -- Chi-square test Analysis toolpack -- regression analysis regression analysis -- Analysis toolpack Data statistics -- regression analysis text to columns XML Source -- load XML data in spreadsheets percentage calculations formula bar -- sheet area names sheet area names showing -- cell references cell references -- showing functions -- sum function icon formula bar -- sum function sum icon AutoSum button, see sum icon formula bar -- functions functions -- formula bar icon formula bar -- canceling inputs functions -- canceling input icon formula bar -- accepting inputs functions -- accepting input icon formulas -- status bar page views -- increasing scales increasing scales in page view zooming -- enlarging page views page views -- reducing scales zooming -- reducing page views inserting -- objects, toolbar icon inserting -- cells, toolbar icon spreadsheets -- shortcut keys in shortcut keys -- spreadsheets sheet ranges -- filling error codes -- list of ### error message invalid references -- error messages error messages -- invalid references #REF error message invalid names -- error messages #NAME error message empty cells -- handling of automatic addressing in tables natural language addressing formulas -- using row/column labels text in cells -- as addressing addressing -- automatic name recognition on/off row headers -- using in formulas column headers -- using in formulas columns -- finding labels automatically rows -- finding labels automatically recognizing -- column and row labels deactivating -- automatic changes tables -- deactivating automatic changes in AutoInput function on/off text in cells -- AutoInput function cells -- AutoInput function of text input support in spreadsheets changing -- input in cells AutoCorrect function -- cell contents cell input -- AutoInput function lowercase letters -- AutoInput function (in cells)capital letters -- AutoInput function (in cells)date formats -- avoiding conversion to number completion on/off text completion on/off word completion on/off filters, see also AutoFilter function AutoFilter function -- applying sheets -- filter values numbers -- filter sheets columns -- AutoFilter function drop-down menus in sheet columns database ranges -- AutoFilter function tables -- AutoFormat function defining -- AutoFormat function for tables AutoFormat function formats -- automatically formatting spreadsheets automatic formatting in spreadsheets sheets -- AutoFormat function spreadsheets -- backgrounds backgrounds -- cell ranges tables -- backgrounds cells -- backgrounds rows, see also cells columns, see also cells cells -- borders line arrangements with cells borders -- cells dates -- in cells times -- in cells cells -- date and time formats current date and time values series -- calculating calculating -- series linear series growth series date series powers of 2 calculations cells -- filling automatically automatic cell filling AutoFill function filling -- cells, automatically calculating -- time differences time differences spreadsheets -- calculating calculating -- spreadsheets formulas -- calculating values -- inserting in multiple cells inserting -- values cell ranges -- selecting for data entries areas, see also cell ranges protecting -- cells and sheets cells -- protecting cell protection -- enabling sheets -- protecting documents -- protecting cells -- hiding for printing changing -- sheet protection hiding -- formulas formulas -- hiding cell protection -- unprotecting protecting -- unprotecting cells unprotecting cells cells -- copying/deleting/formatting/moving rows -- visible and invisible copying -- visible cells only formatting -- visible cells only moving -- visible cells only deleting -- visible cells only invisible cells filters -- copying visible cells only hidden cells drag and drop -- referencing cells cells -- referencing by drag and drop references -- inserting by drag and drop inserting -- references, by drag and drop sheet references references -- to cells in other sheets/documents cells -- operating in another document documents -- references HTML -- in sheet cells references -- URL in cells cells -- Internet references URL -- in Calc formats -- assigning by formulas cell formats -- assigning by formulas STYLE function example cell styles -- assigning by formulas formulas -- assigning cell formats conditional formatting -- cells cells -- conditional formatting formatting -- conditional formatting styles -- conditional styles cell formats -- conditional random numbers -- examples cell styles -- copying copying -- cell styles tables -- copying cell styles negative numbers numbers -- highlighting negative numbers highlighting -- negative numbers colors -- negative numbers number formats -- colors for negative numbers consolidating data ranges -- combining combining -- cell ranges tables -- combining data -- merging cell ranges merging -- data ranges number series import data series import exporting -- tables as text importing -- tables as text delimited values and files comma separated files and values text file import and export csv files -- importing and exporting tables -- importing/exporting as text text documents -- importing to spreadsheets opening -- text csv files saving -- as text csv csv files -- formulas formulas -- importing/exporting as csv files exporting -- formulas as csv files importing -- csv files with formulas currency formats -- spreadsheets cells -- currency formats international currency formats formats -- currency formats in cells currencies -- default currencies defaults -- currency formats changing -- currency formats tables -- database ranges database ranges -- defining ranges -- defining database ranges defining -- database ranges cell ranges -- applying/removing filters filtering -- cell ranges/database ranges database ranges -- applying/removing filters removing -- cell range filters database ranges -- sorting sorting -- database ranges data -- sorting in databases pivot table function -- introduction DataPilot, see pivot table function pivot tables pivot table function -- calling up and applying pivot table function -- deleting tables deleting -- pivot tables pivot table function -- editing tables editing -- pivot tables pivot table function -- filtering tables filtering -- pivot tables grouping -- pivot tables pivot table function -- grouping table entries ungrouping entries in pivot tables pivot table function -- preventing data overwriting output ranges of pivot tables pivot table import pivot table function -- refreshing tables recalculating -- pivot tables updating -- pivot tables exporting -- spreadsheets to dBASE importing -- dBASE files dBASE import/export spreadsheets -- importing from/exporting to dBASE files tables in databases -- importing dBASE files theme selection for sheets layout -- spreadsheets cell styles -- selecting selecting -- formatting themes sheets -- formatting themes formats -- themes for sheets formatting -- themes for sheets copying -- values, to multiple sheets pasting -- values in multiple sheets data -- inserting in multiple sheets sheets -- simultaneous multiple filling filters -- applying/removing rows -- removing/redisplaying with filters removing -- filters searching, see also finding finding -- formulas/values/text/objects replacing -- cell contents formatting -- multiple cell texts text in cells -- formatting spreadsheets -- formatting backgrounds -- cells and pages borders -- cells and pages formatting -- spreadsheets numbers -- formatting options for selected cells cells -- number formats currencies -- formats numbers -- formatting decimals formats -- numbers in tables tables -- number formats defaults -- number formats in spreadsheets decimal places -- formatting numbers formatting -- numbers with decimals formatting -- adding/deleting decimal places number formats -- adding/deleting decimal places in cells deleting -- decimal places decimal places -- adding/deleting numbers -- user-defined formatting formatting -- user-defined numbers number formats -- millions format codes -- user-defined number formats formulas -- copying and pasting copying -- formulas pasting -- formulas formula bar -- input line input line in formula bar formulas -- inputting inserting -- formulas formulas -- displaying in cells values -- displaying in tables tables -- displaying formulas/values results display vs. formulas display displaying -- formulas instead of results formulas -- calculating with calculating -- with formulas examples -- formula calculation fractions -- entering numbers -- entering fractions inserting -- fractions goal seeking -- example equations in goal seek calculating -- variables in equations variables -- calculating equations examples -- goal seek HTML -- sheets sheets -- HTML saving -- sheets in HTML opening -- sheets in HTML zero values -- entering leading zeros numbers -- with leading zeros leading zeros integers with leading zeros cells -- changing text/number formats formats -- changing text/number text in cells -- changing to numbers converting -- text with leading zeros, into numbers accessibility -- Collabora Office Calc shortcuts shortcut keys -- Collabora Office Calc accessibility tables -- freezing title rows -- freezing during table split rows -- freezing columns -- freezing freezing rows or columns headers -- freezing during table split scrolling prevention in tables windows -- splitting tables -- splitting windows HowTos for Calc instructions -- Collabora Office Calc cells -- selecting marking cells selecting -- cells multiple cells selection selection modes in spreadsheets tables -- selecting ranges matrices -- entering matrix formulas formulas -- matrix formulas inserting -- matrix formulas drag and drop -- moving cells cells -- moving by drag and drop rows -- moving by drag and drop columns -- moving by drag and drop moving -- cells, rows and columns by drag and drop inserting -- cells, by drag and drop sheets -- showing multiple sheet tabs -- using views -- multiple sheets multiple operations what if operations -- two variables tables -- multiple operations in data tables -- multiple operations in cross-classified tables sheets -- inserting inserting -- sheets sheets -- selecting multiple appending sheets selecting -- multiple sheets multiple sheets calculating -- multiple sheets comments -- on cells cells -- comments remarks on cells formatting -- comments on cells viewing -- comments on cells displaying -- comments formats -- text as numbers time format conversion date formats -- conversion converting -- text, into numbers chart -- pivot chart pivot table -- pivot chart pivot chart -- creating pivot chart -- editing pivot chart -- update pivot chart -- deleting printing -- sheet details sheets -- printing details grids -- printing sheet grids formulas -- printing, instead of results comments -- printing charts -- printing sheet grids -- printing cells -- printing grids borders -- printing cells zero values -- printing null values -- printing draw objects -- printing printing -- sheet counts sheets -- printing sheet counts page breaks -- spreadsheet preview editing -- print ranges viewing -- print ranges previews -- page breaks for printing printing -- sheet selections sheets -- printing in landscape printing -- landscape landscape printing printing -- sheets on multiple pages sheets -- printing on multiple pages rows -- repeating when printing columns -- repeating when printing repeating -- columns/rows on printed pages title rows -- printing on all sheets headers -- printing on sheets footers -- printing on sheets printing -- rows/columns as table headings headings -- repeating rows/columns as exporting -- cells printing -- cells ranges -- print ranges PDF export of print ranges cell ranges -- printing cells -- print ranges print ranges clearing, see also deleting/removing defining -- print ranges extending print ranges deleting -- print ranges addressing -- relative and absolute references -- absolute/relative absolute addresses in spreadsheets relative addresses absolute references in spreadsheets relative references references -- to cells cells -- references renaming -- sheets sheet tabs -- renaming tables -- renaming names -- sheets numbers -- rounded off rounded off numbers exact numbers in Collabora Office Calc decimal places -- showing changing -- number of decimal places values -- rounded in calculations calculating -- rounded off values numbers -- decimal places precision as shown rounding precision spreadsheets -- values as shown heights of cells cell heights cell widths cells -- heights and widths widths of cells column widths rows -- heights columns -- widths changing -- row heights/column widths scenarios -- creating/editing/deleting opening -- scenarios selecting -- scenarios in Navigator filling -- customized lists sort lists -- applying defining -- sort lists geometric lists arithmetic lists series -- sort lists lists -- user-defined customized lists filters -- defining advanced filters advanced filters defining -- advanced filters database ranges -- advanced filters superscript text in cells subscript text in cells cells -- text super/sub characters -- superscript/subscript cells -- merging/unmerging tables -- merging cells cell merges unmerging cells splitting cells merging -- cells tables -- transposing transposing tables inverting tables swapping tables columns -- swap with rows rows -- swapping with columns tables -- rotating rotating -- tables row headers -- hiding column headers -- hiding tables -- views views -- tables grids -- hiding lines in sheets hiding -- headers/grid lines changing -- table views numbers -- entering as text text formats -- for numbers formats -- numbers as text cell formats -- text/numbers formatting -- numbers as text cells -- rotating text rotating -- text in cells text in cells -- writing vertically text in cells -- multi-line cells -- text breaks breaks in cells multi-line text in cells functions -- user-defined user-defined functions Basic IDE for user-defined functions IDE -- Basic IDE programming -- functions values -- limiting on input limits -- specifying value limits on input permitted cell contents data validity validity cells -- validity error messages -- defining for incorrect input actions in case of incorrect input Help tips -- defining text for cell input comments -- help text for cells cells -- defining input help macros -- running when incorrect input data -- validity check cells -- defining names names -- defining for cells values -- defining names constants definition variables -- defining names cell ranges -- defining names defining -- names for cell ranges formulas -- defining names addressing -- by defined names cell names -- defining/addressing references -- by defined names allowed cell names renaming -- cells HTML WebQuery ranges -- inserting in tables external data -- inserting tables -- inserting external data web pages -- importing data WebQuery filter inserting -- external data data sources -- external data years -- 2-digits dates -- 19xx/20xxMacromedia Flash exportexporting -- to Macromedia Flash format slides -- formatting formatting -- slides Navigator -- presentations presentations -- navigating deleting -- slides slides -- deleting layers -- deleting deleting -- layers fields -- editing editing -- fields fields -- formatting formatting -- fields normal view -- presentations outline view editing -- slide titles notes -- adding to slides slides -- inserting speaker notes speaker notes -- inserting master views normal view -- backgrounds backgrounds -- normal view views -- master slide view master slide view notes -- default formatting backgrounds -- notes speaker notes -- defaults headers and footers -- master slides layouts master slides layouts with headers and footers slides -- page numbers slides -- headers and footers footers -- slides headers and footers -- slides display qualities of presentations colors -- displaying presentations black and white display grayscale display inserting -- slides slides -- inserting snap lines, see also guides snap points -- inserting guides -- inserting magnetic lines in presentations rows -- inserting inserting -- rows guides -- editing editing -- guides and snap points snap points -- editing inserting -- columns columns -- inserting files -- inserting inserting -- files HTML -- inserting files inserting -- objects from files objects -- inserting from files slides -- inserting as links inserting -- slides as links backgrounds -- deleting unused expanding -- slides slides -- expanding summary slide fields -- in slides dates -- fixed fields -- dates (fixed)dates -- variable fields -- dates (variable)times -- fixed fields -- times (fixed)times -- variable fields -- times (variable)fields -- page numbers page number field slide numbers presentations -- numbering slides in authors fields -- authors fields -- file names Styles window -- graphics documents fill format mode -- styles changing -- slide layouts slide layouts renaming layers layers -- renaming dimension lines -- properties of connectors -- properties of objects -- in front of object command in front of object command objects -- behind object command behind object command reversing objects objects -- reversing slide transitions -- manual slide transitions -- sounds sounds -- on slide transitions sounds -- for effects effects -- sounds sounds -- formats presentations -- ordering of effects lists -- animations animations -- list of interactions -- objects in interactive presentations programs run by mouse click in presentations running macros/programs in presentations macros -- running in presentations presentations -- exiting by interaction exiting -- by clicking objects presentations -- settings for slide shows -- settings for presentations -- window / full screen multiple displays converting -- to bitmaps bitmaps -- converting to converting -- to metafile format (WMF)metafiles -- converting to converting -- to contours contours -- converting to combining -- undoing splitting -- combinations objects -- breaking connections breaking object connections Impress Remote -- remote connection dialog presentation -- remote control connections increasing sizes of views views -- display sizes decreasing sizes of views zooming -- in presentations views -- shift function hand icon for moving slides flipping around a flip line mirroring objects 3D rotation objects -- converting to slanting objects objects -- effects distorting objects shearing objects transparency -- of objects gradients -- transparent colors -- defining gradients interactively gradients -- defining colors circles -- of objects object bars -- editing glue points text -- toolbar floating text callouts -- inserting in presentations inserting -- callouts in presentations rectangles forms -- inserting geometric forms inserting -- rectangles toolbars -- ellipses ellipses -- toolbars inserting -- ellipses toolbars -- curves curves -- toolbar polygons -- inserting inserting -- polygons freeform lines -- drawing drawing -- freeform lines toolbars -- 3D objects 3D objects -- inserting inserting -- 3D objects cubes spheres cylinders cones pyramids torus shells half-spheres drawing -- 3D objects lines -- inserting arrows -- inserting inserting -- lines inserting -- arrows dimension lines -- drawing levels -- hiding hiding -- levels levels -- showing showing -- levels subpoints -- hiding hiding -- subpoints subpoints -- showing showing -- subpoints formatting -- slides headings views -- black and white black and white view rotation mode allowing -- effects effects -- preview interactions -- preview allowing -- interaction guides -- show snap lines icon showing -- guides text -- double-clicking to edit attributes -- objects with objects -- with attributes shortcut keys -- in presentations presentations -- shortcut keys Presenter Console shortcuts 3D rotation objects -- generating 3D objects -- generating 3D scenes -- creating converting -- to curves, polygons, 3D extrusion objects cross-fading -- creating cross-fades GIF images -- animating animated GIFs animations -- saving as GIFs exporting -- animations to GIF format objects -- moving along paths connecting -- paths and objects paths -- moving objects along motion paths deleting -- animation effects effects -- applying to/removing from objects animation effects animations -- editing custom animation cross-fading -- slides slide transitions -- applying effects animated slide transitions transition effects deleting -- slide transition effects effects -- animated slide transitions slides -- arranging presentations -- arranging slides changing -- order of slides arranging -- slides ordering -- slides backgrounds -- changing master slides -- changing backgrounds slides -- changing backgrounds zooming -- keyboard keyboard -- zooming footers -- master slides master slides -- headers and footers headers and footers -- master slides inserting -- headers/footers in all slides slide numbers on all slides page numbers on all slides date on all slides time and date on all slides glue points -- using exporting -- presentations to HTML saving -- as HTML presentations -- exporting to HTML HTML -- exporting from presentations importing -- presentations with HTML presentations -- importing HTML HTML -- importing into presentations text documents -- inserting in slides inserting -- text in presentations Impress slide show -- remote control remote control -- Bluetooth connection remote control -- controlling slide show Impress Remote -- controlling slide show Impress Remote -- settings Impress Remote -- connecting to computer Impress Remote -- using slide shows -- custom custom slide shows starting -- always with the current slide starting -- custom slide shows hiding -- slides showing -- hidden slides hidden pages -- showing accessibility -- Collabora Office Impress objects -- moving in layers layers -- moving objects moving -- between layers layers -- inserting and editing inserting -- layers changing -- layer properties layers -- working with locking layers hiding -- layers unlocking layers showing -- hidden layers selecting -- layers layers -- definition line styles -- loading lines -- about line ends arrows -- loading arrow styles styles -- arrow and line styles loading -- arrow and line styles lines -- drawing curves -- drawing control points definition corner points drawing -- lines curves -- editing editing -- curves splitting -- curves closing -- shapes deleting -- points converting -- points points -- adding/converting/deleting Collabora Office Impress instructions instructions -- Collabora Office Impress slide designs master slides -- designing backgrounds -- slides slides -- backgrounds master pages, see master slides objects -- moving in slides moving -- objects in slides connectors -- using flowcharts organization charts hot spots in flowcharts interactions -- hot spots copying -- slides slides -- copying between documents pages -- copying inserting -- slides from files pasting -- slides from other presentations colors -- loading lists gradients -- loading lists hatching -- loading lists loading -- colors/gradients/hatchings colors -- default colors colors -- LibreOffice colors LibreOffice colors colors -- Tango colors Tango colors colors -- web colors -- CMYK Photo Album Impress Photo Album Multimedia show -- Impress Photo Album Kiosk -- Impress Photo Album Slideshow -- Impress Photo Album Album -- Impress Photo Album presenter console -- slide show slide show -- presenter console fitting to pages -- individual slides pages -- fitting to printed pages printing -- fitting to paper printing -- presentations slides -- printing notes -- printing in presentations outlines -- printing presentations -- printing tiled printing of slides changing -- layout for handouts handout printing layout -- printing handouts presentations -- rehearse timings rehearse timings timings -- rehearse timings automatic slide changes -- rehearse timings recording -- display times for slides objects -- selecting selecting -- hidden objects covered objects underlying objects running slide shows showing -- slide shows slide shows -- starting presentations -- starting starting -- slide shows automatic slide shows slide transitions -- automatic automatic slide transition spreadsheets -- in presentations presentations -- inserting spreadsheets including spreadsheets text -- converting to curves characters -- converting to curves sign conversion to curves converting -- text to curves draw objects -- converting text to curves -- converting text to vectorizing bitmaps converting -- bitmaps to polygons bitmaps -- converting to vector graphics vector graphics -- converting bitmaps rulers -- in presentations origin of rulersshortcut keys -- in drawingsdrawings -- shortcut keys zooming -- shortcut keys drawings -- zoom function in arranging -- objects (guide)objects -- aligning distributing draw objects aligning -- draw objects colors -- defining user-defined colors custom colors combining -- draw objects merging -- draw objects connecting -- draw objects draw objects -- combining intersecting draw objects polygons -- intersecting/subtracting/merging subtracting polygons constructing shapes draw objects -- cross-fading two objects cross-fading -- two draw objects sectors of circles/ellipses segments of circles/ellipses circle segments ellipses -- segments drawing -- sectors and segments doubling draw objects draw objects -- duplicating duplicating draw objects multiplying draw objects eyedropper tool colors -- replacing replacing -- colors in bitmaps metafiles -- replacing colors bitmaps -- replacing colors GIF images -- replacing colors gradients -- applying and defining editing -- gradients defining -- gradients custom gradients transparency -- adjusting pictures -- inserting images -- inserting files -- inserting pictures inserting -- pictures grouping -- draw objects draw objects -- grouping draw objects -- connecting lines to connecting -- lines lines -- connecting objects areas -- from connected lines 3D objects -- assembling assembled objects in 3D combining -- 3D objects joining -- 3D objects accessibility -- Collabora Office Draw draw objects -- text entry mode text entry mode for draw objects Draw instructions instructions -- Collabora Office Draw Howtos for Draw rotating -- draw objects draw objects -- rotating pivot points of draw objects skewing draw objects text frames inserting -- text frames copying -- text from other documents pasting -- text from other documents legends -- drawingsqueries -- overview (Base)tables in databases -- printing queries (Base)printing -- queries (Base)queries -- printing (Base)queries -- missing elements (Base)views -- creating database views (Base)queries -- creating in design view (Base)designing -- queries (Base)design view -- queries/views (Base)joining -- tables (Base)tables in databases -- joining for queries (Base)queries -- joining tables (Base)tables in databases -- relations (Base)relations -- joining tables (Base)queries -- deleting table links (Base)criteria of query design (Base)queries -- formulating filter conditions (Base)filter conditions -- in queries (Base)parameters -- queries (Base)queries -- parameter queries (Base)SQL -- queries (Base)native SQL (Base)placeholders -- in SQL queries links -- relational databases (Base)inner joins (Base)joins in databases (Base)left joins (Base)right joins (Base)full joins (Base)forms -- general information (Base)forms -- designing (Base)relational databases (Base)primary keys -- inserting (Base)keys -- primary keys (Base)external keys (Base)relations -- creating and deleting (Base)relations -- properties (Base)key fields for relations (Base)cascading update (Base)queries -- copying (Base)tables in databases -- copying database tables (Base)primary keys -- defining access rights for database tables (Base)tables in databases -- access rights to (Base)databases -- drag and drop (Base)SQL -- executing SQL statements (Base)databases -- administration through SQL (Base)wizards -- databases (Base)Database Wizard (Base)databases -- formats (Base)MySQL databases (Base)dBASE -- database settings (Base)spreadsheets -- as databases (base)databases -- connecting (Base)Access databases (base)Microsoft Office -- Access databases (base)ADO databases (Base)MS ADO interface (Base)databases -- ADO (Base)JDBC -- databases (Base)databases -- JDBC (Base)LDAP server -- address books (Base)address books -- LDAP server (Base)data sources -- LDAP server (Base)ODBC -- database (Base)databases -- ODBC (Base)Oracle databases (base)tables in databases -- importing text formats (Base)text databases (Base)databases -- main page (Base)Collabora Office Base data sources data sources -- Collabora Office Base wizards -- macros (Base)Macro Wizard (Base)macros -- attaching new (Base)migrating macros (Base)insert fields -- in report design add fields -- in report design report design -- add fields to report Report Builder Oracle Report Builder formulas in reports -- editing functions in reports -- editing wizards -- database tables (Base)Table Wizard (Base)markers -- nextplaceholders -- position of next markers -- definition markers -- previous placeholders -- previous marker error search -- next error finding -- errors in Collabora Office Math error search -- previous error zooming in on formula display formulas -- increasing size of display views -- zooming out Collabora Office Math formula display sizes formulas -- zooming out zooming out on formula display views -- maximum size maximum formula size formulas -- maximum size updating formula view formula view -- updating changes -- accepting automatically selection options in formulas formulas -- selections elements -- in Math unary operators binary operators operators -- unary and binary plus signs plus/minus signs minus/plus signs multiplication signs NOT operator AND operator logical operators Boolean operators OR operator concatenating math symbols addition signs subtraction signs minus signs slash division sign backslash division sign indexes -- adding to formulas powers division signs user-defined operators -- unary and binary relations -- in Collabora Office Math Collabora Office Math -- relations equal sign inequation unequal sign identical to relation congruent relation right angled relations orthogonal relations divides relation does not divide relation less than relations approximately equal to relation parallel relation less than or equal to signs greater than or equal to signs proportional to relation similar to relations toward relation logic symbols double arrow symbols much greater than relation considerably greater than relation greater than relations much less than relation considerably less than relation defined as relation correspondence -- picture by picture by correspondence image of relation correspondence -- original by original by correspondence precedes relation not precedes relation succeeds relation not succeeds relation precedes or equal relation succeeds or equal relation precedes or equivalent relation succeeds or equivalent relation operators -- general upper limits limits -- in Collabora Office Math product coproduct lower limits curve integrals user-defined operators -- general integrals -- signs summation functions -- in Collabora Office Math natural exponential functions natural logarithms exponential functions logarithms variables -- with right exponents exponents -- variables with right trigonometrical functions sine function cosine function cotangent function hyperbolic sine function square roots hyperbolic cosine function hyperbolic tangent function hyperbolic cotangent function roots arc sine function arc cosine function arc cotangent function absolute values area hyperbolic cosine function area hyperbolic tangent function area hyperbolic cotangent function factorial values -- absolute tangent function brackets -- in Collabora Office Math brackets -- round (Math)parentheses (Math)brackets -- square (Math)brackets -- double square (Math)braces in Collabora Office Math brackets -- angle (Math)brackets -- operator (Math)brackets -- angle with operator brackets -- group grouping brackets round brackets square brackets double square brackets -- scalable scalable braces scalable round brackets scalable lines with ceiling vertical bars brackets -- scalable operator brackets floor brackets lines -- with edges ceiling brackets -- lines with lines -- scalable ceiling brackets -- scalable lines with brackets -- single, without group function single brackets without group function brackets -- widowed widowed brackets orphaned brackets attributes -- in Collabora Office Math formulas -- attributes in accents -- in Collabora Office Math attributes -- accents vector arrows as attributes tilde as attribute circumflex attribute bold attribute italic attribute in Collabora Office Math resizing -- fonts scaling -- fonts attributes -- changing fonts changing -- fonts attributes -- colored characters colored characters attributes -- changing defaults circle attribute double dot attribute dot attribute line through attribute line above attribute reversed circumflex attribute overline attribute wide vector arrow attribute wide tilde attribute wide circumflex attribute underline attribute triple dot attribute transparent character as attribute formatting -- in Collabora Office Math Collabora Office Math -- formatting superscripts binomials vertical elements lines -- inserting in formulas subscripts stacks vertical arrangement of elements small gaps alignment -- left (Math)left-justified alignment (Math)alignment -- horizontally centered (Math)centered horizontally -- alignment (Math)alignment -- right (Math)right-justified alignment in Collabora Office Math matrices -- arranging spaces in formulas gaps in formulas inserting -- gaps arranging -- matrices formulas -- aligning aligning formulas set operations in Collabora OfficeMath sets of numbers included in set operator not included in set operator owns command includes set operator empty set intersection of sets union of sets difference set operator quotient set cardinal numbers subset set operators superset set operators not subset set operators not superset set operators natural numbers whole numbers real numbers complex numbers -- set rational numbers examples -- Collabora Office Math formulas Collabora Office Math -- examples formulas -- examples font sizes -- example sum range example examples -- integral range of integral example integrals -- example brackets and grouping in Collabora Office Math grouping and brackets in Collabora Office Math indexes and exponents in Collabora Office Math exponents and indexes in Collabora Office Math attributes -- additional information scaling -- in Collabora Office Math Collabora Office Math -- reference list formulas -- reference tables reference tables -- formulas operators -- in Math unary operators -- list of binary operators -- list of relations operators -- list of set operators -- list of functions operators -- list of operators -- list of attributes -- list of formulas -- in color colors -- in formulas other operators -- list of brackets -- reference list formatting -- reference list (Math)mathematical symbols -- other real part of complex numbers symbols -- for complex numbers partial differentiation symbol infinity symbol Nabla operator there exists symbol there does not exist symbol existence quantor symbol for all symbol universal quantifier symbol h-bar symbol lambda-bar symbol imaginary part of a complex number complex numbers -- symbols weierstrass p symbol left arrow symbol right arrow symbol up arrow symbol down arrow symbol arrows -- symbols in Collabora Office Math center dots symbol axis-ellipsis vertical dots symbol diagonal upward dots -- symbol diagonal downward dots -- symbol epsilon -- back back epsilon symbol placeholders -- inserting in formulas ellipsis symbols fonts -- in Collabora Office Math formula fonts -- defining defining -- formula fonts font sizes -- in Collabora Office Math sizes -- of fonts in Collabora Office Math spacing -- formula elements formulas -- element spacing aligning -- multi-line formulas multi-line formulas -- aligning text mode in Collabora Office Math formulas -- fit to text symbols -- entering in Collabora Office Math Collabora Office Math -- entering symbols in catalog for mathematical symbols mathematical symbols -- catalog Greek symbols in formulas formulas -- entering symbols in new symbols in Collabora Office Math symbols -- adding in Collabora Office Math importing -- Collabora Office Math formulas MathML -- import from file MathML -- import via clipboard importing -- MathML formula cursor in Collabora Office Math cursor -- in Collabora Office Math shortcut keys -- in formulas aligning -- characters in Collabora Office Math formula parts -- manually aligning attributes -- changing in Collabora Office Math font attributes -- changing defaults formatting -- changing default attributes defaults -- changing default formatting changing -- default formatting brackets -- merging formula parts formula parts -- merging fractions in formulas merging -- formula parts comments -- entering in Collabora Office Math inserting -- comments in Collabora Office Math accessibility -- Collabora Office Math shortcuts limits -- in sums/integrals integral limits Collabora Office Math -- general instructions instructions -- Collabora Office Math Equation Editor, see Collabora Office Math line breaks -- in formulas formulas -- line breaks wrapping text -- in formulas brackets -- inserting in Collabora Office Math inserting -- brackets distances between brackets text strings -- entering in Collabora Office Math direct text -- entering in Collabora Office Math inserting -- text in Collabora Office Mathchart legends -- hidinghiding -- chart legends data labels in charts labels -- for charts charts -- data labels data values in charts chart legends -- showing icons with labels axes -- showing axes in charts charts -- showing axes X axes -- showing Y axes -- showing Z axes -- showing axes -- better scaling secondary axes in charts calculating -- regression curves regression curves in charts trend lines in charts mean value lines in charts aligning -- 2D charts charts -- aligning pie charts -- options axes -- inserting grids grids -- inserting in charts objects -- properties of charts charts -- properties properties -- charts titles -- formatting charts formatting -- chart titles editing -- titles aligning -- titles in charts titles -- alignment (charts)axes -- formatting Y axes -- formatting scaling -- axes logarithmic scaling along axes charts -- scaling axes X axes -- scaling Y axes -- scaling positioning -- axes charts -- positioning axes X axes -- positioning Y axes -- positioning axes -- interval marks grids -- formatting axes axes -- formatting grids X axes -- grid formatting Y axes -- grid formatting Z axes -- grid formatting charts -- formatting walls formatting -- chart walls charts -- formatting floors formatting -- chart floors charts -- formatting areas formatting -- chart areas curves -- properties in line charts/XY charts properties -- smooth lines in line charts/XY charts curves -- properties in line charts/XY charts properties -- stepped lines in line charts/XY charts 3D charts charts -- 3D views illumination -- 3D charts area charts chart types -- area bubble charts chart types -- bubble column charts bar charts chart types -- column and bar column and line charts chart types -- column and line combination charts line charts chart types -- line net charts chart types -- net radar charts, see net charts donut charts pie charts -- types chart types -- pie/donut stock charts chart types -- stock data sources -- setting for stock charts scatter charts XY charts chart types -- XY (scatter)error indicators in charts error bars in charts averages in charts statistics in charts variances in charts standard deviation in charts charts -- choosing chart types data ranges in charts order of chart data data series text scaling in charts scaling -- text in charts charts -- scaling text reorganizing charts charts -- reorganizing shortcut keys -- charts charts -- shortcuts charts -- overview HowTos for chartsAccess2BaseMicrosoft Access -- Access2Base Access databases -- run in Base properties -- controls in dialog editor changing -- control properties controls -- changing properties dialog editor -- changing control properties dialogs -- creating Basic dialogs controls -- creating in the dialog editor dialog editor -- creating controls programming examples for controls dialogs -- loading (example)dialogs -- displaying (example)controls -- reading or editing properties (example)list boxes -- removing entries from (example)list boxes -- adding entries to (example)examples -- programming controls dialog editor -- programming examples for controls module/dialog toggle dialogs -- using program code to show (example)examples -- showing a dialog using program code dialogs -- translating localizing dialogs translating dialogs twips -- definition macros -- Basic IDE Basic IDE -- macros libraries -- adding inserting -- Basic libraries fundamentals subroutines variables -- global and local modules -- subroutines and functions names of variables variables -- using types of variables declaring variables values -- of variables constants arrays -- declaring defining -- constants procedures functions -- using variables -- passing to procedures and functions parameters -- for procedures and functions parameters -- passing by reference or value variables -- scope scope of variables GLOBAL variables PUBLIC variables PRIVATE variables functions -- return value type return value type of functions Basic IDE -- Integrated Development Environment IDE -- Integrated Development Environment saving -- Basic code loading -- Basic code Basic editor navigating -- in Basic projects long lines -- in Basic editor lines of text -- in Basic editor continuation -- long lines in editor debugging Basic programs variables -- observing values watching variables run-time errors in Basic error codes in Basic breakpoints Call Stack window libraries -- organizing modules -- organizing copying -- modules adding libraries deleting -- libraries/modules/dialogs dialogs -- organizing moving -- modules organizing -- modules/libraries/dialogs renaming modules and dialogs deleting -- macro assignments to events macros -- assigning to events assigning macros to events events -- assigning macros controls -- properties properties -- controls and dialogs dialogs -- properties macros -- stopping program stops stopping macros controls -- in dialog editor push button control in dialog editor icon control buttons -- controls image control check box control radio button control option button control fixed text control label field control editing -- controls text boxes -- controls list boxes -- controls combo box control scroll bar control horizontal scrollbar control vertical scrollbar control group box control progress bar control fixed line control horizontal line control line control vertical line control date field control time field control numerical field control currency field control formatted field control pattern field control masked field control file selection control selection options for controls test mode control BASIC Tools library BASIC Tools library -- Debug module BASIC Tools library -- ListBox module BASIC Tools library -- Misc module BASIC Tools library -- ModuleControl module BASIC Tools library -- Strings module BASIC Tools library -- UCB module BASIC Euro library BASIC Gimmicks library BASIC ScriptBindingLibrary library BASIC Schedule library MsgBox statement MsgBox function Print statement InputBox function Blue function Green function Red function Close statement FreeFile function Open statement Reset statement Get statement Input statement Line Input statement Put statement Write statement Eof function Loc function Lof function Seek function Seek statement ChDir statement ChDrive statement CurDir function Dir function FileAttr function FileCopy statement FileDateTime function FileLen function GetAttr function Kill statement MkDir statement Name statement RmDir statement SetAttr statement FileExists function DateSerial function DateValue function Day function Month function WeekDay function Year function CdateToIso function CdateFromIso function DateAdd function CDateToUnoDate function CDateFromUnoDate function CDateToUnoTime function CDateFromUnoTime function CDateToUnoDateTime function CDateFromUnoDateTime function DateDiff function DatePart function Hour function Minute function Now function Second function TimeSerial function TimeValue function Date statement Time statement Timer function Pi -- Basic constant Null -- Basic constant Empty -- Basic constant Nothing -- Basic constant Basic constant -- Nothing Basic constant -- Null Basic constant -- Empty Basic constant -- Pi Basic constant -- False Basic constant -- True VBA Exclusive constants Erl function Err function Error function Resume Next parameter On Error GoTo ... Resume statement AND operator (logical)Eqv operator (logical)Imp operator (logical)Not operator (logical)Or operator (logical)XOR operator (logical)"-" operator (mathematical)"*" operator (mathematical)"+" operator (mathematical)"/" operator (mathematical)"^" operator (mathematical)MOD operator (mathematical)Atn function Cos function Sin function Tan function Exp function Log function Randomize statement Rnd function Sqr function Fix function Int function Abs function Sgn function Hex function Oct function If statement Select...Case statement Case statement IIf statement Do...Loop statement While -- Do loop Until loops For statement To statement Step statement Next statement While -- While...Wend loop GoSub...Return statement GoTo statement On...GoSub statement On...GoTo statement Call statement Choose function Declare statement DLL (Dynamic Link Library)End statement FreeLibrary function Function statement Rem statement comments -- Rem statement Stop statement Sub statement Switch function With statement Exit statement Type statement CCur function CDec function CVar function CVErr function CBool function CDate function CDbl function CInt function CLng function Const statement CSng function CStr function DefBool statement DefCur statement DefErr statement DefSng statement DefStr statement DefDate statement DefDbl statement DefInt statement DefLng statement DefObj statement DefVar statement Dim statement arrays -- dimensioning dimensioning arrays ReDim statement IsArray function IsDate function IsEmpty function IsError function IsNull function Null value IsNumeric function IsObject function LBound function UBound function Let statement Option Base statement Option Explicit statement Microsoft Excel macros support -- Enable Microsoft Excel macros support -- Option VBASupport statement VBA Support -- Option VBASupport statement Option VBASupport statement Public statement Global statement Static statement TypeName function VarType function Set statement Nothing object FindObject function FindPropertyObject function IsMissing function Optional function Array function DimArray function HasUnoInterfaces function IsUnoStruct function EqualUnoObjects function Erase function comparison operators -- Collabora Office Basic operators -- comparisons Asc function Chr function Str function Val function CByte function AscW function ChrW function Space function String function ampersand symbol in StarBasic Format function LCase function Left function LSet statement LTrim function Mid function Mid statement Right function RSet statement RTrim function UCase function Trim function ConvertToURL function ConvertFromURL function Split function Join function InStr function Len function StrComp function InStrRev function StrReverse function Beep statement Shell function Wait statement GetSystemTicks function Environ function GetSolarVersion function TwipsPerPixelX function TwipsPerPixelY function CreateUnoStruct function CreateUnoService function filepicker -- API service GetProcessServiceManager function ProcessServiceManager CreateUnoDialog function GlobalScope function library systems LibraryContainer BasicLibraries (LibraryContainer)DialogLibraries (LibraryContainer)CreateUnoListener function GetGuiType function ThisComponent property components -- addressing CreateUnoValue function CreateObject function GetDefaultContext function DDB function FV function IPmt function IRR function MIRR function NPer function NPV function Pmt function PPmt function PV function Rate function SLN function SYD function FormatDateTime function WeekdayName function MonthName function Input function Round function FormatNumber function events -- linked to objects keyboard -- in IDE shortcut keys -- Basic IDE IDE -- keyboard shortcuts toolbars -- Basic IDE macro toolbar VBA Functions -- Introduction VBA Functions -- Text Functions VBA Functions -- Financial Functions VBA Functions -- Date and Time Functions VBA Functions -- I/O Functions VBA Functions -- Mathematical Functions VBA Functions -- formatting numbers VBA Functions -- Object FunctionsInternet glossarycommon terms -- Internet glossary glossaries -- Internet terms terminology -- Internet glossary HTML -- definition hyperlinks -- definition ImageMap -- definition Server Side ImageMap Client Side ImageMap Java -- definition SGML -- definition search engines -- definition tags -- definition URL -- definition measurement units -- converting units -- converting converting -- metrics metrics -- converting common terms -- glossaries glossaries -- common terms terminology -- general glossary ASCII -- definition CTL -- definition complex text layout -- definition complex text layout, see CTL DDE -- definition windows -- docking definition docking -- definition formatting -- definition IME -- definition JDBC -- definition kerning -- definition links -- definition objects -- definition ODBC -- definition OLE -- definition OpenGL -- definition register-true -- definition SQL -- definition import filters export filters filters -- for import and export files -- filters and formats formats -- on opening and saving importing -- HTML and text documents exporting -- HTML and text documents text documents -- importing/exporting HTML documents -- importing/exporting UTF-8/UCS2 support HTML -- export character set PostScript -- creating files exporting -- to PostScript format exporting -- XML files XML file formats extensions -- file formats suffixes in file formats document types in Collabora Office file formats -- changing Collabora Office defaults defaults -- file formats in Collabora Office file formats -- OpenDocument/XML OpenDocument file formats ODF file formats directories -- creating new folder creation My Documents folder -- opening multiple documents -- opening opening -- several files selecting -- several files opening -- files, with placeholders placeholders -- on opening files documents -- opening with templates templates -- opening documents with documents -- styles changed styles -- changed message remote file -- open open -- remote file documents -- closing closing -- documents remote file -- save save -- remote file save -- save a copy save a copy saving as command -- precautions documents -- exporting converting -- Collabora Office documents exporting -- to foreign formats Export as -- PDF Export as -- EPUB version numbers of documents documents -- version numbers files -- version numbers editing time of documents documents -- editing time number of pages documents -- number of pages/tables/sheets number of tables number of sheets cells -- number of pictures -- number of OLE objects -- number of password as document property file sharing options for current document read-only documents -- opening documents as saving -- with password by default user data -- removing when saving embedding fonts in document file documents -- embedding fonts font embedding -- in documents fonts -- embedding embedding -- fonts printing -- documents documents -- printing text documents -- printing spreadsheets -- printing presentations -- print menu drawings -- printing choosing printers printers -- choosing print area selection selecting -- print areas pages -- selecting one to print printing -- selections printing -- copies copies -- printing spoolfiles with Xprinter printers -- properties settings -- printers properties -- printers default printer -- setting up printers -- default printer page formats -- restriction exiting -- Collabora Office versions -- file saving as, restriction undoing -- editing editing -- undoing restoring -- editing redo command repeating -- commands commands -- repeating cutting clipboard -- cutting clipboard -- Unix copying -- in Unix pasting -- cell ranges clipboard -- pasting cells -- pasting pasting -- Enter key pasting -- Ctrl+V shortcut case sensitivity -- searching searching -- all sheets finding -- in all sheets sheets -- searching all finding -- selections regular expressions -- list of lists -- regular expressions replacing -- tab stops (regular expressions)tab stops -- regular expressions concatenation, see ampersand symbol ampersand symbol, see also operators similarity search finding -- similarity search opening -- documents with links links -- updating specific links updating -- links, on opening links -- opening files with DDE links -- modifying changing -- DDE links objects -- editing editing -- objects objects -- opening opening -- objects hotspots -- properties properties -- hotspots ImageMap -- hotspot properties changes -- showing hiding -- changes showing -- changes zooming -- page views views -- scaling screen -- scaling pages -- scaling standard bar on/off tools bar status bar on/off full screen view screen -- full screen views complete screen view views -- full screen color bar paint box comments -- inserting/editing/deleting/printing inserting -- comments editing -- comments deleting -- comments Navigator -- comments printing -- comments records -- inserting comments remarks, see also comments OLE objects -- inserting inserting -- OLE objects objects -- inserting OLE objects formulas -- starting formula editor Collabora Office Math start Math formula editor equations in formula editor editors -- formula editor floating frames in HTML documents inserting -- floating frames formatting -- undoing when writing hyperlinks -- deleting deleting -- hyperlinks cells -- resetting formats formats -- fonts characters -- fonts and formats fonts -- formats text -- fonts and formats typefaces -- formats font sizes -- relative changes languages -- spellchecking and formatting characters -- enabling CTL and Asian characters fonts -- effects formatting -- font effects characters -- font effects text -- font effects effects -- fonts underlining -- text capital letters -- font effects lowercase letters -- font effects titles -- font effects small capitals strikethrough -- font effects fonts -- strikethrough outlines -- font effects fonts -- outlines shadows -- characters fonts -- shadows fonts -- color ignored ignored font colors colors -- ignored text color blinking fonts flashing fonts formats -- number and currency formats number formats -- formats currencies -- format codes defaults -- number formats format codes -- numbers conditions -- in number formats number formats -- codes currency formats formats -- of currencies/date/time numbers -- date, time and currency formats Euro -- currency formats date formats times, formats percentages, formats scientific notation, formats engineering notation, formats fraction, formats native numeral LCID, extended formatting -- hyperlinks characters -- hyperlinks hyperlinks -- character formats text -- hyperlinks links -- character formats positioning -- fonts formats -- positions effects -- font positions fonts -- positions in text spacing -- font effects characters -- spacing pair kerning kerning -- in characters text -- kerning double-line writing in Asian layout formats -- Asian layout characters -- Asian layout text -- Asian layout Asian typography formatting -- Asian typography paragraphs -- Asian typography typography -- Asian spacing -- between paragraphs in footnotes line spacing -- paragraph spacing -- lines and paragraphs single-line spacing in text one and a half line spacing in text double-line spacing in paragraphs leading between paragraphs paragraphs -- spacing formats -- tabulators fill characters with tabulators tab stops -- settings shadows -- borders borders -- shadows margins -- shadows frames -- backgrounds backgrounds -- frames/sections/indexes sections -- backgrounds indexes -- backgrounds footers -- backgrounds headers -- backgrounds aligning -- paragraphs paragraphs -- alignment lines of text -- alignment left alignment of paragraphs right alignment of paragraphs centered text justifying text cropping pictures pictures -- cropping and zooming zooming -- pictures scaling -- pictures sizes -- pictures original size -- restoring after cropping organizing -- styles styles -- organizing pages -- formatting and numbering formatting -- pages paper formats paper trays printers -- paper trays layout -- pages binding space margins -- pages gutter Asian Phonetic Guide phonetic guide aligning -- objects positioning -- objects ordering -- objects aligning -- text objects text objects -- alignment fonts -- text objects text objects -- fonts text -- font sizes font sizes -- text text -- font styles fonts -- styles text -- bold bold -- text characters -- bold text -- italics italic text characters -- italics characters -- underlining underlining -- characters strikethrough -- characters text -- shadowed characters -- shadowed shadows -- characters, using context menu table rows -- distribute height equally row height -- distribute equally line spacing -- context menu in paragraphs text -- line spacing table columns -- distribute columns equally column width -- distribute equally objects -- naming groups -- naming names -- objects objects -- titles and descriptions descriptions for objects titles -- objects areas -- styles fill patterns for areas fill colors for areas invisible areas hatching areas -- hatched/dotted dotted areas bitmaps -- patterns areas -- bitmap patterns pixel patterns pixel editor pattern editor areas -- shadows shadows -- areas transparency -- areas areas -- transparency text -- text/draw objects draw objects -- text in frames -- text fitting to frames positioning -- draw objects and controls draw objects -- positioning and resizing controls -- positions and sizes sizes -- draw objects anchors -- types/positions for draw objects draw objects -- anchoring slanting draw objects draw objects -- slanting areas -- slanting legends -- draw objects draw objects -- legends labels -- for draw objects labels, see also names/callouts captions, see also labels/callouts names, see also labels/callouts draw objects -- flipping flipping draw objects objects -- arranging within stacks arranging -- objects borders -- arranging pictures -- arranging within stacks draw objects -- arranging within stacks controls -- arranging within stacks OLE objects -- arranging within stacks charts -- arranging within stacks layer arrangement levels -- depth stagger depth stagger aligning -- cells cells -- aligning data source browser tables in databases -- browsing and editing databases -- editing tables editing -- database tables and queries queries -- editing in data source view dictionaries -- spellcheck spellcheck -- dialog languages -- spellcheck Chinese writing systems simplified Chinese -- conversion to traditional Chinese traditional Chinese -- conversion to simplified Chinese common terms -- Chinese dictionary dictionaries -- common terms in simplified and traditional chinese AutoCorrect function -- switching on and off AutoComplete, see also AutoCorrect/AutoInput AutoCorrect function -- options replacement options words -- automatically replacing abbreviation replacement capital letters -- AutoCorrect function bold -- AutoFormat function underlining -- AutoFormat function spaces -- ignoring double numbering -- using automatically paragraphs -- numbering automatically tables in text -- creating automatically titles -- formatting automatically empty paragraph removal paragraphs -- removing blank ones styles -- replacing automatically user-defined styles -- automatically replacing bullets -- replacing paragraphs -- joining joining -- paragraphs AutoCorrect function -- replacement table replacement table replacing -- AutoCorrect function text -- replacing with format frames -- AutoCorrect function pictures -- inserting automatically AutoCorrect function -- pictures and frames quotes -- custom custom quotes AutoCorrect function -- quotes replacing -- ordinal numbers ordinal numbers -- replacing AutoCorrect function -- context menu spellcheck -- context menus smart tag configuration bullets -- paragraphs paragraphs -- inserting bullets inserting -- paragraph bullets numbering -- options bullet lists -- formatting options font sizes -- bullets macros -- organizing organizing -- macros and scripts script organization menus -- customizing customizing -- menus editing -- menus keyboard -- assigning/editing shortcut keys customizing -- keyboard editing -- shortcut keys styles -- keyboard shortcuts context menus -- customizing customizing -- context menus editing -- context menus customizing -- events events -- customizing filters -- XML filter settings XML filters -- settings converting -- Hangul/Hanja Hangul/Hanja new windows windows -- new importing -- HTML with META tags exporting -- to HTML HTML -- importing META tags HTML documents -- META tags in META tags tags -- META tags CTL -- (not) wrapping words words -- wrapping in CTL font features font features -- OpenType OpenType -- font features grids -- display options (Impress/Draw)guides -- display options (Impress/Draw)image -- compression image -- reduce image size image -- size reduction image -- resize image -- change resolution Media Player window inserting -- movies/sounds sound files playing movies and sound files videos movies audio music notebook bar -- contextual single toolbar notebook bar -- contextual groups notebook bar -- tabbed mode notebook bar -- single toolbar notebook bar -- default layout notebook bar -- layouts notebook bar -- toolbar notebook bar -- sidebar sidebar -- notebook bar toolbar -- notebook bar updates -- checking manually online updates -- checking manually UNO components -- Extension Manager extensions -- Extension Manager packages, see extensions profile -- safe mode EPUB -- export electronic publication exporting -- to EPUB PDF -- export portable document format exporting -- to PDF digital signature -- signing existing PDF security -- warning dialogs with macros macros -- security warning dialog data structure of XForms deleting -- models/instances models in XForms Data Navigator -- display options read-only items in Data Navigator Data Navigator -- adding/editing items conditions -- items in Data Navigator XForms -- conditions editing -- data binding of XForms data binding change in XForms deleting -- namespaces in XForms organizing -- namespaces in XForms namespace organization in XForms XForms -- adding/editing/deleting/organizing namespaces printing -- directly Drawing bar lines -- draw functions polygon drawing freeform lines -- draw functions text boxes -- positioning headings -- entering as text box text objects -- draw functions ticker text text -- animating vertical callouts vertical text boxes cube drawing triangle drawing ellipse drawing rectangle drawing shapes form controls -- toolbars inserting -- form fields form fields command button creation buttons -- form functions controls -- inserting push buttons -- creating radio button creation check box creation labels -- form functions fixed text -- form functions text boxes -- form functions list box creation picklist creation drop-down lists in form functions combo box creation selecting -- controls controls -- select mode formatted fields -- properties fields -- formatted fields controls -- formatted fields date fields -- properties table controls -- properties controls -- properties of table controls table controls -- keyboard-only edit mode controls -- properties of form controls properties -- form controls rich text control controls -- rich text control controls -- grouping groups -- of controls forms -- grouping controls multi-line titles in forms names -- multi-line titles controls -- multi-line titles controls -- reference by SQL bound fields -- controls controls -- bound fields/list contents/linked cells lists -- data assigned to controls cells -- linked to controls links -- between cells and controls controls -- assigning data sources controls -- events events -- controls macros -- assigning to events in forms forms -- properties properties -- forms submitting forms get method for form transmissions post method for form transmissions forms -- events events -- in forms forms -- data data -- forms and subforms forms -- subforms subforms -- description controls -- arranging in forms forms -- Navigator Form Navigator subforms -- creating controls -- hidden hidden controls in Form Navigator forms -- HTML filters forms -- Combo Box/List Box Wizard forms -- opening in design mode controls -- activating in forms design mode after saving documents -- opening in design mode edit mode -- after opening fonts -- specifying several alternative fonts characters -- alternative fonts paragraphs -- increasing indents of anchors -- changing reloading -- documents documents -- reloading loading -- reloading write protection on/off protected documents documents -- read-only read-only documents -- editing cursor -- in read-only text read-only documents -- cursor Edit File icon read-only documents -- database tables on/off protected database tables data -- read-only records -- saving database contents -- inserting as tables database contents -- inserting as fields database contents -- inserting as text default filters, see standard filters databases -- standard filters standard filters -- databases comparisons -- operators in standard filter dialog operators -- standard filters standard filters -- comparison operators filters -- comparison operators equal sign, see also operators sorting -- databases databases -- sorting tables in databases -- searching forms -- browsing records -- searching in databases searching -- databases databases -- searching records data sources -- as tables data sources -- displaying current margins -- setting with the mouse columns -- setting with the mouse paragraphs -- indents, margins and columns tables in databases -- adding to queries SQL -- DISTINCT parameter distinct values in SQL queries HTML documents -- source text page styles -- editing/applying with statusbar zooming -- status bar selection modes in text text -- selection modes extending selection mode adding selection mode block selection mode callouts -- drawings speech bubbles SQL -- LIMIT clause more controls group box creation image button creation image control creation file selection button date fields -- creating time fields -- form functions numerical fields in forms formatted fields -- form functions currency field creation pattern fields -- form functions table controls -- form functions grid controls -- form functions controls -- focus focus of controls forms -- focus after opening automatic control focus spin button creation scrollbars -- controls Navigation bar -- controls queries -- set properties keyboard -- general commands shortcut keys -- general text input fields AutoComplete function in text and list boxes macros -- interrupting shortcut keys -- in databases databases -- shortcut keys support on the Web getting support forums and support Web support Help -- Help tips tooltips -- help Index tab in Help Help -- keywords Find tab in Help Help -- full-text search full-text search in Help Help -- bookmarks bookmarks -- Help Help -- topics tree view of Help Collabora Office Help Help pages -- Index Help pages -- search in index search -- Help index Help pages -- contents wizards -- overview AutoPilots, see wizards wizards -- letters Letter Wizard templates -- letters wizards -- faxes faxes -- wizards templates -- faxes wizards -- agendas Agenda Wizard templates -- agendas forms -- wizards wizards -- forms kiosk export HTML -- live presentations live presentations on the Internet showing -- live presentations on the Internet presentations -- live on the Internet Internet -- presentations WebCast export Euro -- Euro Converter Wizard wizards -- Euro Converter converters -- Euro converter currencies -- converters samples and templates templates -- new documents from templates business cards -- using templates accessibility -- Collabora Office features Help -- extended tips on/off extended tips in Help tips -- extended tips in Help tooltips -- extended tips activating -- extended help tips ActiveX control installing -- ActiveX control Internet -- Internet Explorer for displaying Collabora Office documents Collabora Office documents -- viewing and editing in Internet Explorer viewing -- Collabora Office documents in Internet Explorer editing -- Collabora Office documents in Internet Explorer accessibility -- Collabora Office assistive technology assistive technology in Collabora Office screen readers screen magnifiers magnifiers AutoCorrect function -- URL recognition recognizing URLs automatically automatic hyperlink formatting URL -- turning off URL recognition hyperlinks -- turning off automatic recognition links -- turning off automatic recognition predictive text, see also AutoCorrect function/AutoFill function/AutoInput function/word completion/text completion Gallery -- hiding/showing data source view -- showing Navigator -- docking Styles window -- docking windows -- hiding/showing/docking docking -- windows undocking windows showing -- docked windows hiding -- docked windows backgrounds -- defining colors/pictures colors -- backgrounds pictures -- backgrounds pages -- backgrounds in all applications watermarks text, see also text documents, paragraphs and characters borders, see also frames paragraphs -- defining borders borders -- for paragraphs frames -- around paragraphs inserting -- paragraph borders defining -- paragraph borders tables in text -- defining borders tables in spreadsheets -- defining borders borders -- for tables frames -- around tables defining -- table borders line breaks -- in cells cells -- line breaks text flow -- in cells text breaks in cells wrapping text -- in cells words -- wrapping in cells automatic line breaks new lines in cells inserting -- line breaks in cells tables -- inserting line breaks titles -- changing changing -- document titles documents -- changing titles charts -- editing axes axes in charts editing -- chart axes formatting -- axes in charts charts -- bars with textures textures -- on chart bars inserting -- textures on chart bars charts -- inserting plotting data as charts inserting -- charts spreadsheets -- inserting charts charts -- editing data editing -- chart data charts -- editing legends legends -- charts editing -- chart legends formatting -- chart legends charts -- editing titles editing -- chart titles titles -- editing in charts opening -- CMIS remote file opening -- remote file remote file service -- opening file opening remote file remote file service -- file lock remote file service -- version control remote file service -- working copy remote file service -- checkout remote file service -- checkin remote file service -- saving to remote server remote file service -- saving remote file service -- CMIS properties remote file service -- file properties remote file service -- setup WebDAV -- remote file service setup remote file service setup -- WebDAV SSH -- remote file service setup FTP -- remote file service setup remote file service setup -- FTP remote file service setup -- SSH remote file service -- Windows share Windows share -- remote file service Windows share -- remote file service setup remote file service setup -- Windows share remote file service -- Google Drive Google Drive -- remote file service Google Drive -- remote file service setup remote file service setup -- Google Drive remote file service setup -- other file services remote file service setup -- Lotus remote file service setup -- SharePoint remote file service setup -- IBM remote file service setup -- Nuxeo remote file service setup -- Alfresco remote file service setup -- CMIS server sharing documents collaboration file locking with collaboration locked documents configuring -- Collabora Office customizing -- Collabora Office context menus menus -- activating context menus opening -- context menus activating -- context menus draw objects -- copying between documents copying -- draw objects between documents pasting -- draw objects from other documents charts -- copying with link to source cell range inserting -- cell ranges from spreadsheets pasting -- cell ranges from spreadsheets presentations -- inserting spreadsheet cells text documents -- inserting spreadsheet cells tables in spreadsheets -- copying data to other applications sending -- AutoAbstract function in presentations AutoAbstract function for sending text to presentations outlines -- sending to presentations text -- copying by drag and drop drag and drop -- copying and pasting text inserting -- data from text documents copying -- data from text documents pasting -- data from text documents CTL -- complex text layout languages languages -- complex text layout text -- CTL languages text layout for special languages right-to-left text entering text from right to left bi-directional writing Hindi -- entering text Hebrew -- entering text Arabic -- entering text Thai -- entering text data sources -- registering address books address books -- registering system address book registration registering -- address books databases -- text formats text formats -- databases importing -- tables in text format exporting -- spreadsheets to text format SQL -- executing SQL commands queries -- creating in SQL view commands -- SQL executing SQL commands opening -- forms forms -- creating design view -- creating forms databases -- importing/exporting importing -- databases copying -- datasource records in spreadsheets inserting -- datasource records in spreadsheets spreadsheets -- inserting database records data sources -- copying records to spreadsheets pasting -- from data sources to Collabora Office Calc databases -- creating new databases databases -- creating queries filtering -- data in databases queries -- defining (Base)defining -- queries (Base)wizards -- database queries Query Wizard (Base)databases -- registering (Base)registering -- databases (Base)deleting -- databases (Base)databases -- deleting (Base)lists -- registered databases (Base)database reports data sources -- reports reports -- opening and editing editing -- reports opening -- reports templates -- database reports reports -- templates databases -- creating reports reports -- creating wizards -- reports finding -- records in form documents forms -- finding records searching -- tables and forms form filters databases -- form filters searching -- form filters removing -- form filters filtering -- data in forms data -- filtering in forms forms -- filtering data data, see also values tables in databases -- creating in design view (manually)designing -- database tables properties -- fields in databases fields -- database tables AutoValue (Base)primary keys -- design view tables in databases -- creating databases -- creating tables table views of databases opening -- database files viewing -- databases data sources -- viewing databases -- viewing databases -- overview data source view -- overview data source explorer explorer of data sources certificates digital signatures -- overview security -- digital signatures opening -- documents on WebDAV server WebDAV over HTTPS digital signatures -- WebDAV over HTTPS signing documents with digital signatures digital signatures -- getting/managing/applying documents -- saving automatically saving -- documents, automatically automatic saving backups -- automatic files -- saving automatically text documents -- saving automatically spreadsheets -- saving automatically drawings -- saving automatically presentations -- saving automatically opening -- documents documents -- opening files -- opening loading -- documents spreadsheets -- creating/opening presentations -- creating/opening FTP -- opening documents new documents empty documents text documents -- creating/opening drawings -- creating/opening HTML documents -- new formulas -- new documents -- saving saving -- documents backups -- documents files -- saving text documents -- saving spreadsheets -- saving drawings -- saving presentations -- saving FTP -- saving documents drag and drop -- overview mouse -- pointers when using drag and drop links -- by drag and drop copying -- by drag and drop drag and drop -- data source view data source view -- drag and drop copying -- from data source view pasting -- from data source view Gallery -- dragging pictures to draw objects draw objects -- dropping Gallery pictures drag and drop -- from Gallery to draw objects drag and drop -- to Gallery copying -- to Gallery Gallery -- adding pictures pictures -- adding to Gallery inserting -- pictures in Gallery pasting -- to Gallery drag and drop -- pictures pictures -- drag and drop between documents copying -- pictures, between documents pasting -- pictures from other documents spreadsheets -- copying areas to text documents copying -- sheet areas, to text documents pasting -- sheet areas in text documents customizing -- toolbars buttons -- toolbars toolbars -- adding buttons configuring -- toolbars editing -- toolbars inserting -- buttons in toolbars documents -- sending as e-mail sending -- documents as e-mail e-mail attachments files -- sending as e-mail text documents -- sending as e-mail spreadsheets -- sending as e-mail drawings -- sending as e-mail presentations -- sending as e-mail attachments in e-mails Error Report Tool reports -- error reports crash reports activating -- Error Report Tool documents -- saving in other formats saving -- documents in other formats files -- saving in other formats text documents -- saving in other formats spreadsheets -- saving in other formats drawings -- saving in other formats presentations -- saving in other formats exporting -- to Microsoft Office formats Word documents -- saving as Excel -- saving as PowerPoint export faxes -- sending faxes -- configuring Collabora Office sending -- documents as faxes configuring -- fax icon filters -- Navigator filter conditions -- connecting fonts -- finding font attributes -- finding text attributes -- finding attributes -- finding finding -- attributes resetting -- Find & Replace mode buttons -- big/small views -- icons icon sizes changing -- icon sizes large icons small icons toolbars -- docking/undocking toolbars -- viewing/closing closing -- toolbars docking -- toolbars fixing toolbars detaching toolbars placing toolbars positioning -- toolbars moving -- toolbars attaching toolbars floating toolbars windows -- docking viewing -- toolbars showing -- toolbars icon bars, see toolbars button bars, see toolbars graphical text art designing -- fonts TextArt, see Fontwork WordArt, see Fontwork Fontwork text effects effects -- Fontwork icons text -- Fontwork icons 3D text creation rotating -- 3D text editing -- Fontwork objects inserting -- Fontwork objects command buttons, see push buttons controls -- adding to documents inserting -- push buttons keys -- adding push buttons buttons -- adding push buttons press buttons, see push buttons push buttons -- adding to documents Gallery -- inserting pictures from pictures -- inserting from Gallery objects -- inserting from Gallery patterns for objects textures -- inserting from Gallery backgrounds -- inserting from Gallery inserting -- objects from Gallery copying -- from Gallery groups -- entering/exiting/ungrouping frames -- selection frames selecting -- objects exiting -- groups entering groups ungrouping groups selection frames multiple selection marking, see selecting hyperlinks -- editing links -- editing hyperlinks editing -- hyperlinks text attributes -- hyperlinks buttons -- editing hyperlink buttons URL -- changing hyperlink URLs hyperlinks -- inserting links -- inserting inserting -- hyperlinks absolute hyperlinks relative hyperlinks hyperlinks -- relative and absolute hyperlinks, see also links ImageMap -- editor editors -- ImageMap editor images -- ImageMap pictures -- ImageMap hotspots -- adding to images URL -- in pictures Microsoft Office -- opening Microsoft documents documents -- importing importing -- documents in other formats opening -- documents from other formats loading -- documents from other formats converting -- Microsoft documents saving -- default file formats defaults -- document formats in file dialogs file formats -- saving always in other formats Microsoft Office -- as default file format files -- importing XML converters converters -- XML Document Converter Wizard wizards -- document converter converters -- document converter files, see also documents graphics, see also pictures images, see also pictures images -- inserting and editing bitmaps illustrations, see pictures bitmaps -- inserting and editing pixel graphics -- inserting and editing exporting -- bitmaps importing -- bitmaps pictures -- editing editing -- pictures invert filter smoothing filter sharpening filter remove noise filter solarization filter aging filter posterizing filter pop-art filter charcoal sketches filter mosaic filter pictures -- filters filters -- pictures resizing, see also scaling/zooming scaling, see also zooming drawings, see also draw objects graphic objects, see draw objects text -- drawing pictures inserting -- drawings pictures -- drawing objects -- copying when moving in presentations draw objects -- adding/editing/copying circle drawings square drawings handles -- scaling scaling -- objects objects -- moving and resizing with mouse resizing -- objects, by mouse copying -- draw objects pasting -- draw objects editing -- draw objects pictures -- scaling/resizing characters -- special inserting -- special characters special characters text -- inserting special characters accents compose key to insert special characters add-ons, see UNO components UNO components -- integrating new installing -- UNO components accessibility -- general shortcuts shortcut keys -- Collabora Office accessibility labels -- creating and synchronizing business cards -- creating and synchronizing synchronizing -- labels and business cards address labels from databases labels -- from databases stickers databases -- creating labels languages -- selecting for text documents -- languages characters -- language selection character styles -- language selection text -- language selection paragraph styles -- languages drawings -- languages defaults -- languages spellcheck -- default languages dictionaries, see also languages arrows -- drawing in text indicator lines in text lines -- drawing in text lines -- removing automatic lines deleting -- lines in text drawing lines in text automatic lines/borders in text defining -- arrowheads and other line ends arrows -- defining arrow heads lines -- defining ends line styles -- defining defining -- line styles separator lines -- defining reference lines arrows -- defining arrow lines line styles -- applying macros -- recording recording -- macros Basic -- recording macros macro recording -- limitations instructions -- general documents -- measurement units in measurement units -- selecting units -- measurement units centimeters inches distances selecting -- measurement units Microsoft Office -- feature comparisons Microsoft Office -- reassigning document types file associations for Microsoft Office changing -- file associations in Setup program Microsoft Office -- document import restrictions import restrictions for Microsoft Office Microsoft Office -- importing password protected files Office -- Microsoft Office and Collabora Office Microsoft Office -- new users information opening -- Microsoft Office files saving -- in Microsoft Office file format macros -- in MS Office documents documents -- contents as lists Navigator -- contents as lists Document Map, see Navigator cursor -- quickly moving to an object objects -- quickly moving to navigating -- in documents Navigator -- working with Help -- navigation pane showing/hiding hiding -- navigation pane in Help window indexes -- showing/hiding Help index tab numbering -- turning off bullets -- turning off removing, see also deleting removing -- bullets and numbering keyboard -- removing numbering page formats -- maximizing formats -- maximizing page formats printers -- maximum page formats Format Paintbrush clone formatting formatting -- copying copying -- formatting Paintbrush clipboard -- pasting formatted/unformatted text inserting -- clipboard options pasting -- formatted/unformatted text text formats -- pasting formats -- pasting in special formats printing -- black and white black and white printing colors -- not printing text -- printing in black gradients off for faster printing bitmaps -- off for faster printing resolution when printing bitmaps transparency -- off for faster printing reduced printing speed of printing printing speed printing -- transparencies printing -- faster faster printing protecting -- contents protected contents contents protection encryption of contents passwords for protecting contents security -- protecting contents form controls -- protecting draw objects -- protecting OLE objects -- protecting graphics -- protecting frames -- protecting marking changes highlighting changes changes -- review function review function -- recording changes example Track Changes, see review function changes -- accepting or rejecting review function -- accepting or rejecting changes documents -- comparing comparisons -- document versions versions -- comparing documents changes -- comparing to original review function -- comparing documents documents -- merging merging -- documents versions -- merging document versions changes -- recording recording -- changes comments -- on changes review function -- tracking changes changes -- navigating review function -- navigating changes changes -- protecting protecting -- recorded changes records -- protecting review function -- protecting records versions -- of a document documents -- version management version management corner roundings rectangles with round corners legends -- rounding corners round corners customizing -- round corners assigning scripts programming -- scripting form controls -- assigning macros pictures -- assigning macros hyperlinks -- assigning macros shortcut keys -- assigning macros controls -- assigning macros (Basic)menus -- assigning macros events -- assigning scripts protected spaces -- inserting non-breaking spaces -- inserting spaces -- inserting protected spaces soft hyphens -- inserting hyphens -- inserting custom conditional separators separators -- conditional dashes non-breaking hyphens replacing -- dashes protected hyphens exchanging, see also replacing printers -- adding, UNIX default printer -- UNIX standard printer under UNIX faxes -- fax programs/fax printers under UNIX printers -- faxes under UNIX modifying, see changing changing, see also editing and replacing default templates -- changing defaults -- documents custom templates updating -- templates editing -- templates templates -- editing and saving saving -- templates resetting -- templates start parameters command line parameters parameters -- command line arguments in command line backing window start center tab stops -- inserting and editing paragraphs -- tab stops defaults -- tab stops in text editing -- tab stops inserting -- tab stops decimal tab stops deleting -- tab stops moving -- tab stops on ruler rulers -- default settings rulers -- measurement units measurement units -- changing on rulers template manager -- filter template manager -- category template manager -- set as default template manager -- import template manager -- export template manager -- settings templates -- template manager text -- coloring characters -- coloring colors -- fonts fonts -- colors paint can symbol text -- overwriting or inserting overwrite mode insert mode for entering text undoing -- direct formatting direct formatting -- undoing all deleting -- all direct formatting text attributes -- undoing formatting -- undoing restoring -- default formatting versions -- Collabora Office build numbers of Collabora Office copyright for Collabora Office properties -- files files -- properties viewing -- file properties working directory change My Documents folder -- changing work directory paths -- changing work directory pictures -- changing paths changing -- work directory web documents -- XForms forms -- XForms XML Forms, see XForms XForms -- opening/editing editing -- XForms opening -- XForms saving -- to XML loading -- XML files importing -- from XML exporting -- to XML file filters -- XML XSLT filters, see also XML filters testing XML filters XML filters -- creating/testing distributing XML filters deleting -- XML filters XML filters -- saving as package/installing/deleting installing -- XML filters toolbars -- Form Navigation bar Navigation bar -- forms sorting -- data in forms data -- sorting in forms forms -- sorting data lines -- editing points curves -- editing points Edit Points bar options -- tools defaults -- program configuration settings -- program configuration data -- user data user data -- input personal data input saving -- options defaults -- of saving URL -- saving absolute/relative paths relative saving of URLs absolute saving of URLs paths -- defaults variables -- for paths directories -- directory structure files and folders in Collabora Office writing aids options custom dictionaries -- editing user-defined dictionaries -- editing dictionaries -- editing user-defined exceptions -- user-defined dictionaries user-defined dictionaries -- dictionary of exceptions spellcheck -- dictionary of exceptions ignore list for spellcheck spellcheck -- ignore list hyphenation -- minimal number of characters spellcheck -- activating for a language hyphenation -- activating for a language thesaurus -- activating for a language languages -- activating modules dictionaries -- creating user-defined dictionaries -- creating defining -- colors colors -- selection colors -- adding opening -- dialog settings saving -- dialog settings years -- 2-digit options HTML -- fonts for source display Basic -- fonts for source display fonts -- for HTML and Basic views -- defaults defaults -- views settings -- views icons -- sizes icons -- styles WYSIWYG in fonts lists previews -- fonts lists font lists font name box mouse -- positioning clipboard -- selection clipboard selection clipboard OpenGL -- settings OpenGL -- blacklist OpenGL -- whitelist OpenGL -- graphics output notebook bar -- icon size printing -- colors in grayscale grayscale printing colors -- printing in grayscale printing -- warnings paper size warning colors -- appearance options -- appearance appearance options colors -- applications disabled persons text colors for better accessibility animations -- accessibility options Help tips -- hiding high contrast mode accessibility -- options options -- accessibility settings -- proxies proxy settings macros -- selecting security warnings security -- options for documents with macros macros -- security selecting -- security warnings selecting -- security options options -- security warnings -- security Collabora Office Basic scripts in HTML documents HTML -- compatibility settings snap lines -- showing when moving frames (Writer)scrollbars -- horizontal and vertical (Writer)horizontal scrollbars (Writer)vertical scrollbars (Writer)smooth scrolling (Writer)displaying -- pictures and objects (Writer)pictures -- displaying in Writer (Writer)objects -- displaying in text documents displaying -- tables (Writer)tables in text -- displaying limits of tables (Writer)borders -- table boundaries (Writer)boundaries of tables (Writer)showing -- drawings and controls (Writer)drawings -- showing (Writer)controls -- showing (Writer)fields -- displaying field codes (Writer)displaying -- comments in text documents fonts -- default settings defaults -- fonts basic fonts predefining fonts fonts -- changing in templates templates -- changing basic fonts paragraph styles -- modifying basic fonts pictures -- printing tables in text -- printing drawings -- printing in text documents controls -- printing backgrounds -- printing printing -- elements in text documents text documents -- print settings printing -- text always in black black printing in Calc printing -- left/right pages even/odd pages -- printing printing -- text in reverse order reversing printing order brochures -- printing several printing -- brochures comments -- printing in text printing -- creating individual jobs faxes -- selecting a fax machine inserting -- new text tables defaults tables in text -- default settings aligning -- tables in text number formats -- recognition in text tables non-printing characters (Writer)formatting marks (Writer)displaying -- non-printing characters (Writer)displaying -- formatting marks (Writer)paragraph marks -- displaying (Writer)characters -- displaying only on screen (Writer)optional hyphens (Writer)soft hyphens (Writer)hyphens -- displaying custom (Writer)custom hyphens (Writer)spaces -- displaying (Writer)spaces -- showing protected spaces (Writer)protected spaces -- showing (Writer)non-breaking spaces (Writer)tab stops -- displaying (Writer)break display (Writer)hidden text -- showing (Writer)hidden fields display (Writer)paragraphs -- hidden paragraphs (Writer)cursor -- allowing in protected areas (Writer)links -- updating options (Writer)updating -- links in text documents updating -- fields and charts, automatically (Writer)fields -- updating automatically (Writer)charts -- updating automatically (Writer)captions -- tables/pictures/frames/OLE objects (Writer)tables in text -- captions pictures -- captions (Writer)frames -- captions (Writer)OLE objects -- captions (Writer)tab stops -- spacing in text documents spacing -- tab stops in text documents word counts -- separators Word documents -- compatibility importing -- compatibility settings for text import options -- compatibility (Writer)compatibility settings for MS Word import Microsoft Office -- importing Word documents layout -- importing Word documents formatting -- printer metrics (Writer)metrics -- document formatting (Writer)printer metrics for document formatting (Writer)automatic captions (Writer)AutoCaption function in Collabora Office Writer captions -- automatic captions (Writer)grids -- defaults (Writer/Calc)defaults -- grids (Writer/Calc)snap grid defaults (Writer/Calc)cells -- showing grid lines (Calc)borders -- cells on screen (Calc)grids -- displaying lines (Calc)colors -- grid lines and cells (Calc)page breaks -- displaying (Calc)guides -- showing (Calc)displaying -- zero values (Calc)zero values -- displaying (Calc)tables in spreadsheets -- value highlighting cells -- formatting without effect (Calc)cells -- coloring (Calc)anchors -- displaying (Calc)colors -- restriction (Calc)text overflow in spreadsheet cells references -- displaying in color (Calc)objects -- displaying in spreadsheets pictures -- displaying in Calc charts -- displaying (Calc)draw objects -- displaying (Calc)row headers -- displaying (Calc)column headers -- displaying (Calc)scrollbars -- displaying (Calc)sheet tabs -- displaying tabs -- displaying sheet tabs outlines -- outline symbols metrics -- in sheets tab stops -- setting in sheets cells -- cursor positions after input (Calc)edit mode -- through Enter key (Calc)formatting -- expanding (Calc)expanding formatting (Calc)references -- expanding (Calc)column headers -- highlighting (Calc)row headers -- highlighting (Calc)sort lists -- copying to in Calc references -- iterative (Calc)calculating -- iterative references (Calc)iterative references in spreadsheets recursions in spreadsheets dates -- default (Calc)dates -- start 1900/01/01 (Calc)dates -- start 1904/01/01 (Calc)case sensitivity -- comparing cell contents (Calc)decimal places displayed (Calc)precision as shown (Calc)values -- rounded as shown (Calc)rounding precision (Calc)search criteria for database functions in cells Excel -- search criteria compatibility settings -- key bindings (Calc)formula options -- formula syntax formula options -- separators formula options -- reference syntax in string parameters formula options -- recalculating spreadsheets formula options -- large spreadsheet files formula options -- loading spreadsheet files separators -- function separators -- array column separators -- array row recalculating -- formula options recalculating -- large spreadsheet files loading -- large spreadsheet files defaults -- number of worksheets in new documents defaults -- prefix name for new worksheet number of worksheets in new documents prefix name for new worksheet rulers -- visible in presentations moving -- using guide lines in presentations guides -- displaying when moving objects (Impress)control point display in presentations Bézier curves -- control points in presentations snapping in presentations and drawings points -- reducing editing points when snapping (Impress/Draw)printing -- drawings defaults drawings -- printing defaults pages -- printing page names in presentations printing -- dates in presentations dates -- printing in presentations times -- inserting when printing presentations printing -- hidden pages of presentations hidden pages -- printing in presentations printing -- without scaling in presentations scaling -- when printing presentations printing -- fitting to pages in presentations fitting to pages -- print settings in presentations printing -- tiling pages in presentations presentations -- starting with wizard objects -- always moveable (Impress/Draw)distorting in drawings spacing -- tabs in presentations tab stops -- spacing in presentations text objects -- in presentations and drawings printing -- formulas in Collabora Office Math title rows -- printing in Collabora Office Math formula texts -- printing in Collabora Office Math frames -- printing in Collabora Office Math printing -- in original size in Collabora Office Math original size -- printing in Collabora Office Math printing -- fitting to pages in Collabora Office Math format filling printing in Collabora Office Math printing -- scaling in Collabora Office Math scaling -- printing in Collabora Office Math fitting to pages -- print settings in Math charts -- colors colors -- charts Microsoft Office -- importing/exporting VBA code importing -- Microsoft Office documents with VBA code exporting -- Microsoft Office documents with VBA code loading -- Microsoft Office documents with VBA code saving -- VBA code in Microsoft Office documents VBA code -- loading/saving documents with VBA code Visual Basic for Applications -- loading/saving documents with VBA code languages -- locale settings locale settings Asian languages -- enabling languages -- Asian support complex text layout -- enabling Arabic -- language settings Hebrew -- language settings Thai -- language settings Hindi -- language settings decimal separator key date acceptance patterns languages -- setting options kerning -- Asian texts CTL -- options connections to data sources (Base)data sources -- connection settings (Base)Basic IDE -- Autocorrection Basic IDE -- Autocompletion Basic IDE -- Autoclose quotes Basic IDE -- Basic UNO extended types Basic IDE -- Autoclose parenthesis Basic IDE -- options options -- Basic IDE string -- conversion to number settings string conversion to number options string -- conversion to date settings string conversion to date options string -- conversion to reference settings string conversion to reference options string -- setting in spreadsheet formulas cell reference syntax in strings -- Excel R1C1 cell reference syntax in strings -- Excel A1 cell reference syntax in strings -- Calc A1 Excel R1C1 -- cell reference syntax in strings Excel A1 -- cell reference syntax in strings Calc A1 -- cell reference syntax in strings Java -- setting options experimental features unstable options expert configuration -- setting options expert configuration -- setting options security -- security levels for macros macros -- security levels levels -- macro security update options online update options options -- online update online updates -- checking automatically updates -- checking automatically Internet -- checking for updates Open CL -- setting options setting options -- Open CL themes -- setting options setting options -- themes personalization -- Mozilla Firefox Themes personas -- personalization personalization -- personas Mozilla Firefox Themes -- personalization

Tools Bar

Shows or hides the Tools bar.

To access this command...

Choose View - Toolbars - Tools.

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/01/03050000.xhp

Title is: Tools Bar

Module is: SHARED

System is: null