search

qax-os / excelize

Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
https://xuri.me/excelize
BSD 3-Clause "New" or "Revised" License
17.62k stars 1.68k forks source link

Trigger formulas automatic calculation (excel中公式不自动计算需要打开excel点击后才能出值) #1893

Closed dannyzdy closed 1 month ago

dannyzdy commented 1 month ago

Description excel中公式不自动计算需要点击后才能出值

Steps to reproduce the issue: 1.原excel中C列=A列+B列 2.使用程序往A列和B列赋值 3.打开excel C列公式无效

Describe the results you received:

Describe the results you expected:

**Output of go version: 1.20

(paste your output here)

Excelize version or commit ID:

(paste here)

Environment details (OS, Microsoft Excel™ version, physical, etc.):

xuri commented 1 month ago

Thanks for your issue. If you are reporting a new issue, make sure that we do not have any duplicates already exist. This was duplicated with issues #634, #1195, #1322, #1793 and #1841 use the UpdateLinkedValue to clean up the cell calculation cache value before saving the spreadsheet. I've closed this issue. If you have any questions, please let me know, and you can reopen this anytime.