In calc the column width changes after I save a file. [closed]

asked 2015-08-19 05:21:54 +0100

redwdc gravatar image

updated 2020-08-08 18:15:10 +0100

Alex Kemp gravatar image

Every time I have saved a spreadsheet when I reopen it the columns are thinner. It's not consistent either. I set the Date column to 1.20" and when I reopen the doc it might be 1.19 (I could live with it) or it might be 1.13 which gives me hash marks instead of dates.

I don't want to have to lock the sheet (if that would fix it) because I can be in it several times in a day. I'm not a typist I get tired of typing passwords all day. In the few days I've been playing with LO I've come to like it. So I don't want to go back to OO but this would be a deal breaker.

Edit I was playing with my spreadsheet today because of m.a. riosv's comment.

Cell A1 = "Date" - Font = Arial 9 - Width = 1.20"

Cell A2 = "Mon 2015-07-20" - Font = Arial 10 - Formated = Date - ddd yyyy-mm-dd

See a picture at

When I save as .xlsx the column width will is set to 1.20" then the next time I open it the column is thinner. If thin enough the date looks like "####".

When I save as .xls it saves the column widths correctly.

Also both formats (.xls and .xlsx) don't save cell padding (Format > Cells > Borders > Spacing to Contents). I set it to 0.00" and when I re-open it's back to 0.02" However, if I save as .ods it stays at 0.00".

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-21 21:23:44.515541


Please could you mention, a value for the cell, font, font size, format, column with, and file format used to save?

m.a.riosv gravatar imagem.a.riosv ( 2015-08-20 01:59:04 +0100 )edit

Seems that in xlsx the width is reduced 0,01" every time it is saved, at first I think it was a rounding issue but seems always happens as if a rounding down was done. Please report the issue in: choosing LibreOffice

m.a.riosv gravatar imagem.a.riosv ( 2015-08-22 00:51:52 +0100 )edit