I have to post a concatenated result of a Min and Max calculation in one cell as follows:
formula = “MIN(A1:A5) & “” | “” & MAX(A1:A5)”
Cells(“A2”).Formula = Formula
But I get an invalid formula error. I do not need to have it refreshed by using the Aspose Refresh funciton, but do need it when the user opens the spreadsheet with Excel.
Please try this attached fix. And please chang your code to:
formula = "=MIN(A1:A5) & "" | "" & MAX(A1:A5)"