Is there any way to set column width exactly as Excel defines it?

asked 2018-12-22 12:36:18 +0100

anush gravatar image

updated 2018-12-22 13:51:49 +0100

I am editing spreadsheets in Libreoffice which I have to save in Excel format (.xlsx) and then send to someone (the boss). The person who receives them needs the column width to be exactly 25 for all but one column and 50 for the last one. For the column width Excel uses a formula that relates to character width (I am using 11pt Calibri font) and Libreoffice has no equivalent it seems.

Is there any way to set the column width as I need it without having a copy of Excel?

edit retag flag offensive close merge delete


I don't know what unit of measure you are using for "25" and "50" (you don't say), but does

Format > Columns > Width not give you what you need?

BigRAl gravatar imageBigRAl ( 2018-12-22 13:44:52 +0100 )edit
Mike Kaganski gravatar imageMike Kaganski ( 2018-12-22 13:47:19 +0100 )edit

@BigRAI Libreoffice doesn't offer the right units. I have added a link (which is also in the comments) that explains how Excel calculates it.

anush gravatar imageanush ( 2018-12-22 13:52:42 +0100 )edit

Sorry, I missed the link (old eyes).

BigRAl gravatar imageBigRAl ( 2018-12-22 14:08:29 +0100 )edit