Issue 110037 - Calc: editing centered cells -> text misplaced and can not be edited in cell completely
Summary: Calc: editing centered cells -> text misplaced and can not be edited in cell ...
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.1
Hardware: Unknown Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2010-03-10 20:35 UTC by hardy314
Modified: 2013-01-29 21:38 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

small sample document (7.58 KB, application/vnd.sun.xml.calc)
2010-03-10 20:35 UTC, hardy314
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description hardy314 2010-03-10 20:35:18 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
Comment 1 hardy314 2010-03-10 20:35:51 UTC
Created attachment 68281 [details]
small sample document
Comment 2 Rainer Bielefeld 2010-03-11 06:50:03 UTC
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
Comment 3 Oliver Brinzing 2010-03-11 11:50:43 UTC