To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53833
User andy999 changed the following:
What |Old value |New value
================================================================================
CC|'regina' |'jleowski,regina'
--------------------------------------------------------------------------------
Status|RESOLVED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|DUPLICATE |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sun Sep 4 06:45:27 -0700
2005 -------
Regina, I have reopened this for review as I think you may have have
misunderstood this specific issue and the severity of the problem. In summary;
* Issue 5658 deals with importing an XLS file and calculating the results of a
text cell. No formatting changes are made.
* This issue (issue 53833) deals with an OpenDocument spreadsheet -- created
from-scratch and not necessarily saved. Block formatting changes from text to
numeric are ignored.
Therefor, this issue is not a duplicate of issue 5658.
The first note I posted and the follow on notes by Steve and Jacek document the
steps required to reproduce this problem.
To eliminate any potential confusion, here are the exact steps you can perform
to see that this is not the same issue as issue 5658;
* Open a new Calc spreadsheet.
* Click on cell A2.
* Change the formatting of A2 to "text, @".
* Click on cell B2.
* Verify format of B2 is "numeric, general".
* Click on C2.
* Enter the formula "=sum(a2:b2)".
* Click on A2.
* Enter 1 for the value. (NOTE: The value in the Input Line is just 1 not '1 or
similar.)
* Click on B2.
* Enter 2 for the value.
* Click on another cell. (This will commit the value of 2 in B2.)
* C2 shows a calculated value of 2.
* IMPORTANT: Select both A2 and B2 at the same time.
* Bring up the format dialog. It shows "numeric, general".
* Click OK to issue the change.
* C2 shows a calculated value of 2. It should have been 3!
* The format of A2 is still "text, @" not "numeric, general" as Calc was
instructed to do.
Note: Selecting column A and changing the formatting also has no impact on cell
A2 being in "text, @" format.
In summary: selecting a block and changing the format of the block from text to
numeric does not change the cell from text to numeric -- the cell remains text.
Please read through the steps required to reproduce this as there are specific
conditions required to see this problem and they are easy to miss.
This is a high or critical issue by definition;
* It is a break in functionality.
-- Changing formatting from text to numeric does not work over blocks.(!!!)
* The defect can easily be missed by both novice and expert; it is not a
cosmetic or medium problem.
-- Block formatting is something that should reliable, and in this case it is
ignored. On moderately complex sheets, it is not reasonable that a novice or
even an expert would notice that the calculation is incorrect.
* Data loss or a miscalculation is the result.
-- Unlike issue 5658, this is a formatting problem but the results still are
that the calculation performed is not what Calc is instructed to perform.
As such, a higher priority (top or second from top) is appropriate. (I tend to
use 4 severity levels -- ISO, IEEE, and IBM use similar definitions -- instead
of the 5 used here, and under those this would be a critical aka 'showstopper'
as data loss / miscalculation is involved and the workaround can not be expected
to be performed by experts consistently let alone casual users.)
---------------------------------------------------------------------
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]
