[Issue] Can I scroll smoothly if rows are very tall?

Discuss the spreadsheet application

[Issue] Can I scroll smoothly if rows are very tall?

Postby KeKc » Sat Mar 01, 2008 12:48 pm

Hi guys,

Sorry if it was already discussed.
But I haven't find an answer.

By default OpenOffice calc scrolls by rows. And It's OK, if they are small.
But I have tall rows and scrolling became very hard.

Can I disable this feature (scroll by rows) and scroll smoothly by pixels for example?

Thanks in advance!
And sorry for my English)
Last edited by Hagar Delest on Tue Jun 10, 2008 3:48 pm, edited 2 times in total.
Reason: Tagged thread as Issue (link to a bug report).
KeKc
 
Posts: 6
Joined: Sat Mar 01, 2008 12:40 pm

Re: Can I scroll smoothly if rows are very tall?

Postby squenson » Sat Mar 01, 2008 12:55 pm

KeKc,

As far as I know, this is not possible. But I can offer you a workaround: use rows of standard heights and merge several cells vertically to make a big cell. You can even do it with entire groups of rows. The scrolling will still be by row, using the default height.
LibreOffice 4.2.3.3. on Ubuntu 14.04
User avatar
squenson
Volunteer
 
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: Can I scroll smoothly if rows are very tall?

Postby KeKc » Sat Mar 01, 2008 1:01 pm

squenson,

Thanks for you answer! Soooo fast :)

It's a pity, that there is no such option :cry:
I think it's really useful, don't you think so? Maybe I can submit it for some new release (3.x?) somewhere?
KeKc
 
Posts: 6
Joined: Sat Mar 01, 2008 12:40 pm

Re: Can I scroll smoothly if rows are very tall?

Postby Hagar Delest » Sat Mar 01, 2008 1:32 pm

See here: [Tutorial] Reporting bugs.

Then put here the link to the issue.
LibreOffice 7.0.3 on Xubuntu 20.10 and LibreOffice 7.0 (portable) on Windows 10.
User avatar
Hagar Delest
Moderator
 
Posts: 29613
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Can I scroll smoothly if rows are very tall?

Postby Dave » Sun Mar 02, 2008 4:42 pm

Why is it so hard? You would surely not have a row that exceeded screen height, and rows scroll one at a time, or several depending upon the Mouse setup. With a Logitech scroll mouse I can press the center roller and then, with slight or greater distance from the screen icon, scroll quickly or slowly, or roll the roller to run up/down the least jump being one row at a time. That is a hardware/operating system setup function, not a spreadsheet problem. I'm curious as to the need to scroll by pixels. It is more natural so far as I can see to scroll by row.

David.
Dave
 
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm

Re: Can I scroll smoothly if rows are very tall?

Postby KeKc » Mon Mar 03, 2008 11:02 am

David,

You are right if you are talking about small rows.
But we have some documents in our company with rows even higher then screen size. And this is not my fault :)
So it's very hard to view the whole row (not speaking about two :) ) without zooming out.

I don't know how is it going with MS Office, because I'm not using it. But will check KOffice and Koffice2 at home.
KeKc
 
Posts: 6
Joined: Sat Mar 01, 2008 12:40 pm

Re: Can I scroll smoothly if rows are very tall?

Postby acknak » Mon Mar 03, 2008 3:39 pm

See Issue 7722: Cells Columns that are larger than screen jump when scrolling.

You can register and add a vote (up to two) or comment there.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Can I scroll smoothly if rows are very tall?

Postby KeKc » Mon Mar 03, 2008 3:50 pm

acknak wrote:See Issue 7722: Cells Columns that are larger than screen jump when scrolling.

You can register and add a vote (up to two) or comment there.

Thanks acknak!
I think thread could be closed now..

Thanks everyone and Good luck!
KeKc
 
Posts: 6
Joined: Sat Mar 01, 2008 12:40 pm

Re: Can I scroll smoothly if rows are very tall?

Postby huw » Mon Mar 03, 2008 4:03 pm

I have the same problem with tall rows. I deal with it by using maximum screen resolution, and scrolling with the scrollbar buttons to move one row at a time, because I need the mouse set to scroll "3 lines" for other applications.

I'm using 1280x1024 on a 17" monitor. I didn't expect it to be clear, because some of the lower ones weren't, but it turned out to be the monitor's native resolution, and by far the sharpest of all the choices. None of my rows are so tall that they wont fit on one screen now.

It is worth getting the latest video card & monitor drivers because higher resolutions are sometimes added later.

Hope this helps.
huw
Volunteer
 
Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm

Re: Can I scroll smoothly if rows are very tall?

Postby Dave » Mon Mar 03, 2008 6:04 pm

KeKc wrote:But we have some documents in our company with rows even higher then screen size. And this is not my fault :)
So it's very hard to view the whole row (not speaking about two :) ) without zooming out.


In the meantime ... There is 3rd party software available for zooming a section of the screen. One I have used and like will displace the area around the cursor across the full width at the top of the screen, and you can set zoom level. This would allow you to perhaps set the spreadsheet Zoom to allow the screen to just contain the full cell, then browse over it using this software for readability. This is all theoretical since I haven't tried it. It might simply produce larger unreadable chunky text. I don't have the software installed at the moment, but am tempted to give it a try when I return home later today.

This does not meet your immediate needs, but they do seem to be rather specific. It would be an interesting concept though if such browsing as you need was accommodated. That's the thing about programming, trying to please all the people. It's like knowing which words to keep and which to not keep when making an in-program thesaurus; surely not all of them with today's technology.

David.
Dave
 
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm

Re: Can I scroll smoothly if rows are very tall?

Postby KeKc » Mon Mar 03, 2008 6:12 pm

Dave wrote:
KeKc wrote:But we have some documents in our company with rows even higher then screen size. And this is not my fault :)
So it's very hard to view the whole row (not speaking about two :) ) without zooming out.


In the meantime ... There is 3rd party software available for zooming a section of the screen. One I have used and like will displace the area around the cursor across the full width at the top of the screen, and you can set zoom level. This would allow you to perhaps set the spreadsheet Zoom to allow the screen to just contain the full cell, then browse over it using this software for readability. This is all theoretical since I haven't tried it. It might simply produce larger unreadable chunky text. I don't have the software installed at the moment, but am tempted to give it a try when I return home later today.

This does not meet your immediate needs, but they do seem to be rather specific. It would be an interesting concept though if such browsing as you need was accommodated. That's the thing about programming, trying to please all the people. It's like knowing which words to keep and which to not keep when making an in-program thesaurus; surely not all of them with today's technology.

David.


I don't want exactly what I've asked form developers.
I mean I don't need by-pixel scrolling, I need user-friendly way for browsing spreadsheets with large rows.
It could be also not so large rows, but user has low resolution monitor, so the row is larger then screen.

And I also don't think, that by-pixel browsing should be default. It could be option or it could switch to by-pixel browsing in case of large rows.
KeKc
 
Posts: 6
Joined: Sat Mar 01, 2008 12:40 pm

Re: [Issue] Can I scroll smoothly if rows are very tall?

Postby squenson » Tue Mar 04, 2008 12:28 am

Sorry to disagree with you, but I do not consider this requirement useful, to the contrary:

1) There is no reason for a row to be higher than the screen height. If this is the case, it means that it contains text, and therefore a word processor is much more adapted in such situation, and provides smooth scrolling. If part of the sheet is calculation, then embed a Calc sheet into a Writer document. Using the wrong tool and requesting it to do what you want is not a sensible approach, use the right software instead.

2) I do not want to see half a row or half a column when I scroll, I always want to see a full cell in the top left corner. I know the programmer would make it a selectable options, but then it will be buried somewhere and hardly anybody would find it.

3) The workaround I described is working quite well. Make a template with the first n columns as merged cells with very large height, and then copy/paste your initial spreadsheet into this template. then you will have a pretty good simulation of smooth scrolling.

4) Excel 2003 has the same behavior, scrolling by entire rows. I do not know for Excel 2007, but someone could test it as it can be downloaded for free for 30 days. And yes, I strongly believe that the success of Calc will be better by being as compatible as possible with Excel.

5) When you know how long it too programmers to move Writer object from the left of the page to the center, then to fix a bug in Calc notes which had more than one line, it seems that programmers have great difficulties to modify the display.

6) There are much more important improvements than this one. For example, processing speed of large spreadsheets is very slow and I would prefer that programmers spend their time there.
LibreOffice 4.2.3.3. on Ubuntu 14.04
User avatar
squenson
Volunteer
 
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: [Issue] Can I scroll smoothly if rows are very tall?

Postby KeKc » Tue Mar 04, 2008 6:48 am

2squenson:

I'm not going to "push" this feature.
I have just voted for it, because had met this problem with large rows several time using OpenOffice for several years.
It's very hard to operate with such documents and that's True.

Anyway it's developers wish to implement such feature or to close it. Another deal - if I would be an OpenOffice developer and had such a problem.. But I'm not :)

ps I have never crated spreadsheets with large rows. Last place they was taken is our entire documents.
pps I would like OOo to be better the MSO, not the same as :)
KeKc
 
Posts: 6
Joined: Sat Mar 01, 2008 12:40 pm

Re: [Issue] Can I scroll smoothly if rows are very tall?

Postby andrearicci » Tue May 19, 2009 10:37 am

I disagree.
Using a spreadshet as database+calcs is legitimate, and the trick of merging cells would break the database, the database can have long text fields.
As an exhample: I'm using calc to write a building metric estimate, where I need to calc size by cost for every kind of work (looong descriptions!).
The proposed soolution is:
standard scrolling by row, if row < window height
switch to scrolling by TEXT row if row => window height
OOo 3.1.X on Ms Windows XP + linux4one
andrearicci
 
Posts: 3
Joined: Tue May 19, 2009 10:04 am

Re: [Issue] Can I scroll smoothly if rows are very tall?

Postby squenson » Tue May 19, 2009 10:32 pm

Your proposal is interesting but if you wait for OOo to support this feature to complete your tool, I guess you will be retired before you see it! First, OOo developers do not read this forum, so this is not the right place to post requests. Second, OOo is so complex that the developers can barely cope with the new features and the bugs. Even popular requests like increasing the number of rows are not yet implemented, simply because it is complex.
LibreOffice 4.2.3.3. on Ubuntu 14.04
User avatar
squenson
Volunteer
 
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: [Issue] Can I scroll smoothly if rows are very tall?

Postby dainiswmichel » Sat Aug 18, 2012 10:42 am

i'd like to see this feature implemented as well :-)
OpenOffice 3 on Mac
dainiswmichel
 
Posts: 1
Joined: Sat Aug 18, 2012 10:30 am

Re: [Issue] Can I scroll smoothly if rows are very tall?

Postby squenson » Sat Aug 18, 2012 11:52 am

This thread was from 2009, three years ago!!!

You can now see the content of cells with very long text by using the multi-line entry box for a formula, which is scrollable.
LibreOffice 4.2.3.3. on Ubuntu 14.04
User avatar
squenson
Volunteer
 
Posts: 1885
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: [Issue] Can I scroll smoothly if rows are very tall?

Postby Mirax » Mon Jan 11, 2016 11:13 am

You can change your mouse settings:

Start->Settings->Mouse->Wheel(Roll) set to scrool 1 line at a time instead 3 lines by default

So you can scroll one line even if it small or big. But in other program it will be issue now.
OpenOffice 4.1.1 on windows 7
User avatar
Mirax
 
Posts: 1
Joined: Mon Jan 11, 2016 11:07 am


Return to Calc

Who is online

Users browsing this forum: RPG and 17 guests