1 #LyX 2.1 created this file. For more info see http://www.lyx.org/
6 \use_default_options true
7 \maintain_unincluded_children false
9 \language_package default
14 \font_typewriter default
16 \font_default_family default
17 \use_non_tex_fonts false
23 \default_output_format default
25 \bibtex_command default
26 \index_command default
27 \paperfontsize default
32 \use_package amsmath 1
33 \use_package amssymb 1
36 \use_package mathdots 1
37 \use_package mathtools 0
39 \use_package stackrel 0
40 \use_package stmaryrd 0
41 \use_package undertilde 0
43 \cite_engine_type default
47 \paperorientation portrait
57 \paragraph_separation skip
59 \quotes_language english
62 \paperpagestyle default
63 \tracking_changes false
73 Spreadsheets External Inset
80 \begin_layout Standard
81 \begin_inset CommandInset toc
82 LatexCommand tableofcontents
89 \begin_layout Standard
90 Test of spreadsheet external inset in LyX.
91 Spreadsheets (created with Gnumeric, LibreOffice, OpenOffice.org, or Excel)
92 gets converted to .tex with the
96 program that is distributed together with Gnumeric.
97 They are then imported as longtables.
99 \begin_inset Quotes eld
103 \begin_inset Quotes erd
106 , any changes to the spreadsheet will be reflected in LyX's output too.
107 Thus, the LyX document is always up to date.
110 \begin_layout Section
114 \begin_layout Enumerate
118 \begin_layout Enumerate
119 In LyX use the menu Insert\SpecialChar \menuseparator
120 File\SpecialChar \menuseparator
124 \begin_layout Enumerate
125 In the dialog, set template to
129 and select your spreadsheet file.
132 \begin_layout Section
136 \begin_layout Standard
141 a spreadsheet created with Gnumeric:
144 \begin_layout Standard
145 \begin_inset External
146 template GnumericSpreadsheet
147 filename sheet1.gnumeric
154 \begin_layout Standard
159 which was made with LibreOffice:
162 \begin_layout Standard
163 \begin_inset External
164 template GnumericSpreadsheet
172 \begin_layout Standard
177 which was made for Excel.
180 \begin_layout Standard
181 \begin_inset External
182 template GnumericSpreadsheet
190 \begin_layout Section
194 \begin_layout Standard
195 A multi-page spreadsheet called
200 Notice that page breaking works fine:
203 \begin_layout Standard
204 \begin_inset External
205 template GnumericSpreadsheet
206 filename longsheet.gnumeric
213 \begin_layout Section
217 \begin_layout Standard
218 LyX needs the converter program
222 that is distributed with Gnumeric.
223 It is therefore necessary to install Gnumeric, even if other software is
224 used to create and edit the spreadsheets.
227 \begin_layout Section
231 \begin_layout Standard
232 Spreadsheet inclusion have some limitations.
233 I don't know all of them, but have seen problem with this:
236 \begin_layout Labeling
237 \labelwidthstring Wide~spreadsheets
243 spreadsheets Unlike long spreadsheets, a spreadsheet wider than the margins
245 There is no attempt at breaking up such spreadsheets.
248 \begin_layout Labeling
249 \labelwidthstring Wide~spreadsheets
255 formatting Some types of formatting doesn't work.
256 The red and green texts in the long spreadsheet are underlined.
257 The underlining doesn't show, but the texts is otherwise printed correctly.
260 \begin_layout Standard
261 These limitations come from
266 Feature requests for better spreadsheet conversions should therefore go
267 to the Gnumeric developers.