issue109:libreoffice
Différences
Ci-dessous, les différences entre deux révisions de la page.
Prochaine révision | Révision précédenteDernière révisionLes deux révisions suivantes | ||
issue109:libreoffice [2016/05/29 17:57] – créée auntiee | issue109:libreoffice [2016/06/02 11:47] – auntiee | ||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
- | This is part 60. The big six-zero. Five years worth of articles about my favorite office suite. Due to demands at work and ambitions to take my writing in other directions, this is also my last article in this series. It has been a privilege to write for you each month and teach you about the many things you can do in LibreOffice. Believe me when I say I have learned a great deal by writing for you. | + | **This is part 60. The big six-zero. Five years worth of articles about my favorite office suite. Due to demands at work and ambitions to take my writing in other directions, this is also my last article in this series. It has been a privilege to write for you each month and teach you about the many things you can do in LibreOffice. Believe me when I say I have learned a great deal by writing for you. |
- | In the years writing about LibreOffice, | + | In the years writing about LibreOffice, |
- | 1. Icon Sets | + | Voici la partie n° 60. De grands 6 et 0. Cinq ans riches d' |
- | You can customize | + | Pendant ces années où j'ai écrit sur LibreOffice, |
- | 2. Keyboard Shortcuts | + | **1. Icon Sets |
- | Keyboard shortcuts are a great time saver. Instead of taking your hands off the keyboard to grab the mouse and do something, your hands can just stay at the keyboard and get the same results. Like any office suite, | + | You can customize |
- | 3. Mouse Zoom | + | 1. Jeux d' |
- | After preaching about keeping your hands off the mouse, my next tip is about zooming using the mouse. Most mice today have a scroll wheel, and you can use the scroll wheel to zoom in and out of your document. LibreOffice allows you to zoom from 20% (very small) to 600% (huge). Press the CTRL key while turning the scroll wheel to zoom in and out. Zoom in (make it bigger) by scrolling the wheel forward (away from you), and zoom out (make it smaller) by scrolling the wheel back (toward you). The amount of zoom is controlled by your mouse settings. | + | Vous pouvez personnaliser LibreOffice de sorte qu'il travaille mieux pour vous. Une de ces personnalisations est le jeu d' |
- | 4. Crop An Image | + | **2. Keyboard Shortcuts |
- | You can now crop an image directly in LibreOffice. No more opening GiMP or some other image program just to crop an image. To crop a selected image, Format > Image > Crop. Or you can click the icon on the Graphic toolbar. The image is surrounded by eight control handles. Crop the image horizontally | + | Keyboard shortcuts are a great time saver. Instead of taking your hands off the keyboard |
- | 5. Quick Calculations in Writer | + | 2. Raccourcis clavier |
- | Sometimes while writing a document, you need to insert the results of a calculation. You could go to your computer's calculator program, but that means getting out of Writer to start another program. Instead, use the Formula toolbar built into Writer. View > Toolbars > Formula or pressing the F2 key brings up the Formula toolbar. The bar works in the same manner as the formula bar in Calc, but you have a smaller set of functions you can use. Click on the fx button for a menu of the available functions. Once you finish, click the check button or press the Enter key. The result of the calculation will appear at the last position of your cursor. | + | Les raccourcis clavier vous permettent d' |
- | 6. Placeholders | + | **3. Mouse Zoom |
+ | |||
+ | After preaching about keeping your hands off the mouse, my next tip is about zooming using the mouse. Most mice today have a scroll wheel, and you can use the scroll wheel to zoom in and out of your document. LibreOffice allows you to zoom from 20% (very small) to 600% (huge). Press the CTRL key while turning the scroll wheel to zoom in and out. Zoom in (make it bigger) by scrolling the wheel forward (away from you), and zoom out (make it smaller) by scrolling the wheel back (toward you). The amount of zoom is controlled by your mouse settings.** | ||
+ | |||
+ | 3. Zoom à la souris | ||
+ | |||
+ | Après avoir prêché pour les mains sur le clavier, mon prochain conseil concerne le zoom avec la souris. La plupart des souris actuelles ont une molette et vous pouvez utiliser cette molette pour agrandir et réduire l' | ||
+ | |||
+ | **4. Crop An Image | ||
+ | |||
+ | You can now crop an image directly in LibreOffice. No more opening GiMP or some other image program just to crop an image. To crop a selected image, Format > Image > Crop. Or you can click the icon on the Graphic toolbar. The image is surrounded by eight control handles. Crop the image horizontally or vertically by dragging the center handles in the side and top/bottom edges. Dragging the corner handles crops both. Dragging while holding the SHIFT key maintains the image’s original aspect-ratio. After cropping an image, you can resize it and still maintain your crop. Crop mode stops when you press ESC or click anywhere outside the image.** | ||
+ | |||
+ | 4. Recadrer une image | ||
+ | |||
+ | Vous pouvez maintenant rogner une image directement dans LibreOffice. Plus besoin d' | ||
+ | |||
+ | **5. Quick Calculations in Writer | ||
+ | |||
+ | Sometimes while writing a document, you need to insert the results of a calculation. You could go to your computer' | ||
+ | |||
+ | 5. Calculs rapides dans Writer | ||
+ | |||
+ | Parfois, tout en écrivant un document, vous avez besoin d' | ||
+ | |||
+ | **6. Placeholders | ||
Placeholders are useful in templates and Auto Text. They are special fields that act as temporary text until the actual text or object is inserted. For example, if you were creating a template for a contract, you wouldn' | Placeholders are useful in templates and Auto Text. They are special fields that act as temporary text until the actual text or object is inserted. For example, if you were creating a template for a contract, you wouldn' | ||
Ligne 29: | Ligne 53: | ||
To create a placeholder, | To create a placeholder, | ||
- | To replace a placeholder with the actual information for the document, click on the placeholder and start typing for a text placeholder. For the table, frame, and object placeholders, | + | To replace a placeholder with the actual information for the document, click on the placeholder and start typing for a text placeholder. For the table, frame, and object placeholders, |
- | 7. Protecting Sections in Writer | + | 6. Substituants |
+ | |||
+ | Les substituants sont utiles dans les modèles et les AutoTextes. Ce sont des champs spéciaux qui tiennent lieu de texte temporaire jusqu' | ||
+ | |||
+ | Pour créer un substituant, | ||
+ | |||
+ | Dans le document, pour remplacer un substituant par l' | ||
+ | |||
+ | **7. Protecting Sections in Writer | ||
You can protect any section of a writer document from changes. Some sections, like table of contents, are protected by default. If you were creating a template for a legal document, and there were parts of the document that should never change, you can protect them from changes with a password. Select the text you need to protect, then Insert > Section. Give the section a name. Check the Protect and Password check boxes. A password dialog will pop up. Enter and confirm the password. Click OK. In the Section dialog, click Insert. | You can protect any section of a writer document from changes. Some sections, like table of contents, are protected by default. If you were creating a template for a legal document, and there were parts of the document that should never change, you can protect them from changes with a password. Select the text you need to protect, then Insert > Section. Give the section a name. Check the Protect and Password check boxes. A password dialog will pop up. Enter and confirm the password. Click OK. In the Section dialog, click Insert. | ||
- | To remove the protection and make changes, Format > Sections. Select the section you want to change. Uncheck the Protect check box, and enter the password when prompted. You can now make changes to the section. | + | To remove the protection and make changes, Format > Sections. Select the section you want to change. Uncheck the Protect check box, and enter the password when prompted. You can now make changes to the section.** |
- | 8. Entire Row/Column Reference | + | 7. Protéger des sections dans Writer |
- | When creating a formula in Calc, you sometimes need to reference an entire row or column, usually because the column or row will grow and you have no way to know where it will end. Before version 5, you had to create a reference like A1:A1048576 for columns or A1:AMJ1 for rows. Now, you can use a short reference to the column or row. For columns, you can enter A:A to reference the entire A column. For rows you can enter 1:1 to reference the entire row 1. You can even reference a range of columns or rows (A:B, 1:2). | + | Vous pouvez protéger des modifications toute section d'un document Writer. Certaines sections, comme la table des matières, sont protégées par défaut. Si vous créez un modèle de document juridique, et que certaines parties de ce document ne doivent jamais être modifiées, vous pouvez les protéger à l'aide d'un mot de passe. Sélectionnez le texte à protéger, puis, Insertion > Section. Donnez un nom à la section. Cochez les cases Protéger et Mot de passe. Une boîte de dialogue s' |
- | 9. Auto Filters Top 10 | + | Pour enlever la protection et faire des modifications, |
- | Calc allows you to easily show the top 10 values in any column through the AutoFilter function. To activate the filter, Data > Filter > AutoFilter. Once active, the filter shows a down arrow in the first cell of each column. Clicking on the arrow opens a drop down menu. One of the options is Top 10. Select Top 10 and you will get the top 10 records based on the values in that column. You could use it to determine your highest sales day, or the day of the highest peak on a stock. This tip works only for columnar data. To clear the AutoFilter, select Data > Filter > AutoFilter again. | + | **8. Entire Row/Column Reference |
- | 10. Scientific Format and Engineer Notation | + | When creating a formula in Calc, you sometimes need to reference an entire row or column, usually because the column or row will grow and you have no way to know where it will end. Before version 5, you had to create a reference like A1:A1048576 for columns or A1:AMJ1 for rows. Now, you can use a short reference to the column or row. For columns, you can enter A:A to reference the entire A column. For rows you can enter 1:1 to reference the entire row 1. You can even reference a range of columns or rows (A:B, 1:2).** |
+ | |||
+ | 8. Faire référence à une ligne/ | ||
+ | |||
+ | En créant une formule dans Calc, vous avez parfois besoin de faire référence à toute une ligne/ | ||
+ | |||
+ | **9. Auto Filters Top 10 | ||
+ | |||
+ | Calc allows you to easily show the top 10 values in any column through the AutoFilter function. To activate the filter, Data > Filter > AutoFilter. Once active, the filter shows a down arrow in the first cell of each column. Clicking on the arrow opens a drop down menu. One of the options is Top 10. Select Top 10 and you will get the top 10 records based on the values in that column. You could use it to determine your highest sales day, or the day of the highest peak on a stock. This tip works only for columnar data. To clear the AutoFilter, select Data > Filter > AutoFilter again.** | ||
+ | |||
+ | 9. AutoFiltre du Top 10 | ||
+ | |||
+ | Calc vous permet de montrer facilement le top 10 des valeurs dans n' | ||
+ | |||
+ | **10. Scientific Format and Engineer Notation | ||
Scientific notation is used to express very large or very small numbers. The basic idea is to take a predetermined number of digits and multiply them by powers of 10. This allows scientists and engineers to express these large numbers without having to write out all the digits. Engineer notation is a subset of scientific notation where the powers of 10 are a multiple of 3. | Scientific notation is used to express very large or very small numbers. The basic idea is to take a predetermined number of digits and multiply them by powers of 10. This allows scientists and engineers to express these large numbers without having to write out all the digits. Engineer notation is a subset of scientific notation where the powers of 10 are a multiple of 3. | ||
- | Calc will allow you to express both of these. Let's take the rather large number 12455485785256. A rather large number to type over and over again. In Calc, we can convert this number to scientific notation. Format > Cells. On the Numbers tab select Scientific from the Category list box. Click OK. Our number is transformed into Calc's version of scientific notation, 1.25E+13. 1.25 is the significant digits, E is the place holder for 10, and +13 represents the exponent of 10. If we want engineer notation, Format > Cells. Again, with Scientific selected, check the " | + | Calc will allow you to express both of these. Let's take the rather large number 12455485785256. A rather large number to type over and over again. In Calc, we can convert this number to scientific notation. Format > Cells. On the Numbers tab select Scientific from the Category list box. Click OK. Our number is transformed into Calc's version of scientific notation, 1.25E+13. 1.25 is the significant digits, E is the place holder for 10, and +13 represents the exponent of 10. If we want engineer notation, Format > Cells. Again, with Scientific selected, check the " |
- | One Last Thing | + | 10. Format scientifique et notation d' |
+ | |||
+ | La notation scientifique est utilisée pour exprimer des très grands et très petits nombres. L' | ||
+ | |||
+ | Calc vous permet d' | ||
+ | |||
+ | **One Last Thing | ||
I'd like to share one last thing with you that has been a big help to me while writing 60 articles about LibreOffice – documentation. I have a few helpful links to share with you. Each one provides something different. | I'd like to share one last thing with you that has been a big help to me while writing 60 articles about LibreOffice – documentation. I have a few helpful links to share with you. Each one provides something different. | ||
Ligne 61: | Ligne 113: | ||
LibreOffice Documentation / Publication Page: https:// | LibreOffice Documentation / Publication Page: https:// | ||
- | If you can't wait for the official release of a manual, this is the page where you find the documentation team’s drafts. Keep in mind that many of these documents are drafts and may contain mistakes and errors. When I was writing about Base, this was one of the only places to find documentation at the time. Of course, now there is an official Base manual. Just my luck. | + | If you can't wait for the official release of a manual, this is the page where you find the documentation team’s drafts. Keep in mind that many of these documents are drafts and may contain mistakes and errors. When I was writing about Base, this was one of the only places to find documentation at the time. Of course, now there is an official Base manual. Just my luck.** |
- | Document Foundation Blog: https:// | + | Une dernière chose |
+ | |||
+ | J' | ||
+ | |||
+ | La page du support de la communauté LibreOffice : http:// | ||
+ | |||
+ | La page de support de la communauté a des liens vers la documentation, | ||
+ | |||
+ | Page des documentations/ | ||
+ | |||
+ | Si vous ne pouvez pas attendre la publication officielle d'un manuel, c'est la page où vous trouverez le brouillon de la documentation de l' | ||
+ | |||
+ | **Document Foundation Blog: https:// | ||
The Document Foundation blog is a great place to get news about new releases, tips, events, and more. They don't overwhelm you with posts, but they do keep you up to date. | The Document Foundation blog is a great place to get news about new releases, tips, events, and more. They don't overwhelm you with posts, but they do keep you up to date. | ||
Ligne 69: | Ligne 133: | ||
With that, we come to the conclusion of my series on LibreOffice. It has been a great joy, and I wish many more successful years of publication for Full Circle. I will continue as a reader, and you may still see an article from me now and then, just not every month. | With that, we come to the conclusion of my series on LibreOffice. It has been a great joy, and I wish many more successful years of publication for Full Circle. I will continue as a reader, and you may still see an article from me now and then, just not every month. | ||
- | I leave you with one final thought, " | + | I leave you with one final thought, " |
+ | |||
+ | Le blog de la Document Foundation : https:// | ||
+ | |||
+ | Le blog de la Document Foundation est un super endroit pour trouver des informations sur les nouvelles publications et les événements, | ||
+ | |||
+ | Ainsi, nous arrivons à la conclusion de ma série sur LibreOffice. Ce fut un grand plaisir et je souhaite de nombreuses années de succès au Full Circle. Je continuerai à le lire et vous retrouverez sans doute un article de moi de temps à autre, mais pas tous les mois. | ||
+ | |||
+ | Je vous quitte avec une dernière pensée : « Ne travaillez pas si intensément que vous n'avez plus le temps de vivre, et ne vivez pas si intensément que vous ne pouvez plus apprécier votre travail. » |
issue109/libreoffice.txt · Dernière modification : 2016/06/02 13:58 de andre_domenech