To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658
------- Additional comments from [email protected] Wed Jun 3 09:09:25 +0000 2009 ------- Well, I happen to think that training is an important activity in any company, and training in the correct use of software is equally important. I admit that this is often a neglected area which gives rise to many inaccurate, inefficient and ineffective spreadsheets, and, consequently, wrong results. Just for the record, I was that CFO in a (several) large company, and I am also now a consultant to several companies, so you may assume that I have some small amount of experience. I have never come across the problem defined here (numbers entered as strings by accident) but I have often come across the problem of having to enter hugely complex formulas to avoid #VALUE errors when Excel tries to include a string in a calculation. Fortunately, as a fairly competent Excel user, I can get round the problem, but I still do not understand why you are adamant that I should have to! For this and other reasons, I want OpenOffice to succeed, and to be a better spreadsheet! I disagree that OpenOffice calc is dangerous, except to the extent that ALL spreadsheets are dangerous if the user does not take reasonable precautions to ensure he is getting accurate results, i.e. the spreadsheet is a tool and the user is responsible for the results of using that tool. I do agree that it is not Excel, it does not have the same bugs/features that Excel has,it cannot correctly exchange files with Excel at present, and it cannot therefore be used as a direct replacement for Excel. But if we all work hard at it and encourage its continuing development, it may well become the standard in time, and we can all finally dump Excel with a big sigh of relief. Andrew --------------------------------------------------------------------- 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]
