Columns in calc are slightly narrower than in original .xlsx (, All Platforms) [closed]

asked 2015-12-05 00:59:21 +0100

eoliphant gravatar image

updated 2020-08-27 21:13:12 +0100

Alex Kemp gravatar image

Hi, after noticing some cutoff text in an Excel .xlsx file I opened, I did some additional digging (checking row heights and cell widths) against the same file opened in excel. It turns out that the problem is caused by the fact that LO seems to have assigned slightly smaller column widths than in the original document. This seems to be very consistent, as I checked columns that didn't have the cutoff problem (as they didn't have text that wrapped, etc). For example a column that was 2.19" in Excel, was 2.02" LO when I opened the same source document. This just an annoyance when using LO interactively. However it's a problem as we're using LO's command line to convert documents to PDF, and the 'cutoff' text in LO becomes overwritten text when you save to PDF.

I've checked this on Linux, OS X and Windows and see the same behavior. On OS X and Windows have run the comparisons against Excel, so the fonts, etc are the same, so I don't think that's the issue.

Any ideas?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-27 21:13:22.646521


Maybe some of this reported bugs:

m.a.riosv gravatar imagem.a.riosv ( 2015-12-07 23:36:06 +0100 )edit