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

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

Posted by: ffrey on 5 June 2020, 1:50 pm EST

• 

  ffrey

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 June 2020, 1:50 pm EST - Updated 29 September 2022, 3:38 pm 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)

  

  628×796 27.1 KB

  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

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 9 June 2020, 3:54 am 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.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 29 June 2020, 1:57 am 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.

• 

  ffrey

  • Post Options:
  • Link
    Copy

  Posted 29 June 2020, 12:38 pm EST

  Super! Works well now, thanks!