• RRP: £24.99
  • You Save: £1.00 (4%)
FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Learn OpenOffice.org Spre... has been added to your Basket
+ £2.80 UK delivery
Used: Very Good | Details
Condition: Used: Very Good
Comment: This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See more of our deals.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Learn OpenOffice.org Spreadsheet Macro Programming: OOoBasic and Calc automation: A fast and friendly tutorial to writing macros and spreadsheet applications Paperback – 22 Dec 2006

3.0 out of 5 stars 1 customer review

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
£23.74 £15.16
Promotion Message 10% Bulk Discount 1 Promotion(s)

Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
click to open popover

Special Offers and Product Promotions

  • Save 10% on Books for Schools offered by Amazon.co.uk when you purchase 10 or more of the same book. Here's how (terms and conditions apply) Enter code SCHOOLS2016 at checkout. Here's how (terms and conditions apply)

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Product details

  • Paperback: 220 pages
  • Publisher: Packt Publishing (22 Dec. 2006)
  • Language: English
  • ISBN-10: 1847190979
  • ISBN-13: 978-1847190970
  • Product Dimensions: 19 x 1.3 x 23.5 cm
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 1,637,196 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

About the Author

Dr. Mark Alexander Bain first started customizing CRM systems back in the mid '90s when he was team leader for Vodafone's Cascade project - the team took the 'out-of-the-box' Clarify CRM and turned it into a radio base station planning application, complete with a workflow engine for passing jobs between the different departments involved in the planning, building, and implementation of a radio network. Since then he's lectured at the University of Central Lancashire, and currently Mark writes articles on all things Linux and Open Source for Linux Format, Newsforge.com and Linux Journal. SugarCRM customization, therefore, seems the obvious choice for this, his second book, since it combines Mark's knowledge of working with commercial CRMs and the Open Source philosophy. Mark works from his home on the edge of the Lake District in the UK, where he lives with his wife, two dogs and two cats, and gets the odd visit from his sons - Michael and Simon.

Customer Reviews

3.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
This short book (exactly 200 pages.. the author must really have suffered to achieve them!) is fairly simple to be followed by anyone.
However the problem is that the title is instead rather specific, letting users to believe in a more advanced level.

To make an example, in this book you will find explained the meaning of the "save" icon on the OOo IDE..

If you are totally new on programming and writing macros for OpenOffice and you want a easy-to-follow introduction, I may recommend this one.
In all other cases (particularly if you already have a small self-learned experience) an other title would be best.
Comment 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 3.6 out of 5 stars 8 reviews
15 of 15 people found the following review helpful
5.0 out of 5 stars Eclectic mix of knowledge 9 Dec. 2007
By Andrew D. Pitonyak - Published on Amazon.com
Format: Paperback
I am was the official reviewer for this book before it was published. I was not paid for this service, nor do I benefit in any way from the sale of this book.

The book starts with a basic introduction to the programming environment, and includes a brief introduction to the structure of the language. The book does not even attempt, however, to provide full coverage of the language. This is not an introduction to programming or Basic. If you know something about programming, however, this should be sufficient to get you started.

The chapter on the object model, discusses how [...] (OOo) structures its internals. More specifically, the use of interfaces and services. There is also a discussion on how to manipulate the sheets and cells, which is what you probably expected when you see Object Model.

I refer to this book as Eclectic, because it contains numerous different topics, some of which you will not likely find elsewhere. For example, the book contains a fully working macro that extracts stock values from a web site to populate a Calc document. The macro even creates a chart over time of the stock.

Another nice offering in this book, is coverage of the FuncationAccess service. This service allows you to call the standard built-in functions such as STDEV from a macro. This is frequently a skipped topic, and you will not find it in the online help pages.

Although I could spend time to provide a chapter by chapter description of everything that is covered, well, that is not my intention. I primarily wanted to mention that I consider myself very well versed in Macro Programming, and I learned a few things by reading this book, and I enjoyed the process!
13 of 13 people found the following review helpful
4.0 out of 5 stars Great overview of macro programming with just enough code 25 Mar. 2008
By C. W. - Published on Amazon.com
Format: Paperback
I found this book very useful in getting things going with openoffice.org macro programming. I was underwhelmed with the materials I found on the internet, but found all the major topics covered in this book in varying degrees of depth. If you are already familiar with visual basic this book provides enough material to make the jump to openoffice.org basic.

This book is not a 400 page long tutorial of how to make one or two specific programs, like some vba books. This book does provide enough code examples to get the various concepts across.
4 of 4 people found the following review helpful
5.0 out of 5 stars Great starter book for macro coding in OOo Calc + Basic 22 Feb. 2011
By Wikileaker - Published on Amazon.com
Format: Paperback
This book is great for those trying to get started in OOo Basic macro programming. For those who already know their way around the system, this book has little to offer.

The beginning chapters assume you know absolutely nothing about getting into OOo Basic. Dr. Bain covers organizing your libraries and dialogs, how to stop and start macro execution, the object-oriented model of programming, methods, services, UNO, etc. etc. He takes it slow and easy. Plenty of diagrams showing how all the components of OOo Basic fit together.

Then, in the later middle chapters, he gives an overview of available Calc services and functions. No detail here, just a summary of what's available to the programmer. He does not go into Basic syntax, Calc functions, that kind of detailed stuff. He refers the reader to the built-in Calc Help, and external websites. This may disappoint some readers expecting to get a "batteries-included" type of presentation, but it makes for a compact and concise product for those readers willing to dive into the online and offline content available from the computer.

I can't really review the latter chapters since, at this time, my competence level is inadequate to fully comprehend the material. Dr. Bain presents an OOo Basic app that goes online, retrieves stock market data from Yahoo Finance, and uses it to populate a Calc sheet.

This book makes a great companion to the book "Database Design using OpenOffice.org Base". The database book includes very very brief descriptions of beginner programming concepts. This book on Calc macro programming covers the same material over the course of several chapters, with a plentitude of diagrams. For the complete beginner, this macro book can serve admirably to fill in the gaps in the beginning of the database programming book.

It bears repeating that this macro book serves to introduce the beginner to the OOo Calc programming environment only...the reader must bring proficiency in the Basic language and the Calc application itself, as these topics are given only summary treatment.

Finally and incidentally, this book seems to be a print-on-demand product. I received this book, and the Database Programming book, on 12/09/2010. On the last page is printed "Made in Lexington KY 12/03/2010". That would explain why these two books run $30 each, and why it is likely to be a very long time before you'll be able to find any used copies for a couple of bucks.
20 of 27 people found the following review helpful
2.0 out of 5 stars Not recommended! 16 Feb. 2007
By G. Jenkins - Published on Amazon.com
Format: Paperback Verified Purchase
After reading this book I was disappointed. The explanations were not complete and examples are worst. I kept reading the book over and over trying to find out how to simply erase the contents of a range of cells without results. It gives reference sites to visit but they are very difficult to follow. The book seems to assume you understand programming pretty well to begin with. Finally I turned to the internet and found several sites with much better help. I should have saved my money.
1 of 1 people found the following review helpful
5.0 out of 5 stars Learn OOo Spreadsheet Macro Programming 7 April 2013
By Penguin_Boy - Published on Amazon.com
Format: Paperback Verified Purchase
If you have programmed in Excel(tm) rather than using cell entry you wonder why more users haven't learned the programming method. When I ceased using MS products to use GPL software I found OpenOffice. It was lacking in the programming area, or so I thought. I didn't have the time necessary to dig into researching how to program macros in OOo until I found this publication. Now I can program macros and utilize OOo's Calc to the same level I used to use Excel(tm).

Great examples and lessons prepare the macro programmer.
Were these reviews helpful? Let us know