Apache OpenOffice (AOO) Bugzilla – Issue 110037
Calc: editing centered cells -> text misplaced and can not be edited in cell completely
Last modified: 2013-01-29 21:38:41 UTC
This happened with Calc in OO3.2 on WinXP. I will attach a small sample document for quicker reproduction of the behavior. What you need is * a new calc document * increase the width of the first column to something like double the default * enter some text into a cell in the second column * change the text property of this text to 'centered' alignment * now double-click into the text of this cell and add some more text into it. -> Beginning with a certain amount of text, the displayed text will hop to the left side. :( The problem with this is, that this hopping of the text makes it impossible to mark some of the text with the mouse. Once you try to click it you will hit the neighbor cell and finalize the editing. A nicer behavior would be to * keep the text centered during editing, so that there is no difference between the layout during editing (compared to the layout after editing) * stay in editing mode if someone clicks into the edited text (directly in the cell), even if this text is currently displayed on top of a neighboring cell. Surely there is a workaround: you can just limit yourself to keyboard commands while editing the text. But this seems unsatisfactory to me. Also, I am used to the nicer behavior (as suggested above) from MS Excel (97). So the user unfriendly behavior of Calc also bluntly contrasts to this expected behavior.
Created attachment 68281 [details] small sample document
Reproducible with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]", "Ooo-Dev 3.3.0 multilingual version English UI WIN XP: [DEV300m73 (Build 9456)]", "2.4.1 Multilingual version English UI WIN XP: [680m17(Build9310)]". Worked fine with "1.1.4 (German) WIN XP: [645m52 (Build 8824)]" So it seems that problem started with OOo 2 I can live with the "hop to the left", but that I can't reach text left from cell border is really annoying. You will always see this problem with editing for text aligned to the right, text that exceeds left cell border can not be reached using mouse pointer. I believe that that behaviour is the same for all OS, but currently it's only reproduced with WIN XP. Modified Version to first one for what problem is proved. So my wish: for cell contents that is not aligned to the left please restore edit in cell behaviour as known from OOo 1.1 I can't believe that there is no other earlier report for this, but I was not able to find one
.