Re: [libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???
>>> "RG" == Remy Gauthier 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+unsubscr...@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
Re: [libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???
>>> "RG" == Remy Gauthier 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) > 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. Thanks very much I will have a look. That might be the most elegant solution so far. -- 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+unsubscr...@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
Re: [libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???
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) 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/ > > -- To unsubscribe e-mail to: users+unsubscr...@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
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 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. > > https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/ > > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > > -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???
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/ -- To unsubscribe e-mail to: users+unsubscr...@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