Package_tipoftheday.mk

Heiko Tietze (via logerrit) Thu, 09 Mar 2023 09:07:35 -0800

 cui/inc/bitmaps.hlst                        |    6 
 cui/inc/tipoftheday.hrc                     |  456 ++++++++++++++--------------
 cui/source/dialogs/tipofthedaydlg.cxx       |   23 +
 extras/source/tipoftheday/tipoftheday.svg   |    1 
 extras/source/tipoftheday/tipoftheday_c.svg |    1 
 extras/source/tipoftheday/tipoftheday_d.svg |    1 
 extras/source/tipoftheday/tipoftheday_i.svg |    1 
 extras/source/tipoftheday/tipoftheday_w.svg |    1 
 vcl/Package_tipoftheday.mk                  |    5 
 9 files changed, 254 insertions(+), 241 deletions(-)


New commits:
commit 49379a0b3fc7b263a7e5be2ecbb018e9248d01f2
Author:     Heiko Tietze <tietze.he...@gmail.com>
AuthorDate: Thu Mar 9 12:47:05 2023 +0100
Commit:     Heiko Tietze <heiko.tie...@documentfoundation.org>
CommitDate: Thu Mar 9 17:07:04 2023 +0000

    Resolves tdf#131177 - Replace Hard-Coded TotD bulb by themeable icon
    
    Change-Id: I25006f64436a72f554450929b1b649478b02cbc8
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/148536
    Tested-by: Jenkins
    Reviewed-by: Heiko Tietze <heiko.tie...@documentfoundation.org>

diff --git a/cui/inc/bitmaps.hlst b/cui/inc/bitmaps.hlst
index e36184208fc5..5e10e014b446 100644
--- a/cui/inc/bitmaps.hlst
+++ b/cui/inc/bitmaps.hlst
@@ -74,4 +74,10 @@ inline constexpr OUStringLiteral RID_SVXBMP_MACRO = 
u"svx/res/id018.png";
 
 inline constexpr OUStringLiteral RID_SVXBMP_STARS_FULL = 
u"cmd/sc_stars-full.png";
 
+inline constexpr OUStringLiteral RID_SVXBMP_TOTD_WRITER = 
u"res/tipoftheday_w.png";
+inline constexpr OUStringLiteral RID_SVXBMP_TOTD_CALC = 
u"res/tipoftheday_c.png";
+inline constexpr OUStringLiteral RID_SVXBMP_TOTD_DRAW = 
u"res/tipoftheday_d.png";
+inline constexpr OUStringLiteral RID_SVXBMP_TOTD_IMPRESS = 
u"res/tipoftheday_i.png";
+inline constexpr OUStringLiteral RID_SVXBMP_TOTD_SOFFICE = 
u"res/tipoftheday.png";
+
 /* vim:set shiftwidth=4 softtabstop=4 expandtab cinoptions=b1,g0,N-s 
cinkeys+=0=break: */
diff --git a/cui/inc/tipoftheday.hrc b/cui/inc/tipoftheday.hrc
index 9dc6a3d81488..2248f60562fd 100644
--- a/cui/inc/tipoftheday.hrc
+++ b/cui/inc/tipoftheday.hrc
@@ -27,7 +27,7 @@
 #include <unotools/resmgr.hxx>
 
 /*
- * std:tuple consists of <text, uri, image>
+ * std:tuple consists of <text, uri, image, module>
  * text:
    * escape backslash, ie. use \\ to show \
    * Use %MOD1 for Ctrl/Cmd and %MOD2 for Alt/Option depending on OS 
(uppercase required)
@@ -43,236 +43,240 @@
    * leave the image string empty for the default tipoftheday.png
    * place new images at extra/source/tipoftheday and do not forget to add the 
files to vcl/Package_tipoftheday.mk
    * images are scaled to 150x150px; const ThumbSize() in tipoftheday.cxx
+ * module
+   * use on of the options below; an overlay is drawn on the default image 
tipoftheday.png except for the generic soffice (and of course not if an image 
is set)
 */
+enum tipModule : sal_uInt8
+{ swriter, scalc, sdraw, simpress, soffice };
 
-const std::tuple<TranslateId, OUString, OUString> TIPOFTHEDAY_STRINGARRAY[] =
+const std::tuple<TranslateId, OUString, OUString, tipModule> 
TIPOFTHEDAY_STRINGARRAY[] =
 {
-     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME offers a variety of user 
interface options to make you feel at home"), ".uno:ToolbarModeUI", 
"toolbarmode.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/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/section_edit.html";,
 "tipoftheday_w.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "To print the notes of your slides go to 
File ▸ Print ▸ %PRODUCTNAME Impress tab and select Notes under Document ▸ 
Type."), "", "printnote.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To start temporarily with a fresh user 
profile, or to restore a non-working %PRODUCTNAME, use Help ▸ Restart in Safe 
Mode."), "svx/ui/safemodedialog/SafeModeDialog", ""}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/01/profile_safe_mode.html
-     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/globaldoc.html";,
 "tipoftheday_w.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can create editable Hybrid PDFs with 
%PRODUCTNAME."), 
"https://wiki.documentfoundation.org/Documentation/HowTo/CreateAHybridPDF";, 
"hybrid_pdf.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Explore the ten different functions in the 
status bar (at the bottom of the document window). Place the cursor over each 
field for an explanation. If not visible, use View ▸ Status Bar."), "", 
"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)."), "", 
"sum_sheets.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can create fillable form documents 
(even PDFs) with %PRODUCTNAME."), 
"https://www.techrepublic.com/article/how-to-create-interactive-pdfs-with-libreoffice";,
 "formdocuments.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Cannot see all the text in a cell? Expand 
the input line in the formula bar and you can scroll."), "", 
"expand_formula_bar.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Optimize your table layout with Table ▸ 
Size ▸ Distribute Rows / Columns Evenly."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Find all expressions in brackets per Edit ▸ 
Find and Replace ▸ Find ▸ \\([^)]+\\) (check “Regular expressions”)"), "", 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Select a different icon set from Tools ▸ 
Options ▸ %PRODUCTNAME ▸ View ▸ Icon Theme."), "", "icon_sets.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can display a number as a fraction 
(0.125 = 1/8): Format ▸ Cells, under Numbers tab in the Category select 
Fraction."), "", "fraction.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To remove a hyperlink but keep its text, 
right-click on the hyperlink, and use “Remove Hyperlink”."), "", 
"remove_hyperlink.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To remove several hyperlinks at once, 
select the text with the hyperlinks, then right-click and use “Remove 
Hyperlink”."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To zoom a selection to fit the entire 
window in Draw, use the / (divide key) on the number pad."), "", 
"tipoftheday_d.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", "You can restart the slide show after a 
pause specified at Slide Show ▸ Slide Show Settings ▸ Loop and repeat after."), 
"", "tipoftheday_i.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", "Use View ▸ Value Highlighting to display 
cell contents in colors: Text/black, Formulas/green, Numbers/blue, Protected 
cells/grey background."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/03080000.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can create different master pages in a 
presentation template: View ▸ Master Slide and Slide ▸ New Master (or per 
toolbar or right click in slide pane)."), "", "masterdocument.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", "Display photos or images with different 
shapes in Writer. Insert and select shape, then Insert ▸ Image. To adjust 
image, right-click on selected shape and choose Area."), "", 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Page/Slide ▸ Properties ▸ “Fit object 
to paper format” in Draw/Impress to resize the objects so that they fit on your 
chosen paper format."), "", "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Fit the entire page in a Draw window, use * 
on the number pad."), "", "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "In a Draw page, use “-” to zoom out; “+” to 
zoom in."), "", "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to show the contents of another 
document within your document? Use Insert ▸ Section and select Link."), 
"modules/swriter/ui/editsectiondialog/link", "tipoftheday_w.png"}, // 
https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/section_insert.html#par_id3153404
-     { NC_("RID_CUI_TIPOFTHEDAY", "To automatically number table rows in 
Writer, select the relevant column, then apply a List Style."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/01/05130004.html";,
 "tipoftheday_w.png"}, // no local help URI
-     { 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", "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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/12030200.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can change the default function in the 
status bar: right click on the area."), "", "statusbar.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to add many of the same 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", "%MOD1+Shift+F9 recalculates all formulas in 
all spreadsheets."), "", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to keep a part of an editable document 
as read-only? Insert ▸ Section. Add text to the section, then right-click “Edit 
Section” and check “Protect”."), "", "tipoftheday_w.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", "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", "To repeat a table heading when a table 
spans over a page, use Table ▸ Table Properties ▸ Text Flow ▸ Repeat 
heading."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to quickly insert or delete rows? 
Select the desired number of rows (or columns) and press %MOD1+Plus sign (+) to 
add or %MOD1+Minus sign (-) to delete."), 
"modules/scalc/ui/insertcells/InsertCellsDialog", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To repeat rows/columns on every pages use 
Format ▸ Print Ranges ▸ Edit."), "", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Insert images and photos into shapes in 
Draw and Impress. Right-click on a shape, choose Area ▸ Image ▸ Add / Import, 
and use Options to adjust appearance."), "", ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Need to insert the date in a spreadsheet 
cell? Type %MOD1+; or Shift+%MOD1+; to insert the time."), "", 
"tipoftheday_c.png"},
-     { 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", "Get help from the community via the Ask 
portal."), "https://ask.libreoffice.org";, ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Shift+Space to select the current row 
and %MOD1+Space to select the current column."), "", "tipoftheday_c.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", "Data ▸ Validity allows you to create 
drop-down lists where the user selects a value instead of typing."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/guide/validity.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Hold down %MOD1 and turn the mouse wheel to 
change the zoom factor."), "", ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has great extensions to 
increase your productivity—check them out."), 
"https://extensions.libreoffice.org";, ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to count words for just one particular 
paragraph style? Use Edit ▸ Find and Replace, click Paragraph Styles, select 
the style in Find, and click Find All. Read the result in the status bar."), 
"", "tipoftheday_w.png"},
-     { 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", "%PRODUCTNAME offers a variety of user 
interface options to make you feel at home"), ".uno:ToolbarModeUI", 
"toolbarmode.png", soffice},
+     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/section_edit.html";,
 "", swriter}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "To print the notes of your slides go to 
File ▸ Print ▸ %PRODUCTNAME Impress tab and select Notes under Document ▸ 
Type."), "", "printnote.png", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To start temporarily with a fresh user 
profile, or to restore a non-working %PRODUCTNAME, use Help ▸ Restart in Safe 
Mode."), "svx/ui/safemodedialog/SafeModeDialog", "", soffice}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/01/profile_safe_mode.html
+     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/globaldoc.html";,
 "", swriter}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can create editable Hybrid PDFs with 
%PRODUCTNAME."), 
"https://wiki.documentfoundation.org/Documentation/HowTo/CreateAHybridPDF";, 
"hybrid_pdf.png", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Explore the ten different functions in the 
status bar (at the bottom of the document window). Place the cursor over each 
field for an explanation. If not visible, use View ▸ Status Bar."), "", "", 
swriter},
+     { 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)."), "", 
"sum_sheets.png", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can create fillable form documents 
(even PDFs) with %PRODUCTNAME."), 
"https://www.techrepublic.com/article/how-to-create-interactive-pdfs-with-libreoffice";,
 "formdocuments.png", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Cannot see all the text in a cell? Expand 
the input line in the formula bar and you can scroll."), "", 
"expand_formula_bar.png", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Optimize your table layout with Table ▸ 
Size ▸ Distribute Rows / Columns Evenly."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Find all expressions in brackets per Edit ▸ 
Find and Replace ▸ Find ▸ \\([^)]+\\) (check “Regular expressions”)"), "", "", 
swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Select a different icon set from Tools ▸ 
Options ▸ %PRODUCTNAME ▸ View ▸ Icon Theme."), "", "icon_sets.png", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can display a number as a fraction 
(0.125 = 1/8): Format ▸ Cells, under Numbers tab in the Category select 
Fraction."), "", "fraction.png", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To remove a hyperlink but keep its text, 
right-click on the hyperlink, and use “Remove Hyperlink”."), "", 
"remove_hyperlink.png", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To remove several hyperlinks at once, 
select the text with the hyperlinks, then right-click and use “Remove 
Hyperlink”."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To zoom a selection to fit the entire 
window in Draw, use the / (divide key) on the number pad."), "", "", sdraw},
+     { 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)"), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can restart the slide show after a 
pause specified at Slide Show ▸ Slide Show Settings ▸ Loop and repeat after."), 
"", "", simpress},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To distribute some text in multi-columns 
select the text and apply Format ▸ Columns."), "", "", swriter},
+     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/03080000.html";,
 "", scalc}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can create different master pages in a 
presentation template: View ▸ Master Slide and Slide ▸ New Master (or per 
toolbar or right click in slide pane)."), "", "masterdocument.png", swriter},
+     { 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."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Display photos or images with different 
shapes in Writer. Insert and select shape, then Insert ▸ Image. To adjust 
image, right-click on selected shape and choose Area."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Page/Slide ▸ Properties ▸ “Fit object 
to paper format” in Draw/Impress to resize the objects so that they fit on your 
chosen paper format."), "", "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Fit the entire page in a Draw window, use * 
on the number pad."), "", "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "In a Draw page, use “-” to zoom out; “+” to 
zoom in."), "", "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to show the contents of another 
document within your document? Use Insert ▸ Section and select Link."), 
"modules/swriter/ui/editsectiondialog/link", "", swriter}, // 
https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/section_insert.html#par_id3153404
+     { NC_("RID_CUI_TIPOFTHEDAY", "To automatically number table rows in 
Writer, select the relevant column, then apply a List Style."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/01/05130004.html";,
 "", swriter}, // no local help URI
+     { 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/";, "", 
soffice},
+     { 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", "", scalc}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/12030200.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can change the default function in the 
status bar: right click on the area."), "", "statusbar.png", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to add many of the same shapes in 
Draw/Impress? Double-click a tool in the drawing toolbar to use it for repeated 
tasks."), "", "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%MOD1+Shift+F9 recalculates all formulas in 
all spreadsheets."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to keep a part of an editable document 
as read-only? Insert ▸ Section. Add text to the section, then right-click “Edit 
Section” and check “Protect”."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use the Backspace key instead of Delete in 
Calc. You can choose what to delete."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Best way to fix bad-looking MS Word table 
cells via Table ▸ Size ▸ Optimal Row Height / Column Width."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To repeat a table heading when a table 
spans over a page, use Table ▸ Table Properties ▸ Text Flow ▸ Repeat 
heading."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to quickly insert or delete rows? 
Select the desired number of rows (or columns) and press %MOD1+Plus sign (+) to 
add or %MOD1+Minus sign (-) to delete."), 
"modules/scalc/ui/insertcells/InsertCellsDialog", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To repeat rows/columns on every pages use 
Format ▸ Print Ranges ▸ Edit."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Insert images and photos into shapes in 
Draw and Impress. Right-click on a shape, choose Area ▸ Image ▸ Add / Import, 
and use Options to adjust appearance."), "", "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to insert the date in a spreadsheet 
cell? Type %MOD1+; or Shift+%MOD1+; to insert the time."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Insert your metadata in your document with 
Insert ▸ Fields ▸ More Fields… ▸ Document or DocInformation."), "", "", 
swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Get help from the community via the Ask 
portal."), "https://ask.libreoffice.org";, "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Shift+Space to select the current row 
and %MOD1+Space to select the current column."), "", "", scalc},
+     { 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."), "", "", sdraw},
+     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/guide/validity.html";,
 "", scalc}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Hold down %MOD1 and turn the mouse wheel to 
change the zoom factor."), "", "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has great extensions to 
increase your productivity—check them out."), 
"https://extensions.libreoffice.org";, "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to count words for just one particular 
paragraph style? Use Edit ▸ Find and Replace, click Paragraph Styles, select 
the style in Find, and click Find All. Read the result in the status bar."), 
"", "", swriter},
+     { 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."), "", "", soffice},
 #if ENABLE_LIBRELOGO
-     { NC_("RID_CUI_TIPOFTHEDAY", "Writer includes LibreLogo: simple Logo-like 
programming environment with turtle vector graphics, DTP and graphic design."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/librelogo/LibreLogo.html";,
 "tipoftheday_w.png"}, //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/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/librelogo/LibreLogo.html";,
 "", swriter}, //local help missing
 #endif
-     { NC_("RID_CUI_TIPOFTHEDAY", "Construct your own 2D shapes in Draw. 
Select two or more objects, and explore possibilities with Shape ▸ Combine, 
Shape ▸ Merge, Shape ▸ Subtract, and Shape ▸ Intersect."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/sdraw/guide/combine_etc.html";,
 "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Do you plan to change your computer and 
want to recover your customizations? See:"), 
"https://wiki.documentfoundation.org/UserProfile";, ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can toggle between the field names and 
the actual value with View ▸ Fields Names (or %MOD1+F9)."), "", 
"tipoftheday_w.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", "To enable macro recording, check Tools ▸ 
Options ▸ %PRODUCTNAME ▸ Advanced ▸ Enable macro recording."), "", ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to insert a placeholder for an image 
in a Writer template? Use Insert ▸ Fields ▸ More fields, click Functions tab, 
choose PlaceHolder for Type and Image for Format."), "", "tipoftheday_w.png"},
-     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/shared/optionen/01030300.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Did you know that you can attach comments 
to portions of text? Just use the shortcut %MOD1+%MOD2+C."), "", ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Need to move one or more paragraphs? No 
need to cut and paste: Use the keyboard shortcut %MOD1+%MOD2+Arrow (Up/Down)"), 
"", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Change the basic fonts for the predefined 
template or current document per Tools ▸ Options ▸ %PRODUCTNAME Writer ▸ Basic 
Fonts."), "modules/swriter/ui/optfonttabpage/OptFontTabPage", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/optionen/01040300.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to find words containing more than 10 
characters? Edit ▸ Find and Replace ▸ Search ▸ [a-z]{10,} ▸ Other Options ▸ 
check Regular expressions."), "", "tipoftheday_w.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", "You can continue writing with the default 
formatting attributes after manually applying bold, italic or underline by 
pressing %MOD1+Shift+X."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use %MOD1+%MOD2+Shift+V to paste the 
contents of the clipboard as unformatted text."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Customize footnote appearance with Tools ▸ 
Footnotes and Endnotes…"), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "With Slide Show ▸ Custom Slide Show, 
reorder and pick slides to fit a slideshow to the needs of your viewers."), "", 
"tipoftheday_i.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", "Writer can insert a blank page between two 
odd (even) pages that follow. Check “Print automatically inserted blank pages” 
in the print dialog’s %PRODUCTNAME Writer tab."), "", "tipoftheday_w.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", "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", "Need to position precisely? %MOD2+arrow 
keys move objects (shapes, pictures, formulas) by one pixel."), "", 
"tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Embedded help is available by pressing F1, 
if you have installed it. Otherwise check online at:"), 
"https://help.libreoffice.org";, ""},
-     { 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", "Want to have two or more columns for just a 
part of a %PRODUCTNAME Writer page? Insert ▸ Section, set with Columns tab, and 
place text in that section."), "", "tipoftheday_w.png"},
-     { 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", "You can copy from one sheet to another 
without the clipboard. Select the area to copy, %MOD1+click the target sheet’s 
tab and use Sheet ▸ Fill Cells ▸ Fill Sheets."), "", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can change the look of %PRODUCTNAME via 
View ▸ User Interface."), "", ""},
-     { 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", "You can show formulas instead of results 
with View ▸ Show Formula (or Tools ▸ Options ▸ %PRODUCTNAME Calc ▸ View ▸ 
Display ▸ Formulas)."), "", "tipoftheday_c.png"},
-     { 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", "Left-handed? Enable Tools ▸ Options ▸ 
Language Settings ▸ Languages ▸ Asian and check Tools ▸ Options ▸ %PRODUCTNAME 
Writer ▸ View ▸ Ruler ▸ Right-aligned, which displays the scrollbar to the 
left."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want headings to always begin a page? Edit 
the paragraph style applied to the headings. Check “Insert” on the “Text Flow” 
tab, with Type “Page” and Position “Before”."), 
"cui/ui/textflowpage/checkInsert", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Date/time value is just a number of days 
since a chosen day zero; in the number, integer part represents date, and 
fractional part is time (elapsed part of a day), with 0.5 representing noon."), 
"", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Shift+%MOD1+Del deletes from cursor to the 
end of the current sentence."), "", "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", "Annoyed by the “marching ants” around cells 
in Calc? Press escape to stop them; the copied content will remain available 
for pasting."), "", "marchingants.gif"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to become a %PRODUCTNAME Ambassador? 
There are certifications for developers, admins, and trainers."), 
"https://www.documentfoundation.org/certification/program/";, ""},
-     { 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", "Click on the special character icon in the 
toolbar to get quick access to favorite and recent characters to insert."), "", 
""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Choose “Hierarchical View” in the Styles 
sidebar to see the relation between styles."), "", "tipoftheday_w.png"},
-     { 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 Styles..."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to open hyperlinks without pressing 
the %MOD1 key? Uncheck “%MOD1+click required to open hyperlinks” in Tools ▸ 
Options ▸ %PRODUCTNAME ▸ Security ▸ Options ▸ Security Options."), 
"cui/ui/securityoptionsdialog/ctrlclick", ""},
-     { 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 protect cells with Format ▸ Cells ▸ 
Protection. To prevent insert, delete, rename, move/copy of sheets use Tools ▸ 
Protect Sheet."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/guide/cell_protect.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Write along a curve? Draw the curve, double 
click, type the text, Format ▸ Text Box and Shape ▸ Fontwork. Select one of the 
alignment options: Rotate, Upright, Slant Horizontal or Slant Vertical."), "", 
"tipoftheday_w.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 
choose “Top10”."), "", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To remove the page number from your table 
of contents go to Insert ▸ Table of Contents and Index (or right-click and Edit 
Index to edit a previously inserted index). In the Entries tab delete the page 
number (#) from Structure line."), "", "tipoftheday_w.png"},
-     { 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", "Want to get a math object into Writer 
quickly? Type your formula, select it, and use Insert ▸ OLE Object ▸ Formula to 
convert the text."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "With %PRODUCTNAME it is very easy to 
install a new dictionary: they are supplied as extensions."), 
"https://extensions.libreoffice.org/?q=&Tags[]=50";, ""},
-     { 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."), 
"https://www.libreoffice.org/download/portable-versions/";, ""},
-     { 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", "Your Writer document does not reopen with 
the text cursor at the same editing position it was when you saved it? Add 
First or Last name in Tools ▸ Options ▸ %PRODUCTNAME ▸ User Data ▸ First/last 
name."), "", ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Need to do citation? You can use 
third-party citation managers such as Zotero."), 
"https://wiki.documentfoundation.org/Referencing_Systems_in_LibreOffice";, ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to insert a value in the same place on 
several sheets? Select the sheets: hold down %MOD1 key and click their tabs 
before entering."), "", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to hide some text in a document? 
Select the text. Insert ▸ Section, and select “Hide”."), 
"modules/swriter/ui/editsectiondialog/hide", "tipoftheday_w.png"},  // online 
help is different 
https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/hidden_text.html#hd_id3148675
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can customize the middle mouse button 
by going to Tools ▸ Options ▸ %PRODUCTNAME ▸ View ▸ Mouse ▸ Middle button."), 
"", ""},
-     { 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", "For quick access to your document 
bookmarks, right-click on the page number of the status bar (lower-left corner 
of document window)."), "", "tipoftheday_w.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", "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/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/autotext.html
-     { 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", "%PRODUCTNAME Calc does not calculate from 
left to right but respects the order Parentheses – Exponents – Multiplication – 
Division – Addition – Subtraction."), "", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Get %PRODUCTNAME documentation and free 
user guide books at:"), "https://documentation.libreoffice.org/";, ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to remove all <> at once and keep the 
text inside? Edit ▸ Find and Replace: Search = [<>], Replace = blank and check 
“Regular expressions” under Other options."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/01/02100001.html";,
 ""}, //local help missing
-     { 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", "Want to manage the presentation of 
hyperlinks in a spreadsheet? Insert them with the HYPERLINK function."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060109.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Tools ▸ Options ▸ %PRODUCTNAME Calc 
▸ View ▸ Zoom: “Synchronize sheets” so that each sheet in Calc has its own zoom 
factor."), "", "tipoftheday_c.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", "Trace cells used in a formula, precedents 
(Shift+F9) or dependents (Shift+F5) (or use Tools ▸ Detective). For each hit 
you go one more step in the chain."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/06030000.html";,
 "tipoftheday_c.png"}, //local help missing
-     { 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", "You can create an illustration index from 
object names, not only from captions."), 
"cui/ui/objectnamedialog/ObjectNameDialog", "tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/01/05190000.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use your Android or iPhone to remotely 
control your Impress presentation."), 
"https://help.libreoffice.org/%PRODUCTVERSION/he/text/simpress/guide/impress_remote.html";,
 "tipoftheday_i.png"}, //local help missing
-     { 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", "Your numbers are displayed as ### in your 
spreadsheet? The column is too narrow to display all digits."), "", 
"tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Enable massive parallel calculations of 
formula cells via Tools ▸ Options ▸ %PRODUCTNAME ▸ OpenCL."), 
"cui/ui/optopenclpage/OptOpenCLPage", "tipoftheday_c.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/optionen/opencl.html
-     { 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", "Your donations support our worldwide 
community."), "https://www.libreoffice.org/donate/";, ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You want to add x months to a date? Use 
=EDATE(date;months)."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/func_edate.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "To select a contiguous range of cells 
containing data and bounded by empty row and columns use %MOD1+* (numeric key 
pad)."), "", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Your date acceptance pattern is 
inappropriate? Use Tools ▸ Options ▸ Language Settings ▸ Languages ▸ Date 
acceptance patterns to tweak the pattern."), "", ""},
-     { 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", "The presenter console is a great feature 
when working with %PRODUCTNAME Impress. Have you checked it out?"), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/simpress/guide/presenter_console.html";,
 "tipoftheday_i.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "To delete multiple comments, select cells 
with comments and use Sheet ▸ Cell Comments ▸ Delete Comment."), "", 
"tipoftheday_c.png"},
-     { 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", "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 know the valid command line 
parameters? Start soffice with --help or -h or -?"), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/guide/start_parameters.html";,
 ""}, //local help missing
-     { 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", "Need to include a list item without a 
bullet or number? Use “Insert Unnumbered Entry” in the Bullets and Numbering 
toolbar."), "HID_NUM_TOOLBOX", "tipoftheday_w.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", "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", "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 %MOD2 key."), "", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Automatically mark alphabetical index 
entries using a concordance file."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/indices_index.html";,
 "tipoftheday_w.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Format ▸ Align Objects in Impress or 
Shape ▸ Align Objects in Draw (or the context menu) for precise positioning of 
objects: it centers on the page if one object is selected or works on the group 
respectively."), "", "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Do not 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", "No need to scroll through the list at Tools 
▸ Customize ▸ Keyboard to find a shortcut: just type it."), "", ""},
-     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/shared/optionen/01041100.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "With %PRODUCTNAME you can use your Google 
Mail account to do a mail merge. Fill in Tools ▸ Options ▸ %PRODUCTNAME Writer 
▸ Mail Merge Email."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/form_letters_main.html";,
 "tipoftheday_w.png"}, //local help missing
-     { 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", "You want to start working with Basic 
macros? Take a look at the examples under Tools ▸ Macros ▸ Edit Macros."), "", 
""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Apply Heading paragraph styles in Writer 
with shortcut keys: %MOD1+1 applies Heading 1, %MOD1+2 applies Heading 2, 
etc."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Do not get lost in large documents. Use the 
Navigator (F5) to find your way through the content."), "", ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Edit ▸ Find and Replace lets you insert 
special characters directly: right click in input fields or press 
Shift+%MOD1+S."), "", ""},
-     { 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", "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 
the layer’s tab and choose “Modify Layer”)."), "", "tipoftheday_d.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To insert the current date in your 
document, use Insert ▸ Field ▸ Date."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Got many images in your Writer document? 
Speed up the display by disabling View ▸ Images and charts."), "", 
"tipoftheday_w.png"},
-     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/02140700.html
-     { 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", "Want to display text before a heading 
number? Open the Numbering tab of the “Heading Numbering” dialog and enter the 
desired text in “Before”. For example, type “Chapter ” to display “Chapter 
1”."), "modules/swriter/ui/outlinenumberingpage/prefix", "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", "To get the “Vertical Text” tool in the 
Drawing toolbar, check Tools ▸ Options ▸ Language Settings ▸ Languages ▸ 
Default languages for Documents ▸ Asian (and make the button visible with 
right-click and then Visible Buttons ▸ Vertical Text)."), "", ""},
-     { 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 sign existing PDF files and also 
verify those signatures."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/guide/digital_signatures.html";,
 ""}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Often create one document from another? 
Consider using a template."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Format ▸ Conditional Formatting ▸ 
Manage in Calc to find out which cells have been defined with conditional 
formatting."), 
"modules/scalc/ui/conditionalformatdialog/ConditionalFormatDialog", 
"tipoftheday_c.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/05120000.html
-     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/06030800.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use font embedding for greater 
interoperability with other office suites at File ▸ Properties ▸ Font."), "", 
""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To convert a formula into static values you 
do not need to copy/paste; use Data ▸ Calculate ▸ Formula to Value."), "", 
"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", "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", "When you have created 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", "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", "Batch-convert your Microsoft Office 
documents to the OpenDocument format by using the Document Converter wizard in 
menu File ▸ Wizards ▸ Document Converter."), "", ""},
-     { 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", "Need to move a Writer table? Table ▸ Select 
▸ Table and Insert ▸ Frame ▸ Frame and move where you want."), "", 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "With Tools ▸ AutoText ▸ AutoText ▸ Import 
you can select a Word document or a template containing the AutoText entries 
that you want to import."), "", "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", "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", "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", "Delete all of your printing areas in one 
step: select all sheets, then Format ▸ Print Ranges ▸ Clear."), "", 
"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", "Having trouble pasting text from PDF files 
or webpages into documents? Try to paste as unformatted text 
(%MOD1+%MOD2+Shift+V)."), "", "tipoftheday_w.png"},
-     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060182.html?DbPAR=CALC#bm_id3152966";,
 "tipoftheday_c.png"}, //local help missing
-     { 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", "Toolbars are contextual—they open depending 
on the context. If you do not want that, uncheck them from View ▸ Toolbars."), 
"", ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can create a master document from the 
current Writer document by using File ▸ Send ▸ Create Master Document."), 
"SW_HID_SEND_MASTER_CTRL_PUSHBUTTON_CANCEL", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to center cells on a printed page in 
Calc? Format ▸ Page, Page ▸ Layout settings ▸ Table alignment."), "", 
"tipoftheday_c.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/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/text_frame.html";,
 "tipoftheday_w.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can create a chart based on a Writer 
table by clicking in the table and choosing Insert ▸ Chart."), "", 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Select options in Tools ▸ Options ▸ 
%PRODUCTNAME Writer ▸ Formatting Aids ▸ Display Formatting to specify which 
non-printing characters are displayed."), "", "tipoftheday_w.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 
%MOD1+G."), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME supports over 150 
languages."), 
"https://wiki.documentfoundation.org/Language_support_of_LibreOffice";, ""},
-     { 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", "Want to find the words in bold in a Writer 
document? Edit ▸ Find and Replace ▸ Other options ▸ Attributes ▸ Font 
weight."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/finding.html";,
 "tipoftheday_w.png"}, //local help missing
-     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/01/06100000.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "To insert a paragraph before (after) a 
section, press %MOD2+Enter at the beginning (end) of the section."), "", 
"tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has a template center to 
create good looking documents—check it out."), 
"https://extensions.libreoffice.org/?q=&Tags[]=118";, ""},
-     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060119.html?DbPAR=CALC#bm_id3149577";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Cannot find what you want with the VLOOKUP 
function in Calc? With INDEX and MATCH you can do anything!"), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060109.html";,
 "tipoftheday_c.png"}, //local help missing
-     { 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", "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", "Run %PRODUCTNAME in any browser via 
rollApp."), "https://www.rollapp.com/app/lowriter";, ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Strange error code in Calc, Err: followed 
by a number? This page gives the explanation:"), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/05/02140000.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Include a paragraph that is not a heading 
in the “Table of Contents” by giving a numerical outline level to the paragraph 
in the “Outline & List” tab in the paragraph settings."), 
"modules/swriter/ui/numparapage/comboLB_OUTLINE_LEVEL", "tipoftheday_w.png"},
-     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/indices_toc.html
-     { 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", "You need to fill a series? Select the cell 
range and Sheet ▸ Fill Cells ▸ Fill Series and choose between Linear, Growth, 
Date and AutoFill."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/guide/calc_series.html";,
 "tipoftheday_c.png"}, //local help missing
-     { 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", "In the replace input field of auto correct 
options you can use the wildcards .*"), "", "tipoftheday_w.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to duplicate the above line? Press 
%MOD1+D or use Sheet ▸ Fill Cells ▸ Fill Down."), "", "tipoftheday_c.png"},
-     { NC_("RID_CUI_TIPOFTHEDAY", "To search in several spreadsheets, select 
them before you start the search."), "", "tipoftheday_c.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", "%PRODUCTNAME helps you not to enter two or 
more spaces in Writer. Check Tools ▸ AutoCorrect ▸ AutoCorrect Options ▸ 
Options ▸ Ignore double spaces."), "", "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", "To display the scrollbar to the left, 
enable Tools ▸ Options ▸ Language Settings ▸ Languages ▸ Complex text and right 
click a sheet in Sheet tabs above Status bar ▸ Right-To-Left."), "", 
"tipoftheday_c.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", "New versions of %PRODUCTNAME provide new 
features, bug fixes, and security patches. Keep your software updated!"), 
"SFX2_HID_DLG_CHECKFORONLINEUPDATE", ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Developing new XSLT and XML filters?"), 
"https://fridrich.blogspot.com/2013/08/extending-swiss-army-knife-overview.html";,
 ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Press Shift+F1 to see any available 
extended tooltips in dialog boxes, when \"Extended tips\" is not enabled in 
Tools ▸ Options ▸ %PRODUCTNAME ▸ General."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/05/00000120.html";,
 ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Never use certain arrow styles? Remove them 
by using the Delete button on the Format ▸ Text Box and Shape ▸ Line ▸ Arrow 
Styles tab."), "cui/ui/lineendstabpage/BTN_MODIFY", ""},
-     { NC_("RID_CUI_TIPOFTHEDAY", "Don’t like the position of some icons on 
your toolbar? Change it with Tools ▸ Customize ▸ Toolbars tab ▸ Target."), 
"CUI_HID_SVX_CONFIG_TOOLBAR", ""},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Construct your own 2D shapes in Draw. 
Select two or more objects, and explore possibilities with Shape ▸ Combine, 
Shape ▸ Merge, Shape ▸ Subtract, and Shape ▸ Intersect."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/sdraw/guide/combine_etc.html";,
 "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Do you plan to change your computer and 
want to recover your customizations? See:"), 
"https://wiki.documentfoundation.org/UserProfile";, "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can toggle between the field names and 
the actual value with View ▸ Fields Names (or %MOD1+F9)."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Show or hide comments in Writer by clicking 
the comment toggle button in the ruler."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To enable macro recording, check Tools ▸ 
Options ▸ %PRODUCTNAME ▸ Advanced ▸ Enable macro recording."), "", "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to insert a placeholder for an image 
in a Writer template? Use Insert ▸ Fields ▸ More fields, click Functions tab, 
choose PlaceHolder for Type and Image for Format."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME supports four macro security 
levels (from low to very high) and trusted sources."), 
"cui/ui/optsecuritypage/OptSecurityPage", "", soffice}, // 
https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/optionen/01030300.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Did you know that you can attach comments 
to portions of text? Just use the shortcut %MOD1+%MOD2+C."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to move one or more paragraphs? No 
need to cut and paste: Use the keyboard shortcut %MOD1+%MOD2+Arrow (Up/Down)"), 
"", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Change the basic fonts for the predefined 
template or current document per Tools ▸ Options ▸ %PRODUCTNAME Writer ▸ Basic 
Fonts."), "modules/swriter/ui/optfonttabpage/OptFontTabPage", "", swriter}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/optionen/01040300.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to find words containing more than 10 
characters? Edit ▸ Find and Replace ▸ Search ▸ [a-z]{10,} ▸ Other Options ▸ 
check Regular expressions."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Open a CSV file as a new sheet in the 
current spreadsheet via Sheet ▸ Sheet from file."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can continue writing with the default 
formatting attributes after manually applying bold, italic or underline by 
pressing %MOD1+Shift+X."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use %MOD1+%MOD2+Shift+V to paste the 
contents of the clipboard as unformatted text."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Customize footnote appearance with Tools ▸ 
Footnotes and Endnotes…"), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "With Slide Show ▸ Custom Slide Show, 
reorder and pick slides to fit a slideshow to the needs of your viewers."), "", 
"", simpress},
+     { 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."), "", "", swriter},
+     { 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 %PRODUCTNAME Writer tab."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You do not want to print all columns? Hide 
or group the ones you do not need."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To modify an AutoPlay presentation, open it 
and after it starts, right click and select Edit in the context menu."), "", 
"", simpress},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to position precisely? %MOD2+arrow 
keys move objects (shapes, pictures, formulas) by one pixel."), "", "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Embedded help is available by pressing F1, 
if you have installed it. Otherwise check online at:"), 
"https://help.libreoffice.org";, "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Right-click in the status bar in 
%PRODUCTNAME Calc and select “Selection count” to display the number of 
selected cells."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to have two or more columns for just a 
part of a %PRODUCTNAME Writer page? Insert ▸ Section, set with Columns tab, and 
place text in that section."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Data ▸ Statistics for sampling, 
descriptive statistics, analysis of variance, correlation, and much more in 
%PRODUCTNAME Calc."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can copy from one sheet to another 
without the clipboard. Select the area to copy, %MOD1+click the target sheet’s 
tab and use Sheet ▸ Fill Cells ▸ Fill Sheets."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can change the look of %PRODUCTNAME via 
View ▸ User Interface."), "", "", soffice},
+     { 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."), "", "", simpress},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can show formulas instead of results 
with View ▸ Show Formula (or Tools ▸ Options ▸ %PRODUCTNAME Calc ▸ View ▸ 
Display ▸ Formulas)."), "", "", scalc},
+     { 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/";, "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Left-handed? Enable Tools ▸ Options ▸ 
Language Settings ▸ Languages ▸ Asian and check Tools ▸ Options ▸ %PRODUCTNAME 
Writer ▸ View ▸ Ruler ▸ Right-aligned, which displays the scrollbar to the 
left."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want headings to always begin a page? Edit 
the paragraph style applied to the headings. Check “Insert” on the “Text Flow” 
tab, with Type “Page” and Position “Before”."), 
"cui/ui/textflowpage/checkInsert", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Date/time value is just a number of days 
since a chosen day zero; in the number, integer part represents date, and 
fractional part is time (elapsed part of a day), with 0.5 representing noon."), 
"", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Shift+%MOD1+Del deletes from cursor to the 
end of the current sentence."), "", "", swriter},
+     { 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."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Annoyed by the “marching ants” around cells 
in Calc? Press escape to stop them; the copied content will remain available 
for pasting."), "", "marchingants.gif", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to become a %PRODUCTNAME Ambassador? 
There are certifications for developers, admins, and trainers."), 
"https://www.documentfoundation.org/certification/program/";, "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Mix portrait and landscape orientations in 
a Calc spreadsheet by applying different page styles on sheets."), "", "", 
scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Click on the special character icon in the 
toolbar to get quick access to favorite and recent characters to insert."), "", 
"", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Choose “Hierarchical View” in the Styles 
sidebar to see the relation between styles."), "", "", swriter},
+     { 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 Styles..."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to open hyperlinks without pressing 
the %MOD1 key? Uncheck “%MOD1+click required to open hyperlinks” in Tools ▸ 
Options ▸ %PRODUCTNAME ▸ Security ▸ Options ▸ Security Options."), 
"cui/ui/securityoptionsdialog/ctrlclick", "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You would like to view the calculation of 
individual elements of a formula, select the respective elements and press 
F9."), "", "", scalc},
+     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/guide/cell_protect.html";,
 "", scalc}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Write along a curve? Draw the curve, double 
click, type the text, Format ▸ Text Box and Shape ▸ Fontwork. Select one of the 
alignment options: Rotate, Upright, Slant Horizontal or Slant Vertical."), "", 
"", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to display only the highest values in 
a spreadsheet? Select menu Data ▸ AutoFilter, click the drop-down arrow, and 
choose “Top10”."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To remove the page number from your table 
of contents go to Insert ▸ Table of Contents and Index (or right-click and Edit 
Index to edit a previously inserted index). In the Entries tab delete the page 
number (#) from Structure line."), "", "", swriter},
+     { 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."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to get a math object into Writer 
quickly? Type your formula, select it, and use Insert ▸ OLE Object ▸ Formula to 
convert the text."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "With %PRODUCTNAME it is very easy to 
install a new dictionary: they are supplied as extensions."), 
"https://extensions.libreoffice.org/?q=&Tags[]=50";, "", soffice},
+     { 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."), 
"https://www.libreoffice.org/download/portable-versions/";, "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Writer lets you number your footnotes per 
page, chapter, document: Tools ▸ Footnotes and Endnotes ▸ Footnotes tab ▸ 
Counting."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Your Writer document does not reopen with 
the text cursor at the same editing position it was when you saved it? Add 
First or Last name in Tools ▸ Options ▸ %PRODUCTNAME ▸ User Data ▸ First/last 
name."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to do citation? You can use 
third-party citation managers such as Zotero."), 
"https://wiki.documentfoundation.org/Referencing_Systems_in_LibreOffice";, "", 
swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to insert a value in the same place on 
several sheets? Select the sheets: hold down %MOD1 key and click their tabs 
before entering."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to hide some text in a document? 
Select the text. Insert ▸ Section, and select “Hide”."), 
"modules/swriter/ui/editsectiondialog/hide", "", swriter},  // online help is 
different 
https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/hidden_text.html#hd_id3148675
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can customize the middle mouse button 
by going to Tools ▸ Options ▸ %PRODUCTNAME ▸ View ▸ Mouse ▸ Middle button."), 
"", "", soffice},
+     { 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”."), "", "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "For quick access to your document 
bookmarks, right-click on the page number of the status bar (lower-left corner 
of document window)."), "", "", swriter},
+     { 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."), 
"", "", sdraw},
+     { 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", "", 
swriter}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/autotext.html
+     { 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."), "", "", simpress},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME Calc does not calculate from 
left to right but respects the order Parentheses – Exponents – Multiplication – 
Division – Addition – Subtraction."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Get %PRODUCTNAME documentation and free 
user guide books at:"), "https://documentation.libreoffice.org/";, "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to remove all <> at once and keep the 
text inside? Edit ▸ Find and Replace: Search = [<>], Replace = blank and check 
“Regular expressions” under Other options."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/01/02100001.html";,
 "", soffice}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to present a report written with 
Writer? File ▸ Send ▸ Outline to Presentation automatically creates a slideshow 
from the outline."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to manage the presentation of 
hyperlinks in a spreadsheet? Insert them with the HYPERLINK function."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060109.html";,
 "", scalc}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Tools ▸ Options ▸ %PRODUCTNAME Calc 
▸ View ▸ Zoom: “Synchronize sheets” so that each sheet in Calc has its own zoom 
factor."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can set a color for each tab: 
right-click the tab or use Sheet ▸ Sheet Tab Color."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Trace cells used in a formula, precedents 
(Shift+F9) or dependents (Shift+F5) (or use Tools ▸ Detective). For each hit 
you go one more step in the chain."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/06030000.html";,
 "", scalc}, //local help missing
+     { 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."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can create an illustration index from 
object names, not only from captions."), 
"cui/ui/objectnamedialog/ObjectNameDialog", "", swriter}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/01/05190000.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use your Android or iPhone to remotely 
control your Impress presentation."), 
"https://help.libreoffice.org/%PRODUCTVERSION/he/text/simpress/guide/impress_remote.html";,
 "", simpress}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to know how many days there are in the 
current month? Use the DAYSINMONTH(TODAY()) function."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Your numbers are displayed as ### in your 
spreadsheet? The column is too narrow to display all digits."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Enable massive parallel calculations of 
formula cells via Tools ▸ Options ▸ %PRODUCTNAME ▸ OpenCL."), 
"cui/ui/optopenclpage/OptOpenCLPage", "", scalc}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/optionen/opencl.html
+     { 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."), "", "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Your donations support our worldwide 
community."), "https://www.libreoffice.org/donate/";, "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You want to add x months to a date? Use 
=EDATE(date;months)."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/func_edate.html";,
 "", scalc}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "To select a contiguous range of cells 
containing data and bounded by empty row and columns use %MOD1+* (numeric key 
pad)."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Your date acceptance pattern is 
inappropriate? Use Tools ▸ Options ▸ Language Settings ▸ Languages ▸ Date 
acceptance patterns to tweak the pattern."), "", "", soffice},
+     { 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."), "", "", scalc},
+     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/simpress/guide/presenter_console.html";,
 "", simpress}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "To delete multiple comments, select cells 
with comments and use Sheet ▸ Cell Comments ▸ Delete Comment."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Easily convert your documents to PDF with 
one click by clicking on the PDF icon in the toolbar."), "", "", soffice},
+     { 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."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to know the valid command line 
parameters? Start soffice with --help or -h or -?"), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/guide/start_parameters.html";,
 "", soffice}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Fit your sheet or print ranges to a page 
with Format ▸ Page ▸ Sheet Tab ▸ Scaling Mode."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to include a list item without a 
bullet or number? Use “Insert Unnumbered Entry” in the Bullets and Numbering 
toolbar."), "HID_NUM_TOOLBOX", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can rotate cells table orientation with 
Table ▸ Properties… ▸ Text Flow ▸ Text orientation."), "", "", swriter},
+     { 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."), "", "", sdraw},
+     { 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 %MOD2 key."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Automatically mark alphabetical index 
entries using a concordance file."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/indices_index.html";,
 "", swriter}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Format ▸ Align Objects in Impress or 
Shape ▸ Align Objects in Draw (or the context menu) for precise positioning of 
objects: it centers on the page if one object is selected or works on the group 
respectively."), "", "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Do not 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."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "No need to scroll through the list at Tools 
▸ Customize ▸ Keyboard to find a shortcut: just type it."), "", "", soffice},
+     { 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", 
"", swriter}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/optionen/01041100.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "With %PRODUCTNAME you can use your Google 
Mail account to do a mail merge. Fill in Tools ▸ Options ▸ %PRODUCTNAME Writer 
▸ Mail Merge Email."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/form_letters_main.html";,
 "", swriter}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Keep column headers of a sheet visible when 
scrolling lines via View ▸ Freeze Cells ▸ Freeze First Row."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You want to start working with Basic 
macros? Take a look at the examples under Tools ▸ Macros ▸ Edit Macros."), "", 
"", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Apply Heading paragraph styles in Writer 
with shortcut keys: %MOD1+1 applies Heading 1, %MOD1+2 applies Heading 2, 
etc."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Do not get lost in large documents. Use the 
Navigator (F5) to find your way through the content."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Edit ▸ Find and Replace lets you insert 
special characters directly: right click in input fields or press 
Shift+%MOD1+S."), "", "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need custom contents for metadata 
properties? File ▸ Properties ▸ Custom Properties tab lets you create what you 
want."), "", "", soffice},
+     { 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 
the layer’s tab and choose “Modify Layer”)."), "", "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To insert the current date in your 
document, use Insert ▸ Field ▸ Date."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Got many images in your Writer document? 
Speed up the display by disabling View ▸ Images and charts."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Sheet ▸ Fill Cells ▸ Random Number to 
generate a random series based on various distributions."), 
"modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog", "", 
scalc}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/02140700.html
+     { 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…"), "", "", simpress},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to display text before a heading 
number? Open the Numbering tab of the “Heading Numbering” dialog and enter the 
desired text in “Before”. For example, type “Chapter ” to display “Chapter 
1”."), "modules/swriter/ui/outlinenumberingpage/prefix", "", swriter},
+     { 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."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To get the “Vertical Text” tool in the 
Drawing toolbar, check Tools ▸ Options ▸ Language Settings ▸ Languages ▸ 
Default languages for Documents ▸ Asian (and make the button visible with 
right-click and then Visible Buttons ▸ Vertical Text)."), "", "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To quickly zoom in on range selection, 
right click on the zoom part of the status bar and choose Optimal."), "", "", 
scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can sign existing PDF files and also 
verify those signatures."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/guide/digital_signatures.html";,
 "", soffice}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Often create one document from another? 
Consider using a template."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Format ▸ Conditional Formatting ▸ 
Manage in Calc to find out which cells have been defined with conditional 
formatting."), 
"modules/scalc/ui/conditionalformatdialog/ConditionalFormatDialog", "", scalc}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/05120000.html
+     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/06030800.html";,
 "", scalc}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use font embedding for greater 
interoperability with other office suites at File ▸ Properties ▸ Font."), "", 
"", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To convert a formula into static values you 
do not need to copy/paste; use Data ▸ Calculate ▸ Formula to Value."), "", "", 
scalc},
+     { 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”."), 
"", "", swriter},
+     { 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."), 
"", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "When you have created a Style based on 
another, you can enter a percentage value or a point value (e.g. 110% or −2pt 
or +5pt)."), "", "", swriter},
+     { 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."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Batch-convert your Microsoft Office 
documents to the OpenDocument format by using the Document Converter wizard in 
menu File ▸ Wizards ▸ Document Converter."), "", "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "When editing a cell in place, you can right 
click and Insert fields: Date, Sheet name, Document title, etc."), "", "", 
scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to move a Writer table? Table ▸ Select 
▸ Table and Insert ▸ Frame ▸ Frame and move where you want."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "With Tools ▸ AutoText ▸ AutoText ▸ Import 
you can select a Word document or a template containing the AutoText entries 
that you want to import."), "", "", swriter},
+     { 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."), "", "", swriter},
+     { 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."), "", "", soffice},
+     { 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."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Delete all of your printing areas in one 
step: select all sheets, then Format ▸ Print Ranges ▸ Clear."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Add background images to spreadsheets via 
Insert ▸ Image or drag a background from the Gallery, then Format ▸ Arrange ▸ 
To Background."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Having trouble pasting text from PDF files 
or webpages into documents? Try to paste as unformatted text 
(%MOD1+%MOD2+Shift+V)."), "", "", swriter},
+     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060182.html?DbPAR=CALC#bm_id3152966";,
 "", scalc}, //local help missing
+     { 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."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Toolbars are contextual—they open depending 
on the context. If you do not want that, uncheck them from View ▸ Toolbars."), 
"", "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can create a master document from the 
current Writer document by using File ▸ Send ▸ Create Master Document."), 
"SW_HID_SEND_MASTER_CTRL_PUSHBUTTON_CANCEL", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to center cells on a printed page in 
Calc? Format ▸ Page, Page ▸ Layout settings ▸ Table alignment."), "", "", 
scalc},
+     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/text_frame.html";,
 "", swriter}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can create a chart based on a Writer 
table by clicking in the table and choosing Insert ▸ Chart."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Select options in Tools ▸ Options ▸ 
%PRODUCTNAME Writer ▸ Formatting Aids ▸ Display Formatting to specify which 
non-printing characters are displayed."), "", "", swriter},
+     { 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 
%MOD1+G."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME supports over 150 
languages."), 
"https://wiki.documentfoundation.org/Language_support_of_LibreOffice";, "", 
soffice},
+     { 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."), "", "", simpress},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to find the words in bold in a Writer 
document? Edit ▸ Find and Replace ▸ Other options ▸ Attributes ▸ Font 
weight."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/finding.html";,
 "", swriter}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can sort paragraphs or table rows 
alphabetically or numerically per Tools ▸ Sort."), 
"modules/swriter/ui/sortdialog/SortDialog", "", swriter}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/01/06100000.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "To insert a paragraph before (after) a 
section, press %MOD2+Enter at the beginning (end) of the section."), "", "", 
swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has a template center to 
create good looking documents—check it out."), 
"https://extensions.libreoffice.org/?q=&Tags[]=118";, "", soffice},
+     { 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/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060119.html?DbPAR=CALC#bm_id3149577";,
 "", scalc}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Cannot find what you want with the VLOOKUP 
function in Calc? With INDEX and MATCH you can do anything!"), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060109.html";,
 "", scalc}, //local help missing
+     { 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."), "", "", scalc},
+     { 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."), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Run %PRODUCTNAME in any browser via 
rollApp."), "https://www.rollapp.com/app/lowriter";, "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Strange error code in Calc, Err: followed 
by a number? This page gives the explanation:"), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/05/02140000.html";,
 "", scalc}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Include a paragraph that is not a heading 
in the “Table of Contents” by giving a numerical outline level to the paragraph 
in the “Outline & List” tab in the paragraph settings."), 
"modules/swriter/ui/numparapage/comboLB_OUTLINE_LEVEL", "", swriter},
+     { 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", "", 
swriter}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/indices_toc.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Unable to modify or delete a custom cell 
style? Check all sheets, none should be protected."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "You need to fill a series? Select the cell 
range and Sheet ▸ Fill Cells ▸ Fill Series and choose between Linear, Growth, 
Date and AutoFill."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/guide/calc_series.html";,
 "", scalc}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to know if a cell is referred in 
formulas of other cells? Tools ▸ Detective ▸ Trace Dependents (Shift+F5)."), 
"", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "In the replace input field of auto correct 
options you can use the wildcards .*"), "", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Want to duplicate the above line? Press 
%MOD1+D or use Sheet ▸ Fill Cells ▸ Fill Down."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To search in several spreadsheets, select 
them before you start the search."), "", "", scalc},
+     { 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."), "", "", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME helps you not to enter two or 
more spaces in Writer. Check Tools ▸ AutoCorrect ▸ AutoCorrect Options ▸ 
Options ▸ Ignore double spaces."), "", "", swriter},
+     { 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."), "", 
"", scalc},
+     { NC_("RID_CUI_TIPOFTHEDAY", "To display the scrollbar to the left, 
enable Tools ▸ Options ▸ Language Settings ▸ Languages ▸ Complex text and right 
click a sheet in Sheet tabs above Status bar ▸ Right-To-Left."), "", "", scalc},
+     { 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."), 
"", "", swriter},
+     { NC_("RID_CUI_TIPOFTHEDAY", "New versions of %PRODUCTNAME provide new 
features, bug fixes, and security patches. Keep your software updated!"), 
"SFX2_HID_DLG_CHECKFORONLINEUPDATE", "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Developing new XSLT and XML filters?"), 
"https://fridrich.blogspot.com/2013/08/extending-swiss-army-knife-overview.html";,
 "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Press Shift+F1 to see any available 
extended tooltips in dialog boxes, when \"Extended tips\" is not enabled in 
Tools ▸ Options ▸ %PRODUCTNAME ▸ General."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/05/00000120.html";,
 "", soffice},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Never use certain arrow styles? Remove them 
by using the Delete button on the Format ▸ Text Box and Shape ▸ Line ▸ Arrow 
Styles tab."), "cui/ui/lineendstabpage/BTN_MODIFY", "", sdraw},
+     { NC_("RID_CUI_TIPOFTHEDAY", "Don’t like the position of some icons on 
your toolbar? Change it with Tools ▸ Customize ▸ Toolbars tab ▸ Target."), 
"CUI_HID_SVX_CONFIG_TOOLBAR", "", soffice},
 };
 
 #define STR_HELP_LINK                   NC_("STR_HELP_LINK", "%PRODUCTNAME 
Help")
diff --git a/cui/source/dialogs/tipofthedaydlg.cxx 
b/cui/source/dialogs/tipofthedaydlg.cxx
index 6cfc02f90d13..f1cb7afc2c1f 100644
--- a/cui/source/dialogs/tipofthedaydlg.cxx
+++ b/cui/source/dialogs/tipofthedaydlg.cxx
@@ -26,6 +26,7 @@
 #include <vcl/graphicfilter.hxx>
 #include <vcl/help.hxx>
 #include <vcl/window.hxx>
+#include <vcl/ImageTree.hxx>
 
 #include <com/sun/star/frame/XDispatch.hpp>
 #include <com/sun/star/frame/XDispatchProvider.hpp>
@@ -42,6 +43,7 @@
 #include <unotools/resmgr.hxx>
 #include <unotools/configmgr.hxx>
 #include <com/sun/star/beans/PropertyValue.hpp>
+#include <bitmaps.hlst>
 
 //size of preview
 const Size ThumbSize(150, 150);
@@ -135,7 +137,7 @@ void TipOfTheDayDialog::UpdateTip()
                              .replaceFirst("%CURRENT", 
OUString::number(m_nCurrentTip + 1))
                              .replaceFirst("%TOTAL", 
OUString::number(nNumberOfTips)));
 
-    auto[sTip, sLink, sImage] = TIPOFTHEDAY_STRINGARRAY[m_nCurrentTip];
+    auto[sTip, sLink, sImage, nType] = TIPOFTHEDAY_STRINGARRAY[m_nCurrentTip];
 
     // text
 //replace MOD1 & MOD2 shortcuts depending on platform
@@ -214,11 +216,22 @@ void TipOfTheDayDialog::UpdateTip()
     OUString aURL("$BRAND_BASE_DIR/$BRAND_SHARE_SUBDIR/tipoftheday/");
     rtl::Bootstrap::expandMacros(aURL);
     OUString aImageName = sImage;
-    // use default image if none is available with the number
-    if (aImageName.isEmpty() || !file_exists(aURL + aImageName))
-        aImageName = "tipoftheday.png";
     Graphic aGraphic;
-    GraphicFilter::LoadGraphic(aURL + aImageName, OUString(), aGraphic);
+
+    if (!aImageName.isEmpty() && file_exists(aURL + aImageName))
+        GraphicFilter::LoadGraphic(aURL + aImageName, OUString(), aGraphic);
+    else
+    {
+        const OUString sModuleImage[5]
+            = { RID_SVXBMP_TOTD_WRITER, RID_SVXBMP_TOTD_CALC, 
RID_SVXBMP_TOTD_DRAW,
+                RID_SVXBMP_TOTD_IMPRESS, RID_SVXBMP_TOTD_SOFFICE };
+        const OUString aIconTheme
+            = 
Application::GetSettings().GetStyleSettings().DetermineIconTheme();
+        BitmapEx aBmpEx;
+        ImageTree::get().loadImage(sModuleImage[nType], aIconTheme, aBmpEx, 
true,
+                                   ImageLoadFlags::IgnoreDarkTheme);
+        aGraphic = aBmpEx;
+    }
 
     if (!aGraphic.IsAnimated())
     {
diff --git a/extras/source/tipoftheday/tipoftheday.svg 
b/extras/source/tipoftheday/tipoftheday.svg
deleted file mode 100644
index d768ee0b5a08..000000000000
--- a/extras/source/tipoftheday/tipoftheday.svg
+++ /dev/null
@@ -1 +0,0 @@

... etc. - the rest is truncated

[Libreoffice-commits] core.git: cui/inc cui/source extras/source icon-themes/colibre vcl/Package_tipoftheday.mk

Reply via email to