[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] Wed Feb 20 18:22:16 + 2008 --- @kohei: This may be more work than you wanted to do to with your patch, the but please consider the types of UI warnings that Excel gives. See: http://www.openoffice.org/nonav/issues/showattachment.cgi/30449/Excel2003-warning-about-mixed-cell.png and http://www.openoffice.org/nonav/issues/showattachment.cgi/30450/Excel2003-handling-mixed-cell.png - 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] Wed Feb 20 18:19:56 + 2008 --- The basic issue is this: When opening an Excel file -- calculate 100% like Excel When opening an Quattro Pro file -- calculate 100% like Quattro Pro When opening an 1-2-3 file -- calculate 100% like 1-2-3 When opening an ods or sxc -- Feel free to be "proper" in your own eyes One issue I see is a UI issue in saving/exporting from one format to another where calculated results will change. There should be big fat warning. - 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] Wed Feb 20 18:10:39 + 2008 --- philhibbs said: "What should =A1+0 do, if A1 is text? What should =MID(A1;1;LEN(A1))+0 do, if A1 is text? Why does the former need to be =VALUE(A1)+0 but the latter does not need to be =VALUE(MID(A1;1;LEN(A1)))+0?" The answer is so easy in the context of OO calc opening an Excel document. The answer is it should do the exact same as Excel. - 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] Wed Feb 20 17:58:17 + 2008 --- @philhibbs: You misrepresent me and create the classic straw man retort. You imply that I want EVERY bug recreated in Calc. That is not the case. I want OO to calculate the same as Excel when opening Excel spreadsheets, if that requires behavior considered as a "bug" (and this bug report is about one specific "bug", not all bugs), then so be it. This is a case of OO developers flat out REFUSING to do the right thing. How is NOT malicious when this fixable compatibility bug has been open since 2002? It isn't my credibility that the issue. OO calc is has the credibility problem which is why it is flat out banned at a growing number of sites specifically because of this bug. - 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] Wed Feb 20 17:27:55 + 2008 --- @philhibbs "OOo does not and should not have emulation of Excel bugs on its feature list." If the "bug" is needed to have the calculation result that Excel would perform, then absolutely OOo MUST do the same as Excel when opening an Excel spreadsheet. I'm just guessing that you never had Calc almost cost you $23,000.00. >From the http://www.openoffice.org/product/calc.html it states, "Of course, you are free to use your old Microsoft Excel spreadsheets, or save your work in Excel format for sending to people who are still locked into Microsoft products." This a malicious LIE! It should say, "Of course, you are free to use your old Microsoft Excel spreadsheets, or save your work in Excel format for sending to people who are still locked into Microsoft products AS LONG AS YOU DON'T CARE ABOUT HAVING THE CALCULATED RESULTS MATCH EXCEL. WE KNOW THAT CALCULATION IS THE WHOLE POINT OF A SPREADSHEET, BUT WE DON'T GIVE A SHIT." That would make a good DIGG headline that would be sure to make the top page coupled with my documented, legitimate story of OO calc nearly costing me $23,000 back in 2005. - 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 numbe r 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 Dec 1 10:54:31 -0800 2005 --- This "bug" is going to end up being a massive public relations problem for OpenOffice.org (which I do not want). I recommend removing support for the XLS format entirely. After all, as fst said in bug 58589, "we are not an Excel clone and will not be !" The current support for XLS is "broken" by any definition. The first time someone blogs or goes to the media with "OpenOffice.org Calc cost me $20,000 USD!!" (as it nearly did for me) nobody will ever trust the software again. You can't earn the trust back once lost. Do what you will with files stored in native OpenOffice.org/OASIS format, but when you open an Excel file, YOU MUST CALCULATE it the SAME as Excel does, other wise the support for Excel files is WORSE THAN NONEXISTENT. - 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 numbe r 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 User daxkelson changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=30451) Nasty excel | |test case with undisplayed | |text causing OO misscalc --- Additional comments from [EMAIL PROTECTED] Fri Oct 14 10:52:11 -0700 2005 --- Created an attachment (id=30451) Nasty excel test case with undisplayed text causing OO misscalc - 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 numbe r 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 User daxkelson changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=30450) Excel 2003 UI | |with options to user to | |handle mixed number / text | |cell --- Additional comments from [EMAIL PROTECTED] Fri Oct 14 10:46:38 -0700 2005 --- Created an attachment (id=30450) Excel 2003 UI with options to user to handle mixed number / text cell - 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 numbe r 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 User daxkelson changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=30449) Excel 2003 UI | |to indicate something is | |amiss with mixed | |number/text cell --- Additional comments from [EMAIL PROTECTED] Fri Oct 14 10:45:27 -0700 2005 --- Created an attachment (id=30449) Excel 2003 UI to indicate something is amiss with mixed number/text cell - 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 numbe r 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] Fri Oct 14 10:43:27 -0700 2005 --- This is a HUGE issue. It almost cost me lots and lots of money. I publish books and I get royalty reports in XLS format emailed to me on a quarterly basis. The reports are auto-generated. I'm supposed to invoice off of the total amount that is displayed at the bottom of a very long and wide table. My default application to open XLS is OO.org calc. I thought that the royalty amount seemed to small, so I opened the XLS file in Excel, Gnumeric, and Documents to Go v7 (PalmOS Spreadsheet app). Excel, Gnumeric, and Docs to Go all had the proper royalty dollar figure. In OO.org calc the number was tens of thousands of dollars less. WOW, a big shocker! So, the fault is the document, but really, OO.org has no choice here, it needs to behave the same as the other spreadsheets to continue to claim XLS document compatibility. I don't think that OO.org calc will get a second chance if it violates and loses the trust (and/or money) of it's users. Please consider this a 2.0 showstopper. I do note that now in Excel 2003, it still calculates properly, but a small indicator is displayed in the cell (small green triangle in upper left corner) that when you hover over it tells you that something is amiss. I'll attach a couple screenshots of Excel 2003 handling this situation. - 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 55954] OO miscalculates excel sp readsheets
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55954 User daxkelson changed the following: What|Old value |New value Attachment data| |Created an attachment | |(id=30414) Excel file that | |OO mis calculates --- Additional comments from [EMAIL PROTECTED] Thu Oct 13 15:25:31 -0700 2005 --- Created an attachment (id=30414) Excel file that OO mis calculates - 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 55954] New - OO miscalculates exc el spreadsheets
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=55954 Issue #:|55954 Summary:|OO miscalculates excel spreadsheets Component:|Spreadsheet Version:|OOO 2.0 Beta2 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P2 Subcomponent:|open-import Assigned to:|spreadsheet Reported by:|daxkelson --- Additional comments from [EMAIL PROTECTED] Thu Oct 13 15:14:00 -0700 2005 --- I get a royalty report in Excel format emailed to me on a quarterly basis. It is autogenerated in Excel. When I open in any version of OpenOffice (v1 or v2.0 includes beta2) the owed royalty is the wrong value! Both Excel, Gnumeric, and Documents to Go v7 (PalmOS spreadsheet) produce the proper value. This is a very serious defect, that could have had serious financial implications. I have distilled a test case and am attaching it. - 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]
