To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53833 Issue #:|53833 Summary:|Formatting failure leads to calculation error Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|andy999
------- Additional comments from [EMAIL PROTECTED] Fri Aug 26 08:12:40 -0700 2005 ------- Attached spreadsheet has 3 cells; A2, B2, and C2. C2 subtracts A2 from B2. * Cell A2 is type Text, format @. * Cell B2 is type Numer, format General. * Cell C2 is also type Numer, format General. Important: While C2 shows the value of B2 -- properly -- as described in issue 27241, the problem can not be corrected using block formatting. Because of that, this is a formatting issue and not a calculation issue. Specifically... * If you highlight A2 through B2 and change the Format to Number, A2 will not change from Text and the calculation will fail. * If you highlight from B2 through A2 and change the Format to Number, A2 will not change from Text and the calculation will fail. * If you select A2 and change the Format to Number, C2 is correct. This is similar to but not the same defect as issue 27241. It is closely related to issue 5658. Attachment with example will be provided shortly. --------------------------------------------------------------------- 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]
