We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
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>
The text was updated successfully, but these errors were encountered:
你是怎么断点调试的?
Sorry, something went wrong.
No branches or pull requests
当前使用的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单元格将不能得出正确结果。
报表代码
The text was updated successfully, but these errors were encountered: