To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75979 Issue #|75979 Summary|Calc - Dumbing down to Excel - text in arithmetic Component|Spreadsheet Version|OOo 2.1 Platform|Opteron/x86_64 URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|configuration Assigned to|spreadsheet Reported by|jminney
------- Additional comments from [EMAIL PROTECTED] Sun Apr 1 02:50:25 +0000 2007 ------- Very specific issue: 1) Excel cannot do arithmetic on a range or a cell which contains text - it gives an error. 2) In Calc, if text is included in a range, then you do arithmetic on the range (sum, to take a simple example), it treats the text field as value zero, and does the calculation without complaints. I find this really useful for annotating my work. 3) Before sending my files to an Excel user, I have to debug all those instances out. 4) WHY IS THAT A PROBLEM? The problem is the need to run an instance of genyew-wine Excel itself to chase down and eliminate all these instances. So we can't run an MS-free shop. Of course you can't provide configurable switch-on-or-off-as-needed "dumb-down" compatibility with all the problems of Excel, but as this one is fairly specific and very widely applicable, could it be done? Possible Implementation: Under Configuration, have an option to view it as an Excel user would see it. Build in this function into that, and any others that seem high enough priority. Thanks! I'm busily evangelising --------------------------------------------------------------------- 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]