公式

定义 LibreOfficeDev Calc 的公式语法选项。

要访问此命令...

Open a spreadsheet document, choose - LibreOfficeDev Calc - Formula.


公式选项

公式语法

有三种选项,下面分别举例。示例电子表格中有两个工作表:Sheet1 与 Sheet2。在 Sheet1 的 A1 单元格中引用了 Sheet2 的 C4 单元格。

使用英文函数名称

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}

Detailed Calculation Settings

Sets the rules for conversion from strings values to numeric values, string values to cell references, and strings values to date and time values. This affects built-in functions such as INDIRECT that takes a reference as a string value or date and time functions that takes arguments as string values in local or ISO 8601 formats.

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:

提示图标

LibreOfficeDev saved ODF spreadsheets will honor Never recalculate and Always recalculate options.