Created attachment 75147 [details] screenshot Problem description: Steps to reproduce: 1. Create a file in LibreOffice Calc. Specify the line thickness of framing any cell 0.4pt, 0.5pt, 0.8pt, 2.0pt. Save the file as test_1.ods. Save the file as test_1.xls (Excel 97/2000/XP/2003) and close it. 2. Reopen test_1.xls in LibreOffice Calc. The thickness of the lines will not match the test_1.ods. 3. Test_1.xls open in Microsoft Office Excel 2003. The thickness of the lines will not be the same as the thickness of the lines in the files and test_1.ods test_1.xls, opened in LibreOffice Calc. 4. Create a file in Microsoft Office Excel 2003. Specify the line thickness of framing any cells as thin, medium, thick. Save the file as test_2.xls. 5. Open test_2.xls in LibreOffice Calc. A thick line will look like a medium. Current behavior: Different thickness of lines. Expected behavior: Thickness of the lines should be the same. Operating System: All Version: 4.0.0.3 release
I agree that this is an anoying bug, that should be easy to be resolved, but that could prevent many using LO.
This is likely a duplicate. Please look at https://bugs.freedesktop.org/show_bug.cgi?id=46393 and https://bugs.freedesktop.org/show_bug.cgi?id=60805.
Why exactly is it 'likely' a duplicate? Zooming and printing are about visual style, not necessarily about fileconversion. Please treat this bug separate until clarified.
Reproducible with LO 4.4.1.2, Win 8.1 Tested with xls and xlsx and in both the border thickness is mostly changed: 0.75 stays 0.75 1.00 changed to 0.75 1.25 changed to 0.75 1.50 changed to 0.75 1.75 stays 1.75 2.00 changed to 1.75
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT - Update the version field - Reply via email (please reply directly on the bug tracker) - Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16
Created attachment 126503 [details] ODS file with border width 1.25pt and 3.25pt
Created attachment 126555 [details] file with border width 1.25pt and 3.25pt exported to .xlsx by LO 5.1
Created attachment 126556 [details] .xlsx file which demonstrate all possible thickness and options of borders style
Created attachment 126557 [details] Compare of borders imported by MS Excel 2010 and LO 52
Created attachment 126558 [details] ODT Border with different width for export
It is the limitation of MS Excel that there is only 3 thickness available. Tested on LibreOffice 5.1 Ubuntu 16.04
I see that this bug report got closed. While I understand the reasoning that the size is a limit of MS Excel, the current situation remains a problem. Cell thickness saved in LibreOffice as xlsx should reopen in Libreoffice with the same values; regardless of how excel works. Or is this something the openmxl specs don't support? If someone can confirm this isn't supported by Openmxl, I'll submit an enhancement request where Libreoffice warns when saving as xlsx that this is not supported.
*** Bug 86860 has been marked as a duplicate of this bug. ***
This is an OpenXML/xlsx. All possible values which could be taken by Border Style class is available at: https://msdn.microsoft.com/en-us/library/office/documentformat.openxml.spreadsheet.borderstylevalues.aspx Unfortunately we cannot do anything more than displaying some warning message, that .xlsx is not supporting different border thickness.
Maybe we should keep this bug report as meta and create some new bug reports for all the issues this encompasses. See also these blog post bij LibreOffice dev Kohei on this topic: http://kohei.us/2014/01/17/the-art-of-drawing-border-lines/ http://kohei.us/2014/01/21/update-on-border-lines/ As I see it: Bugreport 1: Dashdot and dashdotdot line are missing when using openmxl in Libreoffice (xlsx). Kohei also mentiones this in his blog posts. Bugreport 2: Line thickness is not kept when using xlsx format internal in LibreOffice: 0.75 stays 0.75 1.00 changed to 0.75 1.25 changed to 0.75 1.50 changed to 0.75 1.75 stays 1.75 2.00 changed to 1.75 Bugreport 3: Hair line support is missing when using xlsx in LibreOffice
I will create these bug reports if there's no other feedback.
This is limitation of the OOXML format: https://msdn.microsoft.com/en-us/library/office/documentformat.openxml.spreadsheet.borderstylevalues.aspx
*** Bug 104820 has been marked as a duplicate of this bug. ***