Hi ,
We are using Oracle 19.
We are importing Excel Files which has formulas in them.
for ex "=A1+B1",
"=M13+SUM(M15:M18)",
"=(AA12/AB12) + AC12" ..etc
While saving in the DB we need to process and change the formula a bit because of front-end requirement.
The formulas should shift 1 row and 1 column. ie
"=A1+B1" -----> "=B2+C2"
"=M13+SUM(M15:M18)" ----> "=N14+SUM(N16:N19)"
"=(AA12/AB13) + AC14" ----> "=(AB13/AC14) + AD15"
How do I transform these?
Please suggest.
Thanks,
Veerendra.