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

From Apache OpenOffice Wiki
< Calc‎ | Features
Jump to: navigation, search
(Configuration: add line)
(Migration: add line)
Line 68: Line 68:
  
 
== Migration ==
 
== Migration ==
 +
No migration is involved.
  
 
== Configuration ==
 
== Configuration ==

Revision as of 15:18, 6 November 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

No migration is involved.

Configuration

No configuration is involved. Default setting should be OpenOffice.org A1 style.

File Format

No file format change is involved.

Open Issues

Issue 72191

References

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