https://bugs.freedesktop.org/show_bug.cgi?id=56235
--- Comment #8 from Ian~G <grayl...@orange.net> --- Created attachment 72030 --> https://bugs.freedesktop.org/attachment.cgi?id=72030&action=edit pdf of boder modified to show correctly The anti-alias bug 57345 is a bit of a red herring... The problem is down to errors in the cell border dialogue. Firstly it doesn't respond to change of units properly ie the line type is always shown as a pt size regardless of units chosen for the spreadsheet. But it has always been like this (I think), so still not the answer. Secondly the double borders are assigned line sizes incorrectly. In attachment 71968 the borders are set to: 0.026cm 0.026cm 0.002cm This is in the wrong order. Double Border size should be bottom line first, then spacing, then top line. >From the point of view of displaying the things I have found that the spacing needs to be at least .06cm to be able to view at 100% and in preview and printing. See attached 72028 fods file which I have edited and which works ok on my screen with the following settings: 0.002cm 0.06cm 0.002cm Note the corrected order and the slightly overlarge spacing. Also see attached pdf of this correction. I have not been able to find any setting accessible through the borders dialogue which displays correctly. The only way of getting a usable financial spreadsheet from LO is to save it as a .fods and edit it with a text editor! Or, you can save a simple sheet as .fods with say just one cell in it with double border underline. Edit the fods to correct the cell format, then reopen it in calc and copy the cell formatting to new cells as you create them. That's a pretty awful workaround. Think I'd rather go back to OpenOffice 3.3 until this is fixed. Also, I have no way of testing what this looks like when exported as a xls file which is how we have to communicate financially with the outside world. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs