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 <[email protected]> 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: [email protected] > 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: [email protected] 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
