Let's say I have a range of data A1:K20, and the formula for cell D5 is "=10+B30". If I sort that data so that row 5 becomes row 3, the formula for D3 should remain "=10+B30". It should remain this way because B30 is outside of the sorted range. This is how Excel and Google Sheets behave.

In Zoho sheets, the formula for D3 changes to "=10+B28". It's acting as if I deleted two rows. This breaks the entire spreadsheet unless absolute references (such as "=10+$B$30") are used.