https://bugs.documentfoundation.org/show_bug.cgi?id=151800
Bug ID: 151800
Summary: Chart won't display correctly if data is a named range
Product: LibreOffice
Version: 7.4.2.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I created a chart in Excel that uses named ranges for the data (dates and
corresponding values). The named ranges are defined in Name Manager using an
OFFSET formula with reference to a cell in which the user can enter an end date
for the chart. In Excel, you can change the date in that input cell and then
the chart with update accordingly and only show dates and values up until that
input date. In Calc however it doesn't work and just displays the chart the way
it last looked in Excel without the possibility of changing the range of data
shown.
Steps to Reproduce:
1. Create new file in Excel.
2. Create one column with dates (B4:B27) and one column with values (C4:C27).
3. Add a date in cell C1. This is supposed to be an input for the user, with
the description: "only show data until: [C1]"
4. In Excel's name manager, create two data ranges called value_range and
date_range. They are defined as
=OFFSET(Sheet1!$B$4,,,COUNTIF(Sheet1!$B$4:$B$27,"<="&Sheet1!$C$1)) for the
dates and =OFFSET(Sheet1!$C$4,,,COUNTIF(Sheet1!$B$4:$B$27,"<="&Sheet1!$C$1))
for the values. In other words, value_range and date_range include all the
dates and their corresponding values that are smaller or equal to the date
entered by the user in C1.
5. Create line diagram. Create new series where the data is Sheet1!values_range
and the axis labels are Sheet1!date_range. Now, the user can change the end
date in C1 and the chart will only show the data until the chosen end date.
6. Save file as .xlsx
The diagram works in Excel, but not in Calc.
Actual Results:
In Calc, the diagram will not update. It will appear the same way Excel last
displayed it but won't update when the date in C1 is changed.
Expected Results:
Diagram should update when date in C1 is changed, like it does in Excel.
Reproducible: Always
User Profile Reset: No
Additional Info:
Test file and screenshots from both Excel and Calc can be found here:
https://www.dropbox.com/sh/ssoeoucg2s2ytb5/AAAhD8uFp9gE3BH00H4dBTCoa?dl=0
--
You are receiving this mail because:
You are the assignee for the bug.
