When scrolling a spreadsheet, the scrolling snaps to rows, instead of smoothly. This makes the spreadsheet "jump" when scrolling, instead of providing a smooth scrolling experience. Would it be possible to provide an option for "smooth" scrolling, so I can align the spreadsheet as I self see fit?
This is the same feature request as openoffice.org bug report 7722: http://openoffice.org/bugzilla/show_bug.cgi?id=7722
I would very much like this also - even for sheets that don't have huge amounts of text, it can be very uncomfortable to snap-scroll.
For OpenOffice, see also the bug n°81907: http://openoffice.org/bugzilla/show_bug.cgi?id=81907 This smooth scroll option was requested 10 years ago, but no result. If LibreOffice team is more dynamic, we may see this improvement one day. It would be appreciated!
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
I confirm that this problem remains in LibO 3.5.0 Beta 2. Still no option for smooth scrolling.
<http://wiki.documentfoundation.org/BugReport_Details#Version> Inherited from OOo, so Version -> 3.3.0 Beta This is a CALC enhancement request Status of this bug report has been modified wrongly by a bulk change.
Why was this request marked medium importance enhancement? If it blocks work (as in when spreadsheet has large enough cells so that you either zoom out so much text is unusable, or you just can't find your cells because of abrupt jumping), isn't it really a bug? Does it require adding fundamental additional functionality (since I can't see how non-smooth jump scrolling could have been implemented without first implementing scrolling to a certain height in the document in the first place)? As you can see in the OO.o bug, many consider this a showstopper for using some spreadsheets. It has run for 10 years now and no-one moved it a bit. It keeps getting pushed aside. Is this very difficult to do or would it be a good candidate for an Easy Hack? Thank you for reconsidering this issue.
Back to Enhancement! @Bojan Markovic It's not a bug because there is no mistake in the code and because the limitation is "by design" and accepted. OOo 1.1 spreadsheet was not buggy because it was limited to 32000 rows, that was it's design. The original idea of spreadsheets was that the cells show numbers and short strings for calculations. For that use the current scroll behavior is a negligible limitation. But of course discussion whether usability can be enhanced (by enhancements) is fair and necessary. May be you should wait for an answer to your questions before you start actions.
Ok, the gist of my remark was that it is usually not the user who objects that has created problematic spreadsheet (otherwise he wouldn't have done it in the first place) it is usually received from somewhere and one must work with it. Be it by design or not, this means that it's an issue that causes user-unsolvable problems, what might be open to discussion is the severity of it's effect on users and their work. Still, I will refrain from "touching the pretty buttons" in the future.
From me as a user, my perspective is that this is a serious bug (though I can understand that from a developers perspective this is probably more a nuisance or an enhancement request at best). I feel the whole idea of merged cells vs. large single cell is not user-friendly when it comes to scrolling. Visually, both are quite close (though merged cells are more flexible). Scrolling wise, single cells are a nightmare right now and what is worst, they are an unexpected nightmare, especially in documents (and I have and do create those) with a mixture of large single cells (in my use case for single quotations) and merged cells (in my use case denoting the range of cells dedicated to the author of those quotes). Scrolling becomes near unpredictable and unnavigable in these cases unless you pay very close attention to the left-hand row numbering spacing all the time and even then it is very difficult to land where you intended to go. Now you could say of course, spreadsheets were not designed for these. But then I'll say that 1. they do allow it by design and 2. it is very bad design and user experience to allow for something and then tell users that they should not do it. So please, do fix this implementation bug. The current scroll implementation really does confuse quite some people who are using LibreOffice Calc in normal and reasonable ways. Make it optional if you prefer, as apparently and not surprisingly given overall quality of the software, there are diverse people using Calc in diverse ways.
*** Bug 95920 has been marked as a duplicate of this bug. ***
Does anybody work on this request?
*** Bug 117487 has been marked as a duplicate of this bug. ***
*** This bug has been marked as a duplicate of bug 35287 ***
Why is this BUG still not fixed? Calc is almost unusable without smooth scrolling in these cases: - Document has cells which have long vertical height. - Some cells in the document use "Wrap text automatically" from the cell Format settings. Smooth scrolling option should exist. Or actually, it should be the default.
The problem is already tracked in bug 35287. Closing as RESOLVED DUPLICATED *** This bug has been marked as a duplicate of bug 35287 ***
*** This bug has been marked as a duplicate of bug 40917 ***