【5.1.5】GcExcel金额大小写转换是否存在环境变量影响

收藏

本帖最后由 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());