KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Problem with some content in file excel #2510

Closed Finu opened this topic on on Dec 28, 2021 - 17 comments

Finu commented on Dec 28, 2021

Hi sir, my boss just bought a koolreport package for a project. Then every time I export to Excel, Excel downloads successfully. And when I open the excel file it always shows a notification like this "We found a problem with some content in 'Rekap.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

Previously it was fine, but when I try to remove the SubTotal using this command "'hideSubTotalRows' => true" a warning notification from excel appears like this "We found a problem with some content in 'Rekap.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.". And when the command "'hideSubTotalRows' => true" is removed, the excel export runs smoothly, there is no problem opening it. Do you guys have a solution for this?.

Please help me,

Thank you for your time.

Sebastian Morales commented on Dec 28, 2021

Pls open the excel in a text editor (e.g Visual Studio Code) and let us know whether there's any warning/error message/blank spaces at the beginning of the file?

Finu commented on Dec 28, 2021

Ok, This is the contents of the excel file when I open it using VSCode and Notepad++.

PK   f‰œSjÒc]  x     [Content_Types].xmlÅ”ÍNÃ0„ï<Eä+ŠÝö€jÚ…#T¢<€±7UǶ¼îßÛ³IZ@H¨Z‰K¬È™ù&ãMÆÓ]m³
D4ÞlÈ,§¼6nY°÷Ås~Ï2LÒii½ƒ‚íÙtr3^ì`Fb‡«R
B ª –È} G;¥µLt—"Hµ’K£ÁàN(︔§ÆƒMƯďFC6—1½Èš0bgE"7è®CN~,{ì„
»`2k”L\lœþEÍ}YÚ«uMÞÚÜ6.â$ÓÞ^ŒÂAj¬ Rmygz$Ï ”k›²§¹wG°xïP&'eûV&ôú_è´nsa¤ŸE¹¥Qê)}ëãêÃûÕµkoV^KãúÄóè
B] šæ4è<%Äd¾½—­|„óáÇ!hÔ$Ún«AÑ.Ã+×þåfŽÑ?åÀJFÐo)Ґ^ýËÿé}Ì!ÚçäPK   f‰œS¶78é   K     _rels/.rels­’ÍjÃ0€ï{
£{£´…1F^Ê ·2²Ðlå‡$–±½-}ûy‡±ºÒÃŽ–¥OŸ„vûyÕ;‡Ø‹Ó°.JPìŒØÞµ^ê§Õ¨˜ÈYű†3GØWw»g)åšØõ>ªqQC—’DŒ¦ã‰b!ž]þi$L”ò3´èÉÔ2nÊòÃoT¦:Z
áh· ê³ç[ØÒ4½áƒ˜·‰]ºÐyNì,Û•¹>¤>£j
-'
VÌ)‡#’÷EF^6ÚÜnô÷´8q"K‰ÐHàë>_ׄÖÿ¹¢eƏÍ<⇄áUdøvÁÅ
TŸPK   f‰œSþ¾‘’ñ   F     xl/_rels/workbook.xml.rels½’ÍjÃ0„ï}
±÷Z¶ûC)‘s)…\[÷„µ¶LlIh·?~ûª
m¦Ó“˜;ó1Òfû1â
#õÞ)(²ºÆ›Þu
^êÇË;ÄÚ=x‡
&$ØV›'4§²} ‘L)°Ìá^Jj,Žš2Ð¥›ÖÇQs’±“A7{Ý¡,óüVƹT'žbgĝ)@ÔSÀ¿xû¶í|ðÍ눎ÏDHâiHü¢Ö±CVpÐYòy>¾\3žÓ.Ó¿åaX,1\­ZÕÍ3ÇôÀó&æã%˜ë5aÞ}Ü“Eä#Èïè5‹ÍÜü3Lù#O¾õ	PK   f‰œSºV“  V     docProps/app.xml“AoÛ0…ïû†îÜ`(†@V1¤+zX± I»ãÀÉt,Ä–‘5’þúÉì:ëaÀ|z"ž?‰’º=¶MÖa$ë]!®¹ÈÐ_Z·/Äóîþê‹ÈˆÁ•Ðx‡…8!‰[ýIm¢Ù"e)ÁQ!jæ°’’L-Ð"µ]êT>¶Ài÷ÒW•5xçÍk‹Žå2Ïo$]‰åU˜Å9qÕñÿ†–Þô|ô²;…”§Õ×k€Ó&õ£5Ñ“¯8ûv4Ø(9oª´Eó-Ÿt®ä|©¶\§`]AC¨ä{A= ôg¶I«ŽWö1#û–Nm)²ß@Ø㢃hÁ±8Û΋A78êŸ>¨FdRr*rîkûY/C—F9$}‰¸³Ü ý¨6ù_ă˜1>áÂoR¦Ny¿J`ø@?rüõçµo¸Ól.kƒÃ@”Ûê챘ÔwëôvþÇ¡\Õ6a™æ8
m*¨‡´»Øôþu
nåèùØè¯ÐËù™èëå"OßpsÆš’ï/BÿPK   f‰œSÕЩÎp       docProps/core.xml¥’QKÃ0…ßý%¯Ò%© Rº
Nö¤ 8Ñט\·¸6	ÉÕÚošnݦ¾	…rzN¿Ü{HuýÕ6Ù'ø ­™>c$#­Òf='O«e~E²€Â(ÑXsÒC ×õY%])­‡oxÔ²2¡”nN6ˆ®¤4È
´"ÌbÂDóÍúV`”~M[±Z0vI[@¡
: s7É©ä„t¾I %)4ЂÁ@ùŒÓCÁ·áÏ’s”l5öþŒîÍ)ýôìºnÖ]¤hœŸÓ—û»Ç´j®ÍP•RWJ–Òƒ@ëë'³5¶3ÙbÔ=ò†ð>6þ¦AÝô¿ã¿#ÕnÍ*‹ã•ã2{çùbq»Z’º`Ïy‘W+ÎJÎãsÎXÉØ0Æ	ä@mw'ý»§¤.PcqµôVÙ£‹gª°ÀTÇhAAzí0^Ç:Y'¢¯ï q4';ÚBßY¯B;¨á¦ÆýÖÖ÷£õCÜâúPK   f‰œSs‘{Y³  ¦     xl/theme/theme1.xmlíYOoÛ6¿ïSº·²lÉu‚:EìØëÖ¦
·C´DK¬)Q 餾
íqÀ€aÝ°Ë€Ýv¶h]ºO“­ÃÖý
{úc‹Šé6iSlCëƒ-’¿÷ŸïñQ¾|å^ÌÐ!’ò¤k9"‰Ïš„]ëÖhx¡c!©p`ÆÒµæDZW¶>¸Œ7UDb‚€<‘›¸kEJ¥›¶-}˜Æò"OIk.b¬`(B;øØÆÌn6m;Æ4±P‚càzs2¡>A£Œ¥µµ`>`ð•(™MøLø¹D"ÇS'û‘sÙgbÖµ@NÀFäž²ÃRÁB×jäËÞºl/‰˜ZC«Ñ
óOIWÓfN'Âñ’к—v–ü›ÿUÜ`0èœ%¿€},uV°î°ãô<5Pñ¸Ê»ßðn¯ño­à7z½ž·Q÷*¼»‚ï4Úîv³†w+¼·ªo»ßo×ð^…o¯à‡—6ÚnŸƒ"F“é
:‹ç22KÈ„³«FxàÅ¨P¶¶»
úD­Ûk1¾ËÅ yp±¢	Ró”L°¸>ŽÇ‚âL Þ$X[)¦|¹2•ÉBÒ4U]ëãCFTO|ñô1zñôÑñý'Ç÷9~ðàøþÏ«8	uÂçßñ÷·Ÿ¢¿÷üáWf¼Ôñ¿ÿôÙo¿~i*øìëG<yôì›Ïÿü᡾-ðX‡hL$ºAŽÐ>Á6ƒ 2g£E˜Ö(pHp ¢ðÆ3®Gêλ-  ˜€ÎîÖt=ˆÄLQðZ×€»œ³Fs®e²tsfIh.f:nãC“ìþ‰Ðf)ìdjbُHMÍ=ÑÆ!IˆBÙŸb »Ciͯ»Ô\ò‰Bw(êajtɈŽ•™è*!.sluÍ7»·Q3ûrXGBB`fbIX͍â™Â±Qc3y«È¤äÁ\ø5‡K‘	ãh)M47ż¦î5•Èö]6ëH¡èÔ„¼Ž9ב;|ڏpœu¦I¤c?’SØ¢íqeT‚×3$Cp²6Ü·)QgKë[4ŒÌ$[™	SJ^ÏÇ9›`’”õ½V©cš¼¬l3
uû}Ù^À·ác§(ÖëpÿýƒgɁ¬x_¡ßWèw±B¯Ëåó¯ËU)¶õ^;g¯m¼'”±5gäºÌ‹¸ó‚!L惜hÙç§<–âj¸Pàü	®>¡*:ˆp
bœ\B(KÖ¡D)—p»°Öòί¨lÎç¼Å½ÐXíò ˜né÷Í%›|J]P+cpZa­Ko&Ì)€§”æxfiÞK¥Ùš7!oÎ^&8íf!6
f$Èü^0X„åÜC$#2FŽÑ§uJ·u^í5MÚFëͤ&Hº8w8ï¢ÔX‰’½šŽ,©Ðhå5=ù8íZè¹à1NŸÌJfaÒµ|UšòÊd>i°y[:µ×D¤Bª,£‚*_Z¼ŽI*ý›ž›ùá|°_W‹VÇùµ°O†–L&ÄWkfªa¹ÆgŠˆƒ(8Bc6ûôv‹ÝP	GEs1¡n¹ñê™_fÁÉ×>ev`–F¸¬I-ö<^ꐏ4õì5º¿¦)­s4Å{wMÉv.4¸­ ¿zA 0Êöh×âBEªPQ( qÈe^Ò"S	±ìv¦+9¬êVÁ£(ra¤öiˆ…J§"AÈž*í|3§©Ÿ¯FeYª+ÓâwL	eÙÛÎì·P´¨&¥#rÜÉ Ù¦ì‡Ãÿpçã6^§=¨¹géE\­èkGÁÆ›©pÆ£¶i¶¸éú¨Máš‚²/(ÜTø¬êoG|¢–%‚x¡S¦ßrr:w4ã2Vo·ªBÐi¼ýæSsvk³·ãlÏàkï家WSÔÖ.2ùhåÏ,>¾²wà~4cJïîÁ¥´¿øøØéÖ?PK   f‰œSZäX”       xl/sharedStrings.xml–moÓ0Çßó)¬HH •¥të¦6“û°ašfQ“ðþXM–8Áv“øð8[a"¶³€Ô7½ÿÝïwqÝL/产\¤›9ƒ“¾ƒ(»-v)ÛÏœ$¾z7qÀvŒÎœ*œKïÕT‰T)3ç eyáºâö@s'EI™R¾<©¾ò½+JNa'”Ê<s‡ýþ©›CÊT±ô[EEÅäÌ™œ;ÞT¤ÞTzñ*ˆñ£ Gä&À>"Áò&XEO]éMÝ:똄“ft‰¯T=Ú®Ö8$qâ+
WÛH1|d)!Q%A†B\¯qÜH©ç½%ܪ5¨å÷Ô1ZmˆOâšóÌBèç_mŽ›ûZOQhév›¦™Ezm¢øð6T‹¾I³TRÞ‡”O9 X”}ªô{´jØ=@{FµkOP]Hȍ9ÃÞxÜ·u½¡Œ²=šúº¨yÖûT2`È¢nà¡°îçØ¡f¥¤Ì,Ò²}ÐÓ¾6è<e8è]埁É
µ85s–‘º0”bü¨­i	™­Ðd{”n1äÆ%WGÀltMFGÉ`røZñTZ˜dãÖ~‹&nuºKÈ'´B¦Ç‘2@‰ió·²—íì§ßcWØâ%˜úéveÍ_`ÕwÌHDôñ‡ÝÇÇ6—fxÔœ
šABZê ²¥¿ºha.ÒG†¦ú¹Åôén´9Ÿö&“‘	‡[pZOŠ2uÛ/1/uÇÊŠ[Û´²VVWÂÜÞMëæ¬@Üì†QKÒ0+^ýk;jAFNÇê¹¥‹ÿÙŒZŒÖúUè}(˜þ/òÔß:O0z“„á[]²)£÷½ÉÙ™v¸½Éøü9êªWZïPK   f‰œS|®yË  ;  
   xl/styles.xmlåW[oÓ0~çWXžÄ4I7&6’LcR$˜+¯Nâ$fŽl§´ûõø’[GÂ®°<Ôç|>ùŽ¿Sßž¬j
–XHÂYƒ™fÏ	+#øi‘¼|
Tˆåˆr†#¸ÆžÄÏB©Ö_T+ Žeƒ2ÝÛ,±Xbh@&#X)Õ{žÌ*\#9ã
fº§à¢FJ»¢ô¤~åÒ0ÕÔ›ûþ¡W#Â`²¶Nj%AÆ[¦ôظæ]®ÁÃÝÏõžm¹zã~÷^ìíù3ߟbЋC¯cŽÃ‚³1Át@¦`‰h}L&¶T‚\â	Ð:›éÒØþ+çñ2N¹ ¢L#˜$¾}ÌPÝQœ!JRAì\â[J?¿–~[òSA½ûÔÛ•ÿ2ypÇe¿žÜ6f2J‡É0‡ˆÃ)…K´:{±nð˜Þsq¿‰.ZóW†¶<›Ñ=†(ÝìÇîMX‡|¶ÑÃN¹Èõúí¾{Èë
Ó*Åk`mUe××Ö	â¹PkôﺖâBíÄ`ãP²Ú-ÞFÆ¡âÍNá:îf‚:C—.Ô^ŠÏÅÆ6³*&[Œo66˜ºèéhœcMÙ÷„öÈÑ®Š)7Smç¨iè:ᆪ÷ÎÛ:Å"±›ß$FŒÞ[Ë1ú§””¬ÆŽ&Qï‚Šr¥éÍ)1ÃB/s.(’È…Wê#WHÙãB³~¨Yh0‚¢Roü²„].xBÌgUl×ü¹þàvô?ÕŸi ‹©ü/­T¤X?”þàÆúƒÇªþÄÿÿý]ôÏÿßÿÿßЯϜ‡šû÷¬}ËÞß—ãIè·—‘{9ù6ԻÕ<vý^wš\¹6.\
Ì5=‚çF˜ž„CÑÒ–PEØ–Ë–æÌWã=Ëö*”êS—%Çj©ZPGû=ÎI[Á>êYrÕEY{µßÞøÙPK   f‰œSweÛ¿  #     xl/workbook.xmlRMoÛ0½ïWº¯v‹¶Ø‚8Ö.[}¡ÍºãÀÈtMD–‘NÚþúQN²y;ÍŠ|üxôüê©wÅSðµ9=©LÞ††ücm¾¯–¯ß˜‚|.x¬Í3²¹Z¼šïBÚ¬CØÊŸq«±˜1mÑdÐsm:‘8+K¶öÀ'!¢×HR¢nz,Y9Ðp‡(½+Ϫê²ìü¡Â,ýOÐ¶dñ&Ø¡G/û"	ˆ®ÄE6‹yKö[ãèuÞ'g
,ïljs®nØá_@⻁\v.ªS.~oþ-ªîK­:â‡@NÊöpÇò³[€Úâ
ÖµQ¥a°$'˜n@ðC
Cu—4¨ˆ-%–û,͘ܓ§ž^ò\-8ÖîÂîcHô¼€»·)8w$çØÈÕ^<U!ûoºÀú.V›ËJ{m‰iMŽä¹6ãÛaÞªœ¬5Þìh?ªp‡ˆ¹B·:ç©ê7#}¤Ûæ<˜&Û’ül@`Â8›0FµËcŸ[òØd¹YqÝÀæ¨É¼·ãgFÿ³^¥6YÛ½úèp<¨®ÖÎ]+úÕ
°ŸQ&‹Ëž‘Ü÷x¶Å/PK   f‰œSâŠ~Û
  êD     xl/worksheets/sheet1.xml­\Ûrã6}߯Pé=‰oe;eR–ͪÙJj’lž9msGµ$mgöë·IQ2ÐÝÂrg¶R‹8N£€¢®þk·½•M[Õû›¹åÍgå~]oªýóÍüßW?EóYÛûM±­÷åÍü[ÙξýÛõ{Ý|m_ʲ›ƒ¤=k MÙ–Í[9ï÷íÍü¥ëÉbÑ®_Ê]Ñ^Õ‡rÈSÝìŠ.›çEuŠÍài·]Ï»¢Ú’fŠúé©Z—Ëzýº+÷ÝÑISn‹8µ/Õ¡=yûk3Éߦ)ށÿ©?F—GäìÏWÄß®Z7u[?uWëz7v²Œ±Ås·žÒ±]Ñ|}=üŽ@îKµ­ºoCç³Ý:ÉŸ÷uS|ÙÂ@@ÇŠµÑËbýýO·×CÙ¯ÍíuýÚm«}ùk3k_wСoi¹­ß!u槂ÏÕóK×,n¯çz›
§Ï²YS>ÝÌïü$×Ao2Xü£*ß[ãó¬+¾üVnËuWnß}¾}©ë¯=˜CäiûR¿?4Õætr­k^Ëcáçú=«·Àòº¯
Ž_}ëüy+³r»½™÷=˜µÿ:4öfqî‚ùùÔµÕ0À}S>¯ÛZz,GºêJÍgct>•oåösÏ.ƒ~õeÐк޶Ãÿg»
fÔÝ
ß«M÷åUè{±„	ø¥l»U՝8®_Û®Þýy4iwßúq?y>úÔ£OýáS]EZj?ønŸÁè30}Æq  Ÿáè3üðƒOíûáwûŒFŸÑÙ§ð¯|±þnŸñè3þ?r÷GŸþ‡OÆH©X|·O1úÜeÏ]xßO9ú”gŸR\…^ âøõ¹8¦þqA-ºâöº©ßgÍq	9ý}ÃOâ“›óüšÏ†?ò*öÎÿõS{ÝW½ëëF`ÓBéÛ­w½xëƒàÿ܈øFÄЈ0ñύéÉbZÕ?Ъ|J£UÁS~ ‘€4"ùF|Ïjåop 
ÊŽÍr4Q†‰¾Ð†Ïµ±ô}â °Û¸gLBÛdŘD¶ÉcÛ&Œ‰ïÙ6¹³%›°àƒzL§Àlgg#l›Œ³‘xtŽ6!û1¬&ˆ«®F4:Žº”8šfeÇÑ éØ÷.Ìh_rÁˆbDš¤¤4Z1iÄ1]èØ7JZºHKi9‰´âI+JZcÒÊlµ‰j2y”Ñ9¡BÌZ¹X[í’É¢&ÑÖ<mMi˜¶6ÜÇ´MÔWæ­Í=Ì[_ÐGÔ>æ}òlt=¼@>àȧ~@ÉGx`lb ÀègàGWÇÈ4ˆd„cX3B㙵qæ<Z¨ˆ4Ž’é;ð‚
ùì	yœ~ËÑfÿXî.qýÕˆ$7³v@ÄDE@¸›®•¸”Ï=¢Ü}Ì=2GÆÓþÞÂ…¯ÈÀGFµÀÜ#Çróh¡~bî¦ëP\÷˜Ÿ1åNnŒ
¹5Æf|´"kGl-l¡Âñ‰Í$ó¬ëGÅs.·\Çâ’æe5[&<Êß!G›Snx(ïï-Ü÷#´¨¬F|¼a ôÁªçÔ£…hIÎ-ÏR^¢îóÔ}Jß'G›‘šâ;¥K<­W#>®‡"Àܭ꘺o-	˜ºOî—¦†`•e*¨"hîeœM„cd	Cááç½e ´GòÔx8„K:Z`ˆWM1I;
^;
ªqî.…-=/›¶¤Ôm¡‡©»¤I!&)HÁ+HA¤Ä7K¡,ê¾OFÝ–z1–‘Â{XE
—Š´À¯‡b’Š¼ŠTEb¸¶NÔtÔM¥ð~m%L%)ɨku«í˜d¼žÄ=à¹S(æXÜUDVDKÄ‘àJX
‘,ˆ‹»Õ6Þ‚æ¶ç‹Üy}(¨>Ä]_
Kÿ)‰ot÷–ò=,’„©âð:ú`Õ&ÜM0ÄÉr|™zÄߨ<”
ßr¯4e\ì)"l	‰·W”yX@ZuIl"‡zÊ-¿—cóiA¥¡Ä›J[¼}2#L<ð4æmÊ72bïر›Í-¿yK^J*%Jº¥ô,ÞX;Ü[8¬˜¸´d!fnÕÆÌ-0Â7 Ëñeæ¼*”TbŽ”¶ê“!^lƒ8Æ;EiÉB…©û.ê&)LÝŸD]ðÔ©Ø“XñHûP„º°7ŠXñHáZÿ¥KìÙm“QŸ$ö$/ö${xýZJ[ËI­0uëH/ñf@J—Ε.±'‡”¹œ¤õ$«õî$Õzxs›r6xÍÙà¨T—·;÷6ˆïR‘íŽ"óÆ¥]`.'IFÉJÆTRɈ7øgƒï#Òq€xoXOJSõi’X.=és9IMJþHRR5‰Oü2Ά,¶+,+,3,.©éò›ËIBS†|X¨ÐÄkdÆØh²…®¹º[ȐÌ%¼|.1ês9I‹J^‹Jª35Yi²Ò˜’P’SlöÉþLF4@d±q)R˜ËI‚Tòç™’
RMƆ,6–vÄ’ÕBEDä‹)-#<c¤K´ºÀ\NÒ¬ŠÕ¬©¢šcgœ
^p”­[Qh,Tx{«<š:øÄS¹¤­ÌÕ$e«|>>TÙŽcƒ?”ïX\î-4²~¥è±%>4}P.ý«G¦¹š$ª¨üÅÛq6ø¸\¹ž¢[ &›A%hxðÃåÒÈ.0W“$²’|x¨DÆçñgƒ·Ê:·TŠL0KêâS’•’®cCåÑHRg’ˆVŠ
¿øù_ÆÙàÝ•2EªŠb2¹,Ü#“Ë”±xUV.uìs5I+^+ª|C²ê06dÕÑÖ>l°`aÉ£L%K—Bv¹š¤¯U¿xϘq6Xì(ë¡}H&”}lJ’&pN(—Jv¹š¤’¯’UÀ˜WÆÙà3IeÈâ³
%Ûue	Y¼]{P.…¬B×R3I!+^!+ª~C²36d¶2~xc¡$0Ö³~—.v¹š¤‹¯‹Õ¼!Y²ÇŽoƒ)×cú•²Äk@òÅ¥Š]`®&©bÍ«bM/Öógƒ×_m=ˆG±@üÕmŠVíÃ.0דİæÅ°¦Bß4²	6KíЪ÷ˆw
ú’VãâÁ.0דD°æE°ÿõ80›`³ÔÂáx˜µÒ—üu¹ž$5/5•¶øÙgÆÙà݁–®À8¾ºÒÒ—ôÕ.é«'I_ÍK_Me-þæ^Æؐ]“v
k‡<]iSž’¨¸T¯«Í\OR½šW½š*Úߥ"í´vEE»¢¢]Qq	^˜ëI‚W³‚÷NS1‹›¶Äj¨â˜°¶¾CêIrÖÙCGXÖ¢fH,8«~Î5¿Ö¿0^n߀«»ñ´áúfþTlÛr>«¿üÊÛóu».÷ESÕ%Ç ûÖHY½}Ýíqéçúý£¨Ú·eC¥Œáã·CÙl«ý×`SnˮĎ¥–‡ã+vŸêõ×rc÷¶­›ÂÅkW¯ªmW6ç¢CõVw¿÷o.boì·ÔßâözW6ÏÃ;|­ñùübaê[6c¹HRÁ•ëä“æʃäSÀ•û^’ù\K@rßcëˆäNF’’ú\û ý‹"“þíQIÿ
 ‡è$cÛIý z±u‚¤ÿâ8‡„Iÿ­j‰’Ìç™Æ0 >['Núïá2ˆ€XEü$c½¥¢h¶o€ô_j䈨`#* ¢‚¨€ˆ
väÄM°q7¶o©ˆ’Tò=€ˆ
v|ÄM°q“7ÉÆMBÜ$;
¢#ÙèHˆÛ·;©’»åHÿè˜óe‘TꤠÊՁX³H*!{%k@2Ie˜ôâ¸:0>’çӏ;
€düÜ–ñ’9I•—ô3˜:€d,’*Xò;¦€d,’*˜%Šm@2I•Lú“`®d‹¤
ò@±y HÆ"©‚<Pl ’±Hª ›€d,’*ÈÅæ ‹¤
ò@±y HÆ"©‚<Pl ’±lÝ“~ûÎÔ$cØ×&ýÞ–«yÀ"°çKú}Wò€E`;”ô["®ä‹ÀV!é·\È!ôbš«yÀ" 39¾ÉoŠ„CSí»_Ã/BÌž?~4`Tç’ßÊÓ[ÌàáP<—/šgÐF³mùˆwÎgÍñ…ÚásW†OýKåu×Õ»ÓÕËðëý•ì…Yݝ.F¿ÐÐëav(@oýVý»ÞÏ­›ªÜwÃÏVÜÌÇ_èaÑ¿:
zUÝïµñFïp=¾h=ï±ÙÕÐÞlS==•
¸üe³¹+÷êí¬ª¦íí	-ýYu/Ëz}zq»ØVÏû¾lÄX~{]o6Ç_X€HŸáã±õcñés	ÍŸÍÍ‹þó¹‚yñÔwí\ź.Εì+3 pyþ™’Ûÿ PK   f‰œS!
z×  Ù     xl/worksheets/sheet2.xml¥UMoÛ0½ïWº7N¶î£Aœ¢k—µ@‡i»ž‹¶µÈ¢'ÉI³_?JþˆÓìP`§Oâã#E:³ó—RE0V¢NØd4fè…Ôyž'_Xdׂ+Ԑ°Xv>7Û¢YÛÀED0µOé°2`Ál€yPÛ„ÎUÓ8¶i%·#¬@ÓI†¦äŽ\“Ç–b¸L¥ŠßÇŸâ’KÝ2LÍ[80Ëd
W˜Ö%hאPÜQM¶•íØ^Ä›ø„á[ª¿Ó3xÕœô|“Ó#¾R¦-fn”bÙJ;®ò,>;¨³Lß"¬äf]W'D\Qq+©¤Û,*ÓéM®Ñ𕢇 a<¨äéè$¦ù,`÷f>ÃÚ)©áÞD¶.IÐî+(ÜÒè°Xʼpˆç³¸’ÇOYd KØÅdzn„?%líÀŽ_=€‚ԁHͤ·âÚÞ4-pûÝHqKjhÔœ©¡—¸½DuM…ÐX{D¸|rN?¸¥¼
øÝÊÙ«õ9†v'l^‚
ñZ9Ês
m­§£Sµ­¹…
¨¥ïÉø#U늾âŽÇ}gѵ
ƒŸ°Œ+Káêá¶÷m
š‰{¤_цª.õk””í!©ia.6è?.^ï*0TÏz ¨µ^34èC󷘮AªµhöóÚáB*¦‡*¹A÷è'û5Û“VÇ|ÔÓÊHíîªðˆòý´Á=òà;&Çñ~p“S©‘‚ŒNÆ£Ï,2ÍÛa¬,Z¡sXv^¦Í{|ŸÑuNËK‰ê*ª8µïAþ°.h$}®ÂW*aíLùæ~ƒ'cžLºGìg¬õŸ¥pE»^MÚEÈ	™e`ˆòNˆoÐûÇèÒX7%Êô,]A_În¸’¹öXÛˆ§µ¢Ù(ÚŒMf“½;›¦]÷ׇŽ·û€¡“yi}ȁœ>èÐ6€Üþ_iþPK   f‰œSÍKR"x      #   xl/worksheets/_rels/sheet1.xml.relsMŒ1! {_A¶÷@cÌq×ù £Øp+a!,1ú{)-'“™yýä¤ÞÔ$¶p˜(bW¶ÈÞÂã~ÝŸAIGÞ0&_X—Ý|£„}4b5&,Bïõ¢µ¸@e*•x˜giûÀæuE÷BOúhÌI·ÿèåPK   f‰œSÍKR"x      #   xl/worksheets/_rels/sheet2.xml.relsMŒ1! {_A¶÷@cÌq×ù £Øp+a!,1ú{)-'“™yýä¤ÞÔ$¶p˜(bW¶ÈÞÂã~ÝŸAIGÞ0&_X—Ý|£„}4b5&,Bïõ¢µ¸@e*•x˜giûÀæuE÷BOúhÌI·ÿèåPK?   f‰œSjÒc]  x             ¶    [Content_Types].xmlPK?   f‰œS¶78é   K             ¶Ž  _rels/.relsPK?   f‰œSþ¾‘’ñ   F             ¶   xl/_rels/workbook.xml.relsPK?   f‰œSºV“  V             ¶É  docProps/app.xmlPK?   f‰œSÕЩÎp               ¶Š  docProps/core.xmlPK?   f‰œSs‘{Y³  ¦             ¶)  xl/theme/theme1.xmlPK?   f‰œSZäX”               ¶

  xl/sharedStrings.xmlPK?   f‰œS|®yË  ;  
           ¶Ó  xl/styles.xmlPK?   f‰œSweÛ¿  #             ¶É  xl/workbook.xmlPK?   f‰œSâŠ~Û
  êD             ¶µ  xl/worksheets/sheet1.xmlPK?   f‰œS!
z×  Ù             ¶÷!  xl/worksheets/sheet2.xmlPK?   f‰œSÍKR"x      #           ¶%  xl/worksheets/_rels/sheet1.xml.relsPK?   f‰œSÍKR"x      #           ¶½%  xl/worksheets/_rels/sheet2.xml.relsPK    
 
 h  v&    

Thank you for your time.

Sebastian Morales commented on Dec 29, 2021

Pls send your excel file, report setup, excel view, some sample data to our email support@report.com or support@koolphp.net for us to check them for you. Tks,

Finu commented on Dec 29, 2021

Oke Sebastian. Sent. Hope you can sleuth out the issue!

Thank you for your time.

Sebastian Morales commented on Dec 29, 2021

Thanks, we have got your attachment. If you don't mind pls let us know which version of Excel package you're using (this could be found in file composer.json of the package) ?

Finu commented on Dec 29, 2021

Ok Sebastian, thanks. This is the packaged version of Excel I'm using.

For additional information, initially, my Excel was safe, but when I added the code " 'hideSubTotalRows' => true " an error occurred, in the form of a warning from Excel.

Hope you can sleuth out the issue!

Thank you for your time.

Sebastian Morales commented on Dec 29, 2021

We've investigated the problem. It seems that there's some bug with "hideSubTotalRows" => true for Excel package version 7.2.0 because of incorrect rowspan when merging row cells. Pls update to the latest version of Excel package that you have access to. let us what that version is, and try excel pivot table export with "hideSubTotalRows" => true again. Tks,

Finu commented on Dec 29, 2021

Ok thanks, Sebastian, I'll update my koolreport, then try to export excel again. If there is another problem, I will ask again here.

Thank you very much, Sebastian.

Finu commented on Dec 29, 2021

Thanks, Sebastian, it works, my excel is working fine.

Sebastian Morales commented on Dec 29, 2021

It's great to hear you got it works. Rgds,

Finu commented on Dec 29, 2021

Hello Sebastian, sorry I have to open my question on this one again. For the total problem solved thanks, but here I found another bug, when I added " 'columnDimension' => 'column' " in the excel.view.php file and added " 'column' => 'Status_Hewan' " in MyExport file .php.

The data in the "Dilindungi" and "Tidak Dilindungi" columns should look like this.

But the data that comes out in my excel in the "Dilindungi" and "Tidak Dilindungi" columns data is copied from the grand total like this.

This only happens in column number 2 and so on, column number 1 is correct.

Hope you can sleuth out the issue!

Thank you for the time.

Sebastian Morales commented on Dec 30, 2021

Does this happen in excel export only or on web view as well? May I know which current version of Excel package you are on? Tks,

Finu commented on Dec 30, 2021

This happens in excel export only. This is the version of the excel package I'm currently using.

Hope you can sleuth out the issue!

Thank you for the time.

Sebastian Morales commented on Dec 30, 2021

Thank you for information. We will investigate this issue and let you know a solution soon. Tks,

Finu commented on Dec 30, 2021

Ok, Sebastian, I'm waiting for a solution soon. Thank you for your time.

Sebastian Morales commented on Dec 30, 2021

We can confirm the bug as you described with Excel package version 8.5.1. It has been fixed in version 9.0.0. But if you don't want to update to 9.0.0 you could apply the following fix by opening the file koolreport/excel/PivotTableBuilder.php and replacing this line:

    for ($i = 0; $i < $decimals; $i++) $zeros .= "0";

with this one:

    for ($deindex = 0; $deindex < $decimals; $deindex++) $zeros .= "0";

Tks,

Finu commented on Dec 31, 2021

Sorry, Sebastian I just replied to your message, I've tried the method you gave, and it worked, thank you for your time, Sebastian, you've helped me.

Thank you so much.

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
bug
help needed

Excel