https://bugs.freedesktop.org/show_bug.cgi?id=68148

--- Comment #16 from Noel Power <[email protected]> ---
(In reply to comment #15)
> Created attachment 84651 [details]
> Cell border problem of LibreOffice Calc 4.1
> 
> The problem is not that single line borders appears as dashed lines on the
> screen.
> 
> An spreadsheet made with the previous version of Libreoffice Calc (4.04) or
> OpenOffice 4.0 having cells with the default single line borders (0.05 pt
> thick) when saved as .xls file and opened with the new version of
> LibreOffice Calc (4.1), the single line  borders shows as dashes on the
> screen.
Sorry, I don't get it, if I export a cell 0.05 pt single line border from
Libreoffice 4.0 or 4.1 and open that file in Excel XP, 2003, 2007 or 2010 I see
a hairline border ( hairline = some dot/dash type borderline, more dot than
dash in this case ).

If I open that same file again
i) in LibreOffice 4.0 I get a single line ( because the import doesn't handle
the hairline )
ii) in 4.1 you see a hairline ( well maybe more dash than dot but better than a
single line )

Regardless of 4.1 or 4.0 the SAME Microsoft border type is exported, how it is
displayed is different

> If you open the cell property of a cell having border you can find
> that "line style" combo box is blank! ie the 0.05 pt style single line (the
> default single line) of previous version of Calc (4.04) is not recognised
> properly by the new version.
so, indeed it is blank, I don't know why ( perhaps that line style isn't
supported natively in odf ? ) certainly that line style is not supported in the
dialog. But..... so what ? the import is trying it's best to show you what the
document would look like in excel, that imho is the correct thing to do
> 
> Further, on printing the spreadsheet using the new 4.1 version, the dashes
> are not printed on all cells (most of the cells appear without any borders).
> This is a big nuisance, since all old spreadsheets have to be edited and the
> borders have to be changed when you open with the new version.
like I said, I have no idea about printing but that is a separate issue and
deserves a separate bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to