公式
定义 LibreOfficeDev Calc 的公式语法选项。
公式选项
公式语法
有三种选项,下面分别举例。示例电子表格中有两个工作表:Sheet1 与 Sheet2。在 Sheet1 的 A1 单元格中引用了 Sheet2 的 C4 单元格。
-
Calc A1 - 这是 LibreOfficeDev Calc 的默认风格。该引用应为 =$Sheet2.C4
-
Excel A1 - 这是 Microsoft Excel 的默认风格。该引用应为 =Sheet2!C4
-
Excel R1C1 - 这是 Microsoft Excel 中的相对行/列地址。该引用应为 =Sheet2!R[3]C[2]
使用英文函数名称
LibreOfficeDev Calc 中的函数名称可以是译文。本复选框默认不旋中,即显示本地化的函数名。选中本复选框可切换为英文函数名称。该变化会发生在下述位置:公式输入及显示,函数向导及公式提示。当然您可以取消选中本项,恢复本地化函数名称的显示。
分隔符
本选项组允许您配置公式表达式当中的分隔符。例如当您希望以逗号 (,) 而非分号 (;) 分隔函数参数时,本功能会非常方便。
例如您可以输入 =SUM(A1,B1,C1),而不必输入 =SUM(A1;B1;C1)。
类似地,您还可以更改行内数组的列与行分隔符。往常行内数组使用分号 (;) 作为列分隔符,竖线 (|) 作为行分隔符,因此典型的 5×2 行内数组表达式可以这样写:
={1;2;3;4;5|6;7;8;9;10}
将列分隔符更改为逗号 (,),行分隔符更改为分号 (;),同样的表达式就会变成这样:
={1,2,3,4,5;6,7,8,9,10}
Recalculation on File Load
Recalculating formulas can take significant time while loading very large files.
Excel 2007 and newer:
Loading a large spreadsheet file can take a long time. If you don't need to update your large spreadsheet data immediately, you can postpone the recalculation at a better time. LibreOfficeDev allows you to defer recalculation of Excel 2007 (and above) spreadsheets to speedup loading time.
ODF Spreadsheet (not saved by LibreOfficeDev):
Recent versions of LibreOfficeDev caches spreadsheet formula results into its ODF file. This feature helps LibreOfficeDev to recalculate a large ODF spreadsheet saved by LibreOfficeDev faster.
For ODF spreadsheets saved by other programs, where such cached formula results may not exist, recalculation can be deferred to speedup file loading as with Excel 2007 files.
For the entries above the following choices are possible:
-
Never recalculate - No formulas will be recalculated on loading the file.
-
Always recalculate - All formulas will be recalculated on file load.
-
Prompt user - Prompt user for action.
LibreOfficeDev saved ODF spreadsheets will honor Never recalculate and Always recalculate options.