If, for example you click the formula =SUM(A1:C5; D15:D24) in a cell, the two referenced areas in the sheet will be highlighted in colour. For example, the formula component &quot; A1:C5 &quot; may be in blue and the cell range in question bordered in the same shade of blue. The next formula component &quot; D15:D24 &quot; can be marked in red in the same way. When to Use Relative and Absolute References What distinguishes a relative reference?
$[officename] Calc 还能够突出显示对公式中数据的引用。比如按击单元格中的公式：=SUM(A1:C5;D15:D24)后，工作表中这两个被引用的区域就会用颜色突出显示。公式中的 &quot; A1:C5 &quot; 显示为蓝色，工作表中的这个区域也以蓝色框表示；公式中的 &quot; D15:D24 &quot; 显示为红色，相应地工作表中的这个区域则以红色框表示。