Formula error

MarkJoseph.Canada
edited May 7 in Eikon COM

can you please check if you can assist?

“Basically, I have a formula RDP.Search("COMPANY", $B$8, "NBROWS:500 SORT:DTSubjectName:A", , ) which returns a sample

5073619959

5073620114

5073620117

5073619966

5074009689

5051175432

5084167849After I copy it and paste it back as values, I get 5073619959. all values after the first one are erased. I am unable to attach the file though. I can share it via email. This was already sent to FMC but was advised to check with dev team. Thanks!

Thanks!

Answers

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @MarkJoseph.Canada

    Thank you for reaching out to us.

    It is about the Excel formula (RDP.Search) so please contact the LSEG Workspace Excel dev or support team, not the developer forum.

    image.png

    The first line contains the RDP.Search formula. If the formula has been deleted and replaced, all values are gone.

    You may use the following formula to display data in other cells (H1).

    =RDP.Search("COMPANY", $B$8, "NBROWS:500 SORT:DTSubjectName:A", , H1)