541
edits
Changes
Jump to navigation
Jump to search
Line 36:
Line 36: − + − ====For Ubuntu OS====+ − #The application is part of the Ubuntu custom distribution. − #In case you do not find it on your computer, you can install by choosing “LibreOffice” in Ubuntu Software Centre − #If you would like to install through the terminal follow these steps below: − ##Open terminal by clicking (Ctrl+Alt+T), − ##Once Window page is open, in front of dollar($) symbol just type below command. − ##sudo apt-get install libreoffice − ==== For Windows OS ====+ − # Download "''LibreOffice windows installer''" from below − ##[https://www.libreoffice.org/download/libreoffice-fresh/?type=win-x86&lang=pick Click here for the 32-bit version] − ## [https://www.libreoffice.org/download/libreoffice-fresh/?type=win-x86_64&lang=pick Click here for the 64-bit version] − # If you are unsure which Windows version you have, press Win+Pause to open your system properties window. The LibreOffice Main Installer download page can be selected with a built-in help file for your language: − # Double-click on download "''LibreOffice_..._Win_x64.msi''" file to begin installation − # It will start downloading "LibreOffice" into your computer (by default browser will save the files in ''Downloads'' folder in your system) − Click "Yes" if it asks your permission to allow this program make change to the computer. The installation wizard welcome dialog box opens advising that the installation process is about to be started. Click “Next” − − <gallery mode="packed" heights="300px"> − File:Step1 LO Installation.png|Downloading LibreOffice − File:Step2 LO Installation.png|Installation wizard − </gallery> − − Another dialog box opens, giving you a choice whether you want a default installation, or whether you want to choose special locations and components. If you want a default installation, click “Next”. <gallery mode="packed" heights="400px"> − File:Step3 LO Installation.png|Setup type − File:Step6 LO Installation.png|File type selection − </gallery> − − Another dialog box opens, inviting you to choose whether to open Microsoft Office documents with LibreOffice. By default, this feature is not enabled. If you want LibreOffice to open Microsoft Office files (documents, spreadsheets and presentations), put a check mark in all four check boxes. Another dialog box opens, asking you whether: − − * A shortcut to open LibreOffice should be placed on your desktop. The default option is to create a shortcut. − * To load LibreOffice during system start-up. − − <gallery mode="packed" heights="400px"> − File:Step7 LO Installation.png|Ready to install the program − File:Step9 LO Installation.png|Finish − </gallery> − − − − If you are not able to install LibreOffice in your windows machine''''',''''' [https://www.libreoffice.org/get-help/install-howto/windows/ follow this official website installation instruction] or [https://youtu.be/ne-8PMLCj_k Click here] to see the LibreOffice Installation- English Tutorial − − ====For MAC OS==== − #Click [https://www.fosshub.com/LibreOffice.html this link] and click on "''LibreOffice MAC OS"'' for MAC laptops. − #It will start downloading "''LibreOffice_..._MacOS_x86-64.dmg"'' into your computer (by default browser will save the files in "''Downloads"'' folder in your system − #Double-click on download "''LibreOffice_..._MacOS_x86-64.dmg"'' file to begin installation − #An installation window appears: drag and drop the LibreOffice icon onto the Applications icon in the same window. You may be required to enter your administrator password. − #The files are copied over and a progress bar shows when the installation is complete. − If you are not able to install LibreOffice in your MAC machine, [https://www.libreoffice.org/get-help/install-howto/macos/ follow this official website installation instructions] Line 140:
Line 95: − − Line 148:
Line 101: − +
Learn LibreOffice Calc (view source)
Revision as of 11:29, 26 September 2022
, 11:29, 26 September 2022→Installation
Spreadsheet application is used for recording, processing and analyzing data. It is also used for creating text and graphical outputs. The application has many arithmetical, statistical, text processing functions which make it a very powerful desktop tool. Data can be sorted, filtered and processed into outputs, including multi-variate tables.
Spreadsheet application is used for recording, processing and analyzing data. It is also used for creating text and graphical outputs. The application has many arithmetical, statistical, text processing functions which make it a very powerful desktop tool. Data can be sorted, filtered and processed into outputs, including multi-variate tables.
===Installation===
==== Installation ====
Please click on the below link to learn about LibreOffice Installation & Configuration
[https://teacher-network.in/OER/index.php/LibreOffice_Installation_and_Configuration Click here]
===Working with the application===
===Working with the application===
==== Freeze or Unfreeze rows and columns ====
==== Freeze or Unfreeze rows and columns ====
If you enter data for a large number of rows or columns, you will not be able to read the row/column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on "View --> Freeze Cells --> Freeze Rows and Columns".<gallery mode="packed" heights="320">
If you enter data for a large number of rows or columns, you will not be able to read the row/column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on "View --> Freeze Cells --> Freeze Rows and Columns".<gallery mode="packed" heights="320">
File:LO Calc 2 Freeze rows and columns.png|Freezing the cells
File:LO Calc 2 Freeze rows and columns.png|Freezing the cells
{{clear}}
{{clear}}
=== Inserting formulae for computations===
==== Inserting formulae for computations====
<gallery mode="packed" heights="400">
<gallery mode="packed" heights="400">
File:LO Calc 3 Processing the data .png|Inserting the formula
File:LO Calc 3 Processing the data .png|Inserting the formula