https://bugs.documentfoundation.org/show_bug.cgi?id=154569
Bug ID: 154569
Summary: Scatter chart has incorrect X axis
Product: LibreOffice
Version: 7.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
