https://bugs.freedesktop.org/show_bug.cgi?id=85493
Bug ID: 85493
Summary: In diagrams of type "Line", point tips are wrong when
Calc needs to sort the values of the "Range for Name"
cells
Product: LibreOffice
Version: 4.3.2.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 108476
--> https://bugs.freedesktop.org/attachment.cgi?id=108476&action=edit
A calc sheet reproducing the issue
Problem description:
When you make Calc generate a diagram of type "Line" from 2 data sets (one for
the X axis, the other for the Y axis), Calc sorts the dataset values, based on
X-axis values (ascending order), before displaying them in the diagram. For
example, if the X-axis values are dates, these dates are sorted so that the
diagram shows value in chronological order.
This is a nice feature, incidentally.
However, when you double-click on the diagram and let the mouse on one of the
curve points, a tip shows up, but this tip gives wrong information if the
X-axis values in the source range needed sorting before being displayed the
diagram (actually, information given is not erratic, it just relates to the
wrong cell in the source cell range).
How to reproduce the issue:
- Open the attached Calc document. It contains 4 sheets with the very same
data, sorted in a different way each; every sheet also contains a diagram of
type "Line" showing up these data graphically. Note that all 4 diagrams are
strictly identical, since data are identical (though they are sorted with
different criteria every time).
- Select any of the "... -- KO" sheet.
- Double-click on the diagram.
- Let the mouse over any point of the curve, et look at the tip info.
Every sheet in the attached Calc document also gives 3 examples of points, with
their expected and actual tip texts.
Expected result:
The tip over any point in the diagram should take into account the fact that
values were sorted when generating the diagram. Which means that the 1st point
on the left in the diagram may not be the value of the 1st cell in the source
cell range; the 11th point from the left in the diagram may not be the value of
the 11th cell in the source cell range; and the last point on the right in the
diagram may not be the value of the last cell in the source cell range.
Note: As a reference, I also added a sheet in the attached spreadsheet, named
"Ascending Date -- OK", which shows that point tips are OK when the data are
already sorted in ascending order in the source cell range.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
