New tutorial about using Org as a spreadsheet system

New tutorial about using Org as a spreadsheet system

[Bastien Guerry]

Hi folks, 

i've made a small tutorial about the use of spreadsheet facilities in
org-mode:

  http://www.legito.net/worg/org-tutorials/org-spreadsheet-intro.php

It won't be very useful for those who are already familiar with this
amazing field of application for Org, and the curious minds will stay
hungry after reading it, but I hope it will make some of you consider
using it for simple needs, and digg further into it.

Enjoy!

Note: Worg is moving to www.legito.net -- I will delete the old website
next week.

-- 
Bastien

RE: New tutorial about using Org as a spreadsheet system

[Chris Randle]

Hi Bastien,

Bastien Guerry wrote:
> Hi folks,
> i've made a small tutorial about the use of spreadsheet facilities in
> org-mode:
>   http://www.legito.net/worg/org-tutorials/org-spreadsheet-intro.php

Thanks. It was very useful. I use tables and spreadsheets quite a lot,
but I still learnt a couple of very useful things that I didn't know:
the formula editor and debugging.

As I followed along, I spotted a couple of things:

1) Under "Your first formula", the first vmean formula you show is a
column formula, whereas the text implies it should have been a field
formula.

2) I'd never used #+CONSTANTS before, and as I followed along I
discovered that I had to do a 'C-c C-c' on the CONSTANTS line before the
table had knowledge of it. It might be good to make that explicit,
otherwise the table shows #ERRORs. I got to use my new-found debugging
knowledge to work out why!

-- 
Chris Randle

Re: New tutorial about using Org as a spreadsheet system

[Bastien Guerry]

Hi Chris,

"Chris Randle" <chris@amlog.co.uk> writes:

> As I followed along, I spotted a couple of things:
>
> 1) Under "Your first formula", the first vmean formula you show is a
> column formula, whereas the text implies it should have been a field
> formula.

Well spotted, I fixed this.

> 2) I'd never used #+CONSTANTS before, and as I followed along I
> discovered that I had to do a 'C-c C-c' on the CONSTANTS line before the
> table had knowledge of it. It might be good to make that explicit,
> otherwise the table shows #ERRORs. I got to use my new-found debugging
> knowledge to work out why!

I added this line:

  (Don't forget to hit =C-c C-c= on the =#+CONSTANTS= line so that
  org-mode knows about it.)

Thanks for the feedback.  The updated version is an the Worg repo and
should be exported to the HTML Worg website in about ten minutes.

-- 
Bastien