Issue 28648

Summary: cell-reference-fields: blue borders are not always displayed
Product: Calc Reporter: norbert2 <norbert.notz>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.1Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description norbert2 2004-05-03 11:33:16 UTC
Please ...

- open an new spreadsheet

- open the goalseek-window: The cursor is in the edit-field of "Formelzelle" 
(german version

- click any cell:

The reference input is added and gets a blue border. This is OK.

Now ...

- switch to the second (or any other) sheet

- do the same as described above:

Now blue border is shown around the referenced cell!
Comment 1 norbert2 2004-05-03 11:34:02 UTC
typing error:

"Now" -> "No"
Comment 2 flibby05 2004-05-03 13:10:53 UTC
hello norbert,
i cannot reprocude this with 1.1.2RC as here indeed a blue border is printed.
what could i be doing differently from your description?
Comment 3 norbert2 2004-05-04 06:36:12 UTC
Hi Max,

I forgot to mention, that it is important to close the goalseek before 
switching to a sheet other then 1.

You have to open the goalseek while already beeing in sheet 2 or greater ...
Comment 4 flibby05 2004-05-04 09:49:11 UTC
confirming behaviour with 1.1.2RC
Comment 5 frank 2004-05-04 09:52:02 UTC
Hi Niklas,

one for you

Comment 6 frank 2004-05-05 10:21:42 UTC
Due to time problems this is re-targeted to OOo2.0
Comment 7 norbert2 2004-05-10 12:56:33 UTC
better secription of the problem:

For sheet numbers >1:
The blue border is only shown for reference-cells to sheets other than the 
sheet where the goalseek has been opened.

(I correct the summary.)
Comment 8 norbert2 2004-05-10 12:57:06 UTC
Comment 9 norbert2 2007-08-16 20:58:54 UTC
This is NOT a goalseek specific issue. Other windows are affected, too.

But the bug behaves inconsistent for the different windows that use

The "Function Wizard" is affected by this bug, too, like the goalseek.

"Edit Print Ranges" never shows blue borders:
"Edit Print Ranges" opened from a sheet >1 (sheet#2 or higher) does not show
blue borders, ALTHOUGH the inputs are from the same sheet. (cannot be from other

"AutoFormat Chart" is not affected by the bug:
"AutoFormat Chart" seems to be the only window where blues borders are always
shown. Idependent from which sheet it is opened and to which sheet the
references are pointing.

Corrected summary.
Comment 10 Marcus 2017-05-20 11:13:43 UTC
Reset assigne to the default "".