The "Of Zen and Computing" blog has a nice article on Linux and open source and just what the deal is.
Cite This Blog
Train Your Organization
« October 2006 | Main | December 2006 »
November 2006
November 30, 2006
November 29, 2006
Applying and Creating Arrows in Draw, Including Unfilled Arrows, and "Arrows" From Special Characters (Repost)
Note: I've been having a dickens of a time getting all my posts to show up as searchable in Technorati. Thus, a repost of this Draw blog.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sure, you like the nice little triangles and double arrows in the list of arrowheads you get with OpenOffice.org. They're nice. They point.
But sometimes you need a little something extra. Something fun, something for your schematics, something for your UML diagram (UML is a little tough to do, more on that in other blogs), something you just need.
Here's how to create your own arrows, or line ends (I'll be using the terms interchangeably).
First, though, the basics. How do you apply them? How do you get the line ending, the arrowhead, of your choice, onto a line?
Applying Arrows and Making Them Big Enough to See
You have a line. You want to put an arrow on the end or you want to change it. How do you do it?
First, draw the line with any of the line or curve tools on the Drawing object bar. Be sure it's selected.
Then apply the line end. The quick way is to click on the dropdown list at the top of the work area, and just select what you want for each end of the line.
However, the default size of the line ends is really small. You'll usually need to make the end bigger. So select your line, choose Format > Line, and in the far more powerful window that appears, select your line end styles. Select the size, and while you're at it you can change line styles too. Click the image below to see a bigger version of the window.
Loading the Extra Arrows
The arrows that OpenOffice.org comes with are stored in .soe files, usually in your openoffice.org\user\config directory. There are two by default; you can only have one loaded at once.
NOTE: You can put all your line ends that you create yourself in a separate one, if you want. More on that later.
The style files are arrowhd.soe and standard.soe. Standard.soe has hardly any. Arrowhd.soe has a bunch more. To load a different style file, choose Format > Line, click the Arrow Styles tab, and click the Load Arrow Styles icon.
In the dialog box, select a different style file and click OK.
Creating a Basic Arrow
Here are the rules. You can create a line end with any character, polygon, contour, curve, or line in OpenOffice.org. This means most of the shapes in the drawing toolbar, like the puzzle piece, though some like the smiley face won't work. However, basically if you just draw anything using the drawing tools, it'll work.
All of these will work as line ends. The first three will end up filled.
If you find yourself with a shape that you think should work but doesn't, or just a shape you want to use of the wrong type, convert it to the correct type. Select it, right-click on it and choose Convert, and select Polygon, Curve, or whatever works for you.
You can also use the line tools to draw filled shapes, like the angled straight-line tool that I used to draw this clumsy-looking crown shape (drawn with grid showing).
When you draw a shape, you might want to have the grid on so it'll look reasonably regular. Choose View > Grid > Display Grid, and Snap to Grid as well.
So let's assume you've got your shape. I'm going to use the crown. Draw the shape right-side-up, by the way.
Select the shape and choose Format > Line. Click on the Arrow Styles tab. The Add button should be enabled; if it isn't, you don't have the right kind of shape drawn. Click the image below to see a bigger version.
Click Add, and name the line end something. (The line end will be saved in the currently loaded .soe file.) Click the image below to see a bigger version.
Click OK, and you'll see a preview of
what the shape is like. Click the image below to see a bigger version.
NOTE: Line ends are always filled unless you go to great lengths to avoid that. I cover that later in this post.
Click OK.
Now the shape will show up in the lists with the other line ends.
Creating an Arrow With a Special Character (or Any Letter)
If you want an arrow that's shaped like the greek symbol for pi, you can do it.
Use the text tool to draw a text box.
Click inside the text box and choose Insert > Special Character. Find the symbol you want and click OK. (Or just type a Z or a W or whatever character you want.)
Make the character bigger if necessary with the font size dropdown list, and change the font as well if you want.
Select the text box, and then just create the line end as I described above.
You can't use a word as a line end, by the way, just a character.
Here's a couple lines with the pi ending and another special character.
Creating Your Own .soe Line Styles File
If you want your own styles in a separate file, here's what you do. Before you start creating, just choose Format > Line, click the Arrow Styles tab, and click the Save File icon. Name the file something like mystyles.soe and click OK.
That new styles file is now loaded, with the default arrow styles from the standard.soe file. Now just create your line ends as you would normally.
Draw a Line With an Arrow in the Middle
You can't actually do a single line with an arrow in the middle. But you can do two lines, with an arrow at the end of the first one. To make sure they don't separate when you move them, use the connector lines.
Here's the connector line palette.
Here are two connector lines, creating the impression of one line with an arrow midway through.
Creating Unfilled Arrows
Thanks to the clever folks in this discussion, I discovered that you can fool Draw into thinking something's closed. Well, it is closed, but you do it all a little differently. This approach is a bit of a pain in the tookus but it works, and once it's done, it's done.
Display the grid; choose View > Grid > Display Grid.
Use one of the two straight-line drawing tools; the squarer one is better.
Draw a triangle for this practice run. Start drawing a normal triangle, but instead of connecting after the third line, double back as shown.
Then complete the triangle so that it's actually a very long thing rectangle bent twice to form a triangle.
Click the Edit Points icon on the Drawing toolbar at the bottom of the work area.
Zoom into about 400%. (Choose View > Zoom.)
Drag each of the two points of the disconnected end toward the other line, so they're almost but not quite touching.
Zoom back out. Click the Edit Points icon again to turn off that function.
Now just create the line end as you normally would.
Here's a picture of the triangle, and a line with the line end applied.
Note that with unfilled shapes, you get the line intruding into the shape very slightly. (Mark Center in the Lines window to change it from definitely intrusion to very slight intrusion.)
In the Name of All That Is Holy, Use Graphics Styles
Once you've got a line that you like, with the ends you like, the size you like, with the line width and type you like, etc. that you're going to reuse, SAVE IT.
NOTE: Graphics styles are like the paragraph and character styles in Writer, and combine all these attributes as applicable. Your specific arrows that you create are also called arrow styles, and are saved in the .soe file that's loaded when you create it. But when you're combining a bunch of line and arrow types and widths and sizes, then those attributes are stored in a graphics style in the Styles and Formatting window. That's what I'm talking about here.
Select your line and choose Format > Styles and Formatting. Click on the New Style From Selection icon with the green + sign.
Name the style something and click OK.
Now, the next time you want that kind of line, draw the line, select it, choose Format> Styles and Formatting, and find the style you created in the list. Double-click the style name. All that painful formatting you did last time will be applied instantly this time.
Styles you create stay in the document you're in. To get a line style from another Draw document, just copy a line with that style, or use templates (which is a whole nother topic).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
That's all there is to applying and creating your own line ends! Simple, huh? 
Creating Automatic Backups and Specifying Where They're Located in OpenOffice
Always have a backup. That's up there with wear your seatbelt, eat your vegetables, and always have cab fare on a first date.
OpenOffice.org has a backup system that lets you create a backup copy of your documents, anywhere you want. Not a bad idea, eh? Here's how you do it.
1. Choose Tools > Options > Load/Save > General.
Mark the checkbox for always making a backup.
2. In the same big window, open the OpenOffice.org category. Click the Paths option and select the Backups item. This is where the backups will be created. If that's fine, leave it as is.
If you want the backups elsewhere, click Edit, specify the new location, and click OK.
3. Click OK to save all the changes you made in the settings window.
For every new document you create, then each time you edit that document, a backup of the previous version will be created. Your backups will be created with a BAK extension in the location you specify.
November 28, 2006
November 27, 2006
Share Your OpenOffice Impress Slides: Sharepoint, O3Spaces
OpenOffice.org Calc and Writer have the usual editing features that let you send files out for edit and get redlined comments back from anyone who reviewed it.
However, not so much for Impress presentations. Not within OpenOffice, anyway. Fortunately, there are a few ways around this, including SlideShare. They support OpenOffice.org Impress files as well as PowerPoint. You can share, tag, and get comments back.
You can also take a look at this extension for OpenOffice Impress. O3Spaces works by providing users a single web-based team environment, with built-in search capabilities and an optional Java-based Desktop Assistant.
Their web site says "O3Spaces technology enhances OpenOffice.org and StarOffice with an integrated solution for Collaboration, Document Management and Document Retention within teams and small businesses. O3Spaces provides the OpenOffice 2.0 and StarOffice user community with a professional out-of-the-box extension for team and project collaboration, O3Spaces means an affordable and integrated alternative for MS Office Sharepoint."
Read more.
http://linux.wordpress.com/2006/11/23/openoffice-extension-rivals-sharepoint/
November 22, 2006
November 21, 2006
Jumping to Particular Spots, and Rearranging Content, in an OpenOffice Writer Document, and Using Draw
Moving Around Easily Between Sections in the Navigator
I saw this question on LiveJournal by madscience but couldn't post an answer because of the Friends Only setting. I thought it was a good question, though, so I'll post it here.
"Is it possible to set up chapters or sections in an OpenOffice Writer document so that I can jump to them easily, like maybe with tabs or a tree like some PDFs have? I found something called "sections" in the documentation, but it doesn't sound like what I'm looking for.'
Definitely. Press F5 and you'll see the Navigator window.
You can expand the Headings option and just double-click the heading name to jump to that part of the document.
(This is only if you've used the Heading1 through Heading10 styles, or if you've used other styles for your headings and set them up at the right levels under Tools > Outline Numbering.)
You can also jump to anything listed in that window that you have set up--graphics, bookmarks (Insert > Bookmark), cross references, notes, etc.
You're right, sections aren't what you want, but if you have them you can double-click them in Navigator and go to them.
Rearranging Sections in Writer by Moving Headings in the Navigator
You can move one section of your document to an earlier or later part of the document easily in the Navigator too. Again, you need to have applied paragraph styles to your headings such as Heading1, Heading2, etc.
In the Navigator, just select the heading for the section you want to move.
Then click the Promote Chapter icon or the Demote Chapter icon as many times as needed to move the section to where you want it. In this picture, the 1950s and Bread section now comes before Romans and Bread.
Other Good Alternative Open Source Software
Another question from LiveJournal from fadedletterlost
"Alternative Software
I love alternative software, especially when it is a piece of free
software that does basically the same function as a far more expensive
version. What are some good alternative softwares that you have found?
MS Office alternative: OpenOffice
Photoshop?
Movie Creation Software?
First Person Shooter?
So on and so forth..."
A lot of people do stuff in Photoshop or Gimp that is easier to do in OpenOffice Draw. (File > New > Drawing.) If you're doing diagrams or anything that's not direct raster editing, do it in Draw, then export to EPS, JPG, PNG, whatever.
You do have slight raster control in Draw -- adjust RGB, make things B/W or grayscale, control contrast and lightness, etc.
November 20, 2006
Searching and Replacing: Replacing One Style With Another, in OpenOffice
I wrote this blog about how to rename styles in your current document to match the style names in a different template or document, then import styles from that different template or document to update the definitions.
Now, that's a reasonable approach. More or less. Renaming can be useful also if you just realize, d'oh! you really should be renaming things something like Directive_Heading, Directive_Text, rather than Textfordirectives and headingtouseindirectives. It's nice to have all the styles you use together sorted together alphabetically.
But unfortunately the Nancy Drew in me is sometimes drawn more toward hacks than to regular ol' features already there in the software.
Felipe wrote to that post and said "Is there a way to search and replace styles?"
And I slapped myself on the forehead and said, "Well, yes, that feature DOES exist and that would, OK, be a perfectly reasonable way to deal with replacing one style with another."
So here's the scenario.
You have a wonderful document with great styles.
But then Bob the Annoying Boss comes along and says "You need to use THIS template with THESE styles."
If all the names of the styles were the same you could just import the styles and be done with it. BUT the styles in the template are DIFFERENT so it's not that simple.
What do you do?
Follow the instructions in this blog if you want to try that approach to rename the styles in your document to match the ones in the template.
Or just search for your style names, and replace them with the style names from the template.
Here's how to do the second one.
Step 1: Import styles from the new template
Open your document.
Choose Format > Styles and Formatting.
Click and hold down on the far right icon and choose Load Styles.
In the next window, mark all the checkboxes and click From File.
Find the file with the styles you need to use and click Open.
That document's styles will show up in your Styles and Formatting window.
Step 2: Search for Your Styles and Replace With the New Styles
Be sure you're in your document.
Choose Edit > Find and Replace or just press Ctrl F.
In the Find and Replace window, click More Options and select only the Search for Styles item. NOTE: An alert reader, Julian, has this warning. "The option
to search for styles disappears if you have specified some formatting in one of the search
or replace boxes. Clicking No Format brings it back."
In the first dropdown list, select the style in your document, and in the other dropdown list, select the style you just imported that you want to replace the existing style with.
Click Find, then Replace as appropriate. Or if you're feeling confident, click Replace All.
Repeat for each style you need to replace.
You'll see that the old styles have been replaced by the new styles. (In this illustration, the style ChapterTitle used to be applied, and it looked like the style illustrated near the top of this blog.)
November 17, 2006
Making Life Much Easier in OpenOffice Writer by Selecting Non-Consecutive Pieces of Text
I've mentioned this in the context of various articles before but I don't think I've really zeroed in on it before.
Selecting text and formatting it, whether manually or with styles, is one of the standard tasks you do every day. Let's say you've got a few notes, interspersed in your document, that need to be bold. They're not consecutive so you select one, then apply formatting; select the next then apply the formatting again and so on.
Select, apply; select, apply. It's one of each.
Or IS it???
You can select a bunch of pieces of text that aren't next to each other, and then apply whatever formatting you like. (Or delete all the pieces of text, or do anything.)
So:
1. Select the first piece of text. (If you're applying a paragraph or list style, you just need to select a part of the paragraph.)
2. Hold down the Ctrl key and keep it held down.
3. Select the next piece of text.
4. Select the next piece of text.
5. When you're done, release the Ctrl key.
6. Now apply the formatting or just generally have your way with the text.
7. You'll see the formatting change.
8. Click somewhere else in the document to deselect the text.
November 15, 2006
Getting Data Back Out of OpenOffice Base
Note: Having clearly labeled import and export features for Base has been proposed and you can vote for it by clicking one of the following links. Here's how to make things work until the features are implemented and put into the next build.
Vote for adding a wizard to import data into Base
http://qa.openoffice.org/issues/show_bug.cgi?id=51904
Utility to export CSV from Base
http://wiki.services.openoffice.org/wiki/CSV_export
Here's the related article on the cleverly disguised import function, for getting data from a spreadsheet, Access, or another database into an OpenOffice Base database.
http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html
November 13, 2006
Styles Hack: Importing a Template With Completely Different Style Names, in OpenOffice Writer
NOTE: You can also search and replace for styles. Open the search and replace window, click More Options, select the Styles checkbox, and go nuts. I have blogged more on this here. Thanks to Felipe for reminding me of this.
Maybe I should have thought of this years ago. Maybe I just hadn't thought about it all that hard. But regardless, I had a realization this morning while brushing my teeth that makes importing a new template much easier.
So. You have a grrrreat document on what makes squirrels look so cute when the sit up and eat nuts. And you need to submit it to the Journal of Squirrel and Possum Research.
You've applied all sorts of styles from your best template. Styles like ReportHead1, ReportHead2, StrongNote, PlainNote, BodyText, ListDiamondBullets, etc. You've got about 20 styles and about 100 pages.
And now you get the note from the JoSPR and they love your article, but they want it in their template.
No problem! you cry as you swig a celebratory jigger of apricot brandy that you keep in your desk drawer for just such occasions. You open your document, import styles, find the template, click OK, and boom......
OK, no boom, just a whimper. You get all those new styles but guess what? Nothing changed because when you import SquirrelHeading1 into a document that uses ReportHead1, nothing about ReportHead1 changes.
Agh!
Do you need to go through the whole document and apply the JoSPR styles? Isn't the whole point, or one of the key points, of styles, is that updating them is soooooo easy?
No, and yes. IF YOU USED YOUR OWN STYLES RATHER THAN STYLES THAT CAN'T BE RENAMED LIKE HEADING1 THROUGH HEADING10 THEN IMPORTING DIFFERENTLY NAMED STYLE DEFINITIONS ISN'T THAT BAD
If you used your own styles, all you need to do is rename the styles. And then when you import, you're golden because when you import SquirrelHeading1 (20 point, Albany font) into a document that uses SquirrelHeading1 (18 point, AvantGarde font), then all of a sudden SquirrelHeading1 does in fact change to the new definition. And alllll text with that style applied changes, too.
Here's what you do.
Figure out if you've applied existing styles that are part of every Writer doc, like Heading1 through Heading10, or if you've applied styles you created yourself like ReportHeading1. If the former, then you do have to just import all the styles and then reapply. If the latter, then you're good.
Renaming Styles
Use this procedure if you can rename the styles you used. If you don't know, try this procedure and you'll find out.
1. Open your document.
2. Go to the text with the first style you want to rename, like ReportHead1. Select that text.
3. Choose Format > Styles and Formatting.
4. In that window, be sure the correct category, Paragraph or another, is showing. Click the appropriate icon at the top.
5. Right-click on the style name and choose Modify.
6. In the style window, click the Organizer tab.
7. Rename the style; name it whatever is in the new template that corresponds to this style, like SquirrelHeading1.
8. Click OK.
9. Now, all the text that used to have the style ReportHead1 applied to it now has the style SquirrelHeading1 applied to it.
10. Rinse and repeat for all the other styles you need to rename.
All you need to do now is import the right definitions from the new template.
Importing Styles
1. Open your document.
2. Go to the text with the first style you want to rename, like ReportHead1. Select that text.
3. Choose Format > Styles and Formatting.
4. Click and hold down on the far right icon and choose Load Styles.
5. In the window that appears, select all the checkboxes.
6. Click Find File.
7. Find the new template and click Open.
8. Now all the new style definitions have been imported and all the text should look different.
(If you used un-renameable styles, then at this point you need to go through and reapply the new styles. Sigh.)
November 09, 2006
Restarting Numbering in OpenOffice Writer: Yes, Virginia, There Is a Way to Do This Without Manual Labor
OpenOffice Writer numbering is powerful but it lacks at least one very important feature.
(I’m not saying Word numbering doesn’t suck. I think it does. )
Now, it’s not all bad. Anyone doing a nice little shopping list like this is going to have no problem.
Beer
Light
Dark
Bread
Rye
Russian
Scandinavian
White
To get lists like this, just type the list, select the list, click the Numbering icon to turn numbering on, press Tab to indent each item as far as it needs to go, then select the whole list and in the Options tab select the numbering type you want at each level.
However, what do you do if you want this? AND let’s say you have about a hundred of these and combine them in the same master document?
Directive on Parking
Parking shall be completed by 8:30 AM each morning.
Parking shall be performed in the following lots
Lot A, except on Mondays
Lot B
Lot Q on weekends
Directive on After-Work Parties
Parties shall follow these guidelines
Parties shall last no longer than three hours
Parties shall be catered for no more than $300
Parties shall provide bus service home as necessary
Parties shall take place no more than five times a year
When I first typed up the Directive on Parking part in OpenOffice, composing the blog before I posted it here, it actually looked like the following: the top-level numbering for the directive on parking continued from the bread list, even though it was totally separate.
Imagine a 100-page document or a 100-document book where you have to go back and fuss and curse over restarting the numbering.
The trouble with using regular ol’ numbering is multi-fold.
There Are Problems With Trying to Do Complex Numbering in Big Projects, Especially Relating to Restarting Numbering
Restarting the numbering where and when you want it is hit and miss. Sometimes it works; sometimes it doesn’t.
To restart numbering, you need to click the Restart Numbering icon, or alternately use the Paragraph formatting window. Here they are.
NOTE however that this restart attribute is NOT available when you create a paragraph style.
This all means that you cannot apply restart-iness with styles. You can only apply it manually.
[I have tested the following issue moderately with 2.1 and it does not SEEM to be a problem. Test with your documents.] Also, here’s the kicker. When you import new styles, at least some of the time, the manual settings, aka the restartiness, are kablooied and you need to set them all over again.
[I have tested the following issue moderately with 2.1 and it does not SEEM to be a problem. Test with your documents.] Did I say the kicker? That was a kicker. There’s another even bigger kicker. Importing the styles also often kablooies all the indenting you did to get, say, Rye bread down to level 3 or the party rules down to the level they’re at. You can get around this by using a separate paragraph style/numbering style combination for every level but you still end up with the problem of manual restarts.
You could consider using outline numbering; however you cannot restart the numbering if you are going to combine multiple documents in a master document. Also you have only the most basic control over the distance from the number to the text. (Tools > Outline Numbering. See also http://openoffice.blogs.com/openoffice/2006/10/in_praise_of_ou.html )
So what the heck is the solution?
There Is A Solution If You’re Willing to Do Things Completely Differently
The solution comes from my colleague Jean Weber, at www.jeanweber.com. She has an excellent book on Writer, including high-end complex issues like this.
Here’s the link to the OOo doc, to which she contributed. http://documentation.openoffice.org/manuals/oooauthors2/
Here’s a link to her book on Amazon. http://www.amazon.com/OpenOffice-org-Writer-Free-Alternative-Microsoft/dp/0596008260/sr=8-1/qid=1163013762/ref=pd_bbs_1/002-0539644-5923228?ie=UTF8&s=books
Here’s a link to the file you’re going to be using to solve this problem. http://documentation.openoffice.org/manuals/oooauthors2/0214WG-WorkingWithFields.pdf
What you do is, you create a numbering series of your own that has nothing to do with the normal numbering.
I’ll leave the particular details to Jean’s guide; go to the section called Defining your own numbering sequences. Here’s what you need to accomplish.
1. Create a single number range for every level. For instance, if your top level is regular Arabic, your second level is Alphabetic, and your third level is lower Roman, then create a single number range for each of those called Arabic, Alpha, and Roman (or one two and three, or Larry Moe and Curly, or whatever). Choose Insert > Fields > Other, click the Variables tab, choose Number Range on the left, and the rest is pretty clear. Jean's guide provides lots of nice detail for this.
2. Create paragraph styles with the indenting you want, one style for each level. The paragraph styles are what will take care of the indenting. You also need to set up the correct tabs since you’ll press Tab between the number range and the text.
Here are examples for levels 1, 2, and 3. In this formatting example there’s an indent of .3 inches from the left margin of the document for all text. Also the distance from the number to the text is .3 inches.
Level 1 (plus set a .3 tab in the Tabs tab)
Level 2 (plus set a .3 tab in the Tabs tab)
Level 3 (plus set a .3 tab in the Tabs tab)
3. Start inserting the numbers, just anywhere in the document. You're going to insert them, then make shortcuts so that you can insert them more easily.
Choose Insert > Fields > Other, select your top level variable such as Arabic, specify 1 in the Value field, and click Insert.
Now create your ArabicContinued field. Press Return or just make a space or two. Still in the Fields window, delete the 1 from the Value field, and click Insert to insert another field of the same range. It’ll show up in the document as 2. Click Insert again if you want to prove it's working; it'll show up as 3.
DO NOT set up different variables here for the regular and the restart. They need to have the same name.
Do the same for the first item and the next item at all the levels you’re using.
4. Apply the appropriate paragraph styles to each number range you're using. If you created a paragraph style called TopLevelNumbering, apply it to all the Arabic fields (or whatever you're using at the top level). Also press Tab to insert a tab after each number.
5. If you have a lot more work to do, you want all this inserting stuff to be easier so make AutoTexts.
5.a. Select the first top-level numbering item, the Arabic one that equals 1 and the tab. (Not crucial, but as long as you're saving yourself some work, you can make the tab show up automatically, too.) Be sure the appropriate style is applied so that you can bundle the number and the correct style into one convenient autotext.
5.b. Choose Edit > AutoText. Type a name like ArabicRestart, make the shortcut something obvious like AR for ArabicRestart. Click and hold down on the Autotext button and choose New.
5.c. Repeat the steps for the next number at that level, the one that doesn’t have 1 as the value. So select the field that shows 2 in your document, choose Edit > AutoText, and call this one just Arabic or ArabicContinued. Make the shortcut something like A or AC.
5.d. Repeat those steps for every level.
6. Now just keep on formatting or typing your list by inserting numbers. Type AR F3 (the shortcut plus the key that says "insert the autotext with that shortcut" to insert a numeral 1 plus a tab. Type AC F3 to insert a sequential continuous number.
Note on inserting: You can't have the cursor immediately next to any existing text or the AutoText tool will get confused about what you want to do. There has to be at least a space between the cursor and any other text.
Alternately, if your list already exists, copy and paste the appropriate restart and continuous number variables to the appropriate spots, rather than using the shortcut keys.
In Conclusion
Is it wildly different from normal numbering? Yes. Is it complicated to set up? No more than any other complex numbering.
Does it offer much more reliability and control than other numbering in OpenOffice Writer, for complex lists? Yes, yes, oh god, yes.
November 08, 2006
Turning data into information with functions in OpenOffice Base
I've written an article for TechTarget on how to use the functions such as Sum and Max in OpenOffice.org Base queries and views.
It took me a while to grok how to use these -- the difficulty is not in applying the functions, but in the kind of data you can use the functions with, and the Group function that needs to be applied along with Sum, Max, or whatever you're using.
November 06, 2006
More on the Data Pilot: Analyzing a Data Source/Database
It's time for more data pilot adventures.
I blogged here about the data pilot. The example I used there was for analyzing data in your spreadsheet. You also, of course, have the option of analyzing, using the data pilot, any of your data sources. You'd want to analyze a data source rather than a spreadsheet for many reasons-- perhaps the data is in Access and not in a spreadsheet. Or the spreadsheet is just realllllly big and you don't want to have to open it every time you want to run data pilot on it.
Here's my sample data for this blog.
Just a nice basic set of data for a week. It's similar but different to what I used in the previous blog and more suitable for demoing the different options. Click to see it bigger.
The first step, of course, is to make sure you have a data source. (Or database—it's all kind of the same thing.) If you already have your data in Access or another database, you'd skip this, of course. However, let's say that this spreadsheet is extremely large and I need to make a database out of it to save time.
Here's what you do to create a database from a spreadsheet; using a different type of data is pretty similar.
1. Choose File > New > Database.
2. In the window that appears, select
the last radio button, and Spreadsheet as the type. Click Next.
3. In the next window, just specify where the spreadsheet is that you want to turn into a database. Click Next.
4. Unmark the Open for Editing option and click Finish.
5. Save the database with an obvious name. This is the name you'll be selecting from dropdown lists in OpenOffice.org.
Now you've got a database.
To analyze a database, start the same way as usual.
1. Open a new empty spreadsheet and choose Data > Data Pilot > Start.
2. Choose to use a data source already registered with OpenOffice.org. Click OK.
3. Select the data source name, then the sheet name (typically Sheet1) where your data is, and specify Sheet as the type of data. Click OK.
4. Now you're ready to drag fields into the layout area and set options as you have with other analyses. This time, I'm using the Date fields as the quick filter field, so I put it in the Page area. The rest is as pictured.
- I double-clicked the Units Sold field and selected Average. In the results, we'll see the average for each book and store, not the total.
- For options, I'm choosing to identify categories, and to sum rows and columns.
<>
Click OK.
Here are the results of the setup shown above.
November 01, 2006
Data Pilots (Pivot Tables) in OpenOffice Calc
Data Pilots are the OpenOffice Calc equivalent of pivot tables.
How do you use them? Very carefully. If you haven't used them before, it's just a bit of a mind-bender to get started--it's all about the data that you start off with. You start off with raw, plain old data, not data that you've already summed up.
I'm including a lesson here on how to use the data pilot. Download this file, datapilotspreadsheet, if you want to use the same spreadsheet I've used. (Don't worry if your numbers are a little off from the screen shots--I tweaked it a little along the way.)
1. Open a spreadsheet.
2. Click in the upper left corner of the data. Don't select the data; you don't need to.
3. Choose Data > Data Pilot > Start.
4. Choose to use the current selection, then click OK.
5. Here's the window you'll be working with. Just drag the fields where you want them, and click More to have more options. When you have things the way you want them, just click OK.
I'll show you a few examples: the setup, and what the data results look like.
NOTE: Click any of these images to see a bigger version.
Example 1
Here's what the setup looks like.
Click OK, and you get this data.
Click the Filter button and you can filter things out more -- say, just view invoices that are more than $5000, or whatever you like.
Example 2
Here's the setup. The Store window in the Page Fields area will give you a dropdown list so you can view all values, or one value at a time for the category in the Page Fields area.
Click OK and you get these results, with the option to use the dropdown list.
Select a different value in the dropdown list and you get different results.
Example 3
Here's the setup. As you can see the More section is displayed with different options.
Here's a closer look at those options. I specified that no total for rows or columns should be included, and that the results be put in Sheet2 in the upper left corner.
Here are the results you get with that setup.
Example 4
Here, I double-clicked the Sum-Amount field to get other function options. I'm going to choose Average for this example
Here are the results.
Double-Clicking a Field
You can see the detail rather than the sum or average if you double-click the name of a field. The following window appears.
Click OK in that window after making a choice and you get the detail. Double-click a detail field to go back to the regular view.
OpenOffice.org 2 Guidebook
GetOpenOffice Consulting
Categories
- Administration and Installation (5)
- April Fool's (1)
- Calc (90)
- Calc: 2008 (36)
- Calc: 2009 (15)
- Calc: 2010 (8)
- Certification (1)
- Charts (6)
- Charts: 2008 (4)
- Clip art (16)
- Clip Art: 2009 (3)
- Compatibility and Conversion (7)
- Compatibility and Conversion: 2008 (7)
- Configuration and Setup (4)
- Configuration and Setup: 2008 (12)
- Databases (39)
- Databases: 2009 (1)
- Databases: 2010 (1)
- Diagrams (13)
- Draw (20)
- Draw 2008 (8)
- Draw: 2009 (9)
- Draw: 2010 (1)
- Education (9)
- Envelopes (7)
- Equations (math) (4)
- Extensions (10)
- Filtering/Sorting (1)
- Fonts (4)
- Forms (7)
- Free Online OpenOffice Seminars (1)
- Free software (25)
- General (28)
- GIMP (7)
- Google (5)
- Grammar (1)
- Graphics (26)
- Graphics: 2008 (5)
- Graphics: 2009 (4)
- IBM (2)
- Impress (37)
- Impress: 2008 (12)
- Impress: 2009 (2)
- Impress: 2010 (1)
- Labels (24)
- Labels: 2008 (7)
- Libraries (2)
- Linux (34)
- Linux: 2008 (2)
- Macros (3)
- Mail merge (39)
- Mail Merge: 2008 (8)
- Mail Merge: 2009 (4)
- Mail Merge:2010 (4)
- Memory (2)
- Microsoft Office (58)
- Microsoft Office users (20)
- Microsoft Office: 2008 (4)
- Numbering: Headings (1)
- Numbering: Lists (5)
- Numbering: Page (10)
- Open source (185)
- Opendocument format (65)
- OpenOffice (362)
- OpenOffice books (326)
- OpenOffice training (323)
- OpenOffice.org (346)
- OpenOffice.org 3.0 (14)
- OpenOffice.org 3.2 (4)
- OpenOffice.org: 2009 (4)
- PDF (16)
- Podcasts (4)
- PowerPoint: 2008 (3)
- Presentations: 2008 (9)
- Presentations: 2010 (1)
- Printing (18)
- Printing: 2008 (2)
- Products and Services (1)
- Reader input (9)
- Regular Expressions: 2010 (1)
- Reports (2)
- Reviews (48)
- Spreadsheets (79)
- StarOffice (212)
- Styles (40)
- Sun (7)
- Switching to OpenOffice (88)
- Tables (18)
- TechTarget articles (34)
- Templates (28)
- Templates: 2008 (4)
- Thunderbird and Firefox (4)
- Tips (20)
- Training:free seminars and online training (1)
- Ubuntu (9)
- Web (11)
- Web software (6)
- Windows (2)
- Writer (117)
- Writer: 2005 (2)
- Writer: 2006 (2)
- Writer: 2008 (46)
- Writer: 2009 (9)
- Writer: 2010 (2)
- Writing (3)