Site Map - skip to main content

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes every weekday Monday through Friday.
This page was generated by The HPR Robot at


hpr1485 :: 26 - LibreOffice Calc Cells

This episode looks at the fundamental unit of a spreadsheet, the cell, and introduces addressing and

<< First, < Previous, , Latest >>

Thumbnail of Ahuka
Hosted by Ahuka on 2014-04-11 is flagged as Clean and is released under a CC-BY-SA license.
LibreOffice, Calc, Spreadsheet. (Be the first).
The show is available on the Internet Archive at: https://archive.org/details/hpr1485

Listen in ogg, spx, or mp3 format. Play now:

Duration: 00:21:15

LibreOffice.

In this in-depth series on LibreOffice we examine Writer, Calc and Impress

LibreOffice Calc: Cells

All spreadsheets have the same basic structure, a table of rows and columns. Columns are headed up A, B, C, and so on. After Z, the next column is AA, then AB, AC, AD, and so on. The maximum number of columns is 1024. Rows are numbered 1,2,3 and so on, and the maximum number of rows is 1024*1024, or 1,048,576. At this time I am not aware of any plans to increase these numbers, though that could change if competitive pressures make it necessary.

Where a row and column intersect, there is a cell, which is given the address of the column followed by the row, e.g. A1, but never 1A. This is very useful since you can use the contents of a cell in a calculation by simply using the cell address. For example, to add the value of cell B4 to the value in cell C3 and store it, you would write “=B4+C3″ in the cell where you want to store the sum. Learning to use cell addresses is extremely important, so get in the habit of doing this at every opportunity.

For the rest of this article see https://www.ahuka.com/?page_id=706


Comments

Subscribe to the comments RSS feed.

Leave Comment

Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.

Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).

Provide feedback
Your Name/Handle:
Title:
Comment:
Anti Spam Question: What does the letter P in HPR stand for?
Are you a spammer?
What is the HOST_ID for the host of this show?
What does HPR mean to you?