cells source code:
src.zip (1.6 KB)
origin cells:
大兴实业B1、B2抹灰及砌筑工程量.xls.zip (38.5 KB)
before converted:
image.png (369.1 KB)
after converted:
image.png (457.1 KB)
Please have a check.
cells source code:
src.zip (1.6 KB)
origin cells:
大兴实业B1、B2抹灰及砌筑工程量.xls.zip (38.5 KB)
before converted:
image.png (369.1 KB)
after converted:
image.png (457.1 KB)
Please have a check.
@hucq_landray_com_cn
By using sample files and code for testing in the latest version v24.2, we can obtain the correct results. Please refer to the attachment. result.zip (73.8 KB)
@hucq_landray_com_cn
After calculating formulas, we got same result as yours.
Did you call Workbook.calculateFormula() though there is no call in sample codes?