Plan de l'article
- Install OpenOffice
- Turn off the Home Screen
- Install the French Dictionary
- Writer: create a PDF
- Writer: numbering pages
- Writer: Replace formatting characters
- Writer: alternating portrait and landscape pages
- Writer: insert a lettrine
- Calc: split your document
- Calc: Optimize Charts
- Calc: create a macro
- Calc: calculate an average quickly
- Calc: Hidden Games
- Calc: protect your data
- Impress: Play music on a presentation
- Impress: insert hyperlinks
- Print: Loop Your Presentations
- Draw: create a vector image
- Base: Connect to an external base
- Math: insert formula in Writer
Read also : Who should arrange a baby shower?
Highlights in our selection of the best free software, now popularized in the Public Service, OpenOfficeOffice Software Suite, developed according to the principle of free software and competing with the Microsoft Office suite. OpenOffice is a follow… is much more than just an alternative to Microsoft Office. This office suite includes a word processor, a spreadsheet, a multimedia presentation program is a term encompassing a lot of information, but the general idea is the convergence of different media in the same equipment. The te…, a vector drawing tool, a database manager and a mathematical program. We will show you some simple tips and tricks to apply that will make it easier for you to use the main OpenOffice functions. The ones we tell you work both on OpenOffice 2 and on the new version 3 beta. Have you always hesitated to take the step? Follow our advice…
See also : Becoming an anthropologist: around the human
To take advantage of OpenOfficeSuite office software, developed on the principle of free software and competing Microsoft Office suite. OpenOffice is a follow…, you must absolutely own JavaJava is a programming language developed by Sun Microsystems. This language is based on a virtual machine technology (still known as the… As for the installation is classic. As with Microsoft Office, you can set up the installation (or not) of each of the six programs in the suite. Rest assured, this ultimately takes much less time than with Microsoft Office. -Download OpenOffice 3.
Turn off the Home Screen
The home screen, also known as SplashScreen, can be easily disabled. To do this, go to . In the Folder Options, remember to uncheck the Hide extensions of files of known type check box, and then select the file “Soffice.ini. Right-click, choose OpenProgram Files/OpenOfficeOffice Software Suite, developed on the basis of free software and competing Microsoft Office suite. OpenOffice is a follow… org 3/Program (in Notepad) and change Logo=1 to Logo=0. Save the file, the turn is played.
Install the French Dictionary
File/Wizards and then Install New Dictionaries. In the window that opens, click French and then click Launch DiCooo. You will now be able to select the list of dictionaries you want to import. Each time, click Recover List to scroll through all available offers. In order you will have to choose the dictionary, then the one of hyphenation and synonyms. Once the download is complete, click Finish and then go to Writer in Tools/Options/Language Settings/ Linguistics. There, click Edit (face Available language modulesTo make the most of Writer, the OpenOfficeSuite word processor of office automation software, developed according to the principle of software free and competing Microsoft Office suite. OpenOffice is a follow…, it is appropriate to have installed the dictionary in French. Under Writer, select ) and verify that all options are checked.
Writer: create a PDF
Export to PDF option from the File menu. Here you need to define the compression ratioCompression deals with how it is possible to store a certain amount of data in a less space than when it is stored… of your images, manage the built-in links, before finally entering the name that you want to give your file after clicking ExportOpenOfficeOffice Software Suite, developed according to the principle of free software and competing with the Microsoft Office suite. OpenOffice is a follow… org supports PDF format without you having to install any plugin. In fact, you can export your documents (text, tables, drawings, etc.) to PDF format very simply by selecting the .
Writer: numbering pages
Under Writer, it’s pretty simple to number your pages. Start by placing yourself in the footer (Insert/Footer/Standard ) and place the page number (Insert/Field/Page Number) there. This can be done from any page in your document. Note that you can also place custom text by typing for example “This is page no” first and then selecting (Insert/Field/Page Number). The same text will then appear again on each footer, embellished with the right number that goes with it.
Writer: Replace formatting characters
The easiest way to replace text with another is to go to Edit/Find & Replace (or the “binoculars” icon in the toolbar). But when it comes to all the formatting characters in your text (tabs, line returns, etc.), there is an alternative solution. Always in Find & Replace, click the Other Options and check the Regular Expressions option. Then you just need to enter the codes corresponding to the different characters to find them and if necessary replace them: $ for a paragraph break, t for a tab, n for a paragraph end, etc.
Writer: alternating portrait and landscape pages
If you want to embed a page in landscape format full document under Writer, here is the procedure to follow. First, you’ll need to create a new page style. Open the Styles and Formatting window on the Format menu. Select the Page Styles icon and right-click Standard choose New. There, click on the Page tab and select Landscape. Under Manage, give it a name and then validate. Once your style is defined, all you have to do is apply it to the page of your choice. Where you want to insert your page, run the Insert/Manual Break option. Then choose Page Break while selecting the style you just created from the drop-down list. For return further in your document to a portrait format, do the same operation again but this time selecting Standard from the list. It’s a little tedious but effective.
Writer: insert a lettrine
A lettrine placed at the top of a paragraph will highlight it while guaranteeing a more neat layout. To create a new one, highlight the first letter of your paragraph, then go to Format/Paragraph and then to the Lettrines tab. Select the First Letter (s) check box, determine the Height of the letter (in number of rows) and then its Text Spacing .
Calc: split your document
Under Calc, splitting your window allows you to navigate without constraint in long and complex arrays. Thus, you can have two extremes on screen and navigate in it simultaneously. To do this, select a cell, the one you want to appear immediately below the separation, and then click Window/Split. A divider bar appears on the screen. Above and below, you can now navigate with peace of mind by having both parts of your board always visible on the screen. Reselect Window/Split to return to normal mode.
Calc: Optimize Charts
Be aware that with Calc you have the opportunity to edit fairly elaborate graphs, which are not just translating your selected data. Start by creating a diagram (Insertion/Diagram… from a list of selected data. Once the graph is on the screen, go to Insert/Label Data. This way, you will be able to display both the value but also the percentage calculated automatically of your data. To do this, check Show Value as Number and Show Value as Percentage. Add to it Show category if you want the caption to appear on the chart. Before validating everything, be sure to select the Optimal Adaptation option from the Placement menu. You will quickly notice the difference!
Calc: create a macro
A macroOn calls macrophotography (or photomacrography), the close-up shot to the point that the subject on the sensor/film either larger or size… is mainly used to repeat a series of operations, without having to redo all manually. They therefore prove to be very convenient to use. Under Calc, simply select the Macros/Save Macro option from the Tools menu. Then, carefully perform the entire suite of operations you want to record, and then click Finish Recording in the small window that opened and give your macro a name. Note that the easiest way is then to create a dedicated button on your toolbar. To do this, go to Display/Toolbar/Customize… Click Add and then select your macro at the end of the category list.
Calc: calculate an average quickly
There is a quick way, requiring no formula, to calculate the average of a data set. Right-click Summ=0, on the status bar at the bottom right of your window. There, select Average . Then simply select a dataset (row, column, etc.) and you will get its average in real time directly in the status bar. As you understand, this also applies to the sums or the search for the minimum or maximum of a list! Fast and efficient.
Calc: Hidden Games
Calc is full of surprises, hidden “bonuses”. These eggsBonus easter hidden on software or DVD accessible only via, for example, an undocumented keyboard shortcut or browsing apparently … are sometimes quite delusional, such as the one concerning a small video game like Space Inviders (the old ones will appreciate). To unveil it, simply type =GAME (“StarWars”) in any box. If you prefer to play punch, then type =GAME (A2:C4;” TicTacToe”) instead. Another pretty funny tip, you can admire the photo of Calc developers simply by copying the command =starcalcteam () and always validating by Enter .
Calc: protect your data
Under Calc, you have the option to protect three types of elements. First, you should know that you can protect one or more cells. Right-click on your selection and choose Format Cells. You Then find all the options to hide all or part of your data under the Protection tab. To protect an entire sheet, go to Tools/Protection/Sheet… and set a password. Finally, you can protect the document itself, by granting it a password. To do this, go to File/Save As… then check the Save with Password option. After clicking Validate , you will be prompted to save a password related to this document. You will then be automatically asked each time you want to open it.
Impress: Play music on a presentation
A slideshow with background music will always be more enjoyable to view. To place background music, Nothing easier: click on the slide on which you want the music to start and then open the Transition tab on the right of Impress. In Edit Transition, choose Other Sound… from the Sound drop-down menu. Then select the song you want to play and then check Loop to Sound. Be careful that all of the following slides do not have any sound selected. Finally, set the transition mode to switch to the next slide Automatically after X seconds.
Under Impress, it’s very easy to integrate hyperlinks into your presentations. To do this, simply go to the Insertion/Hyperlink. However, during your presentations it may happen that your links do not open, at least in the foreground (because in fact your browser is active but under your slideshow). To resolve this issue, simply go to Slideshow/Slideshow Settings and make sure you uncheck the Always Foreground Show option. This way, whenever you click on a link via your presentation, it will return a web page to the screen.
Print: Loop Your Presentations
During your presentations, perhaps you need to let your slideshows turn in a loop. Be aware that with Impress it is relatively simple to achieve. Start by going to the Slide Sorter tab and select all your slides (Ctrl A). HATH right in the Tasks panel, select the Transition tab and then click Automatically After in Skip to Next Slide and set the amount of time that should elapse between each slide. Next, go to Validate Operation by clicking Apply to All Slides. Then go to Slideshow/Slideshow Settings and check the Auto option by setting the counter to 00:00:00 under the Type section. Click OK, the turn is played!
Draw: create a vector image
Under Draw, you can very easily convert a photo into a vector image. To do this, you just need to open your image, click on it to select it and then choose Change/Convert/To Polygon as option. In the window that appears, you are free to play on the Number of Colors or the Point Reduction, so remember to check the box corresponding to Block Holes. Before you validate, also remember to click the Preview button.
Base: Connect to an external base
Connect to an existing database on the Base launch window. In this case, your new document only serves as an interface for your Access file, it does not contain its data. To connect to a MySQL database, it’s a bit more complicated, since you previously need to download an additional library, (JDBC. At that point, you will be able to select MySQL from the drop down menu of Connect to an existing database, then follow the steps by obviously taking care to choose a Connection using JDBCThe OpenOfficeSuite equivalent of office software, developed according to the principle of free software and competing in the Microsoft Office suite. OpenOffice is a follow up… of Access under Microsoft Office allows you to connect to an external database: Access, MySQL, Oracle, etc. For example, to connect to an Access database, you must select Microsoft Access in .
Math: insert formula in Writer
Although Math is a full-fledged program, you can still run it directly from Writer, especially if you need to insert a formula into your document (Insertion/Object/Formula). It is in the bottom pane that you will enter your equation, with the Selection window helping you to place different formulas. Then you only have to enter the necessary data, encrypted or unencrypted. Once your formula is complete, simply press the Esc key or click anywhere in the text to validate. By double-clicking on the inserted object, you can then edit it.
We hope that these little tricks designed to popularize a suite that deserves attention will have convinced you that a complete and free suite can be perfectly credible.