cui/inc/tipoftheday.hrc               |   80 +++++++++++++++++-----------------
 cui/source/dialogs/tipofthedaydlg.cxx |   16 +++++-
 2 files changed, 54 insertions(+), 42 deletions(-)

New commits:
commit 78c6b79f2a05eb92f41037fd20c6579a0a644c47
Author:     Heiko Tietze <[email protected]>
AuthorDate: Wed Sep 25 17:31:00 2019 +0200
Commit:     Heiko Tietze <[email protected]>
CommitDate: Tue Oct 1 10:56:36 2019 +0200

    Resolves tdf#127756 - Tip of the day not localized
    
    Introduced %LANGUAGENAME token being replaced with
    BCP47 for pt, en, zh or ISO otherwise
    
    Change-Id: Iaa7168731e0f6a8e0dd1e906ff0ef646534d9f4b
    Reviewed-on: https://gerrit.libreoffice.org/79564
    Tested-by: Jenkins
    Reviewed-by: Heiko Tietze <[email protected]>

diff --git a/cui/inc/tipoftheday.hrc b/cui/inc/tipoftheday.hrc
index 8977f718f945..b0e8b11f23a2 100644
--- a/cui/inc/tipoftheday.hrc
+++ b/cui/inc/tipoftheday.hrc
@@ -43,48 +43,48 @@
 
 const std::tuple<const char*, OUString, OUString> TIPOFTHEDAY_STRINGARRAY[] =
 {
-     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME can open and save files stored 
on remote servers per CMIS."), "fps/ui/remotefilesdialog/RemoteFilesDialog", 
""}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/guide/cmis-remote-files.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Tools > AutoCorrect > AutoCorrect Options… 
> Replace provides a list of common substitutions. Take a look and complete 
with your own replacements."), "cui/ui/acoroptionspage/AutocorrectOptionsPage", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/01/06040100.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Writer can handle styles conditionally: 
paragraph styles that have different properties depending on the context."), 
"modules/swriter/ui/conditionpage/ConditionPage", "tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/01/05130100.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "With File > Versions you can store multiple 
versions of the document in the same file. You can also open, delete, and 
compare previous versions."), "sfx/ui/versionsofdialog/VersionsOfDialog", ""}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/01/01190000.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can create an illustration index from 
object names, not only from captions."), 
"cui/ui/objectnamedialog/ObjectNameDialog", "tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/01/05190000.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "To temporarily start with a fresh user 
profile, or to restore a non-working %PRODUCTNAME instance, go to Help > 
Restart in Safe Mode."), "svx/ui/safemodedialog/SafeModeDialog", ""}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/01/profile_safe_mode.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Change the basic fonts for the predefined 
template or current document per Tools > Options > %PRODUCTNAME Writer > Basic 
Fonts."), "modules/swriter/ui/optfonttabpage/OptFontTabPage", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/optionen/01040300.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Define texts that you often use as 
AutoText. You will be able to insert them by their name, shortcut or toolbar in 
any Writer document."), "modules/swriter/ui/autotext/AutoTextDialog", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/guide/autotext.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME can automatically add a 
numbered caption when you insert objects. See Tools > Options > %PRODUCTNAME 
Writer > AutoCaption."), "modules/swriter/ui/optcaptionpage/OptCaptionPage", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/optionen/01041100.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can sort paragraphs or table rows 
alphabetically or numerically per Tools > Sort."), 
"modules/swriter/ui/sortdialog/SortDialog", "tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/01/06100000.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Sections in %PRODUCTNAME Writer to 
protect part of a text, show/hide text, reuse parts from other documents, use 
different column layout."), "modules/swriter/ui/sectionpage/SectionPage", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/01/04020100.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use Sheet > Fill Cells > Random Number to 
generate a random series based on various distributions."), 
"modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog", 
"tipoftheday_c.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/01/02140700.html
-     { 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/en-US/text/scalc/01/05120000.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Apart from table of contents, %PRODUCTNAME 
can create Alphabetical, Illustrations, Tables, Objects, Bibliography, 
User-Defined indexes."), "modules/swriter/ui/tocdialog/TocDialog", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/guide/indices_toc.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to sort a series in %PRODUCTNAME Calc 
such as A1, A2, A3, A11, A15, not in alphabetical order but on the number? 
Enable natural sort in the Options tab."), 
"modules/scalc/ui/sortoptionspage/SortOptionsPage", "tipoftheday_c.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/01/12030200.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "Enable massive parallel calculations of 
formula cells via Tools > Options > OpenCL."), 
"cui/ui/optopenclpage/OptOpenCLPage", "tipoftheday_c.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/optionen/opencl.html
-     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME supports four macro security 
levels (from low to very high) and trusted sources."), 
"cui/ui/optsecuritypage/OptSecurityPage", ""}, // 
https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/optionen/01030300.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME can open and save files stored 
on remote servers per CMIS."), "fps/ui/remotefilesdialog/RemoteFilesDialog", 
""}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/guide/cmis-remote-files.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Tools > AutoCorrect > AutoCorrect Options… 
> Replace provides a list of common substitutions. Take a look and complete 
with your own replacements."), "cui/ui/acoroptionspage/AutocorrectOptionsPage", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/01/06040100.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Writer can handle styles conditionally: 
paragraph styles that have different properties depending on the context."), 
"modules/swriter/ui/conditionpage/ConditionPage", "tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/01/05130100.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "With File > Versions you can store multiple 
versions of the document in the same file. You can also open, delete, and 
compare previous versions."), "sfx/ui/versionsofdialog/VersionsOfDialog", ""}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/01/01190000.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can create an illustration index from 
object names, not only from captions."), 
"cui/ui/objectnamedialog/ObjectNameDialog", "tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/01/05190000.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "To temporarily start with a fresh user 
profile, or to restore a non-working %PRODUCTNAME instance, go to 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", "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", "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", "%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", "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", "Use Sections in %PRODUCTNAME Writer to 
protect part of a text, show/hide text, reuse parts from other documents, use 
different column layout."), "modules/swriter/ui/sectionpage/SectionPage", 
"tipoftheday_w.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/01/04020100.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "Use Sheet > Fill Cells > Random Number to 
generate a random series based on various distributions."), 
"modules/scalc/ui/randomnumbergenerator/RandomNumberGeneratorDialog", 
"tipoftheday_c.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/02140700.html
+     { 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", "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", "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", "Enable massive parallel calculations of 
formula cells via Tools > Options > OpenCL."), 
"cui/ui/optopenclpage/OptOpenCLPage", "tipoftheday_c.png"}, 
//https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/optionen/opencl.html
+     { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME supports four macro security 
levels (from low to very high) and trusted sources."), 
"cui/ui/optsecuritypage/OptSecurityPage", ""}, // 
https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/optionen/01030300.html
 
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to know the valid command line 
parameters? Start soffice with --help or -h or -?"), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/guide/start_parameters.html";,
 ""}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to manage the presentation of 
hyperlinks in a spreadsheet? Insert them with the HYPERLINK function."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/01/04060109.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Can not get what you want with VLOOKUP? 
With INDEX and MATCH you can do everything!"), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/01/04060109.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can sign existing PDF files and also 
verify those signatures."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/guide/digital_signatures.html";,
 ""}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Writer includes LibreLogo: simple Logo-like 
programming environment with turtle vector graphics, DTP and graphic design."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/librelogo/LibreLogo.html";,
 "tipoftheday_w.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "You can protect cells with Format > Cells > 
Protection. To prevent insert, delete, rename, move/copy of sheets use Tools > 
Protect Sheet."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/guide/cell_protect.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "You want to add x months to a date? Use 
=EDATE(date;months)."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/01/func_edate.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Trace cells used in a formula, precedents 
(Shift+F9) or dependants (Shift+F5) (or use Tools > Detective). For each hit 
you go one more step in the chain."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/01/06030000.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "You need to fill a serie? Select the cell 
range and Sheet > Fill Cells > Fill Series and choose between Linear, Growth, 
Date and AutoFill."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/guide/calc_series.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "With %PRODUCTNAME you can use your Google 
Mail account to do a mail merge. Fill in Tools > Options > %PRODUCTNAME Writer 
> Mail Merge Email."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/guide/form_letters_main.html";,
 "tipoftheday_w.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Data > Validity allows you to create 
drop-down lists where the user selects a value instead of typing."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/guide/validity.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Use View > Value Highlighting to display 
cell contents in colors: Text/black, Formulas/green, Numbers/blue, Protected 
cells/grey background."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/01/03080000.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Strange error code in Calc, Err: followed 
by a number? This page gives the explanation:"), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/05/02140000.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to find the words in bold in a Writer 
document? Edit > Find & Replace > Other options > Attributes > Font weight."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/guide/finding.html";,
 "tipoftheday_w.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Want to remove all <> at once and keep the 
text inside? Edit > Find & Replace:  Search = [<|>], Replace = blank and check 
‘Regular expressions’ under Other options."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/shared/01/02100001.html";,
 ""}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Tools > Detective > Mark Invalid Data 
highlights all cells in the sheet that contain values outside the validation 
rules."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/01/06030800.html";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Need to allow changes to parts of a 
read-only document in Writer? Insert frames or sections that can authorize 
changes."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/guide/section_edit.html";,
 "tipoftheday_w.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Writing a book? %PRODUCTNAME master 
document lets you manage large documents as a container for individual 
%PRODUCTNAME Writer files."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/guide/globaldoc.html";,
 "tipoftheday_w.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "In Calc use TRIMMEAN() to return the mean 
of a data set excluding the highest and lowest values."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/01/04060182.html?DbPAR=CALC#bm_id3152966";,
 "tipoftheday_c.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Calculate loan repayments with Calc: eg. 
PMT(2%/12;36;2500) interest rate per payment period 2%/12, 36 months, loan 
amount 2500."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/scalc/01/04060119.html?DbPAR=CALC#bm_id3149577";,
 "tipoftheday_c.png"}, //local help missing
+     { 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", "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", "Can not get what you want with VLOOKUP? 
With INDEX and MATCH you can do everything!"), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060109.html";,
 "tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can sign existing PDF files and also 
verify those signatures."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/guide/digital_signatures.html";,
 ""}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Writer includes LibreLogo: simple Logo-like 
programming environment with turtle vector graphics, DTP and graphic design."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/librelogo/LibreLogo.html";,
 "tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You can protect cells with Format > Cells > 
Protection. To prevent insert, delete, rename, move/copy of sheets use Tools > 
Protect Sheet."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/guide/cell_protect.html";,
 "tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You want to add x months to a date? Use 
=EDATE(date;months)."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/func_edate.html";,
 "tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Trace cells used in a formula, precedents 
(Shift+F9) or dependants (Shift+F5) (or use Tools > Detective). For each hit 
you go one more step in the chain."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/06030000.html";,
 "tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "You need to fill a serie? Select the cell 
range and Sheet > Fill Cells > Fill Series and choose between Linear, Growth, 
Date and AutoFill."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/guide/calc_series.html";,
 "tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "With %PRODUCTNAME you can use your Google 
Mail account to do a mail merge. Fill in Tools > Options > %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", "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", "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", "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", "Want to find the words in bold in a Writer 
document? Edit > Find & 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", "Want to remove all <> at once and keep the 
text inside? Edit > Find & Replace:  Search = [<|>], Replace = blank and check 
‘Regular expressions’ under Other options."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/shared/01/02100001.html";,
 ""}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Tools > Detective > Mark Invalid Data 
highlights all cells in the sheet that contain values outside the validation 
rules."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/06030800.html";,
 "tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Need to allow changes to parts of a 
read-only document in Writer? Insert frames or sections that can authorize 
changes."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/section_edit.html";,
 "tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Writing a book? %PRODUCTNAME master 
document lets you manage large documents as a container for individual 
%PRODUCTNAME Writer files."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/globaldoc.html";,
 "tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "In Calc use TRIMMEAN() to return the mean 
of a data set excluding the highest and lowest values."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060182.html?DbPAR=CALC#bm_id3152966";,
 "tipoftheday_c.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Calculate loan repayments with Calc: eg. 
PMT(2%/12;36;2500) interest rate per payment period 2%/12, 36 months, loan 
amount 2500."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/01/04060119.html?DbPAR=CALC#bm_id3149577";,
 "tipoftheday_c.png"}, //local help missing
      { NC_("RID_CUI_TIPOFTHEDAY", "Use your Android or iPhone to remotely 
control your Impress presentation."), 
"https://help.libreoffice.org/%PRODUCTVERSION/he/text/simpress/guide/impress_remote.html";,
 "tipoftheday_i.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "The presenter console is a great feature 
when working with %PRODUCTNAME Impress. Have you checked it out?"), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/simpress/guide/presenter_console.html";,
 "tipoftheday_i.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Automatically mark alphabetical index 
entries using a concordance file."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/guide/indices_index.html";,
 "tipoftheday_w.png"}, //local help missing
-     { NC_("RID_CUI_TIPOFTHEDAY", "Frames can be linked so that the text can 
flow from one to the other as in desktop publishing."), 
"https://help.libreoffice.org/%PRODUCTVERSION/en-US/text/swriter/guide/text_frame.html";,
 "tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "The presenter console is a great feature 
when working with %PRODUCTNAME Impress. Have you checked it out?"), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/simpress/guide/presenter_console.html";,
 "tipoftheday_i.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Automatically mark alphabetical index 
entries using a concordance file."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/indices_index.html";,
 "tipoftheday_w.png"}, //local help missing
+     { NC_("RID_CUI_TIPOFTHEDAY", "Frames can be linked so that the text can 
flow from one to the other as in desktop publishing."), 
"https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/swriter/guide/text_frame.html";,
 "tipoftheday_w.png"}, //local help missing
 
      { NC_("RID_CUI_TIPOFTHEDAY", "Get help from the community via the Ask 
portal."), "https://ask.libreoffice.org";, ""},
      { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has great extensions to 
increase your productivity - check them out."), 
"https://extensions.libreoffice.org";, ""},
diff --git a/cui/source/dialogs/tipofthedaydlg.cxx 
b/cui/source/dialogs/tipofthedaydlg.cxx
index 55e9b51b9003..9d6630d7e5a7 100644
--- a/cui/source/dialogs/tipofthedaydlg.cxx
+++ b/cui/source/dialogs/tipofthedaydlg.cxx
@@ -28,6 +28,8 @@
 #include <vcl/help.hxx>
 #include <vcl/virdev.hxx>
 #include <vcl/svapp.hxx>
+#include <i18nlangtag/languagetag.hxx>
+#include <unotools/configmgr.hxx>
 
 TipOfTheDayDialog::TipOfTheDayDialog(weld::Window* pParent)
     : GenericDialogController(pParent, "cui/ui/tipofthedaydialog.ui", 
"TipOfTheDayDialog")
@@ -86,7 +88,18 @@ void TipOfTheDayDialog::UpdateTip()
     }
     else if (aLink.startsWith("http"))
     {
-        m_pLink->set_uri(CuiResId(aLink.toUtf8().getStr()));
+        aText = CuiResId(aLink.toUtf8().getStr());
+
+        sal_Int32 aPos = aText.indexOf("%LANGUAGENAME");
+        if (aPos != -1)
+        {
+            OUString aLang = 
LanguageTag(utl::ConfigManager::getUILocale()).getLanguage();
+            if (aLang == "en" || aLang == "pt" || aLang == "zh") //en-US/GB, 
pt-BR, zh-CH/TW
+                aLang = 
LanguageTag(utl::ConfigManager::getUILocale()).getBcp47();
+            aText = aText.replaceAt(aPos, 13, aLang);
+        }
+
+        m_pLink->set_uri(aText);
         m_pLink->set_label(CuiResId(STR_MORE_LINK));
         m_pLink->set_visible(true);
         m_pLink->connect_clicked(Link<weld::LinkButton&, void>());
@@ -99,7 +112,6 @@ void TipOfTheDayDialog::UpdateTip()
         //converts aLink into the proper offline/online hyperlink
         m_pLink->connect_clicked(LINK(this, TipOfTheDayDialog, OnLinkClick));
     }
-
     // image
     OUString aURL("$BRAND_BASE_DIR/$BRAND_SHARE_SUBDIR/tipoftheday/");
     rtl::Bootstrap::expandMacros(aURL);
_______________________________________________
Libreoffice-commits mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits

Reply via email to