https://bugs.documentfoundation.org/show_bug.cgi?id=93937
Óvári <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED See Also| |https://bugs.documentfounda | |tion.org/show_bug.cgi?id=92 | |439 Resolution|WORKSFORME |--- Ever confirmed|0 |1 --- Comment #2 from Óvári <[email protected]> --- 1. Assist in reducing the difficulty when creating complex formulae (nested, multiple arguments, etc) as it will fit more easily in the Input Line. Increases usability and reduces the number of small annoyances (even though this corner case may occur rarely in the casual/home users segment; however, this may occurs more frequently in the enterprise/government). Eg. =SUM(A1:A1048576,C1:C1048576,E1:E1048576,G1:G1048576,I1:I1048576,K1:K1048576)/COUNT(A1:A1048576,C1:C1048576,E1:E1048576,G1:G1048576,I1:I1048576,K1:K1048576) =SUM(A:A,C:C,E:E,G:G,I:I,K:K)/COUNT(A:A,C:C,E:E,G:G,I:I,K:K) 2. Would assist Calc to be be WYSIWYG (What You See Is What You Get). At the moment you see one formula and when Enter is pressed the cell changes and the the formula that was entered also changes without showing the operator (unless they return to the cell). 3. This bug may assist in the implementation bug 92439 "Creating entire column/s or entire row/s ranges in formulae by clicking on column/row heading/s" as the Input Line will default to 'B:B' not 'B1:B1048576' 4. Increases usability and reduces the number of small annoyances for enterprise/government operators. 5. MS XL caters for this bug (Input Line is called the Formula Bar). 6. This would increase "Calc's blend of performance and features makes it an enterprise-ready, heavy duty spreadsheet application capable of handling all kinds of workload for an impressive range of use cases." https://www.libreoffice.org/discover/new-features/ Thank you -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
