javascript - javascript Google Sheet 显示值的问题

Question

嗨，我创建了在下一页上提供带有一些值的数据透视表的脚本，下面显示了所有汇总值的总和。我的问题是，在 5 张工作表中它工作正常，在最后一张中，值计算正确，但在工作表中显示的值完全不同。

pivotGroup = pivotTable.addRowGroup(1);

var lastRow = spreadsheet.getLastRow();
let dayShift_P = spreadsheet.getSheetValues(lastRow,3,1,1);
let nightShift_P = spreadsheet.getSheetValues(lastRow,5,1,1);
let waitingOnsite_P = spreadsheet.getSheetValues(lastRow,7,1,1);
let waitingHotel_P = spreadsheet.getSheetValues(lastRow,9,1,1);
let travel_P = spreadsheet.getSheetValues(lastRow,11,1,1);
let training_P = spreadsheet.getSheetValues(lastRow,13,1,1);

let dayShift_H = spreadsheet.getSheetValues(lastRow,2,1,1);
let nightShift_H = spreadsheet.getSheetValues(lastRow,4,1,1);

let payment_sum = Number(dayShift_P) + Number(nightShift_P) + 
Number(waitingOnsite_P) + Number(waitingHotel_P) + Number(travel_P) + 
Number(training_P); //Calculate correct

spreadsheet.getRange(`B${newval}`).activate();
spreadsheet.getCurrentCell().setValue(`${payment_sum}`); //display incorrect
spreadsheet.getActiveRangeList().setNumberFormat('[$€]#,##0.00');
spreadsheet.getActiveRangeList().setNumberFormat('0.00');

也许有人知道为什么会发生这种情况以及如何解决？

标签： javascriptexcelnumberssetvalue