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.
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.
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.
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.
Created attachment 202802 [details] Screenshot with 25.8.1.1
Please test in safe mode, Menu/Help/Restart in Safe Mode
Yes, I have done that test, I have restarted LibreOffice in Safe Mode, and that did not solve the problem, the problem still persisted.
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.
I recreated the chart within the file per how the existing was done and I didn't see any problem even then. Michael: this report is missing your version information. Please copy and paste here the content of your Help - About (LibreOffice - About on macOS) by clicking the copy button. This allows us to know more about your system. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the information. Arch Linux 64-bit Version: 26.8.0.0.alpha0+ (X86_64) Build ID: d30a759567c437b501101099fc3786ea87691e15 CPU threads: 8; OS: Linux 6.18; UI render: default; VCL: gtk3 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: CL threaded Built on 17 January 2026
Created attachment 205104 [details] Five Global Warming Datasets with Graphs. This is the LibreOffice Spreadsheet file, that I was concerned about.
Hello M A Riosv. Hello Buovjaga. Thank you so much for your kind replies. I am now in LibreOffice 25.2.0.3 Happily, I have just tested my LibreOffice Spreadsheet file, and the four digit years do display correctly, thank you ! Best wishes, Michael.
(In reply to Michael Jenkins from comment #10) > Thank you so much for your kind replies. > I am now in LibreOffice 25.2.0.3 > Happily, I have just tested my LibreOffice Spreadsheet file, > and the four digit years do display correctly, thank you ! Aha, but in your comment 3 you said the problem was seen in 25.8 and not in 25.2. I looked at your new file and checked all the charts by using the Navigator in 25.8, but everything seemed fine.
Wow, thank you Buovjaga, yes, I see what you mean, I think I reverted to 25.2, to avoid the apparent problem in 25.8, I may now have to update for 25.8. I have just donated £10 to LibreOffice.
[Automated Action] NeedInfo-To-Unconfirmed