Why do my libreoffice calc tables look differently after update (changed column widths)?

bluenote10

5/20/23, 7:59 PM

I'm on Ubuntu 18.04 and I haven't used libreoffice in approximate a month. Now after loading a file in calc I noticed that the table looks completely different than it looked before. The most notable difference is that the column widths have changed. This is immediately obvious, because now most numbers are shown as ### which indicates that the value doesn't fit into the column anymore. I have a huge number of columns, and I spend a very long time finding nice column widths for each of them to fit the majority of the numbers. I also have many files, and they are all broken now. All the work seems to be messed up now :(. I'm maintaining these files for ~3 years, and they looked the same until I last opened them roughly a month ago.

Things I can rule out to explain the change:

My .xlsx files are committed to git, so I can guarantee that they haven't changed.
I also haven't changed anything in terms of font setup.

However I opened my regular dependencies a few days ago, which may have involved an update to libreoffice. I'm on version 6.0.7.3 now, build ID: 1:6.0.7-0ubuntu0.18.04.10.

My questions are:

Any ideas what has changed inside libreoffice that could explain the change?
Is there any way to revert the change of column widths e.g. by changing a file mode setting or so, instead of having to fine tune all these column widths again manually?

Any help would be greatly appreciated.

0 + 0

libreoffice

bluenote10

5/22/23, 10:55 AM

Perhaps there is a connection to [this bug](https://ask.libreoffice.org/t/in-calc-the-column-width-changes-after-i-save-a-file/14307)?

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Why do my libreoffice calc tables look differently after update (changed column widths)?

TH: เหตุใดตารางคำนวณ libreoffice ของฉันจึงดูแตกต่างออกไปหลังจากอัปเดต (เปลี่ยนความกว้างของคอลัมน์)

RO: De ce tabelele mele de calcul libreoffice arată diferit după actualizare (schimbat lățimea coloanelor)?

RU: Почему мои таблицы вычислений libreoffice после обновления выглядят по-другому (изменилась ширина столбцов)?

VI: Tại sao các bảng calc libreoffice của tôi trông khác sau khi cập nhật (độ rộng cột đã thay đổi)?

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.