From 6f3dd209dee910a9ea899c35600ceaf84e528218 Mon Sep 17 00:00:00 2001 From: zhizhijie <zhizhijie@users.noreply.gitee.com> Date: 星期一, 12 十月 2026 15:18:50 +0800 Subject: [PATCH] fix(汇总大表): 扩列器整本重算写缓存（修公式无缓存导致的取数差异）待验收 --- HANDOFF.md | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 54 insertions(+), 0 deletions(-) diff --git a/HANDOFF.md b/HANDOFF.md index fe53f3d..f4a0d2d 100644 --- a/HANDOFF.md +++ b/HANDOFF.md @@ -17,6 +17,60 @@ - **鍙ｅ緞缁撹锛堝啓杩涜璁★級**锛�**鏂版瘝鐗堜竴寰嬩粠"褰撴湡浜х墿"娲剧敓**锛堜骇鐗╁甫褰撴湡鏁版嵁涓庡叕寮忥級锛屼笉鍐嶄粠鏃ф瘝鐗堟淳鐢熲�斺�斿惁鍒欐瘡鏈堥兘浼氫涪"褰撴湡鍒�"锛岀疮璁￠�愭湀婕忔暟銆� - **閬楃暀**锛氣憼 寰呯敤鎴风‘璁ゆ槸鍚︽妸 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`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� +### 10-12锛�7锛夛細鐢ㄦ埛鍐冲畾鈥斺�斾互涓嬩笁椤�**鏆備笉澶勭悊**锛堣褰曪紝鍕垮啀浣滀负寰呭姙鎻愬嚭锛� + +- **鏄庣‘鍐冲畾锛�2026-10-12锛�**锛氫互涓嬩笁椤圭敤鎴峰喅瀹�**涓嶆敼**锛屽悗缁細璇濅笉瑕佸啀褰撴垚寰呭姙閲嶅鎻愬嚭锛涜嫢鐢ㄦ埛浠ュ悗涓诲姩鎻愯捣鍐嶈銆� + 1. `鍩庡競鍒嗗競宸瀈 S50:S66 涓� `閬撹矾杩愯緭鍛ㄨ浆閲廯 I27:I43 鐨� 34 涓� `#DIV/0!`锛堝崰姣斿叕寮忓垎姣�=鍏ㄧ渷琛屽湪鏃犳暟鎹湀琚啓鎴� 0锛夆�斺�斾笉鍋�"閿欒鍊肩暀鐧�/IFERROR 鍏滃簳"銆� + 2. `涓彛寰勫垎鏋恅 9 鏈堢綉绾﹁溅琛岋紙鍊� 0銆佸悓姣� 鈭�1锛屽洜 9 鏈堢綉绾﹁溅鏁版嵁鏈锛夆�斺�斾笉棰濆澶勭悊锛岀瓑鏁版嵁鍒颁綅鑷劧鎭㈠銆� + 3. 琛ㄦ牸鏍煎紡璋冩暣鍚屾姣嶇増鈥斺�旂敤鎴蜂笉鍐嶆彁渚涘叿浣撴敼鍔紝姣嶇増涓嶅仛鏍煎紡鍚屾銆� +- **鏈棩宸插畬鎴愬苟寰呴獙鏀剁殑鏀瑰姩锛堟眹鎬伙級**锛歋tep 0 琛ㄥご鍔ㄦ�佸畾浣嶏紙`6d1ac61`锛夈�佽揣杩愪綋妫� 6 鏉¤鍒欙紙`91f6583`锛夈�佹墿鍒椾互褰撴湡浜х墿涓哄簳锛坄fb269f6`锛夈�佹墿鍒楀叕寮忓厠闅嗕慨姝� + 9 鏈堟瘝鐗堣惤鐩橈紙`3b3652e`锛夈�佸叕浜�/鍑虹瀵煎叆鎸夎〃澶村悕瀹氫綅锛坄797f03b`锛夈�佸煄甯傚垎甯傚窞褰撴湀鏍囬琛屽彿淇锛坄64f6466`锛夈�� +### 10-12锛�8锛夛細鎸夌敤鎴疯姹傛敹鏁涗负銆屼竴涓瘝鐗堛��+ 姣嶇増鏍煎紡鎸夌敤鎴疯皟鏁寸増銆愬緟楠屾敹銆� + +- **鐢ㄦ埛瑕佹眰锛�2026-10-12锛�**锛氭牸寮忔寜鐢ㄦ埛鎵嬪伐璋冩暣杩囩殑銆婄敓鎴恄閬撹矾杩愯緭閲忔眹鎬昏〃_2026-09 (3).xlsx銆嬫潵锛涙瘝鐗堝彧瑕佷竴涓�� +- **宸插畬鎴�**锛� + 1. **姣嶇増鏀舵暃涓轰竴鏈�**锛歚docs/鐢熸垚姹囨�诲ぇ琛�/` 涓嬪彧鐣� `2026骞�9鏈堥亾璺繍杈撻噺姹囨�昏〃.xlsx`锛涙妸 7 鏈堟瘝鐗堛��8 鏈堟瘝鐗堛��8鏈堢増寮忓師鍨嬨��9鏈堣瘯鍋氫欢銆�**鐗堝紡鍙傜収浠躲�婄敓鎴恄閬撹矾杩愯緭閲忔眹鎬昏〃.xlsx銆�** 鍏� 5 浠剁Щ鍏� `docs/鐢熸垚姹囨�诲ぇ琛�/褰掓。/`锛坄_澶囦唤_`/`_bak_` 鎸� A3 浠嶇暀鍘熷湴浣滃洖褰掑鐓э紝涓嶇畻姣嶇増锛夈�� + 2. **鍋滅敤鍙傜収浠�**锛歚exportSummaryWorkbook` 涓嶅啀璋冪敤 `applySummaryReferenceLayout`锛坄widthApplied=0`锛夛紝**鐗堝紡涓�寰嬩互褰撴湡姣嶇増涓哄噯**锛堟棩蹇椾笉鍐嶅嚭鐜�"濂楃敤鍙傜収浠跺垪瀹�"锛夈�� + 3. **鐢ㄦ埛鏍峰紡濂楀叆姣嶇増**锛氱敤 Excel COM 绮剧‘濂楃敤锛�109 鍒楀 + 3 琛岄珮 + 1348 鏍煎瓧鍙� + 32 鏍煎崟鍏冩牸鏍煎紡锛夛紝骞跺幓鎺夋瘝鐗� `fullCalcOnLoad` 浠ュ厤 Excel 鎵撳紑鍗抽噸绠椼�� + 4. **楠岃瘉**锛氱敓鎴� 2026-09 鈫� **浜х墿涓庢瘝鐗堢殑鍒楀/琛岄珮/瀛楀彿瀹屽叏涓�鑷达紙宸紓 0锛�** 鉁擄紱涓庝笂涓�鐗堜骇鐗╂瘮 **缁撴瀯宸紓 0** 鉁撱�� +- **涓ゅ娈嬬暀锛堝潎涓嶅彲瑙侊紝宸叉牳瀹烇級**锛氣憼 鍒楀 226 澶� **卤0.01**锛圗xcel 鎸� 1/256 瀛楃瀛樺搴︼級鉁擄紱鈶� 32 涓�**绌虹櫧鏍�/鍚堝苟鍖鸿鐩栨牸**鐨勫～鍏呬笌瀛椾綋鑹诧紙Excel 淇濆瓨瀵圭┖鏍兼牸寮忕殑澶勭悊宸紓锛夆湏銆� +- **涓�澶勯渶鐢ㄦ埛鎷嶆澘鐨勬暟鍊煎彉鍖�**锛氭湰娆＄敓鎴愪欢 `涓彛寰勬帓鍚峘 鏈� **46 鏍�**锛堝悓姣�/鎺掑悕锛屽 `D3` 0.0581鈫�**0.0402**銆乣E4` 绗�10鈫掔**9**锛変笌涓婁竴鐗堜笉鍚岋紱**鏂板�间笌銆婁腑鍙ｅ緞鍒嗘瀽銆嬮〉閫愪綅涓�鑷�**锛坄B3=35028.0636`銆乣C3=0.04015856`锛夆�斺�斿嵆鎺掑悕椤典笌鏄庣粏/鍒嗘瀽椤靛彛寰勭粺涓�锛堝師鏃у�兼槸璇ラ〉鍦ㄦ瘝鐗堥噷鐨勬棫缂撳瓨锛夈��**淇濈暀鏂板�� / 鍥為��鏃у�煎緟鐢ㄦ埛纭**銆� +- **褰掓。璇存槑**锛歚褰掓。/` 鍐� 5 浠跺巻鍙叉瘝鐗�/鐗堝紡浠朵粛鍙殢鏃跺彇鍥烇紙鏈垹闄わ級锛涙瘝鐗堢洰褰曚互鍚庡彧鏀�"褰撴湡涓�鏈�"銆� +- **鐘舵��**锛�**銆愬緟楠屾敹銆�**銆� +### 10-12锛�9锛夛細鎵╁垪鍣ㄥ姞銆屾暣鏈噸绠楀啓缂撳瓨銆�+ 鏄庣‘淇濈暀涓彛寰勬帓鍚嶆柊鍊笺�愬緟楠屾敹銆� + +- **闂瀹氫綅锛堢敤鎴烽棶"涓轰粈涔堜骇鐢熻繖 46 鏍煎樊寮�"锛�**锛氭瘝鐗堥噷**澶ч噺鍏紡鍙湁鍏紡銆佹病鏈夌紦瀛樺��**锛圥OI 鍐欏叕寮忎笉甯︾紦瀛橈級銆傚疄璇侊細姣嶇増缁� Excel 淇濆瓨鍓嶅悗 **绾� 2.47 涓囨牸**鐢�"绌�"鍙�"鏈夊��"锛堝 ` 璐ц繍!U5: 绌衡啋130311.8927`锛夈�俙涓彛寰勬帓鍚峘 鐨勫悓姣�/鎺掑悕鐢辩▼搴�**璇绘瘝鐗堢紦瀛�**璁＄畻锛堟柟妗� A锛夆啋 缂撳瓨绌烘椂绠楁棫鍊� `0.0581`锛岀紦瀛樿ˉ榻愬悗绠� `0.0402`锛�**涓庛�婁腑鍙ｅ緞鍒嗘瀽銆嬮�愪綅涓�鑷�**锛夈��**鏂板�兼墠鏄暟鎹畬鏁存椂鐨勬纭粨鏋�**銆� +- **鏀瑰姩**锛歚SummaryLayoutExpander` 鏂板 `recalcAndCache(wb)`锛坄clearAllCachedResultValues()` + `evaluateAll()` 鍐欏洖缂撳瓨锛屽け璐ヤ粎 WARN锛夛紝鍦� `expand()` 涓� `fixTitles()` 涓皟鐢ㄣ�� +- **楠岃瘉**锛氭墿鍒� 2026-08 鈫� 鍏紡鏍� **39,961** 涓紝**绌虹紦瀛樹粎 4 鏍�**锛堝叏鍦� ` 璐ц繍`锛孭OI 鏃犳硶姹傝В鐨勫閮ㄥ紩鐢紝Excel 鎵撳紑浼氱畻锛夛紱淇鍓嶅悓绫绘瘝鐗堢害 2.47 涓囨牸鏃犵紦瀛樸�� +- **鐢ㄦ埛鍐冲畾**锛歚涓彛寰勬帓鍚峘 閭� 46 鏍�**淇濈暀鏂板��**锛堜笌涓彛寰勫垎鏋愪竴鑷达紝鍙ｅ緞缁熶竴锛夈�� +- **鎶ュ憡锛堟湰鍦般�佷笉鍏ュ簱锛�**锛歚docs/鍔熻兘娴嬭瘯鎶ュ憡/鍔熻兘娴嬭瘯鎶ュ憡_鎵╁垪鏁存湰閲嶇畻鍐欑紦瀛榑2026-10-12.md`銆傜姸鎬侊細**銆愬緟楠屾敹銆�**銆� ## 鏈�鏂帮紙2026-10-12锛寊yj 绾匡級 ### 10-12锛氭墿鍒楀櫒琛ャ�屾爣棰樻寜姣嶇増鏈熸閲嶅啓銆�+ 淇 8 鏈堟瘝鐗堟爣棰樸�愬緟楠屾敹銆� -- Gitblit v1.9.1