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 1
43 \use_package stackrel 1
44 \use_package stmaryrd 1
45 \use_package undertilde 1
47 \cite_engine_type default
51 \paperorientation portrait
62 \paragraph_separation skip
65 \math_numbering_side default
70 \paperpagestyle default
71 \tracking_changes false
81 Spreadsheets External Inset
88 \begin_layout Standard
89 \begin_inset CommandInset toc
90 LatexCommand tableofcontents
97 \begin_layout Standard
98 Test of spreadsheet external inset in \SpecialChar LyX
100 Spreadsheets (created with Gnumeric, LibreOffice, OpenOffice.org, or Excel)
101 gets converted to .tex with the
105 program that is distributed together with Gnumeric.
106 They are then imported as longtables.
107 As the spreadsheet is
108 \begin_inset Quotes eld
112 \begin_inset Quotes erd
115 , any changes to the spreadsheet will be reflected in \SpecialChar LyX
117 Thus, the \SpecialChar LyX
118 document is always up to date.
121 \begin_layout Section
125 \begin_layout Enumerate
129 \begin_layout Enumerate
131 use the menu Insert\SpecialChar menuseparator
132 File\SpecialChar menuseparator
136 \begin_layout Enumerate
137 In the dialog, set template to
141 and select your spreadsheet file.
144 \begin_layout Section
148 \begin_layout Standard
153 a spreadsheet created with Gnumeric:
156 \begin_layout Standard
157 \begin_inset External
158 template GnumericSpreadsheet
159 filename sheet1.gnumeric
166 \begin_layout Standard
171 which was made with LibreOffice:
174 \begin_layout Standard
175 \begin_inset External
176 template GnumericSpreadsheet
184 \begin_layout Standard
189 which was made for Excel.
192 \begin_layout Standard
193 \begin_inset External
194 template GnumericSpreadsheet
202 \begin_layout Section
206 \begin_layout Standard
207 A multi-page spreadsheet called
212 Notice that page breaking works fine:
215 \begin_layout Standard
216 \begin_inset External
217 template GnumericSpreadsheet
218 filename longsheet.gnumeric
225 \begin_layout Section
229 \begin_layout Standard
231 needs the converter program
235 that is distributed with Gnumeric.
236 It is therefore necessary to install Gnumeric, even if other software is
237 used to create and edit the spreadsheets.
240 \begin_layout Section
244 \begin_layout Standard
245 Spreadsheet inclusion have some limitations.
246 I don't know all of them, but have seen problem with this:
249 \begin_layout Labeling
250 \labelwidthstring Wide~spreadsheets
256 spreadsheets Unlike long spreadsheets, a spreadsheet wider than the margins
258 There is no attempt at breaking up such spreadsheets.
261 \begin_layout Labeling
262 \labelwidthstring Wide~spreadsheets
268 formatting Some types of formatting doesn't work.
269 The red and green texts in the long spreadsheet are underlined.
270 The underlining doesn't show, but the texts is otherwise printed correctly.
273 \begin_layout Standard
274 These limitations come from
279 Feature requests for better spreadsheet conversions should therefore go
280 to the Gnumeric developers.