Java 合并多个 Excel ,合并后公式失效不可用

[bingfeng_09]

<dependency>
<groupId> e-iceblue </groupId>
<artifactId>spire.xls</artifactId>
<version>12.7.0</version>
</dependency>
List<String> allFile1 = POIUtils2.getAllFile(new File(tempDir));
assert allFile1 != null;
for (String file1 : allFile1) {
tempBook.loadFromFile(file1);
for (Object sheet : tempBook.getWorksheets()) {
Worksheet sheet1= (Worksheet) sheet;
newBook.getWorksheets().addCopy(sheet1, WorksheetCopyType.CopyAll);
}
}
newBook.saveToFile(targetPath, ExcelVersion.Version2016);

[Simple.Li]

Hello,

感谢您的询问。
为了我们准确地调查你的问题，请向我们提供以下信息。提前感谢。
1.您未合并的文档，以及合并的结果文档。
2.您的测试系统环境(E.g.win10,x64)。
您可以在这里附上或通过电子邮件发送(support@e-iceblue.com)。

Sincerely
Simple
E-iceblue support team

[Simple.Li]

Hello,

Could you please let us know how is your issue going? Thanks in advance for your feedback and time.

Sincerely,
Simple
E-iceblue support team