Bug 168368 - Help.LibreOffice Calc Charts now showing years as relative values and not whole years.
Summary: Help.LibreOffice Calc Charts now showing years as relative values and not who...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.1.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-09-11 20:26 UTC by Michael Jenkins
Modified: 2025-09-13 00:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Bug. Years only showing as relative numbers not 4-digit years. (23.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-09-12 05:58 UTC, Michael Jenkins
Details
Screenshot with 25.8.1.1 (307.84 KB, image/png)
2025-09-12 09:31 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Jenkins 2025-09-11 20:26:42 UTC
Description:
Hello.
Please help.
I love LibreOffice.

In the last two weeks,
I have been working hard in LibreOffice Calc,
and I have been creating Charts successfully,
with 'Years' being displayed correctly,
as 4 digit numbers, along the X-axis.
This was in LibreOffice 25.8.1.1.

Then, still in LibreOffice 25.8.1.1,
for an unknown reason, this evening,
when I create any Chart with my normal data,
the 'Years' only display as 2 digit relative values to the first year.

I have tried everything I know,
and the problem will not correct itself.

This is really distressing,
I really need my Charts to be correct,
without the correct 4 digit years,
my Charts won't make sense,
I am working on preparing,
to submit my article to a science journal,
with all my Charts.

This Error does not seem to be manually correctable,
and this Error seems to be LibreOffice,
deciding to do something automatically,
that is not wanted by the user,
that is beyond user control.

Please help,
this error is critical,
and really distressing.

I have been able to be really productive,
in LibreOffice recently.
I love LibreOffice.

Please Help.
Thank You.



Steps to Reproduce:
1. Create Table
2. Column A = 4 digit years
3. Column B = any sequence of numbers
4, Create Chart
5. In 'Data Range' select 'First columns as lablel'
6. Select Line Chart.
7. Select Finish.
8. View Chart.



Actual Results:
9. X-axis 'Years' appear as 2 digit relative numbers.
10. try again and again
11. Same fault always occurs

Expected Results:
12. X-axis 'Years' should be 4 digit years as in Column A.


Reproducible: Always


User Profile Reset: No

Additional Info:
Using Charts.
Charts are so important.
Comment 1 m_a_riosv 2025-09-11 21:37:14 UTC
Please better make your question in https://ask.libreoffice.org/c/english/5, where is easier to find help.

This site is about verify bugs in LibreOffice.

In any case Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Comment 2 Michael Jenkins 2025-09-12 05:58:21 UTC
Created attachment 202801 [details]
Bug. Years only showing as relative numbers not 4-digit years.

Thank you for your reply.
I am sure this is a bug.

Here is a sample spreadsheet,
with the bug appearing in the chart.

In the chart, the 4-digit years,
are only showing as relative numbers.
Comment 3 Michael Jenkins 2025-09-12 06:13:03 UTC
Hello.
Thank you for your help.

That problem appeared in LibreOffice 25.8.1.1

In order to test the problem,
I have just reverted to LibreOffice 25.2.0.3

I have just opened this attached file,
and in the same chart,
the years do correctly show as 4-digit years.

So, this is a bug in LibreOffice 25.8.1.1
in LibreOffice Calc.
Comment 4 m_a_riosv 2025-09-12 09:31:09 UTC
Created attachment 202802 [details]
Screenshot with 25.8.1.1
Comment 5 m_a_riosv 2025-09-12 09:34:00 UTC
Please test in safe mode, Menu/Help/Restart in Safe Mode
Comment 6 Michael Jenkins 2025-09-12 11:00:03 UTC
Yes, I have done that test,
I have restarted LibreOffice in Safe Mode,
and that did not solve the problem,
the problem still persisted.
Comment 7 m_a_riosv 2025-09-13 00:13:06 UTC
Looks really strange, that number is not a date, so except there is something changed in your file, I can't think about anything going to the issue.