Issue 43818

Summary:	Validity/Input Help Does NOT Work With Merged Cells
Product:	Calc	Reporter:	rostrow <rostrow>
Component:	formatting	Assignee:	AOO issues mailing list <issues>
Status:	CLOSED NOT_AN_OOO_ISSUE	QA Contact:
Severity:	Trivial
Priority:	P4	CC:	issues, rainerbielefeld_ooo_qa
Version:	680m79	Keywords:	oooqa
Target Milestone:	---
Hardware:	PC
OS:	Windows 2000
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description rostrow 2005-03-01 19:45:38 UTC

Validity/Input Help does not work with merged cells.

1. Create a merged cell consisting of cells A5:F5.
2. Create a border around the merged cell (makes it easy to see the cell).
3. Select the merged cell.
3. Data/Validity/Input Help - Click "Show input help when cell is selected" box,
enter a title message and click OK button to close the dialog.
4. Now when you click on the merged cell it will display the title message.
5. Horizontally scroll the sheet to the right so the first column of the merged
cell (A) is off the screen.
6. Now try clicking on the merged cell. The note will not appear.

Comment 1 rostrow 2005-03-02 04:37:33 UTC

It does work correctly for merged cells when they are scrolled off the right
edge of the screen. The Title Message stays visable, hugging the right edge,
untill the left end of the merged cells disappears past the right edge of the
screen.

Comment 2 fengmake 2005-03-05 05:42:40 UTC

*** Issue 43953 has been marked as a duplicate of this issue. ***

Comment 3 fengmake 2005-03-05 06:05:07 UTC

OS: Windows XP Professional SP2
OOo: 2.0 Beta RC

Steps to Duplicate:

1) Merge several cells in a row.
2) Select the merged cell and select Data | Validity... from the menu.
3) Click on the Input Help tab. Check the "Show input help when cell is
selected." option.
4) Enter a Title and Input help. Click on OK.
5) The help text should display.
6) Scroll the columns to the left. Note that once the first cell scrolls off the
screen the help prompt disappears. Selecting another cell and then the merged
cell again does not redisplay the help text.
7) Scroll the columns to the right. Once the first cell redisplays, the help
text does not reappear even though the cell is still selected.
8) Click on the cell again. The help text reappears.

Mark

Comment 4 frank 2005-03-23 10:11:57 UTC

Sorry, but it's not a defect.

MS Excel works in the same way, not exactly but they do scroll the input help
out of sight, just a bit later.

So re-flaged as enhancement and re-assigned.

Frank

Comment 5 ace_dent 2008-05-16 00:40:13 UTC

OpenOffice.org Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 3 years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
http://download.openoffice.org/index.html
or consider trying the new OOo 3 BETA (still in testing):
http://download.openoffice.org/3.0beta/
 
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
http://www.openoffice.org/issues/query.cgi
 
Many thanks,
Andrew
 
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
http://marketing.openoffice.org/3.0/announcementbeta.html

Comment 6 Rainer Bielefeld 2014-04-06 08:45:03 UTC

This has nothing to do with merged cells, but help vanishes when scrolling, so that in particular cases (if help appeared outside visible sheet area) it might not become visible at all.

To avoid misleading information in comments I will submit a new issue after check for DUPlicates.