Ask Your Question

Problem with the width of the line

asked 2016-09-21 11:23:06 +0100

Robertinho gravatar image

updated 2016-09-21 16:39:50 +0100

mark_t gravatar image

Hello World ®

I have problem with the width of the cell Border line in Libra 5.2.5 and the older version when saved to .xls file, saved to .ods is OK. I use Calc (the format is .xls in ods it not appear) and When i want set up the width it show correct but if I save the changes and start up again the width line disappear. Have any one problems like that ?

Edit to clarify the question based on reply to comment by Robertinho

edit retag flag offensive close merge delete


Is this line you have a problem with a cell border, a line chart series or some other line drawn as an object?

mark_t gravatar imagemark_t ( 2016-09-21 14:48:03 +0100 )edit

With a cell border =/

Robertinho gravatar imageRobertinho ( 2016-09-21 15:21:38 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-09-21 16:49:39 +0100

mark_t gravatar image

You can only save formatting to xls files if your document contains styles that are valid in xls file. There are differences in border formatting between Excel and LibreOffice. LibreOffice has more control of the line width but this can not be saved to an xls file.

You can work around this problem by setting the border style using the menu "Format", "Cells...", choose the "Borders" tab, and then set the border line width to 1.75pt.

This is similar line width to the bold border option in Excel and seems to save correctly to .xls files.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-21 11:23:06 +0100

Seen: 33 times

Last updated: Sep 21 '16