Description: Many other people are having this same problem: an enormous number of excess rows and/or columns which make LibreOffice very awkward to use. Someone wrote on the main LibreOffice site that there has been a request for "enhancement" so that an almost infinite number of rows and/or columns is the default. It is NOT an enhancement for those of us who need only a limited number of rows and/or columns. In my case, I would never need more than 30 columns and 10,000 rows. Please give us an easy way to allow us to limit the spreadsheet size, and not just "hide" rows and columns, which is both difficult and unnecessary. Steps to Reproduce: Scrolling through huge numbers of rows is inefficient and extremely annoying. Actual Results: Scrolling through huge numbers of rows is inefficient and extremely annoying. Expected Results: Scrolling through huge numbers of rows is inefficient and extremely annoying. Reproducible: Always User Profile Reset: No Additional Info: Allow us to easily limit the number of rows and columns that can EVER be seen.
I don't think this will happen in the near future. And I don't think it's a minor change; changing the possibility of expanding to very large spreadsheets was really hard work. https://bugs.documentfoundation.org/show_bug.cgi?id=50916 https://bugs.documentfoundation.org/show_bug.cgi?id=133764
https://ask.libreoffice.org/t/is-it-possible-to-impose-a-limit-columns-and-rows-on-spreadsheet-size/3924/5
(In reply to m_a_riosv from comment #2) > https://ask.libreoffice.org/t/is-it-possible-to-impose-a-limit-columns-and- > rows-on-spreadsheet-size/3924/5 So LibreOffice is only interested in power users with millions of cells in their spreadsheets? Are they trying to drive normal users away to something else? Give us something simple in the preferences to specify whatever number of rows and columns we want. That way we can tailor it to what we need, whether it's 30 columns and 10,000 rows (perfect for me), or whatever ridiculous number of columns and rows someone else wants. Just allow US to specify the size. It's a really simple concept.
We (mainly volunteers, like myself) have no reason to put up with your reproaches. Incidentally, they are typical of someone who does not know what they are talking about.
There is no need for you to be rude. What you consider a "reproach" is simply a request for you to make Calc usable for normal spreadsheet users who do not need or want infinite (or nearly so) rows and columns. Usability is what we need, whether it's from Microsoft et al or LibreOffice. You claim that LibreOffice is as good as or better than them. Don't try to compete with them on complexity or needless "enhancements" which I expect must cater to a tiny fraction of users. And I repeat: just allow ALL
There is no need for you proposal! No one is forced to use the entire spreadsheet Just use as many rows and columns as you want!
Actually, there IS a need for this to be reworked. My spreadsheets now have 1,048,576 rows. The scroll bar (which I do use) forces me to scroll through those 1,048,576 rows. Currently, my main spreadsheet has about 6,000 rows, and I add about 500 rows per year. Other people may experience similar problems with the columns. This problem is not difficult to understand. I suggest you read the comments from other users experiencing the same problem before dismissing me.
(In reply to Ivan Stephen from comment #7) >My spreadsheets now have 1,048,576 rows. The scroll bar (which I do use) forces >me to scroll through those 1,048,576 rows. Is it possible to add a screenshot/screencast or sample file to illustrate what exactly mean. I don't 'see' how you're being forced to scroll through 1,048,576 rows. Which sounds as your normal working range being 0-10.000 while some content landed on row 1.048.576. Which creates an experience if your are using full capacity I admit I find the Jumbo spreadsheets gigantic. Beyond anything needed for casual use. And sometimes confronting: press CTLR+A selecting A1:XFD1048576. OTOH, I'n not using Calc and Excel enough to know if something is amiss in Calc regarding usability. The maximum supported size increased, without any UI/usability considerations as far I'm aware.
Created attachment 202016 [details] Image to show before and current behaviour of spreadsheet scrolling. Some of the time, a typical spreadsheet has over 1,000,000 rows. The highest number of rows I will ever need will be 10,000 or at most 15,000. Some of the time, it's forcing me to scroll through all 1,048,576 rows. Apple Numbers (which I don't use) has taken the opposite approach, and limits the number of rows and columns that a user would normally see. I'm asking that a setting be put into the LibreOffice preferences to let users specify the number of rows and columns that they want in the spreadsheet. This would be a bit like specifying a print range, so let's call it a "size range".
(In reply to Ivan Stephen from comment #9) > Created attachment 202016 [details] > Image to show before and current behaviour of spreadsheet scrolling. > > Some of the time, a typical spreadsheet has over 1,000,000 rows. The > highest number of rows I will ever need will be 10,000 or at most 15,000. > Some of the time, it's forcing me to scroll through all 1,048,576 rows. I am now experiencing a situation (some of the time) in which the scroll bar has ALL 1,048,576 rows. I don’t understand why it’s not happening consistently. The inconsistent part is a bug by definition of not due to user error Limiting the range sounds in the given context more like a workaround; although might be valid outside the given case
As someone who is a user rather than a coder, I define a bug somewhat differently. "A feature which is designed to frustrate both light users and power users." Specifically, we have spreadsheets which show over a million rows (and an vast number of columns) when 10,000 rows and perhaps 50 columns are all that's wanted. Somewhere (I can't imagine where) there could be a power user who wants 1,048,056 rows and perhaps 1,048,056 columns. Just allow us to all specify what we need, for ease of use. Inconsistency would also be a bug.
Let's run it through UX (User Experience committee)
Thanks! That would be a great help.
(In reply to Ivan Stephen from comment #0) > not just "hide" rows and columns, which is both difficult and unnecessary. Why not? It perfectly solves your issue and is far from difficult. Save the sheet as template and make this the default [1] - and you will never have to hide row/cols again. [1] https://help.libreoffice.org/25.2/en-US/text/shared/guide/template_manager.html (In reply to Ivan Stephen from comment #3) > So LibreOffice is only interested in power users with millions of cells in > their spreadsheets? It's the standard behavior for all spreadsheet applications. Your envisioned option to limit the number of rows/cols would do the same as hiding it manually.
I tried to do what you're suggesting, and could not make it work. So... it IS difficult, and does not solve the problem for those of us who do not need millions of cells.
(In reply to Ivan Stephen from comment #15) > I tried to do what you're suggesting, and could not make it work. Do you want to learn how to? Or do you insist in a different solution?
"Solutions" need to actually be usable, and average users should not need to jump through hoops to "solve" what should be simple. Show me how to do in a simple way. But this is an inferior "solution" for those of us who do need or want millions of cell.
Created attachment 202100 [details] Hidding Rows FWIW: Scrolling down by dragging the thumbs downward with hidden rows not working as expected', IMHO. * Thumb acts as if are 1,048,576 rows. So dragging only slightly down and you're on row 600.000 * Dragging the thumb to the bottom, and you will see a gray screen. * Scroll one tick up (from bottom), and the thumb is massively large; not matching the scrolling range But well, this is an additional/different only partially related
(In reply to Telesto from comment #18) > FWIW: Scrolling down by dragging the thumbs downward with hidden rows not > working as expected', IMHO. But it works for the horizontal scrollbar... Anyway, this is a different topic.