Robotic Process Automation

  • 1.  Excel formulas

    Posted 27 days ago
    Hello everyone,

    I have a problem with writing formulas in excel column by using "Set value in Excel".

    When usual formulas are used it is ok (=F1+F2) but

    when I try to count elements from other sheet by formula in cell error appears and excel file broke itself.

     

    Formula is:

    =countifs(Sheet1!B:B;Sheet2!B${idx};Sheet1!G:G;Sheet2!A${idx})

    When I try to open the excel file after execution error is shown and the formulas does not seem to appear in the cells.

    They calculate values but cells are not wanted formulas only values.

    This is how the worksheet looks like after the manipulation:




    This only happens with more complex formulas, not the regular ones.

    Regards,



    ------------------------------
    Stefan Stefanov
    ------------------------------


  • 2.  RE: Excel formulas

    Posted 8 days ago
    do you have a ready-to-run script that reproduces the issue you can share?

    ------------------------------
    Joba Diniz
    Product Manager
    IBM
    ------------------------------



  • 3.  RE: Excel formulas

    Posted 7 days ago
    Hello Joba,

    This issue has been addressed to IBM and an example script has been also sent.

    Regards,

    ------------------------------
    Stefan Stefanov
    ------------------------------