Hi Everyone

I am having some issues when using getCalculatedValue. Some cells work okay in retrieving the value, but some other simply copies the formula.
Here's what I am trying to do
I want to copy the values in sheet "kirim SAP" (hidden sheet), to a separate new file. So formula containing sheet references need to be calculated before set in the new file.
Here's the source file.
https://docs.google.com/spreadsheets/d/1ShijpIDOXZhSNeUqaOh61WvRT2r7VZC5/edit?usp=sharing&ouid=109095039939818888420&rtpof=true&sd=true

Here's the output on the new file. Please mind that I expect new rows in this file for each trigger.
https://docs.google.com/spreadsheets/d/1ObN4Fnso6zigIjan1XXRV-zYC-CQFKyo/edit?usp=sharing&ouid=109095039939818888420&rtpof=true&sd=true

is there something i need to do to make it work? I checked the doc for supported formulas https://phpspreadsheet.readthedocs.io/en/latest/references/function-list-by-name/, but all that we used seem to be supported

Here's a snippet of my code to achieve this.

$lastColumn='A';
        $row=1;
        $spreadsheet->setActiveSheetIndex($spreadsheet->getSheetCount()-1);
        $sheet = $spreadsheet->getActiveSheet();
        $highestColumn = $sheet->getHighestColumn();
        $highestRow = $sheet->getHighestRow();

        $arr=array();
        try{
            for($row=1;$row<=$highestRow;$row++){
                for($lastColumn='A';$lastColumn!=$highestColumn;$lastColumn++){
                    $arr[$lastColumn.$row]=$sheet->getCell($lastColumn.$row)->getCalculatedValue();
                }
            }

            $stInsertData = $connection->prepare("insert into asmt_report_result values(DEFAULT, :template, :participant, :fields);");
            $successInsertData=$stInsertData->execute(array(':template'=>$_GET['template'], ':participant'=>$_GET['participant'],':fields'=>json_encode($arr)));

        }catch(Exception $e){
            throw $e;
        }

        $sheet->setSheetState(Spreadsheet::VISIBILITY_HIDDEN);
                $randomName=date("Ymd");
        if(empty($arr['A2'])||$arr['A2']==0){
            $randomName="candidate_".date("Ymd");
        }else{
            $randomName="internal_".date("Ymd");
        }

        $spreadsheet2 = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

        if(file_exists("../my_tmp/scpuserhris/".$randomName.".xlsx")){
            //echo "file exists";
            $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
            $spreadsheet2 = $reader->load("../my_tmp/scpuserhris/".$randomName.".xlsx");
        }else{
            //echo "file not exist";
        }




        $sheet2 = $spreadsheet2->getActiveSheet();


        $highestRow = $sheet2->getHighestRow();

        $highestRow+=1;
        for($lastColumn='A';$lastColumn!=$highestColumn;$lastColumn++){
            $sheet2->setCellValue($lastColumn.$highestRow, $lastColumn=='A'&&empty($arr[$lastColumn.'2'])?'0':$arr[$lastColumn.'2']);
            //echo $lastColumn.$highestRow."=".$arr[$lastColumn.'2']."<br/>";
        }

        $writer2 = new Xlsx($spreadsheet2);

        $filePath2 = "../my_tmp/scpuserhris/".$randomName.".xlsx";
        $writer2->save($filePath2);