Difference between revisions of "Calc/Features/Variable formula convention"

From Apache OpenOffice Wiki
< Calc‎ | Features
Jump to: navigation, search
(References: added new issue number.)
(Abstract: added bits about the separators in formula expressions.)
Line 20: Line 20:
 
* Excel R1C1
 
* Excel R1C1
  
The current formula convention can be switched at run-time, via the Options page.
+
The current formula convention can be switched at run-time, via the Options page.  In addition, argument separator, and array column and row separators will be replaceable.
  
 
__TOC__
 
__TOC__

Revision as of 13:48, 24 July 2008

Variable Formula Convention

Specification Status
Author Kohei Yoshida
Last Change See wiki history
Status draft

Abstract

This feature enables use of several different formula syntax conventions in Calc. The three formula conventions will be supported initially, with possible future additions of more conventions as needed. The conventions that will initially be included are

  • Calc A1 (current convention)
  • Excel A1
  • Excel R1C1

The current formula convention can be switched at run-time, via the Options page. In addition, argument separator, and array column and row separators will be replaceable.

References

Reference Document Check Location (URL)
Issue ID (required) available Issue 20857 Issue 72191 Issue 92056
Test case specification (required) n/a

Contacts

Role Name E-Mail Address
Developer Kohei Yoshida kyoshida@novell.com
Quality Assurance nobody
Documentation nobody
User Experience nobody

Detailed Specification

TODO: work on this.

Migration

Configuration

File Format

Open Issues

References

  1. Daniel Rentz's note on Excel separator conventions per locale
Personal tools