The one long term open bug that irks me the most is that you cannot properly date-format the x-axis of scatter plots in LibreOffice:
https://bugs.documentfoundation.org/show_bug.cgi?id=54132
12 years old. According to the comments, fixing it is discouraged as the code is so "horribly complicated", it would likely cause regressions.