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???

```"RG" == Remy Gauthier <remygauthier@yahoo.com> writes:
```
```
```
```Hi,
You can use the SUMIF function to have the ResSh1 and ResSh2 of final
to be updated each time you make an entry. If you only have one "Smith"
per table, you can use VLOOKUP to fetch the \$7 value for Smith. You
will use these functions to find the "Smith" values in each of your
smaller tables.
```
```
```
```Assuming "Name" of table1 is in A1, "Smith" of final is in A2, and
there are 20 rows in table1, using SUMIF for the ResSh1 in final would
bring:
```
```
```
```=SUMIF(table1.\$a\$1:\$a:20,CONCATENATE("=",final.a2),table1.\$g\$1:\$g\$20)
```
```

I think I will try this out now. Do you mean my table1
the name of the sheet, so to distribute the various tables in different
sheet our does there exits a table name (and I don't know where to find
it.) So that I could have different tables on the same sheet?

```
```For ResSh2, you will replace table1 with table2.
```
```
```
```If you want to use VLOOKUP, then you will have, for final.ResSh1:
```
```
```
```=VLOOKUP(final.a2,table1.\$a\$1:\$g\$20,7,FALSE())
```
```
```
```I hope this helps.
Rémy.
```
```
```
```Le mardi 03 octobre 2023 à 18:44 +0200, Uwe Brauer a écrit :
```
```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.

```
```

--
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.