1 #LyX 2.4 created this file. For more info see https://www.lyx.org/
5 \save_transient_properties true
6 \origin /systemlyxdir/examples/External_Material/
10 \setlength{\parskip}{\bigskipamount}
11 \setlength{\parindent}{0pt}
13 \use_default_options true
14 \maintain_unincluded_children no
16 \language_package default
19 \font_roman "default" "default"
20 \font_sans "default" "default"
21 \font_typewriter "default" "default"
22 \font_math "auto" "auto"
23 \font_default_family default
24 \use_non_tex_fonts false
28 \font_typewriter_osf false
29 \font_sf_scale 100 100
30 \font_tt_scale 100 100
32 \use_dash_ligatures false
34 \default_output_format default
36 \bibtex_command default
37 \index_command default
38 \paperfontsize default
43 \use_package amsmath 1
44 \use_package amssymb 1
47 \use_package mathdots 1
48 \use_package mathtools 1
50 \use_package stackrel 1
51 \use_package stmaryrd 1
52 \use_package undertilde 1
54 \cite_engine_type default
58 \paperorientation portrait
70 \paragraph_separation indent
71 \paragraph_indentation default
73 \math_numbering_side default
78 \paperpagestyle default
80 \tracking_changes false
83 \postpone_fragile_content false
87 \docbook_table_output 0
88 \docbook_mathml_prefix 1
94 Spreadsheets External Inset
101 \begin_layout Standard
102 \begin_inset CommandInset toc
103 LatexCommand tableofcontents
110 \begin_layout Standard
111 Test of spreadsheet external inset in \SpecialChar LyX
113 Spreadsheets (created with Gnumeric,
116 or Excel) gets converted to .tex with the
120 program that is distributed together with Gnumeric.
121 They are then imported as longtables.
122 As the spreadsheet is
123 \begin_inset Quotes eld
127 \begin_inset Quotes erd
131 any changes to the spreadsheet will be reflected in \SpecialChar LyX
135 document is always up to date.
138 \begin_layout Section
142 \begin_layout Enumerate
146 \begin_layout Enumerate
148 use the menu Insert\SpecialChar menuseparator
149 File\SpecialChar menuseparator
153 \begin_layout Enumerate
159 and select your spreadsheet file.
162 \begin_layout Section
166 \begin_layout Standard
173 a spreadsheet created with Gnumeric:
176 \begin_layout Standard
177 \begin_inset External
178 template GnumericSpreadsheet
179 filename sheet1.gnumeric
186 \begin_layout Standard
192 which was made with LibreOffice:
195 \begin_layout Standard
196 \begin_inset External
197 template GnumericSpreadsheet
205 \begin_layout Standard
210 which was made for Excel.
213 \begin_layout Standard
214 \begin_inset External
215 template GnumericSpreadsheet
223 \begin_layout Section
227 \begin_layout Standard
228 A multi-page spreadsheet called
233 Notice that page breaking works fine:
236 \begin_layout Standard
237 \begin_inset External
238 template GnumericSpreadsheet
239 filename longsheet.gnumeric
246 \begin_layout Section
250 \begin_layout Standard
252 needs the converter program
256 that is distributed with Gnumeric.
257 It is therefore necessary to install Gnumeric,
258 even if other software is used to create and edit the spreadsheets.
261 \begin_layout Section
265 \begin_layout Standard
266 Spreadsheet inclusion have some limitations.
267 I don't know all of them,
268 but have seen problem with this:
271 \begin_layout Labeling
272 \labelwidthstring Wide~spreadsheets
278 spreadsheets Unlike long spreadsheets,
279 a spreadsheet wider than the margins doesn't work well.
280 There is no attempt at breaking up such spreadsheets.
283 \begin_layout Labeling
284 \labelwidthstring Wide~spreadsheets
290 formatting Some types of formatting doesn't work.
291 The red and green texts in the long spreadsheet are underlined.
292 The underlining doesn't show,
293 but the texts is otherwise printed correctly.
296 \begin_layout Standard
297 These limitations come from
302 Feature requests for better spreadsheet conversions should therefore go to the Gnumeric developers.