Bug 136417 - [FORMATTING] Border Style always switches from 7th option to 4th after reopening spreadsheet.
Summary: [FORMATTING] Border Style always switches from 7th option to 4th after reopen...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Borders
  Show dependency treegraph
 
Reported: 2020-09-02 23:16 UTC by QuestioningEspecialy
Modified: 2024-01-02 03:10 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
video of the bug (584.91 KB, video/mp4)
2021-06-03 17:56 UTC, BogdanB
Details

Note You need to log in before you can comment on or make changes to this bug.
Description QuestioningEspecialy 2020-09-02 23:16:53 UTC
Description:
If a cell's Border Style is set to the eight option (long thin line), it will turn into the fourth when the spreadsheet is reopened. I've tested it with the first eight options and only the fourth one does this.

Steps to Reproduce:
1. Set Border Style is set to the eight option (long thin line)
2. Close file.
3. Open file.

Actual Results:
The cells' Border Style will switch to the fourth option.

Expected Results:
The cells' Border Style stays the seventh option.


Reproducible: Always


User Profile Reset: No



Additional Info:
Originally experienced on 6.3.5 version and now the 7.0.2 version. 
Hardware Acceleration had to be disabled to launch this version, so it happens in whether OpenGL is enabled or not.
Tested in Safe Mode aswell, so didn't bother resetting UserProfile.
Comment 1 Julien Nabet 2020-09-03 09:14:27 UTC
On pc Debian x86-64 with master sources updated today, I could reproduce this but only if I don't put any border on a cell.
If I put a border, the line format is indeed saved and can be retrieved after closing/reopening.

So in the case there's no border defined, I think it might expected the format isn't saved.
Comment 2 QuestioningEspecialy 2020-09-03 22:29:17 UTC
Forgot to mention that I do have the borders set. The style isn't visible otherwise.
Comment 3 Julien Nabet 2020-09-06 19:00:28 UTC
I don't reproduce this so can't help here=>uncc myself.
Comment 4 Buovjaga 2021-06-03 15:54:25 UTC
I set the border style from the toolbar button. The style itself is not changed, but the toolbar dropdown indicates that no border is set. This is some other type of issue.

How are you setting the border styles? From the toolbar, the format cells dialog or from the Sidebar?

Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 3b57ebb445df8a2bc3d916ea79f8af45e20e4e62
CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: threaded Jumbo

Arch Linux 64-bit
Version: 7.2.0.0.alpha1+ / LibreOffice Community
Build ID: c6595e781cf20ab2825e9a2bd8592688f26448e3
CPU threads: 8; OS: Linux 5.12; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 3 June 2021
Comment 5 BogdanB 2021-06-03 17:56:58 UTC
Created attachment 172597 [details]
video of the bug

Confirm with
Version: 7.1.3.2 / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

See the video.
Comment 6 QA Administrators 2023-06-04 03:15:56 UTC Comment hidden (obsolete)
Comment 7 ady 2023-06-04 13:46:59 UTC
This is not easy to replicate, for several reasons:

* The title/subject of the report does not match the description in comment 0 (e.g. "7th option" vs "eight option").
* The Help > About info was not provided by the reporter.
* The Steps To Reproduce are not clear.
* The questions posted in comment 4 were never answered.


From the video posted in comment 5, we can add:

* The only way to reproduce the behavior is by using the Standard UI, with the Formatting toolbar.

* The name of the icon, "Border Style", might be confusing when being as vague as in this bug report: the icon applies Direct Formatting, not a Style, but the same direct formatting cannot be applied by any other means (in the originally-reported versions, at least).

* Using the originally-reported versions, the tooltip on the relevant (expanded) icon does not show the "style" name of each border style, and using [CTRL]+[1] > Borders > Line > Style does not show the same amount of styles as the icon.

* Using the originally-reported versions, trying to mix the border style applied by the icon in the toolbar with another attribute (such as line width, so as to emphasize the border) was not possible. There might be some Customization that might allow it, but I did not search for it.


Only some of these flaws are improved in newer LO Calc versions.

Anyway, I was not able to reproduce the original problem in a recent LO 7.6.alpha under Windows.

Perhaps BogdanB (who posted the video in comment 5) or the original reporter could confirm?

In the meantime, I'm setting this to NEEDINFO.
Comment 8 QA Administrators 2023-12-02 03:16:32 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2024-01-02 03:10:37 UTC
Dear QuestioningEspecialy,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp