Suite101

Articles related to "Openoffice"



Calc Macros: Column Widths and Row Heights
OpenOffice.org Calc cells can soon become hard to read when they have a lot of data in them. This article shows how to optimise column widths and row heights with a macro
openoffice.org macro tutorial developing macros format spreadsheets optimalwidth optimalheight writing openoffice macros

OpenOffice Macros: Open, Save and Close a File
One of the most useful things that an OpenOffice.org Basic macro can do is to open, save and close a document. This article shows exactly how to do that.
macro to open an openoffice document macro to save an openoffice document macro to close an openoffice document openoffice calc macros openoffice automation

Using Macros to Automate OpenOffice.org Calc
OpenOffice.org Calc can be automated very easily by introducing macros - simple scripts that will do all of those laborious tasks
automate openoffice.org automate openoffice.org calc write a macro openoffice.org calc macro calc macro

Automating OpenOffice: Customizing the Toolbar
Many tasks can be made much easier by using macros in OpenOffice.org. That process of automation can be improved even more by customizing the OpenOffice.org toolbars.
openoffice.org macros openoffice.org toolbars openoffice.org customization openoffice.org toolbar buttons add openoffice.org button

Programming OpenOffice: Using Dialogs in Macros
OpenOffice is a powerful suite of tools, and creating Basic Macros makes it even more versatile. Adding dialogs just gives it that human touch.
openoffice.org automation custom dialog box openoffice dialog box openoffice forms openoffice gui design

The 5 Steps to Creating an OpenOffice Macro
OpenOffice Macros can appear intimidating to start with, but they're not - in just five easy steps any user can start developing their own macros.
creating openoffice.org macros writing macros calc macros writer macros basic macros

Automating a Report in OpenOffice.org Calc
This tutorial shows how just a simple macro can automate the production of a complex report in OpenOffice.org Calc
openoffice macro tutorial how to write an openoffice macro automating openoffice programming macros writing macro basic code

Programming OpenOffice Calc Custom Dialog Boxes
This tutorial shows you how to make your OpenOffice Calc users jobs a lot easier by introducing your own custom dialogs and macros.
openoffice dialogs and macros calc dialogs and macros openoffice calc dialogs and macros programming openoffice clac programming basic macros and dialogs

Programming OpenOffice Calc Macros and Buttons
Adding buttons to an OpenOffice Calc spreadsheet will enable users to run macros and will provide them with clean and efficient interface.
openoffice calc buttons openoffice calc button openoffice calc buttons macros openoffice calc button macro add macro button

OpenOffice Macros: Accessing Calc Cells
This tutorial shows how to do one of the most important things that an OpenOffice Calc macro must do - reading from (and writing to) cells.
openoffice calc macros macro to access cells thiscomponent getcellbyposition getcellrangebyname

Automating OpenOffice: Customizing Key Strokes
It is possible to assign macros to various keys in OpenOffice, but not all of them. However, introducing a Listener allows a user to customize any key stroke.
openoffice listener key strokes macro key strokes customize openoffice keys openoffice customization keys macro openofficelistener macro

OpenOffice Macros: Printing a Document
One of the most fundamental thing that any OpenOffice user will want to do is to print a document. This turorial shows exactly how to do this - automatically from a macro
openoffice macros printing printing documents macro openoffice macro programming printing calc documents printing writer documents

OpenOffice Macros: The Worksheet_Activate Method
OpenOffice.org Calc does not have a Worksheet_Activate method, but don't let that be a show stopper when migrating from Microsoft Excel.
microsoft excel worksheet_activate openoffice calc worksheet_activate openoffice calc macros migrating from microsoft to openoffice migrating from excel to calc

Assigning Macros to OpenOffice Events
This short tutorial shows how to use OpenOffice's built-in events to automatically run a macro
macro assign event macros assign events openoffice macro event calc macros calc events

Creating an eBook
e-Books have the same type of sections as a printed book. The dimensions are smaller and the use of graphics is more liberal. Many e-Books use the .pdf format. These down
ebooks word processing software openoffice books fonts

OpenOffice Macros: Formatting Calc Cells
This article shows how to use a macro to alter the format of text in OpenOffice.org Calc cells - so that a fully formatted report can be created at the touch of a button.
openoffice.org calc macro programming automating openoffice macro format cells macro format cells sheet row column calc cell font color colour

OpenOffice Macros: Identify the Operating System
Operating Systems such as Windows and Linux do operate in different ways. This article shows how a macro can tell the difference.
openoffice.org macros operating systems windows and linux cross-platform programming windows and linux file systems

OpenOffice.org Macros: Working with Hidden Files
Macros can be useful when it comes to processing lots of files. This article shows how a macro can be used to open a document without the user seeing anything at all.
openoffice.org macros macro programming and development document property values loadcomponentfromurl. macro hidden documents hide a file with a macro

Using Combo Boxes with OpenOffice Calc
The addition of a Combo box to an OpenOffice.org Calc spreadsheet can greatly improve it's user friendliness. This tutorial shows exactly how to make that happen.
openoffice calc combo boxes adding a combo box to a calc spreadsheet spreadsheets and combo boxes improve spreadsheet user friendliness combo box tutorial

Using Vlookup in OpenOffice.org Calc
Vlookup is one of the most useful, but least understood, functions in OpenOffice Calc (and Microsoft Excel). This tutorial will show you how to use it effectively.
openoffice calc vlookup microsoft excel vlookup calc functions vlookup vlookup search data vlookup search range

Writer vs Word
Writer vs. Word, which one will you use? Two different word processing systems that produce the same end result, one is free, the other is not.
computer software microsoft office computer training microsoft office 2003 online computer courses

Using Yahoo! Financial Stock Quotes
Yahoo! Financial stock quotes are free, on-line and can be accessed either via the Yahoo! web site or downloaded into Microsoft Excel or OpenOffice.org Calc
yahoo! finance stock quotes personal finance microsoft excel openoffice.org writting macros

A Certificate for Dad
Surprise your dad with this certificate designed especially for him. Everything you need is here, except the paper and frame.
computer software microsoft word word processing openoffice corel word perfect

A Certificate of Roses
Is there a special woman in your life that you would like to thank in a memorable way? Give her roses that will last forever. Create a certificate of roses.
computer software certificate roses special transparency

An Introduction to Google Finance
Google Finance is still in Beta mode, but it's an excellent source of finacial data. This article shows how programmers and analysts can access that on-line and free data
google finance stock quotes download financial data programming with financial data microsoft excel openoffice.org stock quotes

Certificate Graphics for Dad
Does your dad have everything? Well, he does not have this certificate. Create this 2-part certificate for him and he will be so happy!
computer software microsoft word openoffice corel word perfect lotus notes

Web-Based Offices
Share your documents and spreadsheets instantly with anyone in the world, with Google's Docs & Spreadsheets. Google has everything a virtual office needs, and it's free.
computer software web based documents microsoft google free

Speadsheets for Your Budget
Spreadsheets simplify creating a budget while organizing planned income and expenses, and you have many good spreadsheets to choose from.
budget spreadsheets budget planning budgeting spreadsheets debt reduction

Absolute and Relative Cell Addressing
This tutorial shows how to create a monthly mortgage repayment calculater in Excel or Calc, and how to simplify it by using absolute and relative cell referencing
excel calc absolute cell reference excel calc relative cell reference relative cell referencing absolute cell referencing complex formula

Budget Templates for Spreadsheets
Get spreadsheet templates andd learn how to use spreadsheet budget templates to simplify creating a personal or household budget.
personal budget household budget budget spreadsheet spreadsheet templates budget forms

Open Source Software Sources
Open Source is one of the best kept secrets. The Open Source movement is in full swing and more not-for-profit companies are starting their own projects.
open source office wikipedia projects legal and social issues

Computer Tips for the Small Business Office
Computer Hints and Tips to help small businesses maintain and improve their computer systems at a reasonable price.
small business computers computer systems monitors printers

Free Small Business Software
When a small business has a tight budget, it can be hard to afford hundreds of dollars for software. Free business software can help.
home office accounting software microsoft office accounting software business related software home office desktop processing software free word processing software package

Holiday Buying Guide
Stuck on what to give that special Welsh-learning someone? Putting together a wish list for Siôn Corn? Take a look at these suggestions.
welsh gifts holiday shopping

Mac Programming - an Introduction
The Macintosh provides many ways to automate tasks. Whether you're a beginner or an expert, you'll find that all the programming tools you need come with every Mac.
mac programming languages how to program a mac programming on the macintosh learn to program on a mac writing programs on a mac

Price Books - Word Processsed
Price books are an important personal budgeting tool for comparing prices, and making your own pages for a price book is easy with these instructions.
make a price book grocery savings comparing prices frugal tips find the best prices

Productivity Software by Google
For the small business owner who needs productivity tools but doesn't want to invest in MS Office, Google Docs is an option to be considered.
google docs productivity software spreadsheets word processing software as a service

Teach Database Use
Databases have become an integral part of computer use. No matter which software is used, students need to understand the fundamentals of database use and creation.
teach database technology integration database basics database software schools database software students

Top Free Web-Based Word Processors
Web-based word processors provide convenient alternatives to traditional word processors. Now anyone can write, save and share documents online, for free.
word processors online word processors web-based word processors free documents google docs

Wget: Downloading from the Internet
This article looks at how to download on-line data such as Yahoo! Finance's stock quotes without the need of a web browser - all through the power of Wget.
yahoo! finance stock quotes wget wget options internet download

Currency Conversion with Yahoo! Finance
Yahoo! Finance is an exellent source of information such as stock quotes - but that's not all. This article looks at how to use Yahoo! Finance's currency conversion.
yahoo! finance currency conversion currency converter ajax programming php programming


| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | 0-9 |