To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=58923
Issue #:|58923
Summary:|Selecting 'Text' as Cell Category sometimes
|prevents/disables formula calculation
Component:|Spreadsheet
Version:|OOo 2.0
Platform:|PC
URL:|
OS/Version:|Windows 2000
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P4
Subcomponent:|ui
Assigned to:|spreadsheet
Reported by:|d_walczak
------- Additional comments from [EMAIL PROTECTED] Mon Dec 5 16:33:51 -0800
2005 -------
This issue is bug or interface inconsistency. I've found that oocalc treats
formula entered into cell in inconsistent way when cell's category is set to
'Text'.
Case I: Correct (IMO) formula calculation, steps to reproduce:
* Create new spreadsheet
* Enter '2' into cell B1
* Enter '=B1' into cell A1 ('2' should be displayed in both cells)
* Select cell A1
* Select 'Format'->'Cells'. 'Format Cells' dialog should appear.
* Select 'Numbers' tab.
* Select 'Text' item in 'Category' list.
* Press 'OK'
* Enter '3' into cell B1 ('3' should be displayed in both cells).
Case II: Incorrect (IMO) formula calculation, steps to reproduce:
* Create new spreadsheet
* Select cell A1
* Select 'Format'->'Cells'. 'Format Cells' dialog should appear.
* Select 'Numbers' tab.
* Select 'Text' item in 'Category' list.
* Press 'OK'
* Enter '2' into cell B1
* Enter '=B1' into cell A1
* BUG: Content of A1 cell is treated as string instead of formula and its value
is different than value of cell B1.
EXPECTED:
Selection of 'Text' as cell's category shouldn't prevent entering of formula
into this particular cell.
NOTE:
In both cases, saving of spreadsheet in 'OpenDocument Spreadsheet' format
doesn't change anything. Spreadsheet created in case 1 still works good (IMO).
Spreadsheet created in case 2 still works bad.
---------------------------------------------------------------------
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]
