diff options
author | heiko tietze <tietze.heiko@gmail.com> | 2019-04-15 14:46:16 +0200 |
---|---|---|
committer | Heiko Tietze <tietze.heiko@gmail.com> | 2019-04-16 10:03:12 +0200 |
commit | 033e1130a65ec7f0fa9c46e5124adc9d8bf724ba (patch) | |
tree | 6f48b5c45902781d7eaa4b534804ee80acaf3a8c | |
parent | 0871804bab38e1b2fdc19ff176189356e155f367 (diff) |
Resolves: tdf#124743 - Tip of the Day randomization
srand() added, image file name part of the hrc definition now
Change-Id: Ib697f64406ab6b11468eb837c71d57398a0533b5
Reviewed-on: https://gerrit.libreoffice.org/70767
Tested-by: Jenkins
Reviewed-by: Heiko Tietze <tietze.heiko@gmail.com>
-rw-r--r-- | cui/inc/tipoftheday.hrc | 615 | ||||
-rw-r--r-- | cui/source/dialogs/tipofthedaydlg.cxx | 7 |
2 files changed, 312 insertions, 310 deletions
diff --git a/cui/inc/tipoftheday.hrc b/cui/inc/tipoftheday.hrc index f633bdc458a9..fbe7408a3bd9 100644 --- a/cui/inc/tipoftheday.hrc +++ b/cui/inc/tipoftheday.hrc @@ -22,319 +22,320 @@ #define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" u8##String) + /* * text beginning with "html" will be used until the end as hyperlink * use \\ to show \ - * place accompanying images at extra/source/tipoftheday and name tipoftheday_<id>.png, e.g. tipoftheday_1.png - * add the files to vcl/Package_tipoftheday.mk + * place accompanying images at extra/source/tipoftheday and add the file name here as second parameter + * don't forget to add the files to vcl/Package_tipoftheday.mk */ -const char* TIPOFTHEDAY_STRINGARRAY[] = +const std::pair<const char*, OUString> TIPOFTHEDAY_STRINGARRAY[] = { - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has the ask.libreoffice.org portal where you may get help from the community. https://ask.libreoffice.org/"), - NC_("RID_CUI_TIPOFTHEDAY", "You can easily convert your documents to PDF with one click by clicking the PDF icon in the toolbar."), - NC_("RID_CUI_TIPOFTHEDAY", "Editable PDFs? Yes, you can create Hybrid PDFs with LibreOffice. https://wiki.documentfoundation.org/Documentation/HowTo/CreateAHybridPDF"), - NC_("RID_CUI_TIPOFTHEDAY", "You can select the new Sifr icon set from Tools > Options... > LibreOffice > View > User Interface > Icon size and style."), - NC_("RID_CUI_TIPOFTHEDAY", "You can easily create fillable form documents (even PDF's) with LibreOffice"), - NC_("RID_CUI_TIPOFTHEDAY", "You can use your Android or iPhone to remotely control your Impress presentation"), - NC_("RID_CUI_TIPOFTHEDAY", "Something about rollAPP? You can use LibreOffice on your iPad or Chrome OS via rollApp"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has great extensions to increase your productivity on its Extension Center, check it out. https://extensions.libreoffice.org/"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has a template center to create good looking documents, check it out. http://templates.libreoffice.org/template-center"), - NC_("RID_CUI_TIPOFTHEDAY", "You can use font embedding for greater interoperability with other office suites/oses "), - NC_("RID_CUI_TIPOFTHEDAY", "Conditional formatting..."), - NC_("RID_CUI_TIPOFTHEDAY", "XSLT and xml filters http://fridrich.blogspot.com.tr/2013/08/extending-swiss-army-knife-overview.html "), - NC_("RID_CUI_TIPOFTHEDAY", "Zotero is an extensions for better bibliography citation management for Academic works and students https://www.zotero.org/download/"), - NC_("RID_CUI_TIPOFTHEDAY", "Mendeley is an extensions for better bibliography citation management for Academic works and students http://www.mendeley.com/"), - NC_("RID_CUI_TIPOFTHEDAY", "You can change the appearance of LibreOffice with Firefox Personas https://addons.mozilla.org/firefox/themes/"), - NC_("RID_CUI_TIPOFTHEDAY", "You can change the splash screen of LibreOffice for your own taste"), - NC_("RID_CUI_TIPOFTHEDAY", "You can disable the splash screen "), - NC_("RID_CUI_TIPOFTHEDAY", "You can speed-up/fine tune LibreOffice's performance http://oldpapyrus.wordpress.com/2012/06/28/reduce-libreoffice-memory-usage/"), - NC_("RID_CUI_TIPOFTHEDAY", "You can use Quickstart to open LibreOffice quicker"), - NC_("RID_CUI_TIPOFTHEDAY", "Have you tried our new sidebar- Appearance- Sidebar"), - NC_("RID_CUI_TIPOFTHEDAY", "Have you known that LibreOffice has great documentation and free user guide books http://www.libreoffice.org/get-help/documentation/ "), - NC_("RID_CUI_TIPOFTHEDAY", "Embedded help can save lives. Just click F1 to reach the embedded help, if you've installed it. Otherwise you may benefit from this huge content online at http://help.libreoffice.org"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has a portable version which gives you mobility. If you don't have administrator rights on your computer you may install LibreOffice Portable to your hard drive too http://www.libreoffice.org/download/portable-versions/"), - NC_("RID_CUI_TIPOFTHEDAY", "How to remove pagebreaks from a .docx document that someone sent you, where there are pagebreaks for each sentence in the document."), - NC_("RID_CUI_TIPOFTHEDAY", "Open 1 document in 2 windows"), - NC_("RID_CUI_TIPOFTHEDAY", "Format one or more characters with a border available since 4.2"), - NC_("RID_CUI_TIPOFTHEDAY", "Generate fully customized PDF documents: you can define the exact pdf format, image compression, comments, access rights, password. File > Export as PDF"), - NC_("RID_CUI_TIPOFTHEDAY", "Right-click context menu on bottom left scrollbar arrows to switch sheets"), - NC_("RID_CUI_TIPOFTHEDAY", "CMIS protocol support to access Document Management Systems"), - NC_("RID_CUI_TIPOFTHEDAY", "Use Data › Statistics for Sampling, Descriptive Statistics, Analysis of Variance, Correlation, Covariance, Exponential Smoothing, Moving Avg"), - NC_("RID_CUI_TIPOFTHEDAY", "Right-click in the status bar and select 'Selection count' to display the number of selected cells"), - NC_("RID_CUI_TIPOFTHEDAY", "Insert › Image › Photo Album to create slideshows from a series of pictures with the 'Photo Album' feature"), - NC_("RID_CUI_TIPOFTHEDAY", "Take a look at the new 'Gallery' (Images & sounds, fifteen themes: Arrows, Bullets, Computers, Environment, Finance, School, Symbols...)"), - NC_("RID_CUI_TIPOFTHEDAY", "Did you know that you can attach comments to portions of text?"), - NC_("RID_CUI_TIPOFTHEDAY", "Need to insert the date in a cell? Type Ctrl+; (Shift+Ctrl+; to insert the time)"), - NC_("RID_CUI_TIPOFTHEDAY", "You want to sort a series such as A1, A2, A3, A11, A15, not in alphabetical order but on the number? Enable natural sort in the Options tab"), - NC_("RID_CUI_TIPOFTHEDAY", "Need to move one or more paragraphs? No need to cut and paste: Use the keyboard shortcut Ctrl+Alt+Arrow (Up/Down)"), - NC_("RID_CUI_TIPOFTHEDAY", "Delete a col of a table (writer) without changing the column widths? Click the column, press Alt+Del 3 seconds then press left/right arrow"), - NC_("RID_CUI_TIPOFTHEDAY", "With #libreoffice is easy to set-up a custom palette. Here's a videoguide: http://impress.paolopelloni.it/2012/06/22/how-create-custom-colour-palette-libreoffice-impress/"), - NC_("RID_CUI_TIPOFTHEDAY", "Presenter console is a great feature when presenting with Impress. Have you checked it out?"), - NC_("RID_CUI_TIPOFTHEDAY", "Impress offers you different keys to control your slide presentation: http://impress.paolopelloni.it/2012/07/24/the-right-keys-to-press-when-presenting-with-impress/"), - NC_("RID_CUI_TIPOFTHEDAY", "Do you know that since version 3.5 colour palette is embedded in the document for greater portability?"), - NC_("RID_CUI_TIPOFTHEDAY", "You can automatically mark alphabetical index entries using a concordance file."), - NC_("RID_CUI_TIPOFTHEDAY", "Frames can be linked so that the text can flow from one to the other as in desktop publishing."), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice supports 110 languages https://wiki.documentfoundation.org/Language_support_of_LibreOffice"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice supports 4 macros security levels (from low to very high) and trusted sources"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice allows you to use assistive tools, such as external screen readers, Braille devices or speech recognition input devices."), - NC_("RID_CUI_TIPOFTHEDAY", "Title page: one single instruction to insert, number the pages, choose the layout..."), - NC_("RID_CUI_TIPOFTHEDAY", "Batch convert your MS Office documents to OpenDocument format by the Document Converter wizard"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice intends to apply as an organization for Google Summer of Code (GSoC) see https://wiki.documentfoundation.org/Development/GSoC"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has a certification program. Interested? See http://www.documentfoundation.org/certification"), - NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Tools›Options›Calc›View›Zoom: 'Synchronize sheets' so that each sheet has its own zoom factor"), - NC_("RID_CUI_TIPOFTHEDAY", "To open a CSV file as a new sheet in the current spreadsheet use Insert›Sheet from file"), - NC_("RID_CUI_TIPOFTHEDAY", "You write a book? LibreOffice master document lets you manage large documents as a container for individual LibreOffice Writer files."), - NC_("RID_CUI_TIPOFTHEDAY", "Show summary slide: right click and 'goto slide' or Ctrl+Shift+F5 to display the browser and that gives you a pointer to draw on the slides"), - NC_("RID_CUI_TIPOFTHEDAY", "Need to move a writer table? Select whole table, Insert›Frame›Check Autosize›Ok, Move where you want !"), - NC_("RID_CUI_TIPOFTHEDAY", "In Draw to change the 0 point of the rulers, drag the intersection of the two rulers in the top left corner into the workspace"), - NC_("RID_CUI_TIPOFTHEDAY", "To change the default options for Drawing toolbar tools, select one of the tools and define the options before drawing the first object"), - NC_("RID_CUI_TIPOFTHEDAY", "Use array formula to repeat calculation using different values: they need less disk space & consume little memory"), - NC_("RID_CUI_TIPOFTHEDAY", "Enable massive parallel calculations of formula cells via OpenCL formula option"), - NC_("RID_CUI_TIPOFTHEDAY", "You have a mouse with a scroll wheel? you can hold down Ctrl and turn the wheel to change the zoom factor in all main modules of LibreOffice"), - NC_("RID_CUI_TIPOFTHEDAY", "In writer use the 'content view' of the navigator to synchronize the cursor position & the title"), - NC_("RID_CUI_TIPOFTHEDAY", "Edit Find & Replace lets you insert special characters directly: right click in 'search for' or 'replace by' zone (Ctrl+Shift+S)"), - NC_("RID_CUI_TIPOFTHEDAY", "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"), - NC_("RID_CUI_TIPOFTHEDAY", "Drag a formatted object to the Styles and Formatting window. A dialog box opens, just enter the name of the new style."), - NC_("RID_CUI_TIPOFTHEDAY", "Besides styles, customizations menus and toolbars can be saved in a template"), - NC_("RID_CUI_TIPOFTHEDAY", "Tools›Options›LibreOffice›Color lets you edit and create colors available in all LibreOffice documents"), - NC_("RID_CUI_TIPOFTHEDAY", "To edit a not showed comment in Calc, right-click the cell and choose Insert comment. Edit then click outside the comment (hidden again)"), - NC_("RID_CUI_TIPOFTHEDAY", "In Calc use TRIMMEAN() to return the mean of a data set excluding the highest and lowest values"), - NC_("RID_CUI_TIPOFTHEDAY", "To keep the zeros before a number, use the 'leading zeroes' cell format option or format the cell as text before entering the number"), - NC_("RID_CUI_TIPOFTHEDAY", "To copy a comment without losing the content of the target cell : Paste Special›uncheck everything except Comments. Operations select Add"), - NC_("RID_CUI_TIPOFTHEDAY", "With Calc calculate loan repayments: eg. PMT(2%/12;36;2500) interest rate per payment period 2%/12, 36 months, loan amount 2500"), - NC_("RID_CUI_TIPOFTHEDAY", "To create a chart on another sheet than where the data is, start to create the chart in the other sheet. You can then select the data"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc, Writer... to select an object in the background use the tool Select in the Draw toolbar to surround the object to select"), - NC_("RID_CUI_TIPOFTHEDAY", "Using Writer, apply Heading paragraph styles with Shortcut Keys: Ctrl+1 applies Heading 1, Ctrl+2 applies Heading 2, etc."), - NC_("RID_CUI_TIPOFTHEDAY", "In Calc mix portrait and landscape orientations in a spreadsheet by applying different page styles on sheets"), - NC_("RID_CUI_TIPOFTHEDAY", "In Writer Sections can protect part of text, show/hide text, reuse parts from other documents, use different column layout"), - NC_("RID_CUI_TIPOFTHEDAY", "To choose the medium and the background of your presentation select File›Wizards›Presentation›Page 2"), - NC_("RID_CUI_TIPOFTHEDAY", "You can create many master pages in a presentation template: View›Master›Slide Master›New Master (toolbar or right click in Slide Pane)"), - NC_("RID_CUI_TIPOFTHEDAY", "Draw/Impress: 'Fit object to paper format' (Format›Page) resizes the objects so that they fit on the paper format that you select"), - NC_("RID_CUI_TIPOFTHEDAY", "You want to modify an AutoPlay presentation? Open it, it starts, right click›Edit the presentation "), - NC_("RID_CUI_TIPOFTHEDAY", "Rename your slides to help you define 'Go to page' interactions and have a summary more explicit than Slide1, Slide2..."), - NC_("RID_CUI_TIPOFTHEDAY", "To play a music throughout a slideshow, assign the sound to the first slide transition without clicking the Apply to All Slides button"), - NC_("RID_CUI_TIPOFTHEDAY", "With Slide Show›Custom Slide Show you can reorder and pick slides to fit a slideshow to public needs"), - NC_("RID_CUI_TIPOFTHEDAY", "To include a paragraph that is not a title in the TOC, edit the paragraph, Outline & Numbering tab select the outline level"), - NC_("RID_CUI_TIPOFTHEDAY", "Impress: Select a layout directly when inserting a slide by long click on the +Slide button on the Presentation toolbar"), - NC_("RID_CUI_TIPOFTHEDAY", "Draw/Impress: Use the Connector tool from the Drawing toolbar to draw flowcharts. You can copy and paste into writer"), - NC_("RID_CUI_TIPOFTHEDAY", "The Navigator's Open Documents List allow to select a document in the list. You can then drag & drop an item to another document"), - NC_("RID_CUI_TIPOFTHEDAY", "Draw: Want to see an object but do not print? Draw it or move it to a new layer unprintable"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to stop base forms from going to the next record when you tab from the last field ? Select Active record in the Cycle list (data tab)"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to print 2 portrait pages on a landscape one (reducing A4 to A5)? File›Print›Page Layout tab, select 2 pages per page"), - NC_("RID_CUI_TIPOFTHEDAY", "To be able to get the Vertical Text tool in Drawing toolbar check Tool›Options›Language Settings›Languages›Default languages›Asian"), - NC_("RID_CUI_TIPOFTHEDAY", "Draw/Impress: double-click a tool in drawing toolbar to use it for multiple tasks"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to display only the highest 10 values in a spreadsheet? Data›Filter›AutoFilter›Standard click the drop-down arrow›Top10"), - NC_("RID_CUI_TIPOFTHEDAY", "You can not modify or delete a custom cell style? Check all sheets: none should be protected"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want to get the number of days in month? Try =DAYSINMONTH(TODAY())"), - NC_("RID_CUI_TIPOFTHEDAY", "Do you know that the Styles & Formatting dialog allows you to hide the styles you do not use?"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc displays Err: followed by a number? This page gives the explanation https://help.libreoffice.org/Calc/Error_Codes_in_Calc "), - NC_("RID_CUI_TIPOFTHEDAY", "Want something else than a color as cell background? Drag a background from the Gallery, resize then right click›Arrange To Background"), - NC_("RID_CUI_TIPOFTHEDAY", "To quickly get a math object in Writer type your formulas, mark it then Insert›Object›Formula"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer inserts a blank page between two odd (even) pages that follow. Use File›Print›Writer tab›Print inserted blank pages as per your need"), - NC_("RID_CUI_TIPOFTHEDAY", "The 4th optional parameter of VLOOKUP Calc function tells whether the first column of data is sorted. If not, enter FALSE or zero"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to show hidden col A? Click a cell in col B, keep the left mouse button, move the mouse to the left, release. Format›Column›Show"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer helps you to make backups: with File›Save a copy you create a new document continuing to work on the original. Be safe!"), - NC_("RID_CUI_TIPOFTHEDAY", "You have to present a report written with Writer? File›Send›Outline to Presentation automatically creates your slideshow from the outline"), - NC_("RID_CUI_TIPOFTHEDAY", "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"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: to copy the table cells' background, use the Format Paintbrush of the Standard ToolBar"), - NC_("RID_CUI_TIPOFTHEDAY", "Draw/Impress›Right click›Alignment to center the selection: on the page if 1 object or a group, on the selection if several objects"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to find the words in bold in a Writer doc? Edit›Find&Replace›Other options›Attributes›Font weight (check Including styles if needed)"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to repeat the heading on next page when a table spans more than one page? Table›Table Properties›Text Flow tab›Check Repeat heading"), - NC_("RID_CUI_TIPOFTHEDAY", "You can use the column (row) labels in formulas. Eg. you have 2 columns, Time & KM, use =Time/KM to get minutes per kilometer (apply hour format)"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: To change the number of a page, edit its first paragraph›Flow tab check Break›Insert and give the number (0 for continuous numbering)"), - NC_("RID_CUI_TIPOFTHEDAY", "Do you want the cursor to go into the cell to the right, after you've entered a value in a cell? Use the Tab key instead of the Enter key"), - NC_("RID_CUI_TIPOFTHEDAY", "Impress provides you with a simple animation editor to create an animated GIF: Insert›Animated Image"), - NC_("RID_CUI_TIPOFTHEDAY", "Since LibreOffice version 4.1, you can show or hide comments in Writer by clicking the comment toggle button in the rule"), - NC_("RID_CUI_TIPOFTHEDAY", "In Calc, it is no longer necessary to use RAND or RANDBETWEEN function to generate a random series. Use Edit›Fill›Random Number"), - NC_("RID_CUI_TIPOFTHEDAY", "Fit your sheet or print ranges to a page with Format›Page›Sheet Tab›Scaling Mode"), - NC_("RID_CUI_TIPOFTHEDAY", "To keep visible column headers of a sheet when scrolling lines, use Windows›Freeze (or Windows›Split if scrollable header needed)"), - NC_("RID_CUI_TIPOFTHEDAY", "Want your chapter titles to always begin a page? Edit Heading1 (paragraph style)›Flow tab›Breaks›check Insert›Page›Before"), - NC_("RID_CUI_TIPOFTHEDAY", "Do you want to keep the text but remove a hyperlink in Writer? Right click on the link›Remove Hyperlink"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to remove all <> at once & keep the text inside? Edit›Find & Replace›Search›[<|>]›Replace›blank›Other Options›check Regular expressions"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Use Format›Conditional Formatting›Manage to find out which are the cells for which conditional formatting has been defined"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: To create a chart based on a Writer table, click in the table and then Insert›Object›Chart"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Move a column between 2 others in 1 step? Click header then a cell in the col, keep mouse button and move to the target with Alt key"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Use the Backspace key instead of Delete. You can choose what to delete"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Want to distribute some text in multi-columns? Select the text then Format›Columns"), - NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Slide Show›Settings›Always on top if you need another program displays its window to the front of your presentation"), - NC_("RID_CUI_TIPOFTHEDAY", "Tools›Detective›Mark Invalid Data Marks all cells in the sheet that contain values outside the validation rules"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Need to allow changes to parts of a read-only document? Insert frames or sections that can authorize changes"), - NC_("RID_CUI_TIPOFTHEDAY", "Select options in Tools›Options›Writer›Formatting Aids›Display to specify which nonprinting characters are displayed"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want the same layout for the screen display and printing? Check Tools›Options›Calc›General›Use printer metrics for text formatting"), - NC_("RID_CUI_TIPOFTHEDAY", "Customize your footnotes page with Tools›Footnotes/Endnotes"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to sum a cell through several sheets? Refer to the range of sheets (insert/delete sheet handled) e.g. =SUM(Sheet1.A1:Sheet3.A1)"), - NC_("RID_CUI_TIPOFTHEDAY", "You can copy from one sheet to another without the clipboard. Select the area to copy›ctrl+click the target sheet's tab›Edit›Fill›Sheets"), - NC_("RID_CUI_TIPOFTHEDAY", "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"), - NC_("RID_CUI_TIPOFTHEDAY", "Click a col field (row) PivotTable and press F12 to group data. Choices adapt to content: Date (month, quarter, year), number (classes)"), - NC_("RID_CUI_TIPOFTHEDAY", "Apart from table of contents LibreOffice can create Alphabetical, Illustrations, Tables, Objects, Bibliography, User-Defined indexes"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to count words for just one paragraph style? Use Find & Replace›Search for Styles›select the style›Find All. Look at the status bar"), - NC_("RID_CUI_TIPOFTHEDAY", "With LibreOffice you can use your Google Mail account to do a mail merge. Fill in Tools›Options›Writer›Mail Merge E-mail"), - NC_("RID_CUI_TIPOFTHEDAY", "Toolbars are contextual, they open depending on the context. If you do not want that, uncheck them from the View Toolbars menu"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Insert and number your formulas in one step: type fn then F3. An AutoText is inserted with formula and number aligned in a table"), - NC_("RID_CUI_TIPOFTHEDAY", "There are Themes to customize LibreOffice: Tools›Customize (menu, keyboard, toolbars, events)"), - NC_("RID_CUI_TIPOFTHEDAY", "To automatically number your table rows in Writer, select the relevant column, then apply a numbering style from List Styles"), - NC_("RID_CUI_TIPOFTHEDAY", "Delete in one step all of your printing areas: select all sheets then Format›Print Ranges›Clear"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice helps you not to enter two or more spaces in Writer. Check Tools›AutoCorrect Options›Ignore double spaces"), - NC_("RID_CUI_TIPOFTHEDAY", "Transpose a writer table? Copy-Paste in Calc. Transpose with Copy-Paste special then Copy-paste special›Formatted text in writer"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer lets you number your footnotes per page, chapter, document: Tools›Footnotes/Endnotes›Footnotes tab›Counting"), - NC_("RID_CUI_TIPOFTHEDAY", "Left-handed? Check Tools›Options›Language Settings›Languages›Asian & Writer›View›Ruler›Right-aligned Displays the scrollbar to the left"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: To display the scrollbar to the left Check Tools›Options›Language Settings›Languages›Complex text & Format›Sheet›Right-To-Left"), - NC_("RID_CUI_TIPOFTHEDAY", "To insert Calc cells in a Writer table copy the cells›Paste special›Format RTF in Writer out of the table›copy this new table in your table"), - NC_("RID_CUI_TIPOFTHEDAY", "Your numbers are displayed as ### in your spreadsheet? The column is too narrow to display all digits"), - NC_("RID_CUI_TIPOFTHEDAY", "In a chart you can choose to leave a gap, assume zero or continue a line & you can include values from hidden cells or not"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: use Ctrl+Alt+Shift+V to paste the contents of the clipboard as unformatted text"), - NC_("RID_CUI_TIPOFTHEDAY", "59.a (alternative) Need more pasting options? Use 'Paste Special' via Edit - Special paste or press Ctrl+Shift+V"), - NC_("RID_CUI_TIPOFTHEDAY", "When editing a cell in place, you can right click›Insert fields: Date, Sheet name, Title"), - NC_("RID_CUI_TIPOFTHEDAY", "Wrap Text Around an Object in Writer: Select the graphic›Right-click›Wrap›Edit Contour"), - NC_("RID_CUI_TIPOFTHEDAY", "Slide Show›Slide Show Settings›Type›Auto: Restarts the slide show after the pause interval you specify"), - NC_("RID_CUI_TIPOFTHEDAY", "In LibreOffice Calc, document sharing allows simultaneous write access for many users"), - NC_("RID_CUI_TIPOFTHEDAY", "You can delete multiple custom styles at once: select them›right click›Delete"), - NC_("RID_CUI_TIPOFTHEDAY", "The Calc's keyboard shortcut to toggle between relative and absolute references is Shift + F4"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc's keyboard shortcut to toggle between relative and absolute references is F4"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: You can not see all the text in a cell? Expand the input line in the formula bar, you can scroll"), - NC_("RID_CUI_TIPOFTHEDAY", "You often create a document from another? Have you considered using a template?"), - NC_("RID_CUI_TIPOFTHEDAY", "New versions do not bring that new features and bug fixes. They also include security patches. Be safe, put yourself updated!"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want to duplicate the above line? Click the row header and then press Ctrl + D"), - NC_("RID_CUI_TIPOFTHEDAY", "You can embed copied graphics from web to your docs via Edit - Links - Break Link "), - NC_("RID_CUI_TIPOFTHEDAY", "You can easily arrange size table rows and columns - Right click - Row(or Columns) - Optimal Height and Width"), - NC_("RID_CUI_TIPOFTHEDAY", "Best way to fix bad looking MS Word table cells via Right click - Row(or Columns) - Optimal Height and Width (Or Table AutoFit)"), - NC_("RID_CUI_TIPOFTHEDAY", "Don't get lost in long%large documents. Use Navigator(F5) to find your way through the content."), - NC_("RID_CUI_TIPOFTHEDAY", "Want to change a word which appears multiple places many place Use Find&Replace to save time."), - NC_("RID_CUI_TIPOFTHEDAY", "You can use various table styles via Table - AutoFormat to have good looking tables"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to select a large range of cells without scrolling? Type the range reference (e.g. A1:A1000) in the name box then Enter"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc›Data›Validity allows you to create drop-down lists for the user selects instead of typing"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc›Format›Page›Sheet Tab›Print:Grid can avoid you draw borders"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to center cells on a printed page? Format›Page›Page Tab›Layout settings›Table alignment"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Want to change basic fonts for the predefined template or Current document? Tools›Options›Writer›Basic Fonts"), - NC_("RID_CUI_TIPOFTHEDAY", "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"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: you can import data from Data Sources view as you do in Writer with Data to Text button (creates a refreshable datarange)"), - NC_("RID_CUI_TIPOFTHEDAY", "You can drag and drop a contiguous range of cells in a chart to redefine"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice uses Regexp ICU’s engine (International Components for Unicode)"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc›View›Value Highlighting displays cell contents in colors: Text/black, Formulas/green, Numbers/blue, Protected cells/grey background"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: to show formulas instead of results in cells Tools›Options›Calc›View›Display›Formulas or check Format›Page›Sheet tab›Print›Formulas"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Want to reach a page by its number? F5 to open the navigator›Type the number in the field›Enter"), - NC_("RID_CUI_TIPOFTHEDAY", "With Edit›AutoText›Import you can select Word document or template, containing the AutoText entries that you want to import"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc can display a number or a calculation as a fraction: Format›Cells›Number tab›Category›Fraction"), - NC_("RID_CUI_TIPOFTHEDAY", "To print the notes of your slides File›Print›General tab›Select Notes in the Print listbox"), - NC_("RID_CUI_TIPOFTHEDAY", "Draw: To Move an object to another Layer›Hold it until its edges flash›Drag to the name tab of the layer you want to move it to›Release"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to exclude duplicate rows in a spreadsheet? Use Data›Filter›Standard Filter›Options›No duplications"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to find words more than 10 characters? Edit›Find & Replace›Search›\\<[a-z]{10,}›Other Options›Check Regular expressions"), - NC_("RID_CUI_TIPOFTHEDAY", "You delete instead of insert? You are in overwrite mode. Press the Insert key on the keyboard or click in the status bar on Overwrite"), - NC_("RID_CUI_TIPOFTHEDAY", "Surprised that Writer adds blank pages in a mailing? Would you like to have a recipient letter to the back of another (Duplexing)?"), - NC_("RID_CUI_TIPOFTHEDAY", "Help users to insert a picture in a Writer template? Insert›Fields›Other›Functions tab›PlaceHolder›Image. One Click to select an image"), - NC_("RID_CUI_TIPOFTHEDAY", "Have you checked Tools›Options›Load/Save›General›Always create backup copy ?"), - NC_("RID_CUI_TIPOFTHEDAY", "Create a master document from the current Writer document? File›Send›Create Master Document (sub-document created depending of outline)"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer includes LibreLogo: simple Logo-like programming environment with turtle vector graphics, DTP and graphic design"), - NC_("RID_CUI_TIPOFTHEDAY", "Need custom acceptance date format? Tools›Options›Language Settings›Language›Date acceptance patterns"), - NC_("RID_CUI_TIPOFTHEDAY", "Typing in bold italics or underlined in Writer you can continue with the default attributes using only the shortcut Ctrl+Shift+X"), - NC_("RID_CUI_TIPOFTHEDAY", "Looking WordArt in LibreOffice? Click Fontwork gallery in the Drawing Toolbar"), - NC_("RID_CUI_TIPOFTHEDAY", "To protect cells: Tools›Protect Document›Sheet. To prevent insert, delete, rename, move/copy sheets: Tools›Protect›Document›Document"), - NC_("RID_CUI_TIPOFTHEDAY", "Search by default in several sheets, select them before you start the search"), - NC_("RID_CUI_TIPOFTHEDAY", "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"), - NC_("RID_CUI_TIPOFTHEDAY", "You don't like the selection color ? Uncheck or modify Tools›Options›LibreOffice›View›Selection›Transparency"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: a date is a formatted number of days since a date origin. An hour is a day divided by 24: noon = 0.5"), - NC_("RID_CUI_TIPOFTHEDAY", "Need custom contents for metadata properties? File›Properties›Custom Properties tab lets you create what you want"), - NC_("RID_CUI_TIPOFTHEDAY", "Customize›ToolbarModify›Change Icon›Import to use your icons for toolbars (only PNG file format and 16x16 or 26x26 pixels)"), - NC_("RID_CUI_TIPOFTHEDAY", "Insert your metadata in your Writer document: Insert›Fields›Other›Document or DocInformation tabs"), - NC_("RID_CUI_TIPOFTHEDAY", "You are missing a label at the beginning of each page? Delete the 'Next Record' field from the last label, it is implicit"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: To delete multiple comments, Copy the range›Edit›Paste Special›Selection›Everything except Comments"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: you would like to view the calculation of individual elements of a formula, select the respective elements and press F9"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: you can rotate cells table orientation with Table›Table Properties›Text Flow tab›Text orientation"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice can automatically add a numbered caption when you insert an object. See Tools›Options›LibreOffice Writer›AutoCaption"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want to add x months to a date? Use =EDATE(date;months)"), - NC_("RID_CUI_TIPOFTHEDAY", "Many images in your writer document? Speed up the display by disabling Tools›Options›LibreOffice Writer›View›Graphics and objects"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Shift+Ctrl+Del deletes from cursor to the end of the current sentence. If the cursor is at the end of a cell, same for the next cell"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Want to sort paragraphs or table rows alphabetically or numerically? Select them›Tools›Sort"), - NC_("RID_CUI_TIPOFTHEDAY", "To bring back a cell on screen after entering formula for which you need to scroll the sheet, select the cell before typing"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Need an unnumbered item in a list? Use 'Insert Unnumbered Entry' in Bullets and Numbering toolbar"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to open/save to favourite places? Enable Tools›Options›LibreOffice›General›Use LibreOffice dialogs lets you record shortcuts"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Click a row header›Ctrl++›Ctrl+D duplicates the above row, including formulas. Just type new values"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Trace cells used in a formula, precedents (Shift+F7) or dependants (Shift+F5). For each hit you go one more step in the chain"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to sort a pivot table? Click on drop-list's arrow in the row/col header and select sort method: ascending, descending or custom"), - NC_("RID_CUI_TIPOFTHEDAY", "Sticky templates (user & shared template folders) let you apply style changes when you open a document created from the template"), - NC_("RID_CUI_TIPOFTHEDAY", "Tools›AutoCorrect›Replace provides a list of common substitutions. Take a look and complete with your own replacements"), - NC_("RID_CUI_TIPOFTHEDAY", "Center a picture in a Writer Table's cell? Anchor as ›Center buttons in Formatting (horizontally) & Table (vertically) toolbars"), - NC_("RID_CUI_TIPOFTHEDAY", "Do not insert empty paragraph to separate two paragraphs, set Indents & Spacing›Spacing›Below paragraph for the paragraph style"), - NC_("RID_CUI_TIPOFTHEDAY", "Want your documents open where you were when last saved? Fill Tools›Options›LibreOffice›User Data First/Last name"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: with the navigator you can select & move up/down headings and the text below the heading, in the Navigator and in the document"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice doesn't calculate from left to right but respects the order Parentheses›Exponents›Multiplication›Division›Addition›Subtraction"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: you can change the default function in the status bar: right click on the area"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: you do not want to print all columns? Hide or group ones you do not need"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: use Shift+Space to select the current row & Ctrl+Shift+Space to select the current column (previous versions)"), - NC_("RID_CUI_TIPOFTHEDAY", " Calc: use Shift+Space to select the current row & Ctrl+Space to select the current column"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer handles Conditional styles: paragraph styles that have different properties depending on the context"), - NC_("RID_CUI_TIPOFTHEDAY", "Install/LibreOffice not working? Have you checked the integrity of the download? On Download page click on Info to get the checksums"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: want to show the current date in your document? Insert›Fields›Other›Document tab›select Date (not fixed)›select a format"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Need to fill a serie? Select the cell range›Edit›Fill›Series›Choose between Linear, Growth, Date and AutoFill"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Click at the beginning (end) of a section and press Alt+Enter to insert a paragraph before (after) the section"), - NC_("RID_CUI_TIPOFTHEDAY", "With File›Versions Save multiple versions of the document in the same file. You can also open, delete, and compare previous versions"), - NC_("RID_CUI_TIPOFTHEDAY", "You change computers and want to recover your customizations? See https://wiki.documentfoundation.org/UserProfile"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: You can set a color for each tab: right-click the tab›Tab ColourfA"), - NC_("RID_CUI_TIPOFTHEDAY", "Looking for examples of LibreOffice Basic macros? Look at LibreOffice Macros›Tools"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Insert›Function List opens a resizable dockable window which displays all functions that can be inserted into your document"), - NC_("RID_CUI_TIPOFTHEDAY", "Don't want the page number in your TOC? Edit index›Delete Tab Stop & Page number from Structure Line in Entries tab"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: to quickly assign a name to a range of cells, select it›type the name in the name box and press Enter"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Outline numbering lets you set text to be displayed before the chapter number. For example, type 'Chapter ' to display 'Chapter 1'"), - NC_("RID_CUI_TIPOFTHEDAY", "Base not only manages its own. Connect to main database engines: JDBC PostgreSQL MySQL LDAP Address book, MS Access ODBC Spreadsheet Text"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want to know if a cell is referred in formulas of other cells? Tools›Detective›Trace Dependents [Shift+F5]"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to customize the middle mouse button? Tools›Options›LibreOffice›View›Middle Mouse button"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: To delete picture's caption select the picture›Ctrl+X›There is only the legend's frame›Select›Delete›Ctrl+C to paste the picture"), - NC_("RID_CUI_TIPOFTHEDAY", "Base: Need a crosstab query ? Calc›Data›Pivot Table›Create›choose your registered Data source"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc Print: Repeat rows/columns on every pages? Format›Print Ranges›Edit›Click the Row/Col text box›drag the mouse in the sheet"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: To copy rows/cols to another sheet preserving heights/widths, select them by clicking the labels before copying"), - NC_("RID_CUI_TIPOFTHEDAY", "With LibreOffice it is very easy to install a new dictionary: they are supplied as an extension"), - NC_("RID_CUI_TIPOFTHEDAY", "Registered databases can also be used in Calc, for example to export your tables to CSV format"), - NC_("RID_CUI_TIPOFTHEDAY", "Need to precisely position? Alt+Arrow Keys move objects (shape, picture, formula...) by one pixel"), - NC_("RID_CUI_TIPOFTHEDAY", "Choose Hierarchical View in the Styles and Formatting window to see the links between styles"), - NC_("RID_CUI_TIPOFTHEDAY", "Print 2 A5 on A4? Check File›Print›Options tab›Use only paper size from printer & set A4 landscape orientation in the printer properties"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: The field names are displayed instead of their content? View›Fields Names or Ctrl + F9"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Creating a Style based on another, you can enter a percentage value or a point value (e.g. 110% or -2pt or +5pt)"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to know the valid Command Line Parameters? Start soffice with --help or -h or -?"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Want to return to default after applying a List Style? Click Bullets or Numbering On/Off tool on the Formatting toolbar"), - NC_("RID_CUI_TIPOFTHEDAY", "Configure use of the Ctrl key to follow hyperlinks? Tools›Options›LibreOffice›Security›Options›Ctrl+click required to follow hyperlinks"), - NC_("RID_CUI_TIPOFTHEDAY", "You get 'weird' characters opening a text file? Check the character set when importing"), - NC_("RID_CUI_TIPOFTHEDAY", "Open Document Format is the key. LibreOffice is the solution."), - NC_("RID_CUI_TIPOFTHEDAY", "For your safety, save your files to disk and then copy them to your USB key. Never do the opposite !"), - NC_("RID_CUI_TIPOFTHEDAY", "After a copy you can hit Esc to stop the 'marching ants'. The copied content will remain available for pasting"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: To quickly insert or delete rows, drag the mouse over the header to select the desired number of lines then Ctrl+ or Ctrl-"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Select contiguous cell range that contains data and is bounded by empty row and columns ? Use Ctrl+* (numeric key pad )"), - NC_("RID_CUI_TIPOFTHEDAY", "Tools›Customize›Keyboard›Save saves the current shortcut key configuration, so that you can load it later or on another computer"), - NC_("RID_CUI_TIPOFTHEDAY", "Property mapping for charts allows to change data serie's fill & border colors based on spreadsheet values"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Ctrl+Shift+F9 Recalculates all formulas in all sheets (some functions like RANDBETWEEN are not calculated by F9)"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: Write along a curve? Draw the line›Double click›Type the text›Format›Object›Fontwork... Have fun with the proposed effects"), - NC_("RID_CUI_TIPOFTHEDAY", "Click the bo4rders button adds borders to selected cells - Shift+Click replaces all borders of current cell with your choice"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: you can create an illustration index from Object names, not only from Captions"), - NC_("RID_CUI_TIPOFTHEDAY", "To enable macro recording check Tools›Options›LibreOffice›Advanced›Enable macro recording (limited)"), - NC_("RID_CUI_TIPOFTHEDAY", "In the Replace input field of AutoCorrection you can use the wildcards .*"), - NC_("RID_CUI_TIPOFTHEDAY", "You no longer find an option? Search in Tools›Options›LibreOffice›Advanced›Configuration Expert"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc - Want to export formulas to CSV? File›Save As›Type:Text CSV›Check Edit filter settings›Check Save cell formulas"), - NC_("RID_CUI_TIPOFTHEDAY", "Impress: set Handouts in File›Print›Document listbox›select the number of slides per page (lines automatically drawn if you pick 3)"), - NC_("RID_CUI_TIPOFTHEDAY", "Impress: Outline View. You cannot use Tab/Shift+Tab to move the title in the hierarchy with Title slide layout (apply Title, content)"), - NC_("RID_CUI_TIPOFTHEDAY", " Impress: Outline View. You cannot use Tab/Shift+Tab to move the title in the hierarchy with Title slide layout (apply Title, content"), - NC_("RID_CUI_TIPOFTHEDAY", "Want to manage the presentation of hyperlinks in a spreadsheet? Insert them with the HYPERLINK function"), - NC_("RID_CUI_TIPOFTHEDAY", "Tools›Customize›Keyboard› No need to scroll through the list to find a shortcut: just type the shortcut"), - NC_("RID_CUI_TIPOFTHEDAY", "Draw/Impress: Want to quickly zoom in on selection? Press the Divide Key (number pad) - Press * to restore entire page in screen"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want to quickly zoom in on range selection? Right click on the zoom part of the status bar, choose Optimal"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: to reformat all comments in a document click the down arrow in a comment and choose 'Format all Comments'"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: File›Print›Comments and choose Place in margins, end of page, end of document"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Convert formula into static values ? No need to copy-paste: Tools›Cell Contents›Formula to Value"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc: Can not get what you want with VLOOKUP? With INDEX and MATCH You can do everything!"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: LibreOffice 5.1 introduces Hide Whitespace option which removes gaps between pages, to help you really focus on your content"), - NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice 5.1 reorganize main menus in Writer, Calc and Impress to improve usability"), - NC_("RID_CUI_TIPOFTHEDAY", "Mailing: with LibreOffice 5.1 embed your datasource definition in the document"), - NC_("RID_CUI_TIPOFTHEDAY", "5.3 implements table styles in Writer, try them!"), - NC_("RID_CUI_TIPOFTHEDAY", "Calc 5.3 brings new cell styles, and the possibility to create your own x"), - NC_("RID_CUI_TIPOFTHEDAY", "New arrow endings in LibreOffice 5.3, including Crow's foot notation's ones "), - NC_("RID_CUI_TIPOFTHEDAY", "Grab the latest docker image from Docker Hub here: https://hub.docker.com/r/libreoffice/online "), - NC_("RID_CUI_TIPOFTHEDAY", "Release 5.3 features the first source release of LibreOffice Online "), - NC_("RID_CUI_TIPOFTHEDAY", "Calc now supports scrolling through the Scroll key"), - NC_("RID_CUI_TIPOFTHEDAY", "Now possible to sign existing PDF files and also verify those signatures"), - NC_("RID_CUI_TIPOFTHEDAY", "A safe mode has been added which starts LibreOffice temporarily with a fresh user profile"), - NC_("RID_CUI_TIPOFTHEDAY", "Menu Help: direct link to user guides, collateral documentation, help on line"), - NC_("RID_CUI_TIPOFTHEDAY", "You can now import AutoText import from .dotx and .dotm files"), - NC_("RID_CUI_TIPOFTHEDAY", "Version 5.4 introduces Pivot Charts"), - NC_("RID_CUI_TIPOFTHEDAY", "Writer: To find the expressions in brackets Edit›Find & Replace›Find›\\([^)]+\\)›set Regular expression"), + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has the ask.libreoffice.org portal where you may get help from the community. https://ask.libreoffice.org/"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can easily convert your documents to PDF with one click by clicking the PDF icon in the toolbar."), "tipoftheday_1.png" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Editable PDFs? Yes, you can create Hybrid PDFs with LibreOffice. https://wiki.documentfoundation.org/Documentation/HowTo/CreateAHybridPDF"), "tipoftheday_2.png" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can select the new Sifr icon set from Tools > Options... > LibreOffice > View > User Interface > Icon size and style."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can easily create fillable form documents (even PDF's) with LibreOffice"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can use your Android or iPhone to remotely control your Impress presentation"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Something about rollAPP? You can use LibreOffice on your iPad or Chrome OS via rollApp"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has great extensions to increase your productivity on its Extension Center, check it out. https://extensions.libreoffice.org/"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has a template center to create good looking documents, check it out. http://templates.libreoffice.org/template-center"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can use font embedding for greater interoperability with other office suites/oses "), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Conditional formatting..."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "XSLT and xml filters http://fridrich.blogspot.com.tr/2013/08/extending-swiss-army-knife-overview.html "), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Zotero is an extensions for better bibliography citation management for Academic works and students https://www.zotero.org/download/"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Mendeley is an extensions for better bibliography citation management for Academic works and students http://www.mendeley.com/"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can change the appearance of LibreOffice with Firefox Personas https://addons.mozilla.org/firefox/themes/"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can change the splash screen of LibreOffice for your own taste"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can disable the splash screen "), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can speed-up/fine tune LibreOffice's performance http://oldpapyrus.wordpress.com/2012/06/28/reduce-libreoffice-memory-usage/"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can use Quickstart to open LibreOffice quicker"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Have you tried our new sidebar- Appearance- Sidebar"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Have you known that LibreOffice has great documentation and free user guide books http://www.libreoffice.org/get-help/documentation/ "), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Embedded help can save lives. Just click F1 to reach the embedded help, if you've installed it. Otherwise you may benefit from this huge content online at http://help.libreoffice.org"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has a portable version which gives you mobility. If you don't have administrator rights on your computer you may install LibreOffice Portable to your hard drive too http://www.libreoffice.org/download/portable-versions/"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "How to remove pagebreaks from a .docx document that someone sent you, where there are pagebreaks for each sentence in the document."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Open 1 document in 2 windows"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Format one or more characters with a border available since 4.2"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Generate fully customized PDF documents: you can define the exact pdf format, image compression, comments, access rights, password. File > Export as PDF"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Right-click context menu on bottom left scrollbar arrows to switch sheets"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "CMIS protocol support to access Document Management Systems"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Use Data › Statistics for Sampling, Descriptive Statistics, Analysis of Variance, Correlation, Covariance, Exponential Smoothing, Moving Avg"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Right-click in the status bar and select 'Selection count' to display the number of selected cells"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Insert › Image › Photo Album to create slideshows from a series of pictures with the 'Photo Album' feature"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Take a look at the new 'Gallery' (Images & sounds, fifteen themes: Arrows, Bullets, Computers, Environment, Finance, School, Symbols...)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Did you know that you can attach comments to portions of text?"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Need to insert the date in a cell? Type Ctrl+; (Shift+Ctrl+; to insert the time)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You want to sort a series such as A1, A2, A3, A11, A15, not in alphabetical order but on the number? Enable natural sort in the Options tab"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Need to move one or more paragraphs? No need to cut and paste: Use the keyboard shortcut Ctrl+Alt+Arrow (Up/Down)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Delete a col of a table (writer) without changing the column widths? Click the column, press Alt+Del 3 seconds then press left/right arrow"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "With #libreoffice is easy to set-up a custom palette. Here's a videoguide: http://impress.paolopelloni.it/2012/06/22/how-create-custom-colour-palette-libreoffice-impress/"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Presenter console is a great feature when presenting with Impress. Have you checked it out?"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Impress offers you different keys to control your slide presentation: http://impress.paolopelloni.it/2012/07/24/the-right-keys-to-press-when-presenting-with-impress/"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Do you know that since version 3.5 colour palette is embedded in the document for greater portability?"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can automatically mark alphabetical index entries using a concordance file."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Frames can be linked so that the text can flow from one to the other as in desktop publishing."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice supports 110 languages https://wiki.documentfoundation.org/Language_support_of_LibreOffice"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice supports 4 macros security levels (from low to very high) and trusted sources"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice allows you to use assistive tools, such as external screen readers, Braille devices or speech recognition input devices."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Title page: one single instruction to insert, number the pages, choose the layout..."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Batch convert your MS Office documents to OpenDocument format by the Document Converter wizard"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice intends to apply as an organization for Google Summer of Code (GSoC) see https://wiki.documentfoundation.org/Development/GSoC"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has a certification program. Interested? See http://www.documentfoundation.org/certification"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Tools›Options›Calc›View›Zoom: 'Synchronize sheets' so that each sheet has its own zoom factor"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To open a CSV file as a new sheet in the current spreadsheet use Insert›Sheet from file"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You write a book? LibreOffice master document lets you manage large documents as a container for individual LibreOffice Writer files."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Show summary slide: right click and 'goto slide' or Ctrl+Shift+F5 to display the browser and that gives you a pointer to draw on the slides"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Need to move a writer table? Select whole table, Insert›Frame›Check Autosize›Ok, Move where you want !"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "In Draw to change the 0 point of the rulers, drag the intersection of the two rulers in the top left corner into the workspace"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To change the default options for Drawing toolbar tools, select one of the tools and define the options before drawing the first object"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Use array formula to repeat calculation using different values: they need less disk space & consume little memory"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Enable massive parallel calculations of formula cells via OpenCL formula option"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You have a mouse with a scroll wheel? you can hold down Ctrl and turn the wheel to change the zoom factor in all main modules of LibreOffice"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "In writer use the 'content view' of the navigator to synchronize the cursor position & the title"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Edit Find & Replace lets you insert special characters directly: right click in 'search for' or 'replace by' zone (Ctrl+Shift+S)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "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"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Drag a formatted object to the Styles and Formatting window. A dialog box opens, just enter the name of the new style."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Besides styles, customizations menus and toolbars can be saved in a template"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Tools›Options›LibreOffice›Color lets you edit and create colors available in all LibreOffice documents"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To edit a not showed comment in Calc, right-click the cell and choose Insert comment. Edit then click outside the comment (hidden again)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "In Calc use TRIMMEAN() to return the mean of a data set excluding the highest and lowest values"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To keep the zeros before a number, use the 'leading zeroes' cell format option or format the cell as text before entering the number"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To copy a comment without losing the content of the target cell : Paste Special›uncheck everything except Comments. Operations select Add"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "With Calc calculate loan repayments: eg. PMT(2%/12;36;2500) interest rate per payment period 2%/12, 36 months, loan amount 2500"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To create a chart on another sheet than where the data is, start to create the chart in the other sheet. You can then select the data"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc, Writer... to select an object in the background use the tool Select in the Draw toolbar to surround the object to select"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Using Writer, apply Heading paragraph styles with Shortcut Keys: Ctrl+1 applies Heading 1, Ctrl+2 applies Heading 2, etc."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "In Calc mix portrait and landscape orientations in a spreadsheet by applying different page styles on sheets"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "In Writer Sections can protect part of text, show/hide text, reuse parts from other documents, use different column layout"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To choose the medium and the background of your presentation select File›Wizards›Presentation›Page 2"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can create many master pages in a presentation template: View›Master›Slide Master›New Master (toolbar or right click in Slide Pane)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Draw/Impress: 'Fit object to paper format' (Format›Page) resizes the objects so that they fit on the paper format that you select"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You want to modify an AutoPlay presentation? Open it, it starts, right click›Edit the presentation "), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Rename your slides to help you define 'Go to page' interactions and have a summary more explicit than Slide1, Slide2..."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To play a music throughout a slideshow, assign the sound to the first slide transition without clicking the Apply to All Slides button"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "With Slide Show›Custom Slide Show you can reorder and pick slides to fit a slideshow to public needs"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To include a paragraph that is not a title in the TOC, edit the paragraph, Outline & Numbering tab select the outline level"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Impress: Select a layout directly when inserting a slide by long click on the +Slide button on the Presentation toolbar"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Draw/Impress: Use the Connector tool from the Drawing toolbar to draw flowcharts. You can copy and paste into writer"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "The Navigator's Open Documents List allow to select a document in the list. You can then drag & drop an item to another document"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Draw: Want to see an object but do not print? Draw it or move it to a new layer unprintable"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to stop base forms from going to the next record when you tab from the last field ? Select Active record in the Cycle list (data tab)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to print 2 portrait pages on a landscape one (reducing A4 to A5)? File›Print›Page Layout tab, select 2 pages per page"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To be able to get the Vertical Text tool in Drawing toolbar check Tool›Options›Language Settings›Languages›Default languages›Asian"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Draw/Impress: double-click a tool in drawing toolbar to use it for multiple tasks"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to display only the highest 10 values in a spreadsheet? Data›Filter›AutoFilter›Standard click the drop-down arrow›Top10"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can not modify or delete a custom cell style? Check all sheets: none should be protected"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want to get the number of days in month? Try =DAYSINMONTH(TODAY())"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Do you know that the Styles & Formatting dialog allows you to hide the styles you do not use?"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc displays Err: followed by a number? This page gives the explanation https://help.libreoffice.org/Calc/Error_Codes_in_Calc "), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want something else than a color as cell background? Drag a background from the Gallery, resize then right click›Arrange To Background"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To quickly get a math object in Writer type your formulas, mark it then Insert›Object›Formula"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer inserts a blank page between two odd (even) pages that follow. Use File›Print›Writer tab›Print inserted blank pages as per your need"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "The 4th optional parameter of VLOOKUP Calc function tells whether the first column of data is sorted. If not, enter FALSE or zero"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to show hidden col A? Click a cell in col B, keep the left mouse button, move the mouse to the left, release. Format›Column›Show"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer helps you to make backups: with File›Save a copy you create a new document continuing to work on the original. Be safe!"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You have to present a report written with Writer? File›Send›Outline to Presentation automatically creates your slideshow from the outline"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "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"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: to copy the table cells' background, use the Format Paintbrush of the Standard ToolBar"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Draw/Impress›Right click›Alignment to center the selection: on the page if 1 object or a group, on the selection if several objects"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to find the words in bold in a Writer doc? Edit›Find&Replace›Other options›Attributes›Font weight (check Including styles if needed)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to repeat the heading on next page when a table spans more than one page? Table›Table Properties›Text Flow tab›Check Repeat heading"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can use the column (row) labels in formulas. Eg. you have 2 columns, Time & KM, use =Time/KM to get minutes per kilometer (apply hour format)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: To change the number of a page, edit its first paragraph›Flow tab check Break›Insert and give the number (0 for continuous numbering)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Do you want the cursor to go into the cell to the right, after you've entered a value in a cell? Use the Tab key instead of the Enter key"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Impress provides you with a simple animation editor to create an animated GIF: Insert›Animated Image"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Since LibreOffice version 4.1, you can show or hide comments in Writer by clicking the comment toggle button in the rule"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "In Calc, it is no longer necessary to use RAND or RANDBETWEEN function to generate a random series. Use Edit›Fill›Random Number"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Fit your sheet or print ranges to a page with Format›Page›Sheet Tab›Scaling Mode"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To keep visible column headers of a sheet when scrolling lines, use Windows›Freeze (or Windows›Split if scrollable header needed)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want your chapter titles to always begin a page? Edit Heading1 (paragraph style)›Flow tab›Breaks›check Insert›Page›Before"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Do you want to keep the text but remove a hyperlink in Writer? Right click on the link›Remove Hyperlink"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to remove all <> at once & keep the text inside? Edit›Find & Replace›Search›[<|>]›Replace›blank›Other Options›check Regular expressions"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Use Format›Conditional Formatting›Manage to find out which are the cells for which conditional formatting has been defined"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: To create a chart based on a Writer table, click in the table and then Insert›Object›Chart"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Move a column between 2 others in 1 step? Click header then a cell in the col, keep mouse button and move to the target with Alt key"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Use the Backspace key instead of Delete. You can choose what to delete"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Want to distribute some text in multi-columns? Select the text then Format›Columns"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Slide Show›Settings›Always on top if you need another program displays its window to the front of your presentation"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Tools›Detective›Mark Invalid Data Marks all cells in the sheet that contain values outside the validation rules"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Need to allow changes to parts of a read-only document? Insert frames or sections that can authorize changes"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Select options in Tools›Options›Writer›Formatting Aids›Display to specify which nonprinting characters are displayed"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want the same layout for the screen display and printing? Check Tools›Options›Calc›General›Use printer metrics for text formatting"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Customize your footnotes page with Tools›Footnotes/Endnotes"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to sum a cell through several sheets? Refer to the range of sheets (insert/delete sheet handled) e.g. =SUM(Sheet1.A1:Sheet3.A1)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can copy from one sheet to another without the clipboard. Select the area to copy›ctrl+click the target sheet's tab›Edit›Fill›Sheets"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "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"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Click a col field (row) PivotTable and press F12 to group data. Choices adapt to content: Date (month, quarter, year), "" }, number (classes)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Apart from table of contents LibreOffice can create Alphabetical, Illustrations, Tables, Objects, Bibliography, User-Defined indexes"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to count words for just one paragraph style? Use Find & Replace›Search for Styles›select the style›Find All. Look at the status bar"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "With LibreOffice you can use your Google Mail account to do a mail merge. Fill in Tools›Options›Writer›Mail Merge E-mail"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Toolbars are contextual, they open depending on the context. If you do not want that, uncheck them from the View Toolbars menu"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Insert and number your formulas in one step: type fn then F3. An AutoText is inserted with formula and number aligned in a table"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "There are Themes to customize LibreOffice: Tools›Customize (menu, keyboard, toolbars, events)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To automatically number your table rows in Writer, select the relevant column, then apply a numbering style from List Styles"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Delete in one step all of your printing areas: select all sheets then Format›Print Ranges›Clear"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice helps you not to enter two or more spaces in Writer. Check Tools›AutoCorrect Options›Ignore double spaces"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Transpose a writer table? Copy-Paste in Calc. Transpose with Copy-Paste special then Copy-paste special›Formatted text in writer"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer lets you number your footnotes per page, chapter, document: Tools›Footnotes/Endnotes›Footnotes tab›Counting"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Left-handed? Check Tools›Options›Language Settings›Languages›Asian & Writer›View›Ruler›Right-aligned Displays the scrollbar to the left"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: To display the scrollbar to the left Check Tools›Options›Language Settings›Languages›Complex text & Format›Sheet›Right-To-Left"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To insert Calc cells in a Writer table copy the cells›Paste special›Format RTF in Writer out of the table›copy this new table in your table"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Your numbers are displayed as ### in your spreadsheet? The column is too narrow to display all digits"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "In a chart you can choose to leave a gap, assume zero or continue a line & you can include values from hidden cells or not"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: use Ctrl+Alt+Shift+V to paste the contents of the clipboard as unformatted text"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "59.a (alternative) Need more pasting options? Use 'Paste Special' via Edit - Special paste or press Ctrl+Shift+V"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "When editing a cell in place, you can right click›Insert fields: Date, Sheet name, Title"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Wrap Text Around an Object in Writer: Select the graphic›Right-click›Wrap›Edit Contour"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Slide Show›Slide Show Settings›Type›Auto: Restarts the slide show after the pause interval you specify"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "In LibreOffice Calc, document sharing allows simultaneous write access for many users"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can delete multiple custom styles at once: select them›right click›Delete"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "The Calc's keyboard shortcut to toggle between relative and absolute references is Shift + F4"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc's keyboard shortcut to toggle between relative and absolute references is F4"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: You can not see all the text in a cell? Expand the input line in the formula bar, you can scroll"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You often create a document from another? Have you considered using a template?"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "New versions do not bring that new features and bug fixes. They also include security patches. Be safe, put yourself updated!"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want to duplicate the above line? Click the row header and then press Ctrl + D"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can embed copied graphics from web to your docs via Edit - Links - Break Link "), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can easily arrange size table rows and columns - Right click - Row(or Columns) - Optimal Height and Width"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Best way to fix bad looking MS Word table cells via Right click - Row(or Columns) - Optimal Height and Width (Or Table AutoFit)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Don't get lost in long%large documents. Use Navigator(F5) to find your way through the content."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to change a word which appears multiple places many place Use Find&Replace to save time."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can use various table styles via Table - AutoFormat to have good looking tables"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to select a large range of cells without scrolling? Type the range reference (e.g. A1:A1000) in the name box then Enter"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc›Data›Validity allows you to create drop-down lists for the user selects instead of typing"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc›Format›Page›Sheet Tab›Print:Grid can avoid you draw borders"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to center cells on a printed page? Format›Page›Page Tab›Layout settings›Table alignment"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Want to change basic fonts for the predefined template or Current document? Tools›Options›Writer›Basic Fonts"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "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"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: you can import data from Data Sources view as you do in Writer with Data to Text button (creates a refreshable datarange)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can drag and drop a contiguous range of cells in a chart to redefine"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice uses Regexp ICU’s engine (International Components for Unicode)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc›View›Value Highlighting displays cell contents in colors: Text/black, Formulas/green, Numbers/blue, Protected cells/grey background"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: to show formulas instead of results in cells Tools›Options›Calc›View›Display›Formulas or check Format›Page›Sheet tab›Print›Formulas"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Want to reach a page by its number? F5 to open the navigator›Type the number in the field›Enter"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "With Edit›AutoText›Import you can select Word document or template, containing the AutoText entries that you want to import"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc can display a number or a calculation as a fraction: Format›Cells›Number tab›Category›Fraction"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To print the notes of your slides File›Print›General tab›Select Notes in the Print listbox"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Draw: To Move an object to another Layer›Hold it until its edges flash›Drag to the name tab of the layer you want to move it to›Release"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to exclude duplicate rows in a spreadsheet? Use Data›Filter›Standard Filter›Options›No duplications"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to find words more than 10 characters? Edit›Find & Replace›Search›\\<[a-z]{10,}›Other Options›Check Regular expressions"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You delete instead of insert? You are in overwrite mode. Press the Insert key on the keyboard or click in the status bar on Overwrite"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Surprised that Writer adds blank pages in a mailing? Would you like to have a recipient letter to the back of another (Duplexing)?"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Help users to insert a picture in a Writer template? Insert›Fields›Other›Functions tab›PlaceHolder›Image. One Click to select an image"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Have you checked Tools›Options›Load/Save›General›Always create backup copy ?"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Create a master document from the current Writer document? File›Send›Create Master Document (sub-document created depending of outline)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer includes LibreLogo: simple Logo-like programming environment with turtle vector graphics, DTP and graphic design"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Need custom acceptance date format? Tools›Options›Language Settings›Language›Date acceptance patterns"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Typing in bold italics or underlined in Writer you can continue with the default attributes using only the shortcut Ctrl+Shift+X"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Looking WordArt in LibreOffice? Click Fontwork gallery in the Drawing Toolbar"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To protect cells: Tools›Protect Document›Sheet. To prevent insert, delete, rename, move/copy sheets: Tools›Protect›Document›Document"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Search by default in several sheets, select them before you start the search"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "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"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You don't like the selection color ? Uncheck or modify Tools›Options›LibreOffice›View›Selection›Transparency"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: a date is a formatted number of days since a date origin. An hour is a day divided by 24: noon = 0.5"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Need custom contents for metadata properties? File›Properties›Custom Properties tab lets you create what you want"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Customize›ToolbarModify›Change Icon›Import to use your icons for toolbars (only PNG file format and 16x16 or 26x26 pixels)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Insert your metadata in your Writer document: Insert›Fields›Other›Document or DocInformation tabs"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You are missing a label at the beginning of each page? Delete the 'Next Record' field from the last label, it is implicit"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: To delete multiple comments, Copy the range›Edit›Paste Special›Selection›Everything except Comments"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: you would like to view the calculation of individual elements of a formula, select the respective elements and press F9"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: you can rotate cells table orientation with Table›Table Properties›Text Flow tab›Text orientation"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice can automatically add a numbered caption when you insert an object. See Tools›Options›LibreOffice Writer›AutoCaption"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want to add x months to a date? Use =EDATE(date;months)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Many images in your writer document? Speed up the display by disabling Tools›Options›LibreOffice Writer›View›Graphics and objects"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Shift+Ctrl+Del deletes from cursor to the end of the current sentence. If the cursor is at the end of a cell, same for the next cell"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Want to sort paragraphs or table rows alphabetically or numerically? Select them›Tools›Sort"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To bring back a cell on screen after entering formula for which you need to scroll the sheet, select the cell before typing"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Need an unnumbered item in a list? Use 'Insert Unnumbered Entry' in Bullets and Numbering toolbar"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to open/save to favourite places? Enable Tools›Options›LibreOffice›General›Use LibreOffice dialogs lets you record shortcuts"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Click a row header›Ctrl++›Ctrl+D duplicates the above row, including formulas. Just type new values"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Trace cells used in a formula, precedents (Shift+F7) or dependants (Shift+F5). For each hit you go one more step in the chain"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to sort a pivot table? Click on drop-list's arrow in the row/col header and select sort method: ascending, descending or custom"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Sticky templates (user & shared template folders) let you apply style changes when you open a document created from the template"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Tools›AutoCorrect›Replace provides a list of common substitutions. Take a look and complete with your own replacements"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Center a picture in a Writer Table's cell? Anchor as ›Center buttons in Formatting (horizontally) & Table (vertically) toolbars"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Do not insert empty paragraph to separate two paragraphs, set Indents & Spacing›Spacing›Below paragraph for the paragraph style"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want your documents open where you were when last saved? Fill Tools›Options›LibreOffice›User Data First/Last name"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: with the navigator you can select & move up/down headings and the text below the heading, in the Navigator and in the document"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice doesn't calculate from left to right but respects the order Parentheses›Exponents›Multiplication›Division›Addition›Subtraction"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: you can change the default function in the status bar: right click on the area"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: you do not want to print all columns? Hide or group ones you do not need"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: use Shift+Space to select the current row & Ctrl+Shift+Space to select the current column (previous versions)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", " Calc: use Shift+Space to select the current row & Ctrl+Space to select the current column"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer handles Conditional styles: paragraph styles that have different properties depending on the context"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Install/LibreOffice not working? Have you checked the integrity of the download? On Download page click on Info to get the checksums"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: want to show the current date in your document? Insert›Fields›Other›Document tab›select Date (not fixed)›select a format"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Need to fill a serie? Select the cell range›Edit›Fill›Series›Choose between Linear, Growth, Date and AutoFill"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Click at the beginning (end) of a section and press Alt+Enter to insert a paragraph before (after) the section"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "With File›Versions Save multiple versions of the document in the same file. You can also open, delete, and compare previous versions"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You change computers and want to recover your customizations? See https://wiki.documentfoundation.org/UserProfile"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: You can set a color for each tab: right-click the tab›Tab ColourfA"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Looking for examples of LibreOffice Basic macros? Look at LibreOffice Macros›Tools"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Insert›Function List opens a resizable dockable window which displays all functions that can be inserted into your document"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Don't want the page number in your TOC? Edit index›Delete Tab Stop & Page number from Structure Line in Entries tab"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: to quickly assign a name to a range of cells, select it›type the name in the name box and press Enter"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Outline numbering lets you set text to be displayed before the chapter number. For example, type 'Chapter ' to display 'Chapter 1'"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Base not only manages its own. Connect to main database engines: JDBC PostgreSQL MySQL LDAP Address book, MS Access ODBC Spreadsheet Text"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want to know if a cell is referred in formulas of other cells? Tools›Detective›Trace Dependents [Shift+F5]"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to customize the middle mouse button? Tools›Options›LibreOffice›View›Middle Mouse button"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: To delete picture's caption select the picture›Ctrl+X›There is only the legend's frame›Select›Delete›Ctrl+C to paste the picture"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Base: Need a crosstab query ? Calc›Data›Pivot Table›Create›choose your registered Data source"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc Print: Repeat rows/columns on every pages? Format›Print Ranges›Edit›Click the Row/Col text box›drag the mouse in the sheet"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: To copy rows/cols to another sheet preserving heights/widths, select them by clicking the labels before copying"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "With LibreOffice it is very easy to install a new dictionary: they are supplied as an extension"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Registered databases can also be used in Calc, for example to export your tables to CSV format"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Need to precisely position? Alt+Arrow Keys move objects (shape, picture, formula...) by one pixel"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Choose Hierarchical View in the Styles and Formatting window to see the links between styles"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Print 2 A5 on A4? Check File›Print›Options tab›Use only paper size from printer & set A4 landscape orientation in the printer properties"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: The field names are displayed instead of their content? View›Fields Names or Ctrl + F9"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Creating a Style based on another, you can enter a percentage value or a point value (e.g. 110% or -2pt or +5pt)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to know the valid Command Line Parameters? Start soffice with --help or -h or -?"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Want to return to default after applying a List Style? Click Bullets or Numbering On/Off tool on the Formatting toolbar"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Configure use of the Ctrl key to follow hyperlinks? Tools›Options›LibreOffice›Security›Options›Ctrl+click required to follow hyperlinks"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You get 'weird' characters opening a text file? Check the character set when importing"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Open Document Format is the key. LibreOffice is the solution."), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "For your safety, save your files to disk and then copy them to your USB key. Never do the opposite !"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "After a copy you can hit Esc to stop the 'marching ants'. The copied content will remain available for pasting"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: To quickly insert or delete rows, drag the mouse over the header to select the desired number of lines then Ctrl+ or Ctrl-"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Select contiguous cell range that contains data and is bounded by empty row and columns ? Use Ctrl+* (numeric key pad )"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Tools›Customize›Keyboard›Save saves the current shortcut key configuration, so that you can load it later or on another computer"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Property mapping for charts allows to change data serie's fill & border colors based on spreadsheet values"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Ctrl+Shift+F9 Recalculates all formulas in all sheets (some functions like RANDBETWEEN are not calculated by F9)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: Write along a curve? Draw the line›Double click›Type the text›Format›Object›Fontwork... Have fun with the proposed effects"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Click the bo4rders button adds borders to selected cells - Shift+Click replaces all borders of current cell with your choice"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: you can create an illustration index from Object names, not only from Captions"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "To enable macro recording check Tools›Options›LibreOffice›Advanced›Enable macro recording (limited)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "In the Replace input field of AutoCorrection you can use the wildcards .*"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You no longer find an option? Search in Tools›Options›LibreOffice›Advanced›Configuration Expert"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc - Want to export formulas to CSV? File›Save As›Type:Text CSV›Check Edit filter settings›Check Save cell formulas"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Impress: set Handouts in File›Print›Document listbox›select the number of slides per page (lines automatically drawn if you pick 3)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Impress: Outline View. You cannot use Tab/Shift+Tab to move the title in the hierarchy with Title slide layout (apply Title, content)"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", " Impress: Outline View. You cannot use Tab/Shift+Tab to move the title in the hierarchy with Title slide layout (apply Title, content"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to manage the presentation of hyperlinks in a spreadsheet? Insert them with the HYPERLINK function"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Tools›Customize›Keyboard› No need to scroll through the list to find a shortcut: just type the shortcut"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Draw/Impress: Want to quickly zoom in on selection? Press the Divide Key (number pad) - Press * to restore entire page in screen"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Want to quickly zoom in on range selection? Right click on the zoom part of the status bar, choose Optimal"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: to reformat all comments in a document click the down arrow in a comment and choose 'Format all Comments'"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: File›Print›Comments and choose Place in margins, end of page, end of document"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Convert formula into static values ? No need to copy-paste: Tools›Cell Contents›Formula to Value"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc: Can not get what you want with VLOOKUP? With INDEX and MATCH You can do everything!"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: LibreOffice 5.1 introduces Hide Whitespace option which removes gaps between pages, to help you really focus on your content"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice 5.1 reorganize main menus in Writer, Calc and Impress to improve usability"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Mailing: with LibreOffice 5.1 embed your datasource definition in the document"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "5.3 implements table styles in Writer, try them!"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc 5.3 brings new cell styles, and the possibility to create your own x"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "New arrow endings in LibreOffice 5.3, including Crow's foot notation's ones "), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Grab the latest docker image from Docker Hub here: https://hub.docker.com/r/libreoffice/online "), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Release 5.3 features the first source release of LibreOffice Online "), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Calc now supports scrolling through the Scroll key"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Now possible to sign existing PDF files and also verify those signatures"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "A safe mode has been added which starts LibreOffice temporarily with a fresh user profile"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Menu Help: direct link to user guides, collateral documentation, help on line"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "You can now import AutoText import from .dotx and .dotm files"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Version 5.4 introduces Pivot Charts"), "" }, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer: To find the expressions in brackets Edit›Find & Replace›Find›\\([^)]+\\)›set Regular expression"), "" }, }; #endif //INCLUDED_CUI_INC_TIPOFTHEDAY_HRC diff --git a/cui/source/dialogs/tipofthedaydlg.cxx b/cui/source/dialogs/tipofthedaydlg.cxx index 430ae484d08a..5bf72f525391 100644 --- a/cui/source/dialogs/tipofthedaydlg.cxx +++ b/cui/source/dialogs/tipofthedaydlg.cxx @@ -40,6 +40,7 @@ TipOfTheDayDialog::TipOfTheDayDialog(weld::Window* pParent) m_pNext->connect_clicked(LINK(this, TipOfTheDayDialog, OnNextClick)); nNumberOfTips = SAL_N_ELEMENTS(TIPOFTHEDAY_STRINGARRAY); + srand(time(nullptr)); nCurrentTip = rand() % nNumberOfTips; UpdateTip(); } @@ -65,7 +66,7 @@ void TipOfTheDayDialog::UpdateTip() { //get string OUString aText; - aText = CuiResId(TIPOFTHEDAY_STRINGARRAY[nCurrentTip]); + aText = CuiResId(TIPOFTHEDAY_STRINGARRAY[nCurrentTip].first); //move hyperlink into linkbutton sal_Int32 nPos = aText.indexOf("http"); if (nPos > 0) @@ -85,9 +86,9 @@ void TipOfTheDayDialog::UpdateTip() // import the image OUString aURL("$BRAND_BASE_DIR/$BRAND_SHARE_SUBDIR/tipoftheday/"); rtl::Bootstrap::expandMacros(aURL); - OUString aName = "tipoftheday_" + OUString::number(nCurrentTip) + ".png"; + OUString aName = TIPOFTHEDAY_STRINGARRAY[nCurrentTip].second; // use default image if none is available with the number - if (!file_exists(aURL + aName)) + if (aName.isEmpty() || !file_exists(aURL + aName)) aName = "tipoftheday.png"; // draw image Graphic aGraphic; |