On Wed, May 4, 2011 at 11:01 AM, Andrew Parsloe <apars...@clear.net.nz> wrote: > The current lack of even a basic 'active' table in LyX, where you can sum a > column of figures for instance, > This is not accurate. In 2.0 you can: File > Import > Table (CSV) File > Import > xls File > Import > Gnumeric Insert > File > External > Gnumeric (supports Excel, OOo, Gnumeric)
The Gnumeric external material allows you to have and maintain a spreadsheet in Excel, OOo, Gnumeric. This means that whatever modifications you introduce in the spreadsheet file, they will be visible upon the next compilation of your LyX document. Pretty nifty, actually. :) A more advanced way to do something similar is to use R via the Sweave module. But this is not for the faint hearted. Cheers Liviu
