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
15 \font_default_family default
16 \use_non_tex_fonts false
23 \default_output_format default
25 \bibtex_command default
26 \index_command default
27 \paperfontsize default
40 \paperorientation portrait
49 \paragraph_separation skip
51 \quotes_language english
54 \paperpagestyle default
55 \tracking_changes false
65 Spreadsheets External Inset
72 \begin_layout Standard
73 \begin_inset CommandInset toc
74 LatexCommand tableofcontents
81 \begin_layout Standard
82 Test of spreadsheet external inset in LyX.
83 Spreadsheets (created with Gnumeric, LibreOffice, OpenOffice.org, or Excel)
84 gets converted to .tex with the
88 program that is distributed together with Gnumeric.
89 They are then imported as longtables.
91 \begin_inset Quotes eld
95 \begin_inset Quotes erd
98 , any changes to the spreadsheet will be reflected in LyX's output too.
99 Thus, the LyX document is always up to date.
102 \begin_layout Section
106 \begin_layout Enumerate
110 \begin_layout Enumerate
111 In LyX use the menu Insert\SpecialChar \menuseparator
112 File\SpecialChar \menuseparator
116 \begin_layout Enumerate
117 In the dialog, set template to
121 and select your spreadsheet file.
124 \begin_layout Section
128 \begin_layout Standard
133 a spreadsheet created with Gnumeric:
136 \begin_layout Standard
137 \begin_inset External
138 template GnumericSpreadsheet
139 filename sheet1.gnumeric
146 \begin_layout Standard
151 which was made with LibreOffice:
154 \begin_layout Standard
155 \begin_inset External
156 template GnumericSpreadsheet
164 \begin_layout Standard
169 which was made for Excel.
172 \begin_layout Standard
173 \begin_inset External
174 template GnumericSpreadsheet
182 \begin_layout Section
186 \begin_layout Standard
187 A multi-page spreadsheet called
192 Notice that page breaking works fine:
195 \begin_layout Standard
196 \begin_inset External
197 template GnumericSpreadsheet
198 filename longsheet.gnumeric
205 \begin_layout Section
209 \begin_layout Standard
210 LyX needs the converter program
214 that is distributed with Gnumeric.
215 It is therefore necessary to install Gnumeric, even if other software is
216 used to create and edit the spreadsheets.
219 \begin_layout Section
223 \begin_layout Standard
224 Spreadsheet inclusion have some limitations.
225 I don't know all of them, but have seen problem with this:
228 \begin_layout Labeling
229 \labelwidthstring Wide~spreadsheets
235 spreadsheets Unlike long spreadsheets, a spreadsheet wider than the margins
237 There is no attempt at breaking up such spreadsheets.
240 \begin_layout Labeling
241 \labelwidthstring Wide~spreadsheets
247 formatting Some types of formatting doesn't work.
248 The red and green texts in the long spreadsheet are underlined.
249 The underlining doesn't show, but the texts is otherwise printed correctly.
252 \begin_layout Standard
253 These limitations come from
258 Feature requests for better spreadsheet conversions should therefore go
259 to the Gnumeric developers.