Problem inserting row into a sheet with formulas using ranges of type "A$1"

Posted by: ffrey on 5 June 2020, 4:50 am EST

  • Posted 5 June 2020, 4:50 am EST

    Hi,
    Given I have a worksheet that contains a cell with a fomula like this:
    =SUM(B3:B$8)
    which defines a sum to a range that ends in a "relative column, absolute row" cell reference.
    When I add a new row on top, let's say in row A, the formula is incorrectly updated to the following value:
    =SUM(B4:R0C)



    Not sure what is that R0C, is that a bug?

    It also happens if you use "absolute column, relative row" cell reference (Sample5 in attachment).
    I am providing a sample project that I was using for testing as an attachment.
    I'm using Documents for Excel (.net) v3.0.1.

    TestUpdateFormulas.zip

    Thanks,
    Fernando
  • Replied 8 June 2020, 6:54 pm EST

    Hi Fernando,

    We too can observe the issue at our end, thus escalated the issue to the developers and will let you know once we get any update on this from the devs end.

    Regards,
    Prabhat Sharma.
  • Marked as Answer

    Replied 28 June 2020, 4:57 pm EST

    Hello,

    This issue has been fixed in 3.1.5 builds, please update the builds to get the correct formula after adding a range.

    Regards,
    Prabhat Sharma.
  • Replied 29 June 2020, 3:38 am EST

    Super! Works well now, thanks!
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels