Apache OpenOffice (AOO) Bugzilla – Issue 127611
thickness of cell border lines are not saved fully as xls file
Last modified: 2017-11-30 12:52:13 UTC
Created attachment 86279 [details] examples of cell border thickness in .xls In OO 4.1.3 Calc / speqadsheet : When setting the thickness of cell border lines to the following values: 0.5pt (single line) > [xls re-opened 1.00pt single line] 5.0pt (single line) > [xls re-opened 4.00pt single line] 1.1pt (double line) > [xls re-opened 3.00pt double line] 2.6pt (double line) > [xls re-opened 3.00pt double line] 7.5pt (double line) > [xls re-opened 3.00pt double line] 3.55pt (shadow line) > [xls re-opened 3.00pt double line] 5.05pt (shadow line) > [xls re-opened 3.00pt double line] 6.55pt (shadow line) > [xls re-opened 3.00pt double line] 6.0pt (shadow line) > [xls re-opened 3.00pt double line] 4.5pt (shadow line) > [xls re-opened 3.00pt double line] 9.0pt (shadow line) > [xls re-opened 3.00pt double line] 9.0pt (shadow line 2nd option) > [xls re-opened 3.00pt double line] and saving as .xls file (choosing file format "Microsoft Excel 97/2000/XP (.xls)"), the thickness settings are not saved, and appear with the values given in []-brackets when re-opened. When saving as .ods (choosing file format "ODF Spreadsheet (.ods)"), the borderline thicknesses are all saved. Best, Thomas
Already reported *** This issue has been marked as a duplicate of issue 96145 ***
Yes, it is the same issue (though, my report describes the problem more in detail). I did not find issue 96145 when searching database. But there are no answers in both issues (yet) about how to solve the problem! Remarkable is, that the border thicknesses are saved when saving as OO file (.ods), but not as .xls file. Why is that? Will this bug be repaired in next OO version?
(In reply to thomas from comment #2) > But there are no answers in both issues (yet) about how to solve the problem! This will be fixed when a developer take care this issue. You can boost it with add your vote.