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

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