Issue 27337 - backgrounds are not full expanded when editing a "oversized" formula
Summary: backgrounds are not full expanded when editing a "oversized" formula
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-04-01 20:04 UTC by norbert2
Modified: 2004-05-07 11:35 UTC (History)
1 user (show)

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

Attachments
background_formula-edit.sxc (5.27 KB, application/vnd.sun.xml.calc)
2004-04-01 20:05 UTC, norbert2 		no flags Details
background_formula-edit.png (116.34 KB, image/png)
2004-04-01 20:06 UTC, norbert2 		no flags Details
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 norbert2 2004-04-01 20:04:47 UTC 
I have attached a spreadsheet and a screenshot.

- Please open the attached spreadsheet.
- double-click the green cell:
As you can see the is enlarged to the next cell. That's OK, because its content
is too long for the cell-width. But If you look exactly at the right side of the
green area, you can see that there is a white-line at the end of the green area.
If you remove the "=", so that it is not handled as formula anymore, the green
areas has crorrect width.

I also have attached a scaled screenshot to show the (minor) problem.
Comment 1 norbert2 2004-04-01 20:05:15 UTC 
Created attachment 14262 [details]
background_formula-edit.sxc
Comment 2 norbert2 2004-04-01 20:06:19 UTC 
Created attachment 14263 [details]
background_formula-edit.png
Comment 3 norbert2 2004-04-01 20:13:40 UTC 
A typing error:

"As you can see the is enlarged"

should be

"As you can see the _cell_ is enlarged"
Comment 4 frank 2004-04-02 08:10:26 UTC 
Hi Norbert,

sorry, but I close this as wontfix because the effort to fix this does in no
case match the outcome.

Frank
Comment 5 frank 2004-04-02 08:10:50 UTC 
closed wontfix
Comment 6 norbert2 2004-04-03 15:04:31 UTC 
(I forgot to mention that just removing the "=" does not remove the white line.
You also have to confirm and re-doubleclick the cell, in order to remove the
white pixels.)
This means that the problem only happens if the expanding of the background is
done, while the content of the cell is a formula (with "=").
Comment 7 norbert2 2004-04-03 15:18:50 UTC 
Mistake in last comment:

The sentence ...
"This means that the problem only happens if the expanding of the background is
done, while the content of the cell is a formula (with "=")."

... of my last comment seems not to be correct:

The problem seems to be more strange:

If you delete a cell's formula and confirm and the re-enter anything without
"=", the white line also appears!
That means that Calc "remembers" if the cell has once been a formula!!!
Comment 8 norbert2 2004-04-03 21:10:08 UTC 
I meaned "and then re-enter" instead of "and the re-enter".
Comment 9 norbert2 2004-05-07 11:30:11 UTC 
This problem does not happen if the cell has centered-format applied!
Comment 10 norbert2 2004-05-07 11:30:51 UTC 
Sorry, a mistake in my last comment:

This problem does not happen if the cell has right-alignment applied!
Comment 11 norbert2 2004-05-07 11:35:48 UTC 
(You may also have a look at issue 28894.)