From 23c6728eac74bba6a0cec1ba9a2654b9507d7066 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Uwe=20St=C3=B6hr?= <uwestoehr@web.de>
Date: Tue, 1 Nov 2011 05:38:58 +0000
Subject: [PATCH] new example file spreadsheet.lyx to show how the spreadsheet
 support works and to test various spreadsheet formats

git-svn-id: svn://svn.lyx.org/lyx/lyx-devel/branches/BRANCH_2_0_X@40121 a592a061-630c-0410-9148-cb99ea01b6c8
---
 development/scons/scons_manifest.py |   5 +
 lib/Makefile.am                     |   5 +
 lib/examples/longsheet.gnumeric     | Bin 0 -> 4405 bytes
 lib/examples/sheet.gnumeric         | Bin 0 -> 2365 bytes
 lib/examples/sheet.ods              | Bin 0 -> 5586 bytes
 lib/examples/sheet.xls              | Bin 0 -> 11776 bytes
 lib/examples/spreadsheet.lyx        | 262 ++++++++++++++++++++++++++++
 7 files changed, 272 insertions(+)
 create mode 100644 lib/examples/longsheet.gnumeric
 create mode 100644 lib/examples/sheet.gnumeric
 create mode 100644 lib/examples/sheet.ods
 create mode 100644 lib/examples/sheet.xls
 create mode 100644 lib/examples/spreadsheet.lyx

diff --git a/development/scons/scons_manifest.py b/development/scons/scons_manifest.py
index af9e32298e..6a56fdefb4 100644
--- a/development/scons/scons_manifest.py
+++ b/development/scons/scons_manifest.py
@@ -2831,6 +2831,7 @@ lib_examples_files = Split('''
     listerrors.lyx
     Literate.lyx
     localization_test.lyx
+    longsheet.gnumeric
     modernCV.lyx
     multicol.lyx
     noweb2lyx.lyx
@@ -2841,8 +2842,12 @@ lib_examples_files = Split('''
     serial_letter1.lyx
     serial_letter2.lyx
     serial_letter3.lyx
+    sheet.gnumeric
+    sheet.ods
+    sheet.xls
     simplecv.lyx
     splash.lyx
+    spreadsheet.lyx
     sweave.lyx
     tufte-book.lyx
     tufte-handout.lyx
diff --git a/lib/Makefile.am b/lib/Makefile.am
index 34bb52f292..30bb57f7ba 100644
--- a/lib/Makefile.am
+++ b/lib/Makefile.am
@@ -262,6 +262,7 @@ dist_examples_DATA = \
 	examples/linguistics.lyx \
 	examples/listerrors.lyx \
 	examples/localization_test.lyx \
+	examples/longsheet.gnumeric \
 	examples/modernCV.lyx \
 	examples/multicol.lyx \
 	examples/noweb2lyx.lyx \
@@ -272,8 +273,12 @@ dist_examples_DATA = \
 	examples/serial_letter1.lyx \
 	examples/serial_letter2.lyx \
 	examples/serial_letter3.lyx \
+	examples/sheet.gnumeric \
+	examples/sheet.ods \
+	examples/sheet.xls \
 	examples/simplecv.lyx \
 	examples/splash.lyx \
+	examples/spreadsheet.lyx \
 	examples/sweave.lyx \
 	examples/tufte-book.lyx \
 	examples/tufte-handout.lyx \
diff --git a/lib/examples/longsheet.gnumeric b/lib/examples/longsheet.gnumeric
new file mode 100644
index 0000000000000000000000000000000000000000..312c781fe74597b7a939bf25d6dd82f4baf61e76
GIT binary patch
literal 4405
zcmYLLcQhN^|5l}1ySCb+suZnNt)Q=6f)Xn#)QU}Guc}dM?@gmsqh^s>O>K!Pv4ez|
zr4+R{@ypxqd(Q8#dq3m(+<Tw%oO>R=`0Hdt{-5>9u5MbodroUI5ofJCE1tmopV-EF
z3S!Np2;b|jC^}B*1Z5X7I>97%fH0G^xXrVJhsa{lxY1$62Ps3Qh9}~Z{#i0e#NL36
z$PxB41LE1)_eJ6P5u3`rdcvr=>`Ex39{uyJ=sQvc6Q3{mtn`Y&TmHOrgqNXZ;o2Gd
z@7HSO^u_|W=I4n-;<B*CfH`-9^=^RIcHLO$T3M+0)>#UL>#Hp~oUUh+BGu(rg?3&8
z+(7V6^{2lz?5-I-9oDs9dc+r8K2G;4<7`)8=lKPntX{>5vWzCzz)1kLNW&MJEfqkt
z^^0i@#=b&7T}AMl549Y!QT>ssL{Yt^d1z|Ax~vHoqVb#Ds{%yZ$?x~akT%XhnF;Gb
z+*ugmD5x)EF1ZvyPwf9VPNUVQuwoOigu*cz6#;s*q%3QR+rJ6?>nRXN3m!Ma^%fJ#
zcJ0U=v-eItAdx)Ha{u%Vc#<+-V0=b0Iz*l!_vJ6b*aL0NJ&saXfpohmGX3M8Yg$mI
zNXt8`o$2Wp11~huwNW4UQ3)khyu$U*-&SjIA2erE#E$c?l`QcVBAo7yiXZ*yi^-(Q
zy&v<ZF)BA{{VUb(pZZD_$x{qFOf>jp=_;G_&YPcPMO~fspNCT_GFG3P#(G-;w0(v$
ztkBAP{74VymIoyYRZY8r7|+<$c+_^U(p==ziRpKT@kzv@F<!p}_`*KzUUy~WGQq*K
zd|Ux4oz!N|?53zXOpcSk?y;8h*<B;H$i|&B{`zS?dlLHxZc1CvFWX(>*9<9ExJ96h
zfe!@~b-@L_zMSv*;-b|lTvp9wX#=mf3odYOW|MI+wy6CnF@y5~xEuG+cYW{QFiL4i
zFcNKtOJ}u39XyT?IednfM$zg0?pI40mms5r1){bVMjP*SdmJP$BK23kM-7xEeN-7!
zKxe_k^rBk5_8%s6pY|l<x55jlwa49a=0R-0(z~=XunJI?vB{VfRUcrV*B}58nW^_v
z2YyZYti#sI@>}fH_GU66{oG%OW~VEPIua)_mzKq~55R&K{O!%51%wV3ZbZtQr*r#{
z{piD^f0$+{Y*LhY8)v_@azF~{uXT@{A=VK~h&{wYJEHJcWR{5W)kKQJrr>Q)SBcs_
zux0iBw9EX}ONs>tS<GiKo{q0=uIx%Z4lTV@gN_#=At%Vwb9<c8M7fh#?`FS3%;?C?
zjWLV@Bo?azq0<kYiNTh5c*7}d(+`rp2yxMw@?74##nGdVn%(?#xO6e%`D8>{draR@
zs1mZVGRxk5bXgXz(KJ75<&fY;w{%0enCo$INDah`kyWxXQpg&;aR^}v(;9^0G%eO&
zcaLQZWvHwA<+G7PF8YXdQ;cHdpcXn4VUI_}*JNXt***cS*??r%azsW`yC(`zc473M
z<i|~??=&tW<7TvA>~JZ9>YHSjw`(9C5k|6Y<c3hZX6I&%*20qLQ$Dq<`FD;0a_CJp
zAnNS6j><J=Rv$I-DUd=qA!Srm_1akCQCgE$SYrAuy#QKW!jaY*3vgiXsHz$-#VF42
z-&N4-yg|8EfAo9sE0Arl!FzkMJB#0}jW2>pB^Yrc^_n(0>C(+Puy*#@y0G`Biq+fA
zVOf3Fysez$wD*rXoKOEDFZbomMr1WWk~en-IF}!rDH+RJ)x~~?ge9Wyz6pvo+g;Ql
zODq0Ptmg^+F`-{JhM$u6lHJ@Fr4<2}?kQj1IQw-pmCt}v6VqyeN0j=jg)-SsngK9l
zLV?VsU?Nj9uY*z;$J_&Jdg^&<Og$@Eo`itD;vqVPp|C@xby20(vy}y^Y@wzmKqW&V
z`a@8=u}e-jj`gbbfc&=?qrHHE4kB%iTgtNE){|Cqe&14gVWPj=bw!5<xloBEg&f_3
zvq`HAX1ND{@I5>%GG=sQB`8DdMtv=72}}QmmtP$=**&t^^+me+qY#PMAF&w$?S9Bc
zKOSMzyviuoEq3>8_G*O17yTRaa0}UA-V%A1MN(}Z?+mP(b~kv;yy`|T1n$$}w3J;j
zd6CuRg1Le^8Q<(dk(b%lYtJuqF8^Fq>;ZSeR?T`jg)T}h`=@?ep!F9L#{86%U47wv
zE^T&`(oI^`ce*E(-v(;-;(hOoG*R)t$`(wCQL(-?v%fWK*!Y&&f5`4=!G8I6O)Ein
zV{2Mh*}JF;*wKdC@7?r}SlH+%AkBJ4QU#Ohq!vRcH426rkiNyjb{o3V)>=<j;uYfR
zu!ivBhbwIz^-{Hf1&bBaNxV!EVNmJ^3u+3K;h9zxQuFeKU~FZJfn|F{j~si7l*?wl
z-P&^=*TVHbUNvV8$60mQro*+JrcB<~60=So2k2Lt7vNX0U#-Ojo%v_9#QcGI|0#Bf
zpGqTth{?1_ONy5%4&v=Ot*=W$k0vnksZq@F4X;axx}PCy=u^kIMY|W9a>xTVn;@R^
zY)IVJ7O>0&?6WG;<~=&Q%ia0rmE>yBZ&X_fGY0GV>4)m6(RUx0GtU0d=!<&Sk=}<*
ziG^SZpd|tvvh&TxTZ?_D5^yERBaiUF%7W`_Mlf3=)NaC8ZsHo{yyf+F-vJAOG9)pq
z#Jmh52QmK&J(Z)unTJw+zG#eL=IvMd-MCvx%SQMu%VJbQw^hT6oxw)?>yoXTvRWv;
zCeVO6OjR<O-SPGIO(C%P)?<2@sLJ*io8W>yr=r_?If0>qD#Go{b$-NSDT$oeWZJ!h
zx8cKezCIg_=&VS#U!9E6GQ$glM)DwzCvzP0OtLSig*do`&WrioJ+v7FCZgZm1o}{~
z+%rnCF1*70)0fiOP7QCI5`D?QyRw6G1#>E&V@`Wr<M};4l-^n555Fk6k1jn)ir6nb
z;h|iU+k05#F+xCN-g#v)@;ZG)-*Tti(R009V_ONHMpZ{~N7}kKr8@fWl$0Dp%`g`1
z4f2QQVa&X%MH7B_mMDT|%|=D8xRG4XY#mkSoDiU%!!8~bl)pHHx?Z?49HoGD;x-3$
ztes?(S<-;jcQ$RSBnAnkoO8}!=1Ii>?i0sZg;K7X$)5XZgdl{*B<m&`lrcT5TbiNe
zVPI7MOkFxKI7wAwE$M@kG(2r!Dxo(S&tV?D^6dkF%fJAbwiXaET4(aJym5(NA}Rhk
zS#JrTf&SA|=+ZMi{7jrVp|dkDU0#kJE9~l8YoSr#QXN?)a)h7ZnhRt$dTdI&9}86s
z5JotAEQ(qrmEC>OGSn+vxdV(UmVtkIR&5G2^#OoygbQij7=xyB#$GJmrO|-#44Gy0
zl>056P*)w=Du<6}{QUJ8UX`+smSJ6tTaW9DONu;X%}2<7*Lj>$qi0?bnD+@%+ic0X
zX86TLhj0L$fp}`p`f50h7e>~sV~)ShCe*ISB|tp&aR<=_q#E8A1$^SEKYalG2JzIM
z@kP0jBEmuGf4C>I@bFfyL>zJ?p_MDn$q677{O}gS|08GcLzXKe0V0PUvJP9CGKU_b
z_5L3p1wYIqE&tYV$en}@g46fe#OMveGoWFDqs^8kh}3Pj6)gzmqWj-K%oOrN%p}^o
z?k|WmS1q-bYp8QJ5lX@i%+jIkQ6ch&9`bfuP|^`%E8-&bxE>YSC3C&g{`*Pe#VT~-
zf(@}ka_=B{3Z|f`64Lf|T5g=S`=Yj<L$(P0u&|%=BAMRqO^pzFSDowXq==Ft4J}7W
zK@E~&6~8W$gfS-Nwt;rpP?<1!)+_j)D|rKwdffT38>3a>j;yeX5e0d1gf8=2Cqbla
zK9(7%5!3iG#?&^Ojeht`&$NrFQ7wxAzDt*yG-n}`;uiADwkkPgsRT+j!UUxK%psc%
z{yt@@B+5~gbd|fMqHIZ%)ElD}k#1=?x#E8%BA0|CRTjeZ>KhltgW>|*vBu|_BmnzO
zZRljig)^Yvs7laWF7vfC@=IPO(>(y_gGF^tm3csY(Raye=rRS(Ux92DEvD$%Wy>dF
zi?g4?ic34Ps$<6eFoj)x8>8sDye>(1?((~-1E%UOTv{%>>u6tWDC>zq$b$LJ!p%G;
z@>B>u;7WKgOz%o~*SH&sIwH|dCKG~J0E|tQ5NO}KW3yLXb<Rm|T$%#fXZv-Vt+CeO
z&~@Nk2wv_rysS<a30CSfedEOS*6B8>iA+!T+a~lj<#X1eoiuXNAUP=!5(|m!OxpLW
z&9zr2SeT4)4(tZcv^VPG|D^_J0yO-pU?pDL@4;iAK2Rfo6<ai}gbj$)^-I!E3A^T-
zoFn4`2-W4s;-rj~I)5$%bXc}iRb$Kg;W_B!4x--!VWi4FWc<lgTtplK02|t86QIj)
zB;lV$V?mo}fqb+iQo%I6?V>w1kNi1AqxjFnxea{a-y~?tp$XjAUKuk^pEPdlw>EBa
zX7W=-g2$U>2UmVqfDu;`$<C;KYm$Xg6o@gb;#W|R2a$5!GKrAK7&5#eg;QB+kAXur
zeG*2UgziAZ{reB)XW~jgd%ps2A${_&%-k9=et%`7KbC#%9f=vOn?*d|ik~=S>to_?
z2>Y$gM^R7%72~2P%1Tq-|B&PX{3B4OOEp9yXw(pBIFn~aT-z9RKcxz4iZ-r{0ac?P
z<o8HIxNDzI$X6bdsM(zOE1UTLmyJo4VDn$u_~d6YS^g)R=D)HbF+;)r-@lR~!2lUe
zLjmD#DCPR&2k)+pyxDzJhEyFU3efH}g=4vzC*~e%m`SYndO>Ofy3RL*TYm3Y?pj?=
zt<og`0j^W{r(1OU67O{Muy3{3Tz3|Jw;X+EFPH!64NKd#S^p%P4wmBW`r^bs<7guf
zV>Fhs3uUec!(J^Y(ME#h%NG}Ex38>lNjGO5W@&li)CY;{{G7c;^G>O|>vimG-Fmj3
zezzre%N&2`vhGDMTF}Zcv}(aD=E=Pn9`!iSBN*<jpiub=+wnB!WuTRldy*C}Zs`8c
z&o9n&sEg%WTdE9t1mtidp4~guL;~{VysP<dctqUS=3{v7Ict?rV?Y(TuzG<z!0q5p
zaNBdZp}l`}nJX?#m5*P#cg>N*R{2o=Cuu+W<v#E5J_%?6?N;hg)z*yvW0|QKG9S{Y
z&O&nY#}zVJzM{8;Mglmg3?Dy^0}uKXxhtu}=}lg)xxC!9n-F*X<d?sv9_mC;`Qa;m
z%M|Yh>`T9;lg&vNDQj;~alB_u11AcuD4!i{;A<=<nu-cEVPqc^F1_}E!!%NGie<*s
zrn0}5K9lO+kHj7i#77!O#6fzv!)5-)whe3Qvx3iUER5LGJEy(7RkoDj<ug%YOicx4
z>i-#fUG?J;BhIdsd)LT-0&~vJm2=V&?qvP{v-3qPb*5}eSR3*)zIGZ>mc)qZo5@|h
zhJwi~D8-?Gp5C#XA&%MJWF>R8eLt~AO^i^8a$LaUJQ{XXaNqRDsdy2&JbNmmvyVR1
zA}bU{UfRC1f6aV^f|K-Ngbyy**AXHTzhV(>OQssWMdNdV%g4Mvu?z4ychv2-JBYTp
zldEQ;A=OFw1xVao#k_}xwNUAgF)%6bdI{z=RBZ;iB|8o_`}w%Fz?MYk4~fF_A=tLq
z^sq@pwfOnQjE+U)K{2?~-|P;i@h%m{_RqN0qcL<#)1+MQfa&<muN-87-K{h3z4+xE
zv~n*gKI8T-wEN>d@G7Zg=s|ljH^S%cW?Dt7V(?}OJPSN<{=q+;A?1MhuGjxz!Q8>?
PV?O-XLd)$kGP3^z*P7Jj

literal 0
HcmV?d00001

diff --git a/lib/examples/sheet.gnumeric b/lib/examples/sheet.gnumeric
new file mode 100644
index 0000000000000000000000000000000000000000..46c23960d0d553a1ae42e9c80056dd538ae38a6d
GIT binary patch
literal 2365
zcmV-D3BvXtiwFSAcdt$W1MM9BPvgq*_xmecKk2Eh1o1}_f*;9KIKmMLC`tm?UR6bo
zy(C*~Z@S*_@&5YG?%Iw&A*rqqz?{T+XJ=+-XJ%(+O(sXbKl+|>k7$TV&{g$)O;u3f
z5ElpYu6jK=-Rr2o_r4s>1K;{i=-rHvI|WFB&;n3bT`;z^8jXjChy8i5@)5<(KB4o*
zy{_%M%vB@Y#}H?5A54K|Xqw*m`^EX#Ss>ru!$HXGz(GJ2Vk;EDbK=-c$X2=3;r?Uj
zs=Y6YBE-Crn^6W!;w)fGs&Zlfn^1Uyy<OlyJhoNkbme(`#~>*T8wq`%F^Xp^hC&X?
z10^hivZp2LHIEv}b9yqcebkF}c7xG_WrYj!FkKLe{~!Ugy=mxB;(0ThN*015&Enqn
zR;V`_T@NIJ980MhC1U+-QNb@5cHV)Y0bz)Prp%s&yC<VdruK@FsYCpwhqycMo{Tu0
zE-9$dVaR<}y3_vocq8$0AaR_I$n7n55NO1KBOI_jA2B-$5^}1mu4rHpJH(-oAheic
zktGUZ5-W{uiHH>i84m|{Wno4?JUncO*%;Mz61?S#dIHOJ8puO@g|Gopp%LS92{#pr
z<EBL-gd_`bbSZQk`<e|oR+VTosW@z?kzS)I&N(rL>sYQ0N;WiI+tZCbU7P5J)jF_R
z+K;0~JR4&Rp&W`t9No(hYMqI0S}oHuIbjK6WZRq&2_R#}B!YgmJ!j<!E)aWzmF<lX
zL=n(AC}t4YGY<_JqETEI0s1ikggj6KUILg951s<<8QMN142awwvDwIW@ncstqTvai
zV+OP>GZo6m3xwDu*lQTL=rMI<k_kn~OFW=7T96d@a6}$p*lxAVw%Y5{J6$?*Li4}!
zF@6#svxH9$l<Ze<|Aq+IhdwFavCDW$G}@rxGlb_028{JiUS(lkH01<`OV55fCDaGY
zhQg9(*hN1OCCT6$#cncyO`IXyMKpoHK2nf~<KI>c4kikPA4G%klRpC$93ziBl)y()
zZh+t55YMoO*;7~jc6l)!pA80+>CJFFJRY78C;yO-=L1#YqJcy__iGmXQ!{~0XmM@n
z%Y5Ji{{-SVnnt4>0_?8WNf7ubjqrmIzZbC=&-vxU7?Kt#0j0zC6~zIY_TiWo!*niG
z|1uh!{;3eEQ)o*PVt&SY{YbV1u$HEvk{2ZuE;F5A=Ajow{PjO8!hYkrmrp-k+BGE1
zC|#&=7~FzK+c_T6hI9_~Xh8->mdX_YQtq(^`0*7*x7Ps%hxC1UjxzW&!Wi+lBJt2I
zO9&2(7x5`S58Dtd#3|f{;+8;Vuo*>s1aj(=u>`UJQg}7eRhNi5kU8u*q`&pE4E~KA
z-94X$^@UsT=#fWQyo4}^^ItuS?olwsw^I^$Pt%Y+c_^$#_DKL23ko5%8powJ*syY%
z@uTs~5>PKfMGN&9sJj|VOiv*-&YzKlP%w4Row5aNF)H6BERTn|1;j~M63VEJS&Y4&
z$<oMZuAGCvc2$12a$OIE_|^88zx{L4KmM1hM6tRc)~R%;Jn0p<fFkLy`rii6Fj(5)
zG(8+bWgUfO3CW!LsxvN~QP?@}p&U3ub6&c@Wt1|A^den}!HDN0aYJ@vI6Mld-ck#v
zMle&(`W~LkI_D;OgyZv_+RF)gWP-_f0fOF5$SIcN5n)krBql-2;)!SVKw`kP_zt;(
zDWp~a3n-*#6el?4*mj^AK7}7E`31+;W}x^WlM6W=C<t;W3ZT^TGCN5O2CgX2JHJOC
z6Hli4A>3oJtn98qJj(O56dTI^J2ZiVvYIa>#G!a8#P5ymAiAb;z8S?e63yjfO3F6d
zTaDlNW3wHs&1SS}yX~~yL=_wxu5GR@$LrzRcDrUfy&_UJ*M`$-qwTWM^tI9SRC;^K
zXr0$HT1V@=W4oobcbu!lQu7nIX9ygjh0Jamr3Ac`+K?jUB}EDTUw&nj`jzqN{Yrmb
zzdDxp(GTTXW~pnLpD@qpZx*jUqF*&j{p#Qo`qkUz!Cm)}PN|P{KDUp&a!%X2R{Ds+
z>ag^(Rlk<nx!aaeaoaNM+txd{ZN1jnHY)B;W_@>hA9trWaTK%EQC_?WH9uYssBc0)
z)32JPepTOucDlCclp3wRn(Ss_vCBE8Sy8e!>yq^yl&lef_$0+HJC;%ESap@V%T?}s
z@h!8|x9Y-p*Bxt%!uY+oVzbm0>stCXU2*4~q*Ll7b?v^>71l?|oUMuvaUIluSJ>gZ
zf2YD~=?_iTA9vk7yS1AYhU3PnKkoY0wo6T98;E$9o^pb2?Ul#I_z!f&J7b#Z6dj}S
z4g}?rL<x-V56~deuehd-LTf{s!i*^leg6R5;moEkUySp5j;@(nsgd0Zmpii&-d|YQ
zh;H!paw`C4aWA^L-%56KP>?E3(@AIq_ncr{j*MVq<RM4&geqTGG$d4>7d0BmM5N_~
zOsLXlEb{^@9UN0BP0I_kUO#Ji<aznN5e`%0*JJS?=WlpZ&O~%OwL#1Y3YiivDYD&A
zG*vpb=f%y|oIxc|qmrj!lzbn;2CU3VRzrsTEf^RD23H^f+Jb{w;PA^9)Xk!PA*6X5
zaA;PlV2Oe)=(8GV0==;XwOOEUZb1$I4<46vcp~1scE7g%deYi}yjAT;4i4c=ZNa0s
z{mvHD#qH}`P-nJZh=U1w`<Zh?P`JT@?aIxX+7{%+-EQJ4?d^8ksg6ASWGLavS8fSa
z&^@A0Y=MKhwSf?wM2KD&IQ)6gvId>M6baXmY_z;UbdFq^Q}a<%%=L~<YY_FcOF$`-
zVGWEDq!cK>h|C5&K%U!AWW^M?(8-3weoBoJi+G?E<$}1#lWNm=hbx(R$WO)>_TvQm
zQl;@%7Vxyezpdbs1ea(obbo?FN4B{4SB!|3*O=X$+Wv?SqSaGf`w<`+f0B-S<N1zz
z?WK<UHA3BSzir38QFq)&Bz4Dq-Em)c+`os8`}&>8yL=~-t+t+d;gBoKN?!nInHK;X
z-T$lHNlUjSZ*lw2iCNc}yIf<Mb&dIEHKtkDn01X=*O+yUS=X3#jak>2pQFZ14ds{q
j^5OOH#Adc4cZ}SLJ&PDf?D)%wdtd$wMUlIalUx7*1=f;;

literal 0
HcmV?d00001

diff --git a/lib/examples/sheet.ods b/lib/examples/sheet.ods
new file mode 100644
index 0000000000000000000000000000000000000000..7691d7f680da1cfd39384c30d0e1a02195f9d197
GIT binary patch
literal 5586
zcmaJ_1yCGom&JVo1PBBT5JGT=0Kwe{_n?Chg9Ql#1os4opurO)xP%Gr?l!n35ZrZO
zA-iw?x3B8$>AGECSAFMJ_o>^b?stJosA$AU4;W@O6AN|_j9|ZCKLpl&fNjAbH!mlU
znUj-)t%aGJEyR(--O-XAV&-b=$_{Y?Ia)$2-hx4nZtSj3E+8{YR~rz>4frP~)_sPD
zocC$|7r6H;3y7oJ1HlvQuxpI?nD&bNw$V?99Sqr5rNfTdw{Q5ZQn(Or@U~|6w`x&Q
zBC2WtPD+&-x2qqbsrFL&nH1K*b4>$Vq2=kbV_%Wl*7`EvrnfsofPw+Ky`17RjD<(;
z0CR)AccTbIzc2`nxIC@0F6*%aJ@s^aOz%{_&4S_Vb5VynY0RITAL%H*ASf|l?n)|{
zGU#KW`g%vU=BMq}_f6$Rv)c^gh6V!F>9fO9lUnZN!3mlEBN5ycH*kCoc(%{zNlEIr
zCOQzy61Sl~VR^$E?GjwV+1_yPT*hPVdhy57l4D(C=_0+`g06LyzDYvY`)Iu(+%If-
z%DErG1Hu+QHHByN`k2>WSVh^>Le?>c9*>U|NQlCZnPK|LAHve!`rAeUa`G*tu&ft~
z(>CtoQ)W1<Qqlfd{`e`?Is^wQwCfindAPO~`aJ22W~~5w8dr@3TUqs|Jhui>+UFsC
zEInwXPBpEjGs)9TTe}j6Y&B42&DAamXVh6))*sAjlArybc&EPd>IylV6qSE@5mG3Z
z?lk|t<a5AOa%Tl64{qA+em8zrG{7B5=di$0qQ`z5o2KWsYc*O%i{PxmQ%_D|L6^se
zrLSJM+0!By+L&xN`A%&~vvP<GTy1%?JcELQ@k&x=%Bw&x53oCmK`-edpK=6hd>UJ|
zmb)FIs@%Mie`@qm7A}s?T4@?g+26D#6Vo!Pf+>%z*(qgT(vu1~#6hoJN~G#A4l{_5
zYaN`Z<J^|d;b;3f8&;<nSg%fPB;Fn&rED`&5YfDICe?x<UX2s_62H~C{n^;$8_l8-
zlc7VYK$FmnE=rp(KHa<$y%FKl*-Aorbeo^VWCkLf)kJ2Sr!6CDL0l!6T?f)+x$jJ)
zRD-y_VRl_elf}O?Rla{H#q2tfCaZd9I>6js4z)DwVj^ps)SLnG5ffuL)nO2@EBnM4
z6QbcJx%^f~m%m~+<E%gU1gM_*6!k`@3pINB16G7u>$>K)@R>jY+IDnX82A&TdEhCn
zP7Ve_82`$Qlbdnvu1RatVb+`KU42LAX>qJ$4G^1FOC_|0kBbC6^<K=j1PMwPBb&)l
zQKQ@hT_-w@f7_2Cr2^lOp2_t6wCo6!h)3&(lML`*)#Jb|y)*X=AH$gao`cO4v3<}G
zwVMTBPp)^z{St2Yp5jf+-GE4mcUZb1jyd_!Q)xxL@=rKR2!`uS>vhJ=&0}?X8M8!*
z{rSVFUO9?7>eu3n{Gds7d9^iYb-7#>Fu7uKJX!9}=b6@=ql@P-r;hDs&b0Q-h_Jbv
zy@2zuSC`OkZ{Sl>&qY&+a}S@OucV;UIyb)hPC$}T01%6@lW{RecoT3EyW%FT_%;*2
zBddBM?n2Zr=xy2OXkA}yE@lhlbqv&)HF}j_-?>)&EQs`MRE)~+#&n<t8dI2u-j<O1
zSiG3v*&X->Wve#PaxJk}+b)!D<8iQw+~iD%!JY?aa%CmbCC+TgvOcQc2g1aXU13Nr
zft~*(Aw)O40l!KBr)wlol>hVL0V!n_g;778_UB1YdV;ee@<J{OK2kS_MkT)7%QH^J
zL{K$X1?}o$RjmKh^_omGT4dxGA;=pLOUD>0d5y?8x(_O0eAO7Zj%ThMU`__#22wL4
z*w9Vm_RWzjb1}|RSQDG6xIh$z{L})q2e#gis97(egt{{hy{!rUYws9ay;~R4gUZ}T
z7#y0+26x>zTnW|BnyHSYgp}GtE8;RlQ6cGVo{*YWeeO4pq^g6aA1`V${!n<d60D|e
z&{iCJfPu~dW)C`e)K>$YK3b4DG+sn2+khEds%9DUE=|5}?T@#Ay6-{;0WD0)y(O#&
zHXwf=4H2;;t;TQj7?-`+Q}oe1p*-TIUYQhbwZHtf0pnSN(Y*DY##=JR$KgLP?z#C!
zxj>a*mt3V5bT9V~Q4Y*1sY-YMc5=*E`1>CQO~C$QQG4W1*x8|RzbAfmI*IyNQ%0jr
z18l6z`m#1>58%1`?o7@U#wgf)t!|>rEA6>9sz0<(9ex16yl1ejiGaJtmohep%Y4j6
z$BdOcb|Y#X8`7%xtqmLOx4z}W7*##8L|@t=k7nE;my6=^#RRKBk?;;`FjmykLdyiu
zO)^d=0wCS?L1GRASGkLB^RI43B`y%xsmnA7(medT&1Nk`z=g=x$a@9<4MiIAgCf7>
z^p;J$RtB#9wyRO5AnMK@ONuB28SFLiL)Hb^j0>^l%r7Y=x2bfBmX>#+gd1GNsIcBS
zg<%#lO=1eRiosQ9PCJqWi<@-mrG{4F;P;*7DP-=S+W0NE_pmrO$7f!Kyn>BMMi6n5
z35yIjt+|Hnh6Kge+8D*v)Qd2^3FOvltsB8!^Vy+W(=hDk2S^XrvsNlNkYo!D&^f#9
zP~Q}V9g;h6WegH)Yd(&Aj(VBX&k*0r=NMy87e%S#JW{%W_QBksm?T7jAq)S&Stc5c
z#1oH%WUfn1L$=UK-Jf34EtNA9FFf=_jDEjQzHmv?_yy6=lkag%pjA}XukF8jClusR
zxdJ-imB5REjwm(nbv(%Q^2is04Y4t+?Lruw$2t|@G7|dBdIy%REK*}GQfe;JXx?bn
z`ObN!FECijwxB1Rji1yQtmS}eTJ$4igNfy7ofUyZ?c&n*D~`uYp_t{8WW9mhJnEIG
zrA#9r<U}2cq_}VWHPk=1(h*m5LgxIP+&3K@9#o{g{b8S*On-W4L@gm(m77VNTqUMV
zc$eX#wWL<Q&R6l%&7d>}py2X2FmD)_>Q?IWi_ZajFF6lqfP{Pdgz*fmgiChqE3eyV
zr{`AFV=WpH5E|j|+)Hh38Ud^$-M(RgkLnTqJVBSQ{V#s#dz$yJj#?lcUak$L9A1LJ
zoO9Cif_JNW`<^o@P*l=rw2{m>FHT*431NoiF0^!atC0}wYO`Eh#^$J)4JZJGrC27p
z<Y#1AWASL6A9S~o%7+EtJGCXV*4C5Vwg)egOH$L7#%pcByeW41D`sk{xF!u7RW}_~
zH(2P+J0VA`Ay(<-qk&apn&%fMt)Kkup)>69QADv(@$_-d>6KgcqG`2TDJtDW$ur%l
zC6dxL_{bl4Q(wLLKGs*>j$++Z^_uvc`WfPp=)pQoiIzav3?idlDa-HfqOPoQd-R8g
z2;%JgXoB}CBY$d?pMxDUnn>wKa-8c|x0B+*suQ!Lth$k>RrTV$0K0jiU+Nj-26qmc
zQsdU8-s}Q`UElYsGQ&WRFusY3@VR7F@3Om)wysDRQDy!<ls#Dmr)&*s2oiXJxaUGe
zkCQw7pcOZkks5SNzZU%vCgL}KM?SJgb@GnAbz$L+b3MFX(K6?qYDPPSi;)5x6Z117
zVH>(l*4G~eh;!*)4*S7;&y#Twav`j|x?N+SGoy_cI#+kCjZq@HW+MtbKfm>KOxp@7
zxOQNaY6^cBtCH1r7q*RFca<%CC-@r$ndZghs60*PCslmKF9w2=lhmJpu2*GQz*DK9
zzB|pmLdh?y*L4Nhr%sH?3SW#0Bk3kyAc^s3Q<shhJ}!Fm0eC9+Vj}%kjc%e*@vxim
z(&S^u`G&`f!+h-dt>txC@AU938c+!nYa+ZaHW3F2i6|Ti>EFBA`wd90Ze9)`*FVjy
zp3=uOA>zg1GI1?qA#tlb)e*}gM>uS=1g^Ls)b(E5f_^Tj7jY_5>!0$PoY{EG(MmQV
zVAx~v7gW#d>H>aXqn2o;;jreA*hNSp{X|)7?xOpAc$4e)0($<uKaMb!G|mk`f??~r
ztR?rE)om|$u3nQaS&t_JcOIBQ5!as-q0WRq`rUOyExjWD_ajO>iYvP$X2Tt2()}cF
z_hldqSZ`9~PyrkVHYO+~n()cxOH1>!@$Wp3&>iY10~=9{|5O+|M-(-iC}=axT2(2e
zyWylL*Vk&!XXC^HRZDp?EQ?v6Rsi@sZJ|#nLY_BR$xW_~nFbCw6rE45hR^8gDoWXv
zJQ)r_9iH<xVTJ7ba2>PC^ggj(9?kX*RPo6#{Md_&wb0!^y~g_0>Z?FxMq=vADR%aF
zxzH<(J|?Z=WzzXznCf_FhZyGO?Z<;RTvFOdjDA5x1HEYM$?*i1<(WckX-b_K*ZL?}
z(&z3X1;JJ56S~Ax;iPJ&#zuUI<Be?rjd2W`)*XH_u57@Q?g$-oY9I7%ITCtR-6sqv
zW4UdQp{ou21Ww{t+ZUJY5wdaT^NwoE0~`g{Q8yljQ{WqrQvi;^>W4JXn525MoAPKX
zeL6`&8V2`4gf}YS#h1@G$1~okP%1w4;?HmUI6cP`xR=b1iZv>U&`X4qTR3FRvJFc<
z3s*?VYXgI$9O|4K6vq>IV`Bnj_j@p}X#(8G$mY%rU#Tj&QsnDtn*;+cd5jeN1>w$?
z6Otv!7l55b9jsa;vms`iLbU<(X_k4qS@LNs+E^dzNw?DFL8KZ<hQJ=B0X`~_JNgPJ
zm|R~x%fLt_E`kP5uF&~;eFiR*dku~frk9(a5tYIwqiGs3CvLBrrZ%tj%IKE{nG9{c
zw4pUcEhXg~?BZ`0{ymbkD$d_u@HvPNn3ZH9X$GmfRyQw06-CPf74A@3ee{xx6|Ck}
zRmC8}0O$f+h0^<v185B~mm#uUWM&e_966W2;??+F8=adzy)^n!+gvJmyvga$<Ke@U
z5~BPl*O^mW68@#o7ma4@#PijB2^#0)pH(F*21vG3<*M4dV;KS~lsun=kXwZ`He!=Y
zDUs_`PD;x68=c~yfIKVTi1Bmvq=NlG;@M_X9tvigkC-l=$qmi)E_nqIadL~VS#j@|
ztr7$d$Z@{zqkM0Sou=^mb3<gU^W_#bGjR37WR0@97=>w4R-irSEA4hwwuQK+g<t0k
zgsWXY+h6*THN+t{>Lr}0t3^sex%#JyyLViAXdTpB)Ovesyo6p|R;*v{2|O5r@%9V9
zS=9RjG2#Db2!D>uAUCrIJBW_sf&_9B1fSpFtW!ZlsufwE8BXSF<d5Z3RB{lL?DX(6
zAkI4pUWRkK{ebN+h-50@|Ek4q8l5pHjw;8Jf3IkxU(8Iu->F$o9}12Cy;kw0C;y3Y
zWM42_12<V--;r%X?9j_^N`{8t`kt_P1Z)!(>9<Yu(%`FPxM~)cML~r;Ruj&AXigRK
zRAgp-n+w<6Wb^gvHLX));{wbBZv*mK&E2dT+wW43cHnVS?*!Kmdrv&sF=ocTzG&UB
z&^hdUzJ%6FnY^^UolTFPoZtQ$1A{hF3Il!4MgEn8n1+xVqkA<yUXtSs`I}x--SQx@
z=db-G+%b*7;`*?ar&5RX<keo#6$sn|t&(T0>!t?DGh`iowT|L2pk$qdnX&=Co=85%
zS95@mLg@V?><%f5uo1_Wsm!+mdW`#^IG%uM_-kY&q->P`PjS2l3kJEl**aSPG2sQB
z)(>z_g2rQ#p7UkENx5`OQL;{A(zs*sBJ-N^V|xqXN`QZJS%$dN`}gNMr)@aH-fIGo
zu6Fh}XFn+S#cf}7KJJWX<i(Hx^+`8Li!C+F3~z$?40>2Ch~u=z*f7oL09|@v)P@Zs
z3KVa0N*{+mPu-FxcqGKd8%q*K#CABU;HvMPGnkE6AYhsWHiby`KAKyLQ@I!f%vcvj
zOk`Vz)+Ak?D2K$IH$-tiRqtgnp9zle>Fwx#Owy%=-SyU3?f0y75oP!BC8fZqD(9}#
zq)sA$IiF0?DcP1%%^ce1!ueb)tNkjjBMBmoZYYKK{ddvgMk`T8KW0fbx_WEX==<y4
zjQo}RXiUrR(Q`s)ga2|hkMPeFU8@1`(`-*4vocY?OKU$XDTvT+<*%{H;>h306Oz1c
zq4+*tSjbV2*vsCA9T;$-_63f^oD>z|{#6GImMkgm8A&%uv;2NhY;*w`-qZ_$t{A_O
z+lcE{9+ix@PBc%KL8_5dhfL4NDDS<O&|1!QR5xqx7iPq02+KHYr4oLS;bHw2+!@*1
z-Y-HY_wb_nr`p^?#_af-Q>`D}9L3(*-G%3l@*6sq?A+`mk9e;^=CE4}0BRDhTSTf9
zD3^js=^09C6ub?^gi-i6jL;cHEPHWCuhIf2N6R3cu2qZ9v_rdFcnQ)>|JrUTtn}L{
z1f6Vy`%a$YW>i+c)Mg{#uw3lCrv8Q$^aGY9*!&^1=H$|3QV!bs=;dK)%&A8wdn6uZ
zz+S3hyVLmba1t-#PB9g6%>bZF`+k~f0PK>OI206n^AZ<YLl4U>zWbn?+x$?bItkh#
z;QJCay&rA;d#6BhU#2QDS`usus<IqlGe=u1kn5ibSWTRST{|a%%(-ar$f6Ehn=q-W
z9~+K}Wjl|R7kdyT1-)kW7h>-%h}p4PzPr0^Ik|R?SVbcWj*@M9E6jvse1_Z{eRK7?
zn#M(pS0#%zgfQ%M|5*{Ct#NcZ<HW4SvuJ)~TX!K+@vMb(B>lU|Z5F!)e!$|!2$nPI
z2U<x()Pju{YRiFOFDBDGHU<pq@9;@%ACKJ;@F-Oxc1a;U5+r4f(!!9HCR$4af#2t3
zrOok<@)!3}us7jrz7)@J@!?^WmNRs)|M%Nbc%80?2`{hMgDS2}%6H@U-yHDg=S4;#
zMg8{~<NdZj$h-g9|1)s}D*ZR>uPNf+JF<r<;$O%^*1BK*ZKn87;@_S7p<(+AdB}A4
zdH&PB{gd~1|9SBBzmSK_gMa^;|KsxiWc|Gy9=z!<<RRx1{9mW~C-d);J(SB|$U{~p
Y`j_GXDxqUMY{R&}4DQu4|0D8$0aSA(l>h($

literal 0
HcmV?d00001

diff --git a/lib/examples/sheet.xls b/lib/examples/sheet.xls
new file mode 100644
index 0000000000000000000000000000000000000000..7a9b00f776ef749771741536dd35c40546c04399
GIT binary patch
literal 11776
zcmeHNZERFo8Gi4bJJTuUV+t%SAC^m7`bA;;0s8?$r<ILMbQJ+35wLb)3JuVbPBDv#
zW>87^u_h`BW|B>I_n*3(b&ZMs+2D|vAhD>~xH0-iAnRYVnl;%qY_HGrp1E`H+)hi2
ztSd{;^nAVNJ@5P8bKZ0AInV7MeqVd@<)5v&C6Ta8Vlw4bOCm(KP+sBJQzFYzCT+^|
zJdz(lL~$WJKqF9{#6%|Ia<=tG)%6^Tw#Y59<#p#OQjyz;hvkeoB4@J`Bkuny45$r5
zmJJUpz{z%636yMj<qJrc%4)T4xuz>L{V8}w-q3WX`liSq_dM481gP}WgLYc^zN=}Y
zrc04p@=NXW7o~K|O8E`=lkz>fHi9GjheoqLy|yCVo`K&2{SBHGkz-3#PJ^>b;-E@%
zQ)g3C*I@gOHdAVEaMofKt_rmr+Lt+YBxqhIRZ{0SZ|Ms4MFrhAz=(C_?O_Rq=~3yx
zPX^nXJ6zuat+Z*aeTP;WH#fqv!M5}u<aSECw6aUMM~549=y1#UAD2$)39B%+hP2R>
zlA^x8K-E^+B#(wv`8|DY#g3{l=ywxy$?z}F)!ZZnmvm09(%<!)W~Xx!EAh`nr_@UP
zA7{EHE+4NL{PEmm#^Jpvy?q9H=M40Y8R*p&>C~q7+==QXy;0<jWu+yJ#*2>c4~9<H
z2<V(&Bgd*uN)p?k;ScCsw3X<oT5$q;Oyx9DZz{=6Wt!d;)C79L9<l$T`fXh4jVcG+
zt}h2<-%c!d24g2n#(wPc&^nz?8iU~v<fl@Q?)vn={@N6ts$_q_FHjKWNB7Y4Ua}oY
z<zgQ5+FU~O<vB<56}c+SB`2D%%*DO0Vqdo82Y3gWJshu9(St@Y;i*F@DCD5rPjaZ_
zSV5ssC?Ly8KJQ7scNpiBNtp!yFn%8BGK~5p1wt`@EUG+}pfachowVO1`g>kp@~C@x
z^o3k+GB3Tup7c&mf(~xRJmN6K59j6b<;wyF>CJ=Ci$BD?M$mfma_!nRxgd+>j!v8-
z{o^OQS#MqfTSV(UtiQUnRPTKrbPK=NEC=sI%c;}1S3O<?E+)K6+sG}8>x{s9yb{^O
zA+@wc66@-M4z>yiI`jk`N=;=QV$iFhsG&FLP-;SlJMs-#1U^Q*r4D4W6K?j*cxLEW
z_CzK#;T|12bt-eLT12Z`o;#IwMD|Q%PQ$bIj*lG8z}O~~4~$I=or1<Qnb9gRA05eN
z$Hqa=o*2tyR~Ose?Ag=q@YuMU`C4ZD+{B5I(c{}aJa|%0V{8}0ge%C86wNVbpH$h|
zr^Yt#46q1{((o!eF2V3vkYLL(S*GP$O;eD4=g0qe^O<M&_6;hf1F7JB#q?WB$rV>5
zg>8iI)1S_x<*Kt1vLL+Wvn`)$Idq_Z;7H59M{tbB!J4GKL&r02%b~sfpMDAr-&Tp=
z(X^!`@twZbP`M4|SAN3q@4og>`DN~Suw1<x<%9M?nuqXCUyy$hvXhuDj*~6T)f-e7
z>zvS593<F@b#4HDyV&ZMMJxDpNjs%37MG>Q)2wAmWA7-9J`|-<MwG^VCQ9SoBuayC
zOrvpG#kqzVV9N(^MlJ%JsSvK<d3ds{!*3m)i>;jN21L_J|8K^xvDk|BCL47u$Qwgx
zt*!-Ai=oCRFf~V-pxe~AV%O`9>YMf=@Yu3JmxZatP~(j%ft=&(qRil?HIo|IjV=Ww
zu|k}}<0_61OaXBf*I24i90!Qv;+4grOJR517svDUdYwgzOQ^W77sVy;e8yIaON7LI
zE)5n0ScfhJB(To16F8GnoGI~PXmJv>dR<mmv}WTNzZ#+w7^EbGt}(J?f7%q5$VLZ(
zoPtvrz&`gU%ozRlC2hU!{n~rp+v)v%>cy#D_Hy|JpH|X{#_2>pfz=f=dyxe#_{IK)
zA?9>)g3SiX{CKhsk=;!|E3a^}+iY8R+b4W|hp`YIwtWKkisC-u?*slI3g(OJKtyLp
zOKGJ3XzA=IwM4p4^YHevg?TUoYts8Y4`JC0<p+BNs*~9F;&C}ueZA@y9_1>wMv-43
z77%YE9>zBA%#QsGpwsJ)0cKXA9LK8^FNqirvZYc_snpBEs<mBHryl1W7rO#qKW1yd
zd6FILaj{|pw`$X%$4{S|dpLvP#%a~(_8ZE$&0E0d#!=Ph_8Y)G9a8#lV5AjM7|EbW
zh8#kF0&*FM6p+g>q<~xoA(7mG(<Bh23i#1#Ovb7bJ&gST#aTo2$TS*Mr3fq$QfY8_
zAXpb}4fi%In~5CF2RG^<ZZv1qXd6+ZK)kVWE|^gdF{6?izu(;uBVJ++a#L`%C^vDj
zrT+oVdG~HKx@45E5{;6hd=Dzk5?9K{MG>F(%4v%BL}-fiL}-fgL}-fel+id=(3>jP
zL0aQ;7jfvQ&ZSH9=F_a4D2?-hzTiuzs)5CDe#0~iE)b>lr^F$Rw-rm8v@g)0X*&9I
z;*yU6I`&?4wWxf&1sGe>xuh8T*b2TgwAq&zrloQHFOz2uRMX^vPxXfFdm5+|`-b&W
zcJLf#45)X$$jrln$<)X*RU9*YAzi>F=XW)J6^KlYOc;a)ud80-8|G!2(wAusF2N=k
z7~w1EdA~0QJ_vLk4oom%DXy~RSi(x&cRmUzVZNt;dxai2>b$sdUHrep4vvlcFn+6W
zI+_6ni((OuZBV8LT$)Sx7@2s;@gWJvCO|_-!cpMNv6rAuP$F&+G{>$6fw%<rF4JmY
z3B}YLy9OP3S&tE1n;n|KQ4l{Dqs`!^HG^@xoq~-Ri#zr*sHL<jAEcWdomda{iW1|H
z7*~l)aDJi0xB>fShbIWI1oC`%0v0A9F9CU#zzN6ZM>2vFs}0at2}q1$7VI(|v#0@P
zQK%|7j*nPe!pr3)9j6=KkGv6Yt#^Iu91x2|A;jYTAr(B$M>il#wRd8#TG)V2&TtJ0
zZ$M#8gBy$=f_pUPPKjxx_kv^0JWFqW2pH1G^EL5d&yqjuv*%NQm7PUAKb8lsIs2^}
zZ@sW(ZR*kwld`Gv{nxrct4CxTBM%7d`F8PChvK}$Z2E6rc=4a_fBr=3mG47;>(Bp8
z{a-*dr$iAKWn%qph&;$_MfB}Sqb%*0KJ(YhzqJ}r<p1{cbai)a?(W&#-F2Y5XZyA%
zw|Dn^nQRN;!5snhQ<zVmpd0eGKp>sRULLG?c;z0*b1!{`e!}lPfLPUk@$p-~TJZnE
z_~nd#!tW~h)Th3VFLMg(uSJf3Lcwk+__88+n;ZYzfV>g039%V*BVr3;D<b`}9kBy(
z6JjUgX2dOs_-_!QKX)VIpGx>yRsDAx^2ZP#N90%IClR+J?m+w`BL7!yS20f`?=O~#
z_dkqbpN!!*fxX}<8AU!W=P)935BRSo{Z_)Uqc6=R(5G_T{166I|4CE1hZNuHR6qAE
z+AvoUYv{lTUxNN|IVsQHqaFC1r24sb=A(aW@%iKU$TTKL<*b~RjLyJ*EuWSlor^u7
z4Xcf$OvnhzqiVTHo+#?4ZiZ0PjK!U3dAisdm-*?73T-Ru=l(HQ{e9p)9~HDv|42rF
dYnE$grv0D$<=ysw@-TA$XZ``=LU=Gn;6Gt?n%@8b

literal 0
HcmV?d00001

diff --git a/lib/examples/spreadsheet.lyx b/lib/examples/spreadsheet.lyx
new file mode 100644
index 0000000000..4248339b39
--- /dev/null
+++ b/lib/examples/spreadsheet.lyx
@@ -0,0 +1,262 @@
+#LyX 2.0 created this file. For more info see http://www.lyx.org/
+\lyxformat 413
+\begin_document
+\begin_header
+\textclass article
+\use_default_options true
+\maintain_unincluded_children false
+\language english
+\language_package default
+\inputencoding auto
+\fontencoding global
+\font_roman default
+\font_sans default
+\font_typewriter default
+\font_default_family default
+\use_non_tex_fonts false
+\font_sc false
+\font_osf false
+\font_sf_scale 100
+\font_tt_scale 100
+
+\graphics default
+\default_output_format default
+\output_sync 0
+\bibtex_command default
+\index_command default
+\paperfontsize default
+\spacing single
+\use_hyperref false
+\papersize a4paper
+\use_geometry false
+\use_amsmath 1
+\use_esint 1
+\use_mhchem 1
+\use_mathdots 1
+\cite_engine basic
+\use_bibtopic false
+\use_indices false
+\paperorientation portrait
+\suppress_date false
+\use_refstyle 1
+\index Index
+\shortcut idx
+\color #008000
+\end_index
+\secnumdepth 3
+\tocdepth 3
+\paragraph_separation skip
+\defskip bigskip
+\quotes_language english
+\papercolumns 1
+\papersides 1
+\paperpagestyle default
+\tracking_changes false
+\output_changes false
+\html_math_output 0
+\html_css_as_file 0
+\html_be_strict false
+\end_header
+
+\begin_body
+
+\begin_layout Title
+Spreadsheets External Inset
+\end_layout
+
+\begin_layout Author
+Helge Hafting
+\end_layout
+
+\begin_layout Standard
+\begin_inset CommandInset toc
+LatexCommand tableofcontents
+
+\end_inset
+
+
+\end_layout
+
+\begin_layout Standard
+Test of spreadsheet external inset in LyX.
+ Spreadsheets (created with Gnumeric, LibreOffice, OpenOffice.org, or Excel)
+ gets converted to .tex with the 
+\family typewriter
+ssconvert
+\family default
+ program that is distributed together with Gnumeric.
+ They are then imported as longtables.
+ As the spreadsheet is 
+\begin_inset Quotes eld
+\end_inset
+
+External material
+\begin_inset Quotes erd
+\end_inset
+
+, any changes to the spreadsheet will be reflected in LyX's output too.
+ Thus, the LyX document is always up to date.
+\end_layout
+
+\begin_layout Section
+How to do it
+\end_layout
+
+\begin_layout Enumerate
+Make a spreadsheet.
+\end_layout
+
+\begin_layout Enumerate
+In LyX use the menu Insert\SpecialChar \menuseparator
+File\SpecialChar \menuseparator
+External Material.
+\end_layout
+
+\begin_layout Enumerate
+In the dialog, set template to 
+\family sans
+GnumericSpreadsheet
+\family default
+ and select your spreadsheet file.
+\end_layout
+
+\begin_layout Section
+Simple examples
+\end_layout
+
+\begin_layout Standard
+First, the file 
+\emph on
+sheet.gnumeric, 
+\emph default
+a spreadsheet created with Gnumeric:
+\end_layout
+
+\begin_layout Standard
+\begin_inset External
+	template GnumericSpreadsheet
+	filename sheet.gnumeric
+
+\end_inset
+
+
+\end_layout
+
+\begin_layout Standard
+Then 
+\emph on
+sheet.ods, 
+\emph default
+which was made with OpenOffice.org:
+\end_layout
+
+\begin_layout Standard
+\begin_inset External
+	template GnumericSpreadsheet
+	filename sheet.ods
+
+\end_inset
+
+
+\end_layout
+
+\begin_layout Standard
+Finally 
+\emph on
+sheet.xls 
+\emph default
+which was created with Excel.
+\end_layout
+
+\begin_layout Standard
+\begin_inset External
+	template GnumericSpreadsheet
+	filename sheet.xls
+
+\end_inset
+
+
+\end_layout
+
+\begin_layout Section
+Long spreadsheets
+\end_layout
+
+\begin_layout Standard
+A multi-page spreadsheet called 
+\emph on
+longsheet.gnumeric
+\emph default
+.
+ Notice that page breaking works fine:
+\end_layout
+
+\begin_layout Standard
+\begin_inset External
+	template GnumericSpreadsheet
+	filename longsheet.gnumeric
+
+\end_inset
+
+
+\end_layout
+
+\begin_layout Section
+Necessary software
+\end_layout
+
+\begin_layout Standard
+LyX needs the converter program 
+\family typewriter
+ssconvert
+\family default
+ that is distributed with Gnumeric.
+ It is therefore necessary to install Gnumeric, even if other software is
+ used to create and edit the spreadsheets.
+\end_layout
+
+\begin_layout Section
+Limitations
+\end_layout
+
+\begin_layout Standard
+Spreadsheet inclusion have some limitations.
+ I don't know all of them, but have seen problem with this:
+\end_layout
+
+\begin_layout Labeling
+\labelwidthstring Wide~spreadsheets
+\noindent
+Wide
+\begin_inset space ~
+\end_inset
+
+spreadsheets Unlike long spreadsheets, a spreadsheet wider than the margins
+ doesn't work well.
+ There is no attempt at breaking up such spreadsheets.
+\end_layout
+
+\begin_layout Labeling
+\labelwidthstring Wide~spreadsheets
+\noindent
+Some
+\begin_inset space ~
+\end_inset
+
+formatting Some types of formatting doesn't work.
+ The red and green texts in the long spreadsheet are underlined.
+ The underlining doesn't show, but the texts is otherwise printed correctly.
+\end_layout
+
+\begin_layout Standard
+These limitations come from 
+\family typewriter
+ssconvert
+\family default
+.
+ Feature requests for better spreadsheet conversions should therefore go
+ to the Gnumeric developers.
+\end_layout
+
+\end_body
+\end_document
-- 
2.39.5