Apache OpenOffice (AOO) Bugzilla – Issue 8793
Allow manual line breaks to be inserted in the Input line
Last modified: 2013-08-07 15:12:27 UTC
1. Open a blank spreadsheet 2. Enlarge a cell, and then type text into it with a manual line break (using ctl+enter) in the middle. 3. Go to another cell, and type the same text, without the line break. Move on to another cell. 4. Go back to cell #2, and try to re-edit it and add a line break in the middle using the input line on the top. You cannot do it; ctl+enter just skips you to the same cell. 5. Double-click cell #2, and edit it "in the cell". You will now be able to enter a manual line break. 6. Go back to Cell #1. Notice that, on the input line, there is no character to indicate the position of the manual line break. See? Not broken, but confusing as all-get-out. Proposed resolution: 1. ctl+enter in the input line should create a manual line break in the cell. 2. On the input line, some special character should indicate the location of a manual line break, such as the Paragraph mark. Thanks! -Josh Berkus
Josh, thank you for your comments and suggestions. Please create a new issue for your second comment about displaying non-printing characters. User summary Manual Line Break Behaviour is Inconsistent
Hi Falko, should be considered. Peter
*** Issue 19551 has been marked as a duplicate of this issue. ***
.
Ermm, sorry but I consider this behaviour completely OK. If one is in the edit field than there is no feed back that there will be a line wrap (opposed to editing directly in the cell itself). This I find this OK.
closed
Falko, YOU may not find it a problem, but 3 end-users I spoke to did. Anywhere in OOo where behavior is inconsistent is a usability problem. Remember, our goal is to make OOo BETTER than MS Office, not "almost as buggy as". I will also point out that this bug has been reported more than once, so I'm not the only person to notice it. Anywhere in Calc where MS Excel does a better job than us of usability is something to look hard at, not something to dismiss as "us folks in Hamburg don't have a problem with this." Of course YOU don't find it confusing; YOU programmed it! If you're swamped with little bugs like this, then fine, put it in the holding list. But don't dismiss a serious usability issue as non-existant just because you don't personally care. -Josh
Well I have not programmed it. And yes, there hase been ONE marked duplicate. But I do not see ANY votes here. Apart from (if you like it or not!) the behaviour of MS Office is what have to aim on. We must make transition/migration easy for those willing to switch. And they get the top priority.... Whether Quattro Pro nor Excel bahecve they way you want to have it.
Falko, I checked ... MS Excel 97 does *not* allow manual line breaks in cells *at all*. I have been unable to borrow a copy of 2000 or XP to test. If manual line breaks is a feature that Calc has and Excel doesn't have, then your argument about compatibility is moot. However, the lack of votes for the issue is still a valid objection. Please comment. Thanks! -Josh
*** Issue 28228 has been marked as a duplicate of this issue. ***
I agree agliodbs. This is why I have entered Issue 28228, that has been marked as duplictae of this issue.
FT: I am sorry, I wrongly closed this issue due to misunderstanding: What I propose: Enable line break also in edit line mode. Do it visually by entending the edit line to the down direction (for similar behaviour look at MS Excel XP)
FT: Changed target and owner
*** Issue 29500 has been marked as a duplicate of this issue. ***
May be I'm wrong adding the following to this issue, but there are certain relations: It should be possible to insert a manual line break by functions, to use it f.e. within a string that ist built by CONCATENATE() Claudia
*** Issue 40651 has been marked as a duplicate of this issue. ***
This is a duplicate of 13870 which was marked as WON'T FIX. So I would assume that this won't be fixed either. Marking as a duplicate. *** This issue has been marked as a duplicate of 13870 ***
Created attachment 37655 [details] line breaks in formulas
The Issue you raised has been marked as 'Resolved' and not updated within the last 1 year+. I am therefore setting this issue to 'Verified' as the first step towards Closing it. If you feel this is incorrect, please re-open the issue and add any comments. Many thanks, Andrew Cleaning-up and Closing old Issues ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
As per previous posting: Verified -> Closed. A Closed Issue is a Happy Issue (TM). Regards, Andrew