https://bugs.freedesktop.org/show_bug.cgi?id=75130
Priority: medium
Bug ID: 75130
Assignee: [email protected]
Summary: Cell Borders not exported properly to XLS
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.1.1 rc
Component: Spreadsheet
Product: LibreOffice
Certain Cell borders made with Calc (4.2.1.1 RC1) are lost when saved to XLS
and reopened with Calc
I feel that most of the issues are export related as import of borders from a
XLS file made using Excel is almost perfect now.
The following export works fine
Single Line Borders 0.75 -> Translates to normal Excel Border
Single Line Borders 1.75 -> Translates to thick Excel Border
Single Line Borders 2.50 -> Translates to thickest Excel Border
Dots 0.75 -> Translates to Excel Dots
Long Dash 1.75 -> Translates to Thick Excel Dash
All Double Lines -> Translates to Excel Double Line
The export issues are:
Single Line Borders 0.05 -> not saved (should be saved as hairline)
Dots 0.05 -> not saved (should be saved as 0.75 dots)
Dots 1.75 -> saved as Border 1.75 (should be saved as 0.75 dots...?)
Dots 2.50 -> saved as Border 2.50 (should be saved as 0.75 dots...?)
Dash 0.05 and 0.75 -> not saved (should be saved as 0.75 dash)
Dash 1.75 -> saved as Border 1.75 (should be saved as 0.75 dash...?)
Dash 2.50 -> saved as Border 2.50 (should be saved as 0.75 dash...?)
Long Dash 0.05 -> not saved
Long Dash 0.75 -> saved as Single Line Border 0.05
Long Dash 2.50 -> saved as Single Line Border 2.50
Unlike Cacl, excel has no option to change the border thickness. The thickness
is assigned with the style. So we cannot expect all Borders in calc to be saved
as xls. I think some issues can be avoided if the default line thickness in
calc is made as 0.75 to match that of Excel.
--
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
