Date: prev next · Thread: first prev next last
2023 Archives by date, by thread · List index


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
So the question is can I split this table say in 8 tales, each with 7

In each table the last column gives me a result of certain operation,

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


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.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.