cui/inc/tipoftheday.hrc               |  451 +++++++++++++++++-----------------
 cui/source/dialogs/tipofthedaydlg.cxx |   52 ++-
 cui/source/inc/tipofthedaydlg.hxx     |    2 
 3 files changed, 269 insertions(+), 236 deletions(-)

New commits:
commit b2eae358eeaf5a3747a59e77eb07545253641197
Author:     heiko tietze <tietze.he...@gmail.com>
AuthorDate: Fri May 3 17:08:53 2019 +0200
Commit:     Heiko Tietze <tietze.he...@gmail.com>
CommitDate: Tue May 7 16:36:48 2019 +0200

    Resolves tdf#124978 - Tip-of-the-day references
    
    * LibreOffice changed into %PRODUCTNAME
    * std::pair made into std::tuple and hyperlinks separated from strings
    * tip about donation / getinvolved added
    * "Use an array formula to repeat a calculation with different values..." 
removed
    * "%PRODUCTNAME supports 110 languages"->"%PRODUCTNAME supports over 150 
languages"
    * code added to open offline help
    * online hyperlinks converted into offline links, if available
    * Ctrl, Shift, Alt uppercased
    * › replace by >
    * ellipsis removed
    
    Change-Id: Ic35257d0a6d6e77750716254fb9d1f6983a54af1
    Reviewed-on: https://gerrit.libreoffice.org/71760
    Tested-by: Jenkins
    Reviewed-by: Heiko Tietze <tietze.he...@gmail.com>

diff --git a/cui/inc/tipoftheday.hrc b/cui/inc/tipoftheday.hrc
index 1a99e420db4a..a82e30b6386f 100644
--- a/cui/inc/tipoftheday.hrc
+++ b/cui/inc/tipoftheday.hrc
@@ -22,230 +22,247 @@
 
 #define NC_(Context, String) reinterpret_cast<char const *>(Context "\004" 
u8##String)
 
+#include <tuple>
 
 /*
- * text beginning with "html" will be used until the end as hyperlink
- * use \\ to show \
- * 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
+ * std:tuple consists of <text, uri, image>
+ * text:
+   * escape backslash, ie. use \\ to show \
+ * uri:
+   * leave uri empty to not show any link
+   * if uri starts with "http" it opens directly in the browser
+   * all other strings are converted for the offline help
+   * find the right uri for e.g. 
https://help.libreoffice.org/6.2/en-US/text/shared/optionen/01030300.html by
+   * grepping help2file.js after building --with-help=html 
(cui/ui/optsecuritypage/OptSecurityPage for the example)
+ * image:
+   * leave the image string empty for the default tipoftheday.png
+   * place new images at extra/source/tipoftheday and don't forget to add the 
files to vcl/Package_tipoftheday.mk
+   * don't exceed 100x120px too much - images dont get scaled
 */
 
-const std::pair<const char*, OUString> TIPOFTHEDAY_STRINGARRAY[] =
+const std::tuple<const char*, OUString, OUString> TIPOFTHEDAY_STRINGARRAY[] =
 {
-     { NC_("RID_CUI_TIPOFTHEDAY", "Get help from the community via the Ask 
portal. https://ask.libreoffice.org";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Easily convert your documents to PDF with 
one click by clicking on the PDF icon in the toolbar."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Create editable Hybrid PDFs with 
LibreOffice. 
https://wiki.documentfoundation.org/Documentation/HowTo/CreateAHybridPDF";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Select a different icon set from Tools › 
Options › LibreOffice › View › User Interface › Icon size and style."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Create fillable form documents (even PDF's) 
with LibreOffice. 
https://www.techrepublic.com/article/how-to-create-interactive-pdfs-with-libreoffice";),
 ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use your Android or iPhone to remotely 
control your Impress presentation. 
https://help.libreoffice.org/6.0/he/text/simpress/guide/impress_remote.html";), 
"tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Run LibreOffice in any browser via rollApp. 
https://www.rollapp.com/app/lowriter";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has great extensions to 
increase your productivity, check them 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", "Use font embedding for greater 
interoperability with other office suites at  File › Properties › Font."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Developing new XSLT and xml filters? 
http://fridrich.blogspot.com.tr/2013/08/extending-swiss-army-knife-overview.html
 "), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Citation management ? Use a 3rd party 
extension. 
https://wiki.documentfoundation.org/Referencing_Systems_in_LibreOffice";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Get LibreOffice documentation and free user 
guide books at http://www.libreoffice.org/get-help/documentation "), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Embedded help is available by clicking on 
F1, if you've installed it. Otherwise check online at 
https://help.libreoffice.org";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice has a portable version which 
gives you mobility. Even without administrator rights on your computer you can 
install LibreOffice Portable to your hard drive too. 
http://www.libreoffice.org/download/portable-versions/ "), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Generate fully customized PDF documents 
with the exact format, image compression, comments, access rights, password, 
etc., via File › Export as PDF."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice can open and save files stored 
on remote servers per CMIS. 
https://help.libreoffice.org/6.2/en-US/text/shared/guide/cmis-remote-files.html";),
 ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Data › Statistics for sampling, 
descriptive statistics, analysis of variance, correlation, and much more in 
LibreOffice Calc."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Right-click in the status bar in 
LibreOffice Calc and select 'Selection count' to display the number of selected 
cells."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "In LibreOffice Impress use Insert › Media › 
Photo Album to create a slideshow from a series of pictures with the 'Photo 
Album' feature."), "tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Did you know that you can attach comments 
to portions of text? Just use shortcut Ctrl+Alt+C for it."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Need to insert the date in a spreadsheet 
cell? Type Ctrl+; or Shift+Ctrl+; to insert the time."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to sort a series in LibreOffice Calc 
such as A1, A2, A3, A11, A15, not in alphabetical order but on the number? 
Enable natural sort in the Options tab. 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/12030200.html";), 
"tipoftheday_c.png"},
-     { 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)"), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "The presenter console is a great feature 
when working with LibreOffice Impress. Have you checked it out? 
https://help.libreoffice.org/6.2/en-US/text/simpress/guide/presenter_console.html";),
 "tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Automatically mark alphabetical index 
entries using a concordance file. 
https://help.libreoffice.org/6.2/en-US/text/swriter/guide/indices_index.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Frames can be linked so that the text can 
flow from one to the other as in desktop publishing. 
https://help.libreoffice.org/6.2/en-US/text/swriter/guide/text_frame.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice supports 110 languages. 
https://wiki.documentfoundation.org/Language_support_of_LibreOffice";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice supports four macro security 
levels (from low to very high) and trusted sources. 
https://help.libreoffice.org/6.2/en-US/text/shared/optionen/01030300.html";), 
""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice allows you to use assistive 
tools, such as external screen readers, Braille devices or speech recognition 
input devices. https://www.libreoffice.org/get-help/accessibility/";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Batch convert your MS Office documents to 
OpenDocument format by the Document Converter wizard in menu File › Wizards › 
Document converter."), ""},
-     { 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", "Want to become a LibreOffice Ambassador? 
There are certifications for developers, admins, and trainers. 
http://www.documentfoundation.org/certification "), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Tools › Options › Calc › View › 
Zoom: 'Synchronize sheets' so that each sheet in Calc has its own zoom 
factor."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Open a CSV file as a new sheet in the 
current spreadsheet via Sheet › Sheet from file."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Writing a book? LibreOffice master document 
lets you manage large documents as a container for individual LibreOffice 
Writer files. 
https://help.libreoffice.org/6.2/en-US/text/swriter/guide/globaldoc.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Need to move a Writer table? Table › Select 
› Table and Insert › Frame… and move where you want."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "In LibreOffice Draw to change the 0/0 point 
of the rulers, drag the intersection of the two rulers in the top left corner 
into the workspace."), "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use an array formula to repeat a 
calculation with different values: it requires less disk space & consumes 
little memory. 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060107.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Enable massive parallel calculations of 
formula cells via Tools › Options › OpenCL. 
https://help.libreoffice.org/6.2/en-US/text/shared/optionen/opencl.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Hold down ctrl and turn the mouse wheel to 
change the zoom factor."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Edit › Find & Replace... lets you insert 
special characters directly: right click in input fields or press 
shift+ctrl+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."), "tipoftheday_w.png"},
-     { 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", "In Calc use TRIMMEAN() to return the mean 
of a data set excluding the highest and lowest values. 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060182.html?DbPAR=CALC#bm_id3152966
 "), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Keep the zeros before a number by using 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 you should use Paste Special and uncheck everything 
except ‘Comments’ in dialog. Use Operations ‘Add’ to not override existing 
content."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Calculate loan repayments with Calc: eg. 
PMT(2%/12;36;2500) interest rate per payment period 2%/12, 36 months, loan 
amount 2500. 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060119.html?DbPAR=CALC#bm_id3149577";),
 "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Select an object in the document background 
via the Select tool in the Drawing toolbar to surround the object to select."), 
""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Apply Heading paragraph styles in Writer 
with shortcut keys: ctrl+1 applies Heading 1, ctrl+2 applies Heading 2, etc."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Mix portrait and landscape orientations in 
a Calc spreadsheet by applying different page styles on sheets."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Sections in LibreOffice Writer to 
protect part of a text, show/hide text, reuse parts from other documents, use 
different column layout. 
https://help.libreoffice.org/6.2/en-US/text/swriter/01/04020100.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Create different master pages in a 
presentation template: View › Master Slide and Slide › New Master (or per 
toolbar or right click in slide pane)."), "tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Format › Page › 'Fit object to paper 
format' in Draw/Impress to resize the objects so that they fit on your chosen 
paper format."), "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To modify an AutoPlay presentation, open it 
and after it starts, right click and select Edit in the context menu."), 
"tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Rename your slides in Impress to help you 
define 'Go to page' interactions and to have a summary more explicit than 
Slide1, Slide2…"), "tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Play music throughout a slideshow by 
assigning the sound to the first slide transition without clicking the ‘Apply 
to All Slides’ button."), "tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "With ‘Slide Show › Custom Slide Show’, 
reorder and pick slides to fit a slideshow to the needs of your public."), 
"tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Include a paragraph that is not a title in 
the table of contents by changing Outline & Numbering in the paragraph settings 
to an outline level."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use the Connector tool from the Drawing 
toolbar in Draw/Impress to create nice flow charts and optionally copy/paste 
the object into Writer."), "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to see, but not print, an object in 
Draw? Draw it on a layer for which the ‘Printable’ flag is not set (right click 
on the tab and ‘Modify Layer’)."), "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to print two portrait pages on a 
landscape one (reducing A4 to A5)? File › Print and select 2 at ‘Pages per 
sheet’."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To get the ‘Vertical Text’ tool in the 
Drawing toolbar, check Tools › Options › Language Settings › Languages › 
Default languages › Asian (and make the button visible with right click)."), 
""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to add many shapes in Draw/Impress? 
Double-click a tool in the drawing toolbar to use it for repeated tasks."), 
"tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to display only the highest values in 
a spreadsheet? Select menu Data › AutoFilter, click the drop-down arrow, and 
chose ‘Top10’."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Unable to modify or delete a custom cell 
style? Check all sheets, none should be protected."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to know how many days there are in the 
current month? Use the DAYSINMONTH(TODAY()) function."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Strange error code in Calc, Err: followed 
by a number? This page gives the explanation 
https://help.libreoffice.org/6.2/en-US/text/scalc/05/02140000.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Add background images to spreadsheets via 
Insert › Image or drag a background from the Gallery, then Format › Arrange › 
To Background."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To quickly get a math object in Writer type 
your formula, mark it, and use Insert › Object › Formula to convert the 
text."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Writer can insert a blank page between two 
odd (even) pages that follow. Check ‘Print automatically inserted blank pages’ 
in the print dialog’s Writer tab."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "The 4th optional parameter of VLOOKUP Calc 
function indicates whether the first column of data is sorted. If not, enter 
FALSE or zero."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to show hidden column A? Click a cell 
in column B, press the left mouse button, move the mouse to the left, release. 
Then switch it on via Format › Columns › Show."), "tipoftheday_c.png"},
-     { 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."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Need to present a report written with 
Writer? File › Send › Outline to Presentation automatically creates a slideshow 
from the outline."), "tipoftheday_w.png"},
-     { 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."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Format › Align (or the context menu) 
for precise positioning of objects in Draw/Impress: it centers on the page if 
one object is selected or works on the group respectively."), 
"tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to find the words in bold in a Writer 
document? Edit › Find & Replace › Other options › Attributes › Font weight. 
https://help.libreoffice.org/6.2/en-US/text/swriter/guide/finding.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Repeat the heading on a subsequent page 
when a table spans over more than one page with Table › Table Properties › Text 
Flow › Repeat heading."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use column or row labels in formulas. For 
example, if you have two columns, ‘Time’ and ‘KM’, use =Time/KM to get minutes 
per kilometer."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To change the number of a page in Writer, 
go to the properties of the first paragraph and at the Text Flow tab check 
Break › Insert and enter the number."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want the cursor to go into the cell to the 
right, after entering a value in Calc? Use the Tab key instead of Enter."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Show or hide comments in Writer by clicking 
the comment toggle button in the ruler."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Sheet › Fill Cells › Random Number to 
generate a random series based on various distributions. 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/02140700.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Fit your sheet or print ranges to a page 
with Format › Page › Sheet Tab › Scaling Mode."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Keep column headers of a sheet visible when 
scrolling lines via View › Freeze Cells › Freeze First Row."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want your chapter titles to always begin a 
page? Edit Heading1 (paragraph style) › Text Flow › Breaks and check Insert › 
Page › Before."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to keep the text from, but remove a 
hyperlink, in Writer? Right click the link and ‘Remove Hyperlink’."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to remove all <> at once and keep the 
text inside? Edit › Find & Replace:  Search = [<|>], Replace = blank and check 
‘Regular expressions’ under Other options. 
https://help.libreoffice.org/6.2/en-US/text/shared/01/02100001.html";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Format › Conditional Formating › Manage 
in Calc to find out which cells have been defined with conditional formating. 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/05120000.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Create a chart based on a Writer table by 
clicking in the table and chossing Insert › Chart."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Move a column in Calc between two others in 
one step? Click the header then a cell in the column, keep mouse button and 
move to the target with Alt key."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use the Backspace key instead of Delete in 
Calc.  You can choose what to delete."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To distribute some text in multi-columns 
select the text and apply Format › Columns."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Slide Show › Settings › 
Presentation always on top if you need another program displays its window to 
the front of your presentation."), "tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Tools › Detective › Mark Invalid Data 
highlights all cells in the sheet that contain values outside the validation 
rules. https://help.libreoffice.org/6.2/en-US/text/scalc/01/06030800.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Need to allow changes to parts of a 
read-only document in Writer? Insert frames or sections that can authorize 
changes. 
https://help.libreoffice.org/6.2/en-US/text/swriter/guide/section_edit.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Select options in Tools › Options › Writer 
› Formatting Aids › Display to specify which non-printing characters are 
displayed."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want the same layout for the screen display 
and printing? Check Tools › Options › Calc › General › Use printer metrics for 
text formatting."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Customize your footnotes page with Tools › 
Footnotes and Endnotes…"), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to sum a cell through several sheets? 
Refer to the range of sheets e.g. =SUM(Sheet1.A1:Sheet3.A1)."), 
"tipoftheday_c.png"},
-     { 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 and use Sheet › Fill Cells › Fill Sheets."), "tipoftheday_c.png"},
-     { 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."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Click a column field (row) PivotTable and 
press F12 to group data. Choices adapt to content: Date (month, quarter, year), 
number (classes)"), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Apart from table of contents, LibreOffice 
can create Alphabetical, Illustrations, Tables, Objects, Bibliography, 
User-Defined indexes. 
https://help.libreoffice.org/6.2/en-US/text/swriter/guide/indices_toc.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to count words for just one particular 
paragraph style? Use Edit › Find & Replace › Paragraph Styles, select the style 
› Find All and read the number from the status bar."), "tipoftheday_w.png"},
-     { 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 
Email. 
https://help.libreoffice.org/6.2/en-US/text/swriter/guide/form_letters_main.html";),
 "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Toolbars are contextual, they open 
depending on the context. If you do not want that, uncheck them from View › 
Toolbars."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Insert and number your formulas in one 
step: type fn then F3. An AutoText is inserted with formula and number aligned 
in a table."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To automatically number your table rows in 
Writer, select the relevant column, then apply a numbering style from List 
Styles."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Delete in one step all of your printing 
areas: select all sheets then Format › Print Ranges › Clear."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice helps you not to enter two or 
more spaces in Writer. Check Tools › AutoCorrect Options › Options › Ignore 
double spaces."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Transpose a writer table? Copy and paste in 
Calc, transpose with copy/paste special then copy/paste special › Formatted 
text in Writer."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Writer lets you number your footnotes per 
page, chapter, document: Tools › Footnotes and Endnotes › Footnotes tab › 
Counting."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Left-handed? Enable Tools › Options › 
Language Settings › Languages › Asian and check Tools › Options › Writer › View 
› Ruler › Right-aligned, which displays the scrollbar to the left."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To display the scrollbar to the left, 
enable Tools › Options › Language Settings › Languages › Complex text and check 
Sheet › Right-To-Left."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Your numbers are displayed as ### in your 
spreadsheet? The column is too narrow to display all digits."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Ctrl+Alt+Shift+V to paste the contents 
of the clipboard as unformatted text."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "When editing a cell in place, you can right 
click and Insert fields: Date, Sheet name, Document title etc."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can restarts the slide show after a 
pause specified at Slide Show › Slide Show Settings › Loop and repeat."), 
"tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can not see all the text in a cell? 
Expand the input line in the formula bar and you can scroll."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You often create a document from another? 
Have you considered using a template?"), "tipoftheday_w.png"},
-     { 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", "Want to duplicate the above line? Press 
Ctrl + D or use Sheet › Fill Cells › Fill Down."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can easily optimize your table per 
Table › Size › Distribute Rows / Columns Evenly."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Best way to fix bad looking MS Word table 
cells via Table › Size › Optimal Row Height / Column Width."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Don't get lost in large documents. Use the 
Navigator (F5) to find your way through the content."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can use styles to make the tables in 
your document consistent. Choose one from the predefined per Styles (F11) or  
via Table › AutoFormat."), "tipoftheday_w.png"},
-     { 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"), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Data › Validity allows you to create 
drop-down lists where the user selects a value instead of typing. 
https://help.libreoffice.org/6.2/en-US/text/scalc/guide/validity.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to center cells on a printed page? 
Format › Page, Page › Layout settings › Table alignment."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Change the basic fonts for the predefined 
template or current document per Tools › Options › Writer › Basic Fonts. 
https://help.libreoffice.org/6.2/en-US/text/shared/optionen/01040300.html";), 
"tipoftheday_w.png"},
-     { 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. 
https://help.libreoffice.org/6.2/en-US/text/swriter/guide/autotext.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use View › Value Highlighting to display 
cell contents in colors: Text/black, Formulas/green, Numbers/blue, Protected 
cells/grey background. 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/03080000.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can show formulas instead of results 
with View › Show Formula (or Tools › Options › Calc › View › Display › 
Formulas)."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to jump to a particular page by its 
number? Click the left-most statusbar entry or use Edit › Go To Page… or press 
ctrl+G."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "With Tools › AutoText › AutoText › Import 
you can select Word document or template containing the AutoText entries that 
you want to import."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can display a number as a fraction 
(0.125 = 1/8): Format › Cells, Number › Fraction."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To print the notes of your slides go to 
File › Print › Impress tab and select Notes under Document › Type."), 
"tipoftheday_i.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can move an object to another layer by 
holding it until its edges flash, then drag it to the tab of the layer you want 
to move it to."), "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to find words more than 10 characters? 
Edit › Find & Replace › Search › [a-z]{10,} › Other Options › check Regular 
expressions."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Make it easy to insert a picture in a 
Writer template by Insert › Fields › More fields... › Functions › PlaceHolder › 
Image. One click to select an image."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Create a master document from the current 
Writer document? File › Send › Create Master Document (sub-documents are 
created depending of outline)."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Writer includes LibreLogo: simple Logo-like 
programming environment with turtle vector graphics, DTP and graphic design. 
https://help.libreoffice.org/6.2/en-US/text/swriter/librelogo/LibreLogo.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Your data acceptance pattern is 
inappropriate? Tools › Options › Language Settings › Language › Date acceptance 
patterns allows to tweak the pattern."), ""},
-     { 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 (remove direct character formats)."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can protect cells with Format › Cells › 
Protection. To prevent insert, delete, rename, move/copy of sheets use Tools › 
Protect Sheet. 
https://help.libreoffice.org/6.2/en-US/text/scalc/guide/cell_protect.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You will search in several sheets when you 
select them before you start the search."), "tipoftheday_c.png"},
-     { 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."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "A date is a formated number of days since a 
date origin. An hour is a day divided by 24 with noon = 0.5."), 
"tipoftheday_c.png"},
-     { 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", "Insert your metadata in your document with 
Insert › Fields › More Fields… › Document or DocInformation."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To delete multiple comments, copy the 
range, paste special, and select everything except comments."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You would like to view the calculation of 
individual elements of a formula, select the respective elements and press 
F9."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can rotate cells table orientation with 
Table › Properties… › Text Flow › Text orientation."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice can automatically add a 
numbered caption when you insert objects. See Tools › Options › LibreOffice 
Writer › AutoCaption. 
https://help.libreoffice.org/6.2/en-US/text/shared/optionen/01041100.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You want to add x months to a date? Use 
=EDATE(date;months). 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/func_edate.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Many images in your Writer document? Speed 
up the display by disabling View › Images and charts."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Shift+ctrl+del deletes from cursor to the 
end of the current sentence."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can sort paragraphs or table rows 
alphabetically or numerically per Tools › Sort. 
https://help.libreoffice.org/6.2/en-US/text/swriter/01/06100000.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Need an unnumbered item in a list? Use 
'Insert Unnumbered Entry' in the Bullets and Numbering toolbar."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Trace cells used in a formula, precedents 
(Shift+F9) or dependants (Shift+F5) (or use Tools › Detective). For each hit 
you go one more step in the chain. 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/06030000.html";), 
"tipoftheday_c.png"},
-     { 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."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Tools › AutoCorrect › AutoCorrect Options… 
› Replace provides a list of common substitutions. Take a look and complete 
with your own replacements. 
https://help.libreoffice.org/6.2/en-US/text/shared/01/06040100.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Do not insert manual breaks to separate two 
paragraphs. Rather change Indents & Spacing › Spacing › Below paragraph at the 
style/paragraph properties."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Your documents don’t open at the position 
where you have saved it? Check Tools › Options › LibreOffice › User Data › 
First/Last name is not empty."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "With the Navigator you can select & move 
up/down headings and the text below the heading, in the Navigator and in the 
document."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "LibreOffice doesn't calculate from left to 
right but respects the order Parentheses > Exponents > Multiplication > 
Division > Addition > Subtraction."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can change the default function in the 
status bar: right click on the area."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You do not want to print all columns? Hide 
or group the ones you do not need."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use shift+space to select the current row 
and ctrl+space to select the current column."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Writer can handle styles conditionally: 
paragraph styles that have different properties depending on the context. 
https://help.libreoffice.org/6.2/en-US/text/swriter/01/05130100.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To insert the current date in your document 
use Insert › Field › Date."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You need to fill a serie? Select the cell 
range and Sheet › Fill Cells › Fill Series and choose between Linear, Growth, 
Date and AutoFill. 
https://help.libreoffice.org/6.2/en-US/text/scalc/guide/calc_series.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Click at the beginning (end) of a section 
and press alt+enter to insert a paragraph before (after) the section."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "With File › Versions you can store multiple 
versions of the document in the same file. You can also open, delete, and 
compare previous versions. 
https://help.libreoffice.org/6.2/en-US/text/shared/01/01190000.html";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You plan to change the computer and want to 
recover your customizations? See 
https://wiki.documentfoundation.org/UserProfile";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can set a color for each tab: 
right-click the tab or use Sheet › Sheet Tab Color."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You want to start working with LibreOffice 
basic macros? Take a look at the examples under Tools › Macros › Edit 
Macros."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To remove the page number from your table 
of contents go to Insert › Table of Contents (or right-click and Edit the 
previously inserted index). At the Entries tab delete the page number (#) from 
Structure line."), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Outline numbering lets you set text to be 
displayed before the chapter number. For example, type 'Chapter ' to display 
'Chapter 1'"), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to know if a cell is referred in 
formulas of other cells? Tools › Detective › Trace Dependents (Shift+F5)."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can customize the middle mouse button 
per Tools › Options › LibreOffice › View › Middle Mouse button."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To repeat rows/columns on every pages use 
Format › Print Ranges › Edit."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "With LibreOffice it is very easy to install 
a new dictionary: they are supplied as an extension. 
https://extensions.libreoffice.org/extensions?getCategories=Dictionary";), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Need to precisely position? Alt+arrow Keys 
move objects (shape, picture, formula...) by one pixel."), "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Choose ‘Hierarchical View’ in the Styles 
and Formatting sidebar to see the relation between styles."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can toggle between the field names and 
the actual value with View › Fields Names (or ctrl + F9)."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Creating a Style based on another, you can 
enter a percentage value or a point value (e.g. 110% or -2pt or +5pt)."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to know the valid command line 
parameters? Start soffice with --help or -h or -? 
https://help.libreoffice.org/6.2/en-US/text/shared/guide/start_parameters.html";),
 ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to return to default after applying a 
list style? Click Bullets or Numbering On/Off tool on the Formatting 
toolbar."), "tipoftheday_w.png"},
-     { 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", "Annoyed from the marching ants around cells 
in Calc. Press escape to stop them; the copied content will remain available 
for pasting."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To quickly insert or delete rows, select 
the desired number of rows (or columns) and press ctrl+ to add or ctrl- to 
delete."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To select a contiguous range of cells 
containing data and bounded by empty row and columns use ctrl+* (numeric key 
pad)."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Ctrl+Shift+F9 recalculates all formulas in 
all sheets (some functions like RANDBETWEEN are not calculated by F9)."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Write along a curve? Draw the line, double 
click, type the text, Format › Text Box and Shape › Fontwork."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can create an illustration index from 
object names, not only from captions. 
https://help.libreoffice.org/6.2/en-US/text/shared/01/05190000.html";), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To enable macro recording, check Tools › 
Options › LibreOffice › Advanced › Enable macro recording."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "In the replace input field of auto correct 
options you can use the wildcards .*"), "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to export formulas to CSV? File › Save 
As › Type:Text CSV, check ‘Edit filter settings’, and check ‘Save cell 
formulas’ in the next dialog."), "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to manage the presentation of 
hyperlinks in a spreadsheet? Insert them with the HYPERLINK function. 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060109.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "No need to scroll through the list at Tools 
› Customize › Keyboard to find a shortcut: just type it."), ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To quickly zoom in the selection, press / 
(divide key) on the number pad. Press * to restore entire page in screen."), 
"tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To quickly zoom in on range selection, 
right click on the zoom part of the status bar and choose Optimal."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can reformat all comments in a document 
by clicking the down arrow in a comment and choose 'Format all Comments'."), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To convert a formula into static values you 
don’t need to copy/paste; use Data › Calculate › Formula to Value."), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Can not get what you want with VLOOKUP? 
With INDEX and MATCH you can do everything! 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060109.html";), 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can sign existing PDF files and also 
verify those signatures. 
https://help.libreoffice.org/6.2/en-US/text/shared/guide/digital_signatures.html";),
 ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To temporarily starts with a fresh user 
profile or to restore a non-working LibreOffice instance start Help › Restart 
in Safe Mode. 
https://help.libreoffice.org/6.2/en-US/text/shared/01/profile_safe_mode.html";), 
""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Find all expressions in brackets per Edit › 
Find & Replace › Find › \\([^)]+\\) (check ‘Regular expressions’)"), 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can change the look of LibreOffice at 
Tools › Options › View › User Interface."), ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME can open and save files stored 
on remote servers per CMIS."), "fps/ui/remotefilesdialog/RemoteFilesDialog", 
""}, 
//https://help.libreoffice.org/6.2/en-US/text/shared/guide/cmis-remote-files.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Tools > AutoCorrect > AutoCorrect Options… 
> Replace provides a list of common substitutions. Take a look and complete 
with your own replacements."), "cui/ui/acoroptionspage/AutocorrectOptionsPage", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/shared/01/06040100.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Writer can handle styles conditionally: 
paragraph styles that have different properties depending on the context."), 
"modules/swriter/ui/conditionpage/ConditionPage", "tipoftheday_w.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/swriter/01/05130100.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "With File > Versions you can store multiple 
versions of the document in the same file. You can also open, delete, and 
compare previous versions."), "sfx/ui/versionsofdialog/VersionsOfDialog", ""}, 
//https://help.libreoffice.org/6.2/en-US/text/shared/01/01190000.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can create an illustration index from 
object names, not only from captions."), 
"cui/ui/objectnamedialog/ObjectNameDialog", "tipoftheday_w.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/shared/01/05190000.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "To temporarily starts with a fresh user 
profile or to restore a non-working %PRODUCTNAME instance start Help > Restart 
in Safe Mode."), "svx/ui/safemodedialog/SafeModeDialog", ""}, 
//https://help.libreoffice.org/6.2/en-US/text/shared/01/profile_safe_mode.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Change the basic fonts for the predefined 
template or current document per Tools > Options > Writer > Basic Fonts."), 
"modules/swriter/ui/optfonttabpage/OptFontTabPage", "tipoftheday_w.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/shared/optionen/01040300.html
+     { 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."), "modules/swriter/ui/autotext/AutoTextDialog", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/swriter/guide/autotext.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME can automatically add a 
numbered caption when you insert objects. See Tools > Options > %PRODUCTNAME 
Writer > AutoCaption."), "modules/swriter/ui/optcaptionpage/OptCaptionPage", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/shared/optionen/01041100.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can sort paragraphs or table rows 
alphabetically or numerically per Tools > Sort."), 
"modules/swriter/ui/sortdialog/SortDialog", "tipoftheday_w.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/swriter/01/06100000.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Sections in %PRODUCTNAME Writer to 
protect part of a text, show/hide text, reuse parts from other documents, use 
different column layout."), "modules/swriter/ui/sectionpage/SectionPage", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/swriter/01/04020100.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Sheet > Fill Cells > Random Number to 
generate a random series based on various distributions."), 
"modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog", 
"tipoftheday_c.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/scalc/01/02140700.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Format > Conditional Formating > Manage 
in Calc to find out which cells have been defined with conditional 
formating."), 
"modules/scalc/ui/conditionalformatdialog/ConditionalFormatDialog", 
"tipoftheday_c.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/scalc/01/05120000.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Apart from table of contents, %PRODUCTNAME 
can create Alphabetical, Illustrations, Tables, Objects, Bibliography, 
User-Defined indexes."), "modules/swriter/ui/tocdialog/TocDialog", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/swriter/guide/indices_toc.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to sort a series in %PRODUCTNAME Calc 
such as A1, A2, A3, A11, A15, not in alphabetical order but on the number? 
Enable natural sort in the Options tab."), 
"modules/scalc/ui/sortoptionspage/SortOptionsPage", "tipoftheday_c.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/scalc/01/12030200.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Enable massive parallel calculations of 
formula cells via Tools > Options > OpenCL."), 
"cui/ui/optopenclpage/OptOpenCLPage", "tipoftheday_c.png"}, 
//https://help.libreoffice.org/6.2/en-US/text/shared/optionen/opencl.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME supports four macro security 
levels (from low to very high) and trusted sources."), 
"cui/ui/optsecuritypage/OptSecurityPage", ""}, // 
https://help.libreoffice.org/6.2/en-US/text/shared/optionen/01030300.html
+
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to know the valid command line 
parameters? Start soffice with --help or -h or -?"), 
"https://help.libreoffice.org/6.2/en-US/text/shared/guide/start_parameters.html";,
 ""}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to manage the presentation of 
hyperlinks in a spreadsheet? Insert them with the HYPERLINK function."), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060109.html";, 
"tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Can not get what you want with VLOOKUP? 
With INDEX and MATCH you can do everything!"), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060109.html";, 
"tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can sign existing PDF files and also 
verify those signatures."), 
"https://help.libreoffice.org/6.2/en-US/text/shared/guide/digital_signatures.html";,
 ""}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Writer includes LibreLogo: simple Logo-like 
programming environment with turtle vector graphics, DTP and graphic design."), 
"https://help.libreoffice.org/6.2/en-US/text/swriter/librelogo/LibreLogo.html";, 
"tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can protect cells with Format > Cells > 
Protection. To prevent insert, delete, rename, move/copy of sheets use Tools > 
Protect Sheet."), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/guide/cell_protect.html";, 
"tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You want to add x months to a date? Use 
=EDATE(date;months)."), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/01/func_edate.html";, 
"tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Trace cells used in a formula, precedents 
(Shift+F9) or dependants (Shift+F5) (or use Tools > Detective). For each hit 
you go one more step in the chain."), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/01/06030000.html";, 
"tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You need to fill a serie? Select the cell 
range and Sheet > Fill Cells > Fill Series and choose between Linear, Growth, 
Date and AutoFill."), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/guide/calc_series.html";, 
"tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "With %PRODUCTNAME you can use your Google 
Mail account to do a mail merge. Fill in Tools > Options > Writer > Mail Merge 
Email."), 
"https://help.libreoffice.org/6.2/en-US/text/swriter/guide/form_letters_main.html";,
 "tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Data > Validity allows you to create 
drop-down lists where the user selects a value instead of typing."), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/guide/validity.html";, 
"tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use View > Value Highlighting to display 
cell contents in colors: Text/black, Formulas/green, Numbers/blue, Protected 
cells/grey background."), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/01/03080000.html";, 
"tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Strange error code in Calc, Err: followed 
by a number? This page gives the explanation:"), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/05/02140000.html";, 
"tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to find the words in bold in a Writer 
document? Edit > Find & Replace > Other options > Attributes > Font weight."), 
"https://help.libreoffice.org/6.2/en-US/text/swriter/guide/finding.html";, 
"tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to remove all <> at once and keep the 
text inside? Edit > Find & Replace:  Search = [<|>], Replace = blank and check 
‘Regular expressions’ under Other options."), 
"https://help.libreoffice.org/6.2/en-US/text/shared/01/02100001.html";, ""}, 
//local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Tools > Detective > Mark Invalid Data 
highlights all cells in the sheet that contain values outside the validation 
rules."), "https://help.libreoffice.org/6.2/en-US/text/scalc/01/06030800.html";, 
"tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to allow changes to parts of a 
read-only document in Writer? Insert frames or sections that can authorize 
changes."), 
"https://help.libreoffice.org/6.2/en-US/text/swriter/guide/section_edit.html";, 
"tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Writing a book? %PRODUCTNAME master 
document lets you manage large documents as a container for individual 
%PRODUCTNAME Writer files."), 
"https://help.libreoffice.org/6.2/en-US/text/swriter/guide/globaldoc.html";, 
"tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "In Calc use TRIMMEAN() to return the mean 
of a data set excluding the highest and lowest values."), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060182.html?DbPAR=CALC#bm_id3152966";,
 "tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Calculate loan repayments with Calc: eg. 
PMT(2%/12;36;2500) interest rate per payment period 2%/12, 36 months, loan 
amount 2500."), 
"https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060119.html?DbPAR=CALC#bm_id3149577";,
 "tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use your Android or iPhone to remotely 
control your Impress presentation."), 
"https://help.libreoffice.org/6.0/he/text/simpress/guide/impress_remote.html";, 
"tipoftheday_i.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "The presenter console is a great feature 
when working with %PRODUCTNAME Impress. Have you checked it out?"), 
"https://help.libreoffice.org/6.2/en-US/text/simpress/guide/presenter_console.html";,
 "tipoftheday_i.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Automatically mark alphabetical index 
entries using a concordance file."), 
"https://help.libreoffice.org/6.2/en-US/text/swriter/guide/indices_index.html";, 
"tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Frames can be linked so that the text can 
flow from one to the other as in desktop publishing."), 
"https://help.libreoffice.org/6.2/en-US/text/swriter/guide/text_frame.html";, 
"tipoftheday_w.png"}, //local help missing
+
+     { NC_("RID_CUI_TIPOFTHEDAY", "Get help from the community via the Ask 
portal."), "https://ask.libreoffice.org";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has great extensions to 
increase your productivity, check them out."), 
"https://extensions.libreoffice.org";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has a template center to 
create good looking documents, check it out."), 
"http://templates.libreoffice.org/template-center";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Embedded help is available by clicking on 
F1, if you've installed it. Otherwise check online at:"), 
"https://help.libreoffice.org";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Get %PRODUCTNAME documentation and free 
user guide books at:"), "http://www.libreoffice.org/get-help/documentation";, 
""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Your donations support our worldwide 
community."), "https://www.libreoffice.org/donate/";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "With %PRODUCTNAME it is very easy to 
install a new dictionary: they are supplied as an extension."), 
"https://extensions.libreoffice.org/extensions?getCategories=Dictionary";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME is developed by a friendly 
community, made up of hundreds of contributors around the world. Join us with 
your skills beyond coding."), 
"https://www.libreoffice.org/community/get-involved/";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has a portable version which 
gives you mobility. Even without administrator rights on your computer you can 
install %PRODUCTNAME Portable to your hard drive too."), 
"http://www.libreoffice.org/download/portable-versions/";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME allows you to use assistive 
tools, such as external screen readers, Braille devices or speech recognition 
input devices."), "https://www.libreoffice.org/get-help/accessibility/";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Create editable Hybrid PDFs with 
%PRODUCTNAME."), 
"https://wiki.documentfoundation.org/Documentation/HowTo/CreateAHybridPDF";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Citation management ? Use a 3rd party 
extension."), 
"https://wiki.documentfoundation.org/Referencing_Systems_in_LibreOffice";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You plan to change the computer and want to 
recover your customizations? See:"), 
"https://wiki.documentfoundation.org/UserProfile";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME supports over 150 
languages."), 
"https://wiki.documentfoundation.org/Language_support_of_LibreOffice";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to become a %PRODUCTNAME Ambassador? 
There are certifications for developers, admins, and trainers."), 
"http://www.documentfoundation.org/certification";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME intends to apply as an 
organization for Google Summer of Code (GSoC) see:"), 
"https://wiki.documentfoundation.org/Development/GSoC";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Create fillable form documents (even PDF's) 
with %PRODUCTNAME."), 
"https://www.techrepublic.com/article/how-to-create-interactive-pdfs-with-libreoffice";,
 ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Run %PRODUCTNAME in any browser via 
rollApp."), "https://www.rollapp.com/app/lowriter";, ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Developing new XSLT and xml filters?"), 
"http://fridrich.blogspot.com.tr/2013/08/extending-swiss-army-knife-overview.html";,
 ""},
+
+     { NC_("RID_CUI_TIPOFTHEDAY", "Easily convert your documents to PDF with 
one click by clicking on the PDF icon inthe toolbar."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Select a different icon set from Tools > 
Options > %PRODUCTNAME > View > User Interface > Icon size and style."), "", 
""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use font embedding for greater 
interoperability with other office suites at  File > Properties > Font."), "", 
""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Generate fully customized PDF documents 
with the exact format, image compression, comments, access rights, password, 
etc., via File > Export as PDF."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Data > Statistics for sampling, 
descriptive statistics, analysis of variance, correlation, and much more in 
%PRODUCTNAME Calc."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Right-click in the status bar in 
%PRODUCTNAME Calc and select 'Selection count' to display the number of 
selected cells."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "In %PRODUCTNAME Impress use Insert > Media 
> Photo Album to create a slideshow from a series of pictures with the 'Photo 
Album' feature."), "", "tipoftheday_i.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Did you know that you can attach comments 
to portions of text? Just use shortcut Ctrl+Alt+C for it."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to insert the date in a spreadsheet 
cell? Type Ctrl+; or Shift+Ctrl+; to insert the time."), "", 
"tipoftheday_c.png"},
+     { 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)"), 
"", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Batch convert your MS Office documents to 
OpenDocument format by the Document Converter wizard in menu File > Wizards > 
Document converter."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Tools > Options > Calc > View > 
Zoom: 'Synchronize sheets' so that each sheet in Calc has its own zoom 
factor."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Open a CSV file as a new sheet in the 
current spreadsheet via Sheet > Sheet from file."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to move a Writer table? Table > Select 
> Table and Insert > Frame… and move where you want."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "In %PRODUCTNAME Draw to change the 0/0 
point of the rulers, drag the intersection of the two rulers in the top left 
corner into the workspace."), "", "tipoftheday_d.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Hold down Ctrl and turn the mouse wheel to 
change the zoom factor."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Edit > Find & Replace lets you insert 
special characters directly: right click in input fields or press 
Shift+Ctrl+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."), "", "tipoftheday_w.png"},
+     { 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", "Keep the zeros before a number by using 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 you should use Paste Special and uncheck everything 
except ‘Comments’ in dialog. Use Operations ‘Add’ to not override existing 
content."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Select an object in the document background 
via the Select tool in the Drawing toolbar to surround the object to select."), 
"", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Apply Heading paragraph styles in Writer 
with shortcut keys: Ctrl+1 applies Heading 1, Ctrl+2 applies Heading 2, etc."), 
"", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Mix portrait and landscape orientations in 
a Calc spreadsheet by applying different page styles on sheets."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Create different master pages in a 
presentation template: View > Master Slide and Slide > New Master (or per 
toolbar or right click in slide pane)."), "", "tipoftheday_i.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Format > Page > 'Fit object to paper 
format' in Draw/Impress to resize the objects so that they fit on your chosen 
paper format."), "", "tipoftheday_d.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To modify an AutoPlay presentation, open it 
and after it starts, right click and select Edit in the context menu."), "", 
"tipoftheday_i.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Rename your slides in Impress to help you 
define 'Go to page' interactions and to have a summary more explicit than 
Slide1, Slide2…"), "", "tipoftheday_i.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Play music throughout a slideshow by 
assigning the sound to the first slide transition without clicking the ‘Apply 
to All Slides’ button."), "", "tipoftheday_i.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "With ‘Slide Show > Custom Slide Show’, 
reorder and pick slides to fit a slideshow to the needs of your public."), "", 
"tipoftheday_i.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Include a paragraph that is not a title in 
the table of contents by changing Outline & Numbering in the paragraph settings 
to an outline level."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use the Connector tool from the Drawing 
toolbar in Draw/Impress to create nice flow charts and optionally copy/paste 
the object into Writer."), "", "tipoftheday_d.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to see, but not print, an object in 
Draw? Draw it on a layer for which the ‘Printable’ flag is not set (right click 
on the tab and ‘Modify Layer’)."), "", "tipoftheday_d.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to print two portrait pages on a 
landscape one (reducing A4 to A5)? File > Print and select 2 at ‘Pages per 
sheet’."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To get the ‘Vertical Text’ tool in the 
Drawing toolbar, check Tools > Options > Language Settings > Languages > 
Default languages > Asian (and make the button visible with right click)."), 
"", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to add many shapes in Draw/Impress? 
Double-click a tool in the drawing toolbar to use it for repeated tasks."), "", 
"tipoftheday_d.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to display only the highest values in 
a spreadsheet? Select menu Data > AutoFilter, click the drop-down arrow, and 
chose ‘Top10’."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Unable to modify or delete a custom cell 
style? Check all sheets, none should be protected."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to know how many days there are in the 
current month? Use the DAYSINMONTH(TODAY()) function."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Add background images to spreadsheets via 
Insert > Image or drag a background from the Gallery, then Format > Arrange > 
To Background."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To quickly get a math object in Writer type 
your formula, mark it, and use Insert > Object > Formula to convert the 
text."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Writer can insert a blank page between two 
odd (even) pages that follow. Check ‘Print automatically inserted blank pages’ 
in the print dialog’s Writer tab."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "The 4th optional parameter of VLOOKUP Calc 
function indicates whether the first column of data is sorted. If not, enter 
FALSE or zero."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to show hidden column A? Click a cell 
in column B, press the left mouse button, move the mouse to the left, release. 
Then switch it on via Format > Columns > Show."), "", "tipoftheday_c.png"},
+     { 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."), 
"", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to present a report written with 
Writer? File > Send > Outline to Presentation automatically creates a slideshow 
from the outline."), "", "tipoftheday_w.png"},
+     { 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."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Format > Align (or the context menu) 
for precise positioning of objects in Draw/Impress: it centers on the page if 
one object is selected or works on the group respectively."), "", 
"tipoftheday_d.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Repeat the heading on a subsequent page 
when a table spans over more than one page with Table > Table Properties > Text 
Flow > Repeat heading."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use column or row labels in formulas. For 
example, if you have two columns, ‘Time’ and ‘KM’, use =Time/KM to get minutes 
per kilometer."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To change the number of a page in Writer, 
go to the properties of the first paragraph and at the Text Flow tab check 
Break > Insert and enter the number."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want the cursor to go into the cell to the 
right, after entering a value in Calc? Use the Tab key instead of Enter."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Show or hide comments in Writer by clicking 
the comment toggle button in the ruler."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Fit your sheet or print ranges to a page 
with Format > Page > Sheet Tab > Scaling Mode."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Keep column headers of a sheet visible when 
scrolling lines via View > Freeze Cells > Freeze First Row."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want your chapter titles to always begin a 
page? Edit Heading1 (paragraph style) > Text Flow > Breaks and check Insert > 
Page > Before."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to keep the text from, but remove a 
hyperlink, in Writer? Right click the link and ‘Remove Hyperlink’."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Create a chart based on a Writer table by 
clicking in the table and chossing Insert > Chart."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Move a column in Calc between two others in 
one step? Click the header then a cell in the column, keep mouse button and 
move to the target with Alt key."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use the Backspace key instead of Delete in 
Calc.  You can choose what to delete."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To distribute some text in multi-columns 
select the text and apply Format > Columns."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Slide Show > Settings > 
Presentation always on top if you need another program displays its window to 
the front of your presentation."), "", "tipoftheday_i.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Select options in Tools > Options > Writer 
> Formatting Aids > Display to specify which non-printing characters are 
displayed."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want the same layout for the screen display 
and printing? Check Tools > Options > Calc > General > Use printer metrics for 
text formatting."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Customize your footnotes page with Tools > 
Footnotes and Endnotes…"), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to sum a cell through several sheets? 
Refer to the range of sheets e.g. =SUM(Sheet1.A1:Sheet3.A1)."), "", 
"tipoftheday_c.png"},
+     { 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 and use Sheet > Fill Cells > Fill Sheets."), "", "tipoftheday_c.png"},
+     { 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."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Click a column field (row) PivotTable and 
press F12 to group data. Choices adapt to content: Date (month, quarter, year), 
number (classes)"), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to count words for just one particular 
paragraph style? Use Edit > Find & Replace > Paragraph Styles, select the style 
> Find All and read the number from the status bar."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Toolbars are contextual, they open 
depending on the context. If you do not want that, uncheck them from View > 
Toolbars."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Insert and number your formulas in one 
step: type fn then F3. An AutoText is inserted with formula and number aligned 
in a table."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To automatically number your table rows in 
Writer, select the relevant column, then apply a numbering style from List 
Styles."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Delete in one step all of your printing 
areas: select all sheets then Format > Print Ranges > Clear."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME helps you not to enter two or 
more spaces in Writer. Check Tools > AutoCorrect Options > Options > Ignore 
double spaces."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Transpose a writer table? Copy and paste in 
Calc, transpose with copy/paste special then copy/paste special > Formatted 
text in Writer."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Writer lets you number your footnotes per 
page, chapter, document: Tools > Footnotes and Endnotes > Footnotes tab > 
Counting."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Left-handed? Enable Tools > Options > 
Language Settings > Languages > Asian and check Tools > Options > Writer > View 
> Ruler > Right-aligned, which displays the scrollbar to the left."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To display the scrollbar to the left, 
enable Tools > Options > Language Settings > Languages > Complex text and check 
Sheet > Right-To-Left."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Your numbers are displayed as ### in your 
spreadsheet? The column is too narrow to display all digits."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Ctrl+Alt+Shift+V to paste the contents 
of the clipboard as unformatted text."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "When editing a cell in place, you can right 
click and Insert fields: Date, Sheet name, Document title etc."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can restarts the slide show after a 
pause specified at Slide Show > Slide Show Settings > Loop and repeat."), "", 
"tipoftheday_i.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can not see all the text in a cell? 
Expand the input line in the formula bar and you can scroll."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You often create a document from another? 
Have you considered using a template?"), "", "tipoftheday_w.png"},
+     { 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", "Want to duplicate the above line? Press 
Ctrl + D or use Sheet > Fill Cells > Fill Down."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can easily optimize your table per 
Table > Size > Distribute Rows / Columns Evenly."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Best way to fix bad looking MS Word table 
cells via Table > Size > Optimal Row Height / Column Width."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Don't get lost in large documents. Use the 
Navigator (F5) to find your way through the content."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can use styles to make the tables in 
your document consistent. Choose one from the predefined per Styles (F11) or  
via Table > AutoFormat."), "", "tipoftheday_w.png"},
+     { 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"), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to center cells on a printed page? 
Format > Page, Page > Layout settings > Table alignment."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can show formulas instead of results 
with View > Show Formula (or Tools > Options > Calc > View > Display > 
Formulas)."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to jump to a particular page by its 
number? Click the left-most statusbar entry or use Edit > Go To Page… or press 
Ctrl+G."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "With Tools > AutoText > AutoText > Import 
you can select Word document or template containing the AutoText entries that 
you want to import."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can display a number as a fraction 
(0.125 = 1/8): Format > Cells, Number > Fraction."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To print the notes of your slides go to 
File > Print > Impress tab and select Notes under Document > Type."), "", 
"tipoftheday_i.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can move an object to another layer by 
holding it until its edges flash, then drag it to the tab of the layer you want 
to move it to."), "", "tipoftheday_d.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to find words more than 10 characters? 
Edit > Find & Replace > Search > [a-z]{10,} > Other Options > check Regular 
expressions."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Make it easy to insert a picture in a 
Writer template by Insert > Fields > More fields > Functions > PlaceHolder > 
Image. One click to select an image."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Create a master document from the current 
Writer document? File > Send > Create Master Document (sub-documents are 
created depending of outline)."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Your date acceptance pattern is 
inappropriate? Tools > Options > Language Settings > Language > Date acceptance 
patterns allows to tweak the pattern."), "", ""},
+     { 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 (remove direct character formats)."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You will search in several sheets when you 
select them before you start the search."), "", "tipoftheday_c.png"},
+     { 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."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "A date is a formated number of days since a 
date origin. An hour is a day divided by 24 with noon = 0.5."), "", 
"tipoftheday_c.png"},
+     { 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", "Insert your metadata in your document with 
Insert > Fields > More Fields… > Document or DocInformation."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To delete multiple comments, copy the 
range, paste special, and select everything except comments."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You would like to view the calculation of 
individual elements of a formula, select the respective elements and press 
F9."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can rotate cells table orientation with 
Table > Properties… > Text Flow > Text orientation."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Many images in your Writer document? Speed 
up the display by disabling View > Images and charts."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Shift+Ctrl+del deletes from cursor to the 
end of the current sentence."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need an unnumbered item in a list? Use 
'Insert Unnumbered Entry' in the Bullets and Numbering toolbar."), "", 
"tipoftheday_w.png"},
+     { 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."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Do not insert manual breaks to separate two 
paragraphs. Rather change Indents & Spacing > Spacing > Below paragraph at the 
style/paragraph properties."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Your documents don’t open at the position 
where you have saved it? Check Tools > Options > %PRODUCTNAME > User Data > 
First/Last name is not empty."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "With the Navigator you can select & move 
up/down headings and the text below the heading, in the Navigator and in the 
document."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME doesn't calculate from left to 
right but respects the order Parentheses > Exponents > Multiplication > 
Division > Addition > Subtraction."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can change the default function in the 
status bar: right click on the area."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You do not want to print all columns? Hide 
or group the ones you do not need."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Shift+Space to select the current row 
and Ctrl+Space to select the current column."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To insert the current date in your document 
use Insert > Field > Date."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Click at the beginning (end) of a section 
and press Alt+Enter to insert a paragraph before (after) the section."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can set a color for each tab: 
right-click the tab or use Sheet > Sheet Tab Color."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You want to start working with %PRODUCTNAME 
basic macros? Take a look at the examples under Tools > Macros > Edit 
Macros."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To remove the page number from your table 
of contents go to Insert > Table of Contents (or right-click and Edit the 
previously inserted index). At the Entries tab delete the page number (#) from 
Structure line."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Outline numbering lets you set text to be 
displayed before the chapter number. For example, type 'Chapter ' to display 
'Chapter 1'"), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to know if a cell is referred in 
formulas of other cells? Tools > Detective > Trace Dependents (Shift+F5)."), 
"", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can customize the middle mouse button 
per Tools > Options > %PRODUCTNAME > View > Middle Mouse button."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To repeat rows/columns on every pages use 
Format > Print Ranges > Edit."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to precisely position? Alt+arrow Keys 
move objects (shape, picture, formula) by one pixel."), "", 
"tipoftheday_d.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Choose ‘Hierarchical View’ in the Styles 
and Formatting sidebar to see the relation between styles."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can toggle between the field names and 
the actual value with View > Fields Names (or Ctrl + F9)."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Creating a Style based on another, you can 
enter a percentage value or a point value (e.g. 110% or -2pt or +5pt)."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to return to default after applying a 
list style? Click Bullets or Numbering On/Off tool on the Formatting 
toolbar."), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Configure use of the Ctrl key to follow 
hyperlinks? Tools > Options > %PRODUCTNAME > Security > Options > ‘Ctrl+click 
required to follow hyperlinks’."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Annoyed from the marching ants around cells 
in Calc. Press escape to stop them; the copied content will remain available 
for pasting."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To quickly insert or delete rows, select 
the desired number of rows (or columns) and press Ctrl+ to add or Ctrl- to 
delete."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To select a contiguous range of cells 
containing data and bounded by empty row and columns use Ctrl+* (numeric key 
pad)."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Ctrl+Shift+F9 recalculates all formulas in 
all sheets (some functions like RANDBETWEEN are not calculated by F9)."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Write along a curve? Draw the line, double 
click, type the text, Format > Text Box and Shape > Fontwork."), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To enable macro recording, check Tools > 
Options > %PRODUCTNAME > Advanced > Enable macro recording."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "In the replace input field of auto correct 
options you can use the wildcards .*"), "", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to export formulas to CSV? File > Save 
As > Type:Text CSV, check ‘Edit filter settings’, and check ‘Save cell 
formulas’ in the next dialog."), "", "tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "No need to scroll through the list at Tools 
> Customize > Keyboard to find a shortcut: just type it."), "", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To quickly zoom in the selection, press / 
(divide key) on the number pad. Press * to restore entire page in screen."), 
"", "tipoftheday_d.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To quickly zoom in on range selection, 
right click on the zoom part of the status bar and choose Optimal."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can reformat all comments in a document 
by clicking the down arrow in a comment and choose 'Format all Comments'."), 
"", "tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To convert a formula into static values you 
don’t need to copy/paste; use Data > Calculate > Formula to Value."), "", 
"tipoftheday_c.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Find all expressions in brackets per Edit > 
Find & Replace > Find > \\([^)]+\\) (check ‘Regular expressions’)"), "", 
"tipoftheday_w.png"},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can change the look of %PRODUCTNAME at 
Tools > Options > View > User Interface."), "", ""},
 };
 
+#define STR_HELP_LINK                   NC_("STR_HELP_LINK", "%PRODUCTNAME 
Help")
+#define STR_MORE_LINK                   NC_("STR_MORE_LINK", "More info")
+
 #endif //INCLUDED_CUI_INC_TIPOFTHEDAY_HRC
 
 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/cui/source/dialogs/tipofthedaydlg.cxx 
b/cui/source/dialogs/tipofthedaydlg.cxx
index 5bf72f525391..0f634876ddd8 100644
--- a/cui/source/dialogs/tipofthedaydlg.cxx
+++ b/cui/source/dialogs/tipofthedaydlg.cxx
@@ -27,6 +27,8 @@
 #include <tipoftheday.hrc>
 #include <vcl/graphicfilter.hxx>
 #include <vcl/virdev.hxx>
+#include <sfx2/sfxhelp.hxx>
+#include <vcl/svapp.hxx>
 
 TipOfTheDayDialog::TipOfTheDayDialog(weld::Window* pParent)
     : GenericDialogController(pParent, "cui/ui/tipofthedaydialog.ui", 
"TipOfTheDayDialog")
@@ -64,35 +66,42 @@ static bool file_exists(const OUString& fileName)
 
 void TipOfTheDayDialog::UpdateTip()
 {
-    //get string
-    OUString aText;
-    aText = CuiResId(TIPOFTHEDAY_STRINGARRAY[nCurrentTip].first);
-    //move hyperlink into linkbutton
-    sal_Int32 nPos = aText.indexOf("http");
-    if (nPos > 0)
+    // text
+    OUString aText = 
CuiResId(std::get<0>(TIPOFTHEDAY_STRINGARRAY[nCurrentTip]));
+    m_pText->set_label(aText);
+
+    // hyperlink
+    aLink = std::get<1>(TIPOFTHEDAY_STRINGARRAY[nCurrentTip]);
+    if (aLink.isEmpty())
     {
+        m_pLink->set_visible(false);
+    }
+    else if (aLink.startsWith("http"))
+    {
+        m_pLink->set_uri(aLink);
+        m_pLink->set_label(CuiResId(STR_MORE_LINK));
         m_pLink->set_visible(true);
-        if (aText.getLength() - nPos > 40)
-            m_pLink->set_label(aText.copy(nPos, 40) + "...");
-        else
-            m_pLink->set_label(aText.copy(nPos));
-        m_pLink->set_uri(aText.copy(nPos));
-        aText = aText.copy(0, nPos - 1);
+        m_pLink->connect_clicked(Link<weld::LinkButton&, void>());
     }
     else
-        m_pLink->set_visible(false);
-    m_pText->set_label(aText);
+    {
+        m_pLink->set_uri("");
+        m_pLink->set_label(CuiResId(STR_HELP_LINK));
+        m_pLink->set_visible(true);
+        //converts aLink into the proper offline/online hyperlink
+        m_pLink->connect_clicked(LINK(this, TipOfTheDayDialog, OnLinkClick));
+    }
 
-    // import the image
+    // image
     OUString aURL("$BRAND_BASE_DIR/$BRAND_SHARE_SUBDIR/tipoftheday/");
     rtl::Bootstrap::expandMacros(aURL);
-    OUString aName = TIPOFTHEDAY_STRINGARRAY[nCurrentTip].second;
+    OUString aImage = std::get<2>(TIPOFTHEDAY_STRINGARRAY[nCurrentTip]);
     // use default image if none is available with the number
-    if (aName.isEmpty() || !file_exists(aURL + aName))
-        aName = "tipoftheday.png";
+    if (aImage.isEmpty() || !file_exists(aURL + aImage))
+        aImage = "tipoftheday.png";
     // draw image
     Graphic aGraphic;
-    if (GraphicFilter::LoadGraphic(aURL + aName, OUString(), aGraphic) == 
ERRCODE_NONE)
+    if (GraphicFilter::LoadGraphic(aURL + aImage, OUString(), aGraphic) == 
ERRCODE_NONE)
     {
         ScopedVclPtr<VirtualDevice> m_pVirDev;
         m_pVirDev = m_pImage->create_virtual_device();
@@ -111,6 +120,11 @@ IMPL_STATIC_LINK(TipOfTheDayDialog, OnShowTipToggled, 
weld::ToggleButton&, rButt
     xChanges->commit();
 }
 
+IMPL_LINK_NOARG(TipOfTheDayDialog, OnLinkClick, weld::LinkButton&, void)
+{
+    Application::GetHelp()->Start(aLink, static_cast<weld::Widget*>(nullptr));
+}
+
 IMPL_LINK_NOARG(TipOfTheDayDialog, OnNextClick, weld::Button&, void)
 {
     nCurrentTip = rand() % nNumberOfTips;
diff --git a/cui/source/inc/tipofthedaydlg.hxx 
b/cui/source/inc/tipofthedaydlg.hxx
index 1e7b1eba8c07..1f55df1156da 100644
--- a/cui/source/inc/tipofthedaydlg.hxx
+++ b/cui/source/inc/tipofthedaydlg.hxx
@@ -32,9 +32,11 @@ private:
 
     sal_uInt32 nCurrentTip;
     sal_uInt32 nNumberOfTips;
+    OUString aLink;
     void UpdateTip();
     DECL_STATIC_LINK(TipOfTheDayDialog, OnShowTipToggled, weld::ToggleButton&, 
void);
     DECL_LINK(OnNextClick, weld::Button&, void);
+    DECL_LINK(OnLinkClick, weld::LinkButton&, void);
 
 public:
     TipOfTheDayDialog(weld::Window* pWindow);
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

Reply via email to