Formula altered when Rows are Added

Formula altered when Rows are Added

Posted by: peter.herschel on 10 May 2019, 2:02 am EST

• 

  peter.herschel

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 May 2019, 2:02 am EST

  I just upgraded to version 12 from version 11. I came across a possible bug in version 12 that works fine in version 11.

  If you have a 10 x 10 sheet and place a formula on row 10 that uses an absolute cell reference. When you add a row, the absolute reference is modified.

  Note: the absolute reference refers to a row that hasn’t been created yet.

  Example:
  
  Sheet is 10x10 (rows x columns)
  
  Formula on row 10 is B10/$B$20 (any cell on row 10)
  
  Add a row to the sheet now 11 x 10
  
  Formula on row 10 changes B11/$B$21 (should be org one)

  The formula should not have changed at all. The new row was appended. This worked fine on Spread 11.

  -Pete

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 14 May 2019, 3:07 pm EST

  Hello,

  Unfortunately, we are unable to replicate the issue at our end using Spread version 12.
  
  Please have a look at attached video and let us know what are we missing to replicate the issue.

  Thanks,
  
  ReevaAddRow_V12.zip