Issue 94563 - row height for formula cell doesn't adapt automatically if content in referenced cell changes
Summary: row height for formula cell doesn't adapt automatically if content in referen...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2008-10-02 05:42 UTC by plish
Modified: 2013-01-29 21:43 UTC (History)
3 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description plish 2008-10-02 05:42:26 UTC 
Highlight entire sheet and make format such that text wordwraps.

A1 will be our main cell.  In A5 type =A1.

Type text into A1 that overflows.  A5 will not grow to wordwrap.  If A5's text 
is locked to the top, the bottom will get cut-off. If locked to the bottom then 
the tp will get cut-off and if centered, the top and bottom will get lost.

Page preview then shows an entirely different view with A1 looking ok but A5 
still being different.

Click on the bottom of a5 and it opens to enclose entire text but additional 
text in A1 will not show up in a5 again.
Comment 1 Regina Henschel 2008-10-02 11:22:19 UTC 
The problem is in the row height not in the word wrap. I change the summary
accordingly.

As described, when the cell content of A1 increases or decreases, the row height
of the formula cell is not adapted. Even an hard recalculate will not adapt the
row height.
You have to reformat with "optimal height" or reassign a style to adapt the row
height to the content.

If it is not seen as defect, it would be at least an useful enhancement, that
row height is adapted automatically in rows where row height is not set hard but
in "optimal height" mode.
Comment 2 Rainer Bielefeld 2010-02-01 08:16:54 UTC 
Reproducible with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]"!
Row height has been adapted in MY 2.4.1 WIN XP (so I am astonished that reporter
saw that in 2.4.1), so regression.
This defect makes word wrap completely unusable, that's a serious problem 
I see it as a blocker for 3.3, but with "Ooo-Dev 3.3.0 multilingual version
English UI WIN XP: [DEV300m70 (Build 9478)]" I can't reproduce that problem any
longer.

@regina:
do you still see that problem in the latest versions?
Comment 3 dhlocker 2010-03-09 17:40:09 UTC 
Adding a vote - OOo 3.2.0, (OOO320m12 (Build:9483); Windows XP If all rows are
set to "Optimal Height" Add: 0.0; "Default Value" checked, Format a number of
cells to Number: Decimal Places 2 (was Decimal Places 3) causes a number of the
affected rows to grow in height.  Most disturbing.  I think this is the same
issue, but it could be independent.