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
64 \math_numbering_side default
68 \paperpagestyle default
69 \tracking_changes false
80 Spreadsheets External Inset
87 \begin_layout Standard
88 \begin_inset CommandInset toc
89 LatexCommand tableofcontents
96 \begin_layout Standard
97 Test of spreadsheet external inset in \SpecialChar LyX
99 Spreadsheets (created with Gnumeric, LibreOffice, OpenOffice.org, or Excel)
100 gets converted to .tex with the
104 program that is distributed together with Gnumeric.
105 They are then imported as longtables.
106 As the spreadsheet is
107 \begin_inset Quotes eld
111 \begin_inset Quotes erd
114 , any changes to the spreadsheet will be reflected in \SpecialChar LyX
116 Thus, the \SpecialChar LyX
117 document is always up to date.
120 \begin_layout Section
124 \begin_layout Enumerate
128 \begin_layout Enumerate
130 use the menu Insert\SpecialChar menuseparator
131 File\SpecialChar menuseparator
135 \begin_layout Enumerate
136 In the dialog, set template to
140 and select your spreadsheet file.
143 \begin_layout Section
147 \begin_layout Standard
152 a spreadsheet created with Gnumeric:
155 \begin_layout Standard
156 \begin_inset External
157 template GnumericSpreadsheet
158 filename sheet1.gnumeric
165 \begin_layout Standard
170 which was made with LibreOffice:
173 \begin_layout Standard
174 \begin_inset External
175 template GnumericSpreadsheet
183 \begin_layout Standard
188 which was made for Excel.
191 \begin_layout Standard
192 \begin_inset External
193 template GnumericSpreadsheet
201 \begin_layout Section
205 \begin_layout Standard
206 A multi-page spreadsheet called
211 Notice that page breaking works fine:
214 \begin_layout Standard
215 \begin_inset External
216 template GnumericSpreadsheet
217 filename longsheet.gnumeric
224 \begin_layout Section
228 \begin_layout Standard
230 needs the converter program
234 that is distributed with Gnumeric.
235 It is therefore necessary to install Gnumeric, even if other software is
236 used to create and edit the spreadsheets.
239 \begin_layout Section
243 \begin_layout Standard
244 Spreadsheet inclusion have some limitations.
245 I don't know all of them, but have seen problem with this:
248 \begin_layout Labeling
249 \labelwidthstring Wide~spreadsheets
255 spreadsheets Unlike long spreadsheets, a spreadsheet wider than the margins
257 There is no attempt at breaking up such spreadsheets.
260 \begin_layout Labeling
261 \labelwidthstring Wide~spreadsheets
267 formatting Some types of formatting doesn't work.
268 The red and green texts in the long spreadsheet are underlined.
269 The underlining doesn't show, but the texts is otherwise printed correctly.
272 \begin_layout Standard
273 These limitations come from
278 Feature requests for better spreadsheet conversions should therefore go
279 to the Gnumeric developers.