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
27 \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
79 \tracking_changes false
80 \postpone_fragile_content false
90 Spreadsheets External Inset
97 \begin_layout Standard
98 \begin_inset CommandInset toc
99 LatexCommand tableofcontents
106 \begin_layout Standard
107 Test of spreadsheet external inset in \SpecialChar LyX
109 Spreadsheets (created with Gnumeric, LibreOffice, OpenOffice.org, or Excel)
110 gets converted to .tex with the
114 program that is distributed together with Gnumeric.
115 They are then imported as longtables.
116 As the spreadsheet is
117 \begin_inset Quotes eld
121 \begin_inset Quotes erd
124 , any changes to the spreadsheet will be reflected in \SpecialChar LyX
126 Thus, the \SpecialChar LyX
127 document is always up to date.
130 \begin_layout Section
134 \begin_layout Enumerate
138 \begin_layout Enumerate
140 use the menu Insert\SpecialChar menuseparator
141 File\SpecialChar menuseparator
145 \begin_layout Enumerate
146 In the dialog, set template to
150 and select your spreadsheet file.
153 \begin_layout Section
157 \begin_layout Standard
162 a spreadsheet created with Gnumeric:
165 \begin_layout Standard
166 \begin_inset External
167 template GnumericSpreadsheet
168 filename sheet1.gnumeric
175 \begin_layout Standard
180 which was made with LibreOffice:
183 \begin_layout Standard
184 \begin_inset External
185 template GnumericSpreadsheet
193 \begin_layout Standard
198 which was made for Excel.
201 \begin_layout Standard
202 \begin_inset External
203 template GnumericSpreadsheet
211 \begin_layout Section
215 \begin_layout Standard
216 A multi-page spreadsheet called
221 Notice that page breaking works fine:
224 \begin_layout Standard
225 \begin_inset External
226 template GnumericSpreadsheet
227 filename longsheet.gnumeric
234 \begin_layout Section
238 \begin_layout Standard
240 needs the converter program
244 that is distributed with Gnumeric.
245 It is therefore necessary to install Gnumeric, even if other software is
246 used to create and edit the spreadsheets.
249 \begin_layout Section
253 \begin_layout Standard
254 Spreadsheet inclusion have some limitations.
255 I don't know all of them, but have seen problem with this:
258 \begin_layout Labeling
259 \labelwidthstring Wide~spreadsheets
265 spreadsheets Unlike long spreadsheets, a spreadsheet wider than the margins
267 There is no attempt at breaking up such spreadsheets.
270 \begin_layout Labeling
271 \labelwidthstring Wide~spreadsheets
277 formatting Some types of formatting doesn't work.
278 The red and green texts in the long spreadsheet are underlined.
279 The underlining doesn't show, but the texts is otherwise printed correctly.
282 \begin_layout Standard
283 These limitations come from
288 Feature requests for better spreadsheet conversions should therefore go
289 to the Gnumeric developers.