1 #LyX 2.2 created this file. For more info see http://www.lyx.org/
5 \origin /systemlyxdir/examples/
7 \use_default_options true
8 \maintain_unincluded_children false
10 \language_package default
13 \font_roman "default" "default"
14 \font_sans "default" "default"
15 \font_typewriter "default" "default"
16 \font_math "auto" "auto"
17 \font_default_family default
18 \use_non_tex_fonts false
21 \font_sf_scale 100 100
22 \font_tt_scale 100 100
24 \default_output_format default
26 \bibtex_command default
27 \index_command default
28 \paperfontsize default
33 \use_package amsmath 1
34 \use_package amssymb 1
37 \use_package mathdots 1
38 \use_package mathtools 0
40 \use_package stackrel 0
41 \use_package stmaryrd 0
42 \use_package undertilde 0
44 \cite_engine_type default
48 \paperorientation portrait
58 \paragraph_separation skip
60 \quotes_language english
63 \paperpagestyle default
64 \tracking_changes false
74 Spreadsheets External Inset
81 \begin_layout Standard
82 \begin_inset CommandInset toc
83 LatexCommand tableofcontents
90 \begin_layout Standard
91 Test of spreadsheet external inset in \SpecialCharNoPassThru LyX
93 Spreadsheets (created with Gnumeric, LibreOffice, OpenOffice.org, or Excel)
94 gets converted to .tex with the
98 program that is distributed together with Gnumeric.
99 They are then imported as longtables.
100 As the spreadsheet is
101 \begin_inset Quotes eld
105 \begin_inset Quotes erd
108 , any changes to the spreadsheet will be reflected in \SpecialCharNoPassThru LyX
110 Thus, the \SpecialCharNoPassThru LyX
111 document is always up to date.
114 \begin_layout Section
118 \begin_layout Enumerate
122 \begin_layout Enumerate
123 In \SpecialCharNoPassThru LyX
124 use the menu Insert\SpecialChar menuseparator
125 File\SpecialChar menuseparator
129 \begin_layout Enumerate
130 In the dialog, set template to
134 and select your spreadsheet file.
137 \begin_layout Section
141 \begin_layout Standard
146 a spreadsheet created with Gnumeric:
149 \begin_layout Standard
150 \begin_inset External
151 template GnumericSpreadsheet
152 filename sheet1.gnumeric
159 \begin_layout Standard
164 which was made with LibreOffice:
167 \begin_layout Standard
168 \begin_inset External
169 template GnumericSpreadsheet
177 \begin_layout Standard
182 which was made for Excel.
185 \begin_layout Standard
186 \begin_inset External
187 template GnumericSpreadsheet
195 \begin_layout Section
199 \begin_layout Standard
200 A multi-page spreadsheet called
205 Notice that page breaking works fine:
208 \begin_layout Standard
209 \begin_inset External
210 template GnumericSpreadsheet
211 filename longsheet.gnumeric
218 \begin_layout Section
222 \begin_layout Standard
223 \SpecialCharNoPassThru LyX
224 needs the converter program
228 that is distributed with Gnumeric.
229 It is therefore necessary to install Gnumeric, even if other software is
230 used to create and edit the spreadsheets.
233 \begin_layout Section
237 \begin_layout Standard
238 Spreadsheet inclusion have some limitations.
239 I don't know all of them, but have seen problem with this:
242 \begin_layout Labeling
243 \labelwidthstring Wide~spreadsheets
249 spreadsheets Unlike long spreadsheets, a spreadsheet wider than the margins
251 There is no attempt at breaking up such spreadsheets.
254 \begin_layout Labeling
255 \labelwidthstring Wide~spreadsheets
261 formatting Some types of formatting doesn't work.
262 The red and green texts in the long spreadsheet are underlined.
263 The underlining doesn't show, but the texts is otherwise printed correctly.
266 \begin_layout Standard
267 These limitations come from
272 Feature requests for better spreadsheet conversions should therefore go
273 to the Gnumeric developers.