NCS Auction and OpenOffice 3.2

I didn't think this had a chance of working, but I am awfully glad it did. I am one of the head technology geeks for our upcoming school auction and needed a way to generate the Silent Auction bid sheets as automatically as possible from a database of auction items. We are completely Microsoft Office based which is both good and bad. Good because we can be very creative with the tools and the knowledge about the application is very diffuse; bad because not all of the laptops we have are not going to have an install of MS Office. Well, in order to run the MS Access database on the day of the auction (to manage bidders and winning bids) I found an MS Access 2007 runtime that seems to perform admirably enough for us not to have to worry about having Access installed on all of the machines at the auction. This will save us a bunch of headaches and is probably the biggest piece of the puzzle we needed to get this whole thing running well. The second piece was the use of OpenOffice (OOo) to edit the individual Silent Auction sheets once they are generated from the items in the database.

 

The issue I was running into with using OOo was that I was generating the mail merged documents in MS Word and then opening them up in OOo for editing. Well, I had an embedded spreadsheet in the Word document that calculated the bids that we would require from three different values: the Minimum Bid, the Minimum Raise, and the Buy It Now price (if any). The embedded spreadsheet was opening just fine in OOo but, when I double clicked on it to edit the values in it, I found it opened in read-only mode in OOo Calc (the MS Excel equivalent). This was a big issue because I do not have a version of MS Office installed on my laptop at home and I needed grant my wife the ability to edit the Silent Auction forms. So...off to the web I went to look for a solution.

 

Well, it turns out that in OOo there is an option (in the Tools>Options>load/Save/Microsoft Office selection) to load Excel files as OOo Calc files and/or save OOo Calc files as Excel. Selecting this option allowed me to load a Word document, edit the embedded spreadsheet to my heart's content, and then print out the forms that are needed for the auction. That made this geek VERY happy and will be a real productivity booster for us this year. If you want to see the fruits of my labor, and help keep Northridge Christian School turning out well-educated disciples of Christ, come to the Auction on March 5, 2011 and bid high.

Comments

Post a Comment

Popular posts from this blog

tightvnc keyboard mapping problem in Ubuntu 9.04

Image
I have been, off and on, having an issue with the keys on my keyboard mapping to the correct values when using the tightvnc client when paired with the vncserver vino in Ubuntu 9.04. I am not exactly sure what keyboard layout the client and server was expecting, but it seemed like every time I restarted the OS the keyboard mapping problem would come back and I would be at square one again. Well, I think I have found the workaround I was looking for . Hopefully this will help anyone else that is having this issue.
Read more

The manifestation of the "I" and the gift of self - Part 1

I am continuing my journey through Pope John Paul II's Theology of the Body and I had never realized how body-focused the 2nd and 3rd chapters of Genesis truly are.  But then it all makes so much more sense when it was brought to my attention that the body we have been given in a manifestation of me, or to put it another way, the "I". And it goes beyond that still. Not only does it reveal me, but my body also reveals, in no small measure, the image of God. That is not to say that God is made of flesh like me as is depicted in so many Renaissance paintings. The old man in the sky is nothing like the God as revealed in the Bible. However, the love that God is, the holiness that he is, the justice he is, the righteousness that he is...all of it is shown to the world through my body. In a very real way, my body allows for others, and for me, to participate in the mystery (the hiddenness) of the image of God. That is by design; from the beginning.  If God is revealed in nature...
Read more

Let me learn what I need to learn

In the “I don’t know what God is trying to produce in me…” portion of the blog: I work across (not with) an incredibly loud person. We are in cubes and he refuses to use a handset when he is in a conference call…or headphones. Everything is done via speaker phone. Maybe his handset is broken? I don’t know and am too timid (read “interested in keeping the peace”) to ask him. Of course he shouts into his speaker phone as well when he talks. Now he even refuses to use a keyboard. He has a speech recognition program that allows him to speak to the computer rather than type. Good for him! Now we can all hear “Comma…open parenthesis…close parenthesis…tab…tab...tab…” Was it my sin or my parents sin that relegated me to this placement in the office. We all know the answer to that but man…it sure feels like I am getting punished for something.
Read more