Excel changing ROW to @ROW

[MarianiVentura]

Good day.

I am wondering if anyone else is having the issue where Excel changes my ROW calculations to @Row?

Consider the following code. I am importing a csv, then creating the formula with ROW, but the final Excel changes this to @Row.

I have manually do a search/replace in Excel to fix these or else the formula doesn't work.

Any ideas?

Thanks.

 
    $excel = Import-Csv $outputFile -Delimiter ^ | Export-Excel $excelFile -Title $title -WorksheetName 'SalesOrders' -AutoSize -AutoNameRange -TableName SO -FreezePane 3 -Passthru

    $formula = "AVERAGE(IF(SUBTOTAL(9,OFFSET(`$J`$3:`$J`$$Frow,ROW(`$J`$3:`$J`$$Frow)-MIN(ROW(`$J`$3:`$J`$$Frow)),,1))>0,`$J`$3:`$J`$$Frow))"
    # Set the Excel range with the formula
    Set-ExcelRange -Range $sheet.Cells["J1"] -Formula $formula -BackgroundColor yellow
    

[dfinke]

@MarianiVentura have not seen that before. Please could you post some scrubbed csv data.

[MarianiVentura]

SalesOrdersSummaryStory1342_20240112_FINKE.xlsx

Attached is example file with just a few rows and customer names removed. If you look at L1, you can see how it changed.

Thank you!

Here is the Powershell code:
$formula = "AVERAGE(IF(SUBTOTAL(9,OFFSET($L$3:$L$$Frow,ROW($L$3:$L$$Frow)-MIN(ROW($L$3:$L$$Frow)),,1))>0,$L$3:$L$$Frow))"