Issue 77232 - new Chart: Range selection shows deselected range
Summary: new Chart: Range selection shows deselected range
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: new_implementation
Depends on:
Reported: 2007-05-11 08:51 UTC by kla
Modified: 2017-05-20 11:28 UTC (History)
4 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description kla 2007-05-11 08:52:00 UTC
follow up issue for i75307
Take a spreadsheet with some data rows and columns e.g.  A1:F6.
Now mark A1:F6. Hold Ctrl down and deselect B1:B5.( Not the whole column) Start
Chart wizard. Notice, that nothing is shown in the starting preview.
Comment 1 kla 2007-05-11 08:53:05 UTC
set Keyword
Comment 2 IngridvdM 2007-05-11 09:13:10 UTC
The chart is created from the selected range, but no range string is shown in
the data range field of the data range tab page. -> Björn, please have a look.
Comment 3 bjoern.milcke 2007-07-30 15:14:28 UTC
Looking at lcl_detectRanges() I found out that for a range like this:

*   * *
*   * *
*   * *
* * * *

is split up like this:

A    C   D
A    C   D
A    C   D

I.e., range B consists of two cells which are "in rows", therefore the
splitting-direction (DataRowSource) is ambiguous.

->NN: This only appears for a de-selection where you leave just one cell in a
column like in the example. It is not a very common example, I think. So, I
would only fix this if there is a somewhat obvious fix that does not wreck other

Maybe range B could be detected to be only one cell, and not yield an ambiguous
state in this case, but count as "don't care", because all sub-ranges have "data
in columns" and only one is undecided. This is not really ambiguous (in contrast
to a complete range that only consists of one cell).

Maybe a query like this would solve the situation, once range "B" is only one cell:

                if( !bRowDiff && !bColDiff )
                else if( bRowDiff && ! bColDiff )
                else if( bColDiff && ! bRowDiff )
                else if( bRowDiff && bColDiff )
                    bRowSourceAmbiguous = true;

                if( (nDataInRows > 0 && nDataInColumns) > 0 || nUndecided > 0 )
                    bRowSourceAmbiguous = true;
Comment 4 Martin Hollmichel 2007-09-12 13:07:44 UTC
move to 3.x target according to
Comment 5 Marcus 2017-05-20 11:28:09 UTC
Reset assigne to the default "".