Re: Re: spreadsheet in org

[Richard G Riley <rileyrgdev@googlemail.com>]

Thomas Baumann <dtbaumann@yahoo.de> writes:

>>>> Or is there a totally better way to do this? I didnt see a way for all
>>>> fields to auto calculate when a certain field was changed. One has to
>>>> tab over the "#" in the left hand column. Or?
>>>
>>> As the manual says: C-u C-c *
>>
>> That is not the same thing as auto recalculation as in excel or similar
>> : you must manually invoke it. This is easily forgotten (well by me :-;)
>>
>
> Fortunately, there is _no_ auto-recalculation, it would slow down
> things significantly on large tables with complex formulas.

Well, clearly one would be able to turn it off in the case of excessive
load. In my case its unfortunate, rather than fortunate, since the
spreadsheets I have (or want to convert) are small and there is
negligible slowdown. To have to remember to refresh the entire
spreadsheet is a burden - not a large one I agree, but one which if
forgotten could lead to catastrophic financial reports :-;

>
>
>> If I tab to a field above and press enter a new row appears. It is bound
>> to org-return. (Latest version). Also there is no preselection of the cell
>> contents so if I type "8" when I have tabbed to the "cashbank" field
>> above then I get "| 8 2040 |".
>
> tab into the field and start writing... believe me, it works (org 6.06b
> and all versions I used since the tables were introduced.)

As I said above, when I tab in and start writing it adds to the existing
text. I do believe it might be different for you, but believe me, it
does not for me...

6.06b

Possibly it is some other mode interfering or we are at cross meanings
here - the cashbank example explains the scenario reasonably well I
think (or rather hope:-;).