Bug 145948 - In an RTL sheet, merged cell borders don't show until save or direction change (see comment 2)
Summary: In an RTL sheet, merged cell borders don't show until save or direction chang...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: RTL-CTL Cell-Border Calc-Merge-Split
  Show dependency tree / graph
 
Reported: 2021-11-29 12:34 UTC by Eyal Rozenberg
Modified: 2022-11-23 12:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Worksheet exhibiting the behavior with LO 7.3.0.0a1 (5.74 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-11-29 12:34 UTC, Eyal Rozenberg 		Details
Screenshot (good? bad?) (89.50 KB, image/png)
2021-12-01 01:56 UTC, Aron Budea 		Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Eyal Rozenberg 2021-11-29 12:34:32 UTC 
Created attachment 176566 [details]
Worksheet exhibiting the behavior with LO 7.3.0.0a1

When a calc sheet has RTL direction, _some_ merged cell are not painted with the borders set for them; it is only a save, close and then open which results in the correct border being displayed. Ar a change of the sheet direction to LTR only makes the cell display its correct border. Changing direction to LTR, then back to RTL, restores the mis-painting of the cell borders.

May be related to bug 34837.

In the attachment, the larger, multi-column merged cell on the left (deeper into the sheet) ignores settings of its its display style; however, the first cell on the right (single column, vertically-merged) _doesn't_ ignore them.
Comment 1 Aron Budea 2021-12-01 01:56:57 UTC 
Created attachment 176613 [details]
Screenshot (good? bad?)

Not sure what I should see here. I'm not seeing a difference when saving/reloading, or when switching to LTR sheet and back. Is this screenshot, taken right after opening the file, correct or not? Could you please upload a comparison screenshot?

Version: 7.3.0.0.beta1+ / LibreOffice Community
Build ID: 81b26582ed62db40e2be701ddefede7d8230d0d2
CPU threads: 16; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-GB (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 2 Eyal Rozenberg 2021-12-01 11:48:07 UTC 
(In reply to Aron Budea from comment #1)

Sorry, I should have been more explicit with the reproduction instructions:


1. Open the attached document (attachment #176566 [details]).
2. Note the sheet direction is RTL.
3. Select the top-left (merged) cell.
4. Choose Format | Cells... on the menus.
5. Remove the top border (click it until it disappears in favor of white background in the dialog).
6. Press Ok.
7. Select the top-right (merged) cell.
8. Choose Format | Cells... on the menus.
9. Remove the top border (click it until it disappears in favor of white background in the dialog).
10. Press Ok.

Expected outcome:

After steps 6 and 10, the top-left and top-right cells, respectively, lose their top border.

Actual Outcome:

After step 6, nothing happens; after step 10, the top-right cell loses its top border.
Comment 3 Buovjaga 2022-11-23 12:18:30 UTC 
Repro, already with 3.3.0 on Win and 6.3 on Linux.

Arch Linux 64-bit
Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 25e9766e9b87342b6f1b29dc146d5f33e12157a7
CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 23 November 2022