Bug 154569

Description:
I have a spreadsheet with a table of values which correspond to dates and a scatter chart to show them. I duplicated the sheet and set new dates on the new sheet but the scatter chart still shows the dates on the original sheet.
I have put a screenshot in my dropbox together with the actual .ods file.
Screenshot: https://www.dropbox.com/s/fd52dqg7s42d6l0/LibreOffice%20calc%20foible.jpg?dl=0
ODS file: https://www.dropbox.com/scl/fi/c656q2vllb1i1mqy581aj/Mike-s-BP.ods?dl=0&rlkey=2cnqoebmx82ctu5hb0jva3ecf

Note: I will also try to attach these files when the report has been submitted.

Steps to Reproduce:
1.Open the given .ods file
2.Double click on the scatter chart
3.Right click the chart and select "Data Ranges"
4.Notice that the X-Values are $'Tables 20230414'.$B$3:$B$16 and that these (highlighted) cells contain the dates from the 1st of April for two weeks whereas the X axis shows the 30th of September through to the 13th of October.

Actual Results:
X axis dates are shown incorrectly.

Expected Results:
X axis dates should be shown correctly.


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

Version: 7.2.7.2 (x64) / LibreOffice Community
Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2
CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: threaded