2023 Archives by date, by thread · List index

# Re: [libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???

```If the 6 rows is constant, it seems much nicer to transpose the table into
6 columns by 50 rows.

It might take a little adjustment, but most or all of the data should fit
into a single screen that way.

On Tue, Oct 3, 2023, 11:45 AM Uwe Brauer <oub@mat.ucm.es> wrote:

```
```Hi

I am facing the following problem, I work with a table with 6 rows but
56 columns. Of course I can hide some columns but I find this not very
comfortable.
So the question is can I split this table say in 8 tales, each with 7
columns.

In each table the last column gives me a result of certain operation,
say

#+begin_src
#+Name: table1
| Name  | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh1 |
|-------+-----+-----+-----+-----+-----+--------|
| Smith |   2 |   3 |   4 |   6 |   7 | 22     |
#+TBLFM: \$7=vsum(\$2..\$6);f2

#+Name: table2
| Name  | Ex1 | Ex2 | Ex2 | Ex4 | Ex5 | ResSh2  |
|-------+-----+-----+-----+-----+-----+--------|
| Smith |   1 |   3 |   5 |   8 |   9 |     26 |
#+TBLFM: \$7=vsum(\$2..\$6);f2

#+Name: final
| Name  | ResSh1 | ResSh2 | Total |
|-------+--------+--------+-------|
| smith |     22 |     26 | 48    |
#+TBLFM: \$4=vsum(\$2..\$3);f2

#+end_src

So that every time I actualise any column in any table, that
table gets updated and the final one

Is this possible. It is possible in emacs org mode with its table
spreadsheet, however my colleagues use either LO or Excel, so it would
be great if this were possible.

BTW is html mail possible/allowd on this lis?t (that would simplify the
display of my tables)

Thanks and regards

Uwe Brauer

--
Warning: Content may be disturbing to some audiences
I strongly condemn Putin's war of aggression against Ukraine.
I support to deliver weapons to Ukraine's military.
I support the NATO membership of Ukraine.
I support the EU membership of Ukraine.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems?
https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/

```
```
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/