To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61477 Issue #:|61477 Summary:|Paste and format paintbrush has a bizarre behaviour Component:|Spreadsheet Version:|680m154 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|mmenaz
------- Additional comments from [EMAIL PROTECTED] Wed Feb 1 05:26:45 -0800 2006 ------- You can do this with an empty sheet: Take A1, enter a big value (i.e. 12345678), then format taht cell as currency then move to A2 put there the formula =A1. Bizarre behaviour, A2 not only will have A1 value, as expected, but also it's FORMAT (will be displayed as currency value)! Then another anomaly: Go to A3 and enter another number (i.e. 456789), then select A2, click the format pailnbrush, and then click on A3 with the intention of copy the currency format A2 has... surprise, A3 will keep it's "no format" format. Developers in IRC channel has gave me the "implementation" reason for this, but since it's behaviour must conform to user expectation, I consider it a defect (and one developer agreed with me). The implementation reason was like "that's the formula that displays the result according to the input cells. The result cell has no number format attribute, that's why." but every user will be very unhappy about it, so please fix this usability/productivity/faith in predicable behaviouir issue. --------------------------------------------------------------------- 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]