Bug 151800

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