summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKohei Yoshida <kyoshida@novell.com>2010-09-15 21:29:01 +0200
committerFridrich Štrba <fridrich.strba@bluewin.ch>2010-09-15 21:29:01 +0200
commit46cacfedc577ba683a760f0788ff891942cfd74d (patch)
treefde4856d128a75aac0f22371f2c6d93ca841a298
parentd1cc491ffc0d01eb7a4e82f65bda7be68a05f26e (diff)
calc-formula-variable-separators-officecfg.diff: formula separators changeable
n#447164, i#92056 Make the formula separators changeable per locale setting, and add new configuration page for formula syntax and separators.
-rw-r--r--officecfg/registry/schema/org/openoffice/Office/Calc.xcs83
1 files changed, 83 insertions, 0 deletions
diff --git a/officecfg/registry/schema/org/openoffice/Office/Calc.xcs b/officecfg/registry/schema/org/openoffice/Office/Calc.xcs
index 913902731f..2db99d2580 100644
--- a/officecfg/registry/schema/org/openoffice/Office/Calc.xcs
+++ b/officecfg/registry/schema/org/openoffice/Office/Calc.xcs
@@ -1217,6 +1217,31 @@
</info>
<value>true</value>
</prop>
+ <prop oor:name="FormulaSyntax" oor:type="xs:int">
+ <!-- UIHints: Tools - Options Spreadsheet Calculate -->
+ <!-- This node is deprecated, but we still need to keep it for migration purposes. -->
+ <info>
+ <author>kyoshida</author>
+ <desc>Specifies what formula syntax type to use.</desc>
+ </info>
+ <constraints>
+ <enumeration oor:value="0">
+ <info>
+ <desc>Calc A1</desc>
+ </info>
+ </enumeration>
+ <enumeration oor:value="1">
+ <info>
+ <desc>Excel A1</desc>
+ </info>
+ </enumeration>
+ <enumeration oor:value="2">
+ <info>
+ <desc>Excel R1C1</desc>
+ </info>
+ </enumeration>
+ </constraints>
+ </prop>
<node-ref oor:name="Date" oor:node-type="Date">
<info>
<desc>Specifies the date that is represented by the number 0.</desc>
@@ -1224,6 +1249,64 @@
</node-ref>
</group>
</group>
+ <group oor:name="Formula">
+ <info>
+ <desc>Contains settings that affect formula handling.</desc>
+ </info>
+ <group oor:name="Syntax">
+ <info>
+ <desc>Contains settings for formula syntax.</desc>
+ </info>
+ <prop oor:name="Grammar" oor:type="xs:int">
+ <!-- UIHints: Tools - Options Spreadsheet Formula -->
+ <info>
+ <author>kyoshida</author>
+ <desc>Specifies what formula syntax type to use.</desc>
+ </info>
+ <constraints>
+ <enumeration oor:value="0">
+ <info>
+ <desc>Calc A1</desc>
+ </info>
+ </enumeration>
+ <enumeration oor:value="1">
+ <info>
+ <desc>Excel A1</desc>
+ </info>
+ </enumeration>
+ <enumeration oor:value="2">
+ <info>
+ <desc>Excel R1C1</desc>
+ </info>
+ </enumeration>
+ </constraints>
+ </prop>
+ <prop oor:name="SeparatorArg" oor:type="xs:string">
+ <!-- UIHints: Tools - Options Spreadsheet Formula -->
+ <info>
+ <author>kyoshida</author>
+ <desc>Argument separator in worksheet function</desc>
+ </info>
+ <value></value>
+ </prop>
+ <prop oor:name="SeparatorArrayRow" oor:type="xs:string">
+ <!-- UIHints: Tools - Options Spreadsheet Formula -->
+ <info>
+ <author>kyoshida</author>
+ <desc>Row separator in array constant</desc>
+ </info>
+ <value></value>
+ </prop>
+ <prop oor:name="SeparatorArrayCol" oor:type="xs:string">
+ <!-- UIHints: Tools - Options Spreadsheet Formula -->
+ <info>
+ <author>kyoshida</author>
+ <desc>Column separator in array constant</desc>
+ </info>
+ <value></value>
+ </prop>
+ </group>
+ </group>
<group oor:name="Revision">
<info>
<desc>Contains settings that affect revision marking.</desc>