On 23/12/2017 10:44 a.m., Rich Shepard wrote:
On Fri, 22 Dec 2017, Rich Shepard wrote:
Having put \usepackage{spreadtab} in the preamble, I assume that I put
the ERT \begin{spreadtab} just above the table and the ERT
\end{spreadtab}
immediately following the table (similar to use of the \multicol
package.)
Is this correct?
Apparently not; but I may well be wrong.
Expanding my request for help with spreadtab, how do I enter
formulae in a
cell (e.g., c2*e2) or relative references (using backets to define the
relative cell positions)?
The spreadtab docs describe doing this in LaTeX and I'd appreciate
pointers on using this package in LyX.
TIA,
Rich
Rich, some years ago I developed a module so that spreadtab could be
used in LyX and if instant preview was on it allowed a kind of
lightweight interactive spreadsheeting. I used it for keeping a
timesheet when I was freelancing as an indexer. There's a link to a
dropbox folder, holding a zipped archive of the module and explanatory
document, on the wiki: item 1.5 at http://wiki.lyx.org/Layouts/Modules.
The module provides a command for turning a table built in LyX into a
spreadtab table. There are a couple of other helper commands defined too.
It is some time since I last looked at this -- the dropbox link is to a
LyX 2.1 document -- so my knowledge is a bit rusty but I imagine it
would come back. Possibly the examples in the document would give you
all the help you need.
Andrew
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
