[Libreoffice-bugs] [Bug 107857] New: Incorrect Formatting Logic

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 107857
           Summary: Incorrect Formatting Logic
           Product: LibreOffice
           Version: 5.3.1.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 fails to retain format of a selected character in a way that contradicts
every other program I've ever used, including Excel.

Steps to Reproduce:
1. in Excel, enter a cell
2. set the font color to Red
3. type R - a red R appears - type space
4. set the font color to Green
5. type G - a green G appears - type space
6. set the font color to Blue
7. type B - a blue B appears now you have R G B, each letter with its own color
8. with the mouse select only the green G
9. type g - a green g replaces the green G - this is desirable behavior - the
user will often want to change a value without changing its format
10. repeat with Calc - a red g replaces the green G - it's same with
superscript, bold and all other formatting options

Actual Results:  
When selecting and replacing a character, Calc, instead of retaining the
format, looks backwards to the previous character (within the same cell) and
forces that formatting on the user.

Expected Results:
Calc should behave like Excel unless Excel has a bug or bad design. It should
also behave like almost every other program on the market. Even after
understanding Calc's behavior, it still take more keystrokes and mouse clicks
to perform the same operation.


Reproducible: Always

User Profile Reset: No

Additional Info:
I wish you could stand behind a user and watch him or her spend hours working
on formatting a massive spreadsheet with lots of border, backgrounds, format
and font changes - and especially changes to individual characters within the
same cell. You would see just how incredibly frustrating the program is. As
always, I realize I'm complaining about a product that's free, and I still find
it significantly less frustrating than Excel on balance, but Calc is not
anywhere near as intuitive and intelligent as I would expect from such an
ambitious un-corporate product. Excel is already there as a model. I would
expect that you would take what works well in Excel and fix what doesn't,
rather than leaving out superior Excel behavior for which millions of users
have already transversed the learning curve.


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/20170515/7a7c9567/attachment.html>