Landray RDM 62545

Aspose.Cells Product Family
1

the fomula is not correct!
src.zip (1.6 KB)
18年09月考勤报批.xls.zip (275.4 KB)
C4E27ABC3277602ECC04A1FDFA56C187.jpg (288.9 KB)

2

@hucq_landray_com_cn,

Could you please explain the problem little more. Share with us the name of output file and highlight the issue by drawing a rectangle on screenshot. We will provide our feedback after analysis.

3

could you run it with our code?and see the differrence between source file and html file

the formula result is not correct,all the result is zero.

4

@hucq_landray_com_cn,

We have tried your code as it is and generated the output HTML files using latest version Aspose.Cells for Java 18.10.x. No issue is observed and all the totals seem fine. Please review the attached HTML files and identify the issue if any.
OutputFiles.zip (255.2 KB)

5

but why we reproduce it?we used aspose-cells-18.11.jar
converteffect.png (391.2 KB)

6

@hucq_landray_com_cn,

Please try our latest version/fix: Aspose.Cells for Java v18.11.4 (attached)

Let us know your feedback.
Aspose.Cells for Java_v18.11.4.zip (6.3 MB)

If the issue persists then also share your JDK/OS details.