Bug 97381 - Styles and Formatting: Borders overwriting bug
Summary: Styles and Formatting: Borders overwriting bug
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.0.2 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-26 14:32 UTC by Eldar
Modified: 2016-02-02 14:00 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
example of bug (7.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-01-26 14:36 UTC, Eldar
Details
Sample file modified (9.02 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2016-01-26 23:34 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eldar 2016-01-26 14:32:15 UTC
Hello!

If I want to set style only for top border of the cell and rest borders leave as is then I'm getting wrong results. Calc overwrites all borders.
Comment 1 Eldar 2016-01-26 14:36:39 UTC
Created attachment 122220 [details]
example of bug

I attached example. Cell A1 and B1 have the same style. Next I'm applying "Untitled1" style on cell B1 and getting wrong results. Only top border should be with red color, rest border should be unchanged.
Comment 2 m_a_riosv 2016-01-26 23:34:55 UTC
Created attachment 122229 [details]
Sample file modified

Hi @Eldar,

A1 has Default style modified with direct format. And Untitled1 is an style inheriting from Default, but default has not borders. Style can not inherit from direct cell format.

To solve your question, create an style from A1 and make the a second style inheriting from it to apply on B1, modifying only top border.

I think there is not a bug, please if you are not agree reopen it.

Attached a sample file.
Comment 3 Eldar 2016-01-31 16:37:48 UTC
Why need to do so complicated? But what if I have many cells with many different styles? For example in MS Excel I can set only top border and rest borders leave unchanged (as is).
Comment 4 Cor Nouws 2016-02-02 14:00:24 UTC
Hi Eldar,

I understand your question. Of course you can work in a simpler way.
But for that please check the documentation or help
 http://www.libreoffice.org/get-help/documentation/
 http://www.libreoffice.org/get-help/community-support/

This is not a bug.
Cheers - Cor