[sc-issues] [Issue 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 User kohei changed the following: What|Old value |New value CC|'discoleo,er,laurentgodard|'discoleo,er,kohei,laurent |,vinc17,zoominee' |godard,vinc17,zoominee' - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from reg...@openoffice.org Sat May 8 12:37:02 + 2010 --- *** Issue 111477 has been marked as a duplicate of this 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: 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from zoomi...@openoffice.org Fri Apr 24 06:49:25 + 2009 --- I suggest adding the appropriate conversions into the Microsoft formats input/ output converter and implementing the mathematically correct precedence rule in OpenOffice.Org starting from the next major version. - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 User zoominee changed the following: What|Old value |New value CC|'discoleo,er,laurentgodard|'discoleo,er,laurentgodard |,vinc17' |,vinc17,zoominee' - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from e...@openoffice.org Wed Feb 4 10:18:46 + 2009 --- *** Issue 98823 has been marked as a duplicate of this 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: 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from [EMAIL PROTECTED] Wed Aug 6 13:29:42 + 2008 --- *** Issue 92515 has been marked as a duplicate of this 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]
[sc-issues] [Issue 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 User discoleo changed the following: What|Old value |New value CC|'er,laurentgodard,vinc17' |'discoleo,er,laurentgodard | |,vinc17' --- Additional comments from [EMAIL PROTECTED] Wed Aug 6 16:53:04 + 2008 --- To add further weight to the mathematical correct interpretation: - all scientifically advanced programs DO interpret -4^2 = -16 - including mathematical and statistical software, e.g: R, Octave, Mathematica (did not test it personally, but I am confident that the person whom I asked, did actually test it), ... Adding parenthesis (as does gnumeric) is necessary for some other reason, too: - files may get imported into different software that: -- DO interpret it mathematically correct -- BUT do NOT implement all ODF-engine (and every quirk) [e.g. a simple ODF-parser/importer] - ODF and implementations might change in the future and handle such expressions correctly -- this will break all backwards-compatibility and -- make old spreadsheets rather unusable To be safe for future changes, removing all mathematical ambiguity when saving these expressions is the better approach. Another weirdness of the current implementation is described in issue 92515: -(5+3)^2 is interpreted as + 64 instead of -64 [tested in OOo-dev m28] If it wasn't tragic, it would be rather grotesque. In the latter case it can't be even argued that the number (-8) is meant, because we have -(an expression). Also, this breaks completely the mathematical commutativity, like: x - b^n != - b^n + x Hope this will foster adopting sound mathematical rules in interpreting such expressions. - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from [EMAIL PROTECTED] Tue Jun 24 01:23:53 + 2008 --- In Google, Have yous tried to type -4^2 ? It resuts -(4^2) = -16. - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 User er changed the following: What|Old value |New value CC|'laurentgodard,vinc17'|'er,laurentgodard,vinc17' Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Mon Jun 2 13:32:28 + 2008 --- Confirmed. Input of =-x^y probably should be changed to read =(-x)^y - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from [EMAIL PROTECTED] Mon Jun 2 13:26:25 + 2008 --- *** Issue 66735 has been marked as a duplicate of this 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]
[sc-issues] [Issue 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from [EMAIL PROTECTED] Mon Jun 2 14:58:02 + 2008 --- Not all OpenOffice users are also Excel users (or users of other spreadsheets). Many of them have used calculators for which the rule is the conventional (and more common across software) mathematical one: -x^y is -(x^y). So, when the user types (or copy-pastes) such a formula, OpenOffice should rather interpret it as -(x^y); there could possibly be a configuration option to support both interpretations. To avoid any ambiguity, OpenOffice should output explicit parentheses in both cases. Concerning file formats, just use the specifications when reading or writing spreadsheet files. When writing files, adding explicit parentheses could also be safer, in particular wrt 3rd-party applications that could easily interpret formulas in the wrong way. - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from [EMAIL PROTECTED] Thu May 29 12:45:11 + 2008 --- Please read here: http://bugzilla.gnome.org/show_bug.cgi?id=115941 - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 User laurentgodard changed the following: What|Old value |New value CC|''|'laurentgodard' - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 User vinc17 changed the following: What|Old value |New value CC|'laurentgodard' |'laurentgodard,vinc17' - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from [EMAIL PROTECTED] Wed May 28 21:42:00 + 2008 --- More info about this subject: http://www.macnauchtan.com/pub/precedence.html - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from [EMAIL PROTECTED] Wed May 28 21:52:01 + 2008 --- OASIS reference: http://wiki.oasis-open.org/office/Expression_Syntax Similar isues : http://www.openoffice.org/issues/show_bug.cgi?id=66735 http://www.openoffice.org/issues/show_bug.cgi?id=24271 Please close duplicates. - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from [EMAIL PROTECTED] Tue May 27 21:40:35 + 2008 --- This issue is commented here. It's clearly an MS-quirck, since Lotus 1-2-3 didn't have it. http://support.microsoft.com/kb/132686/en-us/ - 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from [EMAIL PROTECTED] Tue May 27 21:42:28 + 2008 --- Another remark : properly dealed with by gnumeric : when you type -A1^2 within gnumeric, the cell receives indeed -(A1^2) with parentheses added. It's the right 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 26755] Spreadsheet should not imp lement all of excels order of precedence for w orksheet operators. For example, in Excel =-X ^2 + B is not equal to =b - X^2.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=26755 --- Additional comments from [EMAIL PROTECTED] Tue May 27 21:45:36 + 2008 --- And, of course : the defect remains within OOo 2.4. Please correct this, it's a pity ! (we use OOo in our schools...) - 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]
