To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53833
------- Additional comments from [EMAIL PROTECTED] Sat Sep 3 17:57:17 -0700 2005 ------- Open Office Build 1.9.125 Complete Installation OS: Windows XP Pro SP2 Platform: PC We managed to successfully replicate this issue. Replication: 1) Format an empty cell (cell X) to Text 2) Input a number into cell X, for example the value 2 3) Input an equation a third cell (cell Z), similar to the following “=X+3” If step 2 is done before step 1 then the operation works as expected meaning the value in cell Z is 5. Will attach a “Test case issue 53833.ods” that demonstrates the replication steps. Problem: The result treats the text cell X as 0, so for our example the result should show 5, but it shows 3. Additional problem, possibly a separate issue: Furthermore when the cell X‘s format is changed from text to number the problem is not fixed. In the spreadsheet itself it shows as a number, but in the equation cell a single quote (‘) is present in front of the number. In out example cell X formatted back to number type would have a value of 2, but when clicked on and viewed in the equation editor it shows up as ‘2. Why it’s an issue: Similar problems have been dismissed in the past see issue 27241 and issue 27241. In general the problem shouldn’t be encountered very often through normal use. When steps 1 through 3 is done in Excel the operation yield a proper output, meaning they perform the operation on the value regardless of input type. Hence, when moving from Microsoft based Excel sheets to Open Office’s, creates a problem in migrating files, since the Excel sheet no longer works in Open Office’s spread sheet (Calc) as it did originally in Microsoft Excel. Further Testing: Use a different math operation -, *, /, SUM etc. Use another cells as input instead of the value 3 we use. Import Excel documents into Calc that use text type cells to perform operations. Steve Wu and Jacek Leowski --------------------------------------------------------------------- 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]