openoffice templates community service log

#OPENOFFICE TEMPLATES COMMUNITY SERVICE LOG HOW TO#
#OPENOFFICE TEMPLATES COMMUNITY SERVICE LOG MANUAL#
#OPENOFFICE TEMPLATES COMMUNITY SERVICE LOG ARCHIVE#
#OPENOFFICE TEMPLATES COMMUNITY SERVICE LOG CODE#

In this entry, I'll go through how to use the Format tab to tweak a particular layout, then save it for re-use.

#OPENOFFICE TEMPLATES COMMUNITY SERVICE LOG MANUAL#

In this entry I talked about a fairly straightforward but manual way of giving your labels a little room to breathe. (The illustration cuts out the bottom half of each page for space reasons you would have an entire page for each person.) Then you open that Writer document, check it over a bit to be sure it's what you want, then print that as you would any other Writer document. This creates a perfectly ordinary Writer document with all the fields merged, one copy of your original mail merge document for each record you chose to print by. When you're done, just print as usual I recommend selecting File, and Save as Single Document. You can also remove any filter or sort with this icon. To turn off the standard filter, click the Apply Filter icon to get the filter back on, click it again. It looks like they're not available, but they are. NOTE: The AND/OR fields in the 2nd and 3rd rows aren't enabled until you select something to filter by in those rows. If you want a little more control over the filter, click the Standard Filter icon. Click the AutoFilter icon you'll get all the records that match that value. One single value, like the city where one person is from. To use the quick autofilter, click on a particular cell in a row. Or if you just want a quick sort-by-one-field thing, click on column of your choice, then click the A>Z or Z>A icon to sort ascending or descending. Just choose to sort by a field, up or down, then others if you need to. Here's what you get when you click the Sort icon. You choose File > Print, click Yes in that little window that asks you about a form letter, and you get the print window. You know how to print a mail merge letter, envelope document, or label document. Just specify what you want, when you print. You could, it would be fine, but it's more work than you need to do. You don't need to go into Base or Calc and sort the information. You don't need to set up a query ahead of time in Base or in Calc.

#OPENOFFICE TEMPLATES COMMUNITY SERVICE LOG CODE#

Or let's say you need to print labels for everyone but you need to do it in order by zip code or the people at the post office are going to be very annoyed. You need to send out a letter reminding people to, oh, sign up for benefits, or renew their membership, or maybe it's just a congratulatory letter for some people who have five years of service now and are going to get that sterling silver ice bucket they've always wanted. So you've got 2000 employees, or members, or whatever. If you have questions about the code, use the Macro/API forum.ĭDE_Logger.zip 2 templates, 1 demo database, 1 demo source sheet and 1 documentation file (105.I hate it when I blithely skip by fantastic built-in features. I have nothing to test right now.įor detailed instructions read the documentation file and don't hesitate to ask questions in the Calc forum. I deduced this info from the MySQL documentation. If not, you can change the following line. MySQL should work out of the box if If the ANSI_QUOTES SQL mode is enabled. Then hit Ctrl+Shift+F9 or reload the document. It is definitively safer to store your data in a database.Īfter changing the DDE source it may be (sometimes?always?) nessecary to clean up the DDE links. At one log row every 3 seconds you hit the row limit after 36 days of logging. Mind that the spreadsheet log constantly writes data into a spreadsheet which consumes memory and needs manual saving from time to time. The database log has been tested successfully with embedded and external HSQL in both office suites and with dBase in OpenOffice4.

The database log does not work with dBase connections in LibreOffice. It may serve you as a first demo.Ī self-contained database document serves as demo database for the database logging. A third spreadsheet document served me as an example source for testing.

The macro code reads configuration data from named cells and cell ranges. You can move around cells and rename sheets as long as range names remain intact. This is about two spreadsheet templates with Basic macros logging incoming DDE data either to a spreadsheet list or to a registered data source.

#OPENOFFICE TEMPLATES COMMUNITY SERVICE LOG ARCHIVE#

The full documentation can be found in the attached zip archive as a more readable text document

Openoffice templates community service log