On Monday, 8 Oct 2018 at 17:19, Karl Voit wrote:
> Unfortunately, I have to admit that spreadsheets in Org are not
> something I can recommend to somebody who needs "something that just
> works" (like Excel-switcher). :-(
Maybe not but the combination of "It's all text", Emacs calc, and LaTeX
* Michael Brand wrote:
> Hi Karl
Hi Michael,
> On Mon, Oct 1, 2018 at 5:02 PM Karl Voit wrote:
>
>> I'd like to calculate the differences between rows of numbers of a
>> different table.
>
> For this kind of shifting row or column indexes I use Calc vector
> subscript. In your case:
>
>
Hi Karl
On Mon, Oct 1, 2018 at 5:02 PM Karl Voit wrote:
> I'd like to calculate the differences between rows of numbers of a
> different table.
For this kind of shifting row or column indexes I use Calc vector
subscript. In your case:
#+NAME: my-table
| Numbers |
|-|
| 1 |
|
Karl Voit writes:
>>
>> @# is the row number, so to refer to that row, you need @@#. Something like
>> this,
>> although I didn't test to see if everything gets parsed correctly:
>>
>> #+TBLFM: $2=if(2 == @#, 0, remote(my-table,@@#$1))::$3=if(2 == @#,
>> 0, remote(my-table,@@#-1$1))::$4=if(2 ==
Hi Nick,
* Nick Dokos wrote:
> Karl Voit writes:
>
>> I'd like to calculate the differences between rows of numbers of a
>> different table.
>>
>> Here is a minimal example showing the issue:
>>
>> #+NAME: my-table
>> | Numbers |
>>
>> |-|
>> | 1 |
>> | 5
Karl Voit writes:
> Hi!
>
> I'd like to calculate the differences between rows of numbers of a
> different table.
>
> Here is a minimal example showing the issue:
>
> #+NAME: my-table
> | Numbers |
>
> |-|
> | 1 |
> | 5 |
> | 8 |
> | 12
Hi!
I'd like to calculate the differences between rows of numbers of a
different table.
Here is a minimal example showing the issue:
#+NAME: my-table
| Numbers |
|-|
| 1 |
| 5 |
| 8 |
| 12 |
| 15 |
This is what I expected:
