Bug 36530

Summary: FILEOPEN, reading XLS file ignores font size and line width
Product: LibreOffice Reporter: Ed Dyer <edlindyer>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal    
Priority: medium    
Version: 3.4.0 Beta2   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard: target:3.5
Crash report or crash signature: Regression By:
Attachments: XLS file created in LO 3.4.0 B3
XLS saved from Excel 2000, cell fonts and borders are self-descriptive

Description Ed Dyer 2011-04-23 11:51:32 UTC
When reading in an XLS file, the font size and the cell border line width are ignored.
Comment 1 Kohei Yoshida 2011-05-03 15:44:24 UTC
Please attach a test document that can replicate the reported problem.
Comment 2 Ed Dyer 2011-05-03 19:07:10 UTC
Created attachment 46302 [details]
XLS file created in LO 3.4.0 B3

For an XLS file saved from Excel_2000 (font_border Excel2000.xls), font sizes are read but not line widths.
For an XLS file saved from LO3.4 (font_border LO340B3.xls), font sizes are read except for the last cell changed. Line widths are not read. This file looks good (as the self-described cells suggest) when read by Excel_2000.
Comment 3 Ed Dyer 2011-05-03 19:10:17 UTC
Created attachment 46303 [details]
XLS saved from Excel 2000, cell fonts and borders are self-descriptive

XLS file saved from Excel 2000. Cell contents are the font size and border size.
Comment 4 Kohei Yoshida 2011-05-04 16:01:04 UTC
This is a mapping issue, as Excel's pre-set border widths differ from Calc's preset border widths.

I'll see if there is anything we can do for 3.4, but in case this requires changing the UI of the cell format dialog, then it may have to wait after 3.4.
Comment 5 Ed Dyer 2011-05-06 05:55:20 UTC
Note the the mapping seems to be working when "save as" from Calc, just not when reading back in.
Comment 6 Kohei Yoshida 2011-05-06 07:48:52 UTC
(In reply to comment #5)
> Note the the mapping seems to be working when "save as" from Calc, just not
> when reading back in.

Nah.  It's a display pixel precision issue.  If you print to, say, PDF the line widths should look different.
Comment 7 retired 2014-08-11 17:44:08 UTC
WORKSFORME

OSX 10.9.4 LO Version: 4.3.1.1
Build ID: c4b15cd4d00dec6b266fa830b4ba73e31ae6ce73

If this persists for you with that version of LO or newer, please re-open and add more detail what's still going wrong.