Open gaohuijue opened 5 years ago
E4和F4的左父格都设置成C4,E4格能得出正确结果,但F4格不能得出正确结果,断点调试得出结论如下: 计算E4单元格时,计算“sum(D4)"表达式,由于D4是unprocessed,于是执行context.nextUnprocessedCells(),取到了F4单元格,计算"sum(E4)",虽然E4不在unprocessedCellsMap中,也就是E4被认为是processed的了,然而此时fetchTargetCells得到的name为E4的cell的data是null,所以F4单元格并没有得出正确结果。 概括一下错误原因,比如B1单元格的表达式依赖A1单元格的值,在计算B1表达式的时候A1单元格还没有完成赋值,那么B1单元格将不能得出正确结果。
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" col-span="6"><cell-style font-size="26" forecolor="0,0,0" align="center" valign="middle"></cell-style><simple-value><![CDATA[员工信息纵向多片交叉统计表]]></simple-value></cell><cell expand="None" name="A2" row="2" col="1" row-span="2" col-span="3"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><slash-value><slash text="学历" x="189" y="8" degree="2"/><slash text="性别" x="189" y="55" degree="11"/><slash text="人数" x="170" y="85" degree="26"/><slash text="分片" x="20" y="93" degree="9"/><slash text="公司" x="93" y="93" degree="36"/><slash text="部门" x="146" y="95" degree="47"/><base64-data><![CDATA[data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAANkAAABuCAYAAACqcba7AAAfH0lEQVR4Xu3dB/y/XTkH8CtkRlkhiTIjIntkJGUnO5TKSkVDopRelUiFQkYquxSPjJIGRSVPZJMKGRGRvUe83s9zjs5znu+4x7nH9/u7r9fr//r/f7//Pc657vM5177OVSLif9Of/46IX46I50bEpenffxUbbRzYODCKA1eJiPtHxO0j4m0i4r8i4g8j4h8j4noR8e8JbBl0/n71qDduN28cuGAcADL0ooj4wYj4ioh4vQS0N4mIJ0TESyLiBhHxQRHxgRHxwiTpMvD+4ILxbJvuejnwdkkro4F9WET8UkT8R0S8Z0S8UVq3NLdMrxsR/7lnOrDxOknwjJpxBplB/HBE3DIifiEi/jgN6jcj4pMj4hkR8d0R8fMR8f4JbAAHeG+2Q9r9w6hRbTdvHBjGAQLi3hHxQxHxDhFxrfTv20XET0dEbf7cKSJemdY6sL20ABXB8gER8Y0R8efDhnP5XRlk/v3AhPqvSwODfCok9fHnIuJzI8JOAWz+/HN6MZBlKZf/fkUl7X59zCC3ezcOdOCAdYgIDKD414i4RkT8T0SQWL8dEa+dfs6P+6KI+PGIeFX6xV0i4qlJe+vwym6XlCBzx4sj4pPSSwzgHhHx8ATARybwfUlE+POTCWzP2fGqd6uknV2BU6W07V7ebYjbVRsHOnHgoyPirRPA+BSyGnjNiHj7pPp9cEQ8IGlqHlqDrP6504uPXVSD7IYR8f0R8d7pxndJ6uNdI+JdI+JuEfFlCWwkG7C9eQLbdx3Qb6+6Q9p5N9CVwKM/b7RxoC8HrhYR1ujPJPXv34oHsKuAjy1GXSxVRqD6vQRCGtvNkiRzDy3OGiVMSMPBVIPMgx4UEf8SEV9fPPVHIuJvk777bQlwX56k07snsN0hIh6XAEdqHaO3raQdG48DpgSdnzfaONCVA69VhKTcw+T5vGTa/ERa1/lZr59MIGsWKK8eEZ8ZEY9NoHqvZNP9bNeX77tuF8hcywD8uIgoPYdfGhF3joiPTEblt0bEyyIC2P4mveC2CXBvUEi30ptzbLwkaHao+BsQa2mX33XsWdv/X2wOAMk7R8STk6+BdAKs7Et4w4i4RUQ8MYGKpsasuSSx7UPT388by8Z9ILtRRHxPRLxv9QJS69kRcceI+LGIuFVEANt3RsTXFtdSO6mSpNujE+C4/vuSMAKwlcDjuSyl3Qv6PnS7/uw4QAoByD8VcVxrhi3G4fFHacN2HVAxS94yufmflLjx8RHxJxHxu+nnT0hChp9iFO0DmYc+OCL+Lrkw65f8aET8ZbLP/N99I+LuSaqJt5VE7wU4Eo1XEujG0DtWoBNSqKUdCbvRxebAMUn0PhEhywkI3zQiPjupitkvcOvkVf+LsWw8BDLPtgPw2uxatFTHL46Ij0hg5C4l1a6fwPb8anDvl8AmZpHDAL81dgLJOK2lXQ48lh5NduZG588BrnwaENPjryNil7rHlf+xEfHMiGDHURuFqQgVmPA761TsmHQcRcdABhhUQdJiF4lJCF5Ly2JYIvcAG9HLXjPRkkwwhwEsfIDj0WxJ3Laliil+J8BeqpktAN5yzNuz2nFASiDv93cUMbDy6ddOzg7r33oVhrIW/czN/zUR8QMp42n0qI6BzAsekoDy0ANvo9daxFz8mYhfYOPaL+218jEmBHCfVUi3qTyK71EBj1Fcgo7UowJvdHE4UAenzRwmOO54HPs47fZyrQvI3AxA1ELSaR+JU9wmeR8FAzOx1+REkmp2h13E65OlG8lHunGtTkkYWUs7AcysYmYAjoqRTDmB7dmnwYGuIJPDJT5mUR4ixiTvo9iEXLFMvDqkGmkCbBI399GHJ8DJPMm221xJyNcpguYZgL9RZasIb2y0caAzB7qCzAMfFhFyEr+pw9N/KqVmScsqSUgA2P4seSZre6289o0L6UaCAhyv5txkzGVu5lvskHZ/P/egtvedDgf6gMys/jQiuEaB5BhREdll1EzJmiWxwUhGwKFOHiMeTuqkv7N0O6S6HnvemP/n7s2gy9JOJnfpyfy1MS/Y7j0vDvQFGUcFSfYhHdnAc8P7+OkpJ6y+7T4R8ZVJheziYeSezbYbBwnAZa9mxyFNcpkcz1LayTaobbsuG9Mkg9seuiwH+oLMaL8lOUBk53cliZtc5l+94wYxDSqkcAB7rWsaizgHwAE+sPFiUmfXQFJ4amnnd3Ulgsrzjc6cA0NAhiXqdcTO+kTDvyoiPiV5H3dl20vlAjbPlulPBetCb1WkcP1qAtxTutw48zWyuuu6Oyk7ZbaKjPCNzowDQ0HGLlMxqsS7D1lkvI+qrZ++50aZ0Ow1uZPUyT7EI0m6yZ3M0m3NCcXGWWar8G7W0u6Qc6gPb7ZrF+LAUJAZ7iNS1TTp05eeFhGkjsj6PvJ/pB8V8vt6vkBEPyco/2IC3D5Q93z0pJeri6qlnbSeOjdz0kFsD2/LgTEgMxI2kNjYkEwJvRhkPvM+7gv4cuMDsR0f2LSr60ufmgAnwyNLt1PqQSJFqM7NrEEnx3SjlXJgLMhunIo8BZCHELWT91FFqiY9+wiQgY0NCGxD+kFet5BuCvEA7llDBr2Ce2rQ2Yxq4I1ObF3BPM9iCGNBhgnsJwb8t4/giAxoUup+R57BXgO2xxxRNY8NRZyOOqkoNEu3OpZ37Blr+n+1UTXwhAzK3EydxzZagAMtQGbYJAsXfFeP4K6pSiK+SfI+HmMFVfNeSap977GLD/y/+Fa23XQtArghKumIIUx2qwLbMjdT5W8t7fp4hycb6Lk/uBXItCQghT5qJMPYZ7yPnkeNPEScBKQaVZLLfyw45FsCnIyOLN10VD4XkoRdSzu2cF2JoJBxo4YcaAUyQ1K7o8pU/dlYAjQ2mvZdx0hxHpWVE4a9NsQJU75DEnOWbppkApyFeI6kj2ZdiSBpoATe6PL7c2Rcnzm1BJn3iklRS3KzyD5jqa/Vo18cTr5iF/qMJNmoj9TJFqQ6FuB0ps3SrcVz1/wMSQEl8AT7a2mngnijjhxoDTI2lfhWV2AcG6bniW9RI7umW7HVjIFU096rBZGWWbo9KgHuoiQBaytRSzubaQk8Mc+N9nCgNci8Rg6httx2/hakepV9Jv+x7AV56Nl6fLDX7MrAtqvL8dCx6WsCcOwZc+TpvGgk5lgCj11cSzsVGxtVvfBbMkQjVF2lWqoVmq7K6r95j4GSQMDG+wlsLROI5W4C2+cXquTv9BjbOV1qI6ylnf7zNfDKzr7nNP+Dc5lCknnhTVNK1Mc05qSgtYpr6mOXLsX59UptgE05DXWyJcmuz6qktguk2742Cy3fu/ZnaY1dA0+Fe5mbmXscrn0uo8Y3FcgMiu3yKynRd9Qgq5vtkNRHdWSSlPuQUhtFolz+rey18v3q7ACOEyY7Sjbv3Gs4JJZa5mY63qiWdmNirX3WwmzXTgkyk1CWr4vrFLmCmq8qjpT/2Ie0Z+by11aACimBuDVp0pOlm5ACwD2+9UvO4Hls51raybypKxGadI1ail9Tg4x6pw1BHzuqDy/069cunPrY18Ml6ZgKqZQE2KbKfjA2gNP2OUu3LaF3/1cm3epKBN+2BJ4TWE6GpgYZRvC+cb9PoZ55PslEfXTyTJcmP/XH+bQENu3Fd1Vut/qYKsCzdAMygLNBbHScA5xMJfCEFWppV7YhPP7EGa+YA2SmIyNcZXA+UWOKKeqmJRdRQegQUrsmf5JUm9otzzEEcNLQsnTbeoB0/2rOxKulHU2kBJ5WfquguUBGreNs6Gs/9WWSymj9y6loQ47QJRWpkHZOYDuWP9l3fPX1FkuWbtz/AOfQuY36c8DpriXwJEjX0m7U2c/9h3T5HXOBzLukO1m0fauc+85NbZX3cKP3afZTvodDBdikhwHbHB/HRgRwHAFZuo3Nw+zLu3O6nhe6lnbmVwMvH3s72dznBJlJaOqv9mmO2i1dtRjRtxzBPVXVwCZReEp7rRyi+FKWbs5eAzjZLhuN54D6wRp4YnVlGOH3x7/mik+YG2Q8bE7s/MTWE9nzPN2xOFyojyoEhhJ7TSkPqTb2fLU+Y2BfApz4UpZuLZKv+4zh3K+VElaGEfgO6rq7UTyfG2Q+mKwLldBzZUWoD6M+Co6Pqd4W+yLVfBBgU44zFylJydLNewHuGXO9/IK9x7kNdd2d9MBS2kmy6ExLgMzg5LBZ/HM29xSAporJxhhDpAqwYTxnzhz2WjleIQeAkxuapdtq3ddjGL2ie9+pknYSGWpp5+SjnbQUyHgBHXM71N0+lP9yGBWVUh/HNhJl6wEubyZ1cm7SxSpLNzab6oepvaFzz3Gt73MSZy3taDp1ithlvoelQObdnAlPTYt0TmY6lcVipDq2qOK+Z0QoMKVCasi6BDnY4w5JUmfpdiEz3pdgfnqn4tY6RUzSwaVLgszYuE/lry3RS0O7BAdYWKBjSf8MKqS+/MC2VKs5VelZuskmId0OnQU3dt5rvF/sUa7sGnqV3ADwlgYZ7596rDFu9jEfWms4sTTq40vGPCjdi6nAJjEa2F7e4JlDH3HrJN2kc2XptoaFN3Q+Xe9zVrRvWTonlCO9Ov3p+pxm1y0NMhNxbK0asaWy1DlDqI/SslqpezYNYDMn6uSSBPhZuvHokm69vGNLDr7nuxWP6jqmvZ9UPpKdQ+IWKbGAV3t2WgPITNoOq1nNkuczc/FLq/KRWpGz1x6YpJrnL023T9LNzp4PU1x6TK3eb/2wizjUdIgWVPZvdremuNTnulLfBstLq18LG5ZDQ1lN09KatYBMZgUxzz29JBmDQlDqY6tyCh+fVNOSnMt/KXut5KsAbD5MMauSq0moHbgAnGuu9wg73yYiPMTeJ7X18ZTWBzw29AwirnhAY7eKRTIfxHGz6cC+8/1GlUGtBWT4qlTlSRHxhIFMbnWb1Bvqo6Y9Lctz9HPk8meUs9fWknWfVUmLE+BazrnVNzn2HI4nlQ3OvVPpQYo5n8HZ5cBzqwQ2QOTRzi3LHSQJQHpNeoZNPp9Ljh9yWKXmMWcGS7c1gQwjGaf06sETOvY1evy/chc7IsdMS+LsIdlsJtTJtZAFCHAcJlm6nVoPDraw9DlZG4AmV5a08vOuA03ukpIJqJGuFXS+JCLunDabfNAlEA6mtYFMsJjIHpuVMZgh1Y23SV2MqY+tD4K/RzoRh1Rr1T6vxbyvWjhKeEmNTUHr2snmzOZ8YlIVAcQmKUOHZkJzoCrWp92QgOasNEreIo+wJAmb7BckaTjqIMa1gcyHJK7t8mupGtajxEdS0Nk631I5BqnmCCr22qHjo5ZY5OxI0o0alaVbi1DHFHNR4sS2l+RQOtC+MPXdFMrg3FC3x84SONa6UJdqKmTeRKmIsmk4T0h1GT2jqkbWCDJjwiSenjURg9hOaHdrTQoM2Wt2WZJtbY1BeV2z7caGATg29JrIZqiMpbTpjZsziyTelScLmEComZIenSQZR4kOyb5Blmij5rlGkJkQlZF+3SIbYxSDqpupI1qAUx+nCDSL55BspDl1co3EUwdwikyzdHvZCgYKYNQ+jWxlEEncZosdAgoNgjYhfqYMS5GsDc/PJB+nyehqh7WCzDdjgBLVAotrIqoE9VERp/FNQTp8fUOSaoLHayQLOEs3TUuNc8lvpbkOtS678LnfOTIUCatSABhexRyq4EW2YZB8tCbt15koHFMkH3WSJ/iFY5m/ZpAxZLlkGa9rJLq/j+rjTEF2ZVKNK5oKuUi2QseJ6RQtQdlYs3SbQtJ3HM7OywCJm57ayJNKVaQm2iz8W1OjHL7g5WaP4fmoGJmRrBlkxie+oSzmc8Zwd8J7ZRRQ66iPU/XjoL4AGxczsLX2crZkjwqHLN24vUk3MaY1UZ3VIYAtlKJZLt5eP9nGqvcFsEc5PU4BZMYoQM3poC33GkkbOurjXScOpLMtgI0aTZ1cO+lMRro5JCRLN/bS2onmdPeIUKbSxMO9dknmg1Cb7OIM1DUTbxuX8B0nHqQFIPWLy3+t9lrJAh67LN10ijJm7vELQ6cAMh+DG5Y3q2Xy7hQfWZMgi5/6OCqAeWRwdlsuf++hQj5zislM8EzeU9KNCpylm43prOlUQOYjyENTirI2Hb9eIHR66iOJ1kTdOLACvYsKKcgKbHv7TKxsFV+nkG4C8KTbmh07o9h3SiDjGZJjppfCKZBYF2cIyTY1cQ4BG/uVOnlKJJWOdJOIm6Vbnfp0SvO50lhPCWQGL5fQedStk3an+ogSTbn4qXUtTx3dN967RcRDklRr0b9kKr7seq66rmy7PTlJtymOtZpzTpe969RAZsw+gAX0lNm5NeyFOUFVtsgcHlL2Gqkm7kOFHJ2xMGzao+4SuiHdrllItznbB44afH3zKYJMPhqngoK8UyKqHJuJtJmDHMAAbAL6wLaG1Ke+8zaHLN1k17Pdnt/3IUtff4ogw7PbJhXsdkszsOf7xdKoutTHuRqSCqoCGyl6avZayV6mAul2tUK6LdmuovOnP1WQmaCGntzYyhROiWR78z4KR8zpKSVBH5qkmnZ4p0rU7yzdnBBEuvU9ZXXWuZ8yyOxor0h5Z7MyrdHLhCTUZs2ZbS8flFTjPKJCPr3RXJZ6jLIj0k2qFLC16jbWdD6nDDKM4ExQWDhFjVdTRu95mPQo5TzUx9E5cj0GrFUasCkJEWI4RXutnO6NEtjUhuUwQO7j0YMt01x66iDDlaels6JPdVeW20d9FC+aW/VVQ0XldrrnXA6ZaVby5U+1nrMqyRtJuk196OTR+ZwDyJQqyJ5WT3TKxMaUuT7XYYMlrzhkHGpPhXzkKTOxGLt6MKqkCo4s3cYeMjKINecAMhNXcqJxylS1XYOYO+Amp8OoCKc+cr3PSewaKqTaMGCjIZwDSSzP0k2eJOk2VbHtTn6dC8hMTtBVdvqpJMvuW8B2YOqj0pYlVGClO8CmnwmwKflYgjhpWrvoNc0h3VQ/Z+n20qknd04gc6igrr9OajkHIkm4pvUUWYLYa8AmzECdnJN8S4WUj0g9O1q/WyJDlm4quEk3we5J6JxAhkEYpwW13eoc6N4RofiR+th6V+/KHw1AHXJPqo05Drjr+1ynJMZBGbo4T93oVvqZ9XKzQro1rWY4N5D5QEomHrTCHoZ9Fll5rRAF9dEiWKovo3VCqt08ufyntNc0uNFEaO6z1TjOsnQTv/R+qXCj6RxBpkvRiyNCv4lzIpvHcyPifgtOSj8MLn9SlWRrdShHnpLkZtKbJLGhLNWMx4ZGurHhsu02+GzwcwSZD6ZCWfrN1K0A5l7vuhjL1qA+LklUWJJNJQR1sgVZi7nPplZsz0st2XY9W7Gq3M/cmmKqKnTt5LJ000qOdFMF0ovOFWSY8Oy065/bYeXarpmTnoFLz40045zwNwk3lLTN1mKC/aXVnqRmfUDqc6+tV38cG0zqydKX+KxWT7/FKYkjiHSTXZKl2yu7vPCcQaYWyQkfDoY7R7KJUKkesILJkWqOIQK2Pk1yxLB0/tW/RSW5Qx9UwOt5qMHoLpDdMCLYba9K39YaZiIAGzVPg9UpY4zXKqSbc81It4M26jmDzNpTmSxPb44WAIfWOtXVuVmtcwTvn+wGKuScJDlbBzFkDWkGyl4DNtII2HQV3kdaYOvuKxbmOqfHZC8ikMlB1AawbkPgXTZNJ2feJB2FLIuDbSh/1aZKzZzrbGzxNtKNRAU2Eu5KFfDnDjIfWQm7WNNz5lyF6V3aoakf4ygQh7FoLNCWB0pYbILW7DQLbA66dkRcNzko/F22CSCVgE0eJrANIZuj+FzZyBUwAVnlBclFpXR+GmDpcWLuo1tqDxlsRDjsAtjYb5IhAO7/PcFDQEZ/lhXgCBoqmUzuNbf1clxpPntqIA8738ZOcKIm/tjdnEUM3LlAk7fK4XRODWlJJAL7TP6j2NIUpJU1cHFvUw3NTTxLpfKujHfaA7ANsdccOIKXZfoTtdJmhXeyYmT4kODSwfCXYwLfeSQ1UV2qGY+z9QBOR67LpNsQkNF7IddZXUS3STYN3k2wQnxojVpaecKGDJH9YVHKeJ/KSBcflMPpG01BOkrZPMxFPZyfZdjYcPfNCdBIN9+ga5UB6SgAfq+IeFExEadmqlYAMJLLu20wVExrkAR8QeoStlQ6WB4udfgy6dYXZFynApJ0T0YpF6fTMuxquwgI6evZxcpoVIKwhOQTY5KAO5dKhR9UHAm/nAHmLR9x6lMrJfhyM1MfdextQaSKsAipzN6xsWpQatEDG0nCFtmnBltwwGa9AduxfEHXiXNaO+w1EowGlfM5rTneSJ25rCnrie0tXWp1DZb6gIxHhx7MxZqNXruIRWRitSfIx2UvoKyfOrHRDkN9m5t8DAe8mceUZAH64KRW3vEFxzUAchLkHNW73kt95HGTND2G9LnkiPANmQa8elRwsSyqmfn6rjZUHsJD/e6pmcDGG9fVGWUjp4WQVniobQPPKscILyKVkWoI8Hg7l9OjM0+7gMw1vGMmaqcilu1adhlkcgxShn3+XR4A3dpumg1YJSlcrD7UEiTRlao7RYEiKU89sNtL7LUAyw+u7k0pjvy/ekOSp0fSHfLIDeGXk0oczyp4PITYYZrvPCs5N6wFaV48paQGaUNaO4+Z88PmQqo5buhQziG1TlyN+g50fQjorSPFmMClulxCMVs0b/59njf5tV1AZlLAk2MPGCkyz8gmFagNJkelsJNkI5+Us5hJLQuOSCfuH5cW2RSlDF0YxlA3rlaqVH4nPlHRqEbZ/Wz3xSMuZtJFxsbjk1fMfWwPXYaBjnRwwCCbouVuzB7SLtzY+jacIaVkVfCS8ooCj42CJGKH6U8CgMasQRBJzbFjw+1idwpkC/JSIa2nY2Q8NklS07oDcJJOH86lUrCOjXlQc1NAsTAw1gSzCmSByO/Ku7RdEBgtOGoGhmCQ3/NKKrunyszVGi0zgz7PLuP9mYLYDrIyLEhSnzrDHW1nt1BJgKxSWTQOpLNA/HGvn8V+Wkp7ahb10ckzKqCHEGnLDvrmJMm4q0ltc6Tp8DAO6ZJMQyLNbLrA1vfgd5LVemqSzDuEMcfu6SLJymeYjO6uXJMkG1URcHYdY+r3FphdjXqxJqJi2J2n7BQllmO3laHwmD02K6DjDRBwj9u4gJEHz6ITB2pZ6vGwpNKJK/Uhm4F5UPt9d04QGwdbk2YjvWgXwKwXEo3z4hhxqAEbzyF7reu8qYqSim3mpOvqqA/I7LJiAJiQd2IGL0+R3hQ1kXiuoz5kCSbfjgt7Dcy4NH1MC3sq4mxhP5DYdZtpi4MN5/0CquwLtXA5AwLwOJUEN9k8rYjzispOfezrgKKFsKeMyTgBiCZjI83mRLaZfGf2IM9yH9X8Tsleo9JTJ0+euoDMNYJ8VAIeJrsSPR1ZJAxQnqaSqIY6vpY7uOfwUrEPhqgVrZkN+FQosZ6pSByHXVafO8x+BT5eMnEg/HUtycCBApDUbprAPik4ZszAYu5inQ/v8SCgIbW41NmX1N9HF2ERqjCQKMuxkZKY3jMkS9643E+FXJ1bvgfPOtlkPohdqjRk6ecCn87UrQ9RACbeLBKu1K/tzHR6caK1HB6gxJ1dec8+TGtw7Y2T1BI/wyeqoQ2LZGEvWqwcDDawKTckAV+bDInZlwAM2EobHB/ZfdTcTBw6eExa9yV2PhXSpg5sNqGToy6SbNek3Gc35tAoye+UIUiErb092UkikL0mEjtjY/T1vLWYg2pc4Q9eRmCiiuOtpq0yvMtshxbv2/UMSa6PTerjECB4pm/L1e85uwLN7E0bx1CQyGABNmoqsNWhoql40+S5Q0E25OWMearQ2rxAFjj1xq65BHEcyNLgTOK655nkoqZWdzX+x46bfUite9SAPh5CFFRE/RoPVQ8DGhrjavceYOO46qPmjuXPqPvnBFk+6miNAUPpVhbaEo1Fyw9ItRL2EPeZsiZq36IRIOZ1lR/YhWxMFr70pkOZHp7l+98nZYXsS8Pr8k7XUHNl1JBqvSuVu76k1XVzgqzVmKd6jjIJzoixC6Dv+Lj6kV742iVIWzu2YPu+o8/1PMakKu/jsY67uVL5mPrGqUP68GqW9lqfcdXX0kBINV5vLv+hquiYMXS6dwPZa9gkU0OWOBtpTspODx7GS6rarDnHUb5LuhT1UQrY2GNxj9lrY+dI1SaBqfwk21Kt8/bOYwPZFVkjqEmtmbuhqHACD5r0q7nssC6L2zlmpFBucNPlnvIa9pp8UfbT4G5PHV9KCyDZeIypk6uhDWRX/hSK/1Qzr+bonYVXiyRvIKE+dkl5smEAFHWOl1Qa1pA42dBpe5+QBKk25yGLmyTr8cWobT4Or99Gl3OAQ4b6KC3rWKmOEI5EBDmpMl2WqB0U+yPVJAIAm6yjxWiTZLtZzwvGoL7vYl9mnS/m4qdOSyrYRxw5kn7F3HbVGM45M/YasKkUALaW1Q2d57GBbD+r5GNaTEMDtJ0/wold6LwvLnvqY+sOwlOxQrIBsAnVUCdnpQ1k+9kteC5wLoC+0RU5wKFBfVQoKcvjVEiZjxAFl/9s9toGssPLQxIsF/uS/efXvIAlL0ul4yg6FeKY4fJXLUCFnDx1bQPZ8aUhm5yHrVUQ9fgbT+sKTg5djKesZpiCIzdNKiTpZrOYjP4PISB9x/ZYpEIAAAAASUVORK5CYII=]]></base64-data></slash-value></cell><cell expand="Right" name="D2" row="2" col="4" col-span="2"><cell-style font-size="10" forecolor="0,0,0" bgcolor="218,238,138" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="employee" aggregate="group" property="DEGREE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="F2" row="2" col="6" row-span="2"><cell-style font-size="10" forecolor="0,0,0" bgcolor="124,146,186" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[合计]]></simple-value></cell><cell expand="Right" name="D3" row="3" col="4"><cell-style font-size="10" forecolor="0,0,0" bgcolor="218,238,138" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="employee" aggregate="group" property="SEX" order="none" mapping-type="simple"><mapping-item value="true" label="男"/><mapping-item value="false" label="女"/></dataset-value></cell><cell expand="None" name="E3" row="3" col="5"><cell-style font-size="10" forecolor="0,0,0" bgcolor="217,217,217" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[小计]]></simple-value></cell><cell expand="None" name="A4" row="4" col="1" row-span="3"><cell-style font-size="10" forecolor="0,0,0" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[按公司部门分组]]></simple-value></cell><cell expand="Down" name="B4" row="4" col="2" row-span="2"><cell-style font-size="10" forecolor="0,0,0" bgcolor="255,255,0" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="branch" aggregate="group" property="BRANCH_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="C4" row="4" col="3"><cell-style font-size="10" forecolor="0,0,0" bgcolor="255,255,0" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="dept" aggregate="group" property="DEPT_NAME" order="none" mapping-type="simple"><condition property="BRANCH_ID" op="==" id="undefined" type="property"><value><![CDATA[branch.select(BRANCH_ID)]]></value></condition></dataset-value></cell><cell expand="None" name="D4" row="4" col="4"><cell-style font-size="10" forecolor="0,0,0" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="employee" aggregate="count" property="EMPLOYEE_ID" order="none" mapping-type="simple"><condition property="DEPT_ID" op="==" id="undefined" type="property"><value><![CDATA[dept.select(DEPT_ID)]]></value></condition></dataset-value></cell><cell expand="None" name="E4" row="4" col="5" left-cell="C4"><cell-style font-size="10" forecolor="0,0,0" bgcolor="217,217,217" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(D4)]]></expression-value></cell><cell expand="None" name="F4" row="4" col="6" left-cell="C4"><cell-style font-size="10" forecolor="0,0,0" bgcolor="124,146,186" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(E4)]]></expression-value></cell><cell expand="None" name="C5" row="5" col="3"><cell-style font-size="10" forecolor="0,0,0" bgcolor="217,217,217" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[小计]]></simple-value></cell><cell expand="None" name="D5" row="5" col="4" top-cell="D3"><cell-style font-size="10" forecolor="0,0,0" bgcolor="217,217,217" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="E5" row="5" col="5" top-cell="D2"><cell-style font-size="10" forecolor="0,0,0" bgcolor="217,217,217" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="F5" row="5" col="6" left-cell="B4"><cell-style font-size="10" forecolor="0,0,0" bgcolor="124,146,186" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="B6" row="6" col="2" col-span="2"><cell-style font-size="10" forecolor="255,255,255" bgcolor="124,146,186" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[合计]]></simple-value></cell><cell expand="None" name="D6" row="6" col="4" top-cell="D3"><cell-style font-size="10" forecolor="255,255,255" bgcolor="124,146,186" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="E6" row="6" col="5" top-cell="D2"><cell-style font-size="10" forecolor="255,255,255" bgcolor="124,146,186" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="F6" row="6" col="6" top-cell="F4"><cell-style font-size="10" forecolor="0,0,0" bgcolor="124,146,186" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A7" row="7" col="1" row-span="2"><cell-style font-size="10" forecolor="0,0,0" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[按背景分组]]></simple-value></cell><cell expand="Down" name="B7" row="7" col="2" col-span="2"><cell-style font-size="10" forecolor="0,0,0" bgcolor="255,128,64" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="employee" aggregate="group" property="BACKGROUND" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="D7" row="7" col="4" top-cell="D3"><cell-style font-size="10" forecolor="0,0,0" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="employee" aggregate="count" property="EMPLOYEE_ID" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="E7" row="7" col="5" left-cell="B7"><cell-style font-size="10" forecolor="0,0,0" bgcolor="0,128,255" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(D7)]]></expression-value></cell><cell expand="None" name="F7" row="7" col="6" left-cell="D7"><cell-style font-size="10" forecolor="0,0,0" bgcolor="0,255,255" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(E7)]]></expression-value></cell><cell expand="None" name="B8" row="8" col="2" col-span="2"><cell-style font-size="10" forecolor="0,0,0" bgcolor="0,128,255" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[合计]]></simple-value></cell><cell expand="None" name="D8" row="8" col="4" top-cell="D3"><cell-style font-size="10" forecolor="0,0,0" bgcolor="0,128,255" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(D7)]]></expression-value></cell><cell expand="None" name="E8" row="8" col="5" left-cell="B8"><cell-style font-size="10" forecolor="0,0,0" bgcolor="0,128,255" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(D8)]]></expression-value></cell><cell expand="None" name="F8" row="8" col="6" top-cell="F6"><cell-style font-size="10" forecolor="0,0,0" bgcolor="0,255,255" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(F7)]]></expression-value></cell><row row-number="1" height="36"/><row row-number="2" height="35"/><row row-number="3" height="50"/><row row-number="4" height="24"/><row row-number="5" height="14"/><row row-number="6" height="14"/><row row-number="7" height="14"/><row row-number="8" height="14"/><column col-number="1" width="55"/><column col-number="2" width="55"/><column col-number="3" width="55"/><column col-number="4" width="43"/><column col-number="5" width="55"/><column col-number="6" width="55"/><datasource name="DefaultBuildinDatasource" type="buildin"><dataset name="employee" type="sql"><sql><![CDATA[select * from EMPLOYEE]]></sql><field name="EMPLOYEE_ID"/><field name="DEPT_ID"/><field name="EMPLOYEE_NAME"/><field name="SEX"/><field name="BIRTHDAY"/><field name="MARRIED"/><field name="SALARY"/><field name="DEGREE"/><field name="EMAIL"/><field name="WEB"/><field name="CMNT"/><field name="IMAGE"/><field name="BACKGROUND"/></dataset><dataset name="branch" type="sql"><sql><![CDATA[select * from BRANCH]]></sql><field name="BRANCH_ID"/><field name="BRANCH_NAME"/></dataset><dataset name="dept" type="sql"><sql><![CDATA[select * from DEPT]]></sql><field name="DEPT_ID"/><field name="BRANCH_ID"/><field name="DEPT_NAME"/></dataset></datasource><paper type="A4" left-margin="90" right-margin="90" top-margin="72" bottom-margin="72" paging-mode="fitpage" fixrows="0" width="595" height="842" orientation="portrait" html-report-align="left" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>
你是怎么断点调试的?
当前使用的UReport的具体版本号:2.2.9
遇到的问题描述:
E4和F4的左父格都设置成C4,E4格能得出正确结果,但F4格不能得出正确结果,断点调试得出结论如下: 计算E4单元格时,计算“sum(D4)"表达式,由于D4是unprocessed,于是执行context.nextUnprocessedCells(),取到了F4单元格,计算"sum(E4)",虽然E4不在unprocessedCellsMap中,也就是E4被认为是processed的了,然而此时fetchTargetCells得到的name为E4的cell的data是null,所以F4单元格并没有得出正确结果。
概括一下错误原因,比如B1单元格的表达式依赖A1单元格的值,在计算B1表达式的时候A1单元格还没有完成赋值,那么B1单元格将不能得出正确结果。
报表代码