1 #LyX 2.3 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 \use_dash_ligatures false
27 \default_output_format default
29 \bibtex_command default
30 \index_command default
31 \paperfontsize default
36 \use_package amsmath 1
37 \use_package amssymb 1
40 \use_package mathdots 1
41 \use_package mathtools 0
43 \use_package stackrel 0
44 \use_package stmaryrd 0
45 \use_package undertilde 0
47 \cite_engine_type default
51 \paperorientation portrait
61 \paragraph_separation skip
67 \paperpagestyle default
68 \tracking_changes false
78 Spreadsheets External Inset
85 \begin_layout Standard
86 \begin_inset CommandInset toc
87 LatexCommand tableofcontents
94 \begin_layout Standard
95 Test of spreadsheet external inset in \SpecialChar LyX
97 Spreadsheets (created with Gnumeric, LibreOffice, OpenOffice.org, or Excel)
98 gets converted to .tex with the
102 program that is distributed together with Gnumeric.
103 They are then imported as longtables.
104 As the spreadsheet is
105 \begin_inset Quotes eld
109 \begin_inset Quotes erd
112 , any changes to the spreadsheet will be reflected in \SpecialChar LyX
114 Thus, the \SpecialChar LyX
115 document is always up to date.
118 \begin_layout Section
122 \begin_layout Enumerate
126 \begin_layout Enumerate
128 use the menu Insert\SpecialChar menuseparator
129 File\SpecialChar menuseparator
133 \begin_layout Enumerate
134 In the dialog, set template to
138 and select your spreadsheet file.
141 \begin_layout Section
145 \begin_layout Standard
150 a spreadsheet created with Gnumeric:
153 \begin_layout Standard
154 \begin_inset External
155 template GnumericSpreadsheet
156 filename sheet1.gnumeric
163 \begin_layout Standard
168 which was made with LibreOffice:
171 \begin_layout Standard
172 \begin_inset External
173 template GnumericSpreadsheet
181 \begin_layout Standard
186 which was made for Excel.
189 \begin_layout Standard
190 \begin_inset External
191 template GnumericSpreadsheet
199 \begin_layout Section
203 \begin_layout Standard
204 A multi-page spreadsheet called
209 Notice that page breaking works fine:
212 \begin_layout Standard
213 \begin_inset External
214 template GnumericSpreadsheet
215 filename longsheet.gnumeric
222 \begin_layout Section
226 \begin_layout Standard
228 needs the converter program
232 that is distributed with Gnumeric.
233 It is therefore necessary to install Gnumeric, even if other software is
234 used to create and edit the spreadsheets.
237 \begin_layout Section
241 \begin_layout Standard
242 Spreadsheet inclusion have some limitations.
243 I don't know all of them, but have seen problem with this:
246 \begin_layout Labeling
247 \labelwidthstring Wide~spreadsheets
253 spreadsheets Unlike long spreadsheets, a spreadsheet wider than the margins
255 There is no attempt at breaking up such spreadsheets.
258 \begin_layout Labeling
259 \labelwidthstring Wide~spreadsheets
265 formatting Some types of formatting doesn't work.
266 The red and green texts in the long spreadsheet are underlined.
267 The underlining doesn't show, but the texts is otherwise printed correctly.
270 \begin_layout Standard
271 These limitations come from
276 Feature requests for better spreadsheet conversions should therefore go
277 to the Gnumeric developers.