Bug 59582 - FORMATTING: Cell border width when opening Excel .xlsx is wrong
Summary: FORMATTING: Cell border width when opening Excel .xlsx is wrong
Status: RESOLVED DUPLICATE of bug 58356
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.1 rc
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-01-19 11:52 UTC by Tim Richardson
Modified: 2013-06-01 08:05 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
A document with a excel default border cell (5.60 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-01-19 11:52 UTC, Tim Richardson
Details
png screen shot (50.76 KB, image/png)
2013-01-19 11:55 UTC, Tim Richardson
Details
proposed Patch to fix the border width problem (1.11 KB, patch)
2013-06-01 08:05 UTC, Tim Richardson
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Tim Richardson 2013-01-19 11:52:18 UTC
Created attachment 73280 [details]
A document with a excel default border cell

Problem description: 
Conversion of Excel borders .xlsx is bad. Makes ugly documents.
The key problem is the default cell border width. Both Excel and LO use a think, 1 pixel border when a border is drawn using the native defaults on both platforms. 

However, a default border in a document created in Excel is not converted to a default LO border. Instead, a thicker border is created. So the formatting looks different. For documents where the borders is applied to a contiguous grid of cells, the converted document looks ugly. 


Steps to reproduce:
1. Create a native excel document, and apply the default borders to create a box border for the cell (all sides). Such a document is attaced. 
2. Import this document into LO. 
3. With the document open in LO, choose a blank cell and apply a box default border with LO. 

Current behavior:
After step 3, note how the border width just created is thin (1 px) and the imported Excel content has a much thicker border.

Expected behavior:
The default border width in Excel should convert to the default border with in LO. Therefore, there should be no visible difference between the two borders of step 3. They should both be as think as the border created in LO. 

              
Operating System: All
Version: 4.0.0.1 rc
Comment 1 Tim Richardson 2013-01-19 11:55:03 UTC
Created attachment 73281 [details]
png screen shot

This screen shot has the borders in row 3. A3 contains the border created in Excel, where it was thin; you can see how thick it becomes. C3 contains a border created in LO after the import. It is thin (and in Excel, this is what A3 looks like). In LO, A3 should have the same border as C3.
Comment 2 Joel Madero 2013-01-20 00:09:46 UTC
Duplicate.

*** This bug has been marked as a duplicate of bug 58356 ***
Comment 3 Tim Richardson 2013-06-01 08:05:45 UTC
Created attachment 80109 [details]
proposed Patch to fix the border width problem