Bug 120166 - Cell border style works differently in Microsoft Excel and LibreOffice Calc
Summary: Cell border style works differently in Microsoft Excel and LibreOffice Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Border
  Show dependency treegraph
 
Reported: 2018-09-27 19:25 UTC by Gabor Kelemen (allotropia)
Modified: 2022-10-20 18:53 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Example ods file (11.68 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-09-27 19:25 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2018-09-27 19:25:33 UTC
Created attachment 145224 [details]
Example ods file

The LibreOffice Calc cannot overwrite the border style of an adjacent cell, if we try to modify the border style of the active cell.

Steps to reproduce:
1. Create a new spreadsheet (save as *.ods or *.xlsx) with LibreOffice Calc
2. Set the A1:C10 cells border style to a simple (1 pt width, black) continuous line
3. Try to modify only one cell (B5) border to “- none -”

4. Do the same (save as *.xlsx) from the beginning in Microsoft Excel 2010/2013/2016

Actual results:
We cannot modify a simple cell border (we have to select at least 2) in LibreOffice Calc, if we have already set a cell border for a larger range. We can modify it with Microsoft Excel.

Expected results:
We should modify a simple cell border in LibreOffice Calc, even if we have already set a cell border for a larger range.

Verzió: 6.1.0.3
Build az.: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: alapértelmezett; 
Területi beállítások: hu-HU (hu_HU); Calc: group threaded

(This is probably a dupe, sorry in advance if that is the case)
Comment 1 Zineta 2018-10-04 12:07:15 UTC
I can confirm in:
Version: 6.2.0.0.alpha0+ (x64)
Build ID: 89a60912bba7ffd6f65ea99f4664f343c5025c95
CPU threads: 2; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-10-01_03:18:33
Locale: bs-BA (bs_BA); Calc: threaded

It is inherited from OOo.

The only way to set one cell unbordered is right click-> Format Cells->Set no borders and check box Remove border.
Comment 2 QA Administrators 2020-12-28 03:43:52 UTC Comment hidden (obsolete)
Comment 3 Rafael Lima 2022-10-20 18:53:39 UTC
So I tried this again in LO 7.4 and I can change the border of a single cell if I check the option "Remove border" in "Adjacent cells".

Is this bug still valid?