Robotic Process Automation (RPA)

Robotic Process Automation (RPA)

Come for answers. Stay for best practices. All we’re missing is you.

 View Only

  • 1.  Excel formulas

    Posted Fri November 05, 2021 09:24 AM
    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 Wed November 24, 2021 03:02 PM
    do you have a ready-to-run script that reproduces the issue you can share?

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

    Original Message


  • 3.  RE: Excel formulas

    Posted Thu November 25, 2021 07:12 AM
    Hello Joba,

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

    Regards,

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

    Original Message