[Libreoffice-commits] core.git: cui/inc cui/source

[heiko tietze (via logerrit)]

 cui/inc/tipoftheday.hrc               |  615 +++++++++++++++++-----------------
 cui/source/dialogs/tipofthedaydlg.cxx |    7 
 2 files changed, 312 insertions(+), 310 deletions(-)

New commits:
commit 033e1130a65ec7f0fa9c46e5124adc9d8bf724ba
Author:     heiko tietze <tietze.he...@gmail.com>
AuthorDate: Mon Apr 15 14:46:16 2019 +0200
Commit:     Heiko Tietze <tietze.he...@gmail.com>
CommitDate: Tue Apr 16 10:03:12 2019 +0200

    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.he...@gmail.com>

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;
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits