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 +0000 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