cui/inc/tipoftheday.hrc | 377 +++++++++++++++++++++++------------------------- 1 file changed, 185 insertions(+), 192 deletions(-)
New commits: commit 7fef6c0fed10a3457f520689fa129926636c3103 Author: Heiko Tietze <[email protected]> AuthorDate: Mon Oct 7 13:06:09 2019 +0200 Commit: Heiko Tietze <[email protected]> CommitDate: Tue Oct 8 10:57:59 2019 +0200 Tip of the day randomized Necessary because of serial presentation after I69b72b80d6d6afa25a1c4f01fa05bc60b5741db8 Change-Id: I26d2a08442b91c11ec7d9c4addaaad764e7f3ba9 Reviewed-on: https://gerrit.libreoffice.org/80371 Tested-by: Jenkins Reviewed-by: Heiko Tietze <[email protected]> diff --git a/cui/inc/tipoftheday.hrc b/cui/inc/tipoftheday.hrc index b0e8b11f23a2..def9fa36100b 100644 --- a/cui/inc/tipoftheday.hrc +++ b/cui/inc/tipoftheday.hrc @@ -43,222 +43,215 @@ 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/%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/%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", "To print the notes of your slides go to File > Print > Impress tab and select Notes under Document > Type."), "", "tipoftheday_i.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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", "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/%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";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has a template center to create good looking documents - check it out."), "http://templates.libreoffice.org/template-center";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Embedded help is available by pressing F1, if you've installed it. Otherwise check online at:"), "https://help.libreoffice.org";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Get %PRODUCTNAME documentation and free user guide books at:"), "http://www.libreoffice.org/get-help/documentation";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Your donations support our worldwide community."), "https://www.libreoffice.org/donate/";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "With %PRODUCTNAME it is very easy to install a new dictionary: they are supplied as extensions."), "https://extensions.libreoffice.org/extensions?getCategories=Dictionary";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME is developed by a friendly community, made up of hundreds of contributors around the world. Join us with your skills beyond coding."), "https://www.libreoffice.org/community/get-involved/";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has a portable version which gives you mobility. Even without administrator rights on your computer you can install %PRODUCTNAME Portable to your hard drive too."), "http://www.libreoffice.org/download/portable-versions/";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME allows you to use assistive tools, such as external screen readers, Braille devices or speech recognition input devices."), "https://www.libreoffice.org/get-help/accessibility/";, ""}, { NC_("RID_CUI_TIPOFTHEDAY", "Create editable Hybrid PDFs with %PRODUCTNAME."), "https://wiki.documentfoundation.org/Documentation/HowTo/CreateAHybridPDF";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Citation management? Use a 3rd party extension."), "https://wiki.documentfoundation.org/Referencing_Systems_in_LibreOffice";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Do you plan to change your computer and want to recover your customizations? See:"), "https://wiki.documentfoundation.org/UserProfile";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME supports over 150 languages."), "https://wiki.documentfoundation.org/Language_support_of_LibreOffice";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to become a %PRODUCTNAME Ambassador? There are certifications for developers, admins, and trainers."), "http://www.documentfoundation.org/certification";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME intends to apply as an organization for Google Summer of Code (GSoC) see:"), "https://wiki.documentfoundation.org/Development/GSoC";, ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to sum a cell through several sheets? Refer to the range of sheets e.g. =SUM(Sheet1.A1:Sheet3.A1)."), "", "tipoftheday_c.png"}, { NC_("RID_CUI_TIPOFTHEDAY", "Create fillable form documents (even PDF's) with %PRODUCTNAME."), "https://www.techrepublic.com/article/how-to-create-interactive-pdfs-with-libreoffice";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Run %PRODUCTNAME in any browser via rollApp."), "https://www.rollapp.com/app/lowriter";, ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Developing new XSLT and XML filters?"), "http://fridrich.blogspot.com.tr/2013/08/extending-swiss-army-knife-overview.html";, ""}, - - { NC_("RID_CUI_TIPOFTHEDAY", "Easily convert your documents to PDF with one click by clicking on the PDF icon in the toolbar."), "", ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "Can't see all the text in a cell? Expand the input line in the formula bar and you can scroll."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "You can easily optimize your table per Table > Size > Distribute Rows / Columns Evenly."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Find all expressions in brackets per Edit > Find & Replace > Find > \\([^)]+\\) (check ‘Regular expressions’)"), "", "tipoftheday_w.png"}, { NC_("RID_CUI_TIPOFTHEDAY", "Select a different icon set from Tools > Options > %PRODUCTNAME > View > User Interface > Icon style."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Use font embedding for greater interoperability with other office suites at File > Properties > Font."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Generate fully customized PDF documents with the exact format, image compression, comments, access rights, password, etc., via File > Export as PDF."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Use Data > Statistics for sampling, descriptive statistics, analysis of variance, correlation, and much more in %PRODUCTNAME Calc."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Right-click in the status bar in %PRODUCTNAME Calc and select 'Selection count' to display the number of selected cells."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "In %PRODUCTNAME Impress, use Insert > Media > Photo Album to create a slideshow from a series of pictures with the 'Photo Album' feature."), "", "tipoftheday_i.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Did you know that you can attach comments to portions of text? Just use the shortcut Ctrl+Alt+C."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Need to insert the date in a spreadsheet cell? Type Ctrl+; or Shift+Ctrl+; to insert the time."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Need to move one or more paragraphs? No need to cut and paste: Use the keyboard shortcut Ctrl+Alt+Arrow (Up/Down)"), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Batch convert your MS Office documents to OpenDocument format by the Document Converter wizard in menu File > Wizards > Document converter."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Tools > Options > %PRODUCTNAME Calc > View > Zoom: 'Synchronize sheets' so that each sheet in Calc has its own zoom factor."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Open a CSV file as a new sheet in the current spreadsheet via Sheet > Sheet from file."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Need to move a Writer table? Table > Select > Table and Insert > Frame > Frame and move where you want."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "In %PRODUCTNAME Draw to change the 0/0 point of the rulers, drag the intersection of the two rulers in the top left corner into the workspace."), "", "tipoftheday_d.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Hold down Ctrl and turn the mouse wheel to change the zoom factor."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Edit > Find & Replace lets you insert special characters directly: right click in input fields or press Shift+Ctrl+S."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Don't use tabs to space items on a Writer document. Depending on what you are trying to do, a borderless table can be a better choice."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Drag a formatted object to the Styles and Formatting window. A dialog box opens, just enter the name of the new style."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Keep the zeros before a number by using the 'leading zeroes' cell format option or format the cell as text before entering the number."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "To copy a comment without losing the content of the target cell you should use Paste Special and uncheck everything except ‘Comments’ in dialog. Use Operations ‘Add’ to not override existing content."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Select an object in the document background via the Select tool in the Drawing toolbar to surround the object to select."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Apply Heading paragraph styles in Writer with shortcut keys: Ctrl+1 applies Heading 1, Ctrl+2 applies Heading 2, etc."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Mix portrait and landscape orientations in a Calc spreadsheet by applying different page styles on sheets."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "You can display a number as a fraction (0.125 = 1/8): Format > Cells, Number > Fraction."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to keep the text from, but remove a hyperlink, in Writer? Right click the link and ‘Remove Hyperlink’."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "To quickly zoom in the selection, press / (divide key) on the number pad. Press * to restore entire page in screen."), "", "tipoftheday_d.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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 restarts the slide show after a pause specified at Slide Show > Slide Show Settings > Loop and repeat."), "", "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", "Create different master pages in a presentation template: View > Master Slide and Slide > New Master (or per toolbar or right click in slide pane)."), "", "tipoftheday_i.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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", "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", "To modify an AutoPlay presentation, open it and after it starts, right click and select Edit in the context menu."), "", "tipoftheday_i.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Rename your slides in Impress to help you define 'Go to page' interactions and to have a summary more explicit than Slide1, Slide2…"), "", "tipoftheday_i.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Play music throughout a slideshow by assigning the sound to the first slide transition without clicking the ‘Apply to All Slides’ button."), "", "tipoftheday_i.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "With ‘Slide Show > Custom Slide Show’, reorder and pick slides to fit a slideshow to the needs of your viewers."), "", "tipoftheday_i.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Include a paragraph that is not a title in the table of contents by changing Outline & Numbering in the paragraph settings to an outline level."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Use the Connector tool from the Drawing toolbar in Draw/Impress to create nice flow charts and optionally copy/paste the object into Writer."), "", "tipoftheday_d.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to see, but not print, an object in Draw? Draw it on a layer for which the ‘Printable’ flag is not set (right click on the tab and ‘Modify Layer’)."), "", "tipoftheday_d.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to print two portrait pages on a landscape one (reducing A4 to A5)? File > Print and select 2 at ‘Pages per sheet’."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "To get the ‘Vertical Text’ tool in the Drawing toolbar, check Tools > Options > Language Settings > Languages > Default languages > Asian (and make the button visible with right click)."), "", ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "To automatically number your table rows in Writer, select the relevant column, then apply a numbering style from List Styles."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "%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."), "", "tipoftheday_c.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", "Want to display only the highest values in a spreadsheet? Select menu Data > AutoFilter, click the drop-down arrow, and chose ‘Top10’."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Unable to modify or delete a custom cell style? Check all sheets, none should be protected."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to know how many days there are in the current month? Use the DAYSINMONTH(TODAY()) function."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Add background images to spreadsheets via Insert > Image or drag a background from the Gallery, then Format > Arrange > To Background."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To quickly get a math object in Writer type your formula, mark it, and use Insert > Object > Formula to convert the text."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Writer can insert a blank page between two odd (even) pages that follow. Check ‘Print automatically inserted blank pages’ in the print dialog’s %PRODUCTNAME Writer tab."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "The 4th optional parameter of VLOOKUP Calc function indicates whether the first column of data is sorted. If not, enter FALSE or zero."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to show hidden column A? Click a cell in column B, press the left mouse button, move the mouse to the left, release. Then switch it on via Format > Columns > Show."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Writer helps you to make backups: with File > Save a Copy you create a new document continuing to work on the original."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Need to present a report written with Writer? File > Send > Outline to Presentation automatically creates a slideshow from the outline."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Drag & drop cells from Calc into the normal view of a slide creates a table; into the outline view, each cell creates a line in the outline."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Use Format > Align (or the context menu) for precise positioning of objects in Draw/Impress: it centers on the page if one object is selected or works on the group respectively."), "", "tipoftheday_d.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Repeat the heading on a subsequent page when a table spans over more than one page with Table > Table Properties > Text Flow > Repeat heading."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Use column or row labels in formulas. For example, if you have two columns, ‘Time’ and ‘KM’, use =Time/KM to get minutes per kilometer."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To change the number of a page in Writer, go to the properties of the first paragraph and at the Text Flow tab check Break > Insert and enter the number."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want the cursor to go into the cell to the right, after entering a value in Calc? Use the Tab key instead of Enter."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Show or hide comments in Writer by clicking the comment toggle button in the ruler."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Fit your sheet or print ranges to a page with Format > Page > Sheet Tab > Scaling Mode."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Keep column headers of a sheet visible when scrolling lines via View > Freeze Cells > Freeze First Row."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want your chapter titles to always begin a page? Edit Heading1 (paragraph style) > Text Flow > Breaks and check Insert > Page > Before."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to keep the text from, but remove a hyperlink, in Writer? Right click the link and ‘Remove Hyperlink’."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Create a chart based on a Writer table by clicking in the table and choosing Insert > Chart."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Move a column in Calc between two others in one step? Click the header then a cell in the column, keep mouse button and move to the target with Alt key."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Ctrl+Shift+F9 recalculates all formulas in all spreadsheets."), "", "tipoftheday_c.png"}, { NC_("RID_CUI_TIPOFTHEDAY", "Use the Backspace key instead of Delete in Calc. You can choose what to delete."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To distribute some text in multi-columns select the text and apply Format > Columns."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Uncheck Slide Show > Settings > Presentation always on top if you need another program displays its window to the front of your presentation."), "", "tipoftheday_i.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Select options in Tools > Options > %PRODUCTNAME Writer > Formatting Aids > Display to specify which non-printing characters are displayed."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want the same layout for the screen display and printing? Check Tools > Options > %PRODUCTNAME Calc > General > Use printer metrics for text formatting."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Customize your footnotes page with Tools > Footnotes and Endnotes…"), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to sum a cell through several sheets? Refer to the range of sheets e.g. =SUM(Sheet1.A1:Sheet3.A1)."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can copy from one sheet to another without the clipboard. Select the area to copy, Ctrl+click the target sheet's tab and use Sheet > Fill Cells > Fill Sheets."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to insert a value in the same place on several sheets? Select the sheets: hold down Ctrl key and click their tabs before entering."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Click a column field (row) PivotTable and press F12 to group data. Choices adapt to content: Date (month, quarter, year), number (classes)"), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to count words for just one particular paragraph style? Use Edit > Find & Replace > Paragraph Styles, select the style > Find All and read the number from the status bar."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Toolbars are contextual - they open depending on the context. If you do not want that, uncheck them from View > Toolbars."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Insert and number your formulas in one step: type fn then F3. An AutoText is inserted with formula and number aligned in a table."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To automatically number your table rows in Writer, select the relevant column, then apply a numbering style from List Styles."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Delete all of your printing areas in one step: select all sheets, then Format > Print Ranges > Clear."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME helps you not to enter two or more spaces in Writer. Check Tools > AutoCorrect > AutoCorrect Options > Options > Ignore double spaces."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Transpose a writer table? Copy and paste in Calc, transpose with copy/paste special then copy/paste special > Formatted text in Writer."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Writer lets you number your footnotes per page, chapter, document: Tools > Footnotes and Endnotes > Footnotes tab > Counting."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Left-handed? Enable Tools > Options > Language Settings > Languages > Asian and check Tools > Options > %PRODUCTNAME Writer > View > Ruler > Right-aligned, which displays the scrollbar to the left."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To display the scrollbar to the left, enable Tools > Options > Language Settings > Languages > Complex text and check Sheet > Right-To-Left."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Your numbers are displayed as ### in your spreadsheet? The column is too narrow to display all digits."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Use Ctrl+Alt+Shift+V to paste the contents of the clipboard as unformatted text."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "When editing a cell in place, you can right click and Insert fields: Date, Sheet name, Document title etc."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can restarts the slide show after a pause specified at Slide Show > Slide Show Settings > Loop and repeat."), "", "tipoftheday_i.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Can't see all the text in a cell? Expand the input line in the formula bar and you can scroll."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Often create one document from another? Consider using a template."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "New versions of %PRODUCTNAME don't only bring new features and bug fixes. They also include security patches. Stay safe, and keep yourself updated!"), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to duplicate the above line? Press Ctrl + D or use Sheet > Fill Cells > Fill Down."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can easily optimize your table per Table > Size > Distribute Rows / Columns Evenly."), "", "tipoftheday_w.png"}, { NC_("RID_CUI_TIPOFTHEDAY", "Best way to fix bad-looking MS Word table cells via Table > Size > Optimal Row Height / Column Width."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Don't get lost in large documents. Use the Navigator (F5) to find your way through the content."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can use styles to make the tables in your document consistent. Choose one from the predefined per Styles (F11) or via Table > AutoFormat."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to select a large range of cells without scrolling? Type the range reference (e.g. A1:A1000) in the name box then Enter."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to center cells on a printed page in Calc? Format > Page, Page > Layout settings > Table alignment."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can show formulas instead of results with View > Show Formula (or Tools > Options > %PRODUCTNAME Calc > View > Display > Formulas)."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to jump to a particular page by its number? Click the left-most statusbar entry or use Edit > Go To Page… or press Ctrl+G."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "With Tools > AutoText > AutoText > Import you can select a Word document or a template containing the AutoText entries that you want to import."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can display a number as a fraction (0.125 = 1/8): Format > Cells, Number > Fraction."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To print the notes of your slides go to File > Print > Impress tab and select Notes under Document > Type."), "", "tipoftheday_i.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Repeat the heading on a subsequent page when a table spans over more than one page with Table > Table Properties > Text Flow > Repeat heading."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "To quickly insert or delete rows, select the desired number of rows (or columns) and press Ctrl+ to add or Ctrl- to delete."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "To repeat rows/columns on every pages use Format > Print Ranges > Edit."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Need to insert the date in a spreadsheet cell? Type Ctrl+; or Shift+Ctrl+; to insert the time."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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 Ctrl+Space to select the current column."), "", "tipoftheday_c.png"}, + { 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", "You can move an object to another layer by holding it until its edges flash, then drag it to the tab of the layer you want to move it to."), "", "tipoftheday_d.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to find words containing more than 10 characters? Edit > Find & Replace > Search > [a-z]{10,} > Other Options > check Regular expressions."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Data > Validity allows you to create drop-down lists where the user selects a value instead of typing."), "https://help.libreoffice.org/%PRODUCTVERSION/%LANGUAGENAME/text/scalc/guide/validity.html";, "tipoftheday_c.png"}, //local help missing + { NC_("RID_CUI_TIPOFTHEDAY", "Hold down Ctrl 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 & Replace > Paragraph Styles, select the style > Find All and read the number from 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", "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", "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 Ctrl + 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", "Make it easy to insert a picture in a Writer template by Insert > Fields > More fields > Functions > PlaceHolder > Image. One click to select an image."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Create a master document from the current Writer document? File > Send > Create Master Document (sub-documents are created depending of outline)."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Your date acceptance pattern is inappropriate? Tools > Options > Language Settings > Language > Date acceptance patterns allows to tweak the pattern."), "", ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "%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", "%PRODUCTNAME intends to apply as an organization for Google Summer of Code (GSoC) see:"), "https://wiki.documentfoundation.org/Development/GSoC";, ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "Did you know that you can attach comments to portions of text? Just use the shortcut Ctrl+Alt+C."), "", ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "Need to move one or more paragraphs? No need to cut and paste: Use the keyboard shortcut Ctrl+Alt+Arrow (Up/Down)"), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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 & 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", "Typing in bold, italics, or underlined in Writer you can continue with the default attributes using just the shortcut Ctrl+Shift+X (remove direct character formats)."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To search in several spreadsheets, select them before you start the search."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Use Ctrl+Alt+Shift+V to paste the contents of the clipboard as unformatted text."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Customize your footnotes page 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 precisely position? Alt+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've 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", "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, Ctrl+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 Tools > Options > 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 your chapter titles to always begin a page? Edit Heading1 (paragraph style) > Text Flow > Breaks and check Insert > Page > Before."), "", "tipoftheday_w.png"}, { NC_("RID_CUI_TIPOFTHEDAY", "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", "Need custom contents for metadata properties? File > Properties > Custom Properties tab lets you create what you want."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "Insert your metadata in your document with Insert > Fields > More Fields… > Document or DocInformation."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To delete multiple comments, select cells with comments and use Sheet > Cell Comments > Delete Comment."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You would like to view the calculation of individual elements of a formula, select the respective elements and press F9."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can rotate cells table orientation with Table > Properties… > Text Flow > Text orientation."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Got many images in your Writer document? Speed up the display by disabling View > Images and charts."), "", "tipoftheday_w.png"}, { NC_("RID_CUI_TIPOFTHEDAY", "Shift+Ctrl+Del deletes from cursor to the end of the current sentence."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Need an unnumbered item in a list? Use 'Insert Unnumbered Entry' in the Bullets and Numbering toolbar."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to sort a pivot table? Click on drop-list's arrow in the row/col header and select sort method: ascending, descending, or custom."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Do not insert manual breaks to separate two paragraphs. Rather change Indents & Spacing > Spacing > Below paragraph at the style/paragraph properties."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Your Writer document didn’t reopen with the text cursor at the same editing position it was when you saved it? Check Tools > Options > %PRODUCTNAME > User Data > First/Last name is not empty."), "", ""}, + { 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."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Want to become a %PRODUCTNAME Ambassador? There are certifications for developers, admins, and trainers."), "http://www.documentfoundation.org/certification";, ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "Mix portrait and landscape orientations in a Calc spreadsheet by applying different page styles on sheets."), "", "tipoftheday_c.png"}, + { 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."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Configure use of the Ctrl key to open hyperlinks? Tools > Options > %PRODUCTNAME > Security > Options > ‘Ctrl+click required to open hyperlinks’."), "", ""}, + { 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 line, double click, type the text, Format > Text Box and Shape > Fontwork."), "", "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 chose ‘Top10’."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "To remove the page number from your table of contents go to Insert > Table of Contents (or right-click and Edit the previously inserted index). 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", "To quickly get a math object in Writer type your formula, mark it, and use Insert > Object > Formula to convert the text."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "With %PRODUCTNAME it is very easy to install a new dictionary: they are supplied as extensions."), "https://extensions.libreoffice.org/extensions?getCategories=Dictionary";, ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has a portable version which gives you mobility. Even without administrator rights on your computer you can install %PRODUCTNAME Portable to your hard drive too."), "http://www.libreoffice.org/download/portable-versions/";, ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "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 didn’t reopen with the text cursor at the same editing position it was when you saved it? Check Tools > Options > %PRODUCTNAME > User Data > First/Last name is not empty."), "", ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "Citation management? Use a 3rd party extension."), "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 Ctrl key and click their tabs before entering."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "You can customize the middle mouse button per Tools > Options > %PRODUCTNAME > View > Middle Mouse button."), "", ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "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", "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 doesn't calculate from left to right but respects the order Parentheses > Exponents > Multiplication > Division > Addition > Subtraction."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can change the default function in the status bar: right click on the area."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You do not want to print all columns? Hide or group the ones you do not need."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Use Shift+Space to select the current row and Ctrl+Space to select the current column."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To insert the current date in your document, use Insert > Field > Date."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Click at the beginning (end) of a section and press Alt+Enter to insert a paragraph before (after) the section."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Get %PRODUCTNAME documentation and free user guide books at:"), "http://www.libreoffice.org/get-help/documentation";, ""}, + { 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", "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", "You want to start working with Basic macros? Take a look at the examples under Tools > Macros > Edit Macros."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "To remove the page number from your table of contents go to Insert > Table of Contents (or right-click and Edit the previously inserted index). In the Entries tab delete the page number (#) from Structure line."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Chapter numbering dialog lets you set text to be displayed before the chapter number. For example, type 'Chapter ' to display 'Chapter 1'"), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to know if a cell is referred in formulas of other cells? Tools > Detective > Trace Dependents (Shift+F5)."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can customize the middle mouse button per Tools > Options > %PRODUCTNAME > View > Middle Mouse button."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "To repeat rows/columns on every pages use Format > Print Ranges > Edit."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Need to precisely position? Alt+arrow Keys move objects (shapes, pictures, formulas) by one pixel."), "", "tipoftheday_d.png"}, - { 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 toggle between the field names and the actual value with View > Fields Names (or Ctrl + F9)."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "When you're creating a Style based on another, you can enter a percentage value or a point value (e.g. 110% or -2pt or +5pt)."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Want to return to default after applying a list style? Click Bullets or Numbering On/Off tool on the Formatting toolbar."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Configure use of the Ctrl key to open hyperlinks? Tools > Options > %PRODUCTNAME > Security > Options > ‘Ctrl+click required to open hyperlinks’."), "", ""}, - { 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."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To quickly insert or delete rows, select the desired number of rows (or columns) and press Ctrl+ to add or Ctrl- to delete."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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", "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 > 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 Ctrl+* (numeric key pad)."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Ctrl+Shift+F9 recalculates all formulas in all spreadsheets."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Write along a curve? Draw the line, double click, type the text, Format > Text Box and Shape > Fontwork."), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "To enable macro recording, check Tools > Options > %PRODUCTNAME > Advanced > Enable macro recording."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "In the replace input field of auto correct options you can use the wildcards .*"), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Your date acceptance pattern is inappropriate? Tools > Options > Language Settings > Language > Date acceptance patterns allows 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 an unnumbered item in a list? Use 'Insert Unnumbered Entry' in the Bullets and Numbering toolbar."), "", "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 Alt 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 (or the context menu) for precise positioning of objects in Draw/Impress: it centers on the page if one object is selected or works on the group respectively."), "", "tipoftheday_d.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Don't use tabs to space items on a Writer document. Depending on what you are trying to do, a borderless table can be a better choice."), "", "tipoftheday_w.png"}, { NC_("RID_CUI_TIPOFTHEDAY", "No need to scroll through the list at Tools > Customize > Keyboard to find a shortcut: just type it."), "", ""}, - { NC_("RID_CUI_TIPOFTHEDAY", "To quickly zoom in the selection, press / (divide key) on the number pad. Press * to restore entire page in screen."), "", "tipoftheday_d.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "%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: Ctrl+1 applies Heading 1, Ctrl+2 applies Heading 2, etc."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Don't get lost in large documents. Use the Navigator (F5) to find your way through the content."), "", ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "Edit > Find & Replace lets you insert special characters directly: right click in input fields or press Shift+Ctrl+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 on the tab and ‘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", "Chapter numbering dialog lets you set text to be displayed before the chapter number. For example, type 'Chapter ' to display 'Chapter 1'"), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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 > Asian (and make the button visible with right click)."), "", ""}, { NC_("RID_CUI_TIPOFTHEDAY", "To quickly zoom in on range selection, right click on the zoom part of the status bar and choose Optimal."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can reformat all comments in a document by clicking the down arrow in a comment and choose 'Format all Comments'."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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 don’t need to copy/paste; use Data > Calculate > Formula to Value."), "", "tipoftheday_c.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "Find all expressions in brackets per Edit > Find & Replace > Find > \\([^)]+\\) (check ‘Regular expressions’)"), "", "tipoftheday_w.png"}, - { NC_("RID_CUI_TIPOFTHEDAY", "You can change the look of %PRODUCTNAME via Tools > Options > View > User Interface."), "", ""}, + { 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", "Want the same layout for the screen display and printing? Check Tools > Options > %PRODUCTNAME Calc > General > Use printer metrics for text formatting."), "", "tipoftheday_c.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "Writer helps you to make backups: with File > Save a Copy you create a new document continuing to work on the original."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "When you're creating a Style based on another, you can enter a percentage value or a point value (e.g. 110% or -2pt or +5pt)."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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 MS Office documents to OpenDocument format by 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", "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", "Create a master document from the current Writer document? File > Send > Create Master Document (sub-documents are created depending of outline)."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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", "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 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 Ctrl+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 & 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", "Click at the beginning (end) of a section and press Alt+Enter to insert a paragraph before (after) the section."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "%PRODUCTNAME has a template center to create good looking documents - check it out."), "http://templates.libreoffice.org/template-center";, ""}, + { 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", "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", "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 title in the table of contents by changing Outline & Numbering in the paragraph settings to an outline level."), "", "tipoftheday_w.png"}, + { NC_("RID_CUI_TIPOFTHEDAY", "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 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", "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 Ctrl + 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 check Sheet > 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 don't only bring new features and bug fixes. They also include security patches. Stay safe, and keep yourself updated!"), "", ""}, + { NC_("RID_CUI_TIPOFTHEDAY", "Developing new XSLT and XML filters?"), "http://fridrich.blogspot.com.tr/2013/08/extending-swiss-army-knife-overview.html";, ""}, }; #define STR_HELP_LINK NC_("STR_HELP_LINK", "%PRODUCTNAME Help") _______________________________________________ Libreoffice-commits mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
