עזרה עבור Collabora Office 24.04

Collabora Office

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

Contents

מסמכי טקסט (Writer)
- מידע כללי ושימוש במנשק המשתמש
- Command and Menu Reference
  - תפריטים
    - תפריטים
    - קובץ
    - עריכה
    - תצוגה
    - הכנסה
    - צורה
    - Table
    - Form Menu
    - Main Tools Menu
    - חלון
    - Help
  - סרגלי כלים
- ניווט במסמכי טקסט
- עיצוב מסמכי טקסט
- תבניות וסגנונות
- גרפיקה במסמכי טקסט
- טבלאות במסמכי טקסט
- עצמים במסמכי טקסט
  - Positioning Objects
  - Wrapping Text Around Objects
- סעיפים ומסגרות במסמכי טקסט
- טבלאות תכנים ואינדקסים
- שדות במסמכי טקסט
- חישוב במסמכי טקסט
- רכיבי טקסט מיוחדים
- פונקציות אוטומטיות
- מספור ורשימות
- בדיקת איות, אגרון מונחים ושפות
- עצות לפתרון בעיות
  - Inserting Text Before a Table at the Top of Page
  - Going to Specific Bookmark
- Loading, Saving, Importing, Exporting and Redacting
- מסמכי הורה
  - Using Master Documents and Subdocuments
- קישורים והפניות
  - Inserting Cross-References
  - Inserting Hyperlinks With the Navigator
- הדפסה
- חיפוש והחלפה
  - Using Regular Expressions in Text Searches
  - List of Regular Expressions

מסמכי HTML‏ (Writer Web)

Spreadsheets (Calc)
- מידע כללי ושימוש במנשק המשתמש
- Command and Menu Reference
  - תפריטים
    - תפריטים
    - קובץ
    - עריכה
    - תצוגה
    - הכנסה
    - צורה
    - Sheet
    - נתונים
    - Main Tools Menu
    - חלון
    - Help
  - סרגלי כלים
- Functions Types and Operators
- Loading, Saving, Importing, Exporting and Redacting
- עיצוב
- Filtering and Sorting
- הדפסה
- טווחי נתונים
- Pivot Table
- Pivot Chart
- Data Analysis
- תרחישים
  - Using Scenarios
- Subtotals
  - Using Subtotals Tool
- References
- Viewing, Selecting, Copying
- Formulas and Calculations
- הגנה
  - Protecting Cells from Changes
  - Unprotecting Cells
- Writing Calc Macros
  - Reading and Writing values to Ranges
  - Formatting Borders in Calc with Macros
- שונות

מצגות (Impress)
- מידע כללי ושימוש במנשק המשתמש
- Command and Menu Reference
  - תפריטים
    - תפריטים
    - קובץ
    - Edit
    - תצוגה
    - הכנסה
    - Format
    - Slide
    - Slide Show
    - Main Tools Menu
    - חלון
    - Help
  - סרגלי כלים
- Loading, Saving, Importing, Exporting and Redacting
- עיצוב
- הדפסה
  - Printing Presentations
  - Printing a Slide to Fit a Paper Size
- אפקטים
- Objects, Graphics, and Bitmaps
- טקסט במצגות
  - Adding Text
  - Converting Text Characters into Drawing Objects
- הצגה
  - Changing the Slide Order
  - Zooming With the Keypad
- מצגות

ציורים (Draw)
- מידע כללי ושימוש במנשק המשתמש
- Command and Menu Reference
  - תפריטים
    - תפריטים
    - קובץ
    - Edit
    - View (menu in Draw)
    - Insert
    - Format
    - Page
    - Shape
    - Main Tools Menu
    - חלון
    - Help
  - סרגלי כלים
- טעינה, שמירה, ייבוא וייצוא
  - Loading Color, Gradient, and Hatching Palettes
  - Inserting Graphics
- עיצוב
- הדפסה
  - Printing Presentations
  - Printing a Slide to Fit a Paper Size
- אפקטים
- Objects, Graphics, and Bitmaps
- קבוצות ושכבות
- טקסט בציורים
  - Adding Text
  - Converting Text Characters into Drawing Objects
- הצגה
  - Zooming With the Keypad

יכולות מסד הנתונים (Base)
- מידע כללי

נוסחאות (Math)
- מידע כללי ושימוש במנשק המשתמש
  - Welcome to the Collabora Office Math Help
  - יכולות Collabora Office קאלק
  - רכיבי נוסחה של Collabora Office
  - Instructions for Using Collabora Office Math
  - Shortcuts (Collabora Office Math Accessibility)
- Command and Menu Reference
  - תפריטים
  - סרגלי כלים
- עבודה עם נוסחאות

תרשימים ודיאגרמות
- מידע כללי

Macros and Scripting

התקנת Collabora Office
- Changing the Association of Microsoft Office Document Types
- Safe Mode

נושאי עזרה נפוצים
- מידע כללי
- Collabora Office ו־Office מבית Microsoft
- אפשרויות Collabora Office
- אשפים
  - Wizard
  - אשף מכתבים
    - Letter Wizard
  - אשף פקס
    - Fax Wizard
  - אשף סדר היום
    - Agenda Wizard
  - אשף המרת המסמכים
    - Document Converter
  - Euro Converter Wizard
- הגדרת Collabora Office
- עבודה עם מנשק המשתמש
- חתימות דיגיטליות
- הדפסה ושליחה גם בפקס
- גרירה והשלכה
- העתקה והדבקה
- תרשימים ודיאגרמות
  - Inserting Charts
  - ברוכים הבאים לסיוע 'קאלק' של Collabora Office
- טעינה, שמירה, ייבוא, ייצוא, PDF
- קישורים והפניות
- מעקב אחר גרסאות המסמכים
- תוויות וכרטיסי ביקור
  - Creating and Printing Labels and Business Cards
- הוספת נתונים חיצוניים
- פונקציות אוטומטיות
  - Turning off Automatic URL Recognition
- חיפוש והחלפה
- מדריכים

⇤
←
1
2
3
4
5
6
→
⇥

= -- in Writer tablesAdd to List Asian languages -- sorting paragraphs/table rows AutoCorrect function -- smart tags AutoCorrect function -- headings AutoCorrect function -- turning off Gallery -- docking and resizing LibreLogo Lists -- merging Logo Navigator -- docking and resizing Navigator -- master documents Navigator -- outline levels and headings OpenOffice.org legacy numbering PDF/UA -- check Protect section -- removing Read-only contents -- editing Styles window -- updating from selections Styles window -- applying styles Styles window -- docking and resizing Stylist, see Styles window Turtle graphics accessibility -- check in text document adjusting page margins arithmetical operators in formulas arranging -- headings aspect ratio -- resizing objects autocorrect -- apply manually automatic changes on/off automatic heading formatting automatic numbering -- of objects backgrounds -- selecting backgrounds -- text objects bookmarks -- inserting borders -- automatic drawing on/off bullet lists -- interrupting bullet lists -- changing levels bullets -- adding and editing calculating -- in text capital letters -- changing to small letters after periods captions -- adding chapter numbers captions -- adding heading numbers captions -- inserting and editing cells -- backgrounds cells -- protecting/unprotecting centering -- frames on pages changes -- automatic changing -- bulleting symbols changing -- indents changing -- starting numbers in lists chapter numbering chapter numbers in captions chapters -- numbering character styles -- style categories characters -- finding all characters direct formatting -- spotlighting chart -- view in text document charts -- labeling checkbox -- content control properties checkbox -- content control clear left -- manual break clear right -- manual break clipboard -- outline to clipboard column breaks -- inserting columns -- breaks in text tables combo box -- content control properties combo box -- content control content control -- properties content control copies -- removing line breaks date -- content control properties date -- content control dates -- formatting automatically in tables defining -- page styles deleting -- line breaks deleting -- heading numbers deleting -- numbers in lists deleting -- page breaks demote level -- in lists demoting outline levels disabling -- smart tags docking -- Navigator window document -- protection from changes draw objects -- inserting captions drop-down list -- content control properties drop-down list -- content control edit -- fields editing -- captions editing -- frames entries -- defining in indexes/tables of contents examples for regular expressions field shadings -- show fields -- editing formatting -- changing individual pages formatting -- indenting paragraphs formatting -- bullets formatting -- ordered lists formatting styles -- importing formulas -- calculating in text formulas -- in text documents frames -- centering on pages frames -- labeling frames -- styles frames -- inserting/editing/linking frames -- linking frames -- linking hanging indents in paragraphs hard returns in pasted text headers -- repeating in tables headings -- numbering/paragraph styles headings -- switching outline levels by keyboard headings -- automatic headings -- rearranging hidden paragraph -- show hide -- outline folding hiding -- rulers horizontal rulers hyphenation -- preventing for specific words images -- view in text document importing -- styles from other files indents -- setting on rulers indents -- in text indexes -- defining entries in indexes -- master documents indexes -- unprotecting inserting -- captions inserting -- manual column breaks inserting -- page breaks inserting -- pictures, by dialog inserting -- chapter numbers in captions inserting -- frames inserting -- numbering installing -- smart tags interrupting numbered lists invisible characters -- finding landscape and portrait languages and locales -- translate legends, see also captions line breaks -- removing line numbers lines -- automatic drawing on/off lines of text -- indents lines of text -- numbering lines of text -- sorting paragraphs linking -- frames links -- frames list styles -- style categories list styles lists -- changing levels lists -- removing/interrupting numbering loading -- styles from other files manual break -- clear left manual break -- clear right manual break -- left manual break -- next full line manual break -- next line manual break -- right manual column breaks manual numbering in text manual page breaks marginal numbers on text pages master documents -- creating/editing/exporting mathematical functions in tables months -- automatically completing moving -- headings multi-page tables navigate backward navigate forward navigator -- outline folding non-printing text number formats -- recognition in text tables numbering -- captions numbering -- changing the level of numbering -- lines numbering -- removing/interrupting numbering -- OpenOffice.org numbering -- headings numbering -- manually/by styles numbering -- paragraphs, on and off numbers -- automatic recognition in text tables numbers -- line numbering objects -- captioning automatically objects -- captioning operators -- in table formulas options -- smart tags orientation of pages outline -- outline to clipboard outline content folding -- enabling outline folding -- with Navigator outline folding -- with mouse outlines -- arranging headings outlines -- numbering overriding next style -- for pages page -- title page page background -- watermark page breaks -- tables page formats -- changing individual pages page margins on rulers page number -- insert quickly page styles -- creating and applying page styles -- orientation/scope page styles -- style categories pages -- inserting/deleting page breaks pages -- number of pages in table formulas pages -- orientation paper orientation paragraph marks -- removing paragraph marks -- searching paragraph styles -- numbering paragraph styles -- style categories paragraphs -- backgrounds paragraphs -- bulleted paragraphs -- indents paragraphs -- moving by keyboard paragraphs -- line numbers paragraphs -- toggle ordered list pictures -- inserting by dialog portrait and landscape previews -- styles printing -- hiding frames from printing printing -- page range printing -- portrait/landscape format printing -- selection promote level -- in lists promoting outline levels protecting -- tables and sections protection -- bookmarks in text documents protection -- fields in text documents quotation marks -- changing automatically rearranging headings recognition -- numbers references -- in Writer tables regular expressions -- searching removing -- bullets in text documents removing -- subdocuments repeating -- table headers after page breaks resizing -- aspect ratio resizing -- frames, by mouse resizing -- windows resolved comments -- view rich text -- content control properties rich text -- content control right indents in paragraphs rotate text rotating -- text rotating text row breaks in text tables rulers -- using rulers scaling -- frames, by mouse scope of page styles searching -- with regular expressions sections -- protecting/unprotecting selecting -- pages to print send -- outline to clipboard separator lines -- AutoCorrect function settings -- word completion show -- field shadings show -- hidden paragraph show -- images and charts show -- outline folding show -- resolved comments show -- table boundaries show -- text boundaries showing -- rulers sideways orientation of pages smart tags sorting -- paragraphs in special languages sorting -- paragraphs/table rows splitting tables -- row breaks spotlight -- styles spotlighting -- characters statistical functions in tables style inspector styles -- importing from other files styles -- updating from selections styles -- categories styles -- for pages styles -- inspector styles -- previews styles spotlight -- visual indicator of styles styles visual indicator -- character spotlighting styles visual indicator -- spotlighting styles subdocuments -- creating/editing/removing switching off -- hyphenation for specific words tab stops -- inserting in lists table -- recognizing number formats table -- properties table boundaries -- view in text document table cells -- date formatting table cells -- adjusting the width on rulers table formulas -- in text documents tables -- allowing page breaks tables -- backgrounds tables -- date formatting tables -- header repetition after page breaks tables -- labeling tables -- number recognition tables -- deleting page breaks before tables -- protecting/unprotecting cells tables -- sorting rows tables -- starting cell with =tables -- text flow around text tables tables of contents -- defining entries in tables of contents -- unprotecting templates -- updating from selections text -- line numbers text -- non-printable text -- sorting paragraphs text -- backgrounds text -- content control properties text -- content control text -- rotating text -- turning off automatic correction text boundaries -- view in text document text documents -- inserting column breaks text documents -- word completion settings text flow -- around text tables text flow -- from frame to frame text frame -- insert text rotating title page -- numbering title pages -- centering text on title pages -- adding title pages -- first page style title pages -- inserting title pages -- modifying translate trigonometric functions in tables turning off automatic correction underlining -- quick unordered lists -- turning on and off unprotecting tables of contents and indexes updating -- styles, from selections uppercase -- changing to lowercase variables -- document properties in table formulas vertical rulers view -- field shadings view -- hidden paragraph view -- images and charts view -- resolved comments view -- table boundaries view -- text boundaries watermark -- page background watermark -- text documents weekdays -- automatically completing word completion -- settings words -- automatic replacement on/off words -- backgrounds words -- wrapping/not wrapping in text wrap -- wrap left wrap -- wrap off wrap -- wrap optimal wrap -- wrap parallel wrap -- wrap right wrap -- wrap through wrap text -- after wrap text -- around objects wrap text -- before wrap text -- none wrap text -- optimal wrap text -- parallel wrap text -- through### error message#N/A error message #NAME error message #REF error message ANOVA -- Analysis toolpack ARABIC function ASC function Analysis toolpack -- ANOVA Analysis toolpack -- Chi-square test Analysis toolpack -- F-test Analysis toolpack -- Fourier analysis Analysis toolpack -- Z-test Analysis toolpack -- analysis of variance Analysis toolpack -- correlation Analysis toolpack -- covariance Analysis toolpack -- descriptive statistics Analysis toolpack -- exponential smoothing Analysis toolpack -- moving average Analysis toolpack -- paired t-test Analysis toolpack -- regression analysis Analysis toolpack -- sampling Analysis toolpack -- t-test AutoCalculate function in sheets AutoCorrect function -- cell contents AutoFormat cell ranges AutoInput function on/off AutoSum button, see sum icon BESSELI function BESSELJ function BESSELK function BESSELY function BETA.INV function BIN2DEC function BIN2HEX function BIN2OCT function Bessel functions CEILING function CEILING.MATH function CEILING.PRECISE function CEILING.XCL function COLOR function CONCAT function CONVERT function CONVERT_OOO function COUNTIFS function Chi-square test -- Analysis toolpack Confidence level -- regression analysis DAVERAGE function DCOUNT function DCOUNTA function DEC2BIN function DEC2HEX function DEC2OCT function DELTA function DGET function DMAX function DMIN function DPRODUCT function DSTDEV function DSTDEVP function DSUM function DURATION function DVAR function DVARP function Data Stream -- Live data stream Data Stream -- Streams Data statistics -- ANOVA Data statistics -- Chi-square test Data statistics -- F-test Data statistics -- Fourier analysis Data statistics -- Z-test Data statistics -- analysis of variance Data statistics -- correlation Data statistics -- covariance Data statistics -- descriptive statistics Data statistics -- exponential smoothing Data statistics -- moving average Data statistics -- paired t-test Data statistics -- regression analysis Data statistics -- sampling Detective EFFECT function ENCODEURL function ERF function ERF.PRECISE function F-test -- Analysis toolpack F2 -- cell edit mode FINDB Function FLOOR function FLOOR.MATH function FLOOR.PRECISE function FLOOR.XCL function FOURIER function Formula Auditing,see Detective Fourier analysis -- Analysis toolpack Function Wizard -- arrays Function Wizard -- databases Function Wizard -- date & time Function Wizard -- text GCD_EXCEL2003 function GESTEP function GROWTH function Gaussian error integral Gaussian error integral Go to sheet HEX2BIN function HEX2DEC function HEX2OCT function IFS function IMCOS function IMSIN function IMTAN function ISO.CEILING function JIS function LCM_EXCEL2003 function MAXIFS function MDETERM function MINIFS function MINVERSE function NETWORKDAYS function NETWORKDAYS.INTL function NETWORKDAYS_EXCEL2003 function OPT_BARRIER function OPT_PROB_HIT function OPT_PROB_INMONEY function OPT_TOUCH function PDURATION function RAND function RAND.NV function RANDBETWEEN function RANDBETWEEN.NV function RAWSUBTRACT function REGEX function REPLACEB Function ROMAN function ROUNDDOWN function ROUNDSIG Function SEARCHB Function STYLE function SUM function SUMPRODUCT function SWITCH function Solver for Nonlinear Problems -- Options Styles window Stylist, see Styles window TEXTJOIN function TRUNC function VALUE function WORKDAY.INTL function XML Source -- load XML data in spreadsheets Z-test -- Analysis toolpack Zoom -- spreadsheet Zoom in -- spreadsheet Zoom out -- spreadsheet absolute addresses in spreadsheets absolute references in spreadsheets add-ins -- analysis functions adding -- numbers in cell ranges address -- of cell addresses -- to cells in other sheets/documents addressing -- relative and absolute adjacent cells -- remove border adjusting array ranges analysis functions analysis of variance -- Analysis toolpack anchor -- image annual net interest rates appending sheets areas, see also cell ranges arithmetical operators array formulas automatic date updates averages -- in Calc databases back-solving backgrounds -- cell ranges borders -- cells calculate -- force recalculation calculate -- recalculate hard calculating -- annual net interest rates calculating -- auto calculating sheets calculating -- conditional calculations calculating -- durations calculating -- averages in Calc databases calculating -- multiple sheets calculating -- sums in Calc databases calculation -- accuracy capital letters -- AutoInput function (in cells)cell -- address cell -- insert date cell -- insert time cell contents -- recalculating cell contents -- AutoCalculate function cell contents -- force recalculation cell contents -- searching in Calc databases cell edit mode cell input -- AutoInput function cell links search cell ranges -- inserting named ranges cell ranges -- selecting for data entries cell references -- ranges concatenation cell references -- ranges intersection cell references -- ranges union cells -- AutoInput function of text cells -- backgrounds cells -- moving by drag and drop cells -- operating in another document cells -- references cells -- borders changing -- input in cells changing -- dates, automatically chart -- pivot chart colors -- calculating in spreadsheets colors -- numerical values colors -- values columns -- freezing columns -- hiding columns -- moving by drag and drop columns, see also cells comparisons -- operators in Calc conditional calculations with arrays conditional formatting -- data bar options convert -- formula to values converting -- binary numbers, into decimal numbers converting -- binary numbers, into hexadecimal numbers converting -- binary numbers, into octal numbers converting -- decimal numbers, into binary numbers converting -- decimal numbers, into hexadecimal numbers converting -- decimal numbers, into octal numbers converting -- hexadecimal numbers, into binary numbers converting -- hexadecimal numbers, into decimal numbers converting -- hexadecimal numbers, into octal numbers converting -- text, into numbers copying -- array formulas copying -- values, to multiple sheets correcting sheets automatically correlation -- Analysis toolpack cosine -- complex number counting column -- satisfying criteria counting row -- satisfying criteria counting rows -- with numeric or alphanumeric values counting rows -- with numeric values covariance -- Analysis toolpack cumulative probability density function -- inverse of data -- inserting in multiple sheets data bar formatting -- data bar options data bar options -- conditional formatting data entry forms -- for spreadsheets data entry forms -- insert data in spreadsheets data provider -- for spreadsheets databases -- functions in Collabora Office Calc date and time functions date formats -- avoiding conversion to date formats -- conversion dates -- updating automatically deactivating -- automatic changes decimal places -- cutting off defining -- AutoFormat styles deleting -- array formulas descriptive statistics -- Analysis toolpack determinants displaying -- sheets divide window -- split division sign, see also operators documents -- references dot products drag and drop -- moving cells duplicate -- sheet durations -- calculating durations -- fixed interest securities editing -- array formulas error codes -- list of error messages -- invalid references events -- sheet only exponential smoothing -- Analysis toolpack exponential trends in arrays file names in headers/footers fill range -- random numbers filling -- selection lists filters -- finding unique values filters -- removing duplicates find text -- FINDB Function footers -- defining forced array handling format -- page formats -- Styles window formats -- automatically formatting spreadsheets formats -- text as numbers formatting -- Styles window formatting -- page formatting -- pivot tables formula bar -- sum function formula to values -- convert formula to values -- recalculate formulas -- arrays formulas -- operators formulas -- recalculating manually formulas -- using double quotation marks formulas -- AutoCalculate function formulas -- force recalculation formulas -- recalculate hard freeze rows and columns freezing -- cells freezing -- first column freezing -- first row freezing rows or columns functions -- array functions functions -- database functions functions -- date & time functions -- text functions functions -- sum function icon goal seeking -- solver grid lines -- sheets headers -- defining headers -- freezing during table split hidden -- sheet hiding -- columns hiding -- rows highlighting -- values in sheets image anchor -- in Calc image anchor in Calc -- changing implicit array handling inline array constants inner products input support in spreadsheets insert data -- data entry forms for spreadsheets insert date -- in cells insert time -- in cell inserting -- cell ranges inserting -- sheets inserting -- cells, by drag and drop inserting -- values intersection reference operator invalid names -- error messages invalid references -- error messages inverse arrays jump -- to given sheet jump -- to previous sheet jump -- to the next sheet line arrangements with cells lowercase letters -- AutoInput function (in cells)mathematical optimization -- solver for Calc mathematical programming -- solver for Calc matrices -- calculations matrices -- functions maximum -- satisfying conditions maximum values in Calc databases merge/merging cells minimum -- satisfying conditions minimum values in Calc databases minus sign, see also operators moving -- cells, rows and columns by drag and drop moving average -- Analysis toolpack multiple sheets multiplication sign, see also operators multiplying -- cell contents in Calc databases net annual interest rates non volatile functions -- force recalculation number completion on/off numbers -- greater than or equal to numbers -- rounding down numbers -- truncate operations research -- solver for Calc operators -- formula functions operators -- in spreadsheet formulas operators -- comparison operators -- precedence of page -- style page styles -- footers page styles -- headers paint can for applying styles paired t-test -- Analysis toolpack pasting -- cell ranges pasting -- values in multiple sheets pivot chart -- creating pivot chart -- deleting pivot chart -- editing pivot chart -- update pivot table -- pivot chart plus sign, see also operators precision -- calculation random numbers -- between limits random numbers -- between 0 and 1 random numbers non-volatile -- between limits random numbers non-volatile -- between 0 and 1 random rumbers -- distribution random rumbers -- fill range range of cells -- defining range operator rawsubtract -- subtraction recalculate -- all formulas in sheets recalculate -- auto calculating sheets recalculate -- formula to values recalculating -- all formulas in sheets recalculating -- auto calculating sheets recognizing -- equal numbers records -- counting in Calc databases reference operators references -- absolute/relative references -- to cells in other sheets/documents references -- to cells regression analysis -- Analysis toolpack regression analysis -- linear regression analysis -- logarithmic regression analysis -- power regression lines -- LINEST function regular expressions -- REGEX function regular expressions -- extracting in spreadsheets relative addresses relative references replace formula with values replace text -- REPLACEB Function rounding -- down to nearest multiple of significance rounding -- down to nearest multiple of significance rounding -- up to multiples of significance rounding -- up to multiples of significance rounding -- up to multiples of significance rows -- freezing rows -- hiding rows -- moving by drag and drop rows, see also cells sampling -- Analysis toolpack scalar products scrolling prevention in tables search text -- SEARCHB Function searching -- links in cells searching -- cell contents in Calc databases searching -- maximum values in columns searching -- minimum values in columns select -- all cells in sheet select -- block of data select -- data area select -- to the next sheet select -- to the previous sheet select -- unprotected cells select -- visible columns selecting -- multiple sheets selection lists -- filling cells share spreadsheet sheet -- go to directly sheet -- search and go to sheet -- duplicate sheet -- events sheet -- grid lines sheet -- hiding sheet navigation bar sheet ranges -- filling sheet references sheet tab submenu sheet tabs -- using sheets -- displaying sheets -- inserting sheets -- jump to sheets -- selecting multiple sheets -- showing multiple sheets -- simultaneous multiple filling sheets -- AutoFormat sheets -- creating shortcut keys -- spreadsheets show -- hidden sheets showing -- columns showing -- rows sine -- complex number slopes, see also regression lines solver for Calc -- CoinMP linear solver solver for Calc -- DEPS evolutionary algorithm solver for Calc -- SCO evolutionary algorithm solver for Calc -- linear solver solver for Calc -- swarm non-linear solver solver for Calc -- options solver sparklines split -- divide window split/splitting cells spreadsheet -- collaboration spreadsheet -- form for inserting data spreadsheet -- share spreadsheets -- backgrounds spreadsheets -- duplicate spreadsheets -- hiding functions spreadsheets -- quick rename spreadsheets -- shortcut keys in spreadsheets -- showing columns spreadsheets -- showing rows spreadsheets -- value highlighting standard deviations in databases -- based on a sample standard deviations in databases -- based on populations standard errors -- array functions style -- page styles -- in Calc styles in spreadsheets subtotals -- using subtotals tool sum icon sums -- cells in Calc databases t-test -- Analysis toolpack tables -- AutoFormat tables -- backgrounds tables -- deactivating automatic changes in tables -- freezing tables -- splitting windows tangent -- complex number text completion on/off text concatenation text functions -- convert roman numbers text functions -- convert text to numeric value text functions -- convert to roman numbers text functions -- katakana characters text in cells -- functions text in cells -- AutoInput function text operators time format conversion title rows -- freezing during table split toggle merge and center cells traces -- precedents and dependents union reference operator unmerge/unmerging cells using double quotation marks in formulas values -- inserting in multiple cells values -- highlighting variances -- based on populations variances -- based on samples views -- multiple sheets what if operations -- solver wildcards -- examples wildcards in formulas windows -- splitting word completion on/off אלגוריתם לסידור טבעי כללים לסידור ספר טלפונים סידור -- אפשרויות לטווחי מסדי נתונים סידור -- שפות אסיאתיות שפות אסיאתיות -- סידורAlbum -- Impress Photo AlbumDrawing JPEG export Impress Photo Album Impress Remote -- connecting to computer Impress Remote -- controlling slide show Impress Remote -- remote connection dialog Impress Remote -- settings Impress Remote -- using Impress slide show -- remote control Kiosk -- Impress Photo Album Multimedia show -- Impress Photo Album Photo Album Presentation JPEG export Presenter Console shortcuts Slideshow -- Impress Photo Album Styles window -- graphics documents automatic slide shows automatic slide transition backgrounds -- changing backgrounds -- normal view backgrounds -- pages backgrounds -- slides bitmaps -- converting to vector graphics bullets -- Draw bullets -- Impress changing -- slide layouts converting -- bitmaps to polygons copying -- slides date on all slides editing -- guides and snap points fill format mode -- styles footers -- master slides gluepoints -- using guides -- editing headers and footers -- master slides headers and footers -- master slides layouts inserting -- slides from files inserting -- slides inserting -- headers/footers in all slides master pages -- changing backgrounds master pages -- designing master pages master slide view master slides -- changing backgrounds master slides -- designing master slides -- headers and footers master slides layouts with headers and footers master slides multiple displays normal view -- backgrounds object bars -- editing gluepoints ordered list -- Draw ordered list -- Impress page designs page numbers on all slides pages -- backgrounds pages -- copying pages -- changing backgrounds pages -- pane pane -- pages pane -- slides pasting -- slides from other presentations presentation -- remote control connections presentations -- settings for presentations -- starting presentations -- window / full screen presenter console -- slide show remote control -- Bluetooth connection remote control -- controlling slide show running slide shows showing -- slide shows slide designs slide layouts slide numbers on all slides slide show -- presenter console slide shows -- settings for slide shows -- starting slide transitions -- automatic slides -- backgrounds slides -- copying between documents slides -- inserting slides -- changing backgrounds slides -- pane snap guides and point -- editing starting -- slide shows time and date on all slides unordered list -- Draw unordered list -- Impress vector graphics -- converting bitmaps vectorizing bitmaps views -- master slide viewcolors -- definingcombine text box -- text box consolidation combine text frames -- text box consolidation copying -- text from other documents custom colors hiding -- layers insert layer inserting -- text box join PDF lines -- text box consolidation layers -- definition layers -- insert layers -- modify layers -- moving objects layers -- renaming layers -- working with legends -- drawings locking layers modify layer moving -- between layers objects -- moving in layers pasting -- text from other documents renaming layers selecting -- layers showing -- hidden layers text box consolidation text box unlocking layers user-defined colorsADO databases (Base)Access databases (base)Collabora Office Base data sources Database Wizard (Base)Firebird -- database settings (Base)Firebird connection Firebird server -- setup connection JDBC -- databases (Base)MS ADO interface (Base)Macro Wizard (Base)MariaDB databases (Base)MariaDB settings (Base)Microsoft Office -- Access databases (base)MySQL databases (Base)MySQL settings (Base)ODBC -- data sources (Base)Oracle Report Builder Oracle databases (base)PostgreSQL -- database settings (Base)PostgreSQL settings (Base)Report Builder SQL -- executing SQL statements (Base)SQL -- queries (Base)Table Wizard (Base)access rights for database tables (Base)add fields -- in report design cascading update (Base)criteria of query design (Base)dBASE -- database settings (Base)data sources -- Collabora Office Base data sources -- ODBC (Base)database -- special settings database advanced properties -- autoincrement values database advanced properties -- automatic generated values database advanced properties -- query generated values database advanced properties -- retrieve generated values database connection -- Firebird server database settings -- ODBC date/time database settings -- SQL92 naming database settings -- keyword AS database settings -- line ends database settings -- outer join syntax database settings -- special SELECT statements database settings -- support primary keys database settings -- version columns databases -- JDBC (Base)databases -- administration through SQL (Base)databases -- connecting (Base)databases -- formats (Base)databases -- ADO (Base)databases -- connection settings databases -- drag and drop (Base)databases -- main page (Base)design view -- queries/views (Base)designing -- queries (Base)external keys (Base)filter conditions -- in queries (Base)forms -- designing (Base)forms -- general information (Base)formulas in reports -- editing full joins (Base)functions in reports -- editing inner joins (Base)insert fields -- in report design jdbc -- database settings (Base)joining -- tables (Base)joins in databases (Base)key fields for relations (Base)keys -- primary keys (Base)left joins (Base)links -- relational databases (Base)macros -- attaching new (Base)migrating macros (Base)native SQL (Base)odbc -- database settings (Base)parameters -- queries (Base)placeholders -- in SQL queries primary keys -- defining primary keys -- inserting (Base)printing -- queries (Base)queries -- copying (Base)queries -- creating in design view (Base)queries -- deleting table links (Base)queries -- formulating filter conditions (Base)queries -- joining tables (Base)queries -- missing elements (Base)queries -- parameter queries (Base)queries -- printing (Base)queries -- overview (Base)relational databases (Base)relations -- creating and deleting (Base)relations -- joining tables (Base)relations -- properties (Base)report design -- add fields to report right joins (Base)spreadsheets -- as databases (Base)tables in databases -- access rights to (Base)tables in databases -- copying database tables (Base)tables in databases -- joining for queries (Base)tables in databases -- printing queries (Base)tables in databases -- relations (Base)tables in databases -- importing text formats (Base)text databases (Base)views -- creating database views (Base)wizards -- database tables (Base)wizards -- databases (Base)wizards -- macros (Base)Collabora Office Math -- relationsColor in formulas Hex colors List of predefined colors MathML -- import from file MathML -- import via clipboard RGB colors accents -- in Collabora Office Math approximately equal to relation attributes -- accents attributes -- changing defaults attributes -- changing fonts attributes -- colored characters attributes -- in Collabora Office Math attributes -- list of bold attribute brackets and grouping in Math changing -- fonts chemical formula circle attribute circumflex attribute colored characters congruent relation considerably greater than relation considerably less than relation correspondence -- original by correspondence -- picture by defined as relation direct text -- entering in Collabora Office Math divides relation does not divide relation dot attribute double arrow symbols double dot attribute elements -- in Math equal sign formulas -- attributes in formulas -- selections functions operators -- list of greater than or equal to signs greater than relations grouping and brackets in Math harpoon arrow attribute identical to relation image of relation importing -- MathML inequation inserting -- text in Collabora Office Math integral limits italic attribute in Collabora Office Math less than or equal to signs less than relations limits -- in sums/integrals line above attribute line through attribute logic symbols much greater than relation much less than relation not precedes relation not succeeds relation operators -- list of original by correspondence orthogonal relations other operators -- list of overline attribute parallel relation picture by correspondence precedes or equal relation precedes or equivalent relation precedes relation proportional to relation relations -- in Collabora Office Math relations operators -- list of resizing -- fonts reversed circumflex attribute right angled relations scaling -- fonts selection options in formulas set operators -- list of similar to relations succeeds or equal relation succeeds or equivalent relation succeeds relation text strings -- entering in Collabora Office Math tilde as attribute toward relation transparent character as attribute triple dot attribute underline attribute unequal sign vector arrows as attributes wide circumflex attribute wide harpoon arrow attribute wide tilde attribute wide vector arrow attribute3D chartsXY charts area charts averages in charts bar charts bubble charts calculating -- regression curves chart -- data tables chart -- remove data table chart types -- XY (scatter)chart types -- area chart types -- bubble chart types -- column and bar chart types -- column and line chart types -- line chart types -- net chart types -- pie/donut chart types -- stock charts -- 3D views charts -- choosing chart types column and line charts column charts combination charts curves -- properties in line charts/XY charts curves -- properties in line charts/XY charts data ranges in charts data series data sources -- setting for stock charts donut charts error bars in charts error indicators in charts illumination -- 3D charts insert data tables in charts line charts mean value lines in charts net charts order of chart data pie charts -- types properties -- smooth lines in line charts/XY charts properties -- stepped lines in line charts/XY charts radar charts, see net charts regression curves in charts scatter charts standard deviation in charts statistics in charts stock charts trend lines in charts variances in charts"& or +" concatenation (strings)"\" operator (mathematical)API -- BasicLibraries API -- Database document API -- Desktop API -- DialogLibraries API -- XDocumentEventListener API -- ActionEvent API -- ConfigurationAccess API -- DateTime API -- DialogProvider API -- DialogProvider2 API -- Duration API -- EventObject API -- ExecutableDialogResults API -- FilePicker API -- FilePicker API -- GlobalScope.BasicLibraries API -- ODatabaseDocument API -- OfficeFilePicker API -- PathSettings API -- PathSubstitution API -- PropertyValue API -- SimpleFileAccess API -- SimpleFileAccess API -- UnoControlDialog API -- UnoControlDialogModel API -- XActionListener API -- XComponent API -- XDialogEventHandler API -- XScript API -- XScriptProvider: Retrieving Basic scripts API -- awt.XControl API -- awt.XControl API -- awt.XControlModel API -- awt.XControlModel API -- document.DocumentEvent: Monitoring Document Event API -- document.XDocumentEventBroadcaster: Monitoring Document Event API -- document.XDocumentEventListener: Monitoring Document Event API -- frame.Desktop: Monitoring Document Event API -- frame.GlobalEventBroadcaster: Monitoring Document Event API -- lang.EventObject: Monitoring Document Event API -- script.provider.MasterScriptProvider: Screen Input/Output API -- script.provider.MasterScriptProviderFactory: Monitoring Document Event API -- script.provider.MasterScriptProviderFactory: Retrieving Basic scripts API -- script.provider.XScript : Executing Basic scripts API -- script.provider.XScript: Executing Basic scripts API -- script.provider.XScript: Monitoring Document Event API -- script.provider.XScript: Screen Input/Output API -- sheet.FunctionAccess API -- sheet.addin.Analysis APSO Access databases -- run in Base Access2Base -- Console Access2Base -- Trace Access2Base -- _DumpToFile Access2Base -- dlgTrace Access2Base Alternative Python Scripts Organizer Array service -- Append Array service -- AppendColumn Array service -- AppendRow Array service -- Contains Array service -- ConvertToDictionary Array service -- Copy Array service -- CountDims Array service -- Difference Array service -- ExportToTextFile Array service -- ExtractColumn Array service -- ExtractRow Array service -- Flatten Array service -- ImportFromCSVFile Array service -- IndexOf Array service -- Insert Array service -- InsertSorted Array service -- Intersection Array service -- Join2D Array service -- Prepend Array service -- PrependColumn Array service -- PrependRow Array service -- RangeInit Array service -- Reverse Array service -- Shuffle Array service -- Slice Array service -- Sort Array service -- SortColumns Array service -- SortRows Array service -- Transpose Array service -- TrimArray Array service -- Union Array service -- Unique Array service AscW function BASIC Euro library BASIC Gimmicks library BASIC ImportWizard library BASIC Schedule library BASIC ScriptBindingLibrary library BASIC ScriptForge 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 Tools library BASIC WikiEditor library Base Service -- OpenQuery Base Service -- OpenTable Base service -- CloseFormDocument Base service -- FormDocuments Base service -- Forms Base service -- GetDatabase Base service -- IsLoaded Base service -- OpenFormDocument Base service -- PrintOut Base service -- SetPrinter Base service Basic -- Calling Python Basic -- Dialog Handler Basic -- Event Listener Basic -- Monitoring Document Events Basic -- programming examples Basic Mathematical constants Basic Object constants Basic Variable Type constants Basic constant -- Empty Basic constant -- False Basic constant -- Nothing Basic constant -- Null Basic constant -- Pi Basic constant -- True Basic constants Basic service -- CDate Basic service -- CDateFromUnoDateTime Basic service -- CDateToUnoDateTime Basic service -- ConvertFromUrl Basic service -- ConvertToUrl Basic service -- CreateUnoService Basic service -- CreateUnoStruct Basic service -- DateAdd Basic service -- DateDiff Basic service -- DatePart Basic service -- DateValue Basic service -- Format Basic service -- GetDefaultContext Basic service -- GetGuiType Basic service -- GetPathSeparator Basic service -- GetSystemTicks Basic service -- GlobalScope.BasicLibraries Basic service -- GlobalScope.DialogLibraries Basic service -- InputBox Basic service -- MsgBox Basic service -- Now Basic service -- RGB Basic service -- Xray Basic service BasicLibraries -- library container Boolean Basic constants Calc service -- A1Style Calc service -- Activate Calc service -- Charts Calc service -- ClearAll Calc service -- ClearFormats Calc service -- ClearValues Calc service -- CompactLeft Calc service -- CompactUp Calc service -- CopySheet Calc service -- CopySheetFromFile Calc service -- CopyToCell Calc service -- CopyToRange Calc service -- CreateChart Calc service -- CreatePivotTable Calc service -- DAvg Calc service -- DCount Calc service -- DMax Calc service -- DMin Calc service -- DSum Calc service -- ExportRangeToFile Calc service -- Forms Calc service -- GetColumnName Calc service -- GetFormula Calc service -- GetValue Calc service -- ImportFromCSVFile Calc service -- ImportFromDatabase Calc service -- InsertSheet Calc service -- MoveRange Calc service -- MoveSheet Calc service -- Offset Calc service -- OpenRangeSelector Calc service -- PrintOut Calc service -- Printf Calc service -- RemoveDuplicates Calc service -- RemoveSheet Calc service -- RenameSheet Calc service -- SetArray Calc service -- SetCellStyle Calc service -- SetFormula Calc service -- SetValue Calc service -- ShiftDown Calc service -- ShiftLeft Calc service -- ShiftRight Calc service -- ShiftUp Calc service -- SortRange Calc service CallByName function Case keyword -- in Select Case statement Chart service -- ChartType Chart service -- Deep Chart service -- Dim3D Chart service -- Exploded Chart service -- ExportToFile Chart service -- Filled Chart service -- Legend Chart service -- Percent Chart service -- Resize Chart service -- Stacked Chart service -- Title Chart service -- XChartObj Chart service -- XDiagram Chart service -- XShape Chart service -- XTableChart Chart service -- XTitle Chart service -- YTitle Chart service ChrW function Collection -- Add Collection -- Count Collection -- Item Collection -- Remove Collection Object CompatibilityMode Compiler Options CreateUnoService function -- calling Calc function CreateUnoService function CreateUnoServiceWithArguments function DDB function Database Service -- CloseDatabase Database Service -- Commit Database Service -- CreateDataset Database Service -- DAvg Database Service -- DCount Database Service -- DLookup Database Service -- DMax Database Service -- DMin Database Service -- DSum Database Service -- GetRows Database Service -- OpenQuery Database Service -- OpenSql Database Service -- OpenTable Database Service -- Queries Database Service -- Rollback Database Service -- RunSql Database Service -- SetTransactionMode Database Service -- Tables Database service -- Transaction handling Database service -- OpenFormDocument Database service Dataset service -- BOF property Dataset service -- CloseDataset Dataset service -- CreateDataset Dataset service -- DefaultValues property Dataset service -- Delete Dataset service -- EOF property Dataset service -- ExportValueToFile Dataset service -- Fields property Dataset service -- Filter property Dataset service -- GetRows Dataset service -- GetValue Dataset service -- Insert Dataset service -- MoveFirst Dataset service -- MoveLast Dataset service -- MoveNext Dataset service -- MovePrevious Dataset service -- OrderBy property Dataset service -- ParentDatabase property Dataset service -- Reload Dataset service -- RowCount property Dataset service -- RowNumber property Dataset service -- Source property Dataset service -- SourceType property Dataset service -- UpdatableFields property Dataset service -- Update Dataset service -- Values property Dataset service -- XRowSet property Dataset service Datasheet service -- Activate Datasheet service -- CloseDatasheet Datasheet service -- CreateMenu Datasheet service -- GetText Datasheet service -- GetValue Datasheet service -- GoToCell Datasheet service -- RemoveMenu Datasheet service -- Toolbars Datasheet service Date function Dialog service -- Activate Dialog service -- Center Dialog service -- CloneControl Dialog service -- Controls Dialog service -- CreateButton Dialog service -- CreateCheckBox Dialog service -- CreateComboBox Dialog service -- CreateCurrencyField Dialog service -- CreateDateField Dialog service -- CreateFileControl Dialog service -- CreateFixedLine Dialog service -- CreateFixedText Dialog service -- CreateFormattedField Dialog service -- CreateGroupBox Dialog service -- CreateHyperlink Dialog service -- CreateImageControl Dialog service -- CreateListBox Dialog service -- CreateNumericField Dialog service -- CreatePatternField Dialog service -- CreateProgressBar Dialog service -- CreateRadioButton Dialog service -- CreateScrollBar Dialog service -- CreateTableControl Dialog service -- CreateTextField Dialog service -- CreateTimeField Dialog service -- CreateTreeControl Dialog service -- EndExecute Dialog service -- Execute Dialog service -- GetTextsFromL10N Dialog service -- OrderTabs Dialog service -- Resize Dialog service -- SetPageManager Dialog service -- Terminate Dialog service DialogControl service -- AddSubNode DialogControl service -- AddSubTree DialogControl service -- CreateRoot DialogControl service -- FindNode DialogControl service -- Resize DialogControl service -- SetFocus DialogControl service -- SetTableData DialogControl service -- WriteLine DialogControl service DialogLibraries -- library container Dictionary service -- Add Dictionary service -- ConvertToArray Dictionary service -- ConvertToJson Dictionary service -- ConvertToPropertyValues Dictionary service -- Exists Dictionary service -- ImportFromJson Dictionary service -- ImportFromPropertyValues Dictionary service -- Item Dictionary service -- Remove Dictionary service -- RemoveAll Dictionary service -- ReplaceItem Dictionary service -- ReplaceKey Dictionary service DoEvents function Document service -- Activate Document service -- CloseDocument Document service -- CreateMenu Document service -- CustomProperties property Document service -- DeleteStyles Document service -- Description property Document service -- DocumentProperties property Document service -- DocumentType property Document service -- Echo Document service -- ExportAsPDF Document service -- ExportFilters property Document service -- FileSystem property Document service -- Forms Document service -- ImportFilters property Document service -- ImportStylesFromFile Document service -- IsBase property Document service -- IsCalc property Document service -- IsDraw property Document service -- IsFormDocument property Document service -- IsImpress property Document service -- IsMath property Document service -- IsWriter property Document service -- Keywords property Document service -- PrintOut Document service -- Readonly property Document service -- RemoveMenu Document service -- RunCommand Document service -- Save Document service -- SaveAs Document service -- SaveCopyAs Document service -- SetPrinter Document service -- StyleFamilies property Document service -- Styles Document service -- Subject property Document service -- Title property Document service -- Toolbars Document service -- XComponent property Document service -- XDocumentSettings property Document service -- XStyles Document service Else -- If statement Else -- If statement Else If -- If statement ElseIf -- If statement Empty -- Basic constant End If -- If statement EndIf -- If statement Enum statement Erase statement Err object Error -- handling Error -- raising Exception service -- Clear Exception service -- Console Exception service -- ConsoleClear Exception service -- ConsoleToFile Exception service -- DebugDisplay Exception service -- DebugPrint Exception service -- PythonPrint Exception service -- PythonShell Exception service -- Raise Exception service -- RaiseWarning Exception service FV function FileSystem service -- BuildPath FileSystem service -- CompareFiles FileSystem service -- ConfigFolder property FileSystem service -- CopyFile FileSystem service -- CopyFolder FileSystem service -- CreateFolder FileSystem service -- DeleteFile FileSystem service -- DeleteFolder FileSystem service -- ExtensionFolder FileSystem service -- ExtensionsFolder property FileSystem service -- FileExists FileSystem service -- FileNaming property FileSystem service -- Files FileSystem service -- Files FileSystem service -- FolderExists FileSystem service -- GetBaseName FileSystem service -- GetExtension FileSystem service -- GetFileLen FileSystem service -- GetFileModified FileSystem service -- GetName FileSystem service -- GetParentFolderName FileSystem service -- GetTempName FileSystem service -- HashFile FileSystem service -- HomeFolder property FileSystem service -- InstallFolder property FileSystem service -- MoveFile FileSystem service -- Normalize FileSystem service -- PickFile FileSystem service -- PickFolder FileSystem service -- TemplatesFolder property FileSystem service -- TemporaryFolder property FileSystem service -- UserTemplatesFolder property FileSystem service FolderSystem service -- CreateTextFile FolderSystem service -- MoveFolder FolderSystem service -- OpenTextFile For Each statement For statement Form service -- Activate Form service -- CloseFormDocument Form service -- Controls Form service -- GetDatabase Form service -- MoveFirst Form service -- MoveLast Form service -- MoveNew Form service -- MoveNext Form service -- MovePrevious Form service -- Requery Form service -- Subforms Form service FormControl service -- Controls FormControl service -- SetFocus FormControl service FormDocument service -- CloseDocument FormDocument service -- Forms FormDocument service -- PrintOut FormDocument service FormEvent service FormatDateTime function FormatNumber function FormatPercent function Frac function GLOBAL variables GetPathSeparator function Global keyword GlobalScope specifier GlobalScope GoSub...Return statement GoTo statement IIf function IPmt function IRR function If statement In keyword InStrRev function Input function Is Operator L10N service -- AddText L10N service -- AddTextsFromDialog L10N service -- ExportToPOTFile L10N service -- Folder L10N service -- GetText L10N service -- Languages L10N service -- Locale L10N service Library container MIRR function Menu service -- AddCheckBox Menu service -- AddItem Menu service -- AddRadioButton Menu service Microsoft Access -- Access2Base Microsoft Excel macros support -- Enable Microsoft Excel macros support -- Option VBASupport statement MonthName function NPV function NPer function New Operator Next keyword Nothing -- Basic constant Null -- Basic constant On...GoSub statement On...GoTo statement Operators -- Integer division (\)Operators -- comparison Operators -- concatenation (& or +)Operators -- equal sign (=)Operators -- greater than (>)Operators -- greater than or equal to (>=)Operators -- less than (<)Operators -- less than or equal to (<=)Operators -- not equal to (<>)Option ClassModule Option Compatible Option VBASupport statement PPmt function PRIVATE variables PUBLIC variables PV function ParamArray Partition Function Pi -- Basic constant Platform -- ComputerName Platform -- OSName Platform -- isLinux Platform -- isMacOsX Platform -- isWindows Platform service -- Architecture Platform service -- CPUCount Platform service -- ComputerName Platform service -- CurrentUser Platform service -- Extensions Platform service -- Fonts Platform service -- FormatLocale Platform service -- Locale Platform service -- Machine Platform service -- OSName Platform service -- OSPlatform Platform service -- OSRelease Platform service -- OSVersion Platform service -- OfficeLocale Platform service -- OfficeVersion Platform service -- Printers Platform service -- Processor Platform service -- PythonVersion Platform service -- SystemLocale Platform service -- UserData Platform service Pmt function PopupMenu service -- AddCheckBox PopupMenu service -- AddItem PopupMenu service -- AddRadioButton PopupMenu service -- Execute PopupMenu service PopupService service -- ShortcutCharacter PopupService service -- ShortcutCharacter PopupService service -- SubmenuCharacter PopupService service -- SubmenuCharacter Print statement -- Spc function Print statement -- Tab function Print statement Property statement Python -- Calling Basic Python -- Dialog Handler Python -- Event Listener Python -- InputBox Python -- Modules Python -- Monitoring Document Events Python -- MsgBox Python -- Print Python -- Programming Python -- Shell Python -- createUnoListener Python -- dialogs Python -- examples Python -- import Python -- macros Python -- platform Python -- pythonpath Python -- screen input/output Python -- session Python Interactive Shell Python console Python interpreter -- PYTHONPATH Python scriptforge module Python scripts with ScriptForge PythonLibraries QBColor function RGB function [VBA]RGB function Rate function Region service -- Country Region service -- Currency Region service -- DSTOffset Region service -- DatePatterns Region service -- DateSeparator Region service -- DayAbbrevNames Region service -- DayNames Region service -- DayNarrowNames Region service -- DecimalPoint Region service -- Language Region service -- ListSeparator Region service -- LocalDateTime Region service -- LongMessage Region service -- MonthAbbrevNames Region service -- MonthNames Region service -- MonthNarrowNames Region service -- Number2Text Region service -- ReturnCode Region service -- ThousandSeparator Region service -- TimeSeparator Region service -- TimeZoneOffset Region service -- UTCDateTime Region service -- UTCNow Region service -- Verbose Region service -- WhenAssertionFails Region service Replace function Resume statement Round function (VBA)Runtime conditions SLN function SYD function ScriptForge -- Method signatures ScriptForge -- list of methods ScriptForge -- list of properties Select Case statement Services service -- CreateScriptService Services service Session -- SharedPythonScripts Session -- SharedScripts Session -- UserName Session -- UserProfile Session -- UserPythonScripts Session -- UserScripts Session service -- ExecuteBasicScript Session service -- ExecuteCalcFunction Session service -- ExecutePythonScript Session service -- GetPDFExportOptions Session service -- HasUnoMethod Session service -- HasUnoProperty Session service -- OpenURLInBrowser Session service -- RunApplication Session service -- SendMail Session service -- SetPDFExportOptions Session service -- UnoMethods Session service -- UnoObjectType Session service -- UnoProperties Session service -- WebService Session service Space function Spc function -- in Print statement Spc function StarDesktop Statements syntax -- How to read Step keyword StrConv function StrReverse function String service -- Capitalize String service -- Count String service -- EndsWith String service -- Escape String service -- ExpandTabs String service -- FilterNotPrintable String service -- FindRegex String service -- HashStr String service -- HtmlEncode String service -- IsADate String service -- IsAlpha String service -- IsAlphanum String service -- IsAscii String service -- IsDigit String service -- IsEmail String service -- IsFileName String service -- IsHexDigit String service -- IsIBAN String service -- IsIPv4 String service -- IsLike String service -- IsLower String service -- IsPrintable String service -- IsRegex String service -- IsSheetName String service -- IsTitle String service -- IsUpper String service -- IsUrl String service -- IsWhitespace String service -- JustifyCenter String service -- JustifyLeft String service -- JustifyRight String service -- Quote String service -- ReplaceChar String service -- ReplaceRegex String service -- ReplaceStr String service -- Represent String service -- Reverse String service -- SplitLines String service -- SplitNotQuoted String service -- StartsWith String service -- TrimExt String service -- Unescape String service -- Unquote String service -- Wrap String service Syntax diagrams -- How to read Tab function -- in Print statement TextStream service -- AtEndOfStream TextStream service -- CloseFile TextStream service -- Encoding TextStream service -- FileName TextStream service -- IOMode TextStream service -- Line TextStream service -- NewLine TextStream service -- ReadAll TextStream service -- ReadLine TextStream service -- SkipLine TextStream service -- WriteBlankLines TextStream service -- WriteLine TextStream service The Any type The Variant type ThisComponent object ThisDatabaseDocument Time function Timer service -- Continue Timer service -- Restart Timer service -- Start Timer service -- Suspend Timer service -- Terminate Timer service To keyword Toolbar service -- BuiltIn property Toolbar service -- Docked property Toolbar service -- HasGlobalScope property Toolbar service -- Name property Toolbar service -- ResourceURL property Toolbar service -- ToolbarButtons Toolbar service -- Visible property Toolbar service -- XUIElement property Toolbar service ToolbarButton service -- Caption property ToolbarButton service -- Execute ToolbarButton service -- Height property ToolbarButton service -- Index property ToolbarButton service -- OnClick property ToolbarButton service -- Parent property ToolbarButton service -- TipText property ToolbarButton service -- Visible property ToolbarButton service -- Width property ToolbarButton service -- X property ToolbarButton service -- Y property ToolbarButton service Tools -- GetRegistryContent Tools -- LoadDialog Tools -- LoadDialog Tools -- Strings Type statement TypeName function Typographical conventions UI service -- Activate UI service -- CreateBaseDocument UI service -- CreateDocument UI service -- GetDocument UI service -- Maximize UI service -- Minimize UI service -- OpenBaseDocument UI service -- OpenDocument UI service -- Resize UI service -- RunCommand UI service -- SetStatusbar UI service -- ShowProgressBar UI service -- WindowExists UI service UNO functions UNO objects UnitTest service -- AssertAlmostEqual UnitTest service -- AssertEqual UnitTest service -- AssertFalse UnitTest service -- AssertGreater UnitTest service -- AssertGreaterEqual UnitTest service -- AssertIn UnitTest service -- AssertIsInstance UnitTest service -- AssertIsNothing UnitTest service -- AssertIsNull UnitTest service -- AssertLess UnitTest service -- AssertLessEqual UnitTest service -- AssertLike UnitTest service -- AssertNotAlmostEqual UnitTest service -- AssertNotEqual UnitTest service -- AssertNotIn UnitTest service -- AssertNotInstance UnitTest service -- AssertNotLike UnitTest service -- AssertNotNothing UnitTest service -- AssertNotNull UnitTest service -- AssertNotRegex UnitTest service -- AssertRegex UnitTest service -- AssertTrue UnitTest service -- Fail UnitTest service -- Log UnitTest service -- ReportError UnitTest service -- RunTest UnitTest service -- SkipTest UnitTest service VBA Exclusive constants VBA Functions -- Date and Time Functions VBA Functions -- Financial Functions VBA Functions -- I/O Functions VBA Functions -- Introduction VBA Functions -- Mathematical Functions VBA Functions -- Object Properties and Methods VBA Functions -- Text Functions VBA Functions -- formatting numbers VBA Functions -- partitioning numbers VBA Statements VBA Support -- Option VBASupport statement VBA Variable Type Named Constants VBA compatibility mode VarType function Visual Basic constants WaitUntil statement WeekdayName function While -- While Wend loop While -- While...Wend loop Writer service -- PrintOut Writer service XOR operator (logical)XSCRIPTCONTEXT -- Python XSCRIPTCONTEXT -- getComponentContext XSCRIPTCONTEXT -- getDesktop XSCRIPTCONTEXT -- getDocument adding libraries ampersand symbol -- in literal notation ampersand symbol -- in string handling arrays -- declaring assigning macros to events calling Calc function -- macros comparison operators -- Collabora Office Basic components -- addressing constant groups constants controls -- reading or editing properties (example)copying -- modules declaring variables defining -- constants deleting -- macro assignments to events deleting -- libraries/modules/dialogs dialog box -- Python dialog editor -- programming examples for controls dialogs -- Python dialogs -- displaying (example)dialogs -- loading (example)dialogs -- organizing dialogs -- translating dialogs -- using Basic to show (example)documents -- events enumerations events -- assigning macros events -- in documents examples -- programming controls examples -- showing a dialog with Basic filepicker -- API service functions -- return value type functions -- using label -- in GoSub...Return statement label -- in GoTo statement label -- in On...GoSub statement label -- in On...GoTo statement libraries -- containers libraries -- organizing library systems list boxes -- adding entries to (example)list boxes -- removing entries from (example)literals -- &h notation literals -- &o notation literals -- date literals -- floating point literals -- hexadecimal literals -- integer literals -- octal localizing dialogs macros -- assigning to events macros -- Python scripts macros -- calling Calc function macros -- format borders macros -- read values from cells macros -- setting Calc function macros -- write values to cells module/dialog toggle modules -- organizing moving -- modules names of variables organizing -- modules/libraries/dialogs parameters -- for procedures, functions or properties parameters -- passing by reference or value procedures programming -- UNO objects programming examples for controls python -- IDE - integrated development environment python -- editor renaming modules and dialogs return value type of functions scope of variables scripts -- Python setting Calc function -- macros translating dialogs types of variables uno.py -- Enum uno.py -- absolutize uno.py -- createUnoStruct uno.py -- fileUrlToSystemPath uno.py -- getClass uno.py -- getComponentContext uno.py -- getComponentContext uno.py -- getConstantByName uno.py -- getDesktop uno.py -- getDocument uno.py -- isInterface uno.py -- systemPathToFileUrl uno.py values -- of variables variables -- using variables -- passing to procedures, functions, properties variables -- scope מאפיינים -- פקדים בעורך תיבת הדו־שיח משנים -- שליטה על המאפיינים עורך תיבות דו־שיח -- יצירת פקדים עורך תיבות דו־שיח -- שינוי מאפייני פקדים פקדים -- יצירה בעורך תיבות הדו־שיח פקדים -- שינוי המאפיינים תיבות דו־שיח -- יצירת תיבות דו־שיח בסיסיות3D EffectsAPI -- XConfirmDeleteListener API -- XDatabaseParameterListener API -- XLoadListener API -- XResetListener API -- XRowSetApproveListener API -- XRowSetListener API -- XSQLErrorListener API -- XSubmissionVetoListener API -- XSubmitListener API -- XUpdateListener Arabic -- languages and locales Asian languages -- enabling AutoComplete function in text and list boxes AutoComplete, see also AutoCorrect/AutoInput AutoCorrect function -- context menu AutoCorrect function -- options AutoCorrect function -- quotes AutoCorrect function -- switching on and off AutoFormat function for tables Basic -- recording macros Basic IDE -- Autoclose parenthesis Basic IDE -- Autoclose quotes Basic IDE -- Autocompletion Basic IDE -- Autocorrection Basic IDE -- Basic UNO extended types Basic IDE -- options Basic dialogs -- organize in libraries Basic macros -- organize in libraries Basic modules -- organize in libraries Built-in help -- installation CSV -- command line filter options CSV -- export options CSV -- filter options CSV -- import options CSV -- separator specification line CTL -- (not) wrapping words Calc A1 -- cell reference syntax in strings Collabora Office Basic scripts in HTML documents Collabora Office Help Collabora Office colors Crash Report Tool DDE links -- modifying Diff -- command line filter options Drawing bar EPUB -- export Edit Mode icon Euro -- currency formats Excel A1 -- cell reference syntax in strings Excel R1C1 -- cell reference syntax in strings Export as -- EPUB Export as -- PDF FTP -- remote file service setup Find & Replace -- attributes Find & Replace dialog Find toolbar Format Paintbrush Gallery -- hiding/showing Google Drive -- remote file service setup Google Drive -- remote file service HTML -- compatibility settings HTML documents -- new Hebrew -- languages and locales Help -- Help tips Help pages -- Index Help pages -- contents Help pages -- search in index Hindi -- languages and locales ImageMap -- hotspot properties Internet glossary Java -- setting options LCID, extended LanguageTool -- settings Lotus -- command line filter options Material Design colors Math baseline alignment (Writer)Microsoft Office -- importing/exporting VBA code Microsoft Office -- importing Word documents Microsoft lock files My Documents folder -- opening Navigator -- docking Navigator -- comments OLE objects -- Microsoft Office OLE objects -- PDF OLE objects -- import and export OLE objects -- protecting OpenCL -- setting options OpenPGP -- document encryption OpenType -- font features PDF -- command line parameters PDF -- export PDF export -- Universal Accessibility PDF export -- digital signature PDF export -- general options PDF export -- initial document view PDF export -- links PDF export -- security PDF export -- sign PDF document PDF export -- time stamp PDF export -- user interface PDF forms Paintbrush QR code -- barcode SQL -- LIMIT clause SSH -- remote file service setup Skia -- graphics output Skia -- settings Styles window -- docking TSA Thai -- languages and locales Track Changes, see review function URL -- saving absolute/relative paths Unicode -- input with keyboard Unicode -- shortcut keys VBA code -- loading/saving documents with VBA code Visual Basic for Applications -- loading/saving documents with VBA code WYSIWYG in fonts lists Web support WebDAV -- remote file service setup WebDAV over HTTPS Windows share -- remote file service setup Windows share -- remote file service Word documents -- compatibility XML filters -- creating/testing XML filters -- saving as package/installing/deleting abbreviation replacement absolute saving of URLs activating -- Crash Report Tool adding selection mode aligning -- text aligning -- tables in text ampersand symbol, see also operators anchoring -- as character anchoring -- to cell anchoring -- to character anchoring -- to frame anchoring -- to page anchoring -- to paragraph anchors -- displaying (Calc)anchors -- types/positions for draw objects appearance options applying document themes areas -- image areas -- slanting areas -- styles arguments in command line as character -- anchoring attaching toolbars attachments in emails attributes -- finding audio automatic redaction background -- area background -- pattern backgrounds -- frames/sections/indexes backing window beanshell scripts -- run binding space block selection mode bold -- AutoFormat function bold -- using * when typing bookmark -- definition borders -- cells on screen (Calc)borders -- table boundaries (Writer)boundaries of tables (Writer)break display (Writer)bullets -- replacing bullets -- turning off bullets -- paragraphs button bars, see toolbars callouts -- drawings capital letters -- AutoCorrect function capital letters -- font effects categories -- in templates cell reference syntax in strings -- Calc A1 cell reference syntax in strings -- Excel A1 cell reference syntax in strings -- Excel R1C1 cell widths -- using mouse cell widths -- using ruler cells -- coloring (Calc)cells -- cursor positions after input (Calc)cells -- formatting without effect (Calc)cells -- pasting cells -- showing grid lines (Calc)cells -- formula hint cells -- formula indicator in cell cells -- resetting formats certificate path changes -- accepting or rejecting changes -- navigating changes -- review function changing -- DDE links changing -- page margins changing -- page size changing, see also editing and replacing chapter -- definition character highlighting -- Microsoft Office export character shading -- Microsoft Office export character styles -- language selection characters -- coloring characters -- displaying only on screen (Writer)characters -- enabling CTL and Asian characters characters -- font effects characters -- hiding characters -- language selection characters -- fonts and formats charts -- displaying (Calc)check -- graphic size classification -- BAF category classification -- BAILS levels classification -- categories classification -- classification bar classification -- contents classification -- displayed in user interface classification -- document classification -- headers and footers classification -- licenses classification -- markings classification -- paragraph classification -- part numbers classification -- security levels classification -- watermark classification levels -- Confidential classification levels -- General Business classification levels -- Internal use only classification levels -- Non-Business classification levels -- customizing classification toolbar -- display clipboard -- pasting clipboard -- selection clipboard clone formatting closing -- toolbars color selector colors -- Collabora Office colors colors -- HLC colors colors -- appearance colors -- applications colors -- default colors colors -- fonts colors -- freieFarbe colors -- grid lines and cells (Calc)colors -- ignored text color colors -- web colors -- adding colors -- delete colors -- in document themes colors -- loading lists colors -- palette colors -- restriction (Calc)column -- inserting after column -- inserting before column headers -- displaying (Calc)column headers -- highlighting (Calc)column width -- distribute evenly columns -- optimal widths command line document conversion -- filters for BASE command line document conversion -- filters for CALC command line document conversion -- filters for DRAW command line document conversion -- filters for GRAPHICFILTER command line document conversion -- filters for IMPRESS command line document conversion -- filters for MATH command line document conversion -- filters for PDFIMPORT command line document conversion -- filters for WRITER command line document conversion -- filters for XSLTFILTER command line document conversion -- filters command line parameters comments -- hide resolved comments -- inserting/editing/deleting/printing/resolving comments -- resolve in text documents comments -- show common terms -- Internet glossary comparison -- automatic comparison -- by character comparison -- by word compatibility settings -- key bindings (Calc)compatibility settings for MS Word import complex text layout -- enabling concatenation, see ampersand symbol conditions -- in number formats contents protection context menus -- customizing controls -- events controls -- grouping controls -- multi-line titles controls -- positions and sizes controls -- rich text control controls -- showing (Writer)convert to PDF -- command line parameters convert-to -- filters copying -- formatting crash reports cube drawing currency formats cursor -- allowing in protected areas (Writer)cursor -- in read-only text cursor position -- on opening text documents custom -- classification levels custom dictionaries -- editing custom hyphens (Writer)custom quotes custom templates customizing -- events customizing -- context menus customizing -- menus dBase -- command line filter options data -- user data data source view -- showing database field -- add to form database field -- add to report databases -- searching records date acceptance patterns date formats dates -- printing in presentations decimal separator key decrease indent of paragraph default printer -- UNIX default printer -- setting up default templates -- changing default templates -- creating defaults -- views defaults -- documents defaults -- languages defaults -- number of worksheets in new documents defaults -- of saving defaults -- prefix name for new worksheet delete columns -- protected sheet delete rows -- protected sheet deleting -- hyperlinks deleting -- XML filters deleting -- comments descriptions for objects detaching toolbars development tools dictionaries -- editing user-defined dictionaries -- spellcheck dictionaries -- spelling dictionaries -- creating dictionaries, see also languages digital signature -- add signature line digital signature -- sign signature line digital signature -- signing existing PDF digital signature -- time stamp digital signatures -- WebDAV over HTTPS digital signatures -- certificate path digital signatures -- getting/managing/applying direct formatting -- clear directories -- creating new displaying -- comments in text documents displaying -- formatting marks (Writer)displaying -- non-printing characters (Writer)displaying -- pictures and objects (Writer)displaying -- tables (Writer)displaying -- zero values (Calc)distribute objects -- horizontally evenly distribute objects -- vertically evenly distribute objects horizontally distribute objects in drawings distribute objects vertically distributing XML filters docking -- windows docking -- toolbars document -- classification document -- properties document classification -- pasting contents document colors -- palette document comparison -- options document comparison -- random ID document conversion -- filters document themes -- choosing document themes -- colors document themes -- using documents -- apply user data to documents -- editing time documents -- embedding fonts documents -- languages documents -- last printed documents -- location documents -- number of modifications documents -- opening with templates documents -- opening documents -- preferred image resolution documents -- preview image documents -- read-only documents -- reset properties documents -- sending as email documents -- size documents -- styles changed documents -- template applied documents -- version numbers draw objects -- anchoring draw objects -- control points draw objects -- displaying (Calc)draw objects -- slanting draw objects -- positioning and resizing draw objects -- protecting drawing -- object styles drawing objects -- distribute evenly drawing objects -- distribute drawings -- creating/opening drawings -- languages drawings -- printing defaults drawings -- sending as email drawings -- showing (Writer)edit image -- external tool edit mode -- through Enter key (Calc)editing -- comments editing -- context menus editing -- grouped objects editing -- menus editing -- templates editing time of documents effects -- fonts electronic publication ellipse drawing email attachments embedded objects -- import and export embedding -- fonts embedding fonts in document file embedding licensed fonts empty documents empty paragraph removal encryption of contents engineering notation, formats entering groups events -- controls events -- customizing events -- in database forms exceptions -- user-defined dictionaries exiting -- grouped objects exiting -- groups expanding formatting (Calc)experimental features expert configuration -- setting options exporting -- Microsoft Office documents with VBA code exporting -- to EPUB exporting -- to PDF extending selection mode external tool -- edit image faxes -- fax programs/fax printers under UNIX file -- properties file encryption -- OpenPGP file encryption -- symmetric keys file extensions -- in templates file sharing options for current document files -- opening files -- sending as email files -- version numbers fill colors for areas fill patterns for areas filters -- document conversion finding -- attributes finding -- in all sheets finding -- formatted display finding -- formatted numbers fitting to pages -- print settings in presentations fixing toolbars flip -- horizontally flip -- vertically floating toolbars folder creation font attributes -- finding font effects -- hiding characters font embedding -- in documents font features -- OpenType font features font lists font name box font sizes -- relative changes fonts -- color ignored fonts -- effects fonts -- embedding fonts -- formats fonts -- hiding characters fonts -- licensing for embedding fonts -- outlines fonts -- shadows fonts -- strikethrough fonts -- colors fonts -- finding footers -- backgrounds form controls -- protecting format -- clear direct formatting format codes -- numbers formats -- fonts formats -- of currencies/date/time formatting -- expanding (Calc)formatting -- font effects formatting -- undoing when writing formatting -- copying formatting -- pages formatting marks (Writer)formatting marks -- insert formatting marks -- narrow no-break space formatting marks -- no-break space formatting marks -- non-breaking hyphen formatting marks -- soft hyphen formatting marks -- word joiner formatting marks -- zero-width space forms -- browsing forms -- events forms -- grouping controls forms -- add database field forms -- database events formula options -- formula syntax formula options -- large spreadsheet files formula options -- loading spreadsheet files formula options -- recalculating spreadsheets formula options -- reference syntax in string parameters formula options -- separators formulas -- new forums and support fraction, formats frames -- backgrounds frames -- selection frames frames -- protecting freeform lines -- draw functions full-width -- definition fullwidth -- definition getting support glossaries -- Internet terms gradients -- loading lists grammar -- LanguageTool graphic size -- check graphics -- protecting grids -- displaying lines (Calc)group -- objects group menu groups -- of controls groups -- entering groups -- entering/exiting/ungrouping groups -- exiting guides -- showing (Calc)gutter half-width -- definition halfwidth -- definition hatching -- loading lists head-up display (hud)headers -- backgrounds heading -- definition headings -- entering as text box hidden fields display (Writer)hidden pages -- printing in presentations hidden text -- showing (Writer)hiding -- characters hiding -- docked windows highlighting changes horizontal scrollbars (Writer)hotspots -- properties hybrid PDF hyperlinks -- deleting hyperlinks -- to files hyperlinks -- to folders hyphenation -- activating for a language hyphenation -- minimal number of characters hyphens -- displaying custom (Writer)icon bars, see toolbars icons -- sizes icons -- styles ignore list for spellcheck ignore list for spelling ignored font colors image -- change resolution image -- compression image -- reduce image size image -- replace image -- resize image -- size reduction images -- areas importing -- Microsoft Office documents with VBA code importing -- compatibility settings for text import increase indent of paragraph indexes -- backgrounds insert -- column after insert -- column before insert -- row above insert -- row below insert columns -- protected sheet insert mode for entering text insert rows -- protected sheet inserting -- comments inserting -- movies/sounds inserting -- new text tables defaults inserting -- paragraph bullets installing -- XML filters invisible areas italic -- AutoFormat function italic -- using / when typing java scripts -- run javascript scripts -- run joining -- paragraphs keyboard -- general commands keyboard -- removing numbering languages -- Asian support languages -- activating modules languages -- locale settings languages -- selecting for text languages -- spellcheck languages -- spellchecking and formatting languages -- spelling languages -- spelling layout -- importing Word documents layout -- pages levels -- macro security limits of tables (Writer)lines -- draw functions links -- updating options (Writer)lists -- regular expressions loading -- Microsoft Office documents with VBA code loading -- documents loading -- colors/gradients/hatchings loading -- large spreadsheet files locale settings lock files -- Collabora Office lock files -- Microsoft Office lowercase letters -- font effects macro -- select macro to run macro recording -- limitations macros -- assigning to events in forms macros -- interrupting macros -- recording macros -- security levels macros -- security macros -- selecting security warnings margins -- defining margins -- pages marking changes marking, see selecting menus -- customizing merge/merging cells metrics -- in sheets modifying, see changing module file filters mouse -- middle button movies moving -- toolbars multi-line titles in forms multiple documents -- opening multiple selection music names -- multi-line titles native numeral navigator -- rename new documents non-breaking spaces (Writer)non-printing characters (Writer)notebook bar -- contextual groups notebook bar -- contextual single toolbar notebook bar -- default layout notebook bar -- icon size notebook bar -- layouts notebook bar -- sidebar notebook bar -- single toolbar notebook bar -- tabbed mode notebook bar -- toolbar number formats -- codes number of worksheets in new documents numbering -- turning off numbering -- using automatically numbers -- date, time and currency formats object inspector objects -- displaying in spreadsheets objects -- displaying in text documents objects -- grouping objects -- text and alt text objects -- ungrouping online updates -- checking manually open -- remote file opening -- dialog settings opening -- documents opening -- files, with placeholders opening -- several files opening -- CMIS remote file opening -- documents on WebDAV server opening -- remote file opening remote file optimal column widths -- text table optimal column widths optimal row heights -- text table optimal row heights -- text table;optimal row heights optimal row heights optional hyphens (Writer)options -- appearance options -- Basic IDE options -- compatibility (Writer)options -- security ordinal numbers -- replacing organizing -- styles outline folding buttons -- settings outlines -- font effects outlines -- outline symbols overwrite mode page -- save background image page -- set background image page background image -- save page background image -- set page breaks -- displaying (Calc)page formats -- restriction page line-spacing -- definition page margins page size -- defining pages -- formatting and numbering pages -- printing page names in presentations palette -- document colors paper formats paper trays paragraph -- classification paragraph -- clear direct formatting paragraph marks -- displaying (Writer)paragraph styles -- languages paragraphs -- hidden paragraphs (Writer)paragraphs -- increasing indents of paragraphs -- inserting bullets paragraphs -- joining paragraphs -- numbering automatically paragraphs -- removing blank ones paragraphs -- decreasing indents of parameters -- command line password as document property passwords for protecting contents paste -- nested table paste -- unformatted text paste nested table paste special -- nested table paste special -- only formula (spreadsheet)paste special -- only numbers (spreadsheet)paste special -- only text (spreadsheet)paste special -- unformatted text pasting -- Ctrl+V shortcut pasting -- Enter key pasting -- cell ranges paths -- template files pattern -- area pattern -- background percentages, formats personal data -- cursor position personal data input pick color pictures -- displaying in Calc pictures -- displaying in Writer (Writer)placeholders -- on opening files placing toolbars playing movies and sound files polygon drawing portable document format positioning -- draw objects and controls positioning -- toolbars prefix name for new worksheet presentations -- auto-redact presentations -- redacting contents presentations -- sending as email presentations -- creating/opening previews -- fonts lists printers -- adding, UNIX printers -- default printer printers -- faxes under UNIX printers -- properties printers -- paper trays printing -- dates in presentations printing -- drawings defaults printing -- fitting to pages in presentations printing -- hidden pages of presentations printing -- tiling pages in presentations printing -- without scaling in presentations printing -- comments printing -- manual breaks private key -- file encryption profile -- safe mode properties -- hotspots properties -- printers protect -- sheet protected contents protected documents protected sheet -- delete columns protected sheet -- delete rows protected sheet -- insert columns protected sheet -- insert rows protected spaces -- showing (Writer)protecting -- contents public key -- file encryption python scripts -- run quotes -- custom read-only documents -- editing read-only documents -- cursor read-only documents -- opening documents as recalculate -- formula options recalculating -- formula options recalculating -- large spreadsheet files recording -- macros records -- inserting comments records -- searching in databases rectangle drawing redaction references -- displaying in color (Calc)references -- expanding (Calc)register-true -- definition regular expressions -- begin of paragraph regular expressions -- begin of word regular expressions -- empty paragraph regular expressions -- end of paragraph regular expressions -- list of regular expressions -- new line relative saving of URLs remarks, see also comments remote file -- open remote file -- save remote file service -- CMIS properties remote file service -- Google Drive remote file service -- Windows share remote file service -- checkin remote file service -- checkout remote file service -- file lock remote file service -- file properties remote file service -- opening file remote file service -- saving to remote server remote file service -- saving remote file service -- setup remote file service -- version control remote file service -- working copy remote file service setup -- Alfresco remote file service setup -- CMIS server remote file service setup -- FTP remote file service setup -- Google Drive remote file service setup -- IBM remote file service setup -- Lotus remote file service setup -- Nuxeo remote file service setup -- SSH remote file service setup -- SharePoint remote file service setup -- WebDAV remote file service setup -- Windows share remote file service setup -- other file services removing -- bullets and numbering removing, see also deleting rename -- objects replace -- image replacement options replacing -- tab stops (regular expressions)replacing -- ordinal numbers report -- add database field reports -- crash reports resetting -- Find & Replace mode resetting -- templates resolving -- comments review function -- navigating changes review function -- recording changes example review function -- accepting or rejecting changes rich text control row -- insert above row -- inserting below row headers -- displaying (Calc)row headers -- highlighting (Calc)row height -- distribute equally rows -- optimal heights run macro -- select run scripts -- beanshell run scripts -- java run scripts -- javascript run scripts -- python save -- remote file save -- save a copy save a copy saving -- VBA code in Microsoft Office documents saving -- dialog settings saving -- options saving -- templates saving -- with password by default scaling -- when printing presentations scientific notation, formats scrollbars -- displaying (Calc)scrollbars -- horizontal and vertical (Writer)search -- Help index search commands searching -- all sheets searching -- databases searching -- formatted display searching -- formatted numbers sections -- backgrounds security -- options for documents with macros security -- protecting contents security -- security levels for macros selecting -- several files selecting -- objects selecting -- security options selecting -- security warnings selection -- in protected cells selection clipboard selection frames selection modes in text sending -- documents as email separators -- array column separators -- array row separators -- function setting options -- OpenCL settings -- printers settings -- views shadows -- characters shapes -- control points shapes sheet table -- AutoFormat function sheet tabs -- displaying sheets -- optimal row heights sheets -- searching all shortcut keys -- Unicode shortcut keys -- general show -- sidebar showing -- drawings and controls (Writer)showing -- docked windows showing -- toolbars sidebar -- notebook bar sidebar -- view signature line -- adding signature line -- signing signing documents with digital signatures sizes -- draw objects slanting draw objects slide -- save background image slide -- set background image slide background image -- save slide background image -- set small capitals smart tag configuration smooth scrolling (Writer)snap lines -- showing when moving frames (Writer)soft hyphens (Writer)sound files spaces -- displaying (Writer)spaces -- ignoring double spaces -- showing protected spaces (Writer)spacing -- tab stops in text documents speech bubbles spellcheck -- activating for a language spellcheck -- context menus spellcheck -- default languages spellcheck -- dialog spellcheck -- dictionary of exceptions spellcheck -- ignore list spelling -- activating for a language spelling -- context menus spelling -- default languages spelling -- dialog spelling -- dictionary of exceptions spelling -- ignore list spelling -- LanguageTool split/splitting cells spreadsheet -- auto-redact spreadsheet -- redacting contents spreadsheets -- optimal column widths spreadsheets -- sending as email spreadsheets -- creating/opening standard printer under UNIX start center start parameters strikeout -- AutoFormat function strikeout -- using - when typing strikethrough -- font effects string -- conversion to date settings string -- conversion to number settings string -- conversion to reference settings string -- setting in spreadsheet formulas string conversion to date options string conversion to number options string conversion to reference options styles -- changed message styles -- organizing styles -- replacing automatically styles -- drawing objects styles -- table styles support on the Web tab stops -- displaying (Writer)tab stops -- regular expressions tab stops -- setting in sheets tab stops -- spacing in text documents table columns -- distribute columns evenly table rows -- distribute height equally tables -- AutoFormat function tables in databases -- searching tables in spreadsheets -- value highlighting tables in text -- creating automatically tables in text -- default settings tables in text -- displaying tabs -- displaying sheet tabs template manager -- category template manager -- export template manager -- filter template manager -- import template manager -- set as default template manager -- settings templates -- opening documents with templates -- editing and saving templates -- template manager terminology -- Internet glossary testing XML filters text -- alignment text -- animating text -- coloring text -- font effects text -- fonts and formats text -- language selection text -- overwriting or inserting text -- selection modes text alternative -- objects text attributes -- finding text boxes -- positioning text documents -- auto-redact contents text documents -- redacting contents text documents -- creating/opening text documents -- sending as email text input fields text objects -- draw functions text overflow in spreadsheet cells text table -- optimal column widths themes -- colors thesaurus -- activating for a language ticker text time stamp -- digital signature time stamp authority time stamp for PDF digital signature times -- inserting when printing presentations times, formats tip of the day tip of the day titles -- font effects titles -- formatting automatically to cell -- anchoring to character -- anchoring to frame -- anchoring to page -- anchoring to paragraph -- anchoring toolbar -- notebook bar toolbars -- docking/undocking toolbars -- locking/unlocking toolbars -- viewing/closing tooltips -- help tooltips -- in scroll bars translation -- automatic translation -- server settings triangle drawing typefaces -- formats underlining -- AutoFormat function underlining -- text underlining -- using _ when typing undocking windows unformatted text -- paste special ungroup -- objects ungrouping groups unmerge/unmerging cells unordered list unstable options updates -- checking manually updating -- fields and charts, automatically (Writer)updating -- links in text documents updating -- templates user data -- cursor position user data -- input user data -- removing when saving user-defined dictionaries -- dictionary of exceptions user-defined dictionaries -- editing user-defined dictionaries -- creating user-defined styles -- automatically replacing using -- document themes version numbers of documents vertical callouts vertical scrollbars (Writer)vertical text boxes videos view -- comments view -- sidebar viewing -- toolbars views -- defaults warnings -- security windows -- hiding/showing/docking windows -- docking word counts -- separators words -- automatically replacing words -- formatting marks words -- wrapping in CTL write protection on/off writing aids -- LanguageTool writing aids -- translation writing aids options years -- 2-digit options zero values -- displaying (Calc)טעינת -- קובציXML ייבוא -- מ־XML ייצוא -- ל־XML מסנני XSLT, באותו נושא יש גם מסנני XML מסנני קבצים -- XML שמירה -- ל־XML

Macros

Opens the Macro dialog.

Macros

Please support us!

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

Help content debug info:

This page is: /text/sbasic/shared/02/11100000.xhp

Title is: Macros