Created attachment 140388 [details]
example of ods created with V5 which is OK
Such a simple thing to break.
When selecting certain Border formats and a Border Style, the style is not correct. See the attachments for examples that were
- correct if the ods was created by calc V5 but
- wrong if the ods was created by or copied from a V5 into calc V6
There are two ods attachments,
- one created by V5 which still works correctly when accessed by V6,
- the other created with V6 and which has a bug (and other sheets for other bugs)
Try changing the border and border style to all 4 sides of a cell or range with thick lines. OK in V5, wrong in V6.
Try changing the border and border style to all 4 sides of a cell or range with double lines. OK in both V5 and V6. (skinny lines are OK too)
I didn’t reset my Profile
OpenGL was unticked
Created attachment 140389 [details]
example of ods created with V6
This smells like bug 103924, but things are not clear.
Just to be clear: do you reproduce the bug *from scratch* in version 6? If yes, please give exact steps on selecting the border style.
I am asking, because if I open Format cell in 6, the Style dropdown does not show anything. That is why I suspect the legacy of bug 103924 being involved.
If you know how to use the icons on the Menu bar then do this
1) left click on the drop down arrow for Borders
2) options are displayed in a 3 x 4 matrix. click on the option to surround a cell or range of cells (hint: it's on the second row in the fourth column (right)
3) left click on the drop down arrow for Border style. drag the slider down until you see the third from the bottom wide bar and left click on it.
That's all that I do, LO Calc does the rest by putting a thick border horizontally both top and bottom and incorrectly putting a skinny border line vertically both on the left and right.
To help you visualize this I prepared and attached an ods file named Borders.
It shows the borders for all 14 options
I have only Calc V 22.214.171.124 installed.
If I create a new ods, the borders are drawn incorrectly
If I open an old ods created by V5, the borders are drawn correctly
This makes me think that, when a new ods is created, Border definitions are retrieved and stored within the ods rather than being retrieved from Calc each time the ods is opened.
This raises the issue of how a correction can be designed and applied to:
1) correct the definitions in Calc itself and
2) how to transfer those correct definitions to each ods with the incorrect definitions.
We’d need to know what an incorrect definition looks like, test for it and if found, replace it with a correct definition.
On a side note: There are only 5 Border style variations that make sense to have, but 2 need fixing. The other options look just like an other option and are therefore redundant and should be removed. I documented this in the ods which I’ve attached.
This makes me think that at one time all 14 looked different but over time were converted to what we see now.
Created attachment 140577 [details]
a comprehensive demonstration of the bug in V 126.96.36.199
(In reply to Aprax from comment #3)
> If you know how to use the icons on the Menu bar then do this
> 1) left click on the drop down arrow for Borders
> 2) options are displayed in a 3 x 4 matrix. click on the option to surround
> a cell or range of cells (hint: it's on the second row in the fourth column
> 3) left click on the drop down arrow for Border style. drag the slider down
> until you see the third from the bottom wide bar and left click on it.
> That's all that I do, LO Calc does the rest by putting a thick border
> horizontally both top and bottom and incorrectly putting a skinny border
> line vertically both on the left and right.
Right, there is a discrepancy between the Format cells dialog and the toolbar dropdown button. The toolbar button contains more styles than the dialog. I was working in the dialog this whole time.
Arch Linux 64-bit
Build ID: de53d4690d25b9f1bbc0def6c66ce5b45b2fdc96
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4;
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 12th 2018
Why would there be two very different ways to select a Border and Border width?
I thank you for pointing me to the Format way, it's basically much easier to understand and use. It's not completely intuitive when designing a border with less than 4 sides but I did find the double left click could remove a single side.
However the check box for "Remove border" acts weirdly. It's greyed out initially,it stays greyed if I single click to select a single side, but if I click again on the border, the border disappears and the check box is active which seems pointless since the border is gone. However, once active I can click on other sides and they disappear so it's just a learning curve by trial and error although really, the check box should always be active or someone needs to explain why it isn't..
to 'fix' THIS bug change both of the Menu bar icons to simply open the "Format Cells..." at the Border tab.
You could leave or remove the spurious code that existed under the icons.
This way, anyone (like me) would be directed to the code that works properly.
did you change this to "Fixed"?
(In reply to Aprax from comment #8)
> did you change this to "Fixed"?
How can this be both New and Fixed?
I could possibly understand that it's new although there's the other bug # that indicates that it's not really New, but to label it as Fixed is ridiculous.
(In reply to Aprax from comment #10)
> How can this be both New and Fixed?
> I could possibly understand that it's new although there's the other bug #
> that indicates that it's not really New, but to label it as Fixed is
Nobody has labeled it as fixed, so I have no idea what you are talking about.
Just below the Additional Comments 'box', see attachment screen shot
Created attachment 140743 [details]
shows bug as both New and Fixed----?
** 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!
Created attachment 150148 [details]
Borders now OK
The Borders are drawn as expected now in version 188.8.131.52 x64, thank you!
Great news, let's close.