[Libreoffice-bugs] [Bug 107901] New: Format Cells dialog overwrites user selection

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=107901

            Bug ID: 107901
           Summary: Format Cells dialog overwrites user selection
           Product: LibreOffice
           Version: 5.3.2.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: timbacontent at gmail.com

Description:
Calc reverses one border setting after the user edits another.

Steps to Reproduce:
1. open the attached spreadsheet
2. select all the cells that have contents (rows 2-10 in columns B and C)
3. right-click and choose Format Cells (note: unlike earlier versions, if this
is the first time you've opened this dialog since launching the app, it will
take between 30 and 60 seconds to load)
4. go to the borders tab
5. click on the right-most vertical border 3 times, until no border is shown 
6. the "remove border" checkbox is now active - check it
7. now move on to the center vertical border and click that one three times,
until no border is shown (the border setting selected in step 5 now
auto-reverts to its previous setting)

Actual Results:  
the border setting selected in step 5 now auto-reverts to its previous setting

Expected Results:
The user should be able to make changes to the border settings in any order
without being forced by Calc to only work in a specific (and unexplained)
order. This is a cousin to the earlier report where Calc changes the font
properties of characters that have not been selected by the user.




Reproducible: Always

User Profile Reset: No

Additional Info:
As with many of the other bugs I've reported, Calc takes it upon itself to
change what the user has not asked it to change. Calc is like a
passive-aggressive person going out of its way to make your life more
difficult. Excel is worse, but seriously, the design team needs to have people
do test projects involving formatting and see how painful it is to use.
Spreadsheets are about more than math. If Word/Writer weren't so horrible when
it comes to formatting tables, we wouldn't have to use spreadsheets for
graphics, but they are, and we do and both programs are letting us down.


User-Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/58.0.3029.96 Safari/537.36

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170516/d9fe2080/attachment.html>