Anonymous

Changes

From Karnataka Open Educational Resources
6,284 bytes added ,  09:32, 16 March 2017
Line 1: Line 1:  
==='''[http://www.libreoffice.org/get-help/documentation/ FOR LIBREOFFICE HELP DOCUMENT]'''===
 
==='''[http://www.libreoffice.org/get-help/documentation/ FOR LIBREOFFICE HELP DOCUMENT]'''===
 
[http://www.libreoffice.org/get-help/documentation/ Click here]
 
[http://www.libreoffice.org/get-help/documentation/ Click here]
 
+
====[https://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets Libreoffice shortcut keys CALC-1]====
 +
====[https://wiki.documentfoundation.org/images/4/4c/0315CG3-KeyboardShortcuts.pdf Libreoffice CALC Shortcut keys-2]====
 +
====[https://help.libreoffice.org/Common/General_Shortcut_Keys_in Libreoffice short cut keys]====
 
===Why we should use and promote LibreOffice ?===
 
===Why we should use and promote LibreOffice ?===
 
LibreOffice is public software - we all own it and can freely share it.  
 
LibreOffice is public software - we all own it and can freely share it.  
Line 77: Line 79:  
<li>Click [http://public-software.in/media/Format-Page.png here] to view the screenshot of the Format Page option.
 
<li>Click [http://public-software.in/media/Format-Page.png here] to view the screenshot of the Format Page option.
 
</p>
 
</p>
 +
 +
[[#top|Back to Top]]
 +
 +
===Changing the template for your text document===
 +
Libre Office Writer is comes with a predefined style templates which cannot be easily changed. For Example font style, font size, paragraph style etc. but you can create your own style template and make it as your default style by following these steps.<br/>
 +
 +
 +
1. Open the Styles and Formatting window through '''F11''' shortcut key or through menu '''Styles → Styles and Formatting.'''<br/>
 +
[[File:styles and formatting-min.png|300px]]<br/>
 +
 +
2. On the right side of the document you will see the Styles and Formatting window which displays Default Style. On the top right side '''Click on New style selection → New style.'''<br/>
 +
[[File:Creating new style 2.png|400px]]<br/>
 +
<br/>
 +
3. Give the name for your new style template.<br/>
 +
[[File:give name for your new text style template.png|200px]]<br/>
 +
<br/>
 +
4. Once you click on the '''OK, this new template is added to your style list. '''Select your new template → right click and select '''modify.''' <br/>
 +
[[File:modiefy new text style template-min.png|400px]] <br/>
 +
<br/>
 +
5. Change desired options like Font, Text flow, spacing, etc.,. in the modification window and click on '''Apply''' to save it. <br/>
 +
[[File:do change in your text style template.png|400px]] <br/>
 +
<br/>
 +
6. After all the modifications, go to '''File->Templates->Save as Template''' to open the Template Manager.<br/>
 +
[[File:save changes as a new template-min.png|400px]] <br/>
 +
<br/>
 +
7. In the Template Manager, double click on '''styles'''. <br/>
 +
[[File:selecting styles from the template.png|400px]] <br/>
 +
<br/>
 +
8 Click on '''Save''' at the top left corner. <br/>
 +
9 Enter the template name and click on '''OK'''. <br/>
 +
[[File:ENter the name of your new template-min.png|400px]] <br/>
 +
<br/>
 +
10. Then select the newly created template and click on Set as Default on top to set this as default style for any new documents created on LibreOffice. <br/>
 +
[[File:setting up as default template.png|400px]] <br/>
 +
<br/>
 +
11. Click on '''Close''' to close the Template Manager and re-open LibreOffice to see the new default style in LibreOffice. <br/>
 +
<br/>
 +
 +
 +
[[#top|Back to Top]]
 +
 +
===Adding videos in Libreoffice impress slides===
 +
 +
'''''Note: for doing this you need a good internet connection for the first time.'''''<br>
 +
<br>
 +
1. Open terminal  (Applications >> accessories >> terminal) <br>
 +
2. Type or copy paste below command :<br>
 +
<br>
 +
'''sudo apt-get install -y gstreamer0.10-plugins*'''<br>
 +
<br>
 +
3. if it is asking password for ubuntu, please type your ubuntu login password (ubuntu)<br>
 +
<br>
 +
''Note:- it will not display the password, just type and press "Enter".''<br>
 +
<br>
 +
4. Once it done, please restart the computer.<br>
 +
Now, you can add videos in impress. (Insert >> media >> audio and video)<br>
 +
    
[[#top|Back to Top]]
 
[[#top|Back to Top]]
Line 125: Line 184:  
[[#top|Back to Top]]
 
[[#top|Back to Top]]
   −
===What is Unicode?===
+
===What is Unicode? and convert non-uniccode to unicode===
Unicode provides a unique number for every character, no matter what the platform is, no matter what the program is, no matter what the language is.
+
Unicode (ISO 10646) is the one-size-fits-all character encoding standard designed to clean up the mess of dozens of mutually incompatible ASCII extensions and special encodings and to allow the computer interchange of text in any of the world's writing systems.<br/>
 +
 
 +
'''Note: A tool to convert Kannada text written using ASCII format like Nudi/Baraha to Unicode.Online version is available [http://aravindavk.in/ascii2unicode/ '''here'''].<br/>'''
 +
Source code is released under GPL license and developed by Aravind VK.<br/>
 +
 
    
[[#top|Back to Top]]
 
[[#top|Back to Top]]
Line 137: Line 200:     
===How do I Password Protect my files using LibreOffice?===
 
===How do I Password Protect my files using LibreOffice?===
In LibreOffice just go to File --> Save As and tick the ''Save with password'' option on bottom left corner. It works with ''.odt'' files but can not work with ''.doc'' files as the algorithm used to password protect those files are proprietary, and cannot be legally used.
     −
[[#top|Back to Top]]
+
* If you’re currently using LibreOffice want to learn how to save file securely with passwords, continue below to learn how. Password protecting a document restricts who can open, read or edit it. Anyone who tries to open it without the proper credential will be denied access. However, because LibreOffice uses a very strong encryption algorithm that makes it almost impossible to bypass, losing or forgetting your password will also deny you access to it.<br>
 +
* You can only change your password while the document is opened. If you can’t open it with the correct password, you’ll probably never be able to open that document again. To change your password.<br/>
 +
Click on '''File –> Properties –> General''', then on the menu bar, click the '''Change Password''' button in the dialog box.<br/>
 +
* To get started with protecting your documents, open or create a new document then go to '''File –> Save'''. On the Save dialog box, check the box at the bottom left to '''Save with password.'''<br/>
 +
[[file:libreofficepasswordprotect_01.png | 400px]]
 +
* Next, type and confirm the password that will open the document. When you’re done, click '''OK'''.<br/>
 +
[[file:libreofficepasswordprotect1_2.png |400px]]
 +
* Make sure to remember the password as it will be highly impossible to open the document without the correct password. If you even to open with M$ Word, you’ll get the error message below.<br/>
 +
[[file:libreofficepasswordprotect2_3.png |400px]]
 +
* So, that’s how to protect documents using LibreOffice. If you want the file to be read-only, click ‘More Option’ and create a second password that will allow the file to be changed or modified by users with the correct second password.<br/>
 +
[file:libreofficepasswordprotect3_4.png |400px]
 +
* To edit a document, right click the content and select Edit, then type the editable password.<br/>
 +
[file:libreofficepasswordprotect4_5.png | 400px}
    
===How to enable spell check in LibreOffice Writer?===
 
===How to enable spell check in LibreOffice Writer?===
Line 178: Line 252:  
<li> Enter your password when prompted (password not visible).</li>
 
<li> Enter your password when prompted (password not visible).</li>
 
</ul>
 
</ul>
 +
 +
[[#top|Back to Top]]
 +
 +
===How to mail merge using LO Writer===
 +
1. Create a csv with Name, Email address, etc.,. and save it in a file. <br/>
 +
2. Open LO writer and select Exchange database from Edit menu. <br/>
 +
3. Select browse and choose the csv file which we had created. <br/>
 +
4. Select Data sources from View menu to see the tables. <br/>
 +
5. Edit LO writer document as required. <br/>
 +
6. Drag and drop the attributes from data source table. <br/>
 +
7. Open Mail merge wizard from Tools menu and select current document as the starting document. <br/>
 +
8. Select document type - Letter/A4. <br/>
 +
9. Insert address block: Ensure “This document shall contain an address block” is unchecked. <br/>
 +
10. Create salutation: Ensure “This document should contain salutation” is unchecked. <br/>
 +
11. Edit document: By clicking the left and right arrow we can preview each page. <br/>
 +
12. Personalize document: This shows the finished document which is editable. <br/>
 +
13.  Save, print or send: Save merged document will save the finished multi page document and Save starting document will save template for later use. <br/>
    
[[#top|Back to Top]]
 
[[#top|Back to Top]]