C4C > OFFICE

OFFICE

Document Viewer is Lubuntu's name for Evince - and it comes from their own motto; "Simply a Document Viewer." The stated goal of Evince is to replace the many other "portable" document viewers like gpdf and ggv with one, all-encompassing document viewer. Of course the main format most users need is the Portable Document Format, PDF. But Evince can also view djvu, dvi, ps, tif and xps documents and well as comic book formats; cb7, cbr, cbt and cbz.

Evince

Visit Evince's Live GNOME Home , FAQ and Wiki. Evince is free and open source software licensed under the GPL. Another app we include in the C4C Lubuntu ReSpin is called Xpdf; also free and open source software and also licensed under the GPL. Another good alternative document viewer is called Okular.

Note: Evince, Xpdf (and Okular) are PDF viewers. To create PDF files; the easiest option from most any application is Print-to-PDF. Many applications (some via plug-ins) export to PDF. In LibreOffice Writer; Go to File --> Export as PDF.

Evince

If you need to edit an already existing PDF file (meaning you don't have the original), there are applications that allow PDF editing / manipulation. Manipulate PDF files via the command line with PDFtk, or with a GUI interface with PDF-Shuffler. GIMP has native PDF support - also see Patrick Nagel's solution for multi-page PDF documents here. And LibreOffice has folded their PDF Importer into Draw, where many PDF files open and are editable.


GnuCash

GnuCash is financial software featuring double-entry accounting, checkbook styled register, scheduled transactions, reports, graphs and more. Easily import data from on-line bank statements and other software packages using HBCI, OFX and QIF files. GnuCash uses the double entry accounting system; you will always keep at least two accounts balanced. Transfers of money between accounts debit one and credit the other.

GnuCash divides financial data into files, accounts (checking, savings, credit cards, mortgage, loans...), and transactions (buying something, paying a bill, transferring money, depositing a check, withdrawing money...) stored as either a single XML file or SQL database (using SQLite3, MySQL or PostgreSQL) in five categories; assets, liabilities, equity, income and expenses. And GnuCash makes all this easy to set up and keep track of. You'll always have a good understanding of where you are financially.

GnuCash

GnuCash is free and open source software licensed under the GPL. The GnuCash.org website features an Online Help Manual and a Tutorial and Concepts Guide. You may be interested in this Church Accounting Using GnuCash Series on Finance and Accounting for Churches Blog.



LibreOffice

LibreOffice is a full-featured office suite of applications for text (Writer), spreadsheets (Calc), presentations (Impress), diagrams (Draw), and databases (Base). LibreOffice uses the ISO/IEC standard OpenDocument Format (ODF) as well as featuring full compatibility with literally dozens of other office suites (including Microsoft Office) and stand-alone applications. You can open, work with, save as, import and export to and from LaTex, HTML, StarOffice, PDF, WordPerfect, RTF, Google Docs, Xoho, WebDAV and much more.


LibreOffice


Learn more at the LibreOffice Home. Check out Getting Started with LibreOffice from Open of Course, The Document Foundation's own Documentation as ODF and PDF files. Don't miss LibreOffice Extensions , Maco Tutorials from DebugPoint.com and and LibreOffice Templates.


LIBREOFFICE AND MICROSOFT OFFICE

Microsoft file formats like doc and docx (Word), xls and xlsx (Excel), ppt and pptx (PowerPoint) can be opened, read, changed, and "saved as" in LibreOffice. However, the reverse is not always true. If the LibreOffice user plans to share files with a user of Microsoft Office (or, say print a file from work, turn in a school project electronically, or submit a resume in "Word"); they will probably need to "Save As..." their documents in corresponding Microsoft Office formats.

Writer > Word

Calc > Excel

Impress > PowerPoint

Base > Access

THE "CORE" MICROSOFT FONTS

Special attention should also be paid to the fonts used in LibreOffice documents destined to be opened in Microsoft Office. The "core" Microsoft fonts of Andale Mono, Arial, Arial Black, Comic Sans MS, Georgia, Impact, Tahoma, Times New Roman, Trebuchet, and Verdana are not included. However, these are freely available and easily installed (if you installed the lubuntu-restricted-extras, you now have these fonts).

Go to Menu --> Accessories --> LXTerminal
Type (or copy and paste):
sudo apt install ttf-mscorefonts-installer[Enter]

You will be required to agree to the Microsoft EULA. [Tab] to <OK> then [Enter]. [Left Arrow] to <Yes> then [Enter]

Update MS Core Fonts after running updates to the OS

LibreOffice: Base

Base is a powerful database application. Single users have access to the HSQL relational database engine with data stored in the BASE file. Wizards help in the creation of tables, queries, forms and reports. Power users can connect to almost any database with native support drivers for MySQL, Adabas D, JDBC, ODBC, MS Access and PostgreSQL.

See the Base Homepage, Create a Database from BusinessProgrammer.com on YouTube, Getting Started with Nerd on the Street on YouTube, Tutorials from GOFree, TechRepublic and video tutorials from TheFrugalComputerGuy.


LibreOffice: Calc

Calc is the spreadsheet application for LibreOffice and offers flexible cell formatting options, multiple user support, security for files, over one million rows of data (if you need that many in one spreadsheet), plenty of mathematical functions and easy formula creation. Cross-tabulate, summarize, and convert raw data from other sources. Use templates (even those designed for other spreadsheet applications), wizards and more. There is even an Intelligent Sum button that inserts a sum function or subtotal, depending on the context.

See the Calc Homepage, Array Formulas and Functions Tutorial on YouTube, tutorials from GOFree, SmartChicago, Spreadsheet Beginners Tutorial from DCP WEB on YouTube and video tutorials from TheFrugalComputerGuy.


LibreOffice: Draw
Draw offers import and export support for BMP, GIF, JPEG, PDF, PNG, TIFF, and WMF. It will also save projects as an SWF (Flash) file. Draw offers two and three-dimensional rotation; group, ungroup, regroup (and editing while graphics are still grouped); can use textures, lighting effects and transparency; can change perspectives, be used to make network diagrams and flowcharts; and features page sizes big enough to make posters.

See the Draw Homepage, tutorials from GOFree, LPG Computer Fundamentals and videos from TheFrugalComputerGuy.




LibreOffice: Impress
Impress is used to make, import, export and manipulate all sorts of slide presentations. Use the multi-pane view, or separate drawing, handouts, notes, outline and slides view. Use an incredible selection of built-in transitions, 2D and 3D clip art, special effects, animation and more. Wow the church with a presentation you made in an hour. Besides it's own default file format (an open standard), Impress offers you the option to save as a Microsoft PowerPoint presentation, a PDF or even a Flash SWF file.

See the Impress Homepage, the Beginner's Guide from the ThoughtCo., an Impress tutorial from GOFree and video tutorials from TheFrugalComputerGuy. Download pre-made templates from Brainy Betty, Chich-Hao Tsai, ETC Presentation, Guide2Office, Marcin Milkowski, Phillip Martin and Presentation Magazine.





LibreOffice: Writer
Writer allows you to easily write papers featuring bibliographies, reference tables, and indexes. Writer features auto-correction, auto-completion, formatting, illustration and template use (even templates designed for other applications and office suites) and more. Collaborate with classmates, Bible study partners, or church groups with version tracking and the ability to record changes to a shared document. Password-protect your work, use macros, use Google Docs; export to PDF, HTML, publish to a blog, etc.

See Writer’s Homepage, 10 Essential LibreOffice Writer Tricks from TechRepublic, tutorials from LPG Computer Fundamentals and tutorials in PDF from BVCC Schoolhouse. And/or see video tutorials; the Beginners Tutorial, the Complete Guide to Images, and video tutorials from TheFrugalComputerGuy.




Other Office
(not included, but possibly useful to you)

CiviCRM - Constituent Relationship Management. A web-based solution designed specifically to meet the needs of advocacy, non-profit and non-governmental groups. ChurchInfo - A church database that runs on any computer or server supporting PHP and MySQL. Track members, families, groups, teachers, students, class lists, attendance, volunteers, guests, pledges, payments, donations... Firebird - Relational database offering many ANSI SQL standard features. Concurrency and language support for stored procedures and triggers. gLabels Label Designer - Business card and label designer software for various laser/ink-jet peel-off labels with many available templates. GanttPV - Project Scheduling with Gnatt charts.




Top