[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Tue Jun 15 08:32:08 + 2010 --- I want to thank the OOo team for fixing this very long-standing nuisance. @jitenhaara - OOo advertises itself as a drop-in replacement for Microsoft Office. So Excel compatibility matters more than making a better spreadsheet program that is useless to 99% of the world. And, yes, I understand your compatibility concern. You have exactly the same problem in reverse that people in a mixed Excel/OOo environment had since 2002, when this bug was first reported. I am very glad and appreciative that the OOo development team has listened to users. For me, it came too late - I had to advise all my clients to move away from Open Office because of this problem. But it is very much appreciated anyway! - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Fri Sep 4 20:46:42 + 2009 --- Also, Excel will interpret all kinds of numeric data, such as 100.000,00 or $75.99. I assume that they resolve ambiguities (is 10.000 10 or 1?) based on the locale. Not sure if it's the locale of the OS, of Excel itself or whether the locale is stored with the spreadsheet. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Wed Jun 3 07:12:46 + 2009 --- Andrew, apparently, you never worked in a large company. Unless a CxO is a major OpenOffice supporter or Microsoft hater, if you tell them to retrain users for such an issue, the answer will be you are fired for putting OpenOffice on our computers in the first place. You should have bought MS Office all along! Then he'd write a memo putting OpenOffice on the banned-software list. And he'd be right. A single incident of such a problem can easily cost far more than a copy of MS Office for everybody. In any case, training users is not an option for me. Me lone consultant am not going to tell a multimillion dollar company to retrain all their users AND to review every single Excel spreadsheet companywide (because more often than not, users pass spreadsheets around and copy them, rather than using templates) for an issue that 99% of the recipients never have because they use Microsoft Office. Me lone consultant WILL tell my customers that OpenOffice Calc is dangerous to their bottom line. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Wed Jun 3 11:27:21 + 2009 --- Karlis, I think in this bug report we have seven years worth of evidence that this problem is *extremely* common even if Andrew personally may not have come across it. Which makes me wonder why he even cares about it one way or the other? I actually found the bug exactly the same way you did: a vendor sent me a proposal that looked like the cheapest. In my case, it wasn't for my own business but for a customer - which means that I could have gotten sued over it, and it could have put out of business. I'm not even sure if an EO insurance would cover such matters. Fortunately, I caught it before placing the order. This vendor was a large company, and I'm sure they are sending out dozens of these spreadsheets every day. You are absolutely right. Retraining users is an absurd suggestion. And it wouldn't even help. That horse has left the barn long ago. You know the old joke about how God could create the world in seven days? He didn't have to worry about an installed base. Most likely, they have a sales team of maybe 20 people. Each of them probably keeps a copy of each spreadsheet sent out, and when a new prospect calls, pulls up one of the old spreadsheets, changes the numbers, and resaves it. Maybe they are using SharePoint or something like it to manage the large number of spreadsheets - who knows. He certainly will NOT go back and spend hours double-checking every single cell of a 5-page spreadsheet with 3000 rows and 30 columns - even less so when he sees with his own eyes that the total is correct. And since he can use any of thousands of previous versions of this spreadsheet as a starting point, cleaning up all the places where this error (which isn't an error at all from Excel's perspective) lurks is just plain a ridiculous proposal. Add to that the problem of personnel turnover. In many companies, sales people last maybe six months. Do you really seriously propose that each of these people be trained in such all such subtle issues that doesn't even affect the software that they and 99% of the world is using? On the first day on the job? With that kind of turnover, training is going to be 2 hours of here is the phone, here is the price list, and for the proposals just ask John over there to send you a copy of the spreadsheet he did. Now get to work, and I want you to make 20 sales in your first week! And training for long-term employees? Maybe after a year on the job they'll be sent to a one-week Excel class taught by a MOUS (Microsoft Office User Specialist). Most likely somebody who has never heard of OO. Training people? Come on, get real. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Wed Jun 3 12:09:44 + 2009 --- I think I may actually have stumbled upon WHY this problem occurs in so many Excel-generated spreadsheets. Turns out that it no amount of training would solve it, because Excel actually makes the change automatically. In some cases, users actually have to go out of their way to NOT enter numbers as text. Actually, there is at least one, and probably two more ways this happens: users may intentionally do it for various reasons. And it probably also happens when you import data from CSV and other formats, although I have not confirmed that. Try this (I tried it in Excel 2007). It is important to do it in exactly this sequence. open a blank spreadsheet. Do not touch the format of cell A1 (it should be formatted as General) Type the number 7 into cell A1 Change the format for cell A2 to Text Type the number 6 into cell A2. Make sure you type JUST the digit - no quotes or anything else. Note that the number six will be left-aligned due to the text formatting. Note, but do not change, the formatting of cell A3. It should be General Type the formula =A1+A2 (without quotes) into A3. You will see the number 13, left-aligned. Note the formatting of cell A3 again. You will see that it has changed to Text Save the spreadsheet as XLS file. Open the spreadsheet in OpenOffice. Voila. Remember: you haven't entered a single quote in Excel, only digits. Yet just based on the formatting of the cell, Excel treats the 6 that you typed into A2 as a string. Even if you later change the cell format to General Excel will keep the number as text! In the real world, this is very likely to happen to parts of a spreadsheet by accident. Imagine a spreadsheet with 10 columns. You format each column appropriately for the data it should hold. Later you insert a new column between two columns that are both formatted as text. How likely is it that you'd realize the new cells are also formatted as text? Maybe you'll realize it an hour later when the formatting is off. But it's too late: once you enter data into a text-formatted cell, the data stays a string even if you later change the format. The second way this probably happens: it may also be an intentional trick of the trade of experienced Excel users: you can save yourself a lot of work formatting the cells by typing in the numbers in the correct format, if you start it with a quote. I came across http://excel.tips.net. Several of the tips listed there deal with this and a few related issues, including a question If you have a range of numeric values in your worksheet, you may want to change them from numbers to text values. Here's how you can make the switch. (the answer: copy the cells to the clipboard, format the cells as text, paste the data back in - exactly as I outlined above). - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Wed Jun 3 19:47:32 + 2009 --- Andrew, If, in the real world, you are trying to use OpenOffice as an Excel substitute, then I recommend that you do not. As I have said time and again, If you need Excel, use Excel. I know you have said so before, but I find this comment very strange because OpenOffice is primarily and explicitly *advertised* as a Microsoft Office replacement. You see the banner every time you install Java, for instance. If this statement really was true, then the solution actually is very simple: remove the Excel support altogether. According to your statement, it's not needed anyway, and it is broken anyway. But if you leave the Excel support in, then it absolutely *must* work. Reliably. Every time. Re. the second comment: more importantly, I answered philhibbs' question about how users do it without realizing I identified what to my knowledge nobody had done before: why this issue arises so frequently in the first place. You can call it a feature or a misfeature or whatever you like. What bothers me most about all this isn't actually the bug itself. What bothers me is the absolute willful unresponsiveness of the OpenOffice team to a very obvious user demand - with the seventh anniversary coming up in a few days - just based on some ivory-tower idea of Excel is wrong. And then people wonder why Linux on the Desktop isn't taking off. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Wed Jun 3 19:50:34 + 2009 --- One more thought. It is *entirely* possible that Microsoft has done this intentionally in order to break OpenOffice compatibility. It would be very much in line with their strategies in many other cases. And right now, OpenOffice is actually Microsoft's marketing for them by letting this issue fester for so long. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Wed Jun 3 20:08:42 + 2009 --- ER - given that this issue has its SEVENTH anniversary coming up on Monday without a resolution, I have a very hard time believing that it will be addressed. Even more so since quite a few team members seem to have dismissed this issue or even explicitly stated that it should *not* be addressed. What you are seeing is the resulting frustration from the user community. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Wed Jun 3 21:00:19 + 2009 --- Good point. To be honest, I hadn't even heard about CT2N until you mentioned it yesterday; I all but gave up on OpenOffice and am just following this in case this ever changes. This is one of the two main issues that are keeping me from switching to Linux on the desktop (the other one is the lack of good accounting software). I'm also a bit reluctant to rely too much on extensions for bug-fixes. At some point, you run into software management and update-compatibility issues. Another concern I have is that a user wouldn't necessarily KNOW that he'd need to take the CT2N action. All he would notice is the total of the spreadsheet, and if he is lucky he'd notice that the numbers make no sense. But I'd still be very interested to learn more about CT2N as a stopgap. Is it supported on all platforms? - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Fri May 22 16:41:15 + 2009 --- The marketplace is littered with better products that failed because they didn't do what people needed. Excel won because it *was* Lotus 1-2-3 compatible. Ever heard of Next computers? Linux on the Desktop? Even a multi-billion dollar marketing budget didn't save these products. The choice isn't between Excel Clone and Excel Beater, but between Excel Clone and Edsel Beater. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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 kke...@openoffice.org Fri May 22 21:18:33 + 2009 --- Andrew, here is an easy experiment that may settle this once and for all. It's called Market Research. Implement two versions of OpenOffice. One with all your improvements and only supporting its own file format, and one that can open XLS files, but correctly. See which one people will download. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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] Tue Nov 25 14:15:13 + 2008 --- @fdservices: Excel is inconsistent in its treatment of text and numbers. I would classify that as being a bug, and we do not need to reproduce that in OO. Not quite. If you import Excel files, then Excel's behavior is the gold standard. It doesn't matter if Excel's behavior is logical, illogical, serpentine, obscure, or even outright bizarre. It doesn't matter if you think there's a bug in Excel - I might even agree with you on that, but it's plain irrelevant. If OO doesn't do the same thing, it is a bug in OO's Excel import filter. As this discussion shows, many people got burned by this bug already, so it's not just an academic discussion. I've been a software developer for 20 years, and I also run a business. One thing I have learned is that customers don't care about the perfect anything - they care that the job gets done. I've seen software developers get fired for implementing a technically elegant solution that didn't meet the customer's needs. Whether that matters really depends on your goal. From an academic standpoint, if you want to build the best possible spreadsheet as a research project, you may be absolutely right. If your goal is to provide an alternative to Microsoft Office - well, then arguing I'm right and Microsoft is wrong is not going to earn you much market share. It's more like a famous last word. - 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]
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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] Sat Nov 22 13:28:34 + 2008 --- No, that extension isn't sufficient. When one of my business partners sends me an Excel spreadsheet by email, I need to be able to simply double-click it and trust that when it opens, the numbers will be the same that he used. Having to run a program or the like just in case he used text instead of a number does not cut it. And as long as this bug isn't fixed, only Microsoft Office satisfies that need. That is why I proposed earlier to remove support for .XLS altogether - broken support like this is worse than not supporting Excel at all. - 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]
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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] Sun Nov 23 04:11:41 + 2008 --- @ cornouws: OK, you want a program that does exactly the same as Excel, without doing any extra click... hmm then I have the prefect solution for you: Excel :-) Ummm... Have you seen a version of Excel for my Ubuntu distribution? I've come to the same conclusion you have; if I need Excel, I will have to switch back to Microsoft. Unlike you, I'm not on a quest for an ivory tower perfect spreadsheet but rather for a program that solves my and my customer's real-world business problems. I suspect that is why Microsoft still rules the desktop. One thing that I don't quite understand is: if OpenOffice really does not even want to be Excel-compatible, why is there an Excel import filter in the first place? And why does the ad they insert into the Java JRE installer emphasize what Microsoft Office compatibility that it can't deliver? - 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]
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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] Thu Nov 20 13:25:08 + 2008 --- It seems to me that there is a consensus developing here that it is more important to behave correctly than to be compatible with Excel. Maybe the real solution is to simply remove support for .xls functionality altogether, since it doesn't work anyway? - 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]
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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] Sun Oct 5 08:35:23 + 2008 --- I think there is a fallacy in the thinking; it ignores the real-world workflow that you will often see. The number of people who get a wrong result in Excel is going to be minuscule, because just like regular software projects, people do test spreadsheets. In the business world, spreadsheets are designed in Excel. They are tested in Excel. Then they are distributed to the sales force, who fills them out - in Excel. The spreadsheet designers put strings into formulas - it's rarely the end user who accidentally adds quotes when entering values. Because all the testing happens in Excel, you won't see a problem. Then they are sent out to me. Who opens it in OpenOffice - and gets a wrong result. And movement towards a resolution... - well, when after 6.5 years there are STILL people arguing that Excel compatibility doesn't matter, I'm not as optimistic as you are. - 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]
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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] Sat Oct 4 08:02:02 + 2008 --- I have to chime in with those who argue that this issue almost cost me serious money. A proposal from one of my vendors showed costs that were off by hundreds of dollars per month; my customer would have sued me had I not caught this in time. When loading an XLS spreadsheet, it is absolutely imperative that the results are the same as they were in Excel. That should override any philosophical considerations on what the right treatment is - when you are competing with Excel and advertising compatibility, then right is what Excel does. Anything else may be appropriate for an ivory tower - but not for the real world of business. As a consultant, I used to tell my customers to replace Microsoft Office with OpenOffice. But until this issue is fixed, I cannot do that any more. And the fact that, as I now see, this discussion has been dragging on for six years does not help to build trust in OpenOffice. How many other such issues are there lurking, and will they also take more than half a decade of discussion without a solution? - 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]
[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)
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] Sat Oct 4 08:10:16 + 2008 --- I have to chime in with those who argue that this issue almost cost me serious money. A proposal from one of my vendors showed costs that were off by hundreds of dollars per month; my customer would have sued me had I not caught this in time. When loading an XLS spreadsheet, it is absolutely imperative that the results are the same as they were in Excel. That should override any philosophical considerations on what the right treatment is - when you are competing with Excel and advertising compatibility, then right is what Excel does. Anything else may be appropriate for an ivory tower - but not for the real world of business. As a consultant, I used to tell my customers to replace Microsoft Office with OpenOffice. But until this issue is fixed, I cannot do that any more. And the fact that, as I now see, this discussion has been dragging on for six years does not help to build trust in OpenOffice. How many other such issues are there lurking, and will they also take more than half a decade of discussion without a solution? - 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]
[sc-issues] [Issue 94612] Excel incompatibility - st ring in a Math formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94612 Issue #|94612 Summary|Excel incompatibility - string in a Math formula Component|Spreadsheet Version|OOo 2.4.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|kkeane --- Additional comments from [EMAIL PROTECTED] Fri Oct 3 09:49:06 + 2008 --- When you use a string that contains a numeric string, Excel will use it as a number. OpenOffice treats it as a zero regardless of the actual value. Example: B12: 8 E12: =IF(B125,$59.99,IF(B1215,$49.99)) F12: 1.99 G12: 1.5 M12: =SUM((E12+F12+G12)+(E12+F12+G12)*0.069)*B12 (all cells except B12 formatted as currency) In this scenario, Excel will display: B12 | ... | E12 | F12 | G12 | | M12 8 ... | $49.99 | $1.99 | $1.50 | | $457.36 OpenOffice will display 8 ... $49.99 $1.99 $1.50 $29.85 This is similar to bug 6768, which I believe should not have been closed. Regardless of whether Excel's behavior is philosophically logical or correct, when OpenOffice yields different mathematical results than Excel, that undermines trust in OpenOffice. - 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]