Fortunately, $[officename] does this work for you. After having inserted a new column A, the formula =SUM(A1:B2) will be automatically updated to =SUM(B1:C2). Row numbers will also be automatically adjusted when a new row 1 is inserted. Absolute and relative references are always adjusted in $[officename] Calc whenever the referenced area is moved. But be careful if you are copying a formula since in that case only the relative references will be adjusted, not the absolute references. Absolute references are used when a calculation refers to one specific cell in your sheet.
幸运的是，$[officename] 会替您完成此任务。插入新列 A 后，公式 =SUM(A1:B2) 将自动更新为 =SUM(B1:C2)。插入新行 1 时，行号也会自动调整。只要移动了引用区域，$[officename] Calc 中的绝对引用和相对引用就会进行相应的调整。但是请注意，复制公式时只调整相对引用，而不会调整绝对引用。