79227286

Date: 2024-11-26 15:22:59
Score: 0.5
Natty:
Report link

Thanks @jkpieterse, I solved this problem creating a 'temp' column and copying&pasting the text:

table1.addColumn(-1, null, "temp");
let col = table1.getColumnByName("temp");
let act = table1.getColumnByName("Total");
col.getRangeBetweenHeaderAndTotal().setFormula("=VALUE([@[Total]])")
act.getRangeBetweenHeaderAndTotal().getRow(0).copyFrom( table1.getColumn("temp").getRangeBetweenHeaderAndTotal(), ExcelScript.RangeCopyType.values, false, false);

I hope this can help another else...

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Whitelisted phrase (-2): I solved
  • Whitelisted phrase (-1): hope this can help
  • Has code block (-0.5):
  • User mentioned (1): @jkpieterse
  • Self-answer (0.5):
  • Looks like a comment (1):
  • Low reputation (1):
Posted by: Facundooz