From 870c1b2cf567209a0c159415cefd89a1615c3e2c Mon Sep 17 00:00:00 2001
From: Tim Allison <tallison@apache.org>
Date: Thu, 11 Oct 2018 14:14:07 +0000
Subject: [PATCH] 62815 -- some numeric values not correctly extracted from
 xlsb

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1843553 13f79535-47bb-0310-9956-ffa450edef68
---
 .../poi/xssf/binary/XSSFBSheetHandler.java    |   6 +-
 .../TestXSSFBEventBasedExcelExtractor.java    |  23 ++
 test-data/spreadsheet/62815.xlsb              | Bin 0 -> 10665 bytes
 test-data/spreadsheet/62815.xlsb.txt          | 284 ++++++++++++++++++
 4 files changed, 310 insertions(+), 3 deletions(-)
 create mode 100644 test-data/spreadsheet/62815.xlsb
 create mode 100644 test-data/spreadsheet/62815.xlsb.txt

diff --git a/src/ooxml/java/org/apache/poi/xssf/binary/XSSFBSheetHandler.java b/src/ooxml/java/org/apache/poi/xssf/binary/XSSFBSheetHandler.java
index fb3f433bd6..726c2eeb89 100644
--- a/src/ooxml/java/org/apache/poi/xssf/binary/XSSFBSheetHandler.java
+++ b/src/ooxml/java/org/apache/poi/xssf/binary/XSSFBSheetHandler.java
@@ -302,9 +302,8 @@ public class XSSFBSheetHandler extends XSSFBParser {
     }
 
     private double rkNumber(byte[] data, int offset) {
-        //see 2.5.122 for this abomination
+        //see 2.5.122
         byte b0 = data[offset];
-        String s = Integer.toString(b0, 2);
         boolean numDivBy100 = ((b0 & 1) == 1); // else as is
         boolean floatingPoint = ((b0 >> 1 & 1) == 0); // else signed integer
 
@@ -320,7 +319,8 @@ public class XSSFBSheetHandler extends XSSFBParser {
         if (floatingPoint) {
             d = LittleEndian.getDouble(rkBuffer);
         } else {
-            d = LittleEndian.getInt(rkBuffer);
+            int rawInt = LittleEndian.getInt(rkBuffer, 4);
+            d = rawInt >> 2;//divide by 4/shift bits coz 30 bit int, not 32
         }
         d = (numDivBy100) ? d/100 : d;
         return d;
diff --git a/src/ooxml/testcases/org/apache/poi/xssf/extractor/TestXSSFBEventBasedExcelExtractor.java b/src/ooxml/testcases/org/apache/poi/xssf/extractor/TestXSSFBEventBasedExcelExtractor.java
index 4fd9a5c1d7..e173876188 100644
--- a/src/ooxml/testcases/org/apache/poi/xssf/extractor/TestXSSFBEventBasedExcelExtractor.java
+++ b/src/ooxml/testcases/org/apache/poi/xssf/extractor/TestXSSFBEventBasedExcelExtractor.java
@@ -26,6 +26,10 @@ import static org.junit.Assert.assertTrue;
 import org.apache.poi.xssf.XSSFTestDataSamples;
 import org.junit.Test;
 
+import java.io.BufferedReader;
+import java.nio.charset.StandardCharsets;
+import java.nio.file.Files;
+
 /**
  * Tests for {@link XSSFBEventBasedExcelExtractor}
  */
@@ -110,4 +114,23 @@ public class TestXSSFBEventBasedExcelExtractor {
                 "This is an example spreadsheet created with Microsoft Excel 2007 Beta 2.");
     }
 
+    @Test
+    public void test62815() throws Exception {
+        //test file based on http://oss.sheetjs.com/test_files/RkNumber.xlsb
+        XSSFEventBasedExcelExtractor extractor = getExtractor("62815.xlsb");
+        extractor.setIncludeCellComments(true);
+        String[] rows = extractor.getText().split("[\r\n]+");
+        assertEquals(283, rows.length);
+        BufferedReader reader = Files.newBufferedReader(XSSFTestDataSamples.getSampleFile("62815.xlsb.txt").toPath(),
+                StandardCharsets.UTF_8);
+        String line = reader.readLine();
+        for (int i = 0; i < rows.length; i++) {
+            assertEquals(line, rows[i]);
+            line = reader.readLine();
+            while (line != null && line.startsWith("#")) {
+                line = reader.readLine();
+            }
+        }
+    }
+
 }
diff --git a/test-data/spreadsheet/62815.xlsb b/test-data/spreadsheet/62815.xlsb
new file mode 100644
index 0000000000000000000000000000000000000000..66d8e652b0832340befba4bbcffefafbad1921f3
GIT binary patch
literal 10665
zcmeHNhhJ04_D={^s`TEgQlv+z0wRKh-UA3Ebm^f<M~ZY11O!141yn$KXwr+IAkBcZ
zAWaNKYD7eTm)(8OU3cH_A9(NbA-VU?obNev%FM}}(bs_x(u0UWq#zK82lPF!Gb0QP
z0$CA)Ky)Bd0xNY-4?m=bpRI9_7t+^SJn*JFcQGM>@Iw#*(Eoqef3XHKjfXs<FVM7_
zeNy4JJ-<;B_w=cnkCst+wp^UCl7b_da9=|!>`eFq5p9V^P&_%~lyt51JW}eJHpgbC
zgPm?yUq}z{g~2B=)BGDw2WQ)BNTX%SC*G-cxvI+LDJx$$t%oF$-n?KJM7pI*YJ4%1
zwh48^S*Z49W~9xDCbYc42l63ECiv{&eUM;J(c+EqR|*K9QuVsBkG^KFnlFgn4_IR@
zzkO}ZuL$u_t#`hpwTJl}(R~Lh8YsA=Do7-&k(>|1`Z1oL(K~%1x=(?iRQy9U1UAq>
z`kFjW53!e^R_i<03C8P=9`nXHi-dm35ICaGVhn%hX=Nq+9yvSJ(&?XZmD=M>i^N+Z
zyo+HO@hh52qLUAl4^%0^#i1!jn;NXtPU$nE=jlsKH?>`v=EvCS+U+USE5LC*lRO@Q
z`i9SfU==dA>q)Hn1kH3jImRvoGIPGEW@Gc)h$jsZez@JQv%a4obFG_bWQ*Xwfi6$m
zL$UX^-TPc1(2pMwkp5r7Ry}H|7Z3R2bs#Fqfv~mpLAv`&h@XD`FI@kNWAsl$Ps$j9
zbzh+9+tzATUq1fip+#C$-@;uoM{|xEE8xLapZthl6@Q2jDwAp8IN9DCDQum4GhX%*
zs&T$D3S|&wU)pPqG5I{&T3Mjlt1<jmIOROl=eBidcw^{Vx*=ym+kpX+f$985qur5s
z1H7VvXix1>mT8xUNL-P+Uhu;dZ=-vu%->yA+uj=AGP*pKN232`bnOkM{_)L<Ri@EG
zx)wi2qTT!{7P<3WQdU}WwvSlPaFm`&`q-GCqBYON!uDBlbk)E3M^*0~Iu`BQmISt|
z7g2Bm%LOXGxng90mBL>90&Q&cfIj<kh1}>wuCj1o=zotBbe3A*X`Ivmal#5B1qZrI
z{2nR+o<45&o}O;v_AVa(3L7x6$^lE^fA{s=uv5F|0!<tFclDeW-Ij!S_vW~)m^ST`
zh#Xkn3l~}`@A`1hvMH3^q>e<Se0M8;Rrg(9YG)0frqn!HSpqHdr4_5CV6eoStyM6y
zz`CVNn>v_}*8LOi*@3iW?k<fBT|AQUDuJK&V!E#(E6KGO>W@C9d){dx-BWwqla~(%
z%#cANOL|mgBhcxW3^e#nu@{aM7DwS83n<OSyJnt{X1~i(Myxk&B4niwa|lBgKTJZg
z*(+u`gQe``1rtI8rH$u&VC_L=_x3+;Ek(-MUpmUs=_!RBm~jW_+&36|T5<2<_alDa
z^%+8yW0wOVz}kOzn`^D&;}n1^Bm)1`Ko7ue{_HUDv=(iM0ZnYXMX`CAI}3q*5piA&
zVs0`=bB9)|C|-glzWPo!FE=Ugb75y5=kqqfwwD*W<j;x{ovhLG=GqPC=Kd(W=({>5
zEQ-|P?JZ@uZ_e(@mF8_9t`SA1ldy3eo5{$ZbG`0u@bch3ckb{d*-PxT{Sl7wu7hZQ
zsL><hyrMZ)HZ?k*dJio+sTHP@I|Z+A2a9L5i)-o}G}S$ZGWieJ&HJ$3JBNv-W^zFn
zvnwd`9H*mgS9+h!dI#w|w2iE4m+1JE?CqpD-73v4{EE14-Q|XDr#OkbZ`WDt!<bpN
z5mT4;tC4ebOUDO$4$oR@KWr$cI=;><zQ#wzwr@S+gZu_W)ZZ0{Qb*j00+jX;0s>L~
zt~g)6Aa|tiX`Gc9>go^}&?`xA7elTnF=aiI%eoA6U43GmzIl%D7-C_db~c`9bAzky
zY5QpZSd7As%0%V1-&vw722-J)tg^8^&anXtZEJJBt1p}IZ+pbff?tp%eq2?GC6(BA
zi_=cKIcy#KK-l47w4(gN^kyK@2}jK;&AWrSv*LFs9AmC>O>+uk2*0_Ke0oy2DSEH^
zj;Pc?HOCIig<JYljWk^hi}~?n%zEdda!eUflHIXf94DPgLXi9u+br^~df#UQ{6j3s
z1ef+aNcE_c&RJD)3w*wg7BUPM7&O>3a5}T@s%pr}>Jm17C7~ccgGA(3+936Eq&~`Z
z;)L{}KIx!lUn8BGXc^ojDiy=q&=h0U{6MxVPhUMTAd))W&?W*yTj+?MbJOBWRoWEu
zsvE3Wu-nQU*7mL&ay_!Gq5VS7%v(TbEY@o7P#I#WH+F`6)v|0)v@wP9US7wunENqy
zj)^u{^AE;-3@v(0*(<chF0Pz2<@wk0wM;Kc?GXKwv5E`?b2<Sdu>%I<`|0Jr&Pb%6
z?;rEzZx53Ho+aH!I$eQ9g&2GMaQlXzZT|j+zIdZ4yEM0TPSx719+`W|NbTLjgPWUE
zJK0}UioVyyn9K<$rn*0Lv()dAyEIZ8xjlrzDF}-UP+<lTH-sX`y#m)q>g>w}EJA2a
z7#JZsBJ1jI)#OB(f`T8KbM2|jU0>J2oU5RBl^ZtmhEs_t^q#Ojh*WH*nn3Cu>~bjt
z<~`~umysjpD19~a!?>-Yut0K~PvQO3n4l;2*tLKuS=k8A;FJAvFOq-Kzy<1fx3fUY
zJjdy;pWou#&l!0WDe>E<<ms=U4GTR_wk!1Qd^;SPw>%w${8_J}o=#O;Ige{rTTLtl
zDjmY4TWasK2<=eTU*+f5xC~E2d#kEGHvM3ztox8OVWO%dFL&+$rs$DRtE%ej+*aF;
zUu|1BmJUDsRKJu{q|VE~a!tC-rjjt8pNDG<F-x&^*pe+rz|R1S&Dpsv6D^Y7Szi&b
z(3Bu=qG2DUs+^vOX3@}ooOk}b)NMOaiM>qz&mKKjk{A>db_Vsad~exmvnI8Xp#ps}
zWcpDK`nQ~9ig_-FR!B_^W(6=S3Tl6fOuJKHs>@Cm&B19bs|G{nk@>}2NJj+4ek;>U
zF^OQlcg990I^l@iw4t&R`{sIlIZ=&3Q{~anvQ*?^=hIxHB$D2eNskI|Wa(Q^(DgS<
zmma`cjKua?Kve3VC*B*rv%q;6TQv>S4t&qY%vDaDmu0dYYnOBKeKhGh$(Ac-S`MBr
ztiSk86WP|#_6bWl@B!!h#nP>1&L-e9F=7XJ*vje)e$&gQ-{b6aA?_V`(_ea%2+=c5
zDG>s}vSm>yt6!F*pMG4*yrUsDSkJ72EhYz1BFsk#%U!fJp|?dnmIAqj-_c=pqjWqs
z^o7@A_u*QxQBR(-v=-Wz#pk{>8)*+c_$Cs3@a@&BZYLq?aA?r}$K^%5X*ORVL};l7
zJ5;4|bTULe>Z#WreDp<H#pd3QN;rO0PbKUVi5k%x(cqn<yS4>NK|8(u?O}UUkOjs-
z{aC!qb^d1El()*Mo$~5QZWmeN_pa^pUFRTUkMv0Wl#;-X-4t<Dh9{zz=jh%lhIHWW
zlB86$X<es3cpW00z=0KCd)^z99g!DYN!xvLP3lljTo5^{+!yz<X$I=8Hj`WOR(7w%
z5AAuiN76TSQDaf^TD;m<4i)a6rMXaT4x0cMVe~Rz%$Cta*M!csLaKa?`($$uC3}#c
z_E^+5y=re!*F*P$+SIA6`RNHAIhT%aUzD-wr;BkY98^xR$o*_(enpw@meJXJ-W=uJ
zV-8)=PZW1Dm2(vczKIc?2*!r3P#%lt^@$q_2V=*B$bD@zw?0Sv-(H%C+Z^RT=df^>
zB(0cv(|aX)+ow@&U%Ce@MBW{mN-H$$Bp=n{w~-^GLv!NDt61F%L*H$06JfKnZ>Fg8
zD>dqu39_DXr2pFRVDaXR2l32{_@jiizH-MlQoMxws6t@I#@VujBY{sh<HBZ&qJM<M
z*%%KoEo3`YFgMrDr%kmrOb7Lo%g^%-n(OJZGzq+!x9TF0+30$BPdW}}$lfzX8um#$
zmW+MY{03h%p&6Gx!vSx8*UL6mX90)Ya!#F0AF{P8(i@W%J1_8NhjkX1HJX`={H84-
z&T*K1udrF+3Fc>gtJm}N>Ygx&Donr6x-RnNQ1Grvy@Ae%sqB;7Cm&y%qMwV%t@%7`
z^`ayum$P$<zM(=WTGd@`t4F!U@p?di&%+@zu2*BRip*fO9>w3KZm+&fkv;YN{?v+y
z%vz!U$m+n+l&CpmY*?<Vr1!%&i;QJ>XA*)&(OOqj1jDHF)<D{M!VCvK<NcmO(`ziI
z(EH5gyTKCi)6A8LY69->3M>+zXgP7pf3q-&8A>D~TFUf3SMt77szy?#sz$$BV+65j
zTY>Sbu}*>%IM(DdxUr@2{>WjVah0z_$nX}OBWaN-ZmLbS5L%|Yq9MV`Sp?3D52aWn
zfz_+1pIhweqOS{!n2~+c5VUgm?)iA;b{)lVio-okDDK`@f59p!x%^4Vi%!L?*N}zQ
z2DY`~?S#rNi9V0>`+i89?fZb_N!`>rB5A|}h%}oG?}M4neRvx)79VR3#=TtUNE7o?
zC$EYOLEFpyAonTz(J1SL%BhKse)zuBfnQiu=p60sjmuV2(*dzHt_}O<S)xV=si%m_
z>lM=wA1!lRd<SYS8bW{hX`V+$Jvdt7LHL%h>E-C^`A3<!H|vPrF&8)N_B?vZp12gY
zDd6{g^&68Q<FjM;gW6q9MO(h1l#fic)`ntLXPkE2WNOOi-`++tV#h4q6yD|cKRcL(
z#(!w-zhJ)MWQZnF`^shhql`57#HNU8LU|!>J^{NIy+VE2)OO68Qc6o+>(~u+%&Fjf
z_u8|X2}cF4H<mBWZ9i+)=iuq5-`5~Ngu-ePbu$$n7$q`Y^Y44nUC&{qC984hcc<&E
zuu5D`M-H|1il;%yXAnUfr13kQV>|2>eZh5(l3QH}Oayi5w4UH*lv^#V&`u^p;23fH
z<7cQ!IQ{i0+8SG}U9p<WZjuk2W3czP-(t@=28y|w4XFhlxG$=8y`~Urp^;;9RVMlz
zD(W`-)tMx422p`&M*BQ5-*pnU>Izgr&fguW$()Y<;08G$&MaTT7~PX3T7DzM8L~*v
zoMNLi9&R^Uo$F!fk2}qS|DN#q>SuO@0b7ZQ<{%LB-*Skb*+bGSNgy4Py?<vxz{N%6
zQKkWnuE|5HSvsN^DP#KH<Xa!+Z{ZeVxW)BnA$V2qM;{(?Q^iJDy|}?a1dqouR^V;6
z_*b-c+t!+Fs+#b7VG`MIOYw@!K6>)Evc?U`4h&w%#3s%(^_~yNgB2X#x2QavsF*S;
zhC6Z$Ju1|kaZUa_hI-|Uxq18rr;pb~&u*bmsZM!k3r}j@lqktdT?N>TGMtNCW%;dM
zyNhR)UA=%XH*7n{+t?trXRU_emvvpyAEGcR{n&BCUFPv|kzU+Te!?TSsM@{KZ{cu1
z=K}9_FhqJp`w*=Wzsj=a;<7yzGFqGM1fTr0s>4t)qSF4V`Y7Q{sueJmJGjHW7rnn9
z=_Vw*nFh`lPrflT4218LNYhmxY5OLhKS#~ABX6pLc(w7R9&hX3N!!9$UA?nbFN&EO
z^VmwquGrxzRqWnjUuGzv!}TrmJdC}r*$dIOU3ZXt7FEl4L90x6$VzF7mg$h3Jo@(R
zjb~jCCj-iw-M(Q>I^d<VmzZ*bzSkCZPmP-txVgU@e_TC15`Mwz=6j>hj7gC<eWI*q
z`Eqke{YKDhni`%%-mk<x0`$U@83TfdW#zt(uNKttDni3X&0tTDyKCchSry_MBBY1w
zA^Dsgs7<g_J`My`ipO=?UdXjo9`z)Wzp_54W0#N9`o!6V8r^OTk)U6iWi8pVgJW2{
z`kG|HrB}V?ECGbaz@4`>12)Om4FXGDY({~c@~xP>g4r=d+t&+UA6H`GW`=meN*pnC
z2`-D3p~6&<K$m8}MvUJ@dq6r^*5nBD3%XEqfCw|BUaYA&IpTb854w(Z7kHxxfSLz}
zjbNMKoHi491v6r9k^$7F5#zpS4>y3i0i0jZkD4JEhGHOI!C=hIQ}Dxx@kDf`5J24q
zDkVdEkN_S13G;2bP;I9pg+SYqaIS!yIC5xP6z(e+Am;MAACDsj4MQ90u>0pKXHExc
z4JyTW&8eOe6Xo0VqgsHD@}yqD5X>eOz=bnnoF6XF40Kcims-LbnXu2v)-+4H48B_{
zH{LQr<K&RvEkBAc%rEX7eZM}ryx}`gAmg9y$pru&66HU^HlF}8%y4-H(_tvV`QBTg
z4wrM43N!#<G^n)EYpxSeF9!j%Eg45e1T<ghSm%HTK!H(R1;MsIH1h#tQ8?puKNgpA
zsxo1$3<rh-0ti+eF-`#wU<W$(LtxV0b7TO{15#*P91cbR;2=6&7%LTs05(S8(rNUT
z3?L7TB!3m#EDgw`K<5?Ag?T^(;7mu1lc2ZQf#zYNeB~b08ZiC<W$gah$`%knO%5(i
z^`5%|fLl{QL!)rwr(-beST}+PumHS?p`o!jaT4I&nGP56$`)FH<Qb?m2)*SBAjX1W
zg-gwD07Et^=;UJa*;5#D=$n4j>9AU;yeuPdm8ZnS9qZ)q06qXv9t=A`d(i(`%L+oX
zs644~F~4k2zrc|BmJnOVLiNLv>Xs0B2p}stcAue=?NlWd5#t#2mK?y?gCzfDCn^B2
zbbt_cA_BK{suGV57oN%%5<tRR;L<DTEoGo%9|0`Ud+r2~O9=!GO~i2$0v&le))nCR
z3xG7KAlSlE^Ho6DTNGYj!5F1em!OLnPeps2YF>{3rsFkd1W+fF<cD>k^Z<GA6xcd?
zj1oD}(Kljz1icjmu(1K<-&<^E0&wy`P_cfL1fXQR6n3Ay^46(|?nI1Np|?y<J3{iq
zx=~f9IK<d}g~~iaAfUvs`y`cl6aXT9$GRRIF9@&(tlI81X9cisqlBI$<K|E8V%_0F
zRGA0F;H+QAIu~3X0$}GxjJKn=lmKi;Ff1AEAqNoqf`pO>z7?+X{<tBr%~68~JLy8@
zc^Oi6w|AT7d?aS^^1nMZ$>L(r_HNMhTAGr}hWJ7pz%7&zD&RHOe|kp%74V)bJ-s7_
zKK7b}11wg-FhH@sz}+WMsXbht3lM-P!blp9Cj!_WL>Q4(9-q2M6{yq@j+X`AEr4Ke
zysaU?9pGtF@J3RgwKu|u9F7+|Z3V-`yyx%$j}s8Iz6+%SOaYCAUarZwFu<Z7B3R=T
zT-a$`uwW;MF=D5##MDtvfH^q>=)g0=$O?{E0ARvFuuZSI!c!O`Xnj8_9MEqgf!C)9
z-1k$p*>;rEVq^j6($5mFTf-&&dr+JJ6<J3)U8N52I-4N>T?gtk2963dnMH%D+@0VU
z3P4cW4i{ax8Ndtf+u<SxH#?pE$U8)mah9i3)fum+U8oAc=80QnE1_o3lX35tpW{~N
zL&)&Gyu)*yI4;8Fqt{9x*9R{oK&Oj=708nAMOX3wWy27ee}GfoKE`iEa{Qj|whdqX
z4*n|%S-r`Y0UO-FXyfIbIXCyhLX^CwQ+};(%}_^%G7sBrdV7Usr^FEdljhhJ{J!&)
zBqBOZ%^ex`PU(G+ez48TfQZ6vcN)X^P4k?&Hphi>2CL*vhMLP-JaS*XX1*jUqY+zC
zuQ}upuf=a!&q@QtCR3vY9y$jHsRv9LmImVErkBrylV%DF_f<L@#hWY~Uw@d_ZPe*L
zakk>x!r*Pvp8I#leZ`&m5gj%6>9E%9RcMq~wsF^ws{`jzUU!biWCNSZzx^1Y^mizJ
zY-tww6-ZkCp0liKGb*V8dmaYB7S>r{QyAgtpzq`9<tyRf>4W^E;`zV5U?7<b$uQ9A
zzCa(dK=ecX)vY{4)|;3HNS4w?n&-kVW0pP6%eiP3&wX!mX_=&oO~n`7-7dIwt>IGH
zrLSPzQ_Zz_LBcB!ukf938ydB0O4&A8R>Wjrl4IF9I*UxaZ`~#9)^J$tl_P#$)o~@V
zgo94->aA_c?x{OU!dn^Gx0h$-Ouf0ZTe@QtC0;@l`4A}#f#OYTXh@$Ue=(h5!daJ>
zH|HQF9s1D(n;cKbdc$p~O`D!k2O~ciXQ|wOF)p%|Db~xKvK9SI(_yCJTHc|gT3CXL
z+(^~QQ}4$uR%EJI1c~Sv(Vp(<i!NuW%zW467yD+;EO$$OGz&J|_a-475GK5#K3lt6
zpsbwbX8f8|*P$kUy_H|bKU=Ei%Z8>+>ox%;C5rW%%8v3A{wH-MB05HLR<L-dj<n-l
zI{Nm1OqQ4Z(ipP=$D;ufX3oDQ%fJq)olnp;4+Jvsw+*+~lkGYLcFY|+Yjs?)lViLw
zj_Uks(TnfW)a`W$#Ujs|zoliapp0Bm;nry2*U~`NGZLD92S@TwxyR@-h(#LcFW|%j
z*J>9zk0M&5w?jimq(7eROAR|omWs66%xjX)mT}pX9b6OTi(?IzNf(y$N@1c<&|pmO
zJ};Qh%QD+NBUqDgHK{()y*R3q>YaDY7A!p|9}6)OPq$X&`M6W-MhNpa?57CDNikXt
zO&}stEjk6@?y_;}tqvJwHx;=xjL#sy#A_Fm${Tpoztu>3A<9Zhm!-*|u2Hc_+y*};
z7^d0Rn7SD0<Zs+hQL)dG=uaj_x6UVihj+H8*Fcp{lAzX^`}z&m$%VIsJR%ccE=?Y_
zpxXM1t<@?DofFa&E1S$FB-JG}ldiPfwp1Ba<Pl)sQP=OM5R3ie4J{7}fj*j)RLA!v
z|K6vWvn$&9fo;Pj$B$tX=5;z{2XvEsC*~j0AH%TbKe$jHZ_KGrs@gM+JQ^gf`!bSz
z=@HF-rs5J)ic3)s`$v;51xImd1M|ofFw@ZdZc+z3cL#N6JD{!vSkxF}@`4dTLyY~=
z0bbvty4=iGqM)(Pn6@SELL~55K)|@U<t+V+k6Rv@Fz}r{-<^$K`MuY}8^d7%+c|Gl
zt3UEYs&enltm(#(I}~$A&)t@aOp;i7HDwnK=``?;q9C)PH|x8*gCxk+7tFYWq|G%J
zy!#4yCfD#uMmdr-*ECFc{MG(0U+!hc%v^+H?iI(ZX@q~S`f6qq!Xx+UYSs}V%tDnh
zGX`O2p%EsUIA~vk7Uj_yG_0u;<r^CGscC)AeST28rsg@XO1jBP>8`Yeu4%R`Lf1m)
z-8~e-+CuMLHYGxRS}RPPZAh@D{F|EG-8V?`X~Tw$3MAXKX~W%3B+0aaf5rnO)3k~I
z-8m%nw9#Qk8<Okj@y7Y%SKoai*o8@6b?%-&s%Pho8}wXm^vPitzdDfalgTdDe%E2y
z{30wRn{HX-;<Yddp&=2Ur}=`VLoB-_7mbE9YFF5g9(}v^U36_Q$mb=Tn`!WhPc@u3
zdl2c<1m`guH1Vm2^I-;2K5ety@`JiQwX?j9gEx1Xnyk0d+6NbwVNE()_u7Y4mJ4?!
zjv8nA@PnZ~?TXyggX+646nRqz9d^-*JbHshyLF0uBZI!Xt*zV=gF3r4t-Mu(ZoAE`
zJf4GAyA9v2em}oG(6U?5D#0}nx0@a!S~yU;n;Rnj<F3TA&XM+a2?&oJmEcPn7FcX{
zkyKQYuu57w0>N@cGi!9YCH~uL0+vj2qc5`>;m&fkFRMDrmWg6W65+?9s~I{{T@;D=
zN54~AIjfZfOeJ(cp@rtpYnYvv*Z-C<KxKbi`5AhiGZ!d&w;_id6mx7B=kzHepBHP%
z@4ry#%xG{jdE&rRgNRQ`-xyDANbhqAc%Qs{EAZ=`jAkVnWgK@=ViC=rg}4-{+&yu3
z@*VV%|G^c6mSARIKPU!DkYIJP6K(l;N{yE!$6KRAZ9-#HO}kE3hS*7z#Pn$ntNQGd
ziX@X2(b=mlp4@4z!+UIGBvJZmL6a|u6C}MyM}NfL8$As9Qg^X|;`yZYOt2H>j@SXU
zlTnYk!QsJ;&hr-;7{)6)x9&cAG@O;+;CeGTPJjeA7)U5E0yzLZv3);?zHN!B``BT4
zouyf&wZSdDjrlfbDb0gx!-V$F=jG(oH?2xa3LW0tQL2{lv-K_N!`jB*hrZkE?C5=5
zP0f7S9IY`6-Hm8}nssfT`omFX;0@-WtN9Bpg~zKzV+vi1V<GSI_L1(EbSa{(rVG|n
ziw-S!@Uhssw?jpi7{SZ0JiW#MNjh4tzofQ!C+J?J7&K3QvZs<94j=J!JSxq%^_Mc*
z{g!uN3)tfKEDTH_2KrBD&;Dhxe|`VMNi=<(zXJUA6wJQ}Prn<1u=vxNm|qG1dMx12
zgbT#KRe}D)A%S0UeytP#L}DcSTh;hi;$Lf}KZ*6u{6_q<a{4Rjua&!>q~FN@&G-MS
z<NXTwYa#3>;CG7O0Dmou{R;5wKHyIPRr+5g`nfCkE6QIp^Pd<X&^|i|^tU|ySMp!;
ztDgWjfm2j}6!HI1%dgqiuUNk>>_4$od49wC%QF8f^<SswpR^zl8mP4Xdmw*I*7`a`
TfZKsU6u=(~;JLwqr%(R}i1UJj

literal 0
HcmV?d00001

diff --git a/test-data/spreadsheet/62815.xlsb.txt b/test-data/spreadsheet/62815.xlsb.txt
new file mode 100644
index 0000000000..94060e3171
--- /dev/null
+++ b/test-data/spreadsheet/62815.xlsb.txt
@@ -0,0 +1,284 @@
+RkNumber
+10000000
+1200455
+0.01
+12004.55
+-10000000
+-1200455
+-0.01
+-12004.55
+10268609
+1071427521
+-1071427521
+273214017855
+69942788570880
+17905353874145300
+17835411085574400
+273214017855
+273214017856
+273214017857
+273214017858
+273214017859
+273214017860
+273214017861
+273214017862
+273214017863
+273214017864
+273214017865
+273214017866
+273214017867
+273214017868
+273214017869
+273214017870
+273214017871
+273214017872
+273214017873
+273214017874
+273214017875
+273214017876
+273214017877
+273214017878
+273214017879
+273214017880
+273214017881
+273214017882
+273214017883
+273214017884
+273214017885
+273214017886
+273214017887
+273214017888
+273214017889
+273214017890
+273214017891
+273214017892
+273214017893
+273214017894
+273214017895
+273214017896
+273214017897
+273214017898
+273214017899
+273214017900
+273214017901
+273214017902
+273214017903
+273214017904
+273214017905
+273214017906
+273214017907
+273214017908
+273214017909
+273214017910
+273214017911
+273214017912
+273214017913
+273214017914
+273214017915
+273214017916
+273214017917
+273214017918
+273214017919
+273214017920
+273214017921
+273214017922
+273214017923
+273214017924
+273214017925
+273214017926
+273214017927
+273214017928
+273214017929
+273214017930
+273214017931
+273214017932
+273214017933
+273214017934
+273214017935
+273214017936
+273214017937
+273214017938
+273214017939
+273214017940
+273214017941
+273214017942
+273214017943
+273214017944
+273214017945
+273214017946
+273214017947
+273214017948
+273214017949
+273214017950
+273214017951
+273214017952
+273214017953
+273214017954
+273214017955
+273214017956
+273214017957
+273214017958
+273214017959
+273214017960
+273214017961
+273214017962
+273214017963
+273214017964
+273214017965
+273214017966
+273214017967
+273214017968
+273214017969
+273214017970
+273214017971
+273214017972
+273214017973
+273214017974
+273214017975
+273214017976
+273214017977
+273214017978
+273214017979
+273214017980
+273214017981
+273214017982
+273214017983
+273214017984
+273214017985
+273214017986
+273214017987
+273214017988
+273214017989
+273214017990
+273214017991
+273214017992
+273214017993
+273214017994
+273214017995
+273214017996
+273214017997
+273214017998
+273214017999
+273214018000
+273214018001
+273214018002
+273214018003
+273214018004
+273214018005
+273214018006
+273214018007
+273214018008
+273214018009
+273214018010
+273214018011
+273214018012
+273214018013
+273214018014
+273214018015
+273214018016
+273214018017
+273214018018
+273214018019
+273214018020
+273214018021
+273214018022
+273214018023
+273214018024
+273214018025
+273214018026
+273214018027
+273214018028
+273214018029
+273214018030
+273214018031
+273214018032
+273214018033
+273214018034
+273214018035
+273214018036
+273214018037
+273214018038
+273214018039
+273214018040
+273214018041
+273214018042
+273214018043
+273214018044
+273214018045
+273214018046
+273214018047
+273214018048
+273214018049
+273214018050
+273214018051
+273214018052
+273214018053
+273214018054
+273214018055
+273214018056
+273214018057
+273214018058
+273214018059
+273214018060
+273214018061
+273214018062
+273214018063
+273214018064
+273214018065
+273214018066
+273214018067
+273214018068
+273214018069
+273214018070
+273214018071
+273214018072
+273214018073
+273214018074
+273214018075
+273214018076
+273214018077
+273214018078
+273214018079
+273214018080
+273214018081
+273214018082
+273214018083
+273214018084
+273214018085
+273214018086
+273214018087
+273214018088
+273214018089
+273214018090
+273214018091
+273214018092
+273214018093
+273214018094
+273214018095
+273214018096
+273214018097
+273214018098
+273214018099
+273214018100
+273214018101
+273214018102
+273214018103
+273214018104
+273214018105
+273214018106
+273214018107
+273214018108
+273214018109
+273214018110
+273214018111
+273214018112
+273214018113
+273214018114
+273214018115
+910713.3937166670
+3.03571131238889
+0.000010119037707963000
+3.37E-11
+1.12E-16
+#excel doesn't display ...863, this was manually altered to get the test to work
+3.7477917436899863E-22
-- 
2.39.5