| Summary: | FILEOPEN: XLS - Cell borders not present | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Yousuf Philips (jay) (retired) <philipz85> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | normal | CC: | himajin100000, raal |
| Priority: | medium | Keywords: | filter:xls |
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 59284, 109072 | ||
| Attachments: |
excel 2007 screenshot
smaller reproducible document in xlsx format |
||
|
Description
Yousuf Philips (jay) (retired)
2015-05-02 01:43:45 UTC
I can confirm with Version: 5.0.0.0.alpha1+ Build ID: 59adad74084e9281887e3f78a225794f37b784d7 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-04-29_12:40:39 ** 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.1.5 or 5.2.1 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 helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20160920 reproducible with lo viewer version: 5.5.0.0.alpha0+ / build id : ec79f34 / android 5.1 Still present Version: 6.1.0.0.alpha0+ Build ID: 8e8dd8f320a3ff59ff8a16c1a7a867888ce80700 CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-13_23:59:29 Locale: en-US (en_US.UTF-8); Calc: group ** 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 with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. 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) from 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: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug Still present Version: 6.3.0.0.alpha0+ Build ID: ea9c13be02ba731074fa4207944ff7df40a0fb5c CPU threads: 2; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2019-04-10_20:43:17 Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded Bug is still present, even Excel changed to version 2016 Version: 7.1.1.1 (x64) / LibreOffice Community Build ID: 575c5867c4cc13d7ae78f9ce39a54a52ed38c769 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win Locale: cs-CZ (cs_CZ); UI: cs-CZ Calc: threaded Created attachment 170268 [details]
smaller reproducible document in xlsx format
Just a guess. A-1. Suppose we have A1:B1 merged. the merged area has a unique border style for a specific direction. If the border under A1 is with solid style, the border under B1 would be solid style. This applies to both Excel and Calc. ----- A-2. Lets think about another case. At least in Calc, When all the following three conditions are met, a-1. there is a unmerged area A1:B1 a-2. A1 has solid bottom border a-3. B1 has no bottom border if we merge A1:B1, the area will have a unique solid bottom border as described in A-1 ----- A-3. Lets think about one more case. At least in Calc, When all the following three conditions are met, b-1. there is a unmerged area A1:B1 b-2. A1 has no bottom border b-3. B1 has solid bottom border if we merge A1:B1, the area will have no bottom border. ----- A-4. If all the following five conditions are met in Excel c-1. there is a unmerged area A1:B1 c-2. A1 has no bottom border c-3. B1 has solid bottom border c-4. A1 has its content "AAA" c-5. After we select A1:B1, open [Format Cells] Dialog, and choose "Center across Selection" for [Horizontal] combobox under [Alignment] Tab A1 will have no bottom border, B1 will have a solid bottom border. the content "AAA" will be poisitioned horizontally center in A1:B1 now we save this file in xlsx format. the data "centerContinuous" and its target area A1:B1 will be saved to the file. ----- A-5. Open this xlsx file in Calc. On loading the file, Calc MERGES the area A1:B1. We can see no bottom border, as A1 had no bottom border. https://opengrok.libreoffice.org/xref/core/sc/source/filter/oox/sheetdatabuffer.cxx?r=358bdc5e#716 https://opengrok.libreoffice.org/xref/core/sc/source/filter/oox/sheetdatabuffer.cxx?r=358bdc5e#500 Still repro with: Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: bb67f10786fd5e232b198d09139c41078c3fc60d CPU threads: 12; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL threaded |