O'Reilly logo

Learn OpenOffice.org Spreadsheet Macro Programming by Dr. Mark Alexander Bain

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Manipulating Spreadsheet Cells

It would seem obvious to assume that we should be able to access the cells in the spreadsheet using some object or function, especially because of what we learned about OOo UNO objects in Chapter 3. And, as you would expect:

  • Each spreadsheet that you create contains one or more worksheets (by default there will be three worksheets, and as a matter of interest there can be a maximum of 256).

  • Each worksheet consists of a number of cells (8,192,000 of them arranged in 256 columns by 32,000 rows).

And, of course it is easy to access each worksheet and its cells:

  • Each worksheet can be identified by an index number ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required