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
→
⇥

Access2BaseMicrosoft 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

Absolute Values

This function returns absolute values.

Abs Function

Returns the absolute value of a numeric expression.

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/sbasic/shared/03080600.xhp

Title is: Absolute Values

Module is: WRITER

System is: Unknown OS