https://bugs.documentfoundation.org/show_bug.cgi?id=170925
m_a_riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #4 from m_a_riosv <[email protected]> --- Or use a named range with a non absolute reference. - Go to A2 - Menu>Sheets>Named ranges and expressions>Define - Add a name like 'Prior' - Range: A1 - Add Instead of =E299+C400-D400 use =Prior+C400-D400 You can insert without any problems; the formula always refers to the value in the prior row. -- You are receiving this mail because: You are the assignee for the bug.
