1 #LyX 2.0 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
39 \paperorientation portrait
48 \paragraph_separation skip
50 \quotes_language english
53 \paperpagestyle default
54 \tracking_changes false
64 Spreadsheets External Inset
71 \begin_layout Standard
72 \begin_inset CommandInset toc
73 LatexCommand tableofcontents
80 \begin_layout Standard
81 Test of spreadsheet external inset in LyX.
82 Spreadsheets (created with Gnumeric, LibreOffice, OpenOffice.org, or Excel)
83 gets converted to .tex with the
87 program that is distributed together with Gnumeric.
88 They are then imported as longtables.
90 \begin_inset Quotes eld
94 \begin_inset Quotes erd
97 , any changes to the spreadsheet will be reflected in LyX's output too.
98 Thus, the LyX document is always up to date.
101 \begin_layout Section
105 \begin_layout Enumerate
109 \begin_layout Enumerate
110 In LyX use the menu Insert\SpecialChar \menuseparator
111 File\SpecialChar \menuseparator
115 \begin_layout Enumerate
116 In the dialog, set template to
120 and select your spreadsheet file.
123 \begin_layout Section
127 \begin_layout Standard
132 a spreadsheet created with Gnumeric:
135 \begin_layout Standard
136 \begin_inset External
137 template GnumericSpreadsheet
138 filename sheet1.gnumeric
145 \begin_layout Standard
150 which was made with LibreOffice:
153 \begin_layout Standard
154 \begin_inset External
155 template GnumericSpreadsheet
163 \begin_layout Standard
168 which was made for Excel.
171 \begin_layout Standard
172 \begin_inset External
173 template GnumericSpreadsheet
181 \begin_layout Section
185 \begin_layout Standard
186 A multi-page spreadsheet called
191 Notice that page breaking works fine:
194 \begin_layout Standard
195 \begin_inset External
196 template GnumericSpreadsheet
197 filename longsheet.gnumeric
204 \begin_layout Section
208 \begin_layout Standard
209 LyX needs the converter program
213 that is distributed with Gnumeric.
214 It is therefore necessary to install Gnumeric, even if other software is
215 used to create and edit the spreadsheets.
218 \begin_layout Section
222 \begin_layout Standard
223 Spreadsheet inclusion have some limitations.
224 I don't know all of them, but have seen problem with this:
227 \begin_layout Labeling
228 \labelwidthstring Wide~spreadsheets
234 spreadsheets Unlike long spreadsheets, a spreadsheet wider than the margins
236 There is no attempt at breaking up such spreadsheets.
239 \begin_layout Labeling
240 \labelwidthstring Wide~spreadsheets
246 formatting Some types of formatting doesn't work.
247 The red and green texts in the long spreadsheet are underlined.
248 The underlining doesn't show, but the texts is otherwise printed correctly.
251 \begin_layout Standard
252 These limitations come from
257 Feature requests for better spreadsheet conversions should therefore go
258 to the Gnumeric developers.