To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=52179
Issue #:|52179
Summary:|Formula starting with '+' or '-'
Component:|Spreadsheet
Version:|680m90
Platform:|All
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|PATCH
Priority:|P3
Subcomponent:|code
Assigned to:|spreadsheet
Reported by:|muthusuba
------- Additional comments from [EMAIL PROTECTED] Tue Jul 19 09:03:08 -0700
2005 -------
Formula cells should be allowed to start with '+' or '-' along with '='
This would help in ease of use. Many excel or gnumeric users find it easier to
start a formula cell by using '+' or '-' (because the number pad contains these
and its tough to press '=' every time a formula is to be entered).
Proposed patch:
--- sc/source/ui/view/viewfunc.cxx 2005-07-17 21:30:12.000000000 +0530
+++ sc/source/ui/view/viewfunc.cxx 2005-07-17 21:36:50.786937728 +0530
@@ -451,7 +451,8 @@ void ScViewFunc::EnterData( SCCOL nCol,
BOOL bNumFmtChanged = FALSE;
// einzelnes '=' ist String (wird fuer Spezialfilter so
gebraucht)
- if ( rString.GetChar(0) == '=' && rString.Len() > 1 )
+ if ( ( rString.GetChar(0) == '=' || rString.GetChar(0) == '+' ||
rString.GetChar(0) == '-' )
+ && rString.Len() > 1 )
{ // Formel, compile mit AutoCorrection
for (i=0; i<nTabCount; i++)
if (rMark.GetTableSelect(i))
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
