From 64f64662b602e107038773d589fcee437cb2838c Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 12 十月 2026 14:05:50 +0800 Subject: [PATCH] fix(汇总大表): 城市分市州当月标题行号差一行（45/67→44/66）并恢复被覆盖的单位行 待验收 --- HANDOFF.md | 28 ++++++++++++++++++++++++++++ 1 files changed, 28 insertions(+), 0 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index fe53f3d..5d14bcb 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -17,6 +17,34 @@ - **鍙ｅ緞缁撹锛堝啓杩涜璁★級**锛�**鏂版瘝鐗堜竴寰嬩粠"褰撴湡浜х墿"娲剧敓**锛堜骇鐗╁甫褰撴湡鏁版嵁涓庡叕寮忥級锛屼笉鍐嶄粠鏃ф瘝鐗堟淳鐢熲�斺�斿惁鍒欐瘡鏈堥兘浼氫涪"褰撴湡鍒�"锛岀疮璁￠�愭湀婕忔暟銆� - **閬楃暀**锛氣憼 寰呯敤鎴风‘璁ゆ槸鍚︽妸 v3 钀界洏涓烘寮� 9 鏈堟瘝鐗堬紙浼氬厛澶囦唤鎵嬪伐鐗堬級锛涒憽 鎵╁垪浜х墿涓閲嶅啓鐨勫叕寮忔殏鏃犵紦瀛樺�硷紙鍙啓鍏紡 + `fullCalcOnLoad`锛孍xcel/WPS 鎵撳紑鑷姩绠楋級鈥斺�斿缓璁ˉ"鏁存湰閲嶇畻鍐欑紦瀛�"锛涒憿 `涓彛寰勬槑缁哷 琛ㄥご琛岃瘑鍒繑鍥� `[2,4]`锛岄渶鏍告煡銆� - **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎵╁垪浠ュ綋鏈熶骇鐗╀负搴昣2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +### 10-12锛�4锛夛細鎵╁垪鍏紡鍏嬮殕涓ゅ淇 + 9 鏈堟瘝鐗堣惤鐩� + 绔埌绔獙璇侀�氳繃銆愬緟楠屾敹銆� + +- **淇墠闂锛堝悓涓�鎵规鐨勪笁涓級**锛氣憼 鍏嬮殕"褰撴湀鍊煎垪"鏃跺叕寮忔湭鐩稿鍙崇Щ锛堟柊鍒楀啓鎴� `=Q7+Q9`锛屽簲 `=S7+S9`锛夆啋 鍏ㄧ渷琛屽彇鍒颁笂鏈堟暟锛涒憽 鍏嬮殕"褰撴湀鍚屾瘮鍒�"鏃跺垎瀛愭寚鍚戞棫鏈堜唤锛坄=Q5/AN5-1`锛屽簲 `=S5/AN5-1`锛夆啋 绠楃殑鏄�"涓婃湀鍊济峰幓骞村悓鏈�"锛涒憿 POI `setCellFormula` **涓嶆帴鍙楀墠瀵� `=`** 鈫� 鎺ュ彛 500锛坄FormulaParseException`锛屄�6.3 鍘嗗彶鍧戯級銆� +- **淇硶**锛氭柊澧� `shiftRefsAll`锛堝厠闅嗘椂瀵�"鏈〉/宸叉墿鍒楅〉"寮曠敤**鏃犳潯浠� +2**锛岀浉瀵瑰鍒讹級涓� `cloneYoyCell`锛堜笉鍏嬮殕锛岀洿鎺ュ啓 `鏈湀鍊�/琛ㄤ腑瀹氫綅鐨勫幓骞村悓鏈�-1`锛屽嵆 C3 鍙ｅ緞锛夛紱鍏紡涓插幓鎺夊墠瀵� `=`銆� +- **9 鏈堟瘝鐗堣惤鐩橈紙鐢ㄦ埛宸茬‘璁わ級**锛氭墜宸ョ増澶囦唤涓� `_bak_2026骞�9鏈堟瘝鐗坃鎵嬪伐鐗坃20261012.xlsx`锛涙柊姣嶇増 = "8 鏈堜骇鐗� 鈫� 鎵╁垪"锛�1,083,567 B锛涜緭鍑虹洰褰曞懡鍚嶇悊椤猴紙鏈�鏂颁欢 `_鎵╁垪_2026骞�9鏈坃寰呯‘璁�.xlsx`锛屾棫鐗堝姞 `_bak_` 鍓嶇紑锛夈�� +- **绔埌绔獙璇侊紙鐢ㄦ柊姣嶇増鐢熸垚 2026-09锛�**锛� + - 璐ц繍 8 鏈堝垪鏈夊�硷細鍏ㄥ彛寰� **16888.7615**銆佽涓� **3665.3638**銆佽涓� **13223.3977**锛� + - 9 鏈堝垪锛氬叏鍙ｅ緞 3575.1211锛堚憽琛ㄦ湭瀵硷紝鍙湁鈶犺涓婏級銆佽涓� 3575.1211锛� + - **绱锛氬叏鍙ｅ緞 133887.0138锛�=1-8鏈� 130311.89 + 9鏈� 3575.12锛夈�佽涓� 34974.9459锛�=27734.46+3665.36+3575.12锛夈�佽涓� 98912.0679** 鉁� 涓庢墜绠椾竴鑷达紱 + - 鍏氦锛�8 鏈� 12315.37銆佺疮璁� 110776.34 鉁撱�� +- **閬楃暀**锛氣憼 鎵╁垪浜х墿琚噸鍐欑殑鍏紡鏃犵紦瀛樺�硷紙寤鸿琛�"鏁存湰閲嶇畻鍐欑紦瀛�"锛夛紱鈶� `涓彛寰勬槑缁哷 琛ㄥご琛岃瘑鍒繑鍥� `[2,4]` 寰呮牳鏌ワ紱鈶� 鈶¤〃锛堝叏鍙ｅ緞锛�9 鏈堟湭瀵煎叆鍓嶏紝"鍏ㄥ彛寰�"琛屾樉绀虹瓑浜庤涓婏紙鍏紡 =瑙勪笂+瑙勪笅銆佽涓嬩负绌猴級锛屼綋妫�宸叉彁绀猴紝瀵兼暟鎹悗鑷姩姝ｅ父銆� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎵╁垪鍏紡鍏嬮殕淇涓�9鏈堥獙璇乢2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +### 10-12锛�5锛夛細淇��9 鏈堝叕浜�/鍑虹鏈堟姤瀵间笉杩涘幓銆嶁�斺�斿鍏ユ敼鎸夎〃澶村悕瀹氫綅鍒椼�愬緟楠屾敹銆� + +- **鐜拌薄**锛氱敤鎴峰鍏� 9 鏈堝叕浜�/鍑虹鏈堟姤鍙嶅澶辫触锛沗import_batch` 鏃犺褰曘�乣city_bus_monthly`/`city_taxi_monthly` 鏃� 2026-09 琛� 鈫� **瑙ｆ瀽闃舵鍗虫姏閿�**锛堟病杩涘啓搴擄級銆� +- **鏍瑰洜锛堝疄娴嬩笁浠芥枃浠讹級**锛�9 鏈堟ā鏉挎瘮 7 鏈�**灏戝垪瀵艰嚧鏁翠綋宸︾Щ**鈥斺�斿叕浜� 68鈫�**66** 鍒楋紙灏� `缁熶竴绀句細淇＄敤浠ｇ爜`銆乣濉姤鍗曚綅`锛岀 3 鍒楄捣宸︾Щ 2锛夛紱鍑虹 41鈫�**40** 鍒楋紙灏� `濉姤鍗曚綅`锛屽乏绉� 1锛夈�傚鍏ュ櫒鍘熸槸**鎸夊浐瀹氬垪鍙峰彇鍊� + 鍥哄畾鍒椾綅鏍￠獙** 鈫� 鏍￠獙鐩存帴鎶涖�屼笌鏂囦欢鍐呭涓嶇銆嶃�傚繀闇�鍒楁寜鍚嶉兘鍦紝鏄垪浣嶄笉鍖归厤锛涗笖鍙栧�间篃鎸夊浐瀹氬垪鍙凤紝涓嶆敼浼氭暣浣撹閿欏垪銆� +- **鏀瑰姩锛堟寜 I4 鍙ｅ緞鍏煎妯℃澘宸紓锛�**锛氭柊澧� `colByName(hdr, fallback, name[, occurrence])`锛堟寜琛ㄥご鍚嶅彇鍒楋紝鏈懡涓洖閫�鍘熷浐瀹氬垪鍙凤級涓� `requireHeaderColsByName(...)`锛堝彧鏍￠獙蹇呴渶鍒楁寜鍚嶅瓨鍦ㄣ�佷笉鏍￠獙鍒椾綅锛夛紱`importCityBus`/`importCityTaxi` 鎵�鏈夊瓧娈垫敼涓烘寜鍚嶅彇鍊硷紱鍏氦閲嶅琛ㄥご銆屽叾涓細鍩庡競鍐呫�嶏紙2 娆★級鐢ㄥ嚭鐜板簭鍙峰尯鍒嗭紙`stopCity`=1銆乣passengerCity`=2锛夈�傛槧灏勫彇鑷疄娴嬭〃澶达紙鍏氦 42 瀛楁銆佸嚭绉� 37 瀛楁鍏ㄩ儴鍛戒腑锛夈�� +- **楠岃瘉**锛氬垪浣嶅樊寮傚凡瀹氫綅锛涘悕绉版槧灏勫畬澶囷紙42/42銆�37/37锛夛紱鏍￠獙鏀惧浠嶄繚鐣�"鐪熺己鍒�"鐨勮礋鍚戞嫤鎴紱缂栬瘧閫氳繃銆佸悗绔凡閲嶅惎锛圥ID 40592锛�13:17:38锛夈�� +- **寰呭姙**锛�**璇风敤鎴峰湪椤甸潰閲嶅杩欎袱涓� 9 鏈堟枃浠�**锛堝姪鎵嬩笉浠ｅ锛夛紱瀵煎叆鍚庡姪鎵嬪仛鍙鎶芥煡锛堣鏁�/甯傚窞/涓庢簮鏂囦欢閫愬垪瀵归綈锛屽挨鍏�"鍩庡競鍐�/鍩庨檯鍩庝埂"鍙ｅ緞瀛楁锛夈�� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鍏氦鍑虹瀵煎叆鎸夎〃澶村悕瀹氫綅_2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +### 10-12锛�6锛夛細淇�屽煄甯傚垎甯傚窞褰撴湀鍧楁爣棰樺仠鍦� 7 鏈堛�嶁�斺�旀爣棰樺啓鍏ヨ鍙峰樊涓�琛岀殑 bug銆愬緟楠屾敹銆� + +- **鐜拌薄**锛�9 鏈堜骇鐗╋紙8 鏈堜骇鐗╁悓鏍凤級閲� `鍩庡競鍒嗗競宸瀈 鏄剧ず"鍩庡競瀹㈣繍瀹㈣繍閲忓垎甯傚窞**7鏈�**鎯呭喌"锛屾爣棰樹笉闅忔湀浠芥洿鏂般�� +- **鏍瑰洜锛堜唬鐮佽鍙峰樊涓�琛岋級**锛氭瘝鐗堥噷褰撴湀鍧楃殑**鏍囬鍦� `A45`銆佸崟浣嶅湪 `A46`**锛堝懆杞噺鍧楁槸 `A67`/`A68`锛夛紝浣嗙▼搴忓啓鐨勬槸 0 鍩� `45`/`67` = **Excel 绗� 46/68 琛�** 鈫� 鈶� 鐪熸爣棰樿 `A45/A67` 浠庢湭鏇存柊锛堜竴鐩村仠鍦ㄦ瘝鐗堟棫鏈堜唤锛夛紱鈶� 绋嬪簭鐨勬爣棰�**瑕嗙洊浜�"鍗曚綅锛氫竾浜烘/涓囦汉娆″叕閲�"琛�**銆傜疮璁″潡 `0/22` 姝ｇ‘锛屽叾浣欓〉锛堝煄甯傛眹鎬� `0/11`銆佷腑鍙ｅ緞鍒嗘瀽 `0/9`銆侀亾璺繍杈撳懆杞噺 `0/22`銆佷袱寮犳帓鍚嶏級琛屽彿鍧囧凡鏍稿鏃犺銆� +- **鏀瑰姩**锛氣憼 浠ｇ爜 `smSetTitle(sh,45,鈥�)`鈫抈44`銆乣smSetTitle(sh,67,鈥�)`鈫抈66`锛涒憽 姣嶇増琚鐩栫殑 `A46/A68` 鐢� **XML 绮惧噯鏀规牸**鎭㈠涓�"鍗曚綅锛氫竾浜烘 / 鍗曚綅锛氫竾浜烘鍏噷"锛堝鐢ㄦ枃浠跺唴鏃㈡湁鍏变韩瀛楃涓茬储寮曪紝涓嶆暣鏈噸鍐欙級銆� +- **楠岃瘉锛堢敓鎴� 2026-09 瀹炴祴锛�**锛歚A45/A67` = `鍩庡競瀹㈣繍瀹㈣繍閲�/瀹㈣繍鍛ㄨ浆閲忓垎甯傚窞**9鏈�**鎯呭喌` 鉁擄紱`A46/A68` = `鍗曚綅锛氫竾浜烘 / 鍗曚綅锛氫竾浜烘鍏噷` 鉁擄紱绱鍧� `A1/A2/A23/A24` 姝ｅ父 鉁撱�� +- **閬楃暀锛堝緟鐢ㄦ埛纭鍚庡仛锛�**锛氣憼 `鍩庡競鍒嗗競宸瀈 S50:S66 涓� `閬撹矾杩愯緭鍛ㄨ浆閲廯 I27:I43 鍚� **17 涓� `#DIV/0!`**锛堝崰姣斿垎姣�=鍏ㄧ渷琛屽湪鏃犳暟鎹湀琚啓鎴� 0锛夆啋 寤鸿"鐢熸垚鏀跺熬缁熶竴閿欒鍊肩暀鐧� + 姣嶇増鍗犳瘮鍏紡鍔� IFERROR 鍏滃簳"锛涒憽 `涓彛寰勫垎鏋恅 9 鏈�**缃戠害杞﹁**鍊� 0/鍚屾瘮 鈭�1锛�9 鏈堢綉绾﹁溅鏁版嵁鏈锛屽睘缂烘暟锛夛紱鈶� `涓彛寰勬槑缁哷 D107/D108/F107/F108 涓虹‖缂栫爜 `0` 鍏紡锛堟瘝鐗堟棦鏈夛級锛涒懀 **鐢ㄦ埛鎻愬嚭鐨�"鏍煎紡璋冩暣"灏氭湭缁欏嚭鍏蜂綋浣嶇疆**锛屽緟鎻愪緵鍚庡悓姝ユ瘝鐗堛�� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鍩庡競鍒嗗競宸炲綋鏈堟爣棰樿鍙蜂慨姝2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� ## 鏈�鏂帮紙2026-10-12锛寊yj 绾匡級 ### 10-12锛氭墿鍒楀櫒琛ャ�屾爣棰樻寜姣嶇増鏈熸閲嶅啓銆�+ 淇 8 鏈堟瘝鐗堟爣棰樸�愬緟楠屾敹銆� -- Gitblit v1.9.1