Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


Hi, Kohei and Markus,

I finally had time to work on this cell value xlsx import test task. I attached what I have so far for the test. I just wanted to make sure I'm going in the right direction and see what recommendations you might have.

So far, I just have some basic test values to make sure I could get "make -sr slowcheck" to both pass and fail.

Thanks.


Respectfully,

Daniel Bankston
From c1424394f9efc80c0a3cbac3db7449139977e8a9 Mon Sep 17 00:00:00 2001
From: Daniel Bankston <daniel.dev.libreoffice@gmail.com>
Date: Sat, 28 Apr 2012 21:57:22 -0500
Subject: [PATCH] First attempt adding cell-value xlsx test

Change-Id: I5481759669d14b7e4c564f2909d1db9af3b4a2e6
---
 sc/qa/unit/data/contentCSV/cell-value.csv |    3 +++
 sc/qa/unit/data/xlsx/cell-value.xlsx      |  Bin 0 -> 7697 bytes
 sc/qa/unit/subsequent_filters-test.cxx    |   24 ++++++++++++++++++++++++
 3 files changed, 27 insertions(+), 0 deletions(-)
 create mode 100644 sc/qa/unit/data/contentCSV/cell-value.csv
 create mode 100644 sc/qa/unit/data/xlsx/cell-value.xlsx

diff --git a/sc/qa/unit/data/contentCSV/cell-value.csv b/sc/qa/unit/data/contentCSV/cell-value.csv
new file mode 100644
index 0000000..30ac222
--- /dev/null
+++ b/sc/qa/unit/data/contentCSV/cell-value.csv
@@ -0,0 +1,3 @@
+-2012,-1,0,1,2012
+-3.14,-0.99,0.01,3.14,
+H,"Hello, Calc!",,"Calc is the spreadsheet program you've always needed. Newcomers find it 
intuitive and easy to learn. Professional data miners and number crunchers will appreciate the 
comprehensive range of advanced functions.  Advanced DataPilot technology makes it easy to pull-in 
raw data from corporate databases, and then cross-tabulate, summarise, and convert it into 
meaningful information.  Natural language formulas let you create formulas using words (for 
example: ""sales - costs"").  The Intelligent Sum button inserts a sum function or a subtotal 
automatically, depending on the context.  Wizards can guide you through choosing and using a 
comprehensive range of advanced spreadsheet functions. Or you can download templates from the 
LibreOffice template repository, for ready-made spreadsheet solutions.  Styles and direct 
formatting makes it easy to apply flexible cell formatting options, including freely-rotating 
contents, templates, backgrounds, borders and much more. Become a spreadsheet expert, using 
templates with built-in functions, so that you can re-use a pre-prepared sheet and just focus on 
the immediate work.  The Scenario Manager allows ""what if ..."" analysis at the touch of a button. 
For instance, you can compare profitability for high, medium and low sales forecasts.  Calc's 
solver component lets you solve optimization problems in which the optimum value of a particular 
spreadsheet cell has to be calculated based on constraints provided in other cells.  You can do 
collaborative work on spreadsheets, thanks to Calc's multiple-user support. You can share a 
spreadsheet, so that other users can easily add their data to it. The spreadsheet owner can then 
easily integrate the new data, in just a few clicks. This collaboration feature helps avoid editing 
conflicts.  You can save your spreadsheets in OpenDocument format, the new international standard 
for documents. This XML-based format means that your files can be read even if the recipient is not 
a Calc user. Your spreadsheets will be accessible using any OpenDocument-compliant software.  You 
can also open Microsoft Excel spreadsheets, and can also save your work in Excel format for sending 
to people still locked into Microsoft products. If you only need to make your data readable, but on 
a wide range of devices and platforms, you can export to Portable Document Format (.pdf). Calc can 
read .xlsx files created with Microsoft Office 2007 for Windows or Microsoft Office 2008 for Mac OS 
X.",
diff --git a/sc/qa/unit/data/xlsx/cell-value.xlsx b/sc/qa/unit/data/xlsx/cell-value.xlsx
new file mode 100644
index 0000000000000000000000000000000000000000..70c8d0d6a580489d55c66b58e7b73c8a0cc34655
GIT binary patch
literal 7697
zcmeHMbySpJw<evT8>A$aj-k7RK?I~jx}{N492yj)W2gZH>F#a`l}>4?p&O+0g5Ui<
z{anBMTX)^H?tkB&wdS37t#|J^?{m)HXP@U$mPbY*L;wPT2(-j05(vK;#_exIM{`>z
z4)(k6qUeFA$ROOnUC-c1h+8$0v{^+{&|uONPoIR|Yh(UIPEr?7h(Ay#FAESM=k=qH
z|1s=4zQs{+vTQKeAzz0jH2m^DBqJ63WRtwfMyrpmU-KzFj%j!PXou|~b+kQVIXUNq
zo=TgxfzYB+7DZj4*>^KYfStY}@{QTraZujztmW)Qm}cNfKzwQ5COFV-$p8r~IJBsh
z9?5pX2<G5!#8VoOR?|o$d)8pf;dTaj24o!5Et?N|l~Su-5t`8AB2pLVm?BQF8c=-g
zBv=asM_e~XE3Wrgerp|KuoOp7mInYW^8IS&Z(my&3E}qse*y;g_6aiwQ)NeomrfkU
zFJH31wzEwcRFuC(=iYon3vGabTZ|W@YB^Kzp?YrMw}Q+rTk<ZFF5Ag#NQU3`B)k^`
zXE$_0VK$0;$;5PRt#KJDF*r2wa%)Yu#qI$UQ?8#1`@OX_RP^s(h4*2mexbzZc~Xp&
zqBPmOrZTCm1;b+kqh>*qEQO|G<pP+R?ee1;fj+jM&XE1lXzp_=o+Gc9)QZ8qRS1sU
zS`KCnRgW^)=$OZKaiTF?DLd4j_FKO_dR<o$h<QO3#y0)U_C>ouRMNI=(J30)q+{om
z$FYdc3mBvscPkEW>zwQi^$r)zOa1++yXAoRcevpFj*F>-qxl^$c9A{S?VPwWCs*hh
zO`@*IAMa03x_pzOVRB~4%%d|A9aMlX?XrZ7Dbn=xh&n~u*ECGz37FEu^*Lbq#Hd2c
zRj*7rW^o3VV;F<7MjQ{YA+Kcc8x}sQebf+J)ICI`BhRFLPf^8uxcHSq2SHV~GCE(n
zR^98|@?p+>S)gjlQqZ3ExNhlJRr$D5U{5JoXM}2j25Ivm6jcZDndJ~jQjK@-i%$Ev
zj~j<q4>=5^Q;)G~@sPtz)B3}z^{g3tQ;ToJc)aJewbcw)tQ3g#LRuureC*@SJm1Qp
zcjE&29XiFHEBSM`?;iBG=n&pM@!FQd$<o--+)T~c(aQdX(;Yx>HT50H`EfmVOC~mG
zo*;VGvJKvQzn!LN%_Bhpcp01-G5SjB3ryDFlxF>WQ&|2f!z9~aU@Klkjqt5O;!94N
zve*JG8yjGrEsY6y4WDh`d|DOaV&7Q}dKn)rSC-H2f3sZ@fOuZ@nTNh7OVzK3T?u4t
z^^W&CWX}ON7QYqBTfMH+>CA>3bY@XaEXZv>F2VPD*T;<Q8yimPw6VPr7!s1I*~De<
z>PgynWL|%L<rrJcp>+U%**bPE*rZZ@cD&9lNKe4zqVU4k3g|_ku9Pt_Fggz}V2ddi
z<^?<U!j7WF_KNpKEz`yX6dy&sVoEYwV#e0)jEZLHVXl4XiP^l&n9L-v^H8Sg)j{=)
zOP!%p+9R{TwpX>>W6@+jxgh3Op8{=9zn6tX(=yf=AFwesX%rhPvKc%JqKcPpp}?7=
z9g#KlOz%)!Z9GbfdUMpOf=dO$o}7C73Rqt-F*OgN$MnaEHs~K?c1$Lzm4G9ReW`7A
zude0FNw_dTC8(RVYV-#W`;sV$vH;#zPA<A_Gn6820Ad{x7>H5L-@=w?Ou(G+nTTII
zkW7RI@O&*-{lgC_aylU2aN-PyD@rDFv{ar$YY+kwOhnJI-;4RSyRl1RS+uhcdG1)H
zs2yMj(Uzu@sCG)z(^MuG#wa1=Iv)7dtBi#^4P)8`uc7hVc;kAcMy^+!>7vzw1*gn1
z>Y!2e^FOjPvVSzIQ}cY&8NJ~<(Mx_2){GHLLqF`bTBx;#?T?8|Y(s)N1*yRH7_ZJ=
zSO=lLD^)x|>;#5H8|fWB6@Tz{%}%U)Lo7_H2x0u*l!Cf&VrGzc9{PC|T~*wPh21Bd
z1o4*LKzvv1WAY@77(1hCIIYjFW0vv;{*Ho7pH&eo5G&VN$4dhB3)6<vh{`T9$GTSB
zBy=Z5qwNAw{{xkP_)sNxo<Dx5A{R12Lu4fY!mLOLFj!(#!E^TY_D3Iv;p-t>#%6F1
zFTEZOSci<6`_YUC`U7{#T@whEYPu!&a7i((NpLp4%YjFR9qS4Kz@n}D3#zZFC1c{H
zWGDew?CbZg{DWeG%*7UnR1ni^pWATeeTMPG8Ms-D^vRV<?jlhl<o07daLV8mlwdj5
zzTybRu3l6LLeu?nX(VDQr||*mdW`FpNMR=31Nr)CsF>S_rL~8Meug=zpb_nqQ|12V
zUap1=3#A1mm(F9MRux-t%tR#dn~z}$NXb-;k@g{=k?4LpHAcitKk=OPR*bRys{63e
zgu};e$>v0fF5RNg!qu#H*J$5QPfmQfaY|)+&p@tQ0ZXzv!d5wLQ6vRaMgo}GQtKue
zkJMXar2K<YKNQl0R*t6YRn4?FFedUZ)Dlx@4a5oNqX&4x3(K<IgYXHu1q&#7Ygj+@
zjFwTR<rnd5YfVwe7I!ACCpYF+ceXt^$~`>BesD_cw=09|QoTyR{E1Xg4(*~a6-AQd
zYQ0@p*2B<#j>GzeO=LOyB9AAcux2Hb(U@Lx@M{b(CquO2*pd+nvWXxEA+(RZGG0tn
z(qN1QDK9%Jg>}c7(}Z6v--^bu1}wP$iEkU4(9;o8zE<v$K3Ejx5=4GD{a_f9o?ng=
zaiU~KjON#I-u>~VF~bAm5L=65+y`F?I>z{MWR_mP>;~>{>X986v;A13l%`E(!k5si
z%Vv=x&_+M%?-Y{0K{s2g2+ME}VN=1<xKuIfjLB+!{LvHb63_b~zT#C&9+8M4c710X
z8)a_wdsns-zMTj=Rt$YDxG0gMw(@D_Mcv>Y>72%5$my=P{u>qc@A>a`cGi0i4y|h1
z;#ZEu@9Oe?j@dm;R0M<^^uOD+$o^56|Iz8VIXK#wI5^nc73QB^PgBgNXYHJr?{*=<
zU)^BU<iL;F4b++XUtaq#x+GcK;ZGt~*BIggg{<-g6oj8w!*6b|z4MQZDLMf7C$mh9
z<rFAF@T6H6^jTL9w}{eWl5fNS$`OKUPopS%3YJpPI|imnZ3^BOVrlY8V<Wky)_F0K
zNliP-aqidDR{4lWiP;l8=$0dd)UIEAZibHSrpY~yS3IRjIJBRHe?b&vvfkiiKHaIv
zL_R3@bXUAkQi4<m?MKYJLFb#Ff&dkbAO%4{MLnq35qsr2pQ#L1>K+EA702pvzC^Cb
zU7D25Rk{Ppkx83%;T8sQ<i7*z{y%`agUHF!+}zpeb}zfVaQ|$7G!&giIB}bPu<!`I
z^b<lm#8~7^fg*8db@8BD)H00;jj4~J%h_9ci?U2sDK4}|`m=58T<p*4nqTj{D4L`c
zC>dPxc*D7Xso<-csNdf*qt__1&<ilm9JHifJ()ji=&U$<@V%%60VxCF^J*jdr{*p$
zLv>{gZy#bz_ovQPz)F{fUR{7x_T#F4i<mAIO$_tb<O^XJ@%Odk@_n3GVPp!H{sM!v
z%4f~0V?R1Y%(aCznJHU6!E)yDQV{A?BH;;%Q<E6+nRysy#Eva!puRn%P8~{<-bMix
z6i))X9e8P!o@DT{C}&*IJ9!<#xY4pKolobXdSFPuzl{%fjw{h}Ljae^ifMD(6{^d)
z<$^c&=aKksA8!%Lu!2XH<#s!pY#VbT<Fz?@RA~CNj$5bL*pSD#(^!^_NMFUCOOUhZ
z_>JYsy2@fL&q#meeE~72-x<e7rj$ot@0U5R392c(nGoz+K`fgklp;tT>3Z!Q>nB<T
zp6BQk<wI*9lTXV=qTBE@aN{K8+iLL8looZxQf?3ji<pZF!g-^>>Qw_zV8mk)rMXZj
zXQg&XYFYjy4Vy-Cm;msktVs?9{4Usb#6JT*9vCwc(^W7sdC0hI@03}%N(<zAo}-{W
zNw2Djr^us^ywKpgl|vl8K?flcI`Vl0Y@%QGCntIaCs*Ikp|d%<eqNiB-XSFC;P}$R
z(PLu$)dYUH)g{i0FIN#@?+_ZJD}JTeQ9cyLC~2;(3a>G;o@yP!nipWN0`;|=FrtoS
z{7r$cVo&>}$#sZ)sY|m6GE|sif6!R3<mc5e;Wz+J=_<n%8m?->6G0}cn#-3OP^v`6
z6w4~xAyfwSAf2gC-C15wc2}~IDrnU++Wn?;0r}_9Q>w0p{g?Zd*~OZUMRf4_{^_39
z8%YgAyoFI(_ozKn)!2uxETzzAQ#boqnC9lNnDu*Ax?T5324w8!*hhYxMciwjCa-T3
zX-FsEAhR(x&}$F3CmR<UaT|I5CZ(@}Mj>>9_=h(h9W`swIFl`j&4;jyOuHML^3$Ka
zGc`(23(0L_y}kE;NG`7bB-ekE>p#i$|C3yxyX5NBly{gGz-`_w!F67<vJp*=SDTcv
z{xXd^JP|a)R?4qK@m!iw^&wM3SIHdBL-~UYiLyX_D%)2U0uc`2If1j&jQLq&sD*0i
zl_l=^gCKR)M|`F?n?EkE!gj45qde3@zkgAZb`=pb7oDQcAq3!jAcXs7YxOg<Mlx-L
z0zDm2j^Ybb$oIQ1lCPL1j~Y-fkBYO%*@%wb7GMae)o59KY(Xk-{AeT}!PuGsT>zBO
z-2Xi9N^X&sH8vh(FX0(QIMNRs_o<JzH9}pnSwCEP&aP6b1&E=yWLLuP=Jb>4RErF|
zYFIn=vSdsCWQgfnf3lSoEq}y7d7(wpEK5U2#P7`r&e0S*4$E&nA)H>ie}KqUfwR7@
zx3i*c)cIZvcWN3(!Dn`^x=qGhpj)$~Q|AD=FJ{KLZ~(}8TwZcY4z)#nSE$uW!z-a1
z#cC&|Hb0}e4$&=qv4w#lbkamgpuQ9Ll&o>tBC~4<yH%%~M7NoZ0<fysZ4!$g?gKWy
zxm-)8lxI7{S<=wNZqo@#sJ~?0LGi90q<>fHy86gKZcCaE)u?K2^O?SLSY`Odzy$Y}
z`js8zvs@k<p`xN-24Ouu#zDIUk>Mg;g+rhxk%682N7Q#P3iF})jq^n=ithpKDir#4
z6E2t}E?~?=`lmbn0rD(%W*|4XC;cU+tEN|6!Z+!C1VhE=I338gz73U7MS{%=oa&@0
zxgmozXJL1$K$T<^-6S*9qxDb?XG<<oUNjswiyUHEu^lBgY)3TQjGOzpwW!QuZ;b?k
z*u#B<Oo_0;8FYouirOS!qkP^PU8A18LHJyXYC6%Qm}+yJGex`coMPN<1715KxqHM&
zL|~yJgn#0=#5p5INp3InNF<IrcGsOXKDbHF7?`?ff$;4y=6I6vdLC`=$tRL@K1^h%
zFFgzM=PT#sG@Cm?tne|oxyN@e+^#B~pbJ68o!nZdNV&|x9g50^T;?WThV`D5v^htM
zv`r?i@9M;^Lss%%+q%uV(msD+9-gKnRh!ZVdlm-s3J~X#%y>OIUUk57IKoSc#RRlQ
za|d%$<RvykyBXU;&8M(fp#^{%-`D+;thgEljFLqY<QAfBaVK9}hB?Li^L7ZW<Ej_Z
zERNDg8B(kXq!O&DSFyz+%30fq(cvC7Cp!Cn!xwh^KVqa+bvQb^gjJzb**h2CPoBbX
z25J|oPJ*T{<cOs&uTjWn+VVAp8W>&0-Q))A${uW*U8l%~1g?IF@3(`qpq;xcmR<St
zo&oNfSFf<+sixcgH52Xc_E)U`W?!7$ZOwnuF5BArO4FQ#o^vIomtxV->Q*Sq{x_>(
z31Bb}&-N$!XC@01QQK1OC37y#Fik?{ZDY@`YRNH>0a3ALcE0O%uGO`-%zc@_Qnz^%
zX&HLcN5cr>y)O(SK*R5X5?(S{`pD<+Tb*`}XD=O!WsFiA;R>}Tf;#!X45@&f(s9fr
zQ9a}`yWjh2#R}CcLp!D(EzgkF?TmJz5eOW1(xxthGoG*qpzY=QE2ntVnC4zxZLDnU
zY%ze3YN$ZK58-7$?DvkUoZQz%#ENB=Y%52g7+2E48s9+0h-q|!G8_SbQw30)-7_d&
zmT@`J#&dcaLAW_qC~Mjrti)a;Gkfakgp%6{PtzOir2DHjA*Q~A96=!U_oR(!79t!N
zdj=8(qdXcj3`2ReS^Tg={CvQuXEgJ>F<TZ$?OWyEC(Nh|@drdxd^CD$Grl-77;nXL
z-XofH4)=<Mu~NvJg!UQ_T1*V{I`R7);4NRy9-oz%@j^(R#G}#5eCpxuSB+8&A+JI}
zC3<79Tq4O`hv!s~`7tVwPakVs!!Ev!xblZXVB{3$__WxeobCg2)iQoyB};;;BvB!k
z32kwvWOhFx!GM#XX|_|(U{+nsyHQ$dpcg7;2&>FC4!9(k&<SYc)S8`65Y9#X*f%_)
zXD#t_pL5~Io+bSp*dA}e`9z=ruWxGN@=;$o3tx~`N9a9JgKeo~FSP|OcMxgEWr;Wx
z-rl4N-;Rat8|0C0$G~DVLr27$#{<u<1+TA6FYO&KzP8v4L7=idW>m+i4enaAqsu&x
zj*G!5AJt|a4~_V}YL{*&W8;}&=(j11F)hhLY%X(iZDwA!{U~^uup+f0X!X3YOB1$^
z&9hc>k&^+l&m!}ds!|RP&fQ7~ujZoM{#=>8`I=>V$+TKGpVl%jd@ZxSu!xw@K=Wn>
z?FQ*?-8Wdh(QUfrscG>4Zr$VjI<)=sTpOm^V?WJ_+jznPoHcC<ZRKMHNcyD-9{R4h
z7^tv>@XDYsP1&Cx=?`fx^2iJlbbe1+=q-#RX%V7xUGsOXhECGQA{9ASRd1?_&CDg=
z<^W3dJveLJ0jYnZwx`Zc%A9(?9SYoz(OiC%Bbq*!SQtn!p0WH4?g8k~YI!ELi?=aI
ztNJ2ZL~$SnyD}E=?(Gc~_BfBuLY3MyHXG#=5i)8`DxL3uIvu{LdHAPDpXM8M%ARJV
z472h#QCHtX&_^w%=k}bL$T<-wEjN$n@>6qzD1AYyqY?>yBkKYO@7nN`4!HFw&?CrB
z7OKScQ1@D~cRw;eWSF+3TC;ybZ4kIBCS2kzEN`>}b^8pBzC31p_>7A$nRt@S>gYs3
z^2qebN9b8&q)CZg-%Rc}n>cUJ%9%D~n768N?S~29@>;41DBs=d%Hna?`;6L(eL}u_
zWL4(=^kNP+7NIw2uWWMsi!nnEF#52(bytz$!p>fP{o)cNH_{{wYm3N-JoTh(FJA_`
zm7s|Z7}gandz3@BA-2u6FediNuCkj0Q;OYjOQ1lS9Lyrhb>?UT=WecX{I(BEZrSB0
ze|tbDxSea=#}4++=Jw8p>h3Sio%HWIoIa@1oix$8dqpT;TrQ_8DeXG#Kd*u@R?%Tr
zPhNla_|e$$wD4rLAMM0&x&a?+;)xeWBK<dKy9N_fyf8Oj@_ibXR;H3L8|!197M7Ap
zXRh3pBm`~cqIOsn(_3;H<tn3xj#RBfy=}5A1XrKID0y+^h@c19B>@NQzVhbX4{TLM
zaoNeRIu$-UbFhsnh{&!f?_HXAZfiy+^2X3OgS({9I=a_6Djj9JyPNOn672b*C!BuB
zY=X&9DMx|^Tx1t6O^gX6zZ5(~3*=?uUE_*;*kLx$S$%*P9=JOW`v$-tPifTz4@NMl
z%I_}`nFdkwRwHz|UdEi@2v)Os{dje@c*O-c3v(q9pu1>gJYP8IP1;-VHVfYu?*g4?
zP$ckCCSOS(X9KocuW>&d@eO`0;<5iirJn9Bz_5D<zv=p%oY*b=FK)>sWqCv-LWEz6
z+3%9konrRy_M3k8r{nLM%AKP0%Sdnk>Q8;?Pw(F~hdbTnmw|3;!oR%#slxo}{yQ~x
zCrtb@rQ0R;S2D$)5q{^4?kKchwhH_i;eR01{*3ec@%WBm`enGcwB7AU{*rI{-$${#
z-TD6_%Fl!KpHY5qCH{RZ-M2IJ7g2tmApVT<dttt7JAPT;E!20|{;LW3)Ajc}zpLE8
utdrzl1Ndhh|I_*RReDznepwmmUls;sdDL4@0s#Tz_S18_YB<U7?*0pBWKPon

literal 0
HcmV?d00001

diff --git a/sc/qa/unit/subsequent_filters-test.cxx b/sc/qa/unit/subsequent_filters-test.cxx
index 87697cd..8a10a22 100644
--- a/sc/qa/unit/subsequent_filters-test.cxx
+++ b/sc/qa/unit/subsequent_filters-test.cxx
@@ -115,6 +115,7 @@ public:
 
     //change this test file only in excel and not in calc
     void testSharedFormulaXLSX();
+    void testCellValueXLSX();
 
     //misc tests unrelated to the import filters
     void testPasswordNew();
@@ -140,6 +141,7 @@ public:
     CPPUNIT_TEST(testBrokenQuotesCSV);
 #endif
     CPPUNIT_TEST(testSharedFormulaXLSX);
+    CPPUNIT_TEST(testCellValueXLSX);
 
     //disable testPassword on MacOSX due to problems with libsqlite3
     //also crashes on DragonFly due to problems with nss/nspr headers
@@ -678,6 +680,28 @@ void ScFiltersTest::testSharedFormulaXLSX()
     }
 }
 
+void ScFiltersTest::testCellValueXLSX()
+{
+    const rtl::OUString aFileNameBase(RTL_CONSTASCII_USTRINGPARAM("cell-value."));
+    rtl::OUString aFileExtension(aFileFormats[XLSX].pName, strlen(aFileFormats[XLSX].pName), 
RTL_TEXTENCODING_UTF8 );
+    rtl::OUString aFilterName(aFileFormats[XLSX].pFilterName, 
strlen(aFileFormats[XLSX].pFilterName), RTL_TEXTENCODING_UTF8) ;
+    rtl::OUString aFileName;
+    createFileURL(aFileNameBase, aFileExtension, aFileName);
+    rtl::OUString aFilterType(aFileFormats[XLSX].pTypeName, strlen(aFileFormats[XLSX].pTypeName), 
RTL_TEXTENCODING_UTF8);
+    std::cout << aFileFormats[XLSX].pName << " Test" << std::endl;
+    ScDocShellRef xDocSh = load (aFilterName, aFileName, rtl::OUString(), aFilterType, 
aFileFormats[XLSX].nFormatType);
+
+    CPPUNIT_ASSERT_MESSAGE("Failed to load cell-value.xlsx", xDocSh.Is());
+    ScDocument* pDoc = xDocSh->GetDocument();
+    CPPUNIT_ASSERT_MESSAGE("No Document", pDoc); //remove with first test
+
+    rtl::OUString aCSVPath;
+    createCSVPath( aFileNameBase, aCSVPath );
+    testFile( aCSVPath, pDoc, 0 );
+
+       xDocSh->DoClose();
+}
+
 void ScFiltersTest::testPassword_Impl(const rtl::OUString& aFileNameBase)
 {
     rtl::OUString aFileExtension(aFileFormats[0].pName, strlen(aFileFormats[0].pName), 
RTL_TEXTENCODING_UTF8 );
-- 
1.7.9.1

Attachment: cell-value.xlsx
Description: MS-Excel 2007 spreadsheet

-2012,-1,0,1,2012
-3.14,-0.99,0.01,3.14,
H,"Hello, Calc!",,"Calc is the spreadsheet program you've always needed. Newcomers find it 
intuitive and easy to learn. Professional data miners and number crunchers will appreciate the 
comprehensive range of advanced functions.  Advanced DataPilot technology makes it easy to pull-in 
raw data from corporate databases, and then cross-tabulate, summarise, and convert it into 
meaningful information.  Natural language formulas let you create formulas using words (for 
example: ""sales - costs"").  The Intelligent Sum button inserts a sum function or a subtotal 
automatically, depending on the context.  Wizards can guide you through choosing and using a 
comprehensive range of advanced spreadsheet functions. Or you can download templates from the 
LibreOffice template repository, for ready-made spreadsheet solutions.  Styles and direct 
formatting makes it easy to apply flexible cell formatting options, including freely-rotating 
contents, templates, backgrounds, borders and much more. Become a spreadsheet expert, using 
templates with built-in functions, so that you can re-use a pre-prepared sheet and just focus on 
the immediate work.  The Scenario Manager allows ""what if ..."" analysis at the touch of a button. 
For instance, you can compare profitability for high, medium and low sales forecasts.  Calc's 
solver component lets you solve optimization problems in which the optimum value of a particular 
spreadsheet cell has to be calculated based on constraints provided in other cells.  You can do 
collaborative work on spreadsheets, thanks to Calc's multiple-user support. You can share a 
spreadsheet, so that other users can easily add their data to it. The spreadsheet owner can then 
easily integrate the new data, in just a few clicks. This collaboration feature helps avoid editing 
conflicts.  You can save your spreadsheets in OpenDocument format, the new international standard 
for documents. This XML-based format means that your files can be read even if the recipient is not 
a Calc user. Your spreadsheets will be accessible using any OpenDocument-compliant software.  You 
can also open Microsoft Excel spreadsheets, and can also save your work in Excel format for sending 
to people still locked into Microsoft products. If you only need to make your data readable, but on 
a wide range of devices and platforms, you can export to Portable Document Format (.pdf). Calc can 
read .xlsx files created with Microsoft Office 2007 for Windows or Microsoft Office 2008 for Mac OS 
X.",

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.