1 #LyX 2.2 created this file. For more info see http://www.lyx.org/
5 \save_transient_properties true
6 \origin /systemlyxdir/examples/
8 \use_default_options true
9 \maintain_unincluded_children false
11 \language_package default
14 \font_roman "default" "default"
15 \font_sans "default" "default"
16 \font_typewriter "default" "default"
17 \font_math "auto" "auto"
18 \font_default_family default
19 \use_non_tex_fonts false
22 \font_sf_scale 100 100
23 \font_tt_scale 100 100
25 \default_output_format default
27 \bibtex_command default
28 \index_command default
29 \paperfontsize default
34 \use_package amsmath 1
35 \use_package amssymb 1
38 \use_package mathdots 1
39 \use_package mathtools 0
41 \use_package stackrel 0
42 \use_package stmaryrd 0
43 \use_package undertilde 0
45 \cite_engine_type default
49 \paperorientation portrait
59 \paragraph_separation skip
61 \quotes_language english
64 \paperpagestyle default
65 \tracking_changes false
75 Spreadsheets External Inset
82 \begin_layout Standard
83 \begin_inset CommandInset toc
84 LatexCommand tableofcontents
91 \begin_layout Standard
92 Test of spreadsheet external inset in \SpecialChar LyX
94 Spreadsheets (created with Gnumeric, LibreOffice, OpenOffice.org, or Excel)
95 gets converted to .tex with the
99 program that is distributed together with Gnumeric.
100 They are then imported as longtables.
101 As the spreadsheet is
102 \begin_inset Quotes eld
106 \begin_inset Quotes erd
109 , any changes to the spreadsheet will be reflected in \SpecialChar LyX
111 Thus, the \SpecialChar LyX
112 document is always up to date.
115 \begin_layout Section
119 \begin_layout Enumerate
123 \begin_layout Enumerate
125 use the menu Insert\SpecialChar menuseparator
126 File\SpecialChar menuseparator
130 \begin_layout Enumerate
131 In the dialog, set template to
135 and select your spreadsheet file.
138 \begin_layout Section
142 \begin_layout Standard
147 a spreadsheet created with Gnumeric:
150 \begin_layout Standard
151 \begin_inset External
152 template GnumericSpreadsheet
153 filename sheet1.gnumeric
160 \begin_layout Standard
165 which was made with LibreOffice:
168 \begin_layout Standard
169 \begin_inset External
170 template GnumericSpreadsheet
178 \begin_layout Standard
183 which was made for Excel.
186 \begin_layout Standard
187 \begin_inset External
188 template GnumericSpreadsheet
196 \begin_layout Section
200 \begin_layout Standard
201 A multi-page spreadsheet called
206 Notice that page breaking works fine:
209 \begin_layout Standard
210 \begin_inset External
211 template GnumericSpreadsheet
212 filename longsheet.gnumeric
219 \begin_layout Section
223 \begin_layout Standard
225 needs the converter program
229 that is distributed with Gnumeric.
230 It is therefore necessary to install Gnumeric, even if other software is
231 used to create and edit the spreadsheets.
234 \begin_layout Section
238 \begin_layout Standard
239 Spreadsheet inclusion have some limitations.
240 I don't know all of them, but have seen problem with this:
243 \begin_layout Labeling
244 \labelwidthstring Wide~spreadsheets
250 spreadsheets Unlike long spreadsheets, a spreadsheet wider than the margins
252 There is no attempt at breaking up such spreadsheets.
255 \begin_layout Labeling
256 \labelwidthstring Wide~spreadsheets
262 formatting Some types of formatting doesn't work.
263 The red and green texts in the long spreadsheet are underlined.
264 The underlining doesn't show, but the texts is otherwise printed correctly.
267 \begin_layout Standard
268 These limitations come from
273 Feature requests for better spreadsheet conversions should therefore go
274 to the Gnumeric developers.