Issue 20503 - Q-PCD EaseOfLearning-6
Summary: Q-PCD EaseOfLearning-6
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-09-30 17:39 UTC by niklas.nebel
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description niklas.nebel 2003-09-30 17:39:03 UTC
Task tracking system for Childs

User Interviews/ SEs

Help for competing applications users

Product Requirement 
Toggle input method as competing applications.

Customer Need/Problem
Ability to input data and perform calculations as in competing applications.
Issues to deal with include parameter order and delimiters


Eng Effort

Eng Owner
Niklas Nebel

Product Concept
Other applications use the list separator character from regional settings as
argument separator for formulas. In US-English locale this is a comma. SO/OOo
uses a semicolon, regardless of locale settings. Migrating users who try to
enter a formula into SO/OOo using the comma receive error messages and dont
always immediately know what went wrong.
In SO/OOo each cell can have its own number format language, so making the
separator locale-dependent would lead to the confusing situation of having
different argument separators within one document. We also cant change the
separator in the file format or in API usage of formulas, for compatibility
between SO/OOo versions.
Instead of changing the separator character, we will detect wrong usage of comma
(where it cant be mistaken for a decimal or thousands separator) in the formula
auto correction and suggest the working formula with semicolons in that case.
That way, it becomes obvious to the user that they have to use a semicolon, and
the confusion about whats wrong is avoided.

Functional Specification
Comment 1 lutz.hoeger 2003-10-23 07:44:56 UTC
added keyword Q-PCD
Comment 2 thorsten.ziehm 2004-07-13 12:01:56 UTC
Due to missing resources the product team and the development decided to shift
this feature to the next target 'OOo later'. It is unlikely to integrate this
feature in OOo 2.0.
If somebody in the community have the knowledge to help Sun here, please contact
the development and retarget this feature.
Comment 3 Marcus 2017-05-20 11:13:12 UTC
Reset assigne to the default "".