emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* how obtain automatic row numbers in a table starting after the second hline?
@ 2022-08-06 16:19 Uwe Brauer
  2022-08-07 11:21 ` Christian Moe
  0 siblings, 1 reply; 4+ messages in thread
From: Uwe Brauer @ 2022-08-06 16:19 UTC (permalink / raw)
  To: emacs-orgmode


Hi

I would like to obtain 
#+begin_src 

|  Nr |
|-----|
|     |
|-----|
| 574 |
| 575 |
|  .. |
| 680 |
#+end_src

I tried 
#+begin_src 

| Nr |
|----|
|  1 |
|----|
|  1 |
|  2 |
#+TBLFM: $1=vlen(@II$1..0);EN
#+end_src

or
#+begin_src 

|  Nr |
|-----|
| 573 |
|-----|
| 574 |
| 575 |
#+TBLFM: $1=@#-1+572
#+end_src

None worked, any ideas?

thanks

Uwe Brauer 
-- 
I strongly condemn Putin's war of aggression against the Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the ban of Russia from SWIFT.
I support the EU membership of the Ukraine. 



^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: how obtain automatic row numbers in a table starting after the second hline?
  2022-08-06 16:19 how obtain automatic row numbers in a table starting after the second hline? Uwe Brauer
@ 2022-08-07 11:21 ` Christian Moe
  2022-08-09  7:32   ` Uwe Brauer
  0 siblings, 1 reply; 4+ messages in thread
From: Christian Moe @ 2022-08-07 11:21 UTC (permalink / raw)
  To: emacs-orgmode

Hi, Uwe,

Three ideas:

1. Since your solution depends on the row number (@#) in any case, your
   use case does not actually depend on hline-relative references, does
   it?  Then you can also assign to absolute row numbers, either by

   - assigning to the range rather than to the colum, which is not
     possible with hline relative references (the obvious
     @II$1..@>$1=@#-1+572 is not allowed), but with an absolute start
     reference it works:

     |  Nr |
     |-----|
     |     |
     |-----|
     | 574 |
     | 575 |
     | 576 |
     | 577 |
     #+TBLFM: @3$1..@>$1=@#-1+572

   - or assigning to the row first, then assigning the content between
     the hlines to that cell (perhaps a fragile solution).

     |  Nr |
     |-----|
     |     |
     |-----|
     | 574 |
     | 575 |
     | 576 |
     | 577 |
     #+TBLFM: $1=@#-1+572::@2$1=string("")

2. Use a conditional to avoid changing the cell between the hlines, e.g.:

   |  Nr |
   |-----|
   | foo |
   |-----|
   | 574 |
   | 575 |
   | 576 |
   | 577 |
   #+TBLFM: $1=if(@# < 3, @0$1, @#+571)

   Here, I use @0$1 to replace that cell with itself. If the cell is empty,
   this evaluates as 0, so if you want an empty string, use string("")
   instead of @0$1.

3. Add a first column with special marking characters (see Org manual:
   Spreadsheet: Advanced features), leaving empty the cell between the
   hlines so it won't get recalculated.

   |   |  Nr |
   |---+-----|
   |   |     |
   |---+-----|
   | * | 574 |
   | * | 575 |
   | * | 576 |
   | * | 577 |
   #+TBLFM: $2=@#-1+572

Yours,
Christian

Uwe Brauer writes:

> Hi
>
> I would like to obtain
> #+begin_src
>
> |  Nr |
> |-----|
> |     |
> |-----|
> | 574 |
> | 575 |
> |  .. |
> | 680 |
> #+end_src
>
> I tried
> #+begin_src
>
> | Nr |
> |----|
> |  1 |
> |----|
> |  1 |
> |  2 |
> #+TBLFM: $1=vlen(@II$1..0);EN
> #+end_src
>
> or
> #+begin_src
>
> |  Nr |
> |-----|
> | 573 |
> |-----|
> | 574 |
> | 575 |
> #+TBLFM: $1=@#-1+572
> #+end_src
>
> None worked, any ideas?
>
> thanks
>
> Uwe Brauer


^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: how obtain automatic row numbers in a table starting after the second hline?
  2022-08-07 11:21 ` Christian Moe
@ 2022-08-09  7:32   ` Uwe Brauer
  2022-08-10 20:28     ` Christian Moe
  0 siblings, 1 reply; 4+ messages in thread
From: Uwe Brauer @ 2022-08-09  7:32 UTC (permalink / raw)
  To: emacs-orgmode

[-- Attachment #1: Type: text/plain, Size: 503 bytes --]

>>> "CM" == Christian Moe <mail@christianmoe.com> writes:

> Hi, Uwe,
> Three ideas:

Wow, thanks a lot of all these solutions

I am using the new ods exporter found in 

git@github.com:kjambunathan/org-mode-ox-odt.git

And the first and the last solution work in the sense that LO can open the exported ods file while the second (string) and third (conditional) result in ods file that cannot be opened.

Given my use case, I think I will take the first solution, thanks

Again

Uwe 

[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: how obtain automatic row numbers in a table starting after the second hline?
  2022-08-09  7:32   ` Uwe Brauer
@ 2022-08-10 20:28     ` Christian Moe
  0 siblings, 0 replies; 4+ messages in thread
From: Christian Moe @ 2022-08-10 20:28 UTC (permalink / raw)
  To: emacs-orgmode, Uwe Brauer


Hi, Uwe,

I also get an error when exporting my suggestions to ODT with the
official ODT exporter, but it's not because of the solutions. They
should all be fine, but anyway, it's enough that one of them works for
you.

Rather, the exporter seems to be confused by the way I mixed tables into
a list structure, which leads it to add a </text:list-header> tag
without a preceding opening tag, invalidating the XML. If I can pin down
a minimal example, I'll see about reporting it as a bug in the ODT
exporter (possibly the structure I used is not meant to be allowed, but
it seems to work OK in HTML and LaTeX export).

Yours,
Christian

Uwe Brauer writes:

>>>> "CM" == Christian Moe <mail@christianmoe.com> writes:
>
>> Hi, Uwe,
>> Three ideas:
>
> Wow, thanks a lot of all these solutions
>
> I am using the new ods exporter found in
>
> git@github.com:kjambunathan/org-mode-ox-odt.git
>
> And the first and the last solution work in the sense that LO can open the exported ods file while the second (string) and third (conditional) result in ods file that cannot be opened.
>
> Given my use case, I think I will take the first solution, thanks
>
> Again
>
> Uwe


^ permalink raw reply	[flat|nested] 4+ messages in thread

end of thread, other threads:[~2022-08-10 20:29 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2022-08-06 16:19 how obtain automatic row numbers in a table starting after the second hline? Uwe Brauer
2022-08-07 11:21 ` Christian Moe
2022-08-09  7:32   ` Uwe Brauer
2022-08-10 20:28     ` Christian Moe

Code repositories for project(s) associated with this inbox:

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).