[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 isaacmar...@openoffice.org Sun Apr 19 23:47:16 + 2009 --- @ sparcmoz point (1) and (3) (only drag part) confirmed here, same behavior. points (2) and (3) (point and click) should be dealt with in a different report, IMO. @ mlaakso I agree with your description. The initial problem description reads "Drag cell in formula edit mode changes address to range", I understand that "drag" to mean moving the colored cell with the mouse, and the problem to be related to a change to RANGE. Is there a different description we should be using? - 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 isaacmar...@openoffice.org Sun Apr 19 19:37:05 + 2009 --- Please, we should focus on the main problem.!!! The basic problem is a process, component, that changes a simple reference to a range reference. As a wild guess, perhaps someone tried to solve the issue working on the way absolute references are managed, and that activates sometimes or not. But the real problem here to solve is why when the colored cell is moved, it changes the cell reference to a RANGE. If that ERROR were to be solved, the other problems would simple not happen. Anyone knows: Who is responsible to work on 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: 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 isaacmar...@openoffice.org Sat Apr 18 10:21:59 + 2009 --- > Thank you Isaac Marcos for your very clear example. YW. > When I edit cell D10, using key F2, and I move reference $AE$5 up to cell AE2, > then I get $AE$2:AE2. Same here, that's the issue a several people have voted for!! > 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. If that hapens to you, that's a different item, But: Why the value is changed to a RANGE in the first place. That is the root of the problem > The problem still persists, but it is of another nature. JMO, is the same base problem, a reference changed to a RANGE with an additional twist in your case. > I am using Ver 3.0.0 OOO300m9 Build 9358. Sorry, I should have reported my version: Ver 3.0.1 000300m15 9379 (Debian OS). But as it has been reported by so many people for more than TWO years, that it should be quite irrelevant. It has been happening for a long time, and still does. - 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 isaacmar...@openoffice.org Fri Apr 17 19:14:51 + 2009 --- Created an attachment (id=61651) A long example on 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 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 isaacmar...@openoffice.org Fri Apr 17 19:13:11 + 2009 --- This bug has more than a Year!!! I am writing this in an effort to help developers better understand of how important this is. «Background» Edit the contents of a cell is the most basic and, by large, the most common task any user performs in a worksheet. Anything that needs to be changed is done by a "editing a cell". Many Calc users just look at the graphs, or read the results of a worksheet, but any "power user" would do some sort of change in the worksheet. For those users, any mistake on the edit process could have far reaching effects. «The problem» This specific problem is related to how a cell reference is interpreted by the application. It could be said that a direct cell reference (i.e. D6), an absolute cell reference (i.e. $D$6) and a range of "one cell" (i.e. D6:D6 direct or absolute) point to the same cell. And any of those references would give the same result when used in a cell. While yes, that's correct, this is not what this Issue is really about. The problem becomes a real issue when those references are copied to other cells. That's a common procedure to make formulas in several cells do the right thing. Edit once, copy many, is what I like to call this concept. «An example of the problem» 1.- Open the attached File. On cells C10:D19 there is an empty RED space to work the example. There are some more cells bellow to help understand what happens. 2.- Fill down (copy cells C10:D10 down) up to cells C19:D19. There will be a mistake on cells D13, D16 and D19. The correct result should be what is in cells C23:D32. 3.- Edit cell D10. The reference to AE5 is incorrect. While editing cell D10 move the reference (with the mouse) to cell AE2. The reference should change to $AE$2:AE2. 4.- Fill down C10:D10. A different error is in cells D13, D16, and D19. e.g. The referenced cell $AE$2:AE2 changes to $AE$2:AE5 at cell D13. That breaks the "edit once, copy many" sequence!! The cell D10 needs to be re-edited to erase the incorrectly added part AE2. The correct formula has been set up in C23:D23 for you to try how it should work correctly. Any user that depends on copying formulas to several cells would have problems with this bug. Any power user would be bitten by this bug. Hope this helps. - 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 28779] problem when editing cells that need to be expanded to overlap merged ce lls
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=28779 --- Additional comments from isaacmar...@openoffice.org Fri Apr 17 17:37:35 + 2009 --- Is this issue from 2004 being "look into" by anyone? A P3 defect that's been so lng forgotten does not speak well of the effort to improve OO. Does anyone have an idea of what is being done to solve this? - 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 100624] Allow to switch off "Edit in Cell"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100624 User isaacmarcos changed the following: What|Old value |New value Summary|Allow to siwtch off "Edit |Allow to switch off "Edit |in Cell" |in 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: 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 100624] Allow to siwtch off "Edit in Cell"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100624 User isaacmarcos changed the following: What|Old value |New value Priority|P4|P3 - 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 100624] Edit in Cell.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100624 --- Additional comments from isaacmar...@openoffice.org Sat Mar 28 04:34:08 + 2009 --- Created an attachment (id=61235) Edit in place 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: 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 100624] Edit in Cell.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100624 Issue #|100624 Summary|Edit in Cell. Component|Spreadsheet Version|OOo 2.4.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|editing Assigned to|spreadsheet Reported by|isaacmarcos --- Additional comments from isaacmar...@openoffice.org Sat Mar 28 04:32:17 + 2009 --- "Edit in Cell" as the only option is WRONG. There is a basic problem with the edit in cell concept. Background: I have extensive experience in all worksheet programs. From SuperCalc64, Lotus, Excel, etc. All of them, as Open Office Calc (OOC) does, include an edit line in the task-bar (called formula bar in OOC), to provide space for editing formulas and text included in a cell. It was provided as a means to be able to edit cells that contained data bigger than the actual size of the cell. In the beginning, the cell was edited in place, but never covered other cells, it was limited to the size of the cell itself. That was a problem at the time as editing a long formula while being able to see only a small part of it was quite tricky. Long time ago as well, the idea of an edit bar was incorporated to the spreadsheets to ease the pain with long formulas. It improved with time to allow editing formulas with more than one line. Later, the idea of "editing in cell" was introduced as an improvement. It intended to make easier for users to see what they were editing. It came with an option to disallow it globally, which was available in the edit options. I always choose to disallow it. Now, OOC has "edit in cell" as the only metod available. As I get easily into complex and long formulas, I really need to use the edit bar for what it was created, not this "edit in place" concept that covers the formulas I am trying to edit. Problems it creates: Mainly, the cell contents itself cover the other cells making it, once again, awkward to edit long formulas. Also, if all cells are being edited in place, what's the need for a formula bar? It does help with short text or short formulas, as it is easier to see the changes in place. A possible workaround in OOC: Move the cell to an empty space, where the text/formula of the cell could expand freely. Very annoying to move the cell out to edit, and move it back to where it was. Steps to reproduce: 1.- Open the attached worksheet. 2.- Edit any blue cell (F2, double click, click on the edit bar). 3.- The last referenced cell is blocked by the editing window. Note: I can provide many more "real" examples of how anoying this "feature" is. Recomended action: Provide a way to disallow this editing window, if needed. - 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
