本帖最后由 nutstore 于 2023-4-18 12:44 编辑
代码如下:
- Workbook workbook = new Workbook();
- IWorksheet sheet = workbook.getActiveSheet();
- sheet.getRange("A1").setValue(123.11);
- sheet.getRange("A2").setFormula("=A1");
- sheet.getRange("A3").setFormula("=""&IF(TRIM(A1)="","",IF(A1=0,"",""&IF(A1<0,"负","")&IF(INT(A1),TEXT(INT(ABS(A1)),"[dbnum2]")&"圆",)&IF(INT(ABS(A1)*10)-INT(ABS(A1))*10,TEXT(INT(ABS(A1)*10)-INT(ABS(A1))*10,"[dbnum2]")&"角",IF(INT(ABS(A1))=ABS(A1),,IF(ABS(A1)<0.1,,"零")))&IF(ROUND(ABS(A1)*100-INT(ABS(A1)*10)*10,),TEXT(ROUND(ABS(A1)*100-INT(ABS(A1)*10)*10,),"[dbnum2]")&"分","整")))");
- sheet.getRange("A4").setFormula("=TEXT(INT(ABS(123.00)),"[dbnum2]")");
- workbook.calculate();
- System.out.println(sheet.getRange("A1").getValue());
- System.out.println(sheet.getRange("A2").getValue());
- System.out.println(sheet.getRange("A3").getValue());
- System.out.println(sheet.getRange("A4").getValue());
- System.out.println(sheet.getRange("A4").toJson());
复制代码
直接在本地跑测试, 输出没有问题, 如图
但是我放在docker里, 基于jetty提供web服务, 转换就有问题了
代码是一模一样的
|
|