Loading...
X

All the ‘tips of the day’ LibreOffice

On this page, I have collected all the “Tips of the Day” that LibreOffice displays once a day when the program starts.

A few notes:

  • the lines are taken from the latest version of the program and will be updated as new versions of LibreOffice are released
  • in some tips the text or link is missing – I checked the source code files – there the text is the same
  • some numbers are missing – apparently, this is due to the fact that “Tips of the Day” is constantly updated. For example, in the previous version of the program there were more than 300, and in the last at the time of writing, a little more than 200

If you have your own interesting tips on using LibreOffice, then share them in the comments!

# Tips
Tip # 45 LibreOffice can open and save files stored on remote servers per CMIS.
Tip # 46 Tools > AutoCorrect > AutoCorrect Options… > Replace provides a list of common substitutions. Take a look and complete with your own replacements.
Tip # 47 Writer can handle styles conditionally: paragraph styles that have different properties depending on the context.
Tip # 48 With File > Versions you can store multiple versions of the document in the same file. You can also open, delete, and compare previous versions.
Tip # 49 You can create an illustration index from object names, not only from captions.
Tip # 50 To temporarily start with a fresh user profile or to restore a non-working LibreOffice instance start Help > Restart in Safe Mode.
Tip # 51 Change the basic fonts for the predefined template or current document per Tools > Options > LibreOffice Writer > Basic Fonts.
Tip # 52 Define texts that you often use as AutoText. You will be able to insert them by their name, shortcut or toolbar in any Writer document.
Tip # 53 LibreOffice can automatically add a numbered caption when you insert objects. See Tools > Options > LibreOffice Writer > AutoCaption.
Tip # 54 You can sort paragraphs or table rows alphabetically or numerically per Tools > Sort.
Tip # 55 Use Sections in LibreOffice Writer to protect part of a text, show/hide text, reuse parts from other documents, use different column layout.
Tip # 56 Use Sheet > Fill Cells > Random Number to generate a random series based on various distributions.
Tip # 57 Use Format > Conditional Formatting > Manage in Calc to find out which cells have been defined with conditional formatting.
Tip # 58 Apart from table of contents, LibreOffice can create Alphabetical, Illustrations, Tables, Objects, Bibliography, User-Defined indexes.
Tip # 59 Want to sort a series in LibreOffice Calc such as A1, A2, A3, A11, A15, not in alphabetical order but on the number? Enable natural sort in the Options tab.
Tip # 60 Enable massive parallel calculations of formula cells via Tools > Options > OpenCL.
Tip # 61 LibreOffice supports four macro security levels (from low to very high) and trusted sources.
Tip # 63 Want to know the valid command line parameters? Start soffice with help or -h or -?"
Tip # 64 Want to manage the presentation of hyperlinks in a spreadsheet? Insert them with the HYPERLINK function.
Tip # 65 Can not get what you want with VLOOKUP? With INDEX and MATCH you can do everything!"
Tip # 66 You can sign existing PDF files and also verify those signatures.
Tip # 67 Writer includes LibreLogo: simple Logo-like programming environment with turtle vector graphics, DTP and graphic design.
Tip # 68 You can protect cells with Format > Cells > Protection. To prevent insert, delete, rename, move/copy of sheets use Tools > Protect Sheet.
Tip # 69 You want to add x months to a date? Use =EDATE(date;months).
Tip # 70 Trace cells used in a formula, precedents (Shift+F9) or dependants (Shift+F5) (or use Tools > Detective). For each hit you go one more step in the chain.
Tip # 71 You need to fill a series? Select the cell range and Sheet > Fill Cells > Fill Series and choose between Linear, Growth, Date and AutoFill.
Tip # 72 With LibreOffice you can use your Google Mail account to do a mail merge. Fill in Tools > Options > LibreOffice Writer > Mail Merge Email.
Tip # 73 Data > Validity allows you to create drop-down lists where the user selects a value instead of typing.
Tip # 74 Use View > Value Highlighting to display cell contents in colours: Text/black, Formulas/green, Numbers/blue, Protected cells/grey background.
Tip # 75 Strange error code in Calc, Err: followed by a number? This page gives the explanation:"
Tip # 76 Want to find the words in bold in a Writer document? Edit > Find & Replace > Other options > Attributes > Font weight.
Tip # 77 Want to remove all <> at once and keep the text inside? Edit > Find & Replace: Search = [<|>], Replace = blank and check ‘Regular expressions’ under Other options.
Tip # 78 Tools > Detective > Mark Invalid Data highlights all cells in the sheet that contain values outside the validation rules.
Tip # 79 Need to allow changes to parts of a read-only document in Writer? Insert frames or sections that can authorise changes.
Tip # 80 Writing a book? LibreOffice master document lets you manage large documents as a container for individual LibreOffice Writer files.
Tip # 81 In Calc use TRIMMEAN() to return the mean of a data set excluding the highest and lowest values.
Tip # 82 Calculate loan repayments with Calc: e.g. PMT(2%/12;36;2500) interest rate per payment period 2%/12, 36 months, loan amount 2500.
Tip # 83 Use your Android or iPhone to remotely control your Impress presentation.
Tip # 84 The presenter console is a great feature when working with LibreOffice Impress. Have you checked it out?"
Tip # 85 Automatically mark alphabetical index entries using a concordance file.
Tip # 86 Frames can be linked so that the text can flow from one to the other as in desktop publishing.
Tip # 88 Get help from the community via the Ask portal.
Tip # 89 LibreOffice has great extensions to increase your productivity, check them out.
Tip # 90 LibreOffice has a template centre to create good looking documents, check it out.
Tip # 91 Embedded help is available by clicking on F1, if you've installed it. Otherwise check online at:"
Tip # 92 Get LibreOffice documentation and free user guide books at:"
Tip # 93 Your donations support our worldwide community.
Tip # 94 With LibreOffice it is very easy to install a new dictionary: they are supplied as an extension.
Tip # 95 LibreOffice is developed by a friendly community, made up of hundreds of contributors around the world. Join us with your skills beyond coding.
Tip # 96 LibreOffice has a portable version which gives you mobility. Even without administrator rights on your computer you can install LibreOffice Portable to your hard drive too.
Tip # 97 LibreOffice allows you to use assistive tools, such as external screen readers, Braille devices or speech recognition input devices.
Tip # 98 Create editable Hybrid PDFs with LibreOffice.
Tip # 99 Citation management? Use a 3rd party extension.
Tip # 100 You plan to change the computer and want to recover your customisations? See:"
Tip # 101 LibreOffice supports over 150 languages.
Tip # 102 Want to become a LibreOffice Ambassador? There are certifications for developers, admins, and trainers.
Tip # 103 LibreOffice intends to apply as an organisation for Google Summer of Code (GSoC) see:"
Tip # 104 Create fillable form documents (even PDF's) with LibreOffice.
Tip # 105 Run LibreOffice in any browser via rollApp.
Tip # 106 Developing new XSLT and xml filters?"
Tip # 108 Easily convert your documents to PDF with one click by clicking on the PDF icon in the toolbar.
Tip # 109 Select a different icon set from Tools > Options > LibreOffice > View > User Interface > Icon size and style.
Tip # 110 Use font embedding for greater interoperability with other office suites at File > Properties > Font.
Tip # 111 Generate fully customised PDF documents with the exact format, image compression, comments, access rights, password, etc., via File > Export as PDF.
Tip # 112 Use Data > Statistics for sampling, descriptive statistics, analysis of variance, correlation, and much more in LibreOffice Calc.
Tip # 113 Right-click in the status bar in LibreOffice Calc and select 'Selection count' to display the number of selected cells.
Tip # 114 In LibreOffice Impress use Insert > Media > Photo Album to create a slide-show from a series of pictures with the 'Photo Album' feature.
Tip # 115 Did you know that you can attach comments to portions of text? Just use shortcut Ctrl+Alt+C for it.
Tip # 116 Need to insert the date in a spreadsheet cell? Type Ctrl+; or Shift+Ctrl+; to insert the time.
Tip # 117 Need to move one or more paragraphs? No need to cut and paste: Use the keyboard shortcut Ctrl+Alt+Arrow (Up/Down)"
Tip # 118 Batch convert your MS Office documents to OpenDocument format by the Document Converter wizard in menu File > Wizards > Document converter.
Tip # 119 Uncheck Tools > Options > LibreOffice Calc > View > Zoom: 'Synchronise sheets' so that each sheet in Calc has its own zoom factor.
Tip # 120 Open a CSV file as a new sheet in the current spreadsheet via Sheet > Sheet from file.
Tip # 121 Need to move a Writer table? Table > Select > Table and Insert > Frame… and move where you want.
Tip # 122 In LibreOffice Draw to change the 0/0 point of the rulers, drag the intersection of the two rulers in the top left corner into the workspace.
Tip # 123 Hold down Ctrl and turn the mouse wheel to change the zoom factor.
Tip # 124 Edit > Find & Replace lets you insert special characters directly: right click in input fields or press Shift+Ctrl+S.
Tip # 125 Don't use tabs to space items on a Writer document. Depending on what you are trying to do, a borderless table can be a better choice.
Tip # 126 Drag a formatted object to the Styles and Formatting window. A dialogue box opens, just enter the name of the new style.
Tip # 127 Keep the zeros before a number by using the 'leading zeros' cell format option or format the cell as text before entering the number.
Tip # 128 To copy a comment without losing the content of the target cell you should use Paste Special and uncheck everything except ‘Comments’ in the dialogue box. Use Operations ‘Add’ to not override existing content.
Tip # 129 Select an object in the document background via the Select tool in the Drawing toolbar to surround the object to select.
Tip # 130 Apply Heading paragraph styles in Writer with shortcut keys: Ctrl+1 applies Heading 1, Ctrl+2 applies Heading 2, etc.
Tip # 131 Mix portrait and landscape orientations in a Calc spreadsheet by applying different page styles on sheets.
Tip # 132 Create different master pages in a presentation template: View > Master Slide and Slide > New Master (or per toolbar or right click in slide pane).
Tip # 133 Use Page/Slide > Properties > 'Fit object to paper format' in Draw/Impress to resize the objects so that they fit on your chosen paper format.
Tip # 134 To modify an AutoPlay presentation, open it and after it starts, right click and select Edit in the context menu.
Tip # 135 Rename your slides in Impress to help you define 'Go to page' interactions and to have a summary more explicit than Slide1, Slide2…"
Tip # 136 Play music throughout a slide-show by assigning the sound to the first slide transition without clicking the ‘Apply to All Slides’ button.
Tip # 137 With ‘Slide Show > Custom Slide Show’, reorder and pick slides to fit a slide-show to the needs of your public.
Tip # 138 Include a paragraph that is not a title in the table of contents by changing Outline & Numbering in the paragraph settings to an outline level.
Tip # 139 Use the Connector tool from the Drawing toolbar in Draw/Impress to create nice flow charts and optionally copy/paste the object into Writer.
Tip # 140 Want to see, but not print, an object in Draw? Draw it on a layer for which the ‘Printable’ flag is not set (right click on the tab and ‘Modify Layer’).
Tip # 141 Want to print two portrait pages on a landscape one (reducing A4 to A5)? File > Print and select 2 at ‘Pages per sheet’.
Tip # 142 To get the ‘Vertical Text’ tool in the Drawing toolbar, check Tools > Options > Language Settings > Languages > Default languages > Asian (and make the button visible with right click).
Tip # 143 Want to add many shapes in Draw/Impress? Double-click a tool in the drawing toolbar to use it for repeated tasks.
Tip # 144 Want to display only the highest values in a spreadsheet? Select menu Data > AutoFilter, click the drop-down arrow, and chose ‘Top10’.
Tip # 145 Unable to modify or delete a custom cell style? Check all sheets, none should be protected.
Tip # 146 Want to know how many days there are in the current month? Use the DAYSINMONTH(TODAY()) function.
Tip # 147 Add background images to spreadsheets via Insert > Image or drag a background from the Gallery, then Format > Arrange > To Background.
Tip # 148 To quickly get a Math object in Writer type your formula, mark it, and use Insert > Object > Formula to convert the text.
Tip # 149 Writer can insert a blank page between two odd (even) pages that follow. Check ‘Print automatically inserted blank pages’ in the Print dialogue box’s Writer tab.
Tip # 150 The 4th optional parameter of VLOOKUP Calc function indicates whether the first column of data is sorted. If not, enter FALSE or zero.
Tip # 151 Want to show hidden column A? Click a cell in column B, press the left mouse button, move the mouse to the left, release. Then switch it on via Format > Columns > Show.
Tip # 152 Writer helps you to make backups: with File > Save a Copy you create a new document continuing to work on the original.
Tip # 153 Need to present a report written with Writer? File > Send > Outline to Presentation automatically creates a slide-show from the outline.
Tip # 154 Drag & drop cells from Calc into the normal view of a slide creates a table; into the outline view, each cell creates a line in the outline.
Tip # 155 Use Format > Align (or the context menu) for precise positioning of objects in Draw/Impress: it centres on the page if one object is selected or works on the group respectively.
Tip # 156 Repeat the heading on a subsequent page when a table spans over more than one page with Table > Table Properties > Text Flow > Repeat heading.
Tip # 157 Use column or row labels in formulas. For example, if you have two columns, ‘Time’ and ‘KM’, use =Time/KM to get minutes per kilometre.
Tip # 158 To change the number of a page in Writer, go to the properties of the first paragraph and at the Text Flow tab check Break > Insert and enter the number.
Tip # 159 Want the cursor to go into the cell to the right, after entering a value in Calc? Use the Tab key instead of Enter.
Tip # 160 Show or hide comments in Writer by clicking the comment toggle button in the ruler.
Tip # 161 Fit your sheet or print ranges to a page with Format > Page > Sheet Tab > Scaling Mode.
Tip # 162 Keep column headers of a sheet visible when scrolling lines via View > Freeze Cells > Freeze First Row.
Tip # 163 Want your chapter titles to always begin a page? Edit Heading1 (paragraph style) > Text Flow > Breaks and check Insert > Page > Before.
Tip # 164 Want to keep the text from, but remove a hyperlink, in Writer? Right click the link and ‘Remove Hyperlink’.
Tip # 165 Create a chart based on a Writer table by clicking in the table and choosing Insert > Chart.
Tip # 166 Move a column in Calc between two others in one step? Click the header then a cell in the column, keep mouse button and move to the target with Alt key.
Tip # 167 Use the Backspace key instead of Delete in Calc. You can choose what to delete.
Tip # 168 To distribute some text in multi-columns select the text and apply Format > Columns.
Tip # 169 Uncheck Slide Show > Settings > Presentation always on top if you need another program to display its window to the front of your presentation.
Tip # 170 Select options in Tools > Options > LibreOffice Writer > Formatting Aids > Display to specify which non-printing characters are displayed.
Tip # 171 Want the same layout for the screen display and printing? Check Tools > Options > LibreOffice Calc > General > Use printer metrics for text formatting.
Tip # 172 Customise your footnotes page with Tools > Footnotes and Endnotes…"
Tip # 173 Want to sum a cell through several sheets? Refer to the range of sheets e.g. =SUM(Sheet1.A1:Sheet3.A1).
Tip # 174 You can copy from one sheet to another without the clipboard. Select the area to copy, Ctrl+click the target sheet's tab and use Sheet > Fill Cells > Fill Sheets.
Tip # 175 Want to insert a value in the same place on several sheets? Select the sheets: hold down Ctrl key and click their tabs before entering.
Tip # 176 Click a column field (row) PivotTable and press F12 to group data. Choices adapt to content: Date (month, quarter, year), number (classes)"
Tip # 177 Want to count words for just one particular paragraph style? Use Edit > Find & Replace > Paragraph Styles, select the style > Find All and read the number from the status bar.
Tip # 178 Toolbars are contextual, they open depending on the context. If you do not want that, uncheck them from View > Toolbars.
Tip # 179 Insert and number your formulae in one step: type fn then F3. An AutoText is inserted with formula and number aligned in a table.
Tip # 180 To automatically number your table rows in Writer, select the relevant column, then apply a numbering style from List Styles.
Tip # 181 Delete all of your printing areas in one step: select all sheets then Format > Print Ranges > Clear.
Tip # 182 LibreOffice helps you not to enter two or more spaces in Writer. Check Tools > AutoCorrect Options > Options > Ignore double spaces.
Tip # 183 Transpose a writer table? Copy and paste in Calc, transpose with copy/paste special then copy/paste special > Formatted text in Writer.
Tip # 184 Writer lets you number your footnotes per page, chapter, document: Tools > Footnotes and Endnotes > Footnotes tab > Counting.
Tip # 185 Left-handed? Enable Tools > Options > Language Settings > Languages > Asian and check Tools > Options > LibreOffice Writer > View > Ruler > Right-aligned, which displays the scrollbar to the left.
Tip # 186 To display the scrollbar to the left, enable Tools > Options > Language Settings > Languages > Complex text and check Sheet > Right-To-Left.
Tip # 187 Your numbers are displayed as ### in your spreadsheet? The column is too narrow to display all digits.
Tip # 188 Use Ctrl+Alt+Shift+V to paste the contents of the clipboard as unformatted text.
Tip # 189 When editing a cell in place, you can right click and Insert fields: Date, Sheet name, Document title etc.
Tip # 190 You can restart the slide show after a pause specified at Slide Show > Slide Show Settings > Loop and repeat.
Tip # 191 You can not see all the text in a cell? Expand the input line in the formula bar and you can scroll.
Tip # 192 You often create a document from another? Have you considered using a template?"
Tip # 193 New versions do not bring just new features and bug fixes. They also include security patches. Be safe, get yourself updated!"
Tip # 194 Want to duplicate the above line? Press Ctrl + D or use Sheet > Fill Cells > Fill Down.
Tip # 195 You can easily optimise your table using Table > Size > Distribute Rows / Columns Evenly.
Tip # 196 Fix bad looking MS Word table cells using Table > Size > Optimal Row Height / Column Width.
Tip # 197 Don't get lost in large documents. Use the Navigator (F5) to find your way through the content.
Tip # 198 You can use styles to make the tables in your document consistent. Choose one from the predefined list using Styles (F11) or via Table > AutoFormat.
Tip # 199 Want to select a large range of cells without scrolling? Type the range reference (e.g. A1:A1000) in the name box then Enter"
Tip # 200 Want to centre cells on a printed page in Calc? Format > Page, Page > Layout settings > Table alignment.
Tip # 201 You can show formulae instead of results with View > Show Formula (or Tools > Options > LibreOffice Calc > View > Display > Formulae).
Tip # 202 Want to jump to a particular page by its number? Click the left-most status bar entry or use Edit > Go To Page… or press Ctrl+G.
Tip # 203 With Tools > AutoText > AutoText > Import you can select Word document or template containing the AutoText entries that you want to import.
Tip # 204 You can display a number as a fraction (0.125 = 1/8): Format > Cells, Number > Fraction.
Tip # 205 To print the notes of your slides go to File > Print > Impress tab and select Notes under Document > Type.
Tip # 206 You can move an object to another layer by holding it until its edges flash, then drag it to the tab of the layer you want to move it to.
Tip # 207 Want to find words more than 10 characters? Edit > Find & Replace > Search > [a-z]{10,} > Other Options > check Regular expressions.
Tip # 208 Make it easy to insert a picture in a Writer template by Insert > Fields > More fields > Functions > PlaceHolder > Image. One click to select an image.
Tip # 209 Create a master document from the current Writer document? File > Send > Create Master Document (sub-documents are created depending on outline).
Tip # 210 Your date acceptance pattern is inappropriate? Tools > Options > Language Settings > Language > Date acceptance patterns allows you to tweak the pattern.
Tip # 211 Typing in bold, italics, or underlined in Writer you can continue with the default attributes using only the shortcut Ctrl+Shift+X (remove direct character formats).
Tip # 212 You will search in several sheets when you select them before you start the search.
Tip # 213 Want to change spell checking for some part of the text? Click in the language zone of the status bar or better, apply a style.
Tip # 214 A date is a formatted number of days since a date origin. An hour is a day divided by 24 with noon = 0.5.
Tip # 215 Need custom contents for metadata properties? File > Properties > Custom Properties tab lets you create what you want.
Tip # 216 Insert your metadata in your document with Insert > Fields > More Fields… > Document or DocInformation.
Tip # 217 To delete multiple comments, copy the range, paste special, and select everything except comments.
Tip # 218 To view the calculation of individual elements of a formula, select the respective elements and press F9.
Tip # 219 You can rotate cells table orientation with Table > Properties… > Text Flow > Text orientation.
Tip # 220 Many images in your Writer document? Speed up the display by disabling View > Images and charts.
Tip # 221 Shift+Ctrl+Del deletes from cursor to the end of the current sentence.
Tip # 222 Need an unnumbered item in a list? Use 'Insert Unnumbered Entry' in the Bullets and Numbering toolbar.
Tip # 223 Want to sort a pivot table? Click on drop-down list's arrow in the row/col header and select sort method: ascending, descending, or custom.
Tip # 224 Do not insert manual breaks to separate two paragraphs. Rather change Indents & Spacing > Spacing > Below paragraph at the style/paragraph properties.
Tip # 225 Your Writer document didn’t reopen with the text cursor at the same editing position it was when you saved it? Check Tools > Options > LibreOffice > User Data > First/Last name is not empty.
Tip # 226 With the Navigator you can select & move up/down headings and the text below the heading, in the Navigator and in the document.
Tip # 227 LibreOffice doesn't calculate from left to right but respects the order Parentheses > Exponents > Multiplication > Division > Addition > Subtraction.
Tip # 228 You can change the default function in the status bar: right click on the area.
Tip # 229 You do not want to print all columns? Hide or group the ones you do not need.
Tip # 230 Use Shift+Space to select the current row and Ctrl+Space to select the current column.
Tip # 231 To insert the current date in your document use Insert > Field > Date.
Tip # 232 Click at the beginning (end) of a section and press Alt+Enter to insert a paragraph before (after) the section.
Tip # 233 You can set a colour for each tab: right-click the tab or use Sheet > Sheet Tab Colour.
Tip # 234 You want to start working with LibreOffice basic macros? Take a look at the examples under Tools > Macros > Edit Macros.
Tip # 235 To remove the page number from your table of contents go to Insert > Table of Contents (or right-click and Edit the previously inserted index). At the Entries tab delete the page number (#) from Structure line.
Tip # 236 Chapter numbering dialogue box lets you set text to be displayed before the chapter number. For example, type 'Chapter ' to display 'Chapter 1'"
Tip # 237 Want to know if a cell is referred in formulae of other cells? Tools > Detective > Trace Dependents (Shift+F5).
Tip # 238 You can customise the middle mouse button using Tools > Options > LibreOffice > View > Middle Mouse button.
Tip # 239 To repeat rows/columns on every pages use Format > Print Ranges > Edit.
Tip # 240 Need to precisely position? Alt+arrow Keys move objects (shape, picture, formula) by one pixel.
Tip # 241 Choose ‘Hierarchical View’ in the Styles and Formatting sidebar to see the relation between styles.
Tip # 242 You can toggle between the field names and the actual value with View > Fields Names (or Ctrl + F9).
Tip # 243 Creating a Style based on another, you can enter a percentage value or a point value (e.g. 110% or -2pt or +5pt).
Tip # 244 Want to return to default after applying a list style? Click Bullets or Numbering On/Off tool on the Formatting toolbar.
Tip # 245 Configure use of the Ctrl key to follow hyperlinks? Tools > Options > LibreOffice > Security > Options > ‘Ctrl+click required to follow hyperlinks’.
Tip # 246 Annoyed by the marching ants around cells in Calc? Press Escape to stop them; the copied content will remain available for pasting.
Tip # 247 To quickly insert or delete rows, select the desired number of rows (or columns) and press Ctrl+ to add or Ctrl- to delete.
Tip # 248 To select a contiguous range of cells containing data and bounded by empty row and columns use Ctrl+* (numeric key pad).
Tip # 249 Ctrl+Shift+F9 recalculates all formulae in all sheets.
Tip # 250 Write along a curve? Draw the line, double click, type the text, Format > Text Box and Shape > Fontwork.
Tip # 251 To enable macro recording, check Tools > Options > LibreOffice > Advanced > Enable macro recording.
Tip # 252 In the replace input field of auto correct options you can use the wildcards .*
Tip # 253 Want to export formulae to CSV? File > Save As > Type:Text CSV, check ‘Edit filter settings’, and check ‘Save cell formulae’ in the next dialogue box.
Tip # 254 No need to scroll through the list at Tools > Customise > Keyboard to find a shortcut: just type it.
Tip # 255 To quickly zoom in the selection, press / (divide key) on the number pad. Press * to restore entire page in screen.
Tip # 256 To quickly zoom in on range selection, right click on the zoom part of the status bar and choose Optimal.
Tip # 257 You can reformat all comments in a document by clicking the down arrow in a comment and choose 'Format all Comments'.
Tip # 258 To convert a formula into static values you don’t need to copy/paste; use Data > Calculate > Formula to Value.
Tip # 259 Find all expressions in brackets using Edit > Find & Replace > Find > \([^)]+\) (check ‘Regular expressions’)"
Tip # 260 You can change the look of LibreOffice at Tools > Options > View > User Interface.

 


Leave Your Observation

Your email address will not be published. Required fields are marked *