[sc-issues] [Issue 73766] Drag cell in formula edit mode changes address to range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766 --- Additional comments from vso...@openoffice.org Sun Apr 19 15:38:44 + 2009 --- mlaakso, In my system, Ver 3.0.0 OOO300m9 Build 9358 on Windows XP home edition Ver 5.1, the references change when I press the Enter key. Is it beacause I am using Windows and perhaps you are using Linux? I am not able to give an answer. Vicente Soler - 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 73766] Drag cell in formula edit mode changes address to range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766 --- Additional comments from vso...@openoffice.org Sun Apr 19 07:23:19 + 2009 --- mlaakso, Folowing your example, when I drag the formula in A4 from A1 to A2 I get "=A$2:A2" while in edit mode, and "=A$2:A$2" after pressing the Enter key, which returns the value "2". When I copy down A4 to A5...A10, since my formula is 100% absolute "=A$2:A$2" I get the value "2" all the time. However, I'm afraid that's not what mlaakso obtains since he says everything is screwed up. My conclusion is that somewhere there has been a change betweeen builds, and the behaviour has changed. But the bug is not fixed. I am using Ver 3.0.0 OOO300m9 Build 9358. - 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 73766] Drag cell in formula edit mode changes address to range
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73766 --- Additional comments from vso...@openoffice.org Sat Apr 18 05:44:50 + 2009 --- Thank you Isaac Marcos for your very clear example. However, I do not get exactly the results that you explain in your note. When I edit cell D10, using key F2, and I move reference $AE$5 up to cell AE2, then I get $AE$2:AE2. However, and I find it a very severy error, when I confirm the formula with the Enter key, the reference is changed AUTOMATICALLY, WITHOUT WARNING NOR LOGIC to $AE$2:$AE$2. The problem still persists, but it is of another nature. I am using Ver 3.0.0 OOO300m9 Build 9358. - 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 92402] SUMPRODUCT fails some calc ulations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92402 --- Additional comments from [EMAIL PROTECTED] Sun Aug 3 07:10:25 + 2008 --- I understand that the ODF specs do not allow you to change the definition of the SUMPRODUCT function. However, now that you suggest an alternative formula for the OOo calculation, that Excel does not like, I can provide you with one formula that Excel likes: =SUMPRODUCT(MMULT(($A$2:$A$4=$A$9)*1;($B$1:$D$1=$A$10)*1)*$B$2:$D$4) I just added the '*1' factors to the logical vectors so that Excel could make the calculation. So we found one compatible formula!!! - 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 92402] SUMPRODUCT fails some calc ulations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92402 --- Additional comments from [EMAIL PROTECTED] Sat Aug 2 12:36:59 + 2008 --- Created an attachment (id=55506) Example for issue 92402 - 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 92402] SUMPRODUCT fails some calc ulations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92402 Issue #|92402 Summary|SUMPRODUCT fails some calculations Component|Spreadsheet Version|OOo 2.4.0 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|vsoler --- Additional comments from [EMAIL PROTECTED] Sat Aug 2 12:29:55 + 2008 --- The SUMPRODUCT function in Excel is the most magical function I have come across. It can perform array-like calculations without forcing the formula with Crtl-Shift-Enter. A B C D 1 X Y X 2 a 1 6 3 3 b 3 4 1 4 a 5 8 2 In Excel, SUMPRODUCT((A2:A4="a")*(B1:D1="X")*B2:D4) yields 11 The same formula in Calc yields 1 There is no simple workaround for this problem, except setting up an Excel model different from the calc one. Could calc adapt to the behaviour of Excel? IMHO it's a must - 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 82354] Datapilot unable to fetch data from Base in reasonable time
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82354 Issue #|82354 Summary|Datapilot unable to fetch data from Base in reasonable | time Component|Spreadsheet Version|OOo 2.3.0 RC1 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|vsoler --- Additional comments from [EMAIL PROTECTED] Sun Oct 7 13:33:59 + 2007 --- It's a great idea that you can query a Base database from Calc using the Datapilot. However, in Win XP, the process takes ages and hangs up. I am obliged to close the Calc program after waiting, say, 10 minutes, with Ctrl-Alt-Del. When I'm in my office, using Win NT or Win 2000, it is terribly slow, but it works. Improving performance, IMHO, is a must. Regards - 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]
