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. 
> > https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/


-- 
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. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/

-- 
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/
Privacy Policy: https://www.documentfoundation.org/privacy