[Libreoffice-bugs] [Bug 108016] New: Calc offers less user control than Excel when inserting rows

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 108016
           Summary: Calc offers less user control than Excel when
                    inserting rows
           Product: LibreOffice
           Version: 5.3.3.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:
The root cause is that, unlike Excel, Calc always uses the formatting of the
row above, regardless of whether you insert above or below and regardless of
which row you apply that operation to.

I've typed the steps into the attached spreadsheet along with some formatted
cells so you can do the steps yourself as you read them.

Steps to Reproduce:
1.see spreadsheet titled with the number of this report
2.
3.

Actual Results:  
Calc doesn't offer the flexibility to save time in formatting.

Expected Results:
Calc should be as good or better than Excel in all cases. I've said this one
every report I've entered, so you might wonder why I don't just use Excel. It's
because for every time Calc fails to live up to Excel, it exceeds in at least
two other instances.


Reproducible: Always

User Profile Reset: No

Additional Info:
I call this a bug because I believe the spec should be "do no harm - Calc must
not be worse than Microsoft Excel" - if that's not the spec then this is of
course an enhancement request. As always, I implore you to have someone who
tests only formatting, not math functions. If you do this, you'll see how
frustrating this aspect of the program is.


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/58.0.3029.110 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/20170523/80847253/attachment.html>